Changeset 19 for minimanager/edit.php

Timestamp:

Aug 13, 2007, 9:05:34 PM (17 years ago)

Author:

george

Message:

Aktualizace MaNGOS Minimanageru na verzi 0.1.4a.

File:

• minimanager/edit.php (modified) (5 diffs)

minimanager/edit.php

@@ -19 +19 @@
                 $lang_id_tab, $gm_level_arr;
 
- $mysql = new MySQL;
- $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
-
- $result = $mysql->query("SELECT email,gmlevel,joindate,tbc FROM account WHERE username ='$user_name'");
-
- if ($acc = $mysql->fetch_row($result)) {
+ $sql = new SQL;
+ $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
+
+ $result = $sql->query("SELECT email,gmlevel,joindate,tbc FROM account WHERE username ='$user_name'");
+
+ if ($acc = $sql->fetch_row($result)) {
   require_once("scripts/id_tab.php");
  
@@ -79 +79 @@
       </tr>";
 
-        $result = $mysql->query("SELECT SUM(numchars) FROM realmcharacters WHERE acctid = '$user_id'");
+        $result = $sql->query("SELECT SUM(numchars) FROM realmcharacters WHERE acctid = '$user_id'");
         $output .= "<tr>
         <td>{$lang_edit['tot_chars']}</td>
-        <td>".$mysql->result($result, 0)."</td>
+        <td>".$sql->result($result, 0)."</td>
       </tr>";
           
-        $mysql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
-        $result = $mysql->query("SELECT guid,name,race,class,SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) FROM `character` WHERE account = $user_id");
-        $chars_on_realm = $mysql->num_rows($result);
+        $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+        $result = $sql->query("SELECT guid,name,race,class,SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) FROM `character` WHERE account = $user_id");
 
         $output .= "<tr>
         <td>{$lang_edit['characters']}</td>
-        <td>$chars_on_realm</td>
+        <td>".$sql->num_rows($result)."</td>
       </tr>";
 
-        while ($char = $mysql->fetch_array($result)){
+        while ($char = $sql->fetch_array($result)){
                 $output .= "<tr> 
                 <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'---></td>
@@ -171 +170 @@
  } else error($lang_global['err_no_records_found']);
  
- $mysql->close();
+ $sql->close();
 }
 
@@ -184 +183 @@
         redirect("edit.php?error=1");
 
- $mysql = new MySQL;
- $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
-
- $new_pass = ($mysql->quote_smart($_POST['pass']) != sha1(strtoupper($user_name).":******")) ? "I='".$mysql->quote_smart($_POST['pass'])."', " : "";
- $new_mail = $mysql->quote_smart(trim($_POST['mail']));
- $new_tbc = $mysql->quote_smart(trim($_POST['tbc']));
+ $sql = new SQL;
+ $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
+
+ $new_pass = ($sql->quote_smart($_POST['pass']) != sha1(strtoupper($user_name).":******")) ? "I='".$sql->quote_smart($_POST['pass'])."', " : "";
+ $new_mail = $sql->quote_smart(trim($_POST['mail']));
+ $new_tbc = $sql->quote_smart(trim($_POST['tbc']));
  
  //make sure the mail is valid mail format
@@ -195 +194 @@
  if ((!is_email($new_mail))||(strlen($new_mail)  > 224)) redirect("edit.php?error=2");
 
- $mysql->query("UPDATE account SET email='$new_mail', $new_pass tbc='$new_tbc' WHERE username = '$user_name'");
-
- if ($mysql->affected_rows()) {
-        $mysql->close();
+ $sql->query("UPDATE account SET email='$new_mail', $new_pass tbc='$new_tbc' WHERE username = '$user_name'");
+
+ if ($sql->affected_rows()) {
+        $sql->close();
         redirect("edit.php?error=3");
     } else {
-                $mysql->close();
+                $sql->close();
                 redirect("edit.php?error=4");
         }