[FIX?]Problem s GUID overflow

[STONERSVK 899]

Nekdo se mne ptal jak vyresit problem s GUID overflow tady sou clean up sqlka ktere vam to pomohou vyresit

 

p.s.pro jistotu si udelejte zalohy

p.s2: jestli je tam nejaka chyba napiste opravim to

 

 

 

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;

 

auctionhouse

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

 

Item data field

 

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

 

 

 

nebo PHP scriptem

 

<?php
set_time_limit(0);
$sql = mysql_connect("127.0.0.1","root","pass");
mysql_select_db("db", $sql);
$guidTab = mysql_query("SELECT guid FROM creature ORDER BY guid") or die(mysql_error());
for($i = 1; $dguid = mysql_fetch_array($guidTab); $i++)
{
 $lguid = $dguid['guid'];
 if($i != $lguid)
 {
  mysql_query("DELETE FROM creature WHERE guid='$i'") or die(mysql_error());
  mysql_query("DELETE FROM creature_addon WHERE guid='$i'") or die(mysql_error());
  mysql_query("DELETE FROM creature_battleground WHERE guid='$i'") or die(mysql_error());
  mysql_query("DELETE FROM creature_movement WHERE id='$i'") or die(mysql_error());
  mysql_query("DELETE FROM creature_respawn WHERE guid='$i'") or die(mysql_error());
  mysql_query("DELETE FROM game_event_creature WHERE guid='$i'") or die(mysql_error());
  mysql_query("DELETE FROM npc_gossip WHERE npc_guid='$i'") or die(mysql_error());
  mysql_query("DELETE FROM pool_creature WHERE guid='$i'") or die(mysql_error());

  mysql_query("UPDATE creature SET guid='$i' WHERE guid='$lguid'") or die(mysql_error());
  mysql_query("UPDATE creature_addon SET guid='$i' WHERE guid='$lguid'") or die(mysql_error());
  mysql_query("UPDATE creature_battleground SET guid='$i' WHERE guid='$lguid'") or die(mysql_error());
  mysql_query("UPDATE creature_movement SET id='$i' WHERE id='$lguid'") or die(mysql_error());
  mysql_query("UPDATE creature_respawn SET guid='$i' WHERE guid='$lguid'") or die(mysql_error());
  mysql_query("UPDATE game_event_creature SET guid='$i' WHERE guid='$lguid'") or die(mysql_error());
  mysql_query("UPDATE npc_gossip SET npc_guid='$i' WHERE npc_guid='$lguid'") or die(mysql_error());
  mysql_query("UPDATE pool_creature SET guid='$i' WHERE guid='$lguid'") or die(mysql_error());
 }
}
mysql_close();
?>

Edited December 21, 2011 by STONERSVK

[STONERSVK 899]

edited upraven script!

NENESU ZADNOU ZODPOVEDNOST ZA PRIPADNE POSKOZENI DB!!!

 

 

ZALOHUJTE si pred tym DB