Guest User

Untitled

a guest
Jun 21st, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. function unstuck($guid)//returns
  2. {
  3. global $db,$db_translation;
  4. $fail=false;
  5.  
  6. //fetching character homebind
  7. $query_select = 'SELECT * FROM character_homebind WHERE guid = "'.$guid.'" LIMIT 1';
  8. $sql1=$db->query($query_select)or die($report = 'Error1: '.mysql_error());
  9. $sql2=$db->fetch_assoc($sql1);
  10.  
  11. // Чистим ауры...
  12. if($repair_aurs_clean)$db->query("DELETE FROM `character_aura` WHERE `guid` = '$guid' ");
  13.  
  14. // Чистим группы...
  15. if($repair_groups_clean){
  16. $db->query("DELETE FROM `groups` WHERE `leaderGuid` = '$guid' ");
  17. // Чистим лидера из группы...
  18. $db->query("DELETE FROM `group_member` WHERE `leaderGuid`= '$guid' or `memberGuid`= '$guid' ");
  19. }
  20. // Чистим инстансы...
  21. if($repair_instance_clean)$db->query("DELETE FROM `character_instance` WHERE `guid` = '$guid' ");
  22.  
  23. $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';
  24. $db->query($query_update) or ($fail=mysql_error());
  25.  
  26. return $fail;
  27. }
Add Comment
Please, Sign In to add comment