Character Purge Tool? - Page 2

Tabasco · #16 08-20-2011, 06:35 PM

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.

revloc02c · #17 08-20-2011, 09:27 PM

Quote:

Originally Posted by lerxst2112

I know when I saw this question I logged in all my toons hoping they won't be deleted.

Heh, me too.

thepoetwarrior · #18 08-21-2011, 06:09 AM

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

thepoetwarrior · #19 08-21-2011, 11:39 AM

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!!

**GeorgeS** · #20 08-21-2011, 01:24 PM

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

thepoetwarrior · #21 08-23-2011, 10:36 PM

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?

lerxst2112 · #22 08-23-2011, 10:45 PM

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.

thepoetwarrior · #23 08-24-2011, 03:24 AM

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

GeorgeS other tools work though =(

BrandeX · #24 08-24-2011, 04:32 AM

VB.NET ftw

lerxst2112 · #25 08-24-2011, 07:13 AM

Quote:

Originally Posted by thepoetwarrior

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

GeorgeS other tools work though =(

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.

thepoetwarrior · #26 08-24-2011, 10:06 AM

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.

**GeorgeS** · #27 08-24-2011, 10:17 AM

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

thepoetwarrior · #28 08-24-2011, 10:12 PM

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.

**GeorgeS** · #29 08-25-2011, 10:08 AM

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

Quote:

Originally Posted by thepoetwarrior

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.

thepoetwarrior · #30 09-11-2011, 07:05 AM

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?