Changeset 307 for minimanager/game_object.php

Timestamp:

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

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/game_object.php (modified) (7 diffs)

minimanager/game_object.php

@@ -126 +126 @@
  global $lang_global, $lang_game_object, $output, $mangos_db, $realm_id, $go_datasite, $sql_search_limit,
                 $go_type;
+        require_once("./scripts/get_lib.php");
+        $deplang = get_lang_id();
 
  if((!isset($_POST['entry'])||$_POST['entry'] === '')&&(!isset($_POST['name'])||$_POST['name'] === '')&&(!isset($_POST['ScriptName'])||$_POST['ScriptName'] === '')&&(!isset($_POST['displayId'])||$_POST['displayId'] === '')
@@ -146 +148 @@
         else $custom_search = "";
 
- $where = "WHERE entry > 0 ";
+ $where = "WHERE gameobject_template.entry > 0 ";
  if($custom_search != "") $where .= " $custom_search ";
  if(isset($entry)) $where .= "AND entry = '$entry' ";
- if(isset($name)) $where .= "AND name LIKE '%$name%' ";
+ if(isset($name)) $where .= "AND IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) LIKE '%$name%' ";
  if(isset($type)) $where .= "AND type = '$type' ";
  if(isset($ScriptName)) $where .= "AND ScriptName LIKE '%$ScriptName%' "; 
@@ -156 +158 @@
  if(isset($flags)) $where .= "AND flags = '$flags' ";
  
- if($where == "WHERE entry > 0 ") redirect("game_object.php?error=1");
-
- $result = $sql->query("SELECT entry, type, displayId, name, faction FROM gameobject_template $where ORDER BY entry LIMIT $sql_search_limit");
+ if($where == "WHERE gameobject_template.entry > 0 ") redirect("game_object.php?error=1");
+ $result = $sql->query("SELECT gameobject_template.entry, type, displayId, IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name, faction FROM gameobject_template LEFT JOIN locales_gameobject ON gameobject_template.entry = locales_gameobject.entry $where ORDER BY gameobject_template.entry LIMIT $sql_search_limit");
  $total_found = $sql->num_rows($result);
 
@@ -368 +369 @@
  
  $entry = $sql->quote_smart($_GET['entry']);
- $result = $sql->query("SELECT * FROM gameobject_template WHERE entry = '$entry'");
+ require_once("./scripts/get_lib.php");
+ $deplang = get_lang_id();
+ $result = $sql->query("SELECT gameobject_template.`entry`,`type`,`displayId`,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,`faction`,`flags`,`size`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`ScriptName` FROM gameobject_template LEFT JOIN locales_gameobject ON gameobject_template.entry = locales_gameobject.entry WHERE gameobject_template.entry = '$entry'");
 
  if ($go = $sql->fetch_assoc($result)){
@@ -587 +590 @@
         $result1 = $sql->query("SELECT quest FROM gameobject_questrelation WHERE id = {$go['entry']}");
         while ($quest = $sql->fetch_row($result1)){
-                $query1 = $sql->query("SELECT QuestLevel,Title FROM quest_template WHERE entry ='$quest[0]'");
+                $query1 = $sql->query("SELECT QuestLevel, IFNULL(".($deplang<>0?"title_loc$deplang":"NULL").",`title`) as Title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='$quest[0]'");
                 $quest_templ = $sql->fetch_row($query1);
                 
@@ -602 +605 @@
         $result1 = $sql->query("SELECT quest FROM gameobject_involvedrelation WHERE id = {$go['entry']}");
         while ($quest = $sql->fetch_row($result1)){
-                $query1 = $sql->query("SELECT QuestLevel,Title FROM quest_template WHERE entry ='$quest[0]'");
+                $query1 = $sql->query("SELECT QuestLevel, IFNULL(".($deplang<>0?"title_loc$deplang":"NULL").",`title`) as Title FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE quest_template.entry ='$quest[0]'");
                 $quest_templ = $sql->fetch_row($query1);
                 
@@ -762 +765 @@
         $sql_query = "UPDATE gameobject_template SET ";
 
-        $result = $sql->query("SELECT * FROM gameobject_template WHERE entry = '$entry'");
+        $result = $sql->query("SELECT gameobject_template.`entry`,`type`,`displayId`,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,`faction`,`flags`,`size`,`data0`,`data1`,`data2`,`data3`,`data4`,`data5`,`data6`,`data7`,`data8`,`data9`,`data10`,`data11`,`data12`,`data13`,`data14`,`data15`,`data16`,`data17`,`data18`,`data19`,`data20`,`data21`,`data22`,`data23`,`ScriptName` FROM gameobject_template LEFT JOIN locales_gameobject ON gameobject_template.entry = locales_gameobject.entry WHERE gameobject_template.entry = '$entry'");
         if ($go_templ = $sql->fetch_assoc($result)){
                 if ($go_templ['type'] != $type) $sql_query .= "type='$type',";