Arma2MySQL

[[kh]jman 49]

Pushed to repo

- Fixed some bad path references

- Added default xml magazine & weapons loadout selection lists.

- Removed unused css files

[Charles Darwin 10]

Kolmain: |TG|Charles Darwin on steam or you can join the TacticalGamer TS and see if you can catch me..steam would be best bet though

[brightness 12]

Alright i'm back on tracks now (Been inactive since school start), First of all - Jman & FIREFLY NICE UPDATES Since I've been gone! Thanks a lot..

I will try pushing out some of my ideas soon enough I got my eyes set in the updates and needing.

[firefly2442 6]

I'm still kinda stuck with that Arma2MySQL bug. It's hard to replicate... :/

[[kh]jman 49]

It can wait, the workaround by restarting it with Firedaemon every 8 hours works well at the moment :)

[Charles Darwin 10]

Any updates on this? I have been swamped with real life and unable to work much on my set up guide, just wondering if you guys are still working on this since there has been no activity here or on the Dev heaven site

[firefly2442 6]

Any updates on this? I have been swamped with real life and unable to work much on my set up guide, just wondering if you guys are still working on this since there has been no activity here or on the Dev heaven site

Sorry, no updates on my end. Real-life stuff has been very busy for me! Perhaps over Spring break I will have some time to look at it a little.

[Charles Darwin 10]

NP :) this an amazing thing that you guys are giving to the community :) I just wish I knew more scripting so I could be of more use

[[kh]jman 49]

I've not had any large amounts of time to spend on it either. I did do a little on the frontend but it's not ready to push to the repo yet.

[firefly2442 6]

Worked some on using Arma2NET:

http://forums.bistudio.com/showthread.php?131325-Arma2NET

This uses the built-in function call instead of the named-pipe. Working well so far, just getting hung-up on the SQF scripting side. If anyone wants to help, let me know.

https://github.com/firefly2442/Arma2NETMySQLPlugin

and

https://github.com/firefly2442/Arma2NetMySQLPlugin-ExampleMission

Cheers. :)

[[kh]jman 49]

Fantastic Firefly I'll take a look at it over the weekend and integrate it into the PDB scripts.

Removing the limitations of the named pipes will make things much more adaptable :)

Edited April 5, 2012 by [KH]Jman

[firefly2442 6]

This is just the code so far (no binary yet, still testing). It still needs some work for formatting the returned results on the Arma SQF side. Maybe we could take a look at it this weekend.

[[kh]jman 49]

Sure. I'll pm you with some TS details.

[firefly2442 6]

Need this for compiling:

https://bitbucket.org/Scott_NZ/arma2net/downloads/Arma2NET-1.3-Developers.zip

[firefly2442 6]

OK all, I need some help. I'm trying to run the windows dedicated server from my Steam install of Arma2OA to do some testing. I think I have all the configs in the appropriate place, however, I keep getting an error: "No entry .profilePathDefault". Here's what I have for my launcher:

launcher.cmd

@echo off
"C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\arma2oaserver.exe" "-cfg=C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\configs\default\basic.cfg" "-config=C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\configs\default\server.cfg" "-profiles=C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\configs\default" -name=Server -port=2302 -mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA;@ACE;@ACEX;@Arma2NET -arma2netdev

Any ideas? Thanks.

[wolffy.au 9]

I'm assuming this the right thread for this project?

https://dev-heaven.net/projects/a2-sql-persistent-db

[.kju 3244]

Put the launcher.cmd to the arrowhead folder and use the more simple definition:

beta\arma2oaserver.exe -cfg=basic.cfg -config=server.cfg "-profiles=C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead" -name=server -port=2302 -mod=@CBA;@ACE;@ACEX;@Arma2NET;Expansion\beta;Expansion\beta\Expansion -arma2netdev

[[kh]jman 49]

I'm assuming this the right thread for this project?

