Character Purge Tool?

[Tabasco]

I don't understand why you would ever want to load the entire table into memory in the first place, it kind of defeats the purpose of a database in all but the most extreme of cases.

Between SQLDev and joligario all of the required info has already been posted, I just put it into a form here.

http://216.49.224.132/eq/playerprune.tar.gz

This lets you go by player level, total time played, last login time, and total platinum.

If you're hell bent on using some .net tool, maybe GeorgeS can adapt the queries in here to his GUI.
Consider it MIT or BSD licensed.

You'll need to populate db info in db.inc.php and then uncomment the actual query in dodelete.php.

[GeorgeS]

Actually the tool works, but I forgot a very important issue of handling large character tables. I never would have imaged 1GB for a character table, so the tool would take a long time to load in the query.

Now there is a way to do this (and I will rewrite it this way) - I will only load in results of a query (as suggested before [total time played, last login time etc..]) and not the entire table.

This should expedite the process, although not entirely what I had imagined due to the afformentioned large tables. Let me give this a go, and you can try this tool once it's ready for beta release.


GeorgeS