torndeco

Right Poco 1.5 was a bust... causes crashes Reverted back to Poco 1.4 Github repo now has 2 branchs, stable & dev. Its pretty much self explanatory. (help avoid me trying something big again & it breaks) Anyway Linux Build Instructions @ https://github.com/Torndeco/extdb/wiki/Install-Linux---Chroot-Guide-%28WIP%29 Instructions are for setting up a 32bit chroot & to compile extdb & a link for arma3 server install instructions. I literally wrote this down, as i setup my chroot enviroment on a fresh ubuntu server install. Logging now works, if u have issues please make a issue on github & list your OS & filesystem thanks. Also afew Atlis Life RPG servers have beening trying out extDB With very encouraging reports of performance over Arma2MySQL for Atlis Life. http://www.altisliferpg.com/topic/3689-extdb-support-separate-build/

Uploading new version to Github atm. Changes Now Using Poco 1.5 (old version == poco 1.4, incase there is any issues) DB_RAW supports Procedures & possible functions haven't tested yet . Logging Added (no config option yet, will add later today) Todo / wish list for Tomorrow Add config option for logging Finish DB_PROCEDURE (this way u can call Procedures without enable DB_RAW). Plus it will be less calls to extension Type up Tutorial to Build Extension in 32bit schroot for Ubuntu Server. Questions Be interested to know if times for db access are still similar with new build, if anyone got time to check. Anyone know if Procedure Output Values are local to database session or am i just going insane. Notes Old version is the previous version Poco 1.4, just incase there any issues.

New version with fixed RAW SQL for multiple row return. Also enabled auto-reconnect for MYSQL (don't believe ODBC supports it, could be wrong) Small Update + Question Will be changing over to Poco 1.5 for database access. (Currently using 1.4) No issues encountered & minimal change in code i.e already done locally :) This way can add in support for SQL functions + procedure support, and access to MySQL handle. Anyone used Procedures / Functions before for Arma, whats roughly the most arguments used ? Will be a hardcoded upper limit, until i can find a better way todo it

As for Documentation yeah it sucks alot atm. I need to write a basic quick-start tutorial with basic sqf commands. Hopefully i get time to-do it tomorrow. ------------------- ------------------- Anyway simple guide, hope this clears up some confusion Basicly @ mission. Before u do anything u have to initialize extdb extension. 9:DATABASE:Database2 // This causes it load Database2 Settings in the config file, if u skip this. // It will crash if it attempts any database access later. 9:ADD:DB_RAW:fucktorndeco // This loads DB_RAW Module & Names it fucktorndeco // Originally i was coding plugins, but left some code in. // This way u could try and randomize the Module Names @ startup. If u are paranoid 9:LOCK // This is paranoid option, prevents loading any more options or getting extdb version info etc. // Basicly it disables all 9: System Calls (there is no unlock option) <INSERT REST OF YOUR MISSION SQF CODE> Now since extdb is setup & loaded your database options & modules u wanted. U can call 0:fucktorndeco:SELECT * FROM tablename // Note the fucktorndeco name, since we named it that above. // It only supports multiple connections to single database atm. // I can look @ coding support for connecting to multiple databases if needed. ---------- Post added at 20:09 ---------- Previous post was at 19:53 ---------- @ xyberviri Am using Poco for Database access. Currently using the stable 1.4 Poco it doesn't support procedures. But the dev branch does support procedures. Already looked @ 1.5 changes... should require zero changes to use it. Tomorrow i will look @ coding support for procedures. Basicly i will just compile 2 versions of extdb, (same codebase just add #ifdef #endif etc) One version using Poco 1.5 with procedure support. One version using Poco 1.4 without procedure support. I will look @ it tomorrow, like to avoid using dev version if i can ;) Worst case i might just have 2 versions of extdb compiled against poco, one with procedure + one without. @ everyone else New version on github, fixed mysql / odbc database connection.

Inidbi is a windows extension... (thats the .dll part in the filename) U would need to port over the code & compile it as 32bit to run on arma3server for linux Source code @ https://github.com/code34/-inidbi/tree/master/sources Or u could make your own extension from scratch. Look @ https://community.bistudio.com/wiki/Extensions && http://killzonekid.com/arma-scripting-tutorials-how-to-make-arma-extension-part-1/ ---------- I am working on an extension (linux + windows version) with database support + few other things... Its not finished yet, should have a test version this weekend. But it would require editing your mission code, as its not a drop-in replacement.

Pretty sure max for linux is still 2047 i.e -maxmem=2047 note: people were trying higher values... sometimes the server would startup with higher fps but it had errors i.e server was broken etc...

I assume u are wondering about your linux setup ? Linux Server is installed via steamcmd This is only run when installing steam apps or updating them. The server is launched directly, so u don't need to worry about any steam client updates. Basicly if there is an update, u stop your server. Launch steamcmd + update the serverfiles + restart your server. -------------- Basicly u only need steam account to install + update server files. U dont need steam running to launch the server (this goes for windows + linux servers etc)

Version 1.1 has all the keys signed correctly. U can download version 1.1 via sixupdater or torrent for version 1 + patch it. Was gonna be a hotfix release last weekend, never happened :(

One of the keys isn't signed correctly for v1.2 so they aren't any use... If u to use server keys, u need to download v1.1 or pray that we get a hotfix or a new version soon

Encountering this aswell... Anyone able to confirm they have addon working on a server with verify signatures = 2 ? Thx

Basicly its a Python app that parses battleye logs + bans users based on filter settings. ( note the rcon commands are handled by a launching a small c# app (source code included), no python code for rcon yet ) While the app was made up for dayz mod, its completely generic and can be basicly used for arma2 oa in general... U just need to make up custom filters for which mod u are using... There are basicly Whitelisted / Kicklisted / Banlisted Filters, plus spam filters, all with python's regrex features. More info @ github.com Torndeco pyBEscanner Note some info... Kicking - Is still work in progress... 90% code of the code is done. Default filters are made for dayz mod in mind... Also doesn't have ability to detect when server changes missions (i.e player voting for new mission), to switch to different filters ------------------------------------------ ------------------------------------------ Though i make a post here, while i was checking for info on latest battleye filters for dayz i.e in regards to !="foo" anyone know the different between above and !"foo" ?

@Stuffy U are a saviour, had given up trying to wrap my head around working out the checksums for BE packets