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

minimanager/scripts/get_lib.php

@@ -14 +14 @@
  global $lang_global, $realm_db;
 
- $mysql_0 = new MySQL;
- $mysql_0->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
-
- $result = $mysql_0->query("SELECT name FROM `realmlist` WHERE id = '$realm_id'");
- $realm_name = $mysql_0->result($result, 0);
-
- $mysql_0->close();
+ $sql_0 = new SQL;
+ $sql_0->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
+
+ $result = $sql_0->query("SELECT name FROM `realmlist` WHERE id = '$realm_id'");
+ $realm_name = $sql_0->result($result, 0);
+
+ $sql_0->close();
  return $realm_name;
 }
@@ -30 +30 @@
  global $lang_global, $mangos_db, $realm_id;
  if($item_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']);
-
-        $result = $mysql_1->query("SELECT name FROM item_template WHERE entry = '$item_id'");
-        $item_name = ($mysql_1->num_rows($result) == 1) ? $mysql_1->result($result, 0,"name") : "ItemID: $item_id Not Found" ;
-
-        $mysql_1->close();
+        $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 = $sql_1->query("SELECT name FROM item_template WHERE entry = '$item_id'");
+        $item_name = ($sql_1->num_rows($result) == 1) ? $sql_1->result($result, 0,"name") : "ItemID: $item_id Not Found" ;
+
+        $sql_1->close();
         return $item_name;
  } else return NULL;
@@ -47 +47 @@
  global $lang_global, $lang_item, $lang_id_tab, $mangos_db, $realm_id, $itemset_id;
  if($item_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']);
+        $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_1 = $mysql_1->query("SELECT stat_type1,stat_value1,stat_type2,stat_value2,stat_type3,stat_value3,stat_type4,
+        $result_1 = $sql_1->query("SELECT stat_type1,stat_value1,stat_type2,stat_value2,stat_type3,stat_value3,stat_type4,
                 stat_value4,stat_type5,stat_value5,stat_type6,stat_value6,stat_type7,stat_value7,stat_type8,
                 stat_value8,stat_type9,stat_value9,stat_type10,stat_value10,armor,holy_res,fire_res,nature_res,
@@ -60 +60 @@
                 spellcharges_4,spellcharges_5,AllowableClass,socketColor_1,socketColor_2,socketColor_3,RandomProperty,RandomSuffix
                 FROM item_template WHERE entry = '$item_id' LIMIT 1");
-        if ($item = $mysql_1->fetch_row($result_1)) {
+        if ($item = $sql_1->fetch_row($result_1)) {
                 $tooltip = "";
 
@@ -439 +439 @@
                         switch ($item[$p]) {
                                 case 1:
-                                $tooltip .= "<img src='img/socket_meta.gif' class='no_border' alt='' /><font color='gray'> {$lang_item['socket_meta']}</font><br />";
+                                $tooltip .= "<img src='img/socket_meta.gif' alt='' /><font color='gray'> {$lang_item['socket_meta']}</font><br />";
                                 break;
                                 case 2:
-                                $tooltip .= "<img src='img/socket_red.gif' class='no_border' alt='' /><font color='red'> {$lang_item['socket_red']}</font><br />";
+                                $tooltip .= "<img src='img/socket_red.gif' alt='' /><font color='red'> {$lang_item['socket_red']}</font><br />";
                                 break;
                                 case 4:
-                                $tooltip .= "<img src='img/socket_yellow.gif' class='no_border' alt='' /><font color='yellow'> {$lang_item['socket_yellow']}</font><br />";
+                                $tooltip .= "<img src='img/socket_yellow.gif' alt='' /><font color='yellow'> {$lang_item['socket_yellow']}</font><br />";
                                 break;
                                 case 8:
-                                $tooltip .= "<img src='img/socket_blue.gif' class='no_border' alt='' /><font color='blue'> {$lang_item['socket_blue']}</font><br />";
+                                $tooltip .= "<img src='img/socket_blue.gif' alt='' /><font color='blue'> {$lang_item['socket_blue']}</font><br />";
                                 break;
                         default:
@@ -595 +595 @@
                 $tooltip .= "<br /><font color='orange'>{$lang_item['item_set']} : ".get_itemset_name($item[55])." ($item[55])</font>";
                 }
-        if ($item[54]) $tooltip .= "<br /><font color='orange'>''$item[54]''</font>";
+        if ($item[54]) $tooltip .= "<br /><font color='orange'>''".str_replace("\"", " '", $item[54])."''</font>";
 
         } else $tooltip = "Item ID: $item_id Not Found" ;
 
-        $mysql_1->close();
+        $sql_1->close();
         return $tooltip;
  } else return(NULL);