source: db/include/position_reset.php@ 137

<?

  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");
      $this->character = mysql_fetch_array($sql);
      if( $this->character['online'] != 0 )
      {
        print("Nemůžete přesouvat postavu, která je online! Nejprve se odhlašte!<br>\n");
        $this->char_name = false;
      }
      else 
      {
        $this->char_name = $this->character["name"]; 
      }
    } 
    
    public function StartLocation()
    {
      $sql_home = mysql_query("SELECT * FROM `playercreateinfo` WHERE `race` = '".$this->character['race']."' AND `class` = '".$this->character['class']."' 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");
         print("Přesouvám postavu : ".$this->char_name." na startovní lokaci.<br>");
        }
    }
    
    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");
           print("Přesouvám postavu : ".$this->char_name." domů.<br>");
        } 
        else
        {
          $this->StartLocation();
        }
    }
    
    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)
      {
        print("Postava : ".$this->char_name." přesunuta !<br>");
      }
      else
      {
        print("Postavu : ".$this->char_name." se nepovedlo přesunout !<br>");
      }
    }
  
  } // class end

?>