REPLACE INTO item_instance (guid, owner_guid, text) SELECT guid, owner_guid, text FROM characters_335.item_instance;

UPDATE item_instance ii, characters_335.auction ah SET ii.itemEntry = ah.item_template WHERE ii.guid = ah.itemguid;
UPDATE item_instance ii, characters_335.character_inventory ci SET ii.itemEntry = ci.item_template WHERE ii.guid = ci.item;
UPDATE item_instance ii, characters_335.guild_bank_item gbi SET ii.itemEntry = gbi.item_entry WHERE ii.guid = gbi.item_guid;
UPDATE item_instance ii, characters_335.mail_items mi SET ii.itemEntry = mi.item_template WHERE ii.guid = mi.item_guid;

DELIMITER ||
DROP FUNCTION IF EXISTS uint32toint32||
CREATE FUNCTION uint32toint32(input INT(10) UNSIGNED) RETURNS INT(11) SIGNED DETERMINISTIC
BEGIN
  RETURN input;
END||
DELIMITER ;

UPDATE item_instance ii, character_335.item_instance bb SET creatorGuid = SUBSTRING(bb.data, length(SUBSTRING_INDEX(bb.data,' ',10))+2, length(SUBSTRING_INDEX(bb.data,' ',10+1))-length(SUBSTRING_INDEX(bb.data,' ',10))-1),
giftCreatorGuid = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',12))+2,length(SUBSTRING_INDEX(bb.data,' ',12+1))-length(SUBSTRING_INDEX(bb.data,' ',12))-1),
count = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',14))+2,length(SUBSTRING_INDEX(bb.data,' ',14+1))-length(SUBSTRING_INDEX(bb.data,' ',14))-1),
duration = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',15))+2,length(SUBSTRING_INDEX(bb.data,' ',15+1))-length(SUBSTRING_INDEX(bb.data,' ',15))-1),
charges = CONCAT_WS(' ',uint32toint32(SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',16))+2,length(SUBSTRING_INDEX(bb.data,' ',16+1))-length(SUBSTRING_INDEX(bb.data,' ',16))-1)),uint32toint32(SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',17))+2,length(SUBSTRING_INDEX(bb.data,' ',17+1))-length(SUBSTRING_INDEX(bb.data,' ',17))-1)),uint32toint32(SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',18))+2,length(SUBSTRING_INDEX(bb.data,' ',18+1))-length(SUBSTRING_INDEX(bb.data,' ',18))-1)),uint32toint32(SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',19))+2,length(SUBSTRING_INDEX(bb.data,' ',19+1))-length(SUBSTRING_INDEX(bb.data,' ',19))-1)),uint32toint32(SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',20))+2,length(SUBSTRING_INDEX(bb.data,' ',20+1))-length(SUBSTRING_INDEX(bb.data,' ',20))-1))),
flags = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',21))+2,length(SUBSTRING_INDEX(bb.data,' ',21+1))-length(SUBSTRING_INDEX(bb.data,' ',21))-1),
enchantments = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',22))+2,length(SUBSTRING_INDEX(bb.data,' ',57+1))-length(SUBSTRING_INDEX(bb.data,' ',22))-1),
randomPropertyId = uint32toint32(SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',59))+2,length(SUBSTRING_INDEX(bb.data,' ',59+1))-length(SUBSTRING_INDEX(bb.data,' ',59))-1)),
durability = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',60))+2,length(SUBSTRING_INDEX(bb.data,' ',60+1))-length(SUBSTRING_INDEX(bb.data,' ',60))-1),
playedTime = SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',62))+2,length(SUBSTRING_INDEX(bb.data,' ',62+1))-length(SUBSTRING_INDEX(bb.data,' ',62))-1);

DROP FUNCTION IF EXISTS uint32toint32;

UPDATE item_instance ii, character_335.item_instance bb SET flags = flags &~0x8 WHERE
SUBSTRING(bb.data,length(SUBSTRING_INDEX(bb.data,' ',3))+2,length(SUBSTRING_INDEX(bb.data,' ',3+1))-length(SUBSTRING_INDEX(bb.data,' ',3))-1)NOT IN (5043,5044,17302,17305,17308,21831);

SET @allowedFlags := 0x00000001 | 0x00000008 | 0x00000200 | 0x00001000 | 0x00008000 | 0x00010000;
UPDATE item_instance SET flags = (flags & @allowedFlags);