Took me forever to create an install package. I was running this forever straight out of the VB IDE!

Anyways...

Get the install here:
http://www.sfc2.net/downloads.asp

This program does 2 things:
1. Cleans database
- Removes all AI objects including their ships
- Removes all bad PreparedMissions objects
- Removes all news objects
- *** WARNING *** It will also remove all Auction objects (see useage notes below)

Usage:
- Install program
- Backup database to be cleaned
- Put in a keyfile to lockout players
- Run database long enough to clear out all auctions/bids (I set the turns to 30 sec/turn so this goes faster)
- Backup database again
- Run program
- Open database file (the one with NO bids)
- Clean database
- Copy down "objects removed" total when it's done
- Manually edit newly created database (called dbout.sds). You must deduct the "objects removed" count from the actual object count before starting the database again. The object count are bytes 5-8 staring from the beginning of the db (you will need a hex editor).
- Backup database
- Rename "dbout.sds" to the original name of your database
- Copy the now cleaned and renamed database back into production
- Remember to remove your keyfile and revert back any server settings before starting up again.

Did I mention you should backup your database?

Using this procedure, you can keep your database under 3MB till the end of time. You won't necessarily be able to have 100 players on, but with the 60 you do have the performance will stay good and the server will be much more stable.

2. Parser
This will allow you to parse your EAW database meaning you can extract player statistics.
Usage:
- Run the program on your database
- When it's done parsing, you can press the "Output to CSV" button.
- Now you can take this file and do whatever you want with the data.

I personally import the data into MS SQL Server so our web site can report the stats on a web page. This way we can also query the stats to do different things with them.

Check it out!
www.sfc2.net/tempstats/empiretotals.asp
www.sfc2.net/tempstats/players.asp

***** DISCLAIMER *******
This program sucks. Yup, it sucks bad. I wrote this in iddy bits of spare time and like I said only recently threw an installer at it. The code has gone through many iterations and evolved over the last 8 months or so, so it's a big mess, only half of it works, it looks like crap etc etc. BUT, it works. USE IT AT YOUR OWN RISK

I will post the source code soon as well so someone with some time can make it work right

Enjoy!

------------------
--BBJones--
SFC2.Net Administrator


SFC2.Net Homepage
admin@bozobits.com
Player Profile

------------------
POLL: WILL YOU BUY SFC3?

Tryed it on a Op DB and it crashed i was curies.....

I hope you do relise the sourch code so that i can have a look and see what i could so with it

quote:

---

Originally posted by Gremlin:
If nothing else it shows the number of players on ATM nad all the accounts made for hte server. That by itself is usefull.

Any ideas on when the map and political option will function?

---

When someone else finishes it

The code currently parses those objects but doesn't record any of the info. Basically just skips them to get on to the rest.

Source code coming soon...