[Sql FIX]Creature Guild overflow

[wow-masters]

-- Generate a new guid

ALTER TABLE item_instance ADD COLUMN guid_new INT(11) UNSIGNED AUTO_INCREMENT UNIQUE AFTER guid/*, AUTO_INCREMENT = 1000*/;

-- Item data field

UPDATE item_instance SET DATA = CONCAT(guid_new, ' ', RIGHT(DATA, LENGTH(DATA)-LENGTH(SUBSTRING_INDEX(DATA, ' ', 1))-1));

-- auctionhouse

UPDATE auctionhouse AS ah, item_instance AS it SET ah.itemguid = it.guid_new WHERE ah.itemguid = it.guid;

-- character_gifts

UPDATE character_gifts AS cg, item_instance AS it SET cg.item_guid = it.guid_new WHERE cg.item_guid = it.guid;

-- character_inventory

UPDATE character_inventory AS ci, item_instance AS it SET ci.bag = it.guid_new WHERE ci.bag = it.guid;

UPDATE character_inventory AS ci, item_instance AS it SET ci.item = it.guid_new WHERE ci.item = it.guid;

-- guild_bank_item

UPDATE guild_bank_item AS gb, item_instance AS it SET gb.item_guid = it.guid_new WHERE gb.item_guid = it.guid;

-- mail_items

UPDATE mail_items AS mi, item_instance AS it SET mi.item_guid = it.guid_new WHERE mi.item_guid = it.guid;

-- petition

UPDATE petition AS p, item_instance AS it SET p.petitionguid = it.guid_new WHERE p.petitionguid = it.guid;

-- petition_sign

UPDATE petition_sign AS ps, item_instance AS it SET ps.petitionguid = it.guid_new WHERE ps.petitionguid = it.guid;

-- Put the new guid in place

UPDATE item_instance SET guid = guid_new;

Who wrote this,

not me someone else did but would be a good idea to use it in extras.

[darkstalker]

i wrote that lol.

and its for "packing" item guids, nothing to do with creatures (original purpose was to fix a client bug with arena charters when guidlow is > 2 billions)

[kich0]

maybe he posted the wrong SQL ? this one isn't event related to creatures?

[Raynar]

darkstalker, do you have de sql for creatures? I would be very usefull for the people!