EQEmulator Forums - Delete All Spells in Spellbook

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- General::General Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=586)

- - Delete All Spells in Spellbook (https://www.eqemulator.org/forums/showthread.php?t=44384)

Delete All Spells in Spellbook

Hi folks,

New to the community :).

I've set up my own (private) EQEMU server and am happily multi-boxing away in FOB. I made myself a GM and used a #GM command to completely populate my toons' spellbooks. That turned out to be a huge mistake. Now I have pages and pages of spells I don't understand and would love to just delete them and start over.

Is there some entry in the DB I can edit to delete all this content? I know nothing about SQL but I did manage to cludge my way through to an enticing entry that says character_spells. if I right-click I can "empty tables" or "create new". Anyone know what the heck that will do?

Any advice appreciated (short of "click through every spell manually and delete it).

Thanks!

EDIT: For anyone else looking lol: #unscribespells

Quote:

Originally Posted by Drajakur (Post 270686)

I'm currently trying to restablish a server myself and having several issues. BUT, that's not what I'm replying for. You should be able to delete and remove via #bot commands in-game and doesn't require that you do so via MariaDB/MySQL i believe. It's been a while.

You may be able to locate a txt file that will display them= *YourServerLocation*\utils\sql\git\bots" for a quick delete. I can't confirm at this time as I haven't been successful in getting same machine to generate on my client list (So I then can make public for a friend of mine to play it with me remote"

#unmemspells Unmemorize all spells for you or your target