Jump to content
Bohemia Interactive Forums

Charles Darwin

Member
 View Profile  See their activity

  • Content Count

    133

  • Joined

  • Last visited

  • Medals

Posts posted by Charles Darwin

  1. Posted · Edited by Charles Darwin

    create a mission and place a game logic on the map named "LHD_Center" then place an object on the right elevator you want to control the up down motion I used a folding table..name this control

    in the init of control place this:

    this setposASL [getposASL this select 0, getposASL this select 1, 15.3]; this enableSimulation False;

    then place these files into your mission folder

    init.sqf

    Creates the LHD and names the elevator as elev also adds action to the object that will control the elevator

    if (isServer) then {
_LHDspawnpoint = [getPosASL LHD_Center select 0, getPosASL LHD_Center select 1, -.43];
{
	_dummy = createVehicle [_x, _LHDspawnpoint, [], 0, "NONE"];
	_dummy setdir (getdir LHD_center);
	_dummy setPos _LHDspawnpoint;
} foreach ["Land_LHD_house_1","Land_LHD_house_2","Land_LHD_1","Land_LHD_2","Land_LHD_3","Land_LHD_4","Land_LHD_5","Land_LHD_6"];
elev = createvehicle ["Land_LHD_elev_R", _LHDspawnpoint, [], 0, "NONE"];
elev setdir (getdir LHD_center);
elev setPos _LHDspawnpoint;
};

act = control addAction ["Lower Elevator", "elevdown.sqf",elev,7,TRUE];
sleep 5;

    elevdown.sqf

    sends the elevator down to 2 meters below waterline..this allows LAV to get onboard

    _object = _this select 0;
_obx = (getposasl _object select 0);
_oby = (getposasl _object select 1);
_caller = _this select 1;
_id = _this select 2;
_elev = _this select 3;

if (isServer) then 
{
_object removeaction _id;
_height = (getposASL _elev select 2);
while {_height > -17}
	do {
 _elev setposASL [getposasl _elev select 0, getposASL _elev select 1, ((getposasl _elev select 2) -.015)];
//	 _object setposASL [_obx, _oby, ((getposasl _object select 2) -.015)];
 _height = (getposASL _elev select 2);
 sleep .01;
};
act = _object addAction ["Raise Elevator", "elevup.sqf",elev,7,TRUE];
};

    elevup.sqf

    _object = _this select 0;
_obx = (getposasl _object select 0);
_oby = (getposasl _object select 1);
_caller = _this select 1;
_id = _this select 2;
_elev = _this select 3;

if (isServer) then 
{

_object removeaction _id;
_height = (getposASL _elev select 2);
while {_height < -.3548}
	do {
 _elev setposASL [getposasl _elev select 0, getposASL _elev select 1, ((getposasl _elev select 2) +.015)];
//	  _object setposASL [_obx, _oby, ((getposasl _object select 2) +.015)];
 _height = (getposASL _elev select 2);
 sleep .01;
};
act = control addAction ["Lower Elevator", "elevdown.sqf",elev,7,TRUE];
};

    any questions just ask! :)

    right now this only works when vehicles have a player in them..I will work on correcting this but for now just consider as a way to help encourage teamwork :)

  3. Posted

    Hmmm, not sure if the gun is limited to burst in real life. something may have changed from the A-10A model which is what the a-10 in arma is to the A-10C in DCS A-10C, but the DCS title which (i assume) models the gun operation on the real A-10C has no burst mode it is a purely trigger down = gun firing/ trigger up = not firing system. I posted the question an A-10 forum and will have to see what the guys who flew the A variant say about it. if it's realistic to have only a burst feature then theres no point in changing it.

  20. Posted

    WOOOHOOO!!! got it working..Ill get to writing that quick start guide tomorrow..do you want me to post it here or do you want to look it over first? Don't want to put something out there that might be confused as having your guy's approval especially since I'm not nearly as good at this stuff as you, I'm just excited to get more attention for this project as I see what it can do!

  21. Posted · Edited by Charles Darwin

    DOH! I can't beleive I didn't see that LOL thanks * shy's away for being stupid*

    kolmain..in order to get the git files I had to use the gitbash and this link: https://USERNAME:PASSWORD@git.dev-heaven.net/a2-sql-persistent-db.git

    Jman: ok ran your arma.sql file into a new DB and created the needed tables etc and the ArmA2MySQL program is running and connected to the DB..load the mission named pipe is opened and get:

    Info: 15:29:36 - Arma2MySQL Server Started.
