Transfering spells from one character to another.[With database access]

[Equ1N0X]

So you've gotten hundreds of neat summon spells, or some other collection, and some dufus on your server made that character inaccessible to you somehow? well heres the solution. if your character is still deleted but not your account, or your account has had its ID changed, first go to the [characters] table.

1: Find your old character, and go about four fifths across the row(towards the right)
2: You should see the column spells, double click the box for your character's spells, and save them to a file.(button at top-left in sqlyog)
3: log into the game on a new account and create a new character
4:find the new character in the database
5: go and open his spells window.
6: if the character is the same class as the original character, replace everything with the number list from file saved earlier.
6.1: if character is different class, add the number list to the end of current list.
6.2 turn off our server totally if it is on.
6.3 hit OK and then the save icon (floppy disk)
7: wait around four minutes and turn on your server.
8: log into the new character, he should have all spells your old character had (including class abilities like stealth, blink etc) in the general tab.

9: Enjoy and own the newb who messed up your old toon.