EQEmulator Forums - View Single Post - Mass-clearing of spell books

**GeorgeS** · #3 05-18-2009, 10:50 PM

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

Code:

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