Changeset 142 for minimanager/creature.php

Timestamp:

Nov 23, 2007, 11:29:33 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.5b

File:

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

minimanager/creature.php

@@ -7 +7 @@
  * Email: *****
  * License: GNU General Public License v2(GPL)
+ * modded by melefire for rev 4500 and up
  */
 require_once("header.php");
@@ -59 +60 @@
 
  $output .= "<center>
- <fieldset style=\"width: 760px;\">
+ <fieldset class=\"full_frame\">
         <legend>{$lang_creature['search_template']}</legend><br />
         <form action=\"creature.php?action=do_search&amp;error=2\" method=\"post\" name=\"form\">
@@ -75 +76 @@
                 <td>{$lang_creature['health']}:</td>
                 <td><input type=\"text\" size=\"10\" maxlength=\"5\" name=\"health\" /></td>
-                <td>{$lang_creature['faction']}:</td>
-                <td><input type=\"text\" size=\"10\" maxlength=\"4\" name=\"faction\" /></td>
+                <td>{$lang_creature['faction_A']}:</td>
+                <td><input type=\"text\" size=\"10\" maxlength=\"4\" name=\"faction_A\" /></td>
         </tr>
         <tr>
@@ -190 +191 @@
         ($_POST['npcflag'] === '')&&($_POST['type'] === '')&&($_POST['rank'] === '')&&($_POST['family'] === '')
         &&(!isset($_POST['entry'])||$_POST['entry'] === '')&&(!isset($_POST['name'])||$_POST['name'] === '')&&(!isset($_POST['level'])||$_POST['level'] === '')&&(!isset($_POST['health'])||$_POST['health'] === '')
