Changeset 137 for db

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

Location:

db/include

Files:

• myacc.php (modified) (1 diff)
• position_reset.php (modified) (3 diffs)
• xp_reset.php (modified) (4 diffs)

db/include/myacc.php

@@ -19 +19 @@
           mysql_query("INSERT INTO `acc_heartstone` (`acc`,`char`,`date`,`ip`) VALUES ('".$sql_select['result']['acc']['id']."','".$_GET['heartstone']."','".time()."','".$_SERVER["REMOTE_ADDR"]."')  ");
           };
+        } 
+      else{
+        print("Dnes už byla postava jednou přesunuta! Zkuste to zítra.<br>\n");
+        }
+      }
+    else{
+      SwitchDB(1); // nastavení databáze na mangos
+      $PosRess = new PosRess($_GET['heartstone']);
+      if( $PosRess->char_name != false ){
+        $PosRess->GoHome();
+        $PosRess->GoHomeDone();
+        SwitchDB(3); // nastavení databáze na web
+        mysql_query("INSERT INTO `acc_heartstone` (`acc`,`char`,`date`,`ip`) VALUES ('".$sql_select['result']['acc']['id']."','".$_GET['heartstone']."','".time()."','".$_SERVER["REMOTE_ADDR"]."')  ");
         };
       };

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>");
       }
     }

db/include/xp_reset.php

@@ -5 +5 @@
     var $char_id;
     var $char_name;
+    var $poradi = 856; // XP je an pozici 857 ale začínáme od 0
     
     function __construct($char_id)
@@ -34 +35 @@
       $data_old = $load_res["data"];
       $pole = explode(" ",$data_old);
-      // XP - 857
-      $poradi = 857;
-      $poradi = $poradi - 1;
-      echo "Postava ".$this->char_name." má ".$pole[$poradi]." XP.<br>\n";
+      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");
+        }
     }
     
@@ -46 +50 @@
       $data_old = $load_res["data"];
       $pole = explode(" ",$data_old);
-      // XP - 857
-      $poradi = 857;
-      $poradi = $poradi - 1;
-      $pole[$poradi] = "0";
-      $save = mysql_query("UPDATE `character` SET  `data` = '".$pole."' WHERE `guid` ='".$this->char_id."' LIMIT 1");
+      $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");
+        };
     }
     
@@ -59 +66 @@
       $data_old = $load_res["data"];
       $pole = explode(" ",$data_old);
-      // XP - 857
-      $poradi = 857;
-      $poradi = $poradi - 1;
-      if ( $pole[$poradi] == "0")
+      if( !isset($pole[$this->poradi]) )
       {
-        echo "Restart XP dokončen !<br>\n";
+        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
       {
-        echo "Restart XP se nezdařil !<br>\n";
+        print("Restart XP se nezdařil !<br>\n");
       }
     }