Changeset 19 for minimanager/scripts/gen_lib.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/scripts/gen_lib.php (modified) (3 diffs)

minimanager/scripts/gen_lib.php

@@ -14 +14 @@
         global $lang_global, $mangos_db, $realm_id;
         
-        $mysql_0 = new MySQL;
-        $mysql_0->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name'],true);
+        $sql_0 = new SQL;
+        $sql_0->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
  
-        $result = $mysql_0->query("SELECT MAX(`id`) FROM item_text");
-        $item_page_id = ($mysql_0->result($result, 0)) + 1;
-        $result = $mysql_0->query("INSERT INTO item_text (id, text) VALUES ($item_page_id,'$body')");
+        $result = $sql_0->query("SELECT MAX(`id`) FROM item_text");
+        $item_page_id = ($sql_0->result($result, 0)) + 1;
+        $result = $sql_0->query("INSERT INTO item_text (id, text) VALUES ($item_page_id,'$body')");
 
-        $result = $mysql_0->query("SELECT MAX(`id`) FROM mail");
-        $mail_id = ($mysql_0->result($result, 0)) + 1;
+        $result = $sql_0->query("SELECT MAX(`id`) FROM mail");
+        $mail_id = ($sql_0->result($result, 0)) + 1;
 
         $item_guid = ($item) ? gen_item_instance($to, $item, $stack) : 0;
 
-        $sql = "INSERT INTO mail (id,messageType,sender,receiver,subject,itemTextId,item_guid,item_template,expire_time,deliver_time,money,cod,checked) 
-                        VALUES ($mail_id, 0, '$from', '$to', '$subject', '$item_page_id', '$item_guid', '$item', '".(time() + (30*24*3600))."','".(time()+5)."', '$gold', 0, 0)";
-        $result = $mysql_0->query($sql);
+        $result = $sql_0->query("INSERT INTO mail (id,messageType,sender,receiver,subject,itemTextId,item_guid,item_template,expire_time,deliver_time,money,cod,checked) 
+                        VALUES ($mail_id, 0, '$from', '$to', '$subject', '$item_page_id', '$item_guid', '$item', '".(time() + (30*24*3600))."','".(time()+5)."', '$gold', 0, 0)");
         
         if ($result) {
-                $mysql_0->close();
+                $sql_0->close();
                 return $mail_id;
         } else {
-                        $mysql_0->close();
+                        $sql_0->close();
                         return 0;
                         }
@@ -45 +44 @@
  global $lang_global, $mangos_db, $realm_id;
 
- $mysql_1 = new MySQL;
- $mysql_1->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name'],true);
+ $sql_1 = new SQL;
+ $sql_1->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
 
- $result = $mysql_1->query("SELECT MAX(guid) FROM item_instance");
- $guid = $mysql_1->result($result, 0) + 1;
+ $result = $sql_1->query("SELECT MAX(guid) FROM item_instance");
+ $guid = $sql_1->result($result, 0) + 1;
 
- $result = $mysql_1->query("SELECT flags,stackable,MaxDurability,spellcharges_1,spellcharges_2,
+ $result = $sql_1->query("SELECT flags,stackable,MaxDurability,spellcharges_1,spellcharges_2,
                                                         spellcharges_3,spellcharges_4,spellcharges_5 FROM item_template
                                                         WHERE entry = '$item_id'");
- $item_template = $mysql_1->fetch_row($result);
+ $item_template = $sql_1->fetch_row($result);
  
  if ($item_template[1] <= 1) $stack = 1;
@@ -86 +85 @@
  $data = implode(" ",$item_data);
 
- $result = $mysql_1->query("INSERT INTO item_instance (guid, owner_guid, data) VALUES ($guid, '$owner','$data')");
+ $result = $sql_1->query("INSERT INTO item_instance (guid, owner_guid, data) VALUES ($guid, '$owner','$data')");
  
  if ($result) {
-        $mysql_1->close();
+        $sql_1->close();
         return $guid;
  } else {
-                $mysql_1->close();
+                $sql_1->close();
                 return 0;
                 }