AMailer Posted June 18, 2008 Share Posted June 18, 2008 Hello, I am working on recreating the BWN MOD, Duel MOD, where it basically records the players stats and etc. I was wondering if anyone was interested in helping out. Im planning on making it update the stats to a central server, I got a dedicated box for this, hoping to use MSSQL (i'm pretty familiar with this) and create a website around it with registrations and etc to record your stats. I'm going to be needing help with coming up with ways to update the data to the main server. I'm guessing store the data on the server for the day, and on every x hour of the day, send an update to the main host. Any help would be greatly appreciated, if you want to help me build this, contact me. Will be open source. Thanks, Aaron P.S. Yes, I'm pretty noob at this but Im not inexperienced in the general programming area so I can learn fast and etc. I have already started working on the mod, now working on simply storing the stats into a file for the server to read off and record - for now only though. Link to comment Share on other sites More sharing options...
ck-killa Posted September 24, 2008 Share Posted September 24, 2008 I'm working on something similar, or have been rather on and off. Instead of MSSQL, I use MySQL. It works flawlessly except for the fact that the .dll can be read if the client gets hold of the jampgame file. So distribution would not go well, lol. I need a way of encrypting it somehow so that no one can read the username and password of the server. Otherwhise I already have a working mod. It reads and writes certain things to the database. It writes flag captures, flag returns, assists, deaths, kills, duel wins, duel losses, siege objectives completed, etc. Each client makes their own account which is linked to a phpBB2 forum so that once you register in-game you can use that account on the forums, and if you register on the forums, you can use that account in-game. It works both ways since the same database is attached. The game server can be completely seperate from the MySQL server, and the MySQL server can be completely seperate from the phpBB2 server. So the ease on the bandwidth is easy to maintain. The clients and the server CAN feel lag spikes however since the server needs to communicate with the MySQL server, however, if you want you can put the MySQL and game server on the same box and you wont feel any lag. The lag spikes only happen when a client logs into their account since thats almost the only time it needs to update or insert information. Also the information is logged when they disconnect so you could feel it then as well. If you're interested in helping me with this project, we could eventually finish it. BTW - I talked to the author of BWN, he uses a seperate application to insert the information, and its not to a database, its only to some files which the server reads and writes. It's rather small. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.