-        &&(!isset($_POST['faction'])||$_POST['faction'] === '')&&(!isset($_POST['spell'])||$_POST['spell'] === '')&&(!isset($_POST['lootid'])||$_POST['lootid'] === '')&&(!isset($_POST['ScriptName'])||$_POST['ScriptName'] === '')
+        &&(!isset($_POST['faction_A'])||$_POST['faction_A'] === '')&&(!isset($_POST['spell'])||$_POST['spell'] === '')&&(!isset($_POST['lootid'])||$_POST['lootid'] === '')&&(!isset($_POST['ScriptName'])||$_POST['ScriptName'] === '')
         &&(!isset($_POST['custom_search'])||$_POST['custom_search'] === '')) {
         redirect("creature.php?error=1");
@@ -206 +207 @@
 if ($_POST['level'] != '') $level = $sql->quote_smart($_POST['level']);
 if ($_POST['health'] != '') $health = $sql->quote_smart($_POST['health']);
-if ($_POST['faction'] != '') $faction = $sql->quote_smart($_POST['faction']);
+if ($_POST['faction_A'] != '') $faction = $sql->quote_smart($_POST['faction_A']);
 if ($_POST['spell'] != '') $spell = $sql->quote_smart($_POST['spell']);
 if ($_POST['lootid'] != '') $lootid = $sql->quote_smart($_POST['lootid']);
@@ -219 +220 @@
  if(isset($level)) $where .= "AND minlevel <= $level AND maxlevel >= $level ";
  if(isset($health)) $where .= "AND minhealth <= $health AND maxhealth >= $health ";
- if(isset($faction)) $where .= "AND faction = '$faction' ";
+ if(isset($faction_A)) $where .= "AND faction = '$faction_A' ";
  if(isset($lootid)) $where .= "AND lootid = '$lootid' ";
  if(isset($ScriptName)) $where .= "AND ScriptName LIKE '%$ScriptName%' "; 
@@ -273 +274 @@
 //########################################################################################################################
 function add_new() {
- global $lang_global, $lang_creature, $lang_item, $lang_creature, $output, $item_datasite, $lang_id_tab;
+ global $lang_global, $lang_creature, $lang_item, $lang_creature, $output, $item_datasite,
+                $lang_id_tab, $lang_item;
 
  $output .= "<script type=\"text/javascript\" src=\"js/tab.js\"></script>
@@ -341 +343 @@
 </tr> 
 <tr>
- <td>".makeinfocell($lang_creature['faction'],$lang_creature['faction_desc'])."</td>
- <td colspan=\"2\"><input type=\"text\" name=\"faction\" size=\"14\" maxlength=\"10\" value=\"0\" /></td>
+ <td>".makeinfocell($lang_creature['faction_A'],$lang_creature['faction_A_desc'])."</td>
+ <td colspan=\"2\"><input type=\"text\" name=\"faction_A\" size=\"14\" maxlength=\"10\" value=\"0\" /></td>
 
  <td>".makeinfocell($lang_creature['type'],$lang_creature['type_desc'])."</td>
@@ -451 +453 @@
          <tr>
           <td>".makeinfocell($lang_creature['armor'],$lang_creature['armor_desc'])."</td>
-          <td><input type=\"text\" name=\"armor\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
+          <td colspan=\"2\"><input type=\"text\" name=\"armor\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
          
           <td>".makeinfocell($lang_creature['speed'],$lang_creature['speed_desc'])."</td>
-          <td><input type=\"text\" name=\"speed\" size=\"8\" maxlength=\"45\" value=\"1\" /></td>
- 
-          <td>".makeinfocell($lang_creature['size'],$lang_creature['size_desc'])."</td>
-          <td><input type=\"text\" name=\"size\" size=\"8\" maxlength=\"45\" value=\"1\" /></td>
+          <td colspan=\"2\"><input type=\"text\" name=\"speed\" size=\"8\" maxlength=\"45\" value=\"1\" /></td>
  </tr>
  
@@ -492 +491 @@
  </tr>
  <tr>
-          <td colspan=\"3\">".makeinfocell($lang_creature['bounding_radius'],$lang_creature['bounding_radius_desc'])."</td>
-          <td colspan=\"3\"><input type=\"text\" name=\"bounding_radius\" size=\"14\" maxlength=\"45\" value=\"2\" /></td>
+          <td>".makeinfocell($lang_creature['bounding_radius'],$lang_creature['bounding_radius_desc'])."</td>
+          <td colspan=\"2\"><input type=\"text\" name=\"bounding_radius\" size=\"14\" maxlength=\"45\" value=\"2\" /></td>
+          
+          <td>".makeinfocell($lang_creature['dmgschool'],$lang_creature['dmgschool_desc'])."</td>
+           <td colspan=\"2\"><select name=\"dmgschool\">
+                <option value=\"0\">0: {$lang_item['physical_dmg']}</option>
+                <option value=\"1\">1: {$lang_item['holy_dmg']}</option>
+                <option value=\"2\">2: {$lang_item['fire_dmg']}</option>
+                <option value=\"3\">3: {$lang_item['nature_dmg']}</option>
+                <option value=\"4\">4: {$lang_item['frost_dmg']}</option>
+                <option value=\"5\">5: {$lang_item['shadow_dmg']}</option>
+                <option value=\"6\">6: {$lang_item['arcane_dmg']}</option>
+           </select></td>
  </tr>
  
@@ -543 +553 @@
 <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['models']}:</td></tr>
 <tr>
-        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_male'],$lang_creature['modelid_male_desc'])."</td>
-        <td><input type=\"text\" name=\"modelid_m\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>
-         
-        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_female'],$lang_creature['modelid_female_desc'])."</td>
-        <td><input type=\"text\" name=\"modelid_f\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>
+        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_Aale'],$lang_creature['modelid_Aale_desc'])."</td>
+        <td><input type=\"text\" name=\"modelid_A\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>
+         
+        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_Hemale'],$lang_creature['modelid_Hemale_desc'])."</td>
+        <td><input type=\"text\" name=\"modelid_H\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>
 </tr>
 <tr>
@@ -680 +690 @@
 function edit() {
  global $lang_global, $lang_creature, $output, $mangos_db, $realm_id, $creature_datasite,$item_datasite,
-                $quest_datasite, $lang_id_tab, $spell_datasite;
+                $quest_datasite, $lang_id_tab, $spell_datasite, $lang_item;
 
  if (!isset($_GET['entry'])) redirect("creature.php?error=1");
@@ -798 +808 @@
 
 <tr>
- <td>".makeinfocell($lang_creature['faction'],$lang_creature['faction_desc'])."</td>
- <td colspan=\"2\"><input type=\"text\" name=\"faction\" size=\"14\" maxlength=\"5\" value=\"{$mob['faction']}\" /></td>";
+ <td>".makeinfocell($lang_creature['faction_A'],$lang_creature['faction_A_desc'])."</td>
+ <td colspan=\"2\"><input type=\"text\" name=\"faction_A\" size=\"14\" maxlength=\"5\" value=\"{$mob['faction_A']}\" /></td>";
  unset($rank);
  
@@ -875 +885 @@
                 <option value=\"2\" {$trainer_type[2]}>2 - {$lang_creature['trade_skill']}</option>
                 <option value=\"3\" {$trainer_type[3]}>3 - {$lang_creature['pets']}</option>
-           </select></td>   
+           </select></td>
 </tr>
 <tr>";
@@ -950 +960 @@
          <tr>
           <td>".makeinfocell($lang_creature['armor'],$lang_creature['armor_desc'])."</td>
-          <td><input type=\"text\" name=\"armor\" size=\"8\" maxlength=\"10\" value=\"{$mob['armor']}\" /></td>
+          <td colspan=\"2\"><input type=\"text\" name=\"armor\" size=\"8\" maxlength=\"10\" value=\"{$mob['armor']}\" /></td>
          
           <td>".makeinfocell($lang_creature['speed'],$lang_creature['speed_desc'])."</td>
-          <td><input type=\"text\" name=\"speed\" size=\"8\" maxlength=\"45\" value=\"{$mob['speed']}\" /></td>
- 
-          <td>".makeinfocell($lang_creature['size'],$lang_creature['size_desc'])."</td>
-          <td><input type=\"text\" name=\"size\" size=\"8\" maxlength=\"45\" value=\"{$mob['size']}\" /></td>
+          <td colspan=\"2\"><input type=\"text\" name=\"speed\" size=\"8\" maxlength=\"45\" value=\"{$mob['speed']}\" /></td>
  </tr>
  
@@ -991 +998 @@
  </tr>
  <tr>
-          <td colspan=\"3\">".makeinfocell($lang_creature['bounding_radius'],$lang_creature['bounding_radius_desc'])."</td>
-          <td colspan=\"3\"><input type=\"text\" name=\"bounding_radius\" size=\"14\" maxlength=\"45\" value=\"{$mob['bounding_radius']}\" /></td>
- </tr>
- 
+          <td>".makeinfocell($lang_creature['bounding_radius'],$lang_creature['bounding_radius_desc'])."</td>
+          <td colspan=\"2\"><input type=\"text\" name=\"bounding_radius\" size=\"14\" maxlength=\"45\" value=\"{$mob['bounding_radius']}\" /></td>";
+          
+          
+ $dmgschool = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "");
+ $dmgschool[$mob['dmgschool']] = " selected=\"selected\" ";
+ 
+ $output .= "<td>".makeinfocell($lang_creature['dmgschool'],$lang_creature['dmgschool_desc'])."</td>
+           <td colspan=\"2\"><select name=\"dmgschool\">
+                <option value=\"0\" {$dmgschool[0]}>0: {$lang_item['physical_dmg']}</option>
+                <option value=\"1\" {$dmgschool[1]}>1: {$lang_item['holy_dmg']}</option>
+                <option value=\"2\" {$dmgschool[2]}>2: {$lang_item['fire_dmg']}</option>
+                <option value=\"3\" {$dmgschool[3]}>3: {$lang_item['nature_dmg']}</option>
+                <option value=\"4\" {$dmgschool[4]}>4: {$lang_item['frost_dmg']}</option>
+                <option value=\"5\" {$dmgschool[5]}>5: {$lang_item['shadow_dmg']}</option>
+                <option value=\"6\" {$dmgschool[6]}>6: {$lang_item['arcane_dmg']}</option>
+           </select></td>";
+ unset($dmgschool);
+ 
+$output .= "</tr>
 <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['spells']}:</td></tr>
 
