Arma2MySQL

[firefly2442]

An interesting comment here:

https://dev-heaven.net/issues/9436#note-27

[[KH]Jman]

Dwarden's comment refers to the new call extension API thats present in beta 1.60.87662 and above.

It's implemented in the latest jay2lib and working with our project just fine

[brightness]

Dwarden's comment refers to the new call extension API thats present in beta 1.60.87662 and above.

It's implemented in the latest jay2lib and working with our project just fine

I confirm that, its been running smooth.

JMAN I was thinking about implement in the PDB UCP a way for the admins to insert guns into their database where the player can select his gear.

Sounds good??

[[KH]Jman]

There is an edit player loadout feature in the UCP which is pretty much finished (ACE backpack and weapon on back support needs adding), it's based on the logged in user type privilages, i.e demo privilage: view user data only, user privilage: view/edit user data, administrator privilage: view/edit all user's data. You can set an xml file in the UCP which is specific to a mission which filters the available loadout pool of weapons, ammo and equipment that a user can choose from. It's all undocumented at the moment (though if you look through the php/jquery code you'll see how it works) so I'll have to take you through it on Teamspeak at some point then you should be able to complete/extend/fix it etc... There is a screenshot of the edit player loadout here

[brightness]

I was thinking about making the loadout system in SQL as I am working on a armoury system for my community with currency system which is still under progress but what my idea was that adding the weapons in a table and print it out in a box, example:

$grabdata = mysql_query("SELECT * FROM loadouts");
while ($row = mysql_fetch_array($grabdata, MYSQL_NUM)) {
//EXAMPLE : FORM CODE HERE WITH ROW[0]
}

and then read from "retrieveloadout.php" and get each row name and insert/update the player data which is possible, right?

[[KH]Jman]

Yep that should be fine, however remember weapons and magazine slot positions/limitations and if it's ACE, weight restrictions and ace backpack capacity. The current UCP uses a global xml file which contains all these values which the jquery script reads and uses.

[Charles Darwin]

Ok I admit Im not greatly knowledgeable on SQL but seem to be having an issue as it doesnt seem the scripts even attempt to run in the example mission

I have set up an MySQL server put the info into the database file.. transferred the mission into my MPmissions folder and started it

so its not on a dedicated server(which may be the problem) but testing it out before throwing it on a dedi server

but when the mission loads nothing appears to start related to the arma2sql either in game or the rpt file

[Sickboy]

What about @JayArma2Lib modfolder, did you install and enable it?

[[KH]Jman]

@Charles Darwin. The PDB scripts will only run when the mission is hosted from a dedicated server, the scripts will bypass on the client if you do not hence the issue that you are experiencing.

Run the Arma2SQL.CLI.exe on the server and make sure that the arma2oaserver.exe is running JayArma2Lib and CBA addons. CBA is needed on the server since the serverside PDB scripts call some of the CBA functions but you'll need it anyway since the example mission uses ACE.

The example mission also requires that ACE is running on client as well as server. The client need not run JayArma2Lib and only needs to run CBA if it's an ACE mission (like the example). The client PDB scripts do not call any CBA functions, thus there are no client addon dependencies for PDB.

To setup PDB in a non ACE mission just open the pdbSetup.sqf and disable ACE support with the line: pdb_ace_enabled = false;

Apologies for the fact that there is little or no documentation at the moment, that will change in time.

I have removed the download archive from the files tab in the Dev Heaven project as the download was out of date. The files are now only available from the .git repository here

[Charles Darwin]

NP ^^ from looking at the code I was pretty sure that was the issue just wanted to make sure it was that and not having to do with my limited SQL knowledge though from what I have seen thus far its fairly simple to understand. thanks for the reply Also as far as the SQL procedures is there anything that is required to run the PDB?

*goes to fire up a dedi server*