torndeco

Very nice easter egg :) Is there any chance of signing your pbo I think this is the main reason this addon isn't used more in multiplayer servers

Version 70 https://github.com/Torndeco/extDB2/releases/tag/70 Fixed: 9:LOCAL_TIME now returns localtime Updated: Poco Library + MySQL + Intel TBB Malloc Updated: extDB2 now build against Windows 10 SDK Known Issues: 9:DateAdd Might be off by afew +- afew minutes. Edit: Finally got around to updating the wiki with the new time / date functions https://github.com/Torndeco/extDB2/wiki/Calls:-Setup

@Patches https://github.com/Torndeco/extDB2/wiki/Calls:-Protocol-SQL_RAW The last line details the difference between SQL_RAW + SQL_RAW_V2 Yes if you switched over to SQL_CUSTOM_V2 & its done properly it will be faster + more secure. But its alot of work todo solo, check out https://github.com/danielstuart14/Altis-Life or goto Altis Life RPG Forums for support. Anyway goodluck

Version 68 https://github.com/Torndeco/extDB2/releases/tag/68 Updated to Visual Studio 2015 New Time & Date Functions Added, more info on github release info. I will update the wiki later today/tomorrow

Its already updated on A3L, got updated awhile ago

Version 67 https://github.com/Torndeco/extDB2/releases/tag/67 This is just an updated build of extDB2, compiled against newer versions of various libraries. The biggest change is SQLite compiled updated to 3.9.2 Updated Libraries (etc) also include Intel TBB SPDLog Boost Poco MySQL 5.7.9 Notes about Battleye Whitelisting BE Whitelisting is completely messed up imo, i really cant be bothered to get the extension whitelisted. Also BE appears to randomly block whitelisted extensions (i assume this happens when BE Master Server failes to respond in time i.e its getting DDOS Attacked). So even if it gets whitelisted, you can depend the extension will work 100%, which can be annoying for an extension used for persistence. If you really need to get extDB2 whitelisted. You can send BE an email after BE blocks extDB2, they will whitelist it (no need to send them dll or sourcecode). Or you can try randomly call the extension daily so BE Blocks it, eventually BE will automatically get whitelist the extension (believe this is still current behaviour for BE). SQF While Loop calling the extension should help speed this up

Afew more things i noticed, some buildings / objects that heights are wrong. The apartments opposite the Hospital in Cherno, are slightly under the ground. The tallest Industrial Building Cherno the sign on the roof, is located on the ground level, instead of on the roof. Think i saw another smaller sign with similar thing aswell, can't remember were :/ Was wondering any rough ETA when you plan on a new release with the sounds included. Thanks

Sorry i should have had _query = ["1:TEST:SAVE",_uid, _name] joinString ":"; Its all documented in the wiki, there are also various missions using extDB2 that you can look at. You should also look @ extDB2 logs for debug info etc There is also a console test application where you can type the commands into a window & test if they are working correctly. Before you add it to SQF Code etc

;Database Calls [Save] SQL1_1 = INSERT INTO PlayerInfo (UID, Name, BattlEyeGUID) SQL1_2 = VALUES (?, ?, ?); Number of Inputs = 3 _query = [_uid, _name, _beguid] joinString ":"; "extDB2" callExtension _query; Or better way to accomplish the same is to get extDB2 to generate the beguid from the player uid. Since there is no ingame method, unless you went through the hassle of writing that in SQF Code. Note: player names can't contain : since extDB2 uses it as a seperator character. ;Database Calls [Save] SQL1_1 = INSERT INTO PlayerInfo (UID, Name, BattlEyeGUID) SQL1_2 = VALUES (?, ?, ?); SQL1_INPUTS = 1, 2, 3-BeGUID Number of Inputs = 2 _query = [_uid, _name] joinString ":"; "extDB2" callExtension _query; joinString is better than format, since its not limited by 8k size in length. Looks to be tiny bit slower in testing, but not by any significant margin.

2:49:17 Cannot load sound 'chernarus_winter\sounds\run5.wss' The A3 Chernarus Winter is missing the sounds directory from A2 Chernarus Winter, causing it to spam client RPT. Would be great to get the sounds added back in, or remove references to them. Otherwise nice work :)

Yes Arma really should work like this, but unfortunately it doesn't. The bisign is just to check for if the files is tampered with. Infact the entire serverkey is located in the bisign files If Ryan Zombies is using the same server key to sign with for each release, then players can join a server using any mod version that is signed with the same server key. The best practice is just to make up a batch file that generates a new key each time your pbo up your files. You also add a version info the mod config.cpp & write code to end mission running an older version. But this is prone to mistakes i.e forgetting to update to config.cpp

