Changeset 142 for minimanager/scripts/gen_lib.php

Timestamp:

Nov 23, 2007, 11:29:33 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.5b

File:

• minimanager/scripts/gen_lib.php (modified) (3 diffs)

minimanager/scripts/gen_lib.php

@@ -12 +12 @@
 //SEND INGAME MAIL - SAFE TO USE ONLY WHILE SERVER IS OFFLINE
 function send_ingame_mail($to, $from, $subject, $body, $gold = 0, $item = 0, $stack = 1){
-        global $lang_global, $mangos_db, $realm_id;
+        global $lang_global, $characters_db, $realm_id;
         
         $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']);
+        $sql_0->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
  
         $result = $sql_0->query("SELECT MAX(`id`) FROM item_text");
@@ -42 +42 @@
 //GENERATE ITEM_NSTANCE ENTRY
 function gen_item_instance($owner, $item_id, $stack){
- global $lang_global, $mangos_db, $realm_id;
+ global $lang_global, $characters_db, $realm_id, $mangos_db;
 
  $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']);
+ $sql_1->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
  $result = $sql_1->query("SELECT MAX(guid) FROM item_instance");
@@ -51 +51 @@
 
  $result = $sql_1->query("SELECT flags,stackable,MaxDurability,spellcharges_1,spellcharges_2,
-                                                        spellcharges_3,spellcharges_4,spellcharges_5 FROM item_template
+                                                        spellcharges_3,spellcharges_4,spellcharges_5 FROM `".$mangos_db[$realm_id]['name']."`.`item_template`
                                                         WHERE entry = '$item_id'");
  $item_template = $sql_1->fetch_row($result);