Changeset 307 for minimanager/scripts/del_lib.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/scripts/del_lib.php (modified) (5 diffs)

minimanager/scripts/del_lib.php

@@ -18 +18 @@
         $sql_01 = new SQL;
         $sql_01->connect($characters_db[$realm]['addr'], $characters_db[$realm]['user'], $characters_db[$realm]['pass'], $characters_db[$realm]['name']);
-        $query = $sql_01->query("SELECT account,online FROM `character` WHERE guid ='$guid' LIMIT 1");
+        $query = $sql_01->query("SELECT account,online FROM `characters` WHERE guid ='$guid' LIMIT 1");
         $owner_acc_id = $sql_01->result($query, 0, 'account');
         $sql_01->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
@@ -64 +64 @@
                 foreach ($characters_db as $db){
                         $sql_01->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
-                        $result = $sql_01->query("SELECT guid FROM `character` WHERE account='$acc_id'");
+                        $result = $sql_01->query("SELECT guid FROM `characters` WHERE account='$acc_id'");
                         while ($row = $sql_01->fetch_array($result)) {
                                         foreach ($tab_del_user_characters as $value)
@@ -100 +100 @@
         $query = $sql_01->query("DELETE FROM guild_rank WHERE guildid = '$guid'");
 
-        //clean data inside character.data field
+        //clean data inside characters.data field
         $temp = $sql_01->query("SELECT guid FROM guild_member WHERE guildid = '$guid'");
         while ($guild_member = $sql_01->fetch_row($temp)){
-                $char_data = $sql_01->query("SELECT data FROM `character` WHERE guid = '$guild_member[0]'");
+                $char_data = $sql_01->query("SELECT data FROM `characters` WHERE guid = '$guild_member[0]'");
                 $data = $sql_01->result($char_data, 0, 'data');
                 $data = explode(' ',$data);
@@ -109 +109 @@
                 $data[CHAR_DATA_OFFSET_GUILD_RANK] = 0;
                 $data = implode(" ",$data);
-                $query = $sql_01->query("UPDATE `character` SET data = '$data' WHERE guid = '$guild_member[0]'");
+                $query = $sql_01->query("UPDATE `characters` SET data = '$data' WHERE guid = '$guild_member[0]'");
                 }
 
@@ -123 +123 @@
 }
 
+//##########################################################################################
+//Delete Arena Team
+function del_arenateam($guid,$realm){
+        global $characters_db, $realm_db;
+
+        require_once("scripts/defines.php");
+
+        $sql_01 = new SQL;
+        $sql_01->connect($characters_db[$realm]['addr'], $characters_db[$realm]['user'], $characters_db[$realm]['pass'], $characters_db[$realm]['name']);
+        $query = $sql_01->query("DELETE FROM arena_team WHERE arenateamid = '$guid'");
+        $query = $sql_01->query("DELETE FROM arena_team_stats WHERE arenateamid = '$guid'");
+
+// Cant clean the character data field since the data is incorrect on these fields
+// http://wiki.udbforums.org/index.php/Character_data
+        //clean data inside characters.data field
+        //$temp = $sql_01->query("SELECT guid FROM arena_team_member WHERE arenateamid = '$guid'");
+        //while ($arenateam_member = $sql_01->fetch_row($temp)){
+        //      $char_data = $sql_01->query("SELECT data FROM `characters` WHERE guid = '$arenateam_member[0]'");
+        //      $data = $sql_01->result($char_data, 0, 'data');
+        //      $data = explode(' ',$data);
+        //      $data[CHAR_DATA_OFFSET_GUILD_ID] = 0;
+        //      $data[CHAR_DATA_OFFSET_GUILD_RANK] = 0;
+        //      $data = implode(" ",$data);
+        //      $query = $sql_01->query("UPDATE `characters` SET data = '$data' WHERE guid = '$arenateam_member[0]'");
+        //      }
+    //
+        $query = $sql_01->query("DELETE FROM arena_team_member WHERE arenateamid = '$guid'");
+
+        if ($sql_01->affected_rows()){
+                $sql_01->close();
+                return true;
+                } else {
+                                $sql_01->close();
+                                return false;
+                                }
+}
+
 ?>