Changeset 307 for minimanager/creature.php

Timestamp:

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

Author:

george

Message:

Aktualizace na minimanager 0.1.6g.

File:

• minimanager/creature.php (modified) (11 diffs)

minimanager/creature.php

@@ -11 +11 @@
 require_once("header.php");
 valid_login(1);
+include_once("./scripts/get_lib.php");
 
 // return npcflag
@@ -190 +191 @@
 function do_search() {
  global $lang_global, $lang_creature, $output, $mangos_db, $realm_id, $creature_datasite, $sql_search_limit,
-                $creature_type, $creature_npcflag;
+                $creature_type, $creature_npcflag, $language;
 
  if(
@@ -219 +220 @@
         else $custom_search = "";
 
- $where = "WHERE entry > 0 ";
+ $where = "WHERE creature_template.entry > 0 ";
  if($custom_search != "") $where .= "AND $custom_search ";
- if(isset($entry)) $where .= "AND entry = '$entry' ";
- if(isset($name)) $where .= "AND name LIKE '%$name%' ";
+ if(isset($entry)) $where .= "AND creature_template.entry = '$entry' ";
+ if(isset($name)) $where .= "AND IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) LIKE '%$name%' ";
  if(isset($level)) $where .= "AND minlevel <= $level AND maxlevel >= $level ";
  if(isset($health)) $where .= "AND minhealth <= $health AND maxhealth >= $health ";
@@ -235 +236 @@
  if(isset($spell)) $where .= "AND (spell1 = '$spell' OR spell2 = '$spell' OR spell3 = '$spell' OR spell4 = '$spell') ";
 
- if($where == "WHERE entry > 0 ") redirect("creature.php?error=1");
-
- $result = $sql->query("SELECT entry,name,maxlevel,maxhealth,rank,npcflag FROM creature_template $where ORDER BY entry LIMIT $sql_search_limit");
+ if($where == "WHERE creature_template.entry > 0 ") redirect("creature.php?error=1");
+
+ $deplang = get_lang_id();
+ $result = $sql->query("SELECT creature_template.entry, IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,maxlevel,maxhealth,rank,npcflag FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry $where ORDER BY creature_template.entry LIMIT $sql_search_limit");
  $total_found = $sql->num_rows($result);
 
@@ -679 +681 @@
 function edit() {
  global $lang_global, $lang_creature, $output, $mangos_db, $realm_id, $creature_datasite,$item_datasite,
-                $quest_datasite, $lang_id_tab, $spell_datasite, $lang_item;
-
+                $quest_datasite, $lang_id_tab, $spell_datasite, $lang_item,$language;
+ require_once("./scripts/get_lib.php");
  if (!isset($_GET['entry'])) redirect("creature.php?error=1");
 
@@ -687 +689 @@
 
  $entry = $sql->quote_smart($_GET['entry']);
- $result = $sql->query("SELECT * FROM creature_template WHERE entry = '$entry'");
+ $deplang = get_lang_id();
+ $result = $sql->query("SELECT `creature_template`.`entry`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`, IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,`subname`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`baseattacktime`,`rangeattacktime`,`flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`class`,`race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`civilian`,`flag1`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`RacialLeader`,`RegenHealth`,`equipment_id`,`ScriptName` FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE creature_template.entry = '$entry'");
+
 
  if ($mob = $sql->fetch_assoc($result)){
@@ -1218 +1222 @@
     </div>";
 
-require_once("scripts/get_lib.php");
-
 if($mob['lootid']){
 $output .= "<div id=\"pane5\">
@@ -1284 +1286 @@
         $result1 = $sql->query("SELECT quest FROM creature_questrelation WHERE id = {$mob['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);
 
@@ -1299 +1301 @@
         $result1 = $sql->query("SELECT quest FROM creature_involvedrelation WHERE id = {$mob['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);
 
@@ -1548 +1550 @@
 function do_update() {
  global $mangos_db, $realm_id;
+ $deplang = get_lang_id();
 
  if (!isset($_POST['opp_type']) || $_POST['opp_type'] === '') redirect("creature.php?error=1");
@@ -1827 +1830 @@
         $sql_query = "UPDATE creature_template SET  ";
 
-        $result = $sql->query("SELECT * FROM creature_template WHERE entry = '$entry'");
+        $result = $sql->query("SELECT `creature_template`.`entry`,`modelid_A`,`modelid_A2`,`modelid_H`,`modelid_H2`, IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,`subname`,`minlevel`,`maxlevel`,`minhealth`,`maxhealth`,`minmana`,`maxmana`,`armor`,`faction_A`,`faction_H`,`npcflag`,`speed`,`rank`,`mindmg`,`maxdmg`,`dmgschool`,`attackpower`,`baseattacktime`,`rangeattacktime`,`flags`,`dynamicflags`,`family`,`trainer_type`,`trainer_spell`,`class`,`race`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`civilian`,`flag1`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`RacialLeader`,`RegenHealth`,`equipment_id`,`ScriptName` FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE creature_template.entry = '$entry'");
         if ($mob_templ = $sql->fetch_assoc($result)){
                 if ($mob_templ['modelid_A'] != $modelid_A) $sql_query .= "modelid_A='$modelid_A',";