![(please configure the [header_logo] section in trac.ini)](/wow/chrome/site/your_project_logo.png){kind=logo}
Changeset 374 for minimanager/creature.php
- Timestamp:
- Sep 11, 2008, 9:10:27 AM (16 years ago)
- File:
-
- 1 edited
-
minimanager/creature.php (modified) (38 diffs)
Legend:
- Unmodified
- Added
- Removed
-
minimanager/creature.php
r307 r374 10 10 */ 11 11 require_once("header.php"); 12 valid_login( 1);12 valid_login($action_permission['read']); 13 13 include_once("./scripts/get_lib.php"); 14 14 … … 19 19 if ($flag & 1) $temp .= " {$lang_creature['gossip']} "; 20 20 if ($flag & 2) $temp .= " {$lang_creature['quest_giver']} "; 21 if ($flag & 4) $temp .= " {$lang_creature['vendor']} ";22 if ($flag & 8) $temp .= " {$lang_creature['taxi']} ";23 21 if ($flag & 16) $temp .= " {$lang_creature['trainer']} "; 24 if ($flag & 32) $temp .= " {$lang_creature['spirit_healer']} "; 25 if ($flag & 64) $temp .= " {$lang_creature['guard']} "; 26 if ($flag & 128) $temp .= " {$lang_creature['inn_keeper']} "; 27 if ($flag & 256) $temp .= " {$lang_creature['banker']} "; 28 if ($flag & 1024) $temp .= " {$lang_creature['tabard_vendor']} "; 29 if ($flag & 2048) $temp .= " {$lang_creature['battlemaster']} "; 30 if ($flag & 4096) $temp .= " {$lang_creature['auctioneer']} "; 31 if ($flag & 8192) $temp .= " {$lang_creature['stable_master']} "; 32 if ($flag & 16384) $temp .= " {$lang_creature['armorer']} "; 22 if ($flag & 128) $temp .= " {$lang_creature['vendor']} "; 23 if ($flag & 4096) $temp .= " {$lang_creature['armorer']} "; 24 if ($flag & 8192) $temp .= " {$lang_creature['taxi']} "; 25 if ($flag & 16384) $temp .= " {$lang_creature['spirit_healer']} "; 26 if ($flag & 65536) $temp .= " {$lang_creature['inn_keeper']} "; 27 if ($flag & 131072) $temp .= " {$lang_creature['banker']} "; 28 if ($flag & 262144) $temp .= " {$lang_creature['retitioner']} "; 29 if ($flag & 524288) $temp .= " {$lang_creature['tabard_vendor']} "; 30 if ($flag & 1048576) $temp .= " {$lang_creature['battlemaster']} "; 31 if ($flag & 2097152) $temp .= " {$lang_creature['auctioneer']} "; 32 if ($flag & 4194304) $temp .= " {$lang_creature['stable_master']} "; 33 if ($flag & 268435456) $temp .= " {$lang_creature['guard']} "; 34 33 35 if ($temp != "") return $temp; 34 36 else return $lang_creature['none']; … … 90 92 <option value=\"1\">{$lang_creature['gossip']}</option> 91 93 <option value=\"2\">{$lang_creature['quest_giver']}</option> 92 <option value=\"4\">{$lang_creature['vendor']}</option>93 <option value=\"8\">{$lang_creature['taxi']}</option>94 94 <option value=\"16\">{$lang_creature['trainer']}</option> 95 <option value=\"32\">{$lang_creature['spirit_healer']}</option> 96 <option value=\"64\">{$lang_creature['guard']}</option> 97 <option value=\"128\">{$lang_creature['inn_keeper']}</option> 98 <option value=\"256\">{$lang_creature['banker']}</option> 99 <option value=\"512\">{$lang_creature['retitioner']}</option> 100 <option value=\"1024\">{$lang_creature['tabard_vendor']}</option> 101 <option value=\"2048\">{$lang_creature['battlemaster']}</option> 102 <option value=\"4096\">{$lang_creature['auctioneer']}</option> 103 <option value=\"8192\">{$lang_creature['stable_master']}</option> 104 <option value=\"16384\">{$lang_creature['armorer']}</option> 95 <option value=\"128\">{$lang_creature['vendor']}</option> 96 <option value=\"4096\">{$lang_creature['armorer']}</option> 97 <option value=\"8192\">{$lang_creature['taxi']}</option> 98 <option value=\"16384\">{$lang_creature['spirit_healer']}</option> 99 <option value=\"65536\">{$lang_creature['inn_keeper']}</option> 100 <option value=\"131072\">{$lang_creature['banker']}</option> 101 <option value=\"262144\">{$lang_creature['retitioner']}</option> 102 <option value=\"524288\">{$lang_creature['tabard_vendor']}</option> 103 <option value=\"1048576\">{$lang_creature['battlemaster']}</option> 104 <option value=\"2097152\">{$lang_creature['auctioneer']}</option> 105 <option value=\"4194304\">{$lang_creature['stable_master']}</option> 106 <option value=\"268435456\">{$lang_creature['guard']}</option> 105 107 </select></td> 106 108 <td>{$lang_creature['type']}:</td> … … 171 173 $output .= "</td></tr> 172 174 <tr> 173 <td colspan=\"6\"> -----------------------------------------------------------------------------------------------------------------------------------------------</td>175 <td colspan=\"6\"><hr></td> 174 176 </tr> 175 177 <tr> … … 227 229 if(isset($health)) $where .= "AND minhealth <= $health AND maxhealth >= $health "; 228 230 if(isset($faction_A)) $where .= "AND faction_A = '$faction_A' "; 229 if(isset($faction_H)) $where .= "AND faction_ B = '$faction_A' ";231 if(isset($faction_H)) $where .= "AND faction_H = '$faction_H' "; 230 232 if(isset($lootid)) $where .= "AND lootid = '$lootid' "; 231 233 if(isset($ScriptName)) $where .= "AND ScriptName LIKE '%$ScriptName%' "; … … 382 384 <option value=\"1\">1: {$lang_creature['gossip']}</option> 383 385 <option value=\"2\">2: {$lang_creature['quest_giver']}</option> 384 <option value=\"4\">4: {$lang_creature['vendor']}</option>385 <option value=\"8\">8: {$lang_creature['taxi']}</option>386 386 <option value=\"16\">16: {$lang_creature['trainer']}</option> 387 <option value=\"32\">32: {$lang_creature['spirit_healer']}</option> 388 <option value=\"64\">64: {$lang_creature['guard']}</option> 389 <option value=\"128\">128: {$lang_creature['inn_keeper']}</option> 390 <option value=\"256\">256: {$lang_creature['banker']}</option> 391 <option value=\"512\">512: {$lang_creature['retitioner']}</option> 392 <option value=\"1024\">1024: {$lang_creature['tabard_vendor']}</option> 393 <option value=\"2048\">2048: {$lang_creature['battlemaster']}</option> 394 <option value=\"4096\">4096: {$lang_creature['auctioneer']}</option> 395 <option value=\"8192\">8192: {$lang_creature['stable_master']}</option> 396 <option value=\"16384\">16384: {$lang_creature['armorer']}</option> 387 <option value=\"128\">128: {$lang_creature['vendor']}</option> 388 <option value=\"4096\">4096: {$lang_creature['armorer']}</option> 389 <option value=\"8192\">8192: {$lang_creature['taxi']}</option> 390 <option value=\"16384\">16384: {$lang_creature['spirit_healer']}</option> 391 <option value=\"65536\">65536: {$lang_creature['inn_keeper']}</option> 392 <option value=\"131072\">131072: {$lang_creature['banker']}</option> 393 <option value=\"262144\">262144: {$lang_creature['retitioner']}</option> 394 <option value=\"524288\">524288: {$lang_creature['tabard_vendor']}</option> 395 <option value=\"1048576\">1048576: {$lang_creature['battlemaster']}</option> 396 <option value=\"2097152\">2097152: {$lang_creature['auctioneer']}</option> 397 <option value=\"4194304\">4194304: {$lang_creature['stable_master']}</option> 398 <option value=\"268435456\">268435456: {$lang_creature['guard']}</option> 397 399 </select></td> 398 400 … … 641 643 </select></td> 642 644 643 <td>".makeinfocell($lang_creature[' civilian'],$lang_creature['civilian_desc'])."</td>644 <td><input type=\" checkbox\" name=\"civilian\" value=\"1\" /></td>645 <td>".makeinfocell($lang_creature['flags_extra'],$lang_creature['flags_extra_desc'])."</td> 646 <td><input type=\"text\" name=\"flags_extra\" size=\"8\" maxlength=\"11\" value=\"0\" /></td> 645 647 </tr> 646 648 <tr> … … 690 692 $entry = $sql->quote_smart($_GET['entry']); 691 693 $deplang = get_lang_id(); 692 $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'"); 693 694 $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`,`flags_extra`,`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'"); 694 695 695 696 if ($mob = $sql->fetch_assoc($result)){ … … 729 730 $output .= "<li><a href=\"#\" onclick=\"return showPane('pane8', this)\">{$lang_creature['trainer']}</a></li>"; 730 731 } 732 } 733 if ($mob['npcflag'] & 128) { 734 $vendor_flag = 1; 735 $output .= "<li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_creature['vendor']}</a></li>"; 736 } 737 if ($mob['npcflag'] & 16384) { 738 $vendor_flag = 1; 739 $output .= "<li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_creature['vendor']}</a></li>"; 731 740 } 732 741 if ($mob['lootid']) { … … 836 845 unset($type); 837 846 838 $npcflag = array(0 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128=> "",839 256 => "", 512 => "", 1024 => "", 2048 => "", 4096 => "", 8192 => "", 16384=> "");847 $npcflag = array(0 => "", 1 => "", 2 => "", 16 => "", 128 => "", 4096 => "", 8192 => "", 16384 => "", 65536 => "", 848 131072 => "", 262144 => "", 524288 => "", 1048576 => "", 2097152 => "", 4194304 => "", 268435456 => ""); 840 849 841 850 if($mob['npcflag'] == 0) $npcflag[0] = " selected=\"selected\" "; … … 843 852 if ($mob['npcflag'] & 1) $npcflag[1] = " selected=\"selected\" "; 844 853 if ($mob['npcflag'] & 2) $npcflag[2] = " selected=\"selected\" "; 845 if ($mob['npcflag'] & 4) $npcflag[4] = " selected=\"selected\" ";846 if ($mob['npcflag'] & 8) $npcflag[8] = " selected=\"selected\" ";847 854 if ($mob['npcflag'] & 16) $npcflag[16] = " selected=\"selected\" "; 848 if ($mob['npcflag'] & 32) $npcflag[32] = " selected=\"selected\" ";849 if ($mob['npcflag'] & 64) $npcflag[64] = " selected=\"selected\" ";850 855 if ($mob['npcflag'] & 128) $npcflag[128] = " selected=\"selected\" "; 851 if ($mob['npcflag'] & 256) $npcflag[256] = " selected=\"selected\" ";852 if ($mob['npcflag'] & 512) $npcflag[512] = " selected=\"selected\" ";853 if ($mob['npcflag'] & 1024) $npcflag[1024] = " selected=\"selected\" ";854 if ($mob['npcflag'] & 2048) $npcflag[2048] = " selected=\"selected\" ";855 856 if ($mob['npcflag'] & 4096) $npcflag[4096] = " selected=\"selected\" "; 856 857 if ($mob['npcflag'] & 8192) $npcflag[8192] = " selected=\"selected\" "; 857 858 if ($mob['npcflag'] & 16384) $npcflag[16384] = " selected=\"selected\" "; 859 if ($mob['npcflag'] & 65536) $npcflag[65536] = " selected=\"selected\" "; 860 if ($mob['npcflag'] & 131072) $npcflag[131072] = " selected=\"selected\" "; 861 if ($mob['npcflag'] & 262144) $npcflag[262144] = " selected=\"selected\" "; 862 if ($mob['npcflag'] & 524288) $npcflag[524288] = " selected=\"selected\" "; 863 if ($mob['npcflag'] & 1048576) $npcflag[1048576] = " selected=\"selected\" "; 864 if ($mob['npcflag'] & 2097152) $npcflag[2097152] = " selected=\"selected\" "; 865 if ($mob['npcflag'] & 4194304) $npcflag[4194304] = " selected=\"selected\" "; 866 if ($mob['npcflag'] & 268435456) $npcflag[268435456] = " selected=\"selected\" "; 858 867 } 859 868 … … 1202 1211 unset($InhabitType); 1203 1212 1204 if ($mob['civilian']) $civilian = "checked"; 1205 else $civilian = ""; 1206 1207 $output .= "<td>".makeinfocell($lang_creature['civilian'],$lang_creature['civilian_desc'])."</td> 1208 <td><input type=\"checkbox\" name=\"civilian\" value=\"1\" $civilian /></td> 1213 $output .= "<td>".makeinfocell($lang_creature['flags_extra'],$lang_creature['flags_extra_desc'])."</td> 1214 <td><input type=\"text\" name=\"flags_extra\" size=\"8\" maxlength=\"11\" value=\"{$mob['flags_extra']}\" /></td> 1209 1215 </tr> 1210 1216 <tr> … … 1232 1238 $row_flag = 0; 1233 1239 $output .= "<table class=\"hidden\" align=\"center\"><tr>"; 1234 $result1 = $sql->query("SELECT item,ChanceOr Ref,QuestChanceOrGroup,mincount,maxcount,freeforall, lootcondition, condition_value1,condition_value2 FROM creature_loot_template WHERE entry = {$mob['lootid']} ORDER BY ChanceOrRefDESC");1240 $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1,condition_value2 FROM creature_loot_template WHERE entry = {$mob['lootid']} ORDER BY ChanceOrQuestChance DESC"); 1235 1241 while ($item = $sql->fetch_row($result1)){ 1236 1242 $cel_counter++; 1237 $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]";1243 $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['lootcondition']}: $item[5]<br />{$lang_creature['condition_value1']}: $item[6]<br />{$lang_creature['condition_value2']}: $item[7]"; 1238 1244 $output .= "<td>"; 1239 1245 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip"); 1240 1246 $output .= "<br /><input type=\"checkbox\" name=\"del_loot_items[]\" value=\"$item[0]\" /></td>"; 1241 1247 1242 if ($cel_counter >= 1 6) {1248 if ($cel_counter >= 14) { 1243 1249 $cel_counter = 0; 1244 1250 $output .= "</tr><tr>"; … … 1255 1261 <td><input type=\"text\" name=\"item\" size=\"8\" maxlength=\"10\" value=\"\" /></td> 1256 1262 <td>".makeinfocell($lang_creature['loot_drop_chance'],$lang_creature['loot_drop_chance_desc'])."</td> 1257 <td><input type=\"text\" name=\"ChanceOr Ref\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>1263 <td><input type=\"text\" name=\"ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td> 1258 1264 <td>".makeinfocell($lang_creature['loot_quest_drop_chance'],$lang_creature['loot_quest_drop_chance_desc'])."</td> 1259 <td><input type=\"text\" name=\" QuestChanceOrGroup\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>1265 <td><input type=\"text\" name=\"groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td> 1260 1266 </tr> 1261 1267 <tr> 1262 1268 <td>".makeinfocell($lang_creature['min_count'],$lang_creature['min_count_desc'])."</td> 1263 <td><input type=\"text\" name=\"mincount \" size=\"8\" maxlength=\"3\" value=\"1\" /></td>1269 <td><input type=\"text\" name=\"mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td> 1264 1270 <td>".makeinfocell($lang_creature['max_count'],$lang_creature['max_count_desc'])."</td> 1265 1271 <td><input type=\"text\" name=\"maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td> 1266 <td>".makeinfocell($lang_creature['freeforall'],$lang_creature['freeforall_desc'])."</td>1267 <td><input type=\"text\" name=\"freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>1268 1272 </tr> 1269 1273 <tr> … … 1319 1323 $output .= "<div id=\"pane7\"> 1320 1324 <br /><br /><table class=\"lined\" style=\"width: 720px;\"> 1321 <tr class=\"large_bold\"><td colspan=\" 6\" class=\"hidden\" align=\"left\">{$lang_creature['sells']}:</td></tr>1322 <tr><td colspan=\" 6\">";1325 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_creature['sells']}:</td></tr> 1326 <tr><td colspan=\"8\">"; 1323 1327 1324 1328 $cel_counter = 0; 1325 1329 $row_flag = 0; 1326 1330 $output .= "<table class=\"hidden\" align=\"center\"><tr>"; 1327 $result1 = $sql->query("SELECT item, maxcount, incrtime FROM npc_vendor WHERE entry = {$mob['entry']}");1331 $result1 = $sql->query("SELECT item, maxcount, incrtime, ExtendedCost FROM npc_vendor WHERE entry = {$mob['entry']}"); 1328 1332 while ($item = $sql->fetch_row($result1)){ 1329 1333 $cel_counter++; … … 1335 1339 $output .= "<br /><input type=\"checkbox\" name=\"del_vendor_item[]\" value=\"$item[0]\" /></td>"; 1336 1340 1337 if ($cel_counter >= 1 6) {1341 if ($cel_counter >= 14) { 1338 1342 $cel_counter = 0; 1339 1343 $output .= "</tr><tr>"; … … 1345 1349 $output .= "</td></tr></table> 1346 1350 </td></tr> 1347 <tr class=\"large_bold\"><td colspan=\" 6\" class=\"hidden\" align=\"left\">{$lang_creature['add_items_to_vendor']}:</td></tr>1351 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_creature['add_items_to_vendor']}:</td></tr> 1348 1352 <tr> 1349 1353 <td>".makeinfocell($lang_creature['vendor_item_id'],$lang_creature['vendor_item_id_desc'])."</td> … … 1352 1356 <td><input type=\"text\" name=\"vendor_maxcount\" size=\"8\" maxlength=\"3\" value=\"0\" /></td> 1353 1357 <td>".makeinfocell($lang_creature['vendor_incrtime'],$lang_creature['vendor_incrtime_desc'])."</td> 1354 <td><input type=\"text\" name=\"vendor_incrtime\" size=\"8\" maxlength=\"10\" value=\"0\" /></td> 1358 <td><input type=\"text\" name=\"vendor_incrtime\" size=\"8\" maxlength=\"10\" value=\"0\" /></td> 1359 <td>".makeinfocell($lang_creature['vendor_extended_cost'],$lang_creature['vendor_extended_cost_desc'])."</td> 1360 <td><input type=\"text\" name=\"vendor_extended_cost\" size=\"8\" maxlength=\"10\" value=\"0\" /></td> 1355 1361 </tr> 1356 1362 </table><br />{$lang_creature['check_to_delete']}<br /><br /> … … 1414 1420 $row_flag = 0; 1415 1421 $output .= "<table class=\"hidden\" align=\"center\"><tr>"; 1416 $result1 = $sql->query("SELECT item,ChanceOr Ref,QuestChanceOrGroup,mincount,maxcount,freeforall, lootcondition, condition_value1, condition_value2 FROM skinning_loot_template WHERE entry = {$mob['skinloot']} ORDER BY ChanceOrRefDESC");1422 $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1, condition_value2 FROM skinning_loot_template WHERE entry = {$mob['skinloot']} ORDER BY ChanceOrQuestChance DESC"); 1417 1423 while ($item = $sql->fetch_row($result1)){ 1418 1424 $cel_counter++; 1419 $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]";1425 $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['lootcondition']}: $item[5]<br />{$lang_creature['condition_value1']}: $item[6]<br />{$lang_creature['condition_value2']}: $item[7]"; 1420 1426 $output .= "<td>"; 1421 1427 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip"); … … 1437 1443 <td><input type=\"text\" name=\"skin_item\" size=\"8\" maxlength=\"10\" value=\"\" /></td> 1438 1444 <td>".makeinfocell($lang_creature['loot_drop_chance'],$lang_creature['loot_drop_chance_desc'])."</td> 1439 <td><input type=\"text\" name=\"skin_ChanceOr Ref\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>1445 <td><input type=\"text\" name=\"skin_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td> 1440 1446 <td>".makeinfocell($lang_creature['loot_quest_drop_chance'],$lang_creature['loot_quest_drop_chance_desc'])."</td> 1441 <td><input type=\"text\" name=\"skin_ QuestChanceOrGroup\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>1447 <td><input type=\"text\" name=\"skin_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td> 1442 1448 </tr> 1443 1449 <tr> 1444 1450 <td>".makeinfocell($lang_creature['min_count'],$lang_creature['min_count_desc'])."</td> 1445 <td><input type=\"text\" name=\"skin_mincount \" size=\"8\" maxlength=\"3\" value=\"1\" /></td>1451 <td><input type=\"text\" name=\"skin_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td> 1446 1452 <td>".makeinfocell($lang_creature['max_count'],$lang_creature['max_count_desc'])."</td> 1447 1453 <td><input type=\"text\" name=\"skin_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td> 1448 <td>".makeinfocell($lang_creature['freeforall'],$lang_creature['freeforall_desc'])."</td>1449 <td><input type=\"text\" name=\"skin_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>1450 1454 </tr> 1451 1455 <tr> … … 1471 1475 $row_flag = 0; 1472 1476 $output .= "<table class=\"hidden\" align=\"center\"><tr>"; 1473 $result1 = $sql->query("SELECT item,ChanceOr Ref,QuestChanceOrGroup,mincount,maxcount,freeforall, lootcondition, condition_value1, condition_value2 FROM pickpocketing_loot_template WHERE entry = {$mob['pickpocketloot']} ORDER BY ChanceOrRefDESC");1477 $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount, lootcondition, condition_value1, condition_value2 FROM pickpocketing_loot_template WHERE entry = {$mob['pickpocketloot']} ORDER BY ChanceOrQuestChance DESC"); 1474 1478 while ($item = $sql->fetch_row($result1)){ 1475 1479 $cel_counter++; 1476 $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]";1480 $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['lootcondition']}: $item[5]<br />{$lang_creature['condition_value1']}: $item[6]<br />{$lang_creature['condition_value2']}: $item[7]"; 1477 1481 $output .= "<td>"; 1478 1482 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip"); … … 1494 1498 <td><input type=\"text\" name=\"pp_item\" size=\"8\" maxlength=\"10\" value=\"\" /></td> 1495 1499 <td>".makeinfocell($lang_creature['loot_drop_chance'],$lang_creature['loot_drop_chance_desc'])."</td> 1496 <td><input type=\"text\" name=\"pp_ChanceOr Ref\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>1500 <td><input type=\"text\" name=\"pp_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td> 1497 1501 <td>".makeinfocell($lang_creature['loot_quest_drop_chance'],$lang_creature['loot_quest_drop_chance_desc'])."</td> 1498 <td><input type=\"text\" name=\"pp_ QuestChanceOrGroup\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>1502 <td><input type=\"text\" name=\"pp_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td> 1499 1503 </tr> 1500 1504 <tr> 1501 1505 <td>".makeinfocell($lang_creature['min_count'],$lang_creature['min_count_desc'])."</td> 1502 <td><input type=\"text\" name=\"pp_mincount \" size=\"8\" maxlength=\"3\" value=\"1\" /></td>1506 <td><input type=\"text\" name=\"pp_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td> 1503 1507 <td>".makeinfocell($lang_creature['max_count'],$lang_creature['max_count_desc'])."</td> 1504 1508 <td><input type=\"text\" name=\"pp_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td> 1505 <td>".makeinfocell($lang_creature['freeforall'],$lang_creature['freeforall_desc'])."</td>1506 <td><input type=\"text\" name=\"pp_freeforall\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>1507 1509 </tr> 1508 1510 <tr> … … 1609 1611 if (isset($_POST['family']) && $_POST['family'] != '') $family = $sql->quote_smart($_POST['family']); 1610 1612 else $family = 0; 1611 //if (isset($_POST['bounding_radius']) && $_POST['bounding_radius'] != '') $bounding_radius = $sql->quote_smart($_POST['bounding_radius']);1612 // else $bounding_radius = 0;1613 1613 if (isset($_POST['trainer_type']) && $_POST['trainer_type'] != '') $trainer_type = $sql->quote_smart($_POST['trainer_type']); 1614 1614 else $trainer_type = 0; … … 1629 1629 if (isset($_POST['type']) && $_POST['type'] != '') $type = $sql->quote_smart($_POST['type']); 1630 1630 else $type = 0; 1631 if (isset($_POST[' civilian']) && $_POST['civilian'] != '') $civilian = $sql->quote_smart($_POST['civilian']);1632 else $civilian= 0;1631 if (isset($_POST['flags_extra']) && $_POST['flags_extra'] != '') $flags_extra = $sql->quote_smart($_POST['flags_extra']); 1632 else $flags_extra = 0; 1633 1633 if (isset($_POST['flag1']) && $_POST['flag1'] != '') $flag1 = $sql->quote_smart($_POST['flag1']); 1634 1634 else $flag1 = 0; 1635 // if (isset($_POST['equipmodel1']) && $_POST['equipmodel1'] != '') $equipmodel1 = $sql->quote_smart($_POST['equipmodel1']);1636 // else $equipmodel1 = 0;1637 // if (isset($_POST['equipmodel2']) && $_POST['equipmodel2'] != '') $equipmodel2 = $sql->quote_smart($_POST['equipmodel2']);1638 // else $equipmodel2 = 0;1639 // if (isset($_POST['equipmodel3']) && $_POST['equipmodel3'] != '') $equipmodel3 = $sql->quote_smart($_POST['equipmodel3']);1640 // else $equipmodel3 = 0;1641 // if (isset($_POST['equipinfo1']) && $_POST['equipinfo1'] != '') $equipinfo1 = $sql->quote_smart($_POST['equipinfo1']);1642 // else $equipinfo1 = 0;1643 // if (isset($_POST['equipinfo2']) && $_POST['equipinfo2'] != '') $equipinfo2 = $sql->quote_smart($_POST['equipinfo2']);1644 // else $equipinfo2 = 0;1645 // if (isset($_POST['equipinfo3']) && $_POST['equipinfo3'] != '') $equipinfo3 = $sql->quote_smart($_POST['equipinfo3']);1646 // else $equipinfo3 = 0;1647 // if (isset($_POST['equipslot1']) && $_POST['equipslot1'] != '') $equipslot1 = $sql->quote_smart($_POST['equipslot1']);1648 // else $equipslot1 = 0;1649 // if (isset($_POST['equipslot2']) && $_POST['equipslot2'] != '') $equipslot2 = $sql->quote_smart($_POST['equipslot2']);1650 // else $equipslot2 = 0;1651 // if (isset($_POST['equipslot3']) && $_POST['equipslot3'] != '') $equipslot3 = $sql->quote_smart($_POST['equipslot3']);1652 // else $equipslot3 = 0;1653 1635 if (isset($_POST['lootid']) && $_POST['lootid'] != '') $lootid = $sql->quote_smart($_POST['lootid']); 1654 1636 else $lootid = 0; … … 1692 1674 else $RacialLeader = 0; 1693 1675 1694 if (isset($_POST['ChanceOr Ref']) && $_POST['ChanceOrRef'] != '') $ChanceOrRef = $sql->quote_smart($_POST['ChanceOrRef']);1695 else $ChanceOr Ref= 0;1696 if (isset($_POST[' QuestChanceOrGroup']) && $_POST['QuestChanceOrGroup'] != '') $QuestChanceOrGroup = $sql->quote_smart($_POST['QuestChanceOrGroup']);1697 else $ QuestChanceOrGroup= 0;1698 if (isset($_POST['mincount ']) && $_POST['mincount'] != '') $mincount = $sql->quote_smart($_POST['mincount']);1699 else $mincount = 0;1676 if (isset($_POST['ChanceOrQuestChance']) && $_POST['ChanceOrQuestChance'] != '') $ChanceOrQuestChance = $sql->quote_smart($_POST['ChanceOrQuestChance']); 1677 else $ChanceOrQuestChance = 0; 1678 if (isset($_POST['groupid']) && $_POST['groupid'] != '') $groupid = $sql->quote_smart($_POST['groupid']); 1679 else $groupid = 0; 1680 if (isset($_POST['mincountOrRef']) && $_POST['mincountOrRef'] != '') $mincountOrRef = $sql->quote_smart($_POST['mincountOrRef']); 1681 else $mincountOrRef = 0; 1700 1682 if (isset($_POST['maxcount']) && $_POST['maxcount'] != '') $maxcount = $sql->quote_smart($_POST['maxcount']); 1701 1683 else $maxcount = 0; 1702 1684 1703 if (isset($_POST['freeforall']) && $_POST['freeforall'] != '') $freeforall = $sql->quote_smart($_POST['freeforall']);1704 else $freeforall = 0;1705 1685 if (isset($_POST['lootcondition']) && $_POST['lootcondition'] != '') $lootcondition = $sql->quote_smart($_POST['lootcondition']); 1706 1686 else $lootcondition = 0; … … 1729 1709 if (isset($_POST['vendor_maxcount']) && $_POST['vendor_maxcount'] != '') $vendor_maxcount = $sql->quote_smart($_POST['vendor_maxcount']); 1730 1710 else $vendor_maxcount = 0; 1731 if (isset($_POST['vendor_incrtime']) && $_POST['vendor_incrtime'] != '') $vendor_incrtime = $sql->quote_smart($_POST['vendor_incrtime']); 1732 else $vendor_incrtime = 0; 1733 1734 if (isset($_POST['skin_ChanceOrRef']) && $_POST['skin_ChanceOrRef'] != '') $skin_ChanceOrRef = $sql->quote_smart($_POST['skin_ChanceOrRef']); 1735 else $skin_ChanceOrRef = 0; 1736 if (isset($_POST['skin_QuestChanceOrGroup']) && $_POST['skin_QuestChanceOrGroup'] != '') $skin_QuestChanceOrGroup = $sql->quote_smart($_POST['skin_QuestChanceOrGroup']); 1737 else $skin_QuestChanceOrGroup = 0; 1738 if (isset($_POST['skin_mincount']) && $_POST['skin_mincount'] != '') $skin_mincount = $sql->quote_smart($_POST['skin_mincount']); 1739 else $skin_mincount = 0; 1711 if (isset($_POST['vendor_incrtime']) && $_POST['vendor_incrtime'] != '') $vendor_incrtime = $sql->quote_smart($_POST['vendor_incrtime']); 1712 else $vendor_incrtime = 0; 1713 if (isset($_POST['vendor_extended_cost']) && $_POST['vendor_extended_cost'] != '') $vendor_extended_cost = $sql->quote_smart($_POST['vendor_extended_cost']); 1714 else $vendor_extended_cost = 0; 1715 1716 if (isset($_POST['skin_ChanceOrQuestChance']) && $_POST['skin_ChanceOrQuestChance'] != '') $skin_ChanceOrQuestChance = $sql->quote_smart($_POST['skin_ChanceOrQuestChance']); 1717 else $skin_ChanceOrQuestChance = 0; 1718 if (isset($_POST['skin_groupid']) && $_POST['skin_groupid'] != '') $skin_groupid = $sql->quote_smart($_POST['skin_groupid']); 1719 else $skin_groupid = 0; 1720 if (isset($_POST['skin_mincountOrRef']) && $_POST['skin_mincountOrRef'] != '') $skin_mincountOrRef = $sql->quote_smart($_POST['skin_mincountOrRef']); 1721 else $skin_mincountOrRef = 0; 1740 1722 if (isset($_POST['skin_maxcount']) && $_POST['skin_maxcount'] != '') $skin_maxcount = $sql->quote_smart($_POST['skin_maxcount']); 1741 1723 else $skin_maxcount = 0; 1742 1724 1743 if (isset($_POST['skin_freeforall']) && $_POST['skin_freeforall'] != '') $skin_freeforall = $sql->quote_smart($_POST['skin_freeforall']);1744 else $skin_freeforall = 0;1745 1725 if (isset($_POST['skin_lootcondition']) && $_POST['skin_lootcondition'] != '') $skin_lootcondition = $sql->quote_smart($_POST['skin_lootcondition']); 1746 1726 else $skin_lootcondition = 0; … … 1755 1735 else $del_skin_items = NULL; 1756 1736 1757 if (isset($_POST['pp_ChanceOr Ref']) && $_POST['pp_ChanceOrRef'] != '') $pp_ChanceOrRef = $sql->quote_smart($_POST['pp_ChanceOrRef']);1758 else $pp_ChanceOr Ref= 0;1759 if (isset($_POST['pp_ QuestChanceOrGroup']) && $_POST['pp_QuestChanceOrGroup'] != '') $pp_QuestChanceOrGroup = $sql->quote_smart($_POST['pp_QuestChanceOrGroup']);1760 else $pp_ QuestChanceOrGroup= 0;1761 if (isset($_POST['pp_mincount ']) && $_POST['pp_mincount'] != '') $pp_mincount = $sql->quote_smart($_POST['pp_mincount']);1762 else $pp_mincount = 0;1737 if (isset($_POST['pp_ChanceOrQuestChance']) && $_POST['pp_ChanceOrQuestChance'] != '') $pp_ChanceOrQuestChance = $sql->quote_smart($_POST['pp_ChanceOrQuestChance']); 1738 else $pp_ChanceOrQuestChance = 0; 1739 if (isset($_POST['pp_groupid']) && $_POST['pp_groupid'] != '') $pp_groupid = $sql->quote_smart($_POST['pp_groupid']); 1740 else $pp_groupid = 0; 1741 if (isset($_POST['pp_mincountOrRef']) && $_POST['pp_mincountOrRef'] != '') $pp_mincountOrRef = $sql->quote_smart($_POST['pp_mincountOrRef']); 1742 else $pp_mincountOrRef = 0; 1763 1743 if (isset($_POST['pp_maxcount']) && $_POST['pp_maxcount'] != '') $pp_maxcount = $sql->quote_smart($_POST['pp_maxcount']); 1764 1744 else $pp_maxcount = 0; 1765 1745 1766 if (isset($_POST['pp_freeforall']) && $_POST['pp_freeforall'] != '') $pp_freeforall = $sql->quote_smart($_POST['pp_freeforall']);1767 else $pp_freeforall = 0;1768 1746 if (isset($_POST['pp_lootcondition']) && $_POST['pp_lootcondition'] != '') $pp_lootcondition = $sql->quote_smart($_POST['pp_lootcondition']); 1769 1747 else $pp_lootcondition = 0; … … 1794 1772 if ($npcflag[$t] & 1) $tmp = $tmp + 1; 1795 1773 if ($npcflag[$t] & 2) $tmp = $tmp + 2; 1796 if ($npcflag[$t] & 4) $tmp = $tmp + 4;1797 if ($npcflag[$t] & 8) $tmp = $tmp + 8;1798 1774 if ($npcflag[$t] & 16) $tmp = $tmp + 16; 1799 if ($npcflag[$t] & 32) $tmp = $tmp + 32;1800 if ($npcflag[$t] & 64) $tmp = $tmp + 64;1801 1775 if ($npcflag[$t] & 128) $tmp = $tmp + 128; 1802 if ($npcflag[$t] & 256) $tmp = $tmp + 256;1803 if ($npcflag[$t] & 512) $tmp = $tmp + 512;1804 if ($npcflag[$t] & 1024) $tmp = $tmp + 1024;1805 if ($npcflag[$t] & 2048) $tmp = $tmp + 2048;1806 1776 if ($npcflag[$t] & 4096) $tmp = $tmp + 4096; 1807 1777 if ($npcflag[$t] & 8192) $tmp = $tmp + 8192; 1808 1778 if ($npcflag[$t] & 16384) $tmp = $tmp + 16384; 1779 if ($npcflag[$t] & 65536) $tmp = $tmp + 65536; 1780 if ($npcflag[$t] & 131072) $tmp = $tmp + 131072; 1781 if ($npcflag[$t] & 262144) $tmp = $tmp + 262144; 1782 if ($npcflag[$t] & 524288) $tmp = $tmp + 524288; 1783 if ($npcflag[$t] & 1048576) $tmp = $tmp + 1048576; 1784 if ($npcflag[$t] & 2097152) $tmp = $tmp + 2097152; 1785 if ($npcflag[$t] & 4194304) $tmp = $tmp + 4194304; 1786 if ($npcflag[$t] & 268435456) $tmp = $tmp + 268435456; 1809 1787 } 1810 1788 $npcflag = ($tmp) ? $tmp : 0; … … 1815 1793 maxdmg, dmgschool, attackpower, baseattacktime, rangeattacktime, flags, dynamicflags, family, 1816 1794 trainer_type, trainer_spell, class, race, minrangedmg, maxrangedmg, rangedattackpower, 1817 type, civilian, flag1, lootid, pickpocketloot, skinloot, resistance1,1795 type, flags_extra, flag1, lootid, pickpocketloot, skinloot, resistance1, 1818 1796 resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, 1819 1797 mingold, maxgold, AIName, MovementType, InhabitType, RacialLeader, ScriptName) VALUES ( '$entry', '$modelid_A', '$modelid_H', '$name', … … 1821 1799 '$speed', '$rank', '$mindmg', '$maxdmg', '$dmgschool', '$attackpower', '$baseattacktime', '$rangeattacktime', '$flags', 1822 1800 '$dynamicflags', '$family', '$trainer_type', '$trainer_spell', '$class', '$race', 1823 '$minrangedmg', '$maxrangedmg', '$rangedattackpower', '$type', '$civilian', '$flag1',1801 '$minrangedmg', '$maxrangedmg', '$rangedattackpower', '$type', '$flags_extra', '$flag1', 1824 1802 '$lootid', '$pickpocketloot', '$skinloot', '$resistance1', '$resistance2', 1825 1803 '$resistance3', '$resistance4', '$resistance5', '$resistance6', '$spell1', '$spell2', '$spell3', '$spell4', 1826 1804 '$mingold', '$maxgold', '$AIName', '$MovementType', '$InhabitType', '$RacialLeader', '$ScriptName' )"; 1805 1806 redirect("creature.php?error=7"); 1827 1807 1828 1808 } elseif ($_POST['opp_type'] == "edit"){ … … 1830 1810 $sql_query = "UPDATE creature_template SET "; 1831 1811 1832 $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'");1812 $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`,`flags_extra`,`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'"); 1833 1813 if ($mob_templ = $sql->fetch_assoc($result)){ 1834 1814 if ($mob_templ['modelid_A'] != $modelid_A) $sql_query .= "modelid_A='$modelid_A',"; … … 1857 1837 if ($mob_templ['dynamicflags'] != $dynamicflags) $sql_query .= "dynamicflags='$dynamicflags',"; 1858 1838 if ($mob_templ['family'] != $family) $sql_query .= "family='$family',"; 1859 //if ($mob_templ['bounding_radius'] != $bounding_radius) $sql_query .= "bounding_radius='$bounding_radius',";1860 1839 if ($mob_templ['trainer_type'] != $trainer_type) $sql_query .= "trainer_type='$trainer_type',"; 1861 1840 if ($mob_templ['trainer_spell'] != $trainer_spell) $sql_query .= "trainer_spell='$trainer_spell',"; … … 1866 1845 if ($mob_templ['rangedattackpower'] != $rangedattackpower) $sql_query .= "rangedattackpower='$rangedattackpower',"; 1867 1846 if ($mob_templ['type'] != $type) $sql_query .= "type='$type',"; 1868 if ($mob_templ['civilian'] != $civilian) $sql_query .= "civilian='$civilian',";1847 if ($mob_templ['flags_extra'] != $flags_extra) $sql_query .= "flags_extra='$flags_extra',"; 1869 1848 if ($mob_templ['flag1'] != $flag1) $sql_query .= "flag1='$flag1',"; 1870 //if ($mob_templ['equipmodel1'] != $equipmodel1) $sql_query .= "equipmodel1='$equipmodel1',";1871 //if ($mob_templ['equipmodel2'] != $equipmodel2) $sql_query .= "equipmodel2='$equipmodel2',";1872 //if ($mob_templ['equipmodel3'] != $equipmodel3) $sql_query .= "equipmodel3='$equipmodel3',";1873 //if ($mob_templ['equipinfo1'] != $equipinfo1) $sql_query .= "equipinfo1='$equipinfo1',";1874 //if ($mob_templ['equipinfo2'] != $equipinfo2) $sql_query .= "equipinfo2='$equipinfo2',";1875 //if ($mob_templ['equipinfo3'] != $equipinfo3) $sql_query .= "equipinfo3='$equipinfo3',";1876 //if ($mob_templ['equipslot1'] != $equipslot1) $sql_query .= "equipslot1='$equipslot1',";1877 //if ($mob_templ['equipslot2'] != $equipslot2) $sql_query .= "equipslot2='$equipslot2',";1878 //if ($mob_templ['equipslot3'] != $equipslot3) $sql_query .= "equipslot3='$equipslot3',";1879 1849 if ($mob_templ['lootid'] != $lootid) $sql_query .= "lootid='$lootid',"; 1880 1850 if ($mob_templ['pickpocketloot'] != $pickpocketloot) $sql_query .= "pickpocketloot='$pickpocketloot',"; … … 1925 1895 1926 1896 if ($item){ 1927 $sql_query .= "INSERT INTO creature_loot_template (entry, item, ChanceOr Ref, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)1928 VALUES ($lootid,$item,'$ChanceOr Ref', '$QuestChanceOrGroup' ,$mincount ,$maxcount ,$freeforall,$lootcondition ,$condition_value1 ,$condition_value2);\n";1897 $sql_query .= "INSERT INTO creature_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) 1898 VALUES ($lootid,$item,'$ChanceOrQuestChance', '$groupid' ,$mincountOrRef ,$maxcount ,$lootcondition ,$condition_value1 ,$condition_value2);\n"; 1929 1899 } 1930 1900 … … 1935 1905 1936 1906 if ($skin_item){ 1937 $sql_query .= "INSERT INTO skinning_loot_template (entry, item, ChanceOr Ref, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)1938 VALUES ($skinloot,$skin_item,'$skin_ChanceOr Ref', '$skin_QuestChanceOrGroup' ,$skin_mincount ,$skin_maxcount ,$skin_freeforall,$skin_lootcondition ,$skin_condition_value1 ,$skin_condition_value2);\n";1907 $sql_query .= "INSERT INTO skinning_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) 1908 VALUES ($skinloot,$skin_item,'$skin_ChanceOrQuestChance', '$skin_groupid' ,$skin_mincountOrRef ,$skin_maxcount ,$skin_lootcondition ,$skin_condition_value1 ,$skin_condition_value2);\n"; 1939 1909 } 1940 1910 … … 1945 1915 1946 1916 if ($pp_item){ 1947 $sql_query .= "INSERT INTO pickpocketing_loot_template (entry, item, ChanceOr Ref, QuestChanceOrGroup, mincount, maxcount, freeforall, lootcondition, condition_value1, condition_value2)1948 VALUES ($pickpocketloot,$pp_item,'$pp_ChanceOr Ref', '$pp_QuestChanceOrGroup' ,$pp_mincount ,$pp_maxcount ,$pp_freeforall,$pp_lootcondition ,$pp_condition_value1 ,$pp_condition_value2);\n";1917 $sql_query .= "INSERT INTO pickpocketing_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2) 1918 VALUES ($pickpocketloot,$pp_item,'$pp_ChanceOrQuestChance', '$pp_groupid' ,$pp_mincountOrRef ,$pp_maxcount ,$pp_lootcondition ,$pp_condition_value1 ,$pp_condition_value2);\n"; 1949 1919 } 1950 1920 … … 1978 1948 1979 1949 if ($vendor_item){ 1980 $sql_query .= "INSERT INTO npc_vendor (entry, item, maxcount, incrtime )1981 VALUES ($entry,$vendor_item,$vendor_maxcount,$vendor_incrtime );\n";1950 $sql_query .= "INSERT INTO npc_vendor (entry, item, maxcount, incrtime, ExtendedCost) 1951 VALUES ($entry,$vendor_item,$vendor_maxcount,$vendor_incrtime,$vendor_extended_cost);\n"; 1982 1952 } 1983 1953 … … 2109 2079 case 6: 2110 2080 $output .= "<h1><font class=\"error\">{$lang_creature['err_no_fields_updated']}</font></h1>"; 2081 break; 2082 case 7: 2083 $output .= "<h1><font class=\"error\">{$lang_creature['add_new_success']}</font></h1>"; 2111 2084 break; 2112 2085 default: //no error
Note:
See TracChangeset
for help on using the changeset viewer.
