Changeset 682 for trunk/inc/player.php

Timestamp:

Jan 23, 2010, 4:03:37 PM (14 years ago)

Author:

george

Message:

• Opraveno: Na dalších stránkách přepracován systém pro načítání údajů z databáze namísto konfiguračního souboru.
• Přidáno: Skript pro periodickou kontrolu online stavu přihlašovacích serverů a světů. Online stav se načítá nově přímo z databáze a sníží se tak zátěž sítových portů služeb.

File:

• trunk/inc/player.php (modified) (14 diffs)

trunk/inc/player.php

@@ -102 +102 @@
     global $Config;
 
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
-    $DbResult = $this->db->query('SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.($Config['Mangos']['CharacterDataOffset']['Level'] + 1).'), " ", -1) AS UNSIGNED) AS `level` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;');
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+    $DbResult = $Realm->CharactersDatabase->query('SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.($Config['Mangos']['CharacterDataOffset']['Level'] + 1).'), " ", -1) AS UNSIGNED) AS `level` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;');
     $row = $DbResult->fetch_assoc();
     return($row['level']);
@@ -135 +135 @@
   public function ResetXP($guid)
   {
-    global $Config;
+    global $System, $Config;
 
     if($this->CharInAcc($guid, 0))
@@ -141 +141 @@
       if(!$this->IsOnline($guid))
       {
-        $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
-        $row = $this->db->query('SELECT `data` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_assoc();
+        $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+        $row = $Realm->CharactersDatabase->query('SELECT `data` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_assoc();
         $data = explode(' ', $row['data']);
         $data[$Config['Mangos']['CharacterDataOffset']['Exp']] = 0;
         $data = implode(' ', $data);
-        $this->db->query('UPDATE `characters` SET `data` = "'.$data.'" WHERE `guid` ="'.$guid.'" LIMIT 1');
+        $Realm->CharactersDatabase->query('UPDATE `characters` SET `data` = "'.$data.'" WHERE `guid` ="'.$guid.'" LIMIT 1');
         $this->Msg('Postavě resetováno XP.', 0);
       } else $this->Msg('Postava musí být offline.', 1);
@@ -154 +154 @@
   public function ResetPosition($guid)
   {
-    global $Config;
-
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
+    global $System, $Config;
+
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
     if($this->CharInAcc($guid, 0))
     {
       if(!$this->IsOnline($guid))
       {
-        $row = $this->db->query('SELECT * FROM `character_homebind` WHERE `guid` = "'.$guid.'" LIMIT 1;')->fetch_array();
+        $row = $Realm->CharactersDatabase->query('SELECT * FROM `character_homebind` WHERE `guid` = "'.$guid.'" LIMIT 1;')->fetch_array();
         $home_char_map = $row['map'];
         $home_char_position_x = $row['position_x'];
@@ -168 +168 @@
         if(isset($home_char_map) and isset($home_char_position_x) and isset($home_char_position_y) and isset($home_char_position_z))
         {
-          $this->db->query('UPDATE `characters` SET '.
+          $Realm->CharactersDatabase->query('UPDATE `characters` SET '.
             '`map` = "'.$home_char_map.'" , '.
             '`position_x` ="'.$home_char_position_x.'" , '.
@@ -182 +182 @@
   public function PlayerJail($guid)
   {
-    global $Config;
-
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
+    global $System, $Config;
+
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
     // .go xyz -90.54 41.35 -31.71
     // .go xyz -91.01 100.46 -31.71
@@ -208 +208 @@
     if(!$this->IsOnline($guid))
     {
-      $this->db->query('UPDATE `characters` SET `map` = 35 ,'.
+      $Realm->CharactersDatabase->query('UPDATE `characters` SET `map` = 35 ,'.
         '`orientation` = "'.$defined_positions['o'.$rand_place].'" ,'.
         '`position_x` ="'.$defined_positions['x'.$rand_place].'" ,'.
@@ -214 +214 @@
         '`position_z` = "'.$defined_positions['z'.$rand_place].'"'.
         ' WHERE `guid` ="'.$guid.'" LIMIT 1;');
-      $this->db->query('INSERT INTO `character_aura` (`guid`, `caster_guid`, `spell`, `effect_index`, `amount`, `maxduration`, `remaintime`, `remaincharges`) VALUES '.
+      $Realm->CharactersDatabase->query('INSERT INTO `character_aura` (`guid`, `caster_guid`, `spell`, `effect_index`, `amount`, `maxduration`, `remaintime`, `remaincharges`) VALUES '.
         '('.$guid.', '.$guid.', 23775, 0, 1, -1, -1, -1), '.
         '('.$guid.', '.$guid.', 36558, 0, 1, -1, -1, -1);');               
@@ -223 +223 @@
   public function IsOnline($guid)
   {
-    global $Config;
-
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
-    $row = $this->db->query('SELECT `online` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;')->fetch_assoc();
+    global $System, $Config;
+
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+    $row = $Realm->CharactersDatabase->query('SELECT `online` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;')->fetch_assoc();
     if($row['online'] == 1) return(true);
       else return(false);
@@ -258 +258 @@
   public function CharNameToGuid($name)
   {
-    global $Config;
-
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
-    $row = $this->db->query('SELECT `guid` FROM `characters` WHERE `name` LIKE "'.$name.'" LIMIT 1;')->fetch_assoc();
+    global $System, $Config;
+
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+    $row = $Realm->CharactersDatabase->query('SELECT `guid` FROM `characters` WHERE `name` LIKE "'.$name.'" LIMIT 1;')->fetch_assoc();
     if($row['guid'] != '')
     {
@@ -275 +275 @@
     global $Config;
 
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
-    $row = $this->db->query('SELECT `name` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;')->fetch_assoc();
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+    $row = $Realm->CharactersDatabase->query('SELECT `name` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;')->fetch_assoc();
     if($row['name'] != '')
     {
@@ -305 +305 @@
   {
     global $Config;
-
+  
     $this->db->select_db($Config['Mangos']['DatabaseRealmd']);
     $sha_pass = sha1(strtoupper($acc1_name).':'.strtoupper($acc1_pass));
@@ -344 +344 @@
   public function CharsOnAcc($accid)
   {
-    global $Config;
+    global $Config, $System;
     
     echo('<table class="BaseTable">
@@ -354 +354 @@
             <th>Nahráno</th>
           </tr>');
-    $this->db->select_db($Config['Mangos']['RealmList'][$_COOKIE['RealmIndex']]['DatabaseCharacters']);
-    echo($this->db->error);
-    $sql = $this->db->query('SELECT `guid`,`name`,`race`,`totaltime`,`class`, mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.($Config['Mangos']['CharacterDataOffset']['Gender'] + 1).'), " ",-1) AS unsigned) ), 8, 0), 4, 1) AS gender FROM `characters` WHERE `account`='.$accid.' ORDER BY `totaltime` DESC LIMIT 0, 10');
-    echo($this->db->error);
+    $Realm = new Realm($System, $_COOKIE['RealmIndex']);   
+    $sql = $Realm->CharactersDatabase->query('SELECT `guid`,`name`,`race`,`totaltime`,`class`, mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.($Config['Mangos']['CharacterDataOffset']['Gender'] + 1).'), " ",-1) AS unsigned) ), 8, 0), 4, 1) AS gender FROM `characters` WHERE `account`='.$accid.' ORDER BY `totaltime` DESC LIMIT 0, 10');
     while($row = $sql->fetch_array())
     {