source: db/include/xp_reset.php@ 137

<?

  class XpRess 
  {
    var $char_id;
    var $char_name;
    var $poradi = 856; // XP je an pozici 857 ale začínáme od 0
    
    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 restartovat zkušenosti postavy, která je online! Nejprve se odhlašte!<br>\n");
        $this->char_name = false;
      }
      else 
      {
        $this->char_name = $load["name"]; 
      }
    }
        
    public function ShowXp()
    {
      $sql_res = mysql_query("SELECT * FROM `character` WHERE `guid` = '".$this->char_id."' LIMIT 1");
      $load_res = mysql_fetch_array($sql_res);
      $data_old = $load_res["data"];
      $pole = explode(" ",$data_old);
      if( !isset($pole[$this->poradi]) )
      {
        print("Postava nemá definované XP! Je to závažná chyba v databázi!<br>\n");
      }
      else{
        print("Postava ".$this->char_name." má ".$pole[$this->poradi]." XP.<br>\n");
        }
    }
    
    public function XpRestart()
    {
      $sql_res = mysql_query("SELECT * FROM `character` WHERE `guid` = '".$this->char_id."' LIMIT 1");
      $load_res = mysql_fetch_array($sql_res);
      $data_old = $load_res["data"];
      $pole = explode(" ",$data_old);
      $pole[$this->poradi] = 0;
      if( !isset($pole[$this->poradi]) )
      {
        print("Postava nemá definované XP! Je to závažná chyba v databázi!<br>\n");
      }
      else{
        mysql_query("UPDATE `character` SET  `data` = '".implode(" ", $pole)."' WHERE `guid` ='".$this->char_id."' LIMIT 1");
        };
    }
    
    public function XpRestartDone()
    {
      $sql_res = mysql_query("SELECT * FROM `character` WHERE `guid` = '".$this->char_id."' LIMIT 1");
      $load_res = mysql_fetch_array($sql_res);
      $data_old = $load_res["data"];
      $pole = explode(" ",$data_old);
      if( !isset($pole[$this->poradi]) )
      {
        print("Postava nemá definované XP! Je to závažná chyba v databázi!<br>\n");
      }
      elseif ( $pole[$this->poradi] == 0 )
      {
        print("Restart XP dokončen !<br>\n");
      }
      else
      {
        print("Restart XP se nezdařil !<br>\n");
      }
    }

  }

?>