https://dev-heaven.net/projects/a2-sql-persistent-db

Yes correct.

[wolffy.au 9]

In the first page you guys mention Mono might allow Linux support - has anyone tried this yet?

[[kh]jman 49]

We have not no.

[firefly2442 6]

OK, so I have this but still no luck:

@echo off
arma2oaserver.exe "-cfg=basic.cfg" "-config=server.cfg" "-profiles=C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\" -name=server -port=2302 -mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA;@ACE;@ACEX;@Arma2NET -arma2netdev

How does your folder and file structure look for the Arma profile settings?

http://community.bistudio.com/wiki/server.armaprofile

I feel like I'm missing one tiny thing but I don't know what it is... lol.:confused:

[HeliJunkie 11]

@echo off
arma2oaserver.exe "-cfg=basic.cfg" "-config=server.cfg" "-profiles=C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\" -name=server -port=2302 -mod=expansion\beta;expansion\beta\expansion;@CBA;@CBA;@ACE;@ACEX;@Arma2NET -arma2netdev

With your parameters your profile directory should be (on a dedicated Server):

C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\

In the directory shoud be this files (italic words come from the -name parameter):

\arma2oaserver.RPT                     
\arma2server.bidmp                     
\arma2server.RPT                       
\mpStatistics.log                      
\[i]server[/i].log                            

\BattlEye                              
\BattlEye\BEServer.dll                 

\Users\[i]server[/i]\[i]server[/i].ArmA2OAProfile

Hope this will help you.

Regards

HeliJunkie

PS: You place the mod "@CBA" two times on your command line

PPS:

How can I watch your code from Arma2Mysql? Didn't notice that you are working on it...

I'm also working on a MySQL Addin for Arma2Net.

Sourcecode see => https://bitbucket.org/ubruns/arma2net-mysql/src

Edited May 3, 2012 by HeliJunkie
PPS added

[firefly2442 6]

Hmm, thanks. I'll give that a try.

The Arma2NET MySQL Plugin code is here:

https://github.com/firefly2442/Arma2NETMySQLPlugin

and the example mission code is here:

https://github.com/firefly2442/Arma2NetMySQLPlugin-ExampleMission

With your parameters your profile directory should be (on a dedicated Server):

C:\Program Files (x86)\Steam\steamapps\common\arma 2 operation arrowhead\Expansion\beta\

In the directory shoud be this files (italic words come from the -name parameter):

\arma2oaserver.RPT                     
\arma2server.bidmp                     
\arma2server.RPT                       
\mpStatistics.log                      
\[i]server[/i].log                            

\BattlEye                              
\BattlEye\BEServer.dll                 

\Users\[i]server[/i]\[i]server[/i].ArmA2OAProfile

Hope this will help you.

Regards

HeliJunkie

PS: You place the mod "@CBA" two times on your command line

PPS:

How can I watch your code from Arma2Mysql? Didn't notice that you are working on it...

I'm also working on a MySQL Addin for Arma2Net.

Sourcecode see => https://bitbucket.org/ubruns/arma2net-mysql/src

[Scott_NZ 10]

HeliJunkie, would you like to do a SQLite plugin for Xeno and others wanting a simple DB solution, using http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki?

Edited May 3, 2012 by Scott_NZ

[xeno 234]

HeliJunkie, would you like to do a SQLite plugin for Xeno and others wanting a simple DB solution, using http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki?

Like I wrote in the dh Ticket already, I've made a csharp-sqlite plugin myself but as callExtension support is not available on Linux (and it seems that it won't change) I've dropped it again.

SQLite support can be done quite fast with csharp-sqlite (it is basically just adding two csharp-sqlite projects to an A2Net plugin project so you have a plugin folder with 3 dlls, the basics take just a few minutes, totally easy with A2Net).

csharp-sqlite can be found here: http://code.google.com/p/csharp-sqlite/

Xeno

Edited May 4, 2012 by Xeno