Changeset 137 for db/include/position_reset.php

Timestamp:

Nov 17, 2007, 8:57:23 PM (17 years ago)

Author:

hosiplan

Message:

+ snad už konečně funkční verze XP_restarteru a Position_restarteru

File:

• db/include/position_reset.php (modified) (3 diffs)

db/include/position_reset.php

@@ -16 +16 @@
       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 )
+      $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>");
+        print("Nemůžete přesouvat postavu, která je online! Nejprve se odhlašte!<br>\n");
         $this->char_name = false;
       }
       else 
       {
-        $this->char_name = $load["name"]; 
+        $this->char_name = $this->character["name"]; 
       }
     } 
     
-    public function GoHome()
+    public function StartLocation()
     {
-      $sql_home = mysql_query("SELECT * FROM `character_homebind` WHERE `guid` = '".$this->char_id."' LIMIT 1");
+      $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"];
@@ -44 +44 @@
         `position_z` = '".$home_char_position_z."'
          WHERE `guid` ='".$this->char_id."' LIMIT 1");
-         echo "Přesouvám postavu : ".$this->char_name.".<br>";
+         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();
         }
     }
@@ -65 +89 @@
       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>";
+        print("Postava : ".$this->char_name." přesunuta !<br>");
       }
       else
       {
-        echo "Postavu : ".$this->char_name." se nepovedlo přesunout !<br>";
+        print("Postavu : ".$this->char_name." se nepovedlo přesunout !<br>");
       }
     }