ArmA2 Persistent Database Scripts - WIP

[[KH]Jman]

UPDATE: 7th Feburary 2013



There are many issues and bugs in the current PDB standalone version. Development of the standalone PDB scripts has ceased and I have moved development be to exclusively for MSO where PDB development has really moved on massively in MSO 4.6. Myself and the MSO dev team will also be working on a new MSO PDB version for Arma3 when it's released which will be in addon form.

I am no longer offering support for this old standalone version of PDB.

You can get support for the new PDB integrated into MSO on our dev-heaven site here
MSO support is here and here

The latest development files can be found here


UPDATE: 22nd June 2012



Over the last month or so I have been working on a set of scripts that can be integrated into any ArmA2 missions that will allow for persistent player and game/mission data to be stored in a serverside database and retrieved on command.

No clientside addons are required and it is compatible with Windows dedicated servers. All that is required is that both CBA and Arma2NET addons be loaded serverside together with a MYSQL database. This only works on dedicated servers. There are potentially many applications for this so I'd very much welcome your suggestions whilst I'm still in the development stage.

Many thanks to Sickboy for his help and expert advice!


Direct link to PDBReadme.html

Latest PDB Version:
PDB Dev-heaven repo

Direct downloads:
Arma2NETMySQLPlugin.7z
PersistentDB

PDB in MSO:
Dev-heaven repository branch



Changelog:


07/09/2012
- Arma2NETMySQL.dll compiled against Arma2Net 2.2
- Arma2NETMySQL.dll added sqlite support
- Arma2NETMySQL.dll The socket connection would stay open once started. This caused problems (aka crashing). Now, it will close down the connection after 30 minutes of inactivity.
- Arma2NETMySQL.dll logs save to AppData/Local/Arma2NETMySQL
- Arma2NETMySQL.dll Databases.txt now loads from AppData/Local/Arma2NETMySQL
- Arma2NETMySQL.dll New Databases.txt format. Added type, mysql and sqlite


10/08/2012
- PersistentDB Core rewrite
- New MYSQL DB Schema
- New example missions
- Arma2NETMySQL.dll compiled against Arma2Net 2.11.1
- Arma2NETMySQL.dll logs now save to AppData/Local/Arma2NETMySQL

22/06/2012
- compiled Arma2NETMySQLPlugin.dll against the 6.5.4 MySQL.Data Reference

16/06/2012
- fixed printing of messages in valid format

14/06/2012
- Shows version number of Arma2NET that it is compiled with.
- Fixed so it works with the latest version of the MySQL Connector (6.5.4).
- Works with latest Arma2NET (1.10).

[Loki]

looks very interesting.. will it be JiP compatible for RPG style data saves?

[[KH]Jman]

Yes. Any player or mission data that can be retrieved from the gamestate can be saved and retrieved and at any time, not just on player disconnect.

[Loki]

very very cool!

[Kremator]

Very good indeed.

[HateDread]

Excellent work, man! I love it!

[Raptor 6 Actual]

Again, another great idea from the community that makes this game hard to walk away from even if we lose all of our hair in the process

One question...will the database be able to be customized by the server admin as to what data is saved? IE- can a designer make a system that remembers pilot training and later only allows players with a certain amount of helicopter training to fly them? Hope that makes sense.

Great job JMan

[[KH]Jman]

Yes it can be customised providing you have a basic understanding of scripting and databases. On the final release I will try to document the customisation process as much as possible.

[rexehuk]

Been waiting for something like this for a long time... Great work! My initial idea for this is the ability for members to select their loadouts for sunday operations on the website, reducing waiting times upon joining.

[VictorFarbau]

Fantastic, I can't wait to try this with some massive MP mission I host now and then. How will the saving be triggered? Will the server save all data for each MP mission upon departure of the last player? Or do missions need to trigger something by a module, variable or similar?

Cheers,
VictorFarbau