sandbird

I've been trying to get this to work on win 10 64bit with no success..It was working fine on win8 x64...i dont know why it is giving me such hard time. In the /arma2oa/logs i get this error: Info: 11:49:16 - Type: mysql Database: dayz IPAddress: 127.0.0.1 Port: 3306 Username: dayz Password: NotShownForSecurityReasons Info: 11:49:16 - Unable to open connection to MySQL database, trying again in 10 seconds.MySql.Data.MySqlClient.MySqlException (0x80004005): The host 127.0.0.1 does not support SSL connections. at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at Arma2NETMySQLPlugin.MySQL.OpenConnection(String connectionString) (Notice the SSL connection error oO) But in the Arma2Net log file i get this: 10/15/2018 11:49:16 Arma2NET 2.3.0.0 running on CLR 4.0.30319.42000 10/15/2018 11:49:16 Loaded into process ArmA2OA 10/15/2018 11:49:16 Loading add-ins 10/15/2018 11:49:16 Caught exception of type System.Reflection.TargetInvocationException while loading add-in DefaultDomain 10/15/2018 11:49:16 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileLoadException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.89.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) ---> System.IO.FileLoadException: Attempt to load an unverifiable executable with fixups (IAT with more than 2 sections or a TLS section.) (Exception from HRESULT: 0x80131019) --- End of inner exception stack trace --- at System.Reflection.RuntimeAssembly.nLoadImage(Byte[] rawAssembly, Byte[] rawSymbolStore, Evidence evidence, StackCrawlMark& stackMark, Boolean fIntrospection, Boolean fSkipIntegrityCheck, SecurityContextSource securityContextSource) at System.Reflection.Assembly.Load(Byte[] rawAssembly) at Arma2Net.Managed.AddInManager.DomainLoadAddIn(String assemblyFile) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at Arma2Net.Managed.AddInManager.DomainDoCallback() at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate) at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg) at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg) at Arma2Net.Managed.AddInManager.LoadAddIn(String assemblyFile) All the necessary dependencies are installed. I can connect fine with the Arma2NetExplorer. That works...Only doing it inside the game crashes the client. Anyone got any ideas ? -Thanks

European Operations Forces is the first professional European Milsim team for Arma 3. That means that all important positions are with monthly salary. We are looking for staff, blog/article authors, admins, designers, server admins and mission makers, as well as Operation Officers, Commanders and Train Instructors. Our Website and Forum will be custom built and not a ready template, and will be ready in 4 weeks. So European Operation Forces is asking for experienced players in Arma 3 with more than 1000 hours in game, both in Cooop and PvP missions in order to undertake the job of Team Captains, Leaders, etc. These men will command a team in Operations but also train other soldiers as well. We are looking for: Infantry Division Commander with good knowledge in all infantry movements and tactics. Special Forces Division Commander with good knowledge in Diving, parachute etc. Air Division Commander. Armored Division. We are also looking for : Mission Makers Servers Admins All with monthly salary, Please send CV with full details in hq@eurof-team.org P.S: Please don't send us your applications or messages here at the forum. Use the email provided. Thank you

Hi, I am looking for a hosting company (dedicated or not) for a vanilla Arma3 server for 100-120 slots. This server will be used for a massive clan, with members from all over Europe, so a centralized server would be preferable (France, Germany etc). I've had a dedicated server before, running Dayz Epoch, with balticservers.com, but although the machine was a Xeon, there was some 'rubbering' ingame so i am having some seconds thoughts about dedicated servers. I have no idea how the server specs have changed during this last year that i went MIA from Arma, so i guess i am wondering if its worth the trouble to even bother with a full dedicated server instead of a web-panel based one. Any input would be highly appreciated.

I think this machine would do fine for my purpose : https://www.ovh.com/us/dedicated-servers/details-servers-range-GAME-id-MC-64-OC.xml What do you guys think ? The anti-ddos protection is something that i didnt think of before, so i guess a setup like this would be preferable right?

Thanks, thats what i noticed as well..They are cheaper now. Probably to promote them. Cool. Thanks so much for your answer.

