source: db/include/position_reset.php@ 132

<?

  class PosRess 
  {
    var $char_id;
    var $char_name;
    
    function __construct($char_id)
    {
      $this->char_id = $char_id;
      $this->CharName();
    } 
    
    private function CharName()
    {
      global $user;
      $sql = mysql_query("SELECT * FROM `character` WHERE `guid` = '".$this->char_id."' AND `account`='".$user['acc']."' LIMIT 1");
      $load = mysql_fetch_array($sql);
      if( $load['online'] == 0 )
      {
        print("Nemůžete přesouvat postavu, která je online! Nejprve se odhlašte!<br>");
        $this->char_name = false;
      }
      else 
      {
        $this->char_name = $load["name"]; 
      }
    } 
    
    public function GoHome()
    {
      $sql_home = mysql_query("SELECT * FROM `character_homebind` WHERE `guid` = '".$this->char_id."' LIMIT 1");
      $load_home = mysql_fetch_array($sql_home);
      $home_char_map         = $load_home["map"];
      $home_char_position_x  = $load_home["position_x"];
      $home_char_position_y  = $load_home["position_y"];
      $home_char_position_z  = $load_home["position_z"];
        if (isset($home_char_map) AND isset ($home_char_position_x) AND isset ($home_char_position_y) AND isset ($home_char_position_z))
        {
        $save = mysql_query("UPDATE `character` SET 
        `map` = '".$home_char_map."' ,
        `position_x` ='".$home_char_position_x."' ,
        `position_y` = '".$home_char_position_y."' ,
        `position_z` = '".$home_char_position_z."'
         WHERE `guid` ='".$this->char_id."' LIMIT 1");
         echo "Přesouvám postavu : ".$this->char_name.".<br>";
        }
    }
    
    public function GoHomeDone()
    {
      $sql_home = mysql_query("SELECT * FROM `character_homebind` WHERE `guid` = '".$this->char_id."' LIMIT 1");
      $load_home = mysql_fetch_array($sql_home);
      $home_char_map         = $load_home["map"];
      $home_char_position_x  = $load_home["position_x"];
      $home_char_position_y  = $load_home["position_y"];
      $home_char_position_z  = $load_home["position_z"]; 
      
      $sql_pos = mysql_query("SELECT * FROM `character` WHERE `guid` = '".$this->char_id."' LIMIT 1");
      $load_pos = mysql_fetch_array($sql_pos);
      $char_map         = $load_pos["map"];
      $char_position_x  = $load_pos["position_x"];
      $char_position_y  = $load_pos["position_y"];
      $char_position_z  = $load_pos["position_z"];
      if ($home_char_map == $char_map AND $home_char_position_x == $char_position_x AND $home_char_position_y == $char_position_y AND $home_char_position_z == $char_position_z)
      {
        echo "Postava : ".$this->char_name." přesunuta !<br>";
      }
      else
      {
        echo "Postavu : ".$this->char_name." se nepovedlo přesunout !<br>";
      }
    }
  
  } // class end

?>