Since you probably want to avoid active users, it might be nice to make a script to touch each character based on an account name and then UPDATE character_ SET timelaston = UNIX_TIMESTAMP(NOW()) WHERE account_id = X

This is easily done in PHP and could then be added to your website. If you want such a thing I could whip it up in a few minutes, as could most of the current thread contributors I'm sure.

Heh, me too.

I'll post something on our forums now just so users have a chance to log in, etc.

I posted a message on EZ Server forums about this to give people time to log in their characters, etc.

I'll probably test the tool on a backup database, then give players a week, or maybe even a month, notice to log in to save their characters.

Still eagerly waiting for the tool by GeorgeS!!

I just uploaded the beta version. I did check and it does work, but please backup first. The only tables it purges are the ones I listed in my post above.

Features -
You can sort fields, and select multiple rows and delete.

Please list features you need so i can get them in the tool.

http://www.georgestools.eqemulator.n...er_manager.rar


Have fun

GeorgeS

No window / GUI popped up.

I'm running Windows 7 64-bit.

I tried Run as Admin + Compatibility for XP.

Nothing shows up, except in process list which I kill after not seeing any window pop up.

ini file is configured properly and I ran the *.bat file for ocxs.

Any ideas?

It worked for me on Windows 7 x64.

Instead of the batch file, open an administrator command prompt and cd to the resources directory then type:

for %i in (*.ocx) do regsvr32 %i

That should register them properly.

The command prompt thing worked fine but the window doesn't show up still.

GeorgeS other tools work though =(

VB.NET ftw ;)

Hmm, did you just copy the db.ini from another one of the tools? That's what I did. I don't know if this one is picky about it, but I remember one of them didn't work right when I had an invalid client directory specified.

Maybe thats what happened. I'll try to use the orig ini and edit values manually this time.

Edit: Nope, didn't help. Register bat works, then run exe as admin just like I did with the bat file, but no window shows up. It does how ever get listed in Windows Task Manager, which I end process on.

odd, I'll look into it more and see what it may be.
More likely than not, could be a bad field/record in a table/schema issue...

GeorgeS

I updated the source / database just recently, so the table/schema should be up to date.

When the program starts, does it auto load the character table? Or do you type in fields first then do a search/query on characters? I notice when using Navicat that it takes a few seconds just to load up the first 200 character table records per page. The character table is well over 1 GB and I'm using tools remotely.

Thanks for looking into it. I'm excited to see this.

Now I think the answer is your database size. I would wait till the program finishes loading in the data - could be an hour. Then it should work fine. Had no idea it was 1GB!

Let me know what happens after it loads.

GeorgeS

I took down the server to try to character purge tool, and the window still did not show up.

I could see in the process list that mysqld.exe and character_purge.exe tool were very active I/O and let it do that for 10 minutes, but still no window.

Is there any way to load only specific info instead of the whole table which is over 1 GB? Seems to be taking too long. I am assuming soon as the program executes, it connects to the database, and loads the entire table?