Hi Tankbuster, Did you have a Skylake or Haswell (does it mater ?) I know Skylake is supposed to be better....i just want your opinion in case you had Haswell. -thanks

So basically something like this will do ? : https://www.hetzner.de/en/hosting/produkte_rootserver/px91ssd or go higher ? Do you think this machine will be able to run 2 servers (120 & 64 slots) ? My previous dedi box was an i7 4600. Cant say i was satisfied. (With optimized mysql server, power options on high, and unparked heads)

I have a dialog box in which i am showing an .html page like this: class hlp_html: RscHTML_Help { idc = 1100; filename = "custom\rules\help.html"; text = ""; x = 0.164376 * safezoneW + safezoneX; y = 0.348684 * safezoneH + safezoneY; w = 0.677395 * safezoneW; h = 0.478422 * safezoneH; }; While i am showing the text i also want to show an image like a normal html file could do. For example, is this possible ?: <h2><a name="Rules"></a></h2> <h2><a href="#Main">BACK</a></h2> <br> <h3>General Rules:</strong></h3><br> <p>-<b>NO</b> voice in sidechat!</p> <p><img image="images\noside.paa" /></p> of course the above doesnt work... Is there a way i can add a picture inside as well? -Thanks

not the latest latest...one before that...does it matter?

nope it doesnt....it loads but nothing happens...testing many many times...i even did with less seconds...it never works.

yeah i tried without <p> tags...basically tried any combination possible...i dont think its possible. But why does the wiki say pictures as well.

Can someone please show me how to properly set up Connectionlimiter ? It loads but doesnt do anything to the server. Using it in a Dayz Epoch server..and here is my settings file: # 5 con in 10 sec locks 120 sec DEFAULT = [2, 120, 5] # custom setting, only used with multiple config files CONFIG = {} # restrict the plugin for/to specific server(s) # leave empty to allow on any config file SERVERS = [] 12:01:58 : Starting plugin : ConnectionLimiter V.0.2 12:01:58 : Checking for new Bec version... 12:02:02 : New Bec update available : Version 1.606 -> http://www.ibattle.org 12:02:02 : Connecting to Battleye server xxxxx:xxxx 12:02:02 : Scheduling 67 tasks 12:02:02 : RCon admin #4 (xxxxxxxx) logged in but it doesnt lock the server down.

yeah i've seen that page but doesnt show how to use the img tag inside the CT_HTML. No errors no nothing :/

yeah i kinda thought that would work :) just thought there might be a switch or something to turn logging off....cause i am using arma2netmysql with it and it creates logs based on date and time...i'd have to make the whole folder readonly.

Arma2NET 2.3

is there a way i can disable logging ? I think that since i am using normal HD and not SSDs, the process of streaming 10k objects would be faster if it doesnt write in the log file. -thanks

I am trying to do absolute coordinates for objects in the database, because things tend to move on server restart. I have this: [336.253,"[6028.168945,1444.422974,0.370625]"] and i want to convert it to this: [336.253,[6028.168945,1444.422974,0.370625]] The problem is that i cant call compile that string, cause it will remove the extra decimal numbers from the coordinates, which of course i dont want :/ Any ideas please ? -Thanks

Well, i am trying to do this: http://killzonekid.com/arma-scripting-tutorials-float-to-string-position-to-string/ Basically hold extra numbers for precision in the coordinates system....But i keep ending up with quotes around the final result. And i dont understand why call compiling it trims them. I first Select the coordinates from the database, and select the 2nd part of the array (not the direction value). I use the trick to get the extra decimal points and when i import it back....it has quotes. Call compiling it first removes the extra decimal points which i need :/

The double quotes problem...i fixed it with thousand call compiles and str() tricks :P For the second (and biggest problem with the 'skips') I never thought that multiple SQLs might be doing this....You are probably right. If a player connects while the server is streaming data....it would try to load his character also from the database. I really wish i could find a working example of async calls....but i cant find any :/ I understand what the concept does, i just dont know how to implement it. The example in : http://arma2netmysqlplugin.readthedocs.org/en/latest/#using-the-plugin isnt very helpful about what happens 'after' the call. -Thanks again for your answer

