Mass-clearing of spell books

[GeorgeS]

..so to continue, AndMetal's SQL for modifying BLOBS in profile can be done according to

UPDATE character_ SET  profile = INSERT
  ((SELECT profile FROM (SELECT * FROM character_) AS x WHERE id = 748),
  (4720+1),4,RPAD(CHAR(100),4,CHAR(0))) WHERE id = 748;

from AndMetal's message quoted--
"In theory, you can change 4720 to any field # in the profile blob & the 100 to whatever numeric value you want it set to. You would then need to change the 4's to correspond with however many characters the data takes up (32-bit integers are 4, for example), otherwise the blob will become corrupt (too many/too few characters)."

I think you can expand on this..

GeorgeS

[ChaosSlayerZ]

George - how about to add an actual char editor to your item/inventory editor =)

things like race, class, deity, gender, spells in spell book and so on =)

[GeorgeS]

I am thinking about it now, but the spells is a hard one to figure out exactly.
race, class, deity, gender and others are easy, so I may do it

GeorgeS

[ChaosSlayerZ]

ok drop the spells for now, i will take rest anytime =)

[GeorgeS]

All of the above (except AA editing) are coded into the new item editor.
clearing of spell books (1 toon at a time) is built in
You can also edit the spell book and assign memmed spells

GeorgeS