Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function unstuck($guid)//returns
- {
- global $db,$db_translation;
- $fail=false;
- //fetching character homebind
- $query_select = 'SELECT * FROM character_homebind WHERE guid = "'.$guid.'" LIMIT 1';
- $sql1=$db->query($query_select)or die($report = 'Error1: '.mysql_error());
- $sql2=$db->fetch_assoc($sql1);
- // Чистим ауры...
- if($repair_aurs_clean)$db->query("DELETE FROM `character_aura` WHERE `guid` = '$guid' ");
- // Чистим группы...
- if($repair_groups_clean){
- $db->query("DELETE FROM `groups` WHERE `leaderGuid` = '$guid' ");
- // Чистим лидера из группы...
- $db->query("DELETE FROM `group_member` WHERE `leaderGuid`= '$guid' or `memberGuid`= '$guid' ");
- }
- // Чистим инстансы...
- if($repair_instance_clean)$db->query("DELETE FROM `character_instance` WHERE `guid` = '$guid' ");
- $query_update ='UPDATE characters SET position_x="'.$sql2['posX'].'", position_y="'.$sql2['posY'].'", position_z="'.$sql2['posZ'].'", map="'.$sql2['mapId'].'", zone="'.$sql2['zoneId'].'" WHERE guid="'.$sql2['guid'].'" LIMIT 1';
- $db->query($query_update) or ($fail=mysql_error());
- return $fail;
- }
Add Comment
Please, Sign In to add comment