Changeset 178 for minimanager/scripts/get_lib.php

Timestamp:

Dec 23, 2007, 2:55:36 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.6b

File:

• minimanager/scripts/get_lib.php (modified) (16 diffs)

minimanager/scripts/get_lib.php

@@ -49 +49 @@
         $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 = $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,
@@ -87 +87 @@
                         default:
                         }
-                                                
+
  $tooltip .= "<font color='white'>";
-                
+
         switch ($item[53]) {
                         case 1: //Binds when Picked Up
@@ -107 +107 @@
 
  if ($item[60]) $tooltip .= "{$lang_item['unique']}<br />";
- 
+
  $tooltip .= "<br />";
         switch ($item[57]) {
@@ -172 +172 @@
                         default:
                         }
-                                                
+
         switch ($item[33]) {
                         case 0: //Consumable
-                        $tooltip .= "{$lang_item['consumable']}<br />"; 
-                        break;
-                        
+                        $tooltip .= "{$lang_item['consumable']}<br />";
+                        break;
+
                         case 2: //Weapon
                                 switch ($item[34]) {
@@ -340 +340 @@
                                         }
                         break;
-                        
+
                         case 12: //Quest
                                 if ($item[53] != 4) $tooltip .= "{$lang_item['quest_item']}<br />";
                         break;
-                        
+
                         case 13: //key
                                 switch ($item[34]) {
@@ -358 +358 @@
                         default:
                 }
-                
+
         if ($item[20]) $tooltip .= "$item[20] {$lang_item['armor']}<br />";
 
@@ -365 +365 @@
                 $min_dmg_value = $item[$f];
                 $max_dmg_value = $item[$f+1];
-        
+
                 if ($min_dmg_value && $max_dmg_value){
                         switch ($dmg_type) {
@@ -389 +389 @@
                                 $tooltip .= "$min_dmg_value - $max_dmg_value {$lang_item['arcane_dmg']}<br />";
                         break;
-                        
+
                         default:
                         }
@@ -433 +433 @@
         if ($item[24]) $tooltip .= "$item[24] {$lang_item['res_frost']}<br />";
         if ($item[26]) $tooltip .= "$item[26] {$lang_item['res_shadow']}<br />";
-        
+
         //sockets
         for($p=72;$p<=74;$p++){
@@ -565 +565 @@
                         }
                 }
-        }       
+        }
         }
         //add equip spellid to status
@@ -586 +586 @@
                                 if ($item[$s1+40]) $tooltip.= abs($item[$s1+40])." {$lang_item['charges']}.<br />";
                         }
-                }                       
+                }
         }
 
         $tooltip .= "</font>";
-        
+
         if ($item[55]) {
                 include_once("itemset_tab.php");
                 $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'>''".str_replace("\"", " '", $item[54])."''</font>";
+        if ($item[54]) $tooltip .= "<br /><font color='orange'>''".str_replace("\"", " '", $item[54])."'</font>";
 
         } else $tooltip = "Item ID: $item_id Not Found" ;
@@ -610 +610 @@
  global $proxy_cfg, $get_icons_from_web;
  if (file_exists("img/INV/$itemid.jpg")) return "img/INV/$itemid.jpg";
- 
+
  if($get_icons_from_web){
         //only customitems have ids in this range.
         if ($itemid > 35000) return "img/INV/INV_blank_32.gif";
- 
+
         $xmlfilepath="http://www.wowhead.com/?item=";
         $proxy = $proxy_cfg['addr'];
@@ -636 +636 @@
         while ($fp && !feof($fp)) $temp .= fgets($fp, 4096);
         fclose($fp);
- 
+
     preg_match("~(Icon.create\('(.*?)')~", $temp, $temp);
         if (!isset($temp[2])) return "img/INV/INV_blank_32.gif";
         $temp[2] = strtolower($temp[2]);
-        
+
         //get the icon itself
         $fp = @fsockopen($proxy, $port, $errno, $errstr, 0.4);
@@ -647 +647 @@
         $out = "GET $file HTTP/1.0\r\nHost: $proxy\r\n";
         if (!empty($proxy_cfg['user'])) $out .= "Proxy-Authorization: Basic ". base64_encode ("{$proxy_cfg['user']}:{$proxy_cfg['pass']}")."\r\n";
-        $out .="Connection: Close\r\n\r\n";     
+        $out .="Connection: Close\r\n\r\n";
         fwrite($fp, $out);
 
@@ -660 +660 @@
         fclose($fp);
         fclose($img_file);
-        
+
         if (file_exists("img/INV/$itemid.jpg")) return "img/INV/$itemid.jpg";
                 else return "img/INV/INV_blank_32.gif";
@@ -666 +666 @@
         } else return "img/INV/INV_blank_32.gif";
 }
+
+//##########################################################################################
+//generate item border from item_template.entry
+function get_item_border($item_id){
+        global $lang_global, $lang_id_tab, $mangos_db, $realm_id, $itemset_id;
+        if($item_id){
+                $sql_2 = new SQL;
+                $sql_2->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+
+                $result_2 = $sql_2->query("SELECT Quality FROM item_template WHERE entry = '$item_id'");
+                $iborder = ($sql_2->num_rows($result_2) == 1) ? $sql_2->result($result_2, 0,"Quality"): "Quality: $iborder Not Found" ;
+
+        return "icon_border_$iborder";
+        }
+        else
+                return "icon_border_0";
+}
 ?>