Character Wipe Issues
 

Hey guys,


So, after doing a lot of server work I decided to wipe the accounts. I found a thread on here that stated using drop_players, but that doesn't exist anymore in the peq download, I also could not find it. Also in that thread someone had posted a script they used to wipe. So I tried that and now everybodies client crashes after character select to world logon. I tried restoring from the backup pre-wipe and it doesn't matter, every client crashes. I have tried all kinds of things, removing toon manually, deleting all characters from select screen and remaking, I just don't know what to do. Heres the dbg.txt log from client.

I just recently did the latest recompile and all sql updates are installed. Everything worked until I messed around with trying to wipe characters. ugh.

this is the thread I was following
http://www.eqemulator.org/forums/showthread.php?t=39621

EDIT : I'm willing to bet the auto increment from the posted script fubar'd it.

If anybody knows what this could be, an answer may be good for anybody in the future.

I fixed mine though, took the long route and just sourced a new database, updated sql, restored the tables ive changed like npcs, grids, items, spells, etc.

There's probably a better way to do this...

On bots, that information is old and won't affect the reworked tables.

You want a full out purge of all characters and accounts?

Well to be fair, that script is almost a year old and since then there are more tables that have been added character related, "character_alternate_abilities" for one, so of course there would be issues..The script has not been updated to the current structure.


I'm just a lurker now, so hopefully a "better way" will be developed soon that gets updated automagically..

I understand rencro, you stated that the script was old so I knew there was a risk lol but I was opening my server up to public beta and had to take the chance :)

Yes Shin Noir, I wanted to purge all accounts and every bit of data to do with characters so it was a complete character and account wipe without messing up npc and other world information.

I agree Uleat, has to be a better way hahaha. I just do what I know how to do. Sometimes the long road is a shortcut over learning and breaking lol

Not all the tables with character information are labeled character and sifting through all the tables tryen to match character IDs and account IDs would have taken a ton more time.

EDIT : I don't use bots so I deleted all the bot entries so that wasn't an issue. Just some other altered naming changes that caught me off guard

Figback, I went ahead and wrote up a menu option for character and accounts wiping (option 19).
Click the photo and download the version your eq server is on (likely windows 64x). Run the exe in the same directory your eqemu_config.xml file is, and always: backup!
http://i.imgur.com/LCVupHt.png

Let me know if it works for you, and if not, any symptoms and i'll try to support the side effects. I did a quick dry run locally on my test box and it seemed fine.

Oh nice! I didn't even know that little program existed! Woulda saved me some time hahaa, ill download and test for u.

Just remember to backup.

And generic disclaimer, note that normally it is not recommended to download binaries (exe), since they can contain viruses, and it shouldn't be a habit unless you trust the source. (I'm the source). Feel free to virus scan or any other efforts to ensure things are good, even verify the code with a programmer friend (it is open source) to get any vouches it's all OK.

That aside, let me know how it goes, and report any errors you hit.

MD5s are nice too :D

Got an issue saying there was no character_custom table, which doesn't appear to be in the base peq database. The character wipe then stopped and didn't carry on further.

Shin, What does PEQ Tweaks do?

Celestial

Edit: I see, it updates skeleton speed. Is that more like live?

Try to download it again at here: https://github.com/Xackery/eqcleanup/releases/tag/0.13

I removed the step it clears character_custom.

When I grabbed the latest PEQ build it was in an august one, and there was a few PEQ related issues. You can see a rundown of what it does here: https://github.com/Xackery/eqcleanup...ak/peqtweak.go

But yeah, at this time, it only fixes runspeed, since without that fix, most skeletons are permarooted and easily abused by casters.

Most of what EQCleanup's intent is, I collect a bunch of little tweaks and cleanup methods that in general help cater your database to unconventional setups (one thing I'm starting to work on is to turn old models into modern ones). You know, a collection of misc changes.

EVENTUALLY, I'll make it spin up a web server so you can access it locally (similar to EOC or PEQ editor) and get a more informative/graphical experience with more options. For now, it's quick and dirty and gets the job done. :)