Anyone knows why i've been getting errors like this one ? 11/09/2014 13:26:29 function: Arma2NETMySQLCommand ['dayz_epoch',"UPDATE object_data SET Hitpoints = '[]', Damage = '0' WHERE ObjectID = '6467'"] 11/09/2014 13:26:29 maxResultSize: 10239 11/09/2014 13:26:29 Result size: 4 11/09/2014 13:26:29 Result: [[]] 11/09/2014 13:26:32 Caught exception of type System.Reflection.TargetInvocationException 11/09/2014 13:26:32 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Value does not fall within the expected range. at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize) at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at Arma2Net.Managed.AddInManager.DomainDoCallback() at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate) at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg) at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg) at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize) at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize) at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize) or 11/09/2014 13:26:56 function: Arma2NETMySQLCommand ['dayz_epoch','SELECT Worldspace from object_data where ObjectUID = ''6048414236097'''] 11/09/2014 13:26:56 maxResultSize: 10239 11/09/2014 13:26:56 Result size: 66 11/09/2014 13:26:56 Result: [[["[325,[6047.64,1427.83,0.00263214],""0,1,0,1"",""1,0,0,1""]"]]] 11/09/2014 13:26:56 Caught exception of type System.Reflection.TargetInvocationException 11/09/2014 13:26:56 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Value does not fall within the expected range. at Arma2NETMySQLPlugin.Arma2NETMySQLPluginCommand.Invoke(String args, Int32 maxResultSize) at Arma2Net.Managed.AddInManager.DomainInvokeAddIn(AddInArguments args) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Delegate.DynamicInvokeImpl(Object[] args) at Arma2Net.Managed.AddInManager.DomainDoCallback() at System.AppDomain.DoCallBack(CrossAppDomainDelegate callBackDelegate) at Arma2Net.Managed.AddInManager.DoCallbackImpl(AppDomain domain, Delegate func, Object arg) at Arma2Net.Managed.AddInManager.DoCallbackWithResult[T,TResult](AppDomain domain, Func`2 func, T arg) at Arma2Net.Managed.AddInManager.InvokeAddIn(String addInName, String arguments, Int32 maxResultSize) at Arma2Net.Managed.Bridge.InvokeBuiltInOrAddIn(String function, Int32 maxResultSize) at Arma2Net.Managed.Bridge.InvokeFunction(String function, Int32 maxResultSize) Ok on the 2nd example i know its the double quotes are pissing it off....but how can i retrieve data then when i need to have double quotes in the db cell ? I've tried: _sql = "Arma2Net.Unmanaged" callExtension format["Arma2NETMySQLCommand ['dayz_epoch','SELECT Worldspace from object_data where ObjectUID = ''%1''']",_pid]; _result = call compile _sql; and _sql = format["SELECT Worldspace from object_data where ObjectUID = '%1'", _pid]; _qresult = _sql call myserver_hiveReadWrite; _qselect = _qresult select 0 select 0 select 0; where myserver_hiveReadWrite is myserver_hiveReadWrite = { private["_mykey","_qres","_mydata"]; _mykey = _this; _mydata = format["Arma2NETMySQLCommand ['dayz_epoch",""%1""]",_mykey]; SQL_RESULT = "Arma2Net.Unmanaged" callExtension _mydata; _qres = call compile format ["%1",SQL_RESULT]; _qres }; Also on another note...I notice something weird....When i have tons of entries in my db and i parse them one by one so i can spawn them on the map, sometimes some objects are getting skipped. Although in the logs the SQL query was executed fine. For example for "_i" from 0 to (_objectCount) do { if (_i != _objectCount) then { _keyvg = format["SELECT `ObjectID`, `ObjectUID`, `Classname`, `CharacterID`, `Worldspace`, `Inventory`, `Hitpoints`, `Fuel`, `Damage` FROM object_data WHERE `Instance`='%1' AND `Classname` IS NOT NULL LIMIT %2,1",dayZ_instance, _i]; _data2 = _keyvg call myserver_hiveReadWriteLarge; _response = _data2 select 0 select 0; if ((_response select 2) isKindOf "ModularItems") then { _BuildingQueue set [_bQty,_response]; _bQty = _bQty + 1; } else { _objectQueue set [_vQty,_response]; _vQty = _vQty + 1; }; }; sleep 0.0001; //////////// }; This function checks whether the row has a vehicle or a building, and add it to the proper array. Notice the sleep in the end ? If i dont put that there....It might skip some objects. Not that the sleep saves the days....But it helps.... For example....here is the diag_log entry, while streaming objects: ">>>HIVE ["5959","60382140201447","OutHouse_DZ","76561198017478031","[292.742,[6038.19,1402,-0.143723],[[-0.922254,0.386585,0],[0,0,1]]]","[[[],[]],[[],[]],[[],[]]]","[]","0","0"] OutHouse_DZ" ">>>HIVE ["6127","6039314122016","Plastic_Pole_EP1_DZ","76561198017478031","[171.11,[6039.29,1412.18,0],[[0.154541,-0.987986,0],[0,0,1]]]","[]","[]","0","0"] Plastic_Pole_EP1_DZ" ">>>HIVE ["6131","60275140882220","CinderWallHalf_DZ","76561198017478031","[40.4377,[6027.52,1408.78,-0.0235214],[[0.648621,0.761111,0],[0.538187,-0.458644,0.707107]]]","[]","[]","0","0"] CinderWallHalf_DZ" ">>>HIVE ["6173","60351141250123","CinderWall_DZ","76561198017478031","[227.203,[6035.05,1412.53,0.0175705],[[-0.733765,-0.679404,0],[0,0,1]]]","[]","[]","0","0"] CinderWall_DZ" ">>>HIVE <null> any" Error in expression <t 0; diag_log (format[">>>HIVE %1 %2", _response, (_response select 2)]); if ((> Error position: <_response, (_response select 2)]); if ((> Error Undefined variable in expression: _response ">>>HIVE ["6333","60353141733319","Land_psi_bouda","76561198017478031","[318.667,[6035.35,1417.31,0.301598]]","[]","[]","3","0"] Land_psi_bouda" ">>>HIVE ["6366","60349142362300","Land_MBG_Garage_Single_D","76561198017478031","[300.118,[6034.88,1423.57,0.201233]]","[]","[]","0","0"] Land_MBG_Garage_Single_D" ">>>HIVE ["6367","6048514236271","HeliH","76561198017478031","[71.1653,[6048.46,1423.59,0.219681]]","[]","[]","0","0"] HeliH" See that null there ? If i restart the server, it will grab it correctly though....It might skip something else. Its as if the query is slower than then loop or something, which is weird since this is on a XEON machine, with 32GB ram, and the standard professional mysql server (no xampp and crap like that). Any input would be really appreciated. -Thanks

This mod is attached on Overwatch map mod. Is there any way i can overwrite the scripts the raven uses...without touching the map files of course. I need to replace all but the green marker to local markers. Basically replace all createmarker to createmarkerlocal (besides the green one), so that the rest of the players cant pinpoint where the player is. -Thanks

After all that do _playerLostsResult = _playerLostsResult select 0 select 0 select 0;

yeah the deletion works. So you think the deletion 'delays' for some reason, so the query doesnt get executed huh...hmm good idea. Update is a bit risky. The deletion probably is the key here....Cause things marked for deletion probably do other stuff as well. I have to check it out first before i resort to ignoring it. Yeah, the diag_logs are unique..i know that the file is getting executed thats a 100%, and its called when it has to as well. I was wondering, is there a way (with my current vgserver_hiveWrite) to a loop for x times of executing the sql until i get a result back or something ? The original hive.dll can get a result on queries....If its a PASS then continue...else try again for X times. How easy is it to do the same with arma2net ? Thanks again for 'unstucking' me firefly :)