@@ -1041 +1064 @@
 <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_creature['models']}:</td></tr>
 <tr>
-        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_male'],$lang_creature['modelid_male_desc'])."</td>
-        <td><input type=\"text\" name=\"modelid_m\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid_m']}\" /></td>
-         
-        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_female'],$lang_creature['modelid_female_desc'])."</td>
-        <td><input type=\"text\" name=\"modelid_f\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid_f']}\" /></td>
+        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_Aale'],$lang_creature['modelid_Aale_desc'])."</td>
+        <td><input type=\"text\" name=\"modelid_A\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid_A']}\" /></td>
+         
+        <td colspan=\"2\">".makeinfocell($lang_creature['modelid_Hemale'],$lang_creature['modelid_Hemale_desc'])."</td>
+        <td><input type=\"text\" name=\"modelid_H\" size=\"8\" maxlength=\"11\" value=\"{$mob['modelid_H']}\" /></td>
 </tr>
 <tr>
@@ -1185 +1208 @@
         $row_flag = 0;
         $output .= "<table class=\"hidden\" align=\"center\"><tr>";
-        $result1 = $sql->query("SELECT item,ChanceOrRef,QuestChanceOrGroup,mincount,maxcount,quest_freeforall FROM creature_loot_template WHERE entry = {$mob['lootid']} ORDER BY ChanceOrRef DESC");
+        $result1 = $sql->query("SELECT item,ChanceOrRef,QuestChanceOrGroup,mincount,maxcount,freeforall, lootcondition, condition_value1,condition_value2 FROM creature_loot_template WHERE entry = {$mob['lootid']} ORDER BY ChanceOrRef DESC");
         while ($item = $sql->fetch_row($result1)){
                 $cel_counter++;
-                $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_creature['drop_chance']}: $item[1]%<br />{$lang_creature['quest_drop_chance']}: $item[2]%<br />{$lang_creature['drop_chance']}: $item[3]-$item[4]<br />{$lang_creature['quest_freeforall']}: $item[5]";
+                $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_creature['drop_chance']}: $item[1]%<br />{$lang_creature['quest_drop_chance']}: $item[2]%<br />{$lang_creature['drop_chance']}: $item[3]-$item[4]<br />{$lang_creature['freeforall']}: $item[5]<br />{$lang_creature['lootcondition']}: $item[6]<br />{$lang_creature['condition_value1']}: $item[7]<br />{$lang_creature['condition_value2']}: $item[8]";
                 $output .= "<td>";
                 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip");
