PDA

View Full Version : MySQL



{7}21|Gef.Jupiter
17th March 2008, 21:19
I'm doing a linux app that will enable arma scripts to connect to a mysql database.

Would the mod team be interested in this?

On the other hand as far as i understand the atow server is running on windows, am i right?

This will be pretty much what FWatch was to ofp, ...if i get it finished.

Edit:
Of course the app could do a lot other things as well, running external programs, accepting external connections (maybe a webapp to control the server), submit a form on a wbsite to trigger a nuclear explosion ingame, etc...

BazookaBoy
17th March 2008, 21:27
We have looked at an app which will right out to windows files, but writting to a database would also be very handy (automatic gathering of destroyed totals, objective ownership etc). But you correct our game server is currently windows.

{7}21|Gef.Jupiter
17th March 2008, 21:48
Yeah that's what i tought, well i dont know if i can do it on windows as easily you'd probably need to be a Keg to get it right.

Has there been any debate on weather the server should be win or linux, or is there some issue that outright rules out the latter?

[UN]SGen.ViperMaul
17th March 2008, 21:51
Actually the same app was we looked at also wrote to a database file. But the obstacle was the difficulty in getting the server app to started consistently each week. The scripts are completed and working too. Nutty101 was the author and he abandoned his 1.x for a 2.0 version then stopped working on that when ArmA II was announced. You should look at what he did as you will probably have some of the same headaches that he faced. I will get you the link when I find it.

[UN]SGen.ViperMaul
17th March 2008, 21:58
Here is what were were using. It past all the beta tests successfully. But when we moved it to the production servers it was too hard to keep running without Remote Desktop which we do not have.

http://www.armaholic.com/page.php?id=847

The latest update as of 11-Mar-2008
http://forums.livecar.net/index.php?showtopic=75&pid=211&st=0&#entry211

{7}21|Gef.Jupiter
17th March 2008, 22:04
Well i think im having a unique approach here connecting straight to mysql using a deamon process interrupting all arma file access. I already did this once for ofp (basing it on fwatch at that time) this time though it works for linux. Fwatch (or any other) didnt work for linux because of how the ofp binary was linked. Arma linux binaries are linked differently making it now possible to do it.

One of my ideas is to make a dynamic mission that reads all the mission data from the database and that data can be generated by a website. What im thinking is that fro ATow this could provide access for each army general to plan missions for battle day, placing the vehicles and other stuff and then the website can generate briefings for the grunts as well as the mission itself.

We could even track the realtime positions of players on a website during battle, generate new objectives on the fly etc..

I'll definitely check those links though, thanks!