Undo a .reset all?

[g1bb0n]

So is there a way to undo a .reset command? Since it is at next character login, is there a way to prevent the damage to those characters who have not logged in yet?

[Schmoozerd]

yes, look at the at_login flags, description is in the wiki

[g1bb0n]

Awesome! I knew it wasn't too late. Is there a way to set this value to 0 on all characters in a short way? Or would I need to edit each sql entry manually?

[g1bb0n]

Yeah my wife accidentally used .learn all, and her spellbook was so junked up. Then she tried to remove all her spells, but she used .reset, rather than .unlearn. I think she used .reset all. This all happened while I was at work.

I think I just fixed it with the following sql command: UPDATE characters SET at_login="0" WHERE at_login="6"

I used 6 because it was a combination of the bitmasks 2 and 4, which according to that wiki, described the symptoms perfectly (talents and spells).

Now I just need a way to delete all the mail I sent, which was supposed to be compensation, but is no longer needed! Is there an ingame command to delete mail from someone, or is that an sql edit as well?

OK, I removed the mass mail with this: DELETE FROM mail WHERE sender="27";

Looking at the tables, I noticed my GM was sender 27. OMG huge sigh of relief here!

[lillecarl]

UPDATE characters SET at_login = 0;

That will remove everyones at_login flag =)