Info: 15:29:36 - Database: arma IPAddress: localhost Port: 3306 Username: root Password: NotShownForSecurityReasons
Info: 15:29:36 - Started listening to pipe.
Info: 15:34:14 - Named pipe opened.
Info: 15:34:15 - Received message: arma:GetMissionByName(tna=Co30 ACE KH PDB Battlefields)
Warning: 15:34:15 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Procedure or function '`GetMissionByName`' cannot be found in database '`arma`'.
  at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey)
  at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName, DataTable& proceduresTable, DataTable& parametersTable)
  at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
  at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
  at Arma2SQL.MySQLProvider.MySQLProvider.<RunProcedure>d__0.MoveNext()
Info: 15:34:15 - Trying to write: arma:GetMissionByName(tna=Co30 ACE KH PDB Battlefields)false;
Info: 15:34:15 - Named pipe closed.
Info: 15:34:37 - Named pipe opened.
Info: 15:34:37 - Received message: arma:UpdatePlayer(tsc=0,tpos=2194.36|9603.84|245.678,tdam=0,tdhe=0,tdbo=0,tdha=0,tdle=0,tdir=337.231,tsta=Stand,tsid=,tveh=,tsea=,tpid=2335878,tna=|TG-IrrP|Charles Darwin,tmid=<null>)
Warning: 15:34:37 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Procedure or function '`UpdatePlayer`' cannot be found in database '`arma`'.
  at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey)
  at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName, DataTable& proceduresTable, DataTable& parametersTable)
  at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
  at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
  at Arma2SQL.MySQLProvider.MySQLProvider.<RunProcedure>d__0.MoveNext()
Info: 15:34:37 - Trying to write: arma:UpdatePlayer(tsc=0,tpos=2194.36|9603.84|245.678,tdam=0,tdhe=0,tdbo=0,tdha=0,tdle=0,tdir=337.231,tsta=Stand,tsid=,tveh=,tsea=,tpid=2335878,tna=|TG-IrrP|Charles Darwin,tmid=<null>)false;
Info: 15:34:37 - Received message: arma:UpdatePlayerWeapons(twea="AKS_74_U"|"Binocular"|"ItemCompass"|"ItemWatch"|"ACE_Map"|"ACRE_PRC343_ID_1",tmag="30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"HandGrenade_East"|"HandGrenade_East"|"SmokeShell"|"SmokeShell"|"ACE_Bandage"|"ACE_Bandage",tpid=2335878,tna=|TG-IrrP|Charles Darwin,tmid=<null>)
Warning: 15:34:37 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Procedure or function '`UpdatePlayerWeapons`' cannot be found in database '`arma`'.
  at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey)
  at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName, DataTable& proceduresTable, DataTable& parametersTable)
  at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
  at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
  at Arma2SQL.MySQLProvider.MySQLProvider.<RunProcedure>d__0.MoveNext()
Info: 15:34:37 - Trying to write: arma:UpdatePlayerWeapons(twea="AKS_74_U"|"Binocular"|"ItemCompass"|"ItemWatch"|"ACE_Map"|"ACRE_PRC343_ID_1",tmag="30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"30Rnd_545x39_AK"|"HandGrenade_East"|"HandGrenade_East"|"SmokeShell"|"SmokeShell"|"ACE_Bandage"|"ACE_Bandage",tpid=2335878,tna=|TG-IrrP|Charles Darwin,tmid=<null>)false;
Info: 15:34:37 - Received message: arma:UpdatePlayerACE(tawb=,taw=,tarm=,tpid=2335878,tna=|TG-IrrP|Charles Darwin,tmid=<null>)
Warning: 15:34:37 - MySQL error. MySql.Data.MySqlClient.MySqlException (0x80004005): Procedure or function '`UpdatePlayerACE`' cannot be found in database '`arma`'.
  at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
  at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey)
  at MySql.Data.MySqlClient.StoredProcedure.GetParameters(String procName, DataTable& proceduresTable, DataTable& parametersTable)
  at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
  at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
  at Arma2SQL.MySQLProvider.MySQLProvider.<RunProcedure>d__0.MoveNext()