@@ -1217 +1240 @@
 <td>".makeinfocell($lang_creature['max_count'],$lang_creature['max_count_desc'])."</td>
         <td><input type=\"text\" name=\"maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
-<td>".makeinfocell($lang_creature['quest_loot'],$lang_creature['quest_loot_desc'])."</td>
-        <td><input type=\"text\" name=\"quest_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
+<td>".makeinfocell($lang_creature['freeforall'],$lang_creature['freeforall_desc'])."</td>
+        <td><input type=\"text\" name=\"freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
+</tr>
+<tr>
+<td>".makeinfocell($lang_creature['lootcondition'],$lang_creature['lootcondition_desc'])."</td>
+        <td><input type=\"text\" name=\"lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
+<td>".makeinfocell($lang_creature['condition_value1'],$lang_creature['condition_value1_desc'])."</td>
+        <td><input type=\"text\" name=\"condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
+<td>".makeinfocell($lang_creature['condition_value2'],$lang_creature['condition_value2_desc'])."</td>
+        <td><input type=\"text\" name=\"condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
 </tr>
 </table><br />{$lang_creature['check_to_delete']}<br /><br />
@@ -1359 +1390 @@
         $row_flag = 0;
         $output .= "<table class=\"hidden\" align=\"center\"><tr>";
-        $result1 = $sql->query("SELECT item,ChanceOrRef,QuestChanceOrGroup,mincount,maxcount,quest_freeforall FROM skinning_loot_template WHERE entry = {$mob['skinloot']} ORDER BY ChanceOrRef DESC");
+        $result1 = $sql->query("SELECT item,ChanceOrRef,QuestChanceOrGroup,mincount,maxcount,freeforall, lootcondition, condition_value1, condition_value2 FROM skinning_loot_template WHERE entry = {$mob['skinloot']} ORDER BY ChanceOrRef DESC");
         while ($item = $sql->fetch_row($result1)){
                 $cel_counter++;
-                $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_creature['drop_chance']}: $item[1]%<br />{$lang_creature['quest_drop_chance']}: $item[2]%<br />{$lang_creature['drop_chance']}: $item[3]-$item[4]<br />{$lang_creature['quest_freeforall']}: $item[5]";
+                $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_creature['drop_chance']}: $item[1]%<br />{$lang_creature['quest_drop_chance']}: $item[2]%<br />{$lang_creature['drop_chance']}: $item[3]-$item[4]<br />{$lang_creature['freeforall']}: $item[5]<br />{$lang_creature['lootcondition']}: $item[6]<br />{$lang_creature['condition_value1']}: $item[7]<br />{$lang_creature['condition_value2']}: $item[8]";
                 $output .= "<td>";
                 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip");
@@ -1391 +1422 @@
 <td>".makeinfocell($lang_creature['max_count'],$lang_creature['max_count_desc'])."</td>
         <td><input type=\"text\" name=\"skin_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
-<td>".makeinfocell($lang_creature['quest_loot'],$lang_creature['quest_loot_desc'])."</td>
-        <td><input type=\"text\" name=\"skin_quest_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
+<td>".makeinfocell($lang_creature['freeforall'],$lang_creature['freeforall_desc'])."</td>
+        <td><input type=\"text\" name=\"skin_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
+</tr>
+<tr>
+<td>".makeinfocell($lang_creature['lootcondition'],$lang_creature['lootcondition_desc'])."</td>
+        <td><input type=\"text\" name=\"skin_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
+<td>".makeinfocell($lang_creature['condition_value1'],$lang_creature['condition_value1_desc'])."</td>
+        <td><input type=\"text\" name=\"skin_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
+<td>".makeinfocell($lang_creature['condition_value2'],$lang_creature['condition_value2_desc'])."</td>
+        <td><input type=\"text\" name=\"skin_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
 </tr>
 </table><br />{$lang_creature['check_to_delete']}<br /><br />