AIATP, you need to install the hotfix for AIATP

extDB2 is not drop and replace and use arma inbuilt editor for missions etc... extDB2 is basically a customizable connector that allows arma to talk to a MySQL/MariaDB/SQLite Database. It is up to you to code an SQF Framework to use extDB2 to save/load from a database. Try look at other mods/missions that are using extDB2. Currently my recommend to look at to start with is https://github.com/MrEliasen/Supremacy-Framework http://www.exilemod.com(is alot more complicated, but prob has one of the best implementationsof extDB2 i seen so far) ----------------- Note: If you are still confused this extension is alot simpler to use i.e http://www.armaholic.com/page.php?id=26985

Yeah Exile has remote execute commands locked down. Exile has its own system / functions to call to sent network messages Look @Exile config + search for CfgNetworkMessages Where you will need to define it the message and the passed parameters datatypes

Encountered similiar issue with my friends PC. Was able to load A3Lingor on my PC, but not with friends. Same issue with locking up on Calamar Airfield Edit: If the AIATP hotfix doesn't work (not 100% sure i had the hotfix on my friends machine installed :P) But in the end i got it working by using CUPS Terrains Latest RC Build. <------ Confirmed the issue with unable to load in Calamar Airfield is due to not having AIATP HotFix Installed. Cups Terrain works aswell

extDB2 works fine with Arma2/3 Your issue is purely SQF code error Also the error you pasted is for different code that what you pasted below. It is similiar code but its not the same.

To get the mod to load / fix it Add the following to the config.cpp requiredAddons[]={"A3_Characters_F"}; Please release a hotfix that is signed, love the work so far. Keep it up :)

If the usernames are never fetched from the database, don't bother to strip them of quotations it will be fine. It only effects it when you try to call compile it. ------------- Infact there is an option i.e 1-String_Escape_Quotes That will escape the quotes from a playername, if you ever do fetch the playername from the database. Completely forgot i added that in.

Just a heads up There will be another update after Exile Release, kinda busy atm with other projects Will basically be updating afew libraries, main change will be speed increase for SQLite Databases. Linux users can just use v65 for now. Barely anything changed in v66, it was mainly just to help people diag bad custom_V2.ini files.

@mre You don't need to convert the arrays at all, just send them as is. str(_array); or format["%1", _array]; When fn_async is fetching the result it is call compiling it, so it will get converted back to an array for you. ------------------ The only thing you need to worry about is if you are saving PlayerNames, PlayerInput If a player name is: Player"Name The str command won't escape quotations for you. You can either do sqf code to turn: Player"Name -> Player""Name Or you could strip out all quotations or use toArray toString to convert the playername. But that makes it harder to read database for playernames though. ---- But there really is no nice way todo this. BIS really need to make a newer str command that escapes quotations properly :(

Just had a quick glance of your code Always nice to see someone else using extDB2 :) Small pointer, will help improve server performance mresArray.sqf mresString.sqf mresToArray.sqf These are functions life servers used to make raw SQL Statements safe, to prevent injection attacks. You only need to worry about this when using SQL_RAW. SQL_CUSTOM_V2 is using Prepared Statements, so you don't need to worry about this. Note: If you use CUSTOM_INPUTS just use the strip options to make it safe from injection attacks.

Most likely your windows 7 machine doesn't have root certificate for StartCom installed, it should be in Windows 8 & later. I don't have access to a windows 7 machine to see how to install the cert, so i am afraid thats going to up to someone else to figure out. The reason i am signing dlls is that BattlEye Whitelisting is buggy and annoying to submit dlls to get whitelisted. Also there is no way for me to submit dlls to get whitelisted now lol :)

It works fine here with no issues If you right click on dll it will tell if its digital signed or not + the version on the dll itself Also you could try disable BattlEye + do "extDB2" callExtension "9:VERSION" to check the version number aswell edit: also what windows version are you running?

BattlEye doesn't block extensions on Servers or Headless Clients. But BattlEye shouldn't be blocking v66, chances are you have an older extDB2 installed on your client machine. extDB2 v66 and later i am signing the dlls, so i don't need to request to get an extensions whitelisted

Point armaserver @ a server.cfg Linux installs can be weird, have seen it were it will startup without an server.cfg + sometimes it requires a server.cfg https://community.bistudio.com/wiki/server.cfg