I am using Arma2Net on a dayz Overpoch server. So far everything was working fine...or so i thought it was actually. I am using it to publish buildings that players build, and also to upgrade them. The publish function (the 1st insert of the object in the db) works fine...but the upgrade one doesnt....and although its basically the same command, and i see the mysql entry in the logs...its not getting executed. My main function is : vgserver_hiveWrite = { private["_mykey","_mydata"]; _mykey = _this; _mydata = format["Arma2NETMySQLCommand ['dayzdb',""%1""]",_mykey]; SQL_RESULT = "Arma2Net.Unmanaged" callExtension _mydata; }; and i use this like this: server_publishVehicle.sqf _key = format["insert into object_data (ObjectUID, Instance, Classname, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Damage, Datestamp) values ('%1','%2','%3','%4','%5','%6','%7','%8','%9', CURRENT_TIMESTAMP)",_uid,dayZ_instance,_class,_characterID,_worldspace,'[]',_array,_fuel,_damage]; //diag_log ("HIVE: WRITE: "+ str(_key)); _key call vgserver_hiveWrite; This works fine...it inserts the object in the db 100% of the time. The arma2net log shows it: 10/17/2014 14:42:14 function: Arma2NETMySQLCommand ['dayzdb',"insert into object_data (ObjectUID, Instance, Classname, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Damage, Datestamp) values ('60326137931352','13','CinderWallHalf_DZ','11111111111111111','[352.22,[6032.56,1379.29,-0.00756836]]','[]','[]','0','0',CURRENT_TIMESTAMP)"] 10/17/2014 14:42:14 maxResultSize: 10239 10/17/2014 14:42:14 Result size: 4 10/17/2014 14:42:14 Result: [[]] Now if a player upgrades an object server_swapObject.sqf is called. That file basically grabs the requested object's details from a publicvariable, deletes the object in question, writes the upgraded entry in the database and spawns the new object in game. For example object 'CinderWallHalf_DZ' is upgraded to 'CinderWall_DZ' (....hence the 1st object deletion) But in this file...although the insert sql is similar server_swapObject.sqf _keySwap = format["insert into object_data (ObjectUID, Instance, Classname, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Damage, Datestamp) values ('%1','%2','%3','%4','%5','%6','%7','%8','%9', CURRENT_TIMESTAMP)",_uid,dayZ_instance,_class,_charID,_worldspace,'[]','[]',0,0]; //diag_log ("HIVE: WRITE Server SWAP_OBJECT: "+ str(_keySwap)); _keySwap call vgserver_hiveWrite; and i can see it in the arma2netmysql log file: 10/17/2014 14:43:34 function: Arma2NETMySQLCommand ['dayzdb',"insert into object_data (ObjectUID, Instance, Classname, CharacterID, Worldspace, Inventory, Hitpoints, Fuel, Damage, Datestamp) values ('60326137931352','13','CinderWall_DZ','11111111111111111','[352.22,[6032.56,1379.29,-0.00756836]]','[]','[]','0','0', CURRENT_TIMESTAMP)"] 10/17/2014 14:43:34 maxResultSize: 10239 10/17/2014 14:43:34 Result size: 4 10/17/2014 14:43:34 Result: [[]] it does NOT get executed in the db. If i copy/paste the above query in phpmyadmin and execute it...it imports just fine. So its not a problem of bad syntax or something. It just doesnt execute...and i dont know why !? Should i put a sleep somewhere or something ? Why do i see it in the arma2net log ? That means it executed right ? (1st file, works fine) server_publishVehicle.sqf: http://pastebin.com/ikQrTNZp (2nd file, not w/fine) server_swapObject.sqf : http://pastebin.com/YrSMeywJ Any ideas? -Thanks

Is it possible to do this in 3d editor ? if !(isNull (findDisplay 46)) then {...}; Because i am trying to do it there and its not working. I want to write a script and want the player to use some keys for controlling a camera, but i realized that the keys were not working and ended up finding the bug to this if.... Does 3d editor allow button interaction like MP does ? -Thanks