@@ -1408 +1447 @@
         $row_flag = 0;
         $output .= "<table class=\"hidden\" align=\"center\"><tr>";
-        $result1 = $sql->query("SELECT item,ChanceOrRef,QuestChanceOrGroup,mincount,maxcount,quest_freeforall FROM pickpocketing_loot_template WHERE entry = {$mob['pickpocketloot']} ORDER BY ChanceOrRef DESC");
+        $result1 = $sql->query("SELECT item,ChanceOrRef,QuestChanceOrGroup,mincount,maxcount,freeforall, lootcondition, condition_value1, condition_value2 FROM pickpocketing_loot_template WHERE entry = {$mob['pickpocketloot']} ORDER BY ChanceOrRef DESC");
         while ($item = $sql->fetch_row($result1)){
                 $cel_counter++;
-                $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_creature['drop_chance']}: $item[1]%<br />{$lang_creature['quest_drop_chance']}: $item[2]%<br />{$lang_creature['drop_chance']}: $item[3]-$item[4]<br />{$lang_creature['quest_freeforall']}: $item[5]";
+                $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_creature['drop_chance']}: $item[1]%<br />{$lang_creature['quest_drop_chance']}: $item[2]%<br />{$lang_creature['drop_chance']}: $item[3]-$item[4]<br />{$lang_creature['freeforall']}: $item[5]<br />{$lang_creature['lootcondition']}: $item[6]<br />{$lang_creature['condition_value1']}: $item[7]<br />{$lang_creature['condition_value2']}: $item[8]";
                 $output .= "<td>";
                 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip");
@@ -1440 +1479 @@
 <td>".makeinfocell($lang_creature['max_count'],$lang_creature['max_count_desc'])."</td>
         <td><input type=\"text\" name=\"pp_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
-<td>".makeinfocell($lang_creature['quest_loot'],$lang_creature['quest_loot_desc'])."</td>
-        <td><input type=\"text\" name=\"pp_quest_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
+<td>".makeinfocell($lang_creature['freeforall'],$lang_creature['freeforall_desc'])."</td>
+        <td><input type=\"text\" name=\"pp_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
+</tr>
+<tr>
+<td>".makeinfocell($lang_creature['lootcondition'],$lang_creature['lootcondition_desc'])."</td>
+        <td><input type=\"text\" name=\"pp_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
+<td>".makeinfocell($lang_creature['condition_value1'],$lang_creature['condition_value1_desc'])."</td>
+        <td><input type=\"text\" name=\"pp_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
+<td>".makeinfocell($lang_creature['condition_value2'],$lang_creature['condition_value2_desc'])."</td>
+        <td><input type=\"text\" name=\"pp_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
 </tr>
 </table><br />{$lang_creature['check_to_delete']}<br /><br />
@@ -1476 +1523 @@
 //DO UPDATE CREATURE TEMPLATE
 //########################################################################################################################
