Changeset 307 for minimanager/scripts/get_lib.php

Timestamp:

Mar 13, 2008, 8:18:42 PM (17 years ago)

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

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

minimanager/scripts/get_lib.php

@@ -24 +24 @@
 }
 
+//##########################################################################################
+//get DBC Language from config
+function get_lang_id() {
+        # DBC Language Settings
+        # 0 = English
+        # 1 = Korean
+        # 2 = French
+        # 3 = German
+        # 4 = Chinese
+        # 5 = Taiwanese
+        # 6 = Spanish
+        # 7 = Russian
+        # 8 = Unknown
+        # 9 = Unknown
+        # 10 = Unknown
+        # 11 = Unknown
+        # 12 = Unknown
+        # 13 = Unknown
+        # 14 = Unknown
+        # 15 = Unknown
+        global $language;
+        if (isset($_COOKIE["lang"])) $language=$_COOKIE["lang"];
+
+        switch ($language) {
+                        case 'frBE':
+                        case 'frFR':
+                        return 2;
+                        break;
+                        case 'deDE':
+                        return 3;
+                        break;
+                        case 'esAR':
+                        return 6;
+                        break;
+                        case 'ruRU':
+                        return 7;
+                        break;
+                        default:
+                        return 0;
+                        break;
+                }
+}
 
 //##########################################################################################
@@ -33 +75 @@
         $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'");
+        $deplang = get_lang_id();
+        $result = $sql_1->query("SELECT IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry WHERE item_template.entry = '$item_id'");
         $item_name = ($sql_1->num_rows($result) == 1) ? $sql_1->result($result, 0,"name") : "ItemID: $item_id Not Found" ;
 
@@ -45 +88 @@
 //generate item tooltip from item_template.entry
 function get_item_tooltip($item_id){
- global $lang_global, $lang_item, $lang_id_tab, $mangos_db, $realm_id, $itemset_id;
+ global $lang_global, $lang_item, $lang_id_tab, $mangos_db, $realm_id, $itemset_id, $language;
  if($item_id){
         $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']);
 
+        $deplang = get_lang_id();
         $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,
                 frost_res,arcane_res,shadow_res,spellid_1,spellid_2,spellid_3,spellid_4,spellid_5,
-                name,class,subclass,Quality,RequiredLevel,dmg_min1,dmg_max1,dmg_type1,dmg_min2,dmg_max2,dmg_type2,
+                IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",name),class,subclass,Quality,RequiredLevel,dmg_min1,dmg_max1,dmg_type1,dmg_min2,dmg_max2,dmg_type2,
                 dmg_min3,dmg_max3,dmg_type3,dmg_min4,dmg_max4,dmg_type4,dmg_min5,dmg_max5,dmg_type5,delay,bonding,
-                description,itemset,entry,InventoryType,ItemLevel,displayid,maxcount,spelltrigger_1,spelltrigger_2,
+                description,itemset,item_template.entry,InventoryType,ItemLevel,displayid,maxcount,spelltrigger_1,spelltrigger_2,
                 spelltrigger_3,spelltrigger_4,spelltrigger_5,ContainerSlots,spellcharges_1,spellcharges_2,spellcharges_3
                 spellcharges_4,spellcharges_5,AllowableClass,socketColor_1,socketColor_2,socketColor_3,RandomProperty,RandomSuffix
-                FROM item_template WHERE entry = '$item_id' LIMIT 1");
+                FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry WHERE item_template.entry = '$item_id' LIMIT 1");
         if ($item = $sql_1->fetch_row($result_1)) {
                 $tooltip = "";
@@ -607 +651 @@
 //##########################################################################################
 //get item icon - if icon not exists in INV folder D/L it from web.
+
 function get_icon($itemid) {
  global $proxy_cfg, $get_icons_from_web;
@@ -667 +712 @@
 }
 
+
 //##########################################################################################
 //generate item border from item_template.entry