Code PHP :
<?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();
?>
Sa pue, c'est mal fait, ca a été fait dans l'urgence, mais sa fonctionne