+//Now We are going to clone the faction variable to the H faction for newer revision support. (MeleFire)
+$faction_A = faction_H;
+//Now we are done. Yay!
 function do_update() {
  global $mangos_db, $realm_id;
@@ -1486 +1536 @@
 
  $entry = $sql->quote_smart($_POST['entry']);
- if (isset($_POST['modelid_m']) && $_POST['modelid_m'] != '') $modelid_m = $sql->quote_smart($_POST['modelid_m']);
-        else $modelid_m = 0;
- if (isset($_POST['modelid_f']) && $_POST['modelid_f'] != '') $modelid_f = $sql->quote_smart($_POST['modelid_f']);
-        else $modelid_f = 0;
+ if (isset($_POST['modelid_A']) && $_POST['modelid_A'] != '') $modelid_A = $sql->quote_smart($_POST['modelid_A']);
+        else $modelid_A = 0;
+ if (isset($_POST['modelid_H']) && $_POST['modelid_H'] != '') $modelid_H = $sql->quote_smart($_POST['modelid_H']);
+        else $modelid_H = 0;
  if (isset($_POST['name']) && $_POST['name'] != '') $name = $sql->quote_smart($_POST['name']);
         else $name = "";
@@ -1508 +1558 @@
  if (isset($_POST['armor']) && $_POST['armor'] != '') $armor = $sql->quote_smart($_POST['armor']);
         else $armor = 0;
- if (isset($_POST['faction']) && $_POST['faction'] != '') $faction = $sql->quote_smart($_POST['faction']);
-        else $faction = 0;
+ if (isset($_POST['faction_A']) && $_POST['faction_A'] != '') $faction_A = $sql->quote_smart($_POST['faction_A']);
+        else $faction_A = 0;
+ if (isset($_POST['faction_H']) && $_POST['faction_H'] != '') $faction_H = $sql->quote_smart($_POST['faction_H']);
+        else $faction_H = 0;
  if (isset($_POST['npcflag'])) $npcflag = $sql->quote_smart($_POST['npcflag']);
         else $npcflag = 0;
@@ -1520 +1572 @@
  if (isset($_POST['maxdmg']) && $_POST['maxdmg'] != '') $maxdmg = $sql->quote_smart($_POST['maxdmg']);
         else $maxdmg = 0;
+ if (isset($_POST['dmgschool']) && $_POST['dmgschool'] != '') $dmgschool = $sql->quote_smart($_POST['dmgschool']);
+        else $dmgschool = 0;
  if (isset($_POST['attackpower']) && $_POST['attackpower'] != '') $attackpower = $sql->quote_smart($_POST['attackpower']);
         else $attackpower = 0;
@@ -1530 +1584 @@
  if (isset($_POST['dynamicflags']) && $_POST['dynamicflags'] != '') $dynamicflags = $sql->quote_smart($_POST['dynamicflags']);
         else $dynamicflags = 0;
- if (isset($_POST['size']) && $_POST['size'] != '') $size = $sql->quote_smart($_POST['size']);
-        else $size = 0;
  if (isset($_POST['family']) && $_POST['family'] != '') $family = $sql->quote_smart($_POST['family']);
         else $family = 0;
@@ -1625 +1677 @@
         if (isset($_POST['maxcount']) && $_POST['maxcount'] != '') $maxcount = $sql->quote_smart($_POST['maxcount']);
                 else $maxcount = 0;
-        if (isset($_POST['quest_freeforall']) && $_POST['quest_freeforall'] != '') $quest_freeforall = $sql->quote_smart($_POST['quest_freeforall']);
-                else $quest_freeforall = 0;
+
+        if (isset($_POST['freeforall']) && $_POST['freeforall'] != '') $freeforall = $sql->quote_smart($_POST['freeforall']);
+                else $freeforall = 0;
+        if (isset($_POST['lootcondition']) && $_POST['lootcondition'] != '') $lootcondition = $sql->quote_smart($_POST['lootcondition']);
+                else $lootcondition = 0;
+        if (isset($_POST['condition_value1']) && $_POST['condition_value1'] != '') $condition_value1 = $sql->quote_smart($_POST['condition_value1']);
+                else $condition_value1 = 0;
+        if (isset($_POST['condition_value2']) && $_POST['condition_value2'] != '') $condition_value2 = $sql->quote_smart($_POST['condition_value2']);
+                else $condition_value2 = 0;
         if (isset($_POST['item']) && $_POST['item'] != '') $item = $sql->quote_smart($_POST['item']);
                 else $item = 0;
@@ -1658 +1717 @@
         if (isset($_POST['skin_maxcount']) && $_POST['skin_maxcount'] != '') $skin_maxcount = $sql->quote_smart($_POST['skin_maxcount']);
                 else $skin_maxcount = 0;
-        if (isset($_POST['skin_quest_freeforall']) && $_POST['skin_quest_freeforall'] != '') $skin_quest_freeforall = $sql->quote_smart($_POST['skin_quest_freeforall']);
-                else $skin_quest_freeforall = 0;
+
+        if (isset($_POST['skin_freeforall']) && $_POST['skin_freeforall'] != '') $skin_freeforall = $sql->quote_smart($_POST['skin_freeforall']);
+                else $skin_freeforall = 0;
+        if (isset($_POST['skin_lootcondition']) && $_POST['skin_lootcondition'] != '') $skin_lootcondition = $sql->quote_smart($_POST['skin_lootcondition']);
+                else $skin_lootcondition = 0;
+        if (isset($_POST['skin_condition_value1']) && $_POST['skin_condition_value1'] != '') $skin_condition_value1 = $sql->quote_smart($_POST['skin_condition_value1']);
+                else $skin_condition_value1 = 0;
+        if (isset($_POST['skin_condition_value2']) && $_POST['skin_condition_value2'] != '') $skin_condition_value2 = $sql->quote_smart($_POST['skin_condition_value2']);
+                else $skin_condition_value2 = 0;
+
         if (isset($_POST['skin_item']) && $_POST['skin_item'] != '') $skin_item = $sql->quote_smart($_POST['skin_item']);
                 else $skin_item = 0;
@@ -1673 +1740 @@
         if (isset($_POST['pp_maxcount']) && $_POST['pp_maxcount'] != '') $pp_maxcount = $sql->quote_smart($_POST['pp_maxcount']);
                 else $pp_maxcount = 0;
-        if (isset($_POST['pp_quest_freeforall']) && $_POST['pp_quest_freeforall'] != '') $pp_quest_freeforall = $sql->quote_smart($_POST['pp_quest_freeforall']);
-                else $pp_quest_freeforall = 0;
+
+        if (isset($_POST['pp_freeforall']) && $_POST['pp_freeforall'] != '') $pp_freeforall = $sql->quote_smart($_POST['pp_freeforall']);
+                else $pp_freeforall = 0;
+        if (isset($_POST['pp_lootcondition']) && $_POST['pp_lootcondition'] != '') $pp_lootcondition = $sql->quote_smart($_POST['pp_lootcondition']);
+                else $pp_lootcondition = 0;
+        if (isset($_POST['pp_condition_value1']) && $_POST['pp_condition_value1'] != '') $pp_condition_value1 = $sql->quote_smart($_POST['pp_condition_value1']);
+                else $pp_condition_value1 = 0;
+        if (isset($_POST['pp_condition_value2']) && $_POST['pp_condition_value2'] != '') $pp_condition_value2 = $sql->quote_smart($_POST['pp_condition_value2']);
+                else $pp_condition_value2 = 0;
         if (isset($_POST['pp_item']) && $_POST['pp_item'] != '') $pp_item = $sql->quote_smart($_POST['pp_item']);
                 else $pp_item = 0;
@@ -1714 +1788 @@
 
   if ($_POST['opp_type'] == "add_new"){
-        $sql_query = "INSERT INTO creature_template ( entry, modelid_m, modelid_f, name, subname, minlevel,
-        maxlevel, minhealth, maxhealth, minmana, maxmana, armor, faction, npcflag, speed, rank, mindmg,
-        maxdmg, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, size, family,
-        bounding_radius, trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower,
-        combat_reach, type, civilian, flag1, equipmodel1, equipmodel2, equipmodel3, equipinfo1, equipinfo2,
-        equipinfo3, equipslot1, equipslot2, equipslot3, lootid, pickpocketloot, skinloot, resistance1,
+        $sql_query = "INSERT INTO creature_template ( entry, modelid_A, modelid_H, 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, ScriptName) VALUES ( '$entry', '$modelid_m', '$modelid_f', '$name',
-        '$subname', '$minlevel', '$maxlevel', '$minhealth', '$maxhealth', '$minmana', '$maxmana', '$armor', '$faction', '$npcflag',
-        '$speed', '$rank', '$mindmg', '$maxdmg', '$attackpower', '$baseattacktime', '$rangeattacktime', '$flags',
-        '$dynamicflags', '$size', '$family', '$bounding_radius', '$trainer_type', '$trainer_spell', '$class', '$race',
-        '$minrangedmg', '$maxrangedmg', '$rangedattackpower', '$combat_reach', '$type', '$civilian', '$flag1',
-        '$equipmodel1', '$equipmodel2', '$equipmodel3', '$equipinfo1', '$equipinfo2', '$equipinfo3', '$equipslot1',
-        '$equipslot2', '$equipslot3', '$lootid', '$pickpocketloot', '$skinloot', '$resistance1', '$resistance2',
+        mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, ScriptName) VALUES ( '$entry', '$modelid_A', '$modelid_H', '$name',
+        '$subname', '$minlevel', '$maxlevel', '$minhealth', '$maxhealth', '$minmana', '$maxmana', '$armor', '$faction_A', '$faction_A',  '$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', '$ScriptName' )";
@@ -1737 +1809 @@
         $result = $sql->query("SELECT * FROM creature_template WHERE entry = '$entry'");
         if ($mob_templ = $sql->fetch_assoc($result)){
-                if ($mob_templ['modelid_m'] != $modelid_m) $sql_query .= "modelid_m='$modelid_m',";
-                if ($mob_templ['modelid_f'] != $modelid_f) $sql_query .= "modelid_f='$modelid_f',";
+                if ($mob_templ['modelid_A'] != $modelid_A) $sql_query .= "modelid_A='$modelid_A',";
+                if ($mob_templ['modelid_H'] != $modelid_H) $sql_query .= "modelid_H='$modelid_H',";
                 if ($mob_templ['name'] != $name) $sql_query .= "name='$name',";
                 if ($mob_templ['subname'] != $subname) $sql_query .= "subname='$subname',";
@@ -1748 +1820 @@
                 if ($mob_templ['maxmana'] != $maxmana) $sql_query .= "maxmana='$maxmana',";
                 if ($mob_templ['armor'] != $armor) $sql_query .= "armor='$armor',";
-                if ($mob_templ['faction'] != $faction) $sql_query .= "faction='$faction',";
+                if ($mob_templ['faction_A'] != $faction_A) $sql_query .= "faction_A='$faction_A',";
+                if ($mob_templ['faction_H'] != $faction_H) $sql_query .= "faction_H='$faction_H',";
                 if ($mob_templ['npcflag'] != $npcflag) $sql_query .= "npcflag='$npcflag',";
                 if ($mob_templ['speed'] != $speed) $sql_query .= "speed='$speed',";
@@ -1754 +1827 @@
                 if ($mob_templ['mindmg'] != $mindmg) $sql_query .= "mindmg='$mindmg',";
                 if ($mob_templ['maxdmg'] != $maxdmg) $sql_query .= "maxdmg='$maxdmg',";
+                if ($mob_templ['dmgschool'] != $dmgschool) $sql_query .= "dmgschool='$dmgschool',";
                 if ($mob_templ['attackpower'] != $attackpower) $sql_query .= "attackpower='$attackpower',";
                 if ($mob_templ['baseattacktime'] != $baseattacktime) $sql_query .= "baseattacktime='$baseattacktime',";
@@ -1759 +1833 @@
                 if ($mob_templ['flags'] != $flags) $sql_query .= "flags='$flags',";
                 if ($mob_templ['dynamicflags'] != $dynamicflags) $sql_query .= "dynamicflags='$dynamicflags',";
-                if ($mob_templ['size'] != $size) $sql_query .= "size='$size',";
                 if ($mob_templ['family'] != $family) $sql_query .= "family='$family',";
                 if ($mob_templ['bounding_radius'] != $bounding_radius) $sql_query .= "bounding_radius='$bounding_radius',";
@@ -1769 +1842 @@
                 if ($mob_templ['maxrangedmg'] != $maxrangedmg) $sql_query .= "maxrangedmg='$maxrangedmg',";
                 if ($mob_templ['rangedattackpower'] != $rangedattackpower) $sql_query .= "rangedattackpower='$rangedattackpower',";
-                if ($mob_templ['combat_reach'] != $combat_reach) $sql_query .= "combat_reach='$combat_reach',";
                 if ($mob_templ['type'] != $type) $sql_query .= "type='$type',";
                 if ($mob_templ['civilian'] != $civilian) $sql_query .= "civilian='$civilian',";
@@ -1830 +1902 @@
 
         if ($item){
-        $sql_query .= "INSERT INTO creature_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, quest_freeforall)
-                        VALUES ($lootid,$item,'$ChanceOrRef', '$QuestChanceOrGroup' ,$mincount ,$maxcount ,$quest_freeforall);\n";
+        $sql_query .= "INSERT INTO creature_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)
+                        VALUES ($lootid,$item,'$ChanceOrRef', '$QuestChanceOrGroup' ,$mincount ,$maxcount ,$freeforall ,$lootcondition ,$condition_value1 ,$condition_value2);\n";
         }
         
@@ -1840 +1912 @@
 
         if ($skin_item){
-        $sql_query .= "INSERT INTO skinning_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, quest_freeforall)
-                        VALUES ($skinloot,$skin_item,'$skin_ChanceOrRef', '$skin_QuestChanceOrGroup' ,$skin_mincount ,$skin_maxcount ,$skin_quest_freeforall);\n";
+        $sql_query .= "INSERT INTO skinning_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)
+                        VALUES ($skinloot,$skin_item,'$skin_ChanceOrRef', '$skin_QuestChanceOrGroup' ,$skin_mincount ,$skin_maxcount ,$skin_freeforall,$skin_lootcondition ,$skin_condition_value1 ,$skin_condition_value2);\n";
         }
         
@@ -1850 +1922 @@
    
         if ($pp_item){
-        $sql_query .= "INSERT INTO pickpocketing_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, quest_freeforall)
-                        VALUES ($pickpocketloot,$pp_item,'$pp_ChanceOrRef', '$pp_QuestChanceOrGroup' ,$pp_mincount ,$pp_maxcount ,$pp_quest_freeforall);\n";
+        $sql_query .= "INSERT INTO pickpocketing_loot_template (entry, item, ChanceOrRef, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)
+                        VALUES ($pickpocketloot,$pp_item,'$pp_ChanceOrRef', '$pp_QuestChanceOrGroup' ,$pp_mincount ,$pp_maxcount ,$pp_freeforall,$pp_lootcondition ,$pp_condition_value1 ,$pp_condition_value2);\n";
         }