Info: 15:34:37 - Trying to write: arma:UpdatePlayerACE(tawb=,taw=,tarm=,tpid=2335878,tna=|TG-IrrP|Charles Darwin,tmid=<null>)false;
Info: 15:34:37 - Named pipe closed.

    Im guessing there are SQL procedures needed in the DB that arent in that file?:confused: seems like everything is in there based on whats in the SQF files and my limited knowledge of SQL but Im so confused by all of this I have no real clue lol

    On the bright side...were at least connected now lol!

  22. Posted

    Hmmm.. Im sure this is because I have not fully grasped the concept the MySQL database program yet but this is the error I get with the new files

    Info: 12:56:57 - Arma2MySQL Server Started.
Info: 12:56:57 - Started listening to pipe.
Info: 13:01:38 - Named pipe opened.
Info: 13:01:40 - Received message: arma:GetMissionByName(tna=Co30 ACE KH PDB Battlefields)
Error: 13:01:40 - ERROR: The database name passed through to the application doesn't match any in the Databases.txt file.
Info: 13:02:23 - Named pipe closed.

    the database.txt

    # Put each database connection you want on a separate line
# For an example, see the following
#databasename,ipaddress,port,username,password
#
#MySQL55,"localhost",3306,root,pass

    and the rpt:

    [6431,223.461,0,"XEH: PreInit Started. v3.3.3. MISSINIT: missionName=Co30_ACE_KH_PDB_Batfields_2_12, worldName=Chernarus, isMultiplayer=true, isServer=false, isDedicated=false"]
[6431,234.616,0,"XEH: PreInit Finished. CACHE DISABLED? (Disable caching with cba_disable_cache.pbo): SLX_XEH_RECOMPILE=false, CBA_COMPILE_RECOMPILE=false, CBA_FUNC_RECOMPILE=false"]
"JayArmA2Lib: ACTIVE"
[6431,230.673,0,"x\ace\addons\sys_wounds\XEH_preInit.sqf:8","WARNING: Enhanced Armor difficulty options enabled - this is not recommended in conjunction with ACE Wounds!"]
[6457,251.961,0,"XEH: PostInit Started"]
[6457,252.019,0,"CBA_VERSIONING: cba=0.8.3.175, ace=1.13.0.522, acex=1.13.0.353, acex_ru=1.13.0.64, acex_usnavy=1.13.0.67, "]
[6457,258.152,0,"XEH: PostInit Finished. State: _isClient=true, _isJip=false, _isDedClient=true, _isServer=false, _isDedServer=false, _playerCheckDone=true, _sp=false, _startInitDone=true, _postInitDone=true, _mpRespawn=true, _machineType=2, _sessionId=2, BIS_functions=L 1-1-I:1 REMOTE, group=L 1-1-I, player=R 1-1-A:1 (|TG-IrrP|Charles Darwin), _playerType="GUE_Soldier_CO", _playerGroup=R 1-1-A"]
["PersistentDB: pdb settings loaded"]
"############################# Co30 ACE KH PDB Battlefields #############################"
[6479,259.694,0,"CBA_VERSIONING_SERVER: cba=0.8.3.175, ace=1.13.0.522, acex=1.13.0.353, acex_ru=1.13.0.64, acex_usnavy=1.13.0.67, "]
["dynamic_weatherSync.sqf: Running"]
["dynamic_weatherSync.sqf: Syncing"]
["dynamic_weatherSync.sqf: updating setOvercast:",0.566492]
Client: Object 2:860 (type Type_149) not found.
["PersistentDB: SPAWN"]
Client: Object 2:863 (type Type_70) not found.
Client: Object 2:863 (type Type_72) not found.
["PersistentDB: PDB_FNC_SERVER_LOADERSTATUS: ","Mission: Co30 ACE KH PDB Battlefields"]
Client: Object 2:864 (type Type_70) not found.
Client: Object 2:864 (type Type_94) not found.
["PersistentDB: FINISHED MISSION INIT, time: ",4.706]

    thanks again for all the help I feel like I am being a pain in the but but I hope I can repay eventually :bounce3:

  25. Posted

    awesome, this is a really awesome tool you guys are working on, I wish I knew more about programming to be able to help, but like I said as soon as I figure out how to use it, Ill put up a quick start guide:D

    git bash connection is still being hung up i assume that mean the read only is still not working

×