source: trunk/minimanager/item.php@ 599

Last change on this file since 599 was 599, checked in by barny, 16 years ago

*Přidán nový mimimanager pro podporu 3.0.9 a upraven index.php pro zobrazování online mapy (všechny lokace).
File size: 177.2 KB
Line 
1<?php
2/*
3 * Project Name: MiniManager for Mangos Server
4 * Date: 17.10.2006 inital version (0.0.1a)
5 * Author: Q.SA
6 * Copyright: Q.SA
7 * Email: *****
8 * License: GNU General Public License v2(GPL)
9 */
10require_once("header.php");
11 valid_login($action_permission['read']);
12require_once("scripts/itemset_tab.php");
13require_once("scripts/get_lib.php");
14
15function makeinfocell($text,$tooltip){
16 return "<a href=\"#\" onmouseover=\"toolTip('".addslashes($tooltip)."','info_tooltip')\" onmouseout=\"toolTip()\">$text</a>";
17}
18
19function output_status_options($stat_type_offset){
20 global $lang_item, $output;
21
22 $stat_type = array( 0 => "", 1 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "",12 => "",
23 13 => "",14 => "",15 => "",16 => "",17 => "",18 => "",19 => "",20 => "",21 => "",22 => "",
24 23 => "",24 => "",25 => "",26 => "",27 => "",28 => "",29 => "",30 => "",31 => "",32 => "",
25 33 => "",34 => "",35 => "",36 => "");
26 if (!$stat_type_offset) $stat_type_offset = 0;
27 $stat_type[$stat_type_offset] = " selected=\"selected\" ";
28
29 $output .= "<option value=\"0\" {$stat_type[0]}>0: {$lang_item['mana']}</option>
30 <option value=\"1\" {$stat_type[1]}>1: {$lang_item['health']}</option>
31 <option value=\"3\" {$stat_type[3]}>3: {$lang_item['agility']}</option>
32 <option value=\"4\" {$stat_type[4]}>4: {$lang_item['strength']}</option>
33 <option value=\"5\" {$stat_type[5]}>5: {$lang_item['intellect']}</option>
34 <option value=\"6\" {$stat_type[6]}>6: {$lang_item['spirit']}</option>
35 <option value=\"7\" {$stat_type[7]}>7: {$lang_item['stamina']}</option>
36 <option value=\"12\" {$stat_type[12]}>12: {$lang_item['DEFENCE_RATING']}</option>
37 <option value=\"13\" {$stat_type[13]}>13: {$lang_item['DODGE_RATING']}</option>
38 <option value=\"14\" {$stat_type[14]}>14: {$lang_item['PARRY_RATING']}</option>
39 <option value=\"15\" {$stat_type[15]}>15: {$lang_item['SHIELD_BLOCK_RATING']}</option>
40 <option value=\"16\" {$stat_type[16]}>16: {$lang_item['MELEE_HIT_RATING']}</option>
41 <option value=\"17\" {$stat_type[17]}>17: {$lang_item['RANGED_HIT_RATING']}</option>
42 <option value=\"18\" {$stat_type[18]}>18: {$lang_item['SPELL_HIT_RATING']}</option>
43 <option value=\"19\" {$stat_type[19]}>19: {$lang_item['MELEE_CS_RATING']}</option>
44 <option value=\"20\" {$stat_type[20]}>20: {$lang_item['RANGED_CS_RATING']}</option>
45 <option value=\"21\" {$stat_type[21]}>21: {$lang_item['SPELL_CS_RATING']}</option>
46 <option value=\"22\" {$stat_type[22]}>22: {$lang_item['MELEE_HA_RATING']}</option>
47 <option value=\"23\" {$stat_type[23]}>23: {$lang_item['RANGED_HA_RATING']}</option>
48 <option value=\"24\" {$stat_type[24]}>24: {$lang_item['SPELL_HA_RATING']}</option>
49 <option value=\"25\" {$stat_type[25]}>25: {$lang_item['MELEE_CA_RATING']}</option>
50 <option value=\"26\" {$stat_type[26]}>26: {$lang_item['RANGED_CA_RATING']}</option>
51 <option value=\"27\" {$stat_type[27]}>27: {$lang_item['SPELL_CA_RATING']}</option>
52 <option value=\"28\" {$stat_type[28]}>28: {$lang_item['MELEE_HASTE_RATING']}</option>
53 <option value=\"29\" {$stat_type[29]}>29: {$lang_item['RANGED_HASTE_RATING']}</option>
54 <option value=\"30\" {$stat_type[30]}>30: {$lang_item['SPELL_HASTE_RATING']}</option>
55 <option value=\"31\" {$stat_type[31]}>31: {$lang_item['HIT_RATING']}</option>
56 <option value=\"32\" {$stat_type[32]}>32: {$lang_item['CS_RATING']}</option>
57 <option value=\"33\" {$stat_type[33]}>33: {$lang_item['HA_RATING']}</option>
58 <option value=\"34\" {$stat_type[34]}>34: {$lang_item['CA_RATING']}</option>
59 <option value=\"35\" {$stat_type[35]}>35: {$lang_item['RESILIENCE_RATING']}</option>
60 <option value=\"36\" {$stat_type[36]}>36: {$lang_item['HASTE_RATING']}</option>";
61
62 return;
63}
64
65function output_dmgtype_options($dmg_type_offset){
66 global $lang_item, $output;
67
68 $dmg_type = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "");
69 if (!$dmg_type_offset) $dmg_type_offset = 0;
70 $dmg_type[$dmg_type_offset] = " selected=\"selected\" ";
71
72 $output .= "<option value=\"0\" {$dmg_type[0]}>0: {$lang_item['physical_dmg']}</option>
73 <option value=\"1\" {$dmg_type[1]}>1: {$lang_item['holy_dmg']}</option>
74 <option value=\"2\" {$dmg_type[2]}>2: {$lang_item['fire_dmg']}</option>
75 <option value=\"3\" {$dmg_type[3]}>3: {$lang_item['nature_dmg']}</option>
76 <option value=\"4\" {$dmg_type[4]}>4: {$lang_item['frost_dmg']}</option>
77 <option value=\"5\" {$dmg_type[5]}>5: {$lang_item['shadow_dmg']}</option>
78 <option value=\"6\" {$dmg_type[6]}>6: {$lang_item['arcane_dmg']}</option>";
79
80 return;
81}
82
83//########################################################################################################################
84// PRINT ITEM SEARCH FORM
85//########################################################################################################################
86function search() {
87 global $lang_global, $lang_item, $lang_item_edit, $lang_id_tab, $output, $world_db, $realm_id, $itemset_id;
88
89 $sql = new SQL;
90 $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
91
92 $result = $sql->query("SELECT count(*) FROM item_template");
93 $tot_items = $sql->result($result, 0);
94 $sql->close();
95
96 $output .= "<center>
97 <fieldset class=\"full_frame\">
98 <legend>{$lang_item_edit['search_item']}</legend><br />
99 <form action=\"item.php?action=do_search&amp;error=2\" method=\"post\" name=\"form\">
100
101 <table class=\"hidden\">
102 <tr>
103 <td>{$lang_item_edit['entry']}:</td>
104 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"entry\" /></td>
105 <td>{$lang_item_edit['item_name']}:</td>
106 <td colspan=\"3\"><input type=\"text\" size=\"35\" maxlength=\"35\" name=\"name\" /></td>
107 <td>{$lang_item_edit['model_id']}:</td>
108 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"displayid\" /></td>
109 </tr>
110 </tr>
111 <tr>
112 <td width=\"15%\">{$lang_item_edit['class']}:</td>
113 <td width=\"15%\"><select name=\"class\">
114 <option value=\"-1\">{$lang_item_edit['all']}</option>
115 <option value=\"0\">{$lang_item['consumable']}</option>
116 <option value=\"1\">{$lang_item['bag']}</option>
117 <option value=\"2\">{$lang_item['weapon']}</option>
118 <option value=\"4\">{$lang_item['armor']}</option>
119 <option value=\"5\">{$lang_item['reagent']}</option>
120 <option value=\"6\">{$lang_item['projectile']}</option>
121 <option value=\"7\">{$lang_item['trade_goods']}</option>
122 <option value=\"9\">{$lang_item['recipe']}</option>
123 <option value=\"11\">{$lang_item['quiver']}</option>
124 <option value=\"12\">{$lang_item['quest']}</option>
125 <option value=\"13\">{$lang_item['key']}</option>
126 <option value=\"14\">{$lang_item['permanent']}</option>
127 <option value=\"15\">{$lang_item['misc_short']}</option>
128 </select></td>
129 <td width=\"15%\">{$lang_item_edit['quality']}:</td>
130 <td width=\"15%\"><select name=\"Quality\">
131 <option value=\"-1\">{$lang_item_edit['all']}</option>
132 <option value=\"0\">{$lang_item['poor']}</option>
133 <option value=\"1\">{$lang_item['common']}</option>
134 <option value=\"2\">{$lang_item['uncommon']}</option>
135 <option value=\"3\">{$lang_item['rare']}</option>
136 <option value=\"4\">{$lang_item['epic']}</option>
137 <option value=\"5\">{$lang_item['legendary']}</option>
138 <option value=\"6\">{$lang_item['artifact']}</option>
139 </select></td>
140 <td width=\"15%\">{$lang_item_edit['inv_type']}:</td>
141 <td width=\"15%\"><select name=\"InventoryType\">
142 <option value=\"-1\">{$lang_item_edit['all']}</option>
143 <option value=\"1\">{$lang_item['head']}</option>
144 <option value=\"2\">{$lang_item['neck']}</option>
145 <option value=\"3\">{$lang_item['shoulder']}</option>
146 <option value=\"4\">{$lang_item['shirt']}</option>
147 <option value=\"5\">{$lang_item['chest']}</option>
148 <option value=\"6\">{$lang_item['belt']}</option>
149 <option value=\"7\">{$lang_item['legs']}</option>
150 <option value=\"8\">{$lang_item['feet']}</option>
151 <option value=\"9\">{$lang_item['belt']}</option>
152 <option value=\"10\">{$lang_item['gloves']}</option>
153 <option value=\"11\">{$lang_item['finger']}</option>
154 <option value=\"12\">{$lang_item['trinket']}</option>
155 <option value=\"13\">{$lang_item['one_hand']}</option>
156 <option value=\"14\">{$lang_item['off_hand']}</option>
157 <option value=\"15\">{$lang_item['bow']}</option>
158 <option value=\"16\">{$lang_item['back']}</option>
159 <option value=\"17\">{$lang_item['two_hand']}</option>
160 <option value=\"18\">{$lang_item['bag']}</option>
161 <option value=\"19\">{$lang_item['tabard']}</option>
162 <option value=\"20\">{$lang_item['robe']}</option>
163 <option value=\"21\">{$lang_item['main_hand']}</option>
164 <option value=\"22\">{$lang_item['off_misc']}</option>
165 <option value=\"23\">{$lang_item['tome']}</option>
166 <option value=\"24\">{$lang_item['projectile']}</option>
167 <option value=\"25\">{$lang_item['thrown']}</option>
168 <option value=\"26\">{$lang_item['rifle']}</option>
169 </select></td>
170 <td width=\"15%\">{$lang_item_edit['req_level']}:</td>
171 <td width=\"15%\"><input type=\"text\" size=\"6\" maxlength=\"3\" name=\"RequiredLevel\" /></td>
172 </tr>
173 <tr>
174 <td>{$lang_item_edit['spell_id']} 1:</td>
175 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"spellid_1\" /></td>
176 <td>{$lang_item_edit['spell_id']} 2:</td>
177 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"spellid_2\" /></td>
178 <td>{$lang_item_edit['spell_id']} 3:</td>
179 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"spellid_3\" /></td>
180 <td>{$lang_item_edit['spell_id']} 4:</td>
181 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"spellid_4\" /></td>
182 </tr>
183 <tr>
184 <td>{$lang_item_edit['item_level']}:</td>
185 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"ItemLevel\" /></td>
186
187 <td>{$lang_item_edit['item_set']}:</td>
188 <td colspan=\"3\"><select name=\"itemset\">
189 <option value=\"\">{$lang_item_edit['all']}</option>";
190 foreach ($itemset_id as $set) $output .= "<option value=\"{$set[0]}\">($set[0]) {$set[1]}</option>";
191$output .= "</select></td>
192 <td>{$lang_item_edit['flags']}:</td>
193 <td><input type=\"text\" size=\"6\" maxlength=\"6\" name=\"Flags\" /></td>
194 </tr>
195 <tr>
196 <td>{$lang_item_edit['bonding']}:</td>
197 <td colspan=\"2\"><select name=\"bonding\">
198 <option value=\"-1\">{$lang_item_edit['all']}</option>
199 <option value=\"1\">{$lang_item['bop']}</option>
200 <option value=\"2\">{$lang_item['boe']}</option>
201 <option value=\"3\">{$lang_item['bou']}</option>
202 <option value=\"4\">{$lang_item['quest_item']}</option>
203 </select></td>
204 <td>{$lang_item_edit['custom_search']}:</td>
205 <td colspan=\"2\"><input type=\"text\" size=\"20\" maxlength=\"512\" name=\"custom_search\" /></td>
206 <td colspan=\"2\">";
207 makebutton($lang_item_edit['search'], "javascript:do_submit()",160);
208 $output .= "</td>
209 </tr>
210 <tr>
211 <td colspan=\"8\">-----------------------------------------------------------------------------------------------------------------------------------------------</td>
212 </tr>
213 <tr>
214 <td></td>
215 <td colspan=\"2\">";
216 makebutton($lang_item_edit['add_new_item'], "item.php?action=add_new&error=3",200);
217 $output .= "</td>
218 <td colspan=\"4\">{$lang_item_edit['tot_items_in_db']}: $tot_items</td>
219 </tr>
220 </table>
221</form>
222</fieldset><br /><br /></center>";
223}
224
225
226//########################################################################################################################
227// SHOW SEARCH RESULTS
228//########################################################################################################################
229function do_search() {
230 global $lang_global, $lang_item, $lang_item_edit, $output, $world_db, $realm_id, $item_datasite, $sql_search_limit;
231 $deplang = get_lang_id();
232 if(($_POST['class'] == "-1")&&($_POST['Quality'] == "-1")&&($_POST['InventoryType'] == "-1")&&($_POST['bonding'] == "-1")
233 &&(!isset($_POST['entry'])||$_POST['entry'] === '')&&(!isset($_POST['name'])||$_POST['name'] === '')&&(!isset($_POST['displayid'])||$_POST['displayid'] === '')&&(!isset($_POST['RequiredLevel'])||$_POST['RequiredLevel'] === '')
234 &&(!isset($_POST['spellid_1'])||$_POST['spellid_1'] === '')&&(!isset($_POST['spellid_2'])||$_POST['spellid_2'] === '')&&(!isset($_POST['spellid_3'])||$_POST['spellid_3'] === '')&&(!isset($_POST['spellid_4'])||$_POST['spellid_4'] === '')
235 &&(!isset($_POST['ItemLevel'])||$_POST['ItemLevel'] === '')&&(!isset($_POST['itemset'])||$_POST['itemset'] === '')&&(!isset($_POST['Flags'])||$_POST['Flags'] === '')
236 &&(!isset($_POST['custom_search'])||$_POST['custom_search'] === ''))
237 redirect("item.php?error=1");
238
239$sql = new SQL;
240$sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
241
242$class = $sql->quote_smart($_POST['class']);
243$Quality = $sql->quote_smart($_POST['Quality']);
244$InventoryType = $sql->quote_smart($_POST['InventoryType']);
245$bonding = $sql->quote_smart($_POST['bonding']);
246
247if ($_POST['entry'] != '') $entry = $sql->quote_smart($_POST['entry']);
248if ($_POST['name'] != '') $name = $sql->quote_smart($_POST['name']);
249if ($_POST['displayid'] != '') $displayid = $sql->quote_smart($_POST['displayid']);
250if ($_POST['RequiredLevel'] != '') $RequiredLevel = $sql->quote_smart($_POST['RequiredLevel']);
251if ($_POST['spellid_1'] != '') $spellid_1 = $sql->quote_smart($_POST['spellid_1']);
252if ($_POST['spellid_2'] != '') $spellid_2 = $sql->quote_smart($_POST['spellid_2']);
253if ($_POST['spellid_3'] != '') $spellid_3 = $sql->quote_smart($_POST['spellid_3']);
254if ($_POST['spellid_4'] != '') $spellid_4 = $sql->quote_smart($_POST['spellid_4']);
255if ($_POST['ItemLevel'] != '') $ItemLevel = $sql->quote_smart($_POST['ItemLevel']);
256if ($_POST['itemset'] != '') $itemset = $sql->quote_smart($_POST['itemset']);
257if ($_POST['Flags'] != '') $Flags = $sql->quote_smart($_POST['Flags']);
258if ($_POST['custom_search'] != '') $custom_search = $sql->quote_smart($_POST['custom_search']);
259 else $custom_search = "";
260
261 $where = "WHERE item_template.entry > 0 ";
262 if($custom_search) $where .= "AND $custom_search ";
263 if($class != "-1") $where .= "AND class = '$class' ";
264 if($Quality != "-1") $where .= "AND Quality = '$Quality' ";
265 if($InventoryType != "-1") $where .= "AND InventoryType = '$InventoryType' ";
266 if($bonding != "-1") $where .= "AND bonding = '$bonding' ";
267 if(isset($entry)) $where .= "AND item_template.entry = '$entry' ";
268 if(isset($name)) $where .= "AND IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) LIKE '%$name%' ";
269 if(isset($displayid)) $where .= "AND displayid = '$displayid' ";
270 if(isset($RequiredLevel)) $where .= "AND RequiredLevel = '$RequiredLevel' ";
271
272 if(isset($spellid_1)) $where .= "AND (spellid_1 = '$spellid_1' OR spellid_2 = '$spellid_1' OR spellid_3 = '$spellid_1' OR spellid_4 = '$spellid_1' OR spellid_5 = '$spellid_1') ";
273 if(isset($spellid_2)) $where .= "AND (spellid_1 = '$spellid_2' OR spellid_2 = '$spellid_2' OR spellid_3 = '$spellid_2' OR spellid_4 = '$spellid_2' OR spellid_5 = '$spellid_2') ";
274 if(isset($spellid_3)) $where .= "AND (spellid_1 = '$spellid_3' OR spellid_2 = '$spellid_3' OR spellid_3 = '$spellid_3' OR spellid_4 = '$spellid_3' OR spellid_5 = '$spellid_3') ";
275 if(isset($spellid_4)) $where .= "AND (spellid_1 = '$spellid_4' OR spellid_2 = '$spellid_4' OR spellid_3 = '$spellid_4' OR spellid_4 = '$spellid_4' OR spellid_5 = '$spellid_4') ";
276
277 if(isset($ItemLevel)) $where .= "AND ItemLevel = '$ItemLevel' ";
278 if(isset($itemset)) $where .= "AND itemset = '$itemset' ";
279 if(isset($Flags)) $where .= "AND Flags = '$Flags' ";
280
281 if($where == "WHERE item_template.entry > 0 ") redirect("item.php?error=1");
282 $result = $sql->query("SELECT item_template.entry,displayid,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,RequiredLevel,ItemLevel FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry $where ORDER BY item_template.entry LIMIT $sql_search_limit");
283 $total_items_found = $sql->num_rows($result);
284
285 $output .= "<center>
286 <table class=\"top_hidden\"></td>
287 <tr><td>";
288 makebutton($lang_item_edit['new_search'], "item.php",160);
289 $output .= "</td>
290 <td align=\"right\">{$lang_item_edit['items_found']} : $total_items_found : {$lang_global['limit']} $sql_search_limit</td>
291 </tr></table>";
292
293 $output .= "<table class=\"lined\">
294 <tr>
295 <th width=\"15%\">{$lang_item_edit['entry']}</th>
296 <th width=\"10%\">{$lang_item_edit['display_id']}</th>
297 <th width=\"55%\">{$lang_item_edit['item_name']}</th>
298 <th width=\"10%\">{$lang_item_edit['req_level']}</th>
299 <th width=\"10%\">{$lang_item_edit['item_level']}</th>
300 </tr>";
301
302 for ($i=1; $i<=$total_items_found; $i++){
303 $item = $sql->fetch_row($result);
304
305 $tooltip = get_item_tooltip($item[0]);
306
307 $output .= "<tr>
308 <td><a href=\"$item_datasite$item[0]\" target=\"_blank\">$item[0]</a></td>
309 <td>";
310 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", "$tooltip", "item_tooltip", "target=\"_blank\"");
311 $output .="</td>
312 <td><a href=\"item.php?action=edit&amp;entry=$item[0]&amp;error=4\">".htmlentities($item[2])."</a></td>
313 <td>$item[3]</td>
314 <td>$item[4]</td>
315 </tr>";
316 }
317 $output .= "</table></center><br />";
318
319 $sql->close();
320}
321
322
323//########################################################################################################################
324// ADD NEW ITEM
325//########################################################################################################################
326function add_new() {
327 global $lang_global, $lang_item, $lang_id_tab, $lang_item_edit, $output, $item_datasite;
328
329 $output .= "<script type=\"text/javascript\" src=\"js/tab.js\"></script>
330 <center>
331 <br /><br /><br />
332 <form method=\"post\" action=\"item.php?action=do_update\" name=\"form1\">
333 <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>
334 <input type=\"hidden\" name=\"type\" value=\"add_new\"/>
335
336<div class=\"jtab-container\" id=\"container\">
337 <ul class=\"jtabs\">
338 <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_item_edit['general_tab']}</a></li>
339 <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_item_edit['additional_tab']}</a></li>
340 <li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_item_edit['stats_tab']}</a></li>
341 <li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_item_edit['damage_tab']}</a></li>
342 <li><a href=\"#\" onclick=\"return showPane('pane5', this)\">{$lang_item_edit['spell_tab']}</a></li>
343 <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_item_edit['sock_tab']}</a></li>
344 <li><a href=\"#\" onclick=\"return showPane('pane6', this)\">{$lang_item_edit['req_tab']}</a></li>
345 </ul>
346 <div class=\"jtab-panes\">";
347
348$output .= "<div id=\"pane1\">
349 <br /><br />
350<table class=\"lined\" style=\"width: 720px;\">
351<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['general']}:</td></tr>
352<tr>
353 <td>".makeinfocell($lang_item_edit['entry'],$lang_item_edit['entry_desc'])."</td>
354 <td><input type=\"text\" name=\"entry\" size=\"8\" maxlength=\"11\" value=\"\" /></td>
355
356 <td>".makeinfocell($lang_item_edit['display_id'],$lang_item_edit['display_id_desc'])."</td>
357 <td><input type=\"text\" name=\"displayid\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>
358
359 <td>".makeinfocell($lang_item_edit['req_level'],$lang_item_edit['req_level_desc'])."</td>
360 <td><input type=\"text\" name=\"RequiredLevel\" size=\"8\" maxlength=\"4\" value=\"0\" /></td>
361
362 <td>".makeinfocell($lang_item_edit['item_level'],$lang_item_edit['item_level_desc'])."</td>
363 <td><input type=\"text\" name=\"ItemLevel\" size=\"8\" maxlength=\"4\" value=\"1\" /></td>
364</tr>
365
366<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['names']}:</td></tr>
367<tr>
368 <td>".makeinfocell($lang_item_edit['item_name'],$lang_item_edit['item_name_desc'])."</td>
369 <td colspan=\"3\"><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"225\" value=\"item_name\" /></td>
370
371 <td>".makeinfocell($lang_item_edit['script_name'],$lang_item_edit['script_name_desc'])."</td>
372 <td colspan=\"3\"><input type=\"text\" name=\"ScriptName\" size=\"30\" maxlength=\"100\" value=\"internalitemhandler\" /></td>
373</tr>
374<tr>
375 <td>".makeinfocell($lang_item_edit['description'],$lang_item_edit['description_desc'])."</td>
376 <td colspan=\"3\"><input type=\"text\" name=\"description\" size=\"30\" maxlength=\"225\" value=\"\" /></td>
377 <td colspan=\"4\"></td>
378</tr>
379
380<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['type']}:</td></tr>
381 <tr>
382
383<td>".makeinfocell($lang_item_edit['class'],$lang_item_edit['class_desc'])."</td>
384 <td colspan=\"3\"><select name=\"class\">
385 <option value=\"0\">0 - {$lang_item['consumable']}</option>
386 <option value=\"1\">1 - {$lang_item['bag']}</option>
387 <option value=\"2\">2 - {$lang_item['weapon']}</option>
388 <option value=\"4\">4 - {$lang_item['armor']}</option>
389 <option value=\"5\">5 - {$lang_item['reagent']}</option>
390 <option value=\"6\">6 - {$lang_item['projectile']}</option>
391 <option value=\"7\">7 - {$lang_item['trade_goods']}</option>
392 <option value=\"9\">9 - {$lang_item['recipe']}</option>
393 <option value=\"11\">11 - {$lang_item['quiver']}</option>
394 <option value=\"12\">12 - {$lang_item['quest']}</option>
395 <option value=\"13\">13 - {$lang_item['key']}</option>
396 <option value=\"14\">14 - {$lang_item['permanent']}</option>
397 <option value=\"15\">15 - {$lang_item['misc_short']}</option>
398 </select></td>
399
400 <td>".makeinfocell($lang_item_edit['subclass'],$lang_item_edit['subclass_desc'])."</td>
401 <td colspan=\"3\"><select name=\"subclass\">
402 <option value=\"0\">0 - {$lang_item['none']}</option>
403 <optgroup label=\"Class 0: {$lang_item['consumable']}\">
404 <option value=\"0\">0 - {$lang_item['consumable']}</option>
405 <option value=\"3\">3 - {$lang_item['potion']}</option>
406 <option value=\"4\">4 - {$lang_item['scroll']}</option>
407 <option value=\"5\">5 - {$lang_item['bandage']}</option>
408 <option value=\"6\">6 - {$lang_item['healthstone']}</option>
409 <option value=\"7\">7 - {$lang_item['combat_effect']}</option>
410 <optgroup label=\"Class 1: {$lang_item['bag']}\">
411 <option value=\"0\">0 - {$lang_item['bag']}</option>
412 <option value=\"1\">1 - {$lang_item['soul_shards']}</option>
413 <option value=\"2\">2 - {$lang_item['herbs']}</option>
414 <option value=\"3\">3 - {$lang_item['enchanting']}</option>
415 <option value=\"4\">4 - {$lang_item['engineering']}</option>
416 <option value=\"5\">5 - {$lang_item['gems']}</option>
417 <option value=\"6\">6 - {$lang_item['mining']}</option>
418 <optgroup label=\"Class 2: {$lang_item['weapon']}\">
419 <option value=\"0\">0 - {$lang_item['axe_1h']}</option>
420 <option value=\"1\">1 - {$lang_item['axe_2h']}</option>
421 <option value=\"2\">2 - {$lang_item['bow']}</option>
422 <option value=\"3\">3 - {$lang_item['rifle']}</option>
423 <option value=\"4\">4 - {$lang_item['mace_1h']}</option>
424 <option value=\"5\">5 - {$lang_item['mace_2h']}</option>
425 <option value=\"6\">6 - {$lang_item['polearm']}</option>
426 <option value=\"7\">7 - {$lang_item['sword_1h']}</option>
427 <option value=\"8\">8 - {$lang_item['sword_2h']}</option>
428 <option value=\"10\">10 - {$lang_item['staff']}</option>
429 <option value=\"11\">11 - {$lang_item['exotic_1h']}</option>
430 <option value=\"12\">12 - {$lang_item['exotic_2h']}</option>
431 <option value=\"13\">13 - {$lang_item['fist_weapon']}</option>
432 <option value=\"14\">14 - {$lang_item['misc_weapon']}</option>
433 <option value=\"15\">15 - {$lang_item['dagger']}</option>
434 <option value=\"16\">16 - {$lang_item['thrown']}</option>
435 <option value=\"17\">17 - {$lang_item['spear']}</option>
436 <option value=\"18\">18 - {$lang_item['crossbow']}</option>
437 <option value=\"19\">19 - {$lang_item['wand']}</option>
438 <option value=\"20\">20 - {$lang_item['fishing_pole']}</option>
439 </optgroup>
440 <optgroup label=\"Class 4: {$lang_item['armor']}\">
441 <option value=\"0\">0 - {$lang_item['misc']}</option>
442 <option value=\"1\">1 - {$lang_item['cloth']}</option>
443 <option value=\"2\">2 - {$lang_item['leather']}</option>
444 <option value=\"3\">3 - {$lang_item['mail']}</option>
445 <option value=\"4\">4 - {$lang_item['plate']}</option>
446 <option value=\"5\">5 - {$lang_item['buckler']}</option>
447 <option value=\"6\">6 - {$lang_item['shield']}</option>
448 <option value=\"7\">7 - {$lang_item['libram']}</option>
449 <option value=\"8\">8 - {$lang_item['idol']}</option>
450 <option value=\"9\">9 - {$lang_item['totem']}</option>
451 </optgroup>
452 <optgroup label=\"Class 6: {$lang_item['projectile']}\">
453 <option value=\"2\">2 - {$lang_item['arrows']}</option>
454 <option value=\"3\">3 - {$lang_item['bullets']}</option>
455 </optgroup>
456 <optgroup label=\"Class 7: {$lang_item['trade_goods']}\">
457 <option value=\"0\">0 - {$lang_item['trade_goods']}</option>
458 <option value=\"1\">1 - {$lang_item['parts']}</option>
459 <option value=\"2\">2 - {$lang_item['explosives']}</option>
460 <option value=\"3\">3 - {$lang_item['devices']}</option>
461 </optgroup>
462 <optgroup label=\"Class 9: {$lang_item['recipe']}\">
463 <option value=\"0\">0 - {$lang_item['book']}</option>
464 <option value=\"1\">1 - {$lang_item['LW_pattern']}</option>
465 <option value=\"2\">2 - {$lang_item['tailoring_pattern']}</option>
466 <option value=\"3\">3 - {$lang_item['ENG_Schematic']}</option>
467 <option value=\"4\">4 - {$lang_item['BS_plans']}</option>
468 <option value=\"5\">5 - {$lang_item['cooking_recipe']}</option>
469 <option value=\"6\">6 - {$lang_item['alchemy_recipe']}</option>
470 <option value=\"7\">7 - {$lang_item['FA_manual']}</option>
471 <option value=\"8\">8 - {$lang_item['ench_formula']}</option>
472 <option value=\"9\">9 - {$lang_item['fishing_manual']}</option>
473 <option value=\"10\">10 - {$lang_item['JC_formula']}</option>
474 </optgroup>
475 <optgroup label=\"Class 11: {$lang_item['quiver']}\">
476 <option value=\"2\">2 - {$lang_item['quiver']}</option>
477 <option value=\"3\">3 - {$lang_item['ammo_pouch']}</option>
478 </optgroup>
479 <optgroup label=\"Class 13: {$lang_item['key']}\">
480 <option value=\"0\">0 - {$lang_item['key']}</option>
481 <option value=\"1\">1 - {$lang_item['lockpick']}</option>
482 </optgroup>
483 </select></td>
484</tr>
485<tr>
486
487<td>".makeinfocell($lang_item_edit['quality'],$lang_item_edit['quality_desc'])."</td>
488 <td colspan=\"2\"><select name=\"Quality\">
489 <option value=\"0\">0 - {$lang_item['poor']}</option>
490 <option value=\"1\">1 - {$lang_item['common']}</option>
491 <option value=\"2\">2 - {$lang_item['uncommon']}</option>
492 <option value=\"3\">3 - {$lang_item['rare']}</option>
493 <option value=\"4\">4 - {$lang_item['epic']}</option>
494 <option value=\"5\">5 - {$lang_item['legendary']}</option>
495 <option value=\"6\">6 - {$lang_item['artifact']}</option>
496 </select></td>
497
498<td>".makeinfocell($lang_item_edit['inv_type'],$lang_item_edit['inv_type_desc'])."</td>
499 <td colspan=\"2\"><select name=\"InventoryType\">
500 <option value=\"0\">0 - {$lang_item['other']}</option>
501 <option value=\"1\">1 - {$lang_item['head']}</option>
502 <option value=\"2\">2 - {$lang_item['neck']}</option>
503 <option value=\"3\">3 - {$lang_item['shoulder']}</option>
504 <option value=\"4\">4 - {$lang_item['shirt']}</option>
505 <option value=\"5\">5 - {$lang_item['chest']}</option>
506 <option value=\"6\">6 - {$lang_item['belt']}</option>
507 <option value=\"7\">7 - {$lang_item['legs']}</option>
508 <option value=\"8\">8 - {$lang_item['feet']}</option>
509 <option value=\"9\">9 - {$lang_item['belt']}</option>
510 <option value=\"10\">10 - {$lang_item['gloves']}</option>
511 <option value=\"11\">11 - {$lang_item['finger']}</option>
512 <option value=\"12\">12 - {$lang_item['trinket']}</option>
513 <option value=\"13\">13 - {$lang_item['one_hand']}</option>
514 <option value=\"14\">14 - {$lang_item['off_hand']}</option>
515 <option value=\"15\">15 - {$lang_item['bow']}</option>
516 <option value=\"16\">16 - {$lang_item['back']}</option>
517 <option value=\"17\">17 - {$lang_item['two_hand']}</option>
518 <option value=\"18\">18 - {$lang_item['bag']}</option>
519 <option value=\"19\">19 - {$lang_item['tabard']}</option>
520 <option value=\"20\">20 - {$lang_item['robe']}</option>
521 <option value=\"21\">21 - {$lang_item['main_hand']}</option>
522 <option value=\"22\">22 - {$lang_item['off_misc']}</option>
523 <option value=\"23\">23 - {$lang_item['tome']}</option>
524 <option value=\"24\">24 - {$lang_item['projectile']}</option>
525 <option value=\"25\">25 - {$lang_item['thrown']}</option>
526 <option value=\"26\">26 - {$lang_item['rifle']}</option>
527 </select></td>
528
529 <td>".makeinfocell($lang_item_edit['flags'],$lang_item_edit['flags_desc'])."</td>
530 <td><input type=\"text\" name=\"Flags\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
531 </tr>
532 <tr>
533 <td>".makeinfocell($lang_item_edit['item_set'],$lang_item_edit['item_set_desc'])."</td>
534 <td><input type=\"text\" name=\"itemset\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
535
536<td>".makeinfocell($lang_item_edit['bonding'],$lang_item_edit['bonding_desc'])."</td>
537 <td colspan=\"3\"><select name=\"bonding\">
538 <option value=\"0\">0 - {$lang_item['no_bind']}</option>
539 <option value=\"1\">1 - {$lang_item['bop']}</option>
540 <option value=\"2\">2 - {$lang_item['boe']}</option>
541 <option value=\"3\">3 - {$lang_item['bou']}</option>
542 <option value=\"4\">4 - {$lang_item['quest_item']}</option>
543 <option value=\"5\">5 - {$lang_item['quest_item']}1</option>
544 </select></td>
545
546<td>".makeinfocell($lang_item_edit['start_quest'],$lang_item_edit['start_quest_desc'])."</td>
547<td><input type=\"text\" name=\"startquest\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
548
549</tr>
550</table>
551<br />{$lang_item_edit['short_rules_desc']}<br /><br />
552</div>";
553
554$output .= "<div id=\"pane2\">
555 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
556 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['vendor']}:</td></tr>
557 <tr>
558 <td>".makeinfocell($lang_item_edit['buy_count'],$lang_item_edit['buy_count_desc'])."</td>
559 <td><input type=\"text\" name=\"BuyCount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
560
561 <td>".makeinfocell($lang_item_edit['buy_price'],$lang_item_edit['buy_price_desc'])."</td>
562 <td><input type=\"text\" name=\"BuyPrice\" size=\"8\" maxlength=\"30\" value=\"0\" /></td>
563
564 <td>".makeinfocell($lang_item_edit['sell_price'],$lang_item_edit['sell_price_desc'])."</td>
565 <td><input type=\"text\" name=\"SellPrice\" size=\"8\" maxlength=\"30\" value=\"0\" /></td>
566 <td></td><td></td>
567 </tr>
568
569 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['container']}:</td></tr>
570 <tr>
571 <td>".makeinfocell($lang_item_edit['max_count'],$lang_item_edit['max_count_desc'])."</td>
572 <td><input type=\"text\" name=\"maxcount\" size=\"8\" maxlength=\"5\" value=\"0\" /></td>
573
574 <td>".makeinfocell($lang_item_edit['stackable'],$lang_item_edit['stackable_desc'])."</td>
575 <td><input type=\"text\" name=\"stackable\" size=\"8\" maxlength=\"5\" value=\"1\" /></td>
576
577 <td>".makeinfocell($lang_item_edit['bag_family'],$lang_item_edit['bag_family_desc'])."</td>
578 <td><select name=\"BagFamily\">
579 <option value=\"0\">0 - {$lang_item['none']}</option>
580 <option value=\"1\">1 - {$lang_item['arrows']}</option>
581 <option value=\"2\">2 - {$lang_item['bullets']}</option>
582 <option value=\"3\">3 - {$lang_item['soul_shards']}</option>
583 <option value=\"6\">6 - {$lang_item['herbs']}</option>
584 <option value=\"7\">7 - {$lang_item['enchanting']}</option>
585 <option value=\"8\">8 - {$lang_item['engineering']}</option>
586 <option value=\"9\">9 - {$lang_item['keys']}</option>
587 <option value=\"10\">10 - {$lang_item['gems']}</option>
588 <option value=\"12\">12 - {$lang_item['mining']}</option>
589 </select></td>
590 <td>".makeinfocell($lang_item_edit['bag_slots'],$lang_item_edit['bag_slots_desc'])."</td>
591 <td><input type=\"text\" name=\"ContainerSlots\" size=\"6\" maxlength=\"3\" value=\"0\" /></td>
592 </tr>
593 <tr>
594
595 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['materials']}:</td></tr>
596 <tr>
597 <td>".makeinfocell($lang_item_edit['material'],$lang_item_edit['material_desc'])."</td>
598 <td colspan=\"2\"><select name=\"Material\">
599 <option value=\"-1\">-1 - {$lang_item_edit['consumables']}</option>
600 <option value=\"-1\">0 - {$lang_item_edit['none']}</option>
601 <option value=\"1\">1 - {$lang_item_edit['metal']}</option>
602 <option value=\"2\">2 - {$lang_item_edit['wood']}</option>
603 <option value=\"3\">3 - {$lang_item_edit['liquid']}</option>
604 <option value=\"4\">4 - {$lang_item_edit['jewelry']}</option>
605 <option value=\"5\">5 - {$lang_item_edit['chain']}</option>
606 <option value=\"6\">6 - {$lang_item_edit['plate']}</option>
607 <option value=\"7\">7 - {$lang_item_edit['cloth']}</option>
608 <option value=\"8\">8 - {$lang_item_edit['leather']}</option>
609 </select></td>
610
611 <td>".makeinfocell($lang_item_edit['page_material'],$lang_item_edit['page_material_desc'])."</td>
612 <td colspan=\"2\"><select name=\"PageMaterial\">
613 <option value=\"0\">0 - {$lang_item_edit['none']}</option>
614 <option value=\"1\">1 - {$lang_item_edit['parchment']}</option>
615 <option value=\"2\">2 - {$lang_item_edit['stone']}</option>
616 <option value=\"3\">3 - {$lang_item_edit['marble']}</option>
617 <option value=\"4\">4 - {$lang_item_edit['silver']}</option>
618 <option value=\"5\">5 - {$lang_item_edit['bronze']}</option>
619 </select></td>
620
621<td>".makeinfocell($lang_item_edit['max_durability'],$lang_item_edit['max_durability_desc'])."</td>
622<td><input type=\"text\" name=\"MaxDurability\" size=\"8\" maxlength=\"30\" value=\"10\" /></td>
623</tr>
624
625<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['RandomProperty']}:</td></tr>
626<tr>
627 <td colspan=\"2\">".makeinfocell($lang_item_edit['RandomProperty'],$lang_item_edit['RandomProperty_desc'])."</td>
628 <td colspan=\"2\"><input type=\"text\" name=\"RandomProperty\" size=\"8\" maxlength=\"30\" value=\"0\" /></td>
629
630 <td colspan=\"2\">".makeinfocell($lang_item_edit['RandomSuffix'],$lang_item_edit['RandomSuffix_desc'])."</td>
631 <td colspan=\"2\"><input type=\"text\" name=\"RandomSuffix\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
632</tr>
633
634
635<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['other']}:</td></tr>
636 <tr>
637
638 <td>".makeinfocell($lang_item_edit['area'],$lang_item_edit['area_desc'])."</td>
639 <td><input type=\"text\" name=\"area\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
640
641 <td>".makeinfocell($lang_item_edit['map'],$lang_item_edit['map_desc'])."</td>
642 <td><input type=\"text\" name=\"Map\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
643
644 <td>".makeinfocell($lang_item_edit['page_text'],$lang_item_edit['page_text_desc'])."</td>
645 <td><input type=\"text\" name=\"PageText\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
646
647 <td>".makeinfocell($lang_item_edit['unk0'],$lang_item_edit['unk0_desc'])."</td>
648 <td><input type=\"text\" name=\"unk0\" size=\"8\" maxlength=\"10\" value=\"-1\" /></td>
649 </tr>
650
651 <tr>
652 <td colspan=\"2\">".makeinfocell($lang_item_edit['disenchant_id'],$lang_item_edit['disenchant_id_desc'])."</td>
653 <td><input type=\"text\" name=\"DisenchantID\" size=\"10\" maxlength=\"10\" value=\"0\" /></td>
654
655 <td colspan=\"2\">".makeinfocell($lang_item_edit['req_skill_disenchant'],$lang_item_edit['req_skill_disenchant_desc'])."</td>
656 <td><input type=\"text\" name=\"RequiredDisenchantSkill\" size=\"10\" maxlength=\"10\" value=\"-1\" /></td>
657
658 <td>".makeinfocell($lang_item_edit['lock_id'],$lang_item_edit['lock_id_desc'])."</td>
659 <td><input type=\"text\" name=\"lockid\" size=\"8\" maxlength=\"30\" value=\"0\" /></td>
660 </tr>
661 <tr>
662 <td>".makeinfocell($lang_item_edit['lang_id'],$lang_item_edit['lang_id_desc'])."</td>
663 <td colspan=\"2\"><select name=\"LanguageID\">
664 <option value=\"0\">0 - {$lang_item_edit['other']}</option>
665 <option value=\"1\">1 - Orcish</option>
666 <option value=\"2\">2 - Darnassian</option>
667 <option value=\"3\">3 - Taurahe</option>
668 <option value=\"6\">6 - Dwarvish</option>
669 <option value=\"7\">7 - Common</option>
670 <option value=\"8\">8 - Demonic</option>
671 <option value=\"9\">9 - Titan</option>
672 <option value=\"10\">10 - Thelassian</option>
673 <option value=\"11\">11 - Draconic</option>
674 <option value=\"12\">12 - Kalimag</option>
675 <option value=\"13\">13 - Gnomish</option>
676 <option value=\"14\">14 - Troll</option>
677 <option value=\"33\">33 - Gutterspeak</option>
678 </select></td>
679
680 <td>".makeinfocell($lang_item_edit['sheath'],$lang_item_edit['sheath_desc'])."</td>
681 <td colspan=\"2\"><select name=\"sheath\">
682 <option value=\"0\">0 - {$lang_item_edit['other']}</option>
683 <option value=\"1\">1 - {$lang_item['sword_2h']}</option>
684 <option value=\"2\">2 - {$lang_item['staff']}</option>
685 <option value=\"3\">3 - {$lang_item['sword_1h']}</option>
686 <option value=\"4\">4 - {$lang_item['shield']}</option>
687 <option value=\"5\">5 - {$lang_item['rod']}</option>
688 <option value=\"7\">7 - {$lang_item['off_hand']}</option>
689 </select></td>
690
691 <td>".makeinfocell($lang_item_edit['totem_category'],$lang_item_edit['totem_category_desc'])."</td>
692 <td><input type=\"text\" name=\"TotemCategory\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
693 </tr>
694
695 </table><br /><br />
696 </div>";
697
698$output .= "<div id=\"pane3\">
699 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
700 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['stats']}:</td></tr>
701 <tr>
702 <td>".makeinfocell($lang_item_edit['stat_type']." 1",$lang_item_edit['stat_type_desc'])."</td>
703 <td><select name=\"stat_type1\">";
704 output_status_options(NULL);
705$output .= "</select></td>
706
707 <td><input type=\"text\" name=\"stat_value1\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
708
709 <td>".makeinfocell($lang_item_edit['stat_type']." 2",$lang_item_edit['stat_type_desc'])."</td>
710 <td><select name=\"stat_type2\">";
711 output_status_options(NULL);
712$output .= "</select></td>
713
714 <td><input type=\"text\" name=\"stat_value2\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
715 </tr>
716<tr>
717 <td>".makeinfocell($lang_item_edit['stat_type']." 3",$lang_item_edit['stat_type_desc'])."</td>
718 <td><select name=\"stat_type3\">";
719 output_status_options(NULL);
720$output .= "</select></td>
721
722 <td><input type=\"text\" name=\"stat_value3\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
723
724 <td>".makeinfocell($lang_item_edit['stat_type']." 4",$lang_item_edit['stat_type_desc'])."</td>
725 <td><select name=\"stat_type4\">";
726 output_status_options(NULL);
727$output .= "</select></td>
728
729 <td><input type=\"text\" name=\"stat_value4\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
730 </tr>
731<tr>
732 <td>".makeinfocell($lang_item_edit['stat_type']." 5",$lang_item_edit['stat_type_desc'])."</td>
733 <td><select name=\"stat_type5\">";
734 output_status_options(NULL);
735$output .= "</select></td>
736
737 <td><input type=\"text\" name=\"stat_value5\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
738
739 <td>".makeinfocell($lang_item_edit['stat_type']." 6",$lang_item_edit['stat_type_desc'])."</td>
740 <td><select name=\"stat_type6\">";
741 output_status_options(NULL);
742$output .= "</select></td>
743
744 <td><input type=\"text\" name=\"stat_value6\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
745 </tr>
746<tr>
747 <td>".makeinfocell($lang_item_edit['stat_type']." 7",$lang_item_edit['stat_type_desc'])."</td>
748 <td><select name=\"stat_type7\">";
749 output_status_options(NULL);
750$output .= "</select></td>
751
752 <td><input type=\"text\" name=\"stat_value7\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
753
754 <td>".makeinfocell($lang_item_edit['stat_type']." 8",$lang_item_edit['stat_type_desc'])."</td>
755 <td><select name=\"stat_type8\">";
756 output_status_options(NULL);
757$output .= "</select></td>
758
759 <td><input type=\"text\" name=\"stat_value8\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
760
761 </tr>
762<tr>
763 <td>".makeinfocell($lang_item_edit['stat_type']." 9",$lang_item_edit['stat_type_desc'])."</td>
764 <td><select name=\"stat_type9\">";
765 output_status_options(NULL);
766$output .= "</select></td>
767
768 <td><input type=\"text\" name=\"stat_value9\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
769
770 <td>".makeinfocell($lang_item_edit['stat_type']." 10",$lang_item_edit['stat_type_desc'])."</td>
771 <td><select name=\"stat_type10\">";
772 output_status_options(NULL);
773$output .= "</select></td>
774
775 <td><input type=\"text\" name=\"stat_value10\" size=\"10\" maxlength=\"6\" value=\"0\" /></td>
776 </tr>
777
778 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['resis_armor']}:</td></tr>
779 <tr>
780 <td colspan=\"2\">".makeinfocell($lang_item['armor'],$lang_item_edit['armor_desc'])."</td>
781 <td><input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
782
783 <td colspan=\"2\">".makeinfocell($lang_item['block'],$lang_item_edit['block_desc'])."</td>
784 <td><input type=\"text\" name=\"block\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
785 </tr>
786 <tr>
787 <td colspan=\"2\">".makeinfocell($lang_item['res_holy'],$lang_item_edit['res_holy_desc'])."</td>
788 <td><input type=\"text\" name=\"holy_res\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
789
790 <td colspan=\"2\">".makeinfocell($lang_item['res_fire'],$lang_item_edit['res_fire_desc'])."</td>
791 <td><input type=\"text\" name=\"fire_res\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
792 </tr>
793 <tr>
794 <td colspan=\"2\">".makeinfocell($lang_item['res_nature'],$lang_item_edit['res_nature_desc'])."</td>
795 <td><input type=\"text\" name=\"nature_res\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
796
797 <td colspan=\"2\">".makeinfocell($lang_item['res_frost'],$lang_item_edit['res_frost_desc'])."</td>
798 <td><input type=\"text\" name=\"frost_res\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
799 </tr>
800 <tr>
801 <td colspan=\"2\">".makeinfocell($lang_item['res_shadow'],$lang_item_edit['res_shadow_desc'])."</td>
802 <td><input type=\"text\" name=\"shadow_res\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
803
804 <td colspan=\"2\">".makeinfocell($lang_item['res_arcane'],$lang_item_edit['res_arcane_desc'])."</td>
805 <td><input type=\"text\" name=\"arcane_res\" size=\"10\" maxlength=\"30\" value=\"0\" /></td>
806 </tr>
807 </table><br /><br />
808</div>";
809
810$output .= "<div id=\"pane4\">
811 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
812
813<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_properties']}:</td></tr>
814<tr>
815<td>".makeinfocell($lang_item_edit['delay'],$lang_item_edit['delay_desc'])."</td>
816 <td colspan=\"2\"><input type=\"text\" name=\"delay\" size=\"10\" maxlength=\"11\" value=\"0\" /></td>
817
818 <td>".makeinfocell($lang_item_edit['ranged_mod'],$lang_item_edit['ranged_mod_desc'])."</td>
819 <td colspan=\"2\"><input type=\"text\" name=\"RangedModRange\" size=\"10\" maxlength=\"40\" value=\"0\" /></td>
820</tr>
821<tr>
822 <td>".makeinfocell($lang_item_edit['armor_dmg_mod'],$lang_item_edit['armor_dmg_mod_desc'])."</td>
823 <td colspan=\"2\"><input type=\"text\" name=\"ArmorDamageModifier\" size=\"10\" maxlength=\"40\" value=\"0\" /></td>
824
825 <td>".makeinfocell($lang_item_edit['ammo_type'],$lang_item_edit['ammo_type_desc'])."</td>
826 <td colspan=\"2\"><select name=\"ammo_type\">
827 <option value=\"0\">0 - {$lang_item['none']}</option>
828 <option value=\"2\">2 - {$lang_item['arrows']}</option>
829 <option value=\"3\">3 - {$lang_item['bullets']}</option>
830 </select>
831 </td>
832</tr>
833
834<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_damage']}:</td></tr>
835<tr>
836 <td>".makeinfocell($lang_item_edit['damage_type']." 1",$lang_item_edit['damage_type_desc'])."</td>
837 <td colspan=\"2\"><select name=\"dmg_type1\">";
838 output_dmgtype_options(NULL);
839$output .= "</select></td>
840
841 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
842 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min1\" size=\"8\" maxlength=\"45\" value=\"0\" /> - <input type=\"text\" name=\"dmg_max1\" size=\"8\" maxlength=\"45\" value=\"0\" /></td>
843
844</tr>
845<tr>
846 <td>".makeinfocell($lang_item_edit['damage_type']." 2",$lang_item_edit['damage_type_desc'])."</td>
847 <td colspan=\"2\"><select name=\"dmg_type2\">";
848 output_dmgtype_options(NULL);
849$output .= "</select></td>
850
851 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
852 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min2\" size=\"8\" maxlength=\"45\" value=\"0\" /> - <input type=\"text\" name=\"dmg_max2\" size=\"8\" maxlength=\"45\" value=\"0\" /></td>
853
854</tr>
855<tr>
856 <td>".makeinfocell($lang_item_edit['damage_type']." 3",$lang_item_edit['damage_type_desc'])."</td>
857 <td colspan=\"2\"><select name=\"dmg_type3\">";
858 output_dmgtype_options(NULL);
859$output .= "</select></td>
860
861 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
862 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min3\" size=\"8\" maxlength=\"45\" value=\"0\" /> - <input type=\"text\" name=\"dmg_max3\" size=\"8\" maxlength=\"45\" value=\"0\" /></td>
863
864</tr>
865<tr>
866 <td>".makeinfocell($lang_item_edit['damage_type']." 4",$lang_item_edit['damage_type_desc'])."</td>
867 <td colspan=\"2\"><select name=\"dmg_type4\">";
868 output_dmgtype_options(NULL);
869$output .= "</select></td>
870
871 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
872 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min4\" size=\"8\" maxlength=\"45\" value=\"0\" /> - <input type=\"text\" name=\"dmg_max4\" size=\"8\" maxlength=\"45\" value=\"0\" /></td>
873
874</tr>
875<tr>
876 <td>".makeinfocell($lang_item_edit['damage_type']." 5",$lang_item_edit['damage_type_desc'])."</td>
877 <td colspan=\"2\"><select name=\"dmg_type5\">";
878 output_dmgtype_options(NULL);
879$output .= "</select></td>
880
881 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
882 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min5\" size=\"8\" maxlength=\"45\" value=\"0\" /> - <input type=\"text\" name=\"dmg_max5\" size=\"8\" maxlength=\"45\" value=\"0\" /></td>
883</tr>
884
885</table><br /><br />
886 </div>";
887
888$output .= "<div id=\"pane5\">
889 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
890<tr>
891 <td colspan=\"2\">{$lang_item_edit['item_spell']} 1</td>
892 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
893 <td><input type=\"text\" name=\"spellid_1\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
894
895 <td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
896 <td><select name=\"spelltrigger_1\">
897 <option value=\"0\">0: {$lang_item['spell_use']}</option>
898 <option value=\"1\">1: {$lang_item['spell_equip']}</option>
899 <option value=\"2\">2: {$lang_item['spell_coh']}</option>
900 <option value=\"4\">4: {$lang_item['soul_stone']}</option>
901 </select></td>
902 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
903 <td><input type=\"text\" name=\"spellcharges_1\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
904</tr>
905<tr>
906 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
907 <td><input type=\"text\" name=\"spellcooldown_1\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
908
909 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
910 <td><input type=\"text\" name=\"spellcategory_1\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
911
912 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
913 <td><input type=\"text\" name=\"spellcategorycooldown_1\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
914
915 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
916 <td><input type=\"text\" name=\"spellppmRate_1\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
917</tr>
918<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
919<tr>
920 <td colspan=\"2\">{$lang_item_edit['item_spell']} 2</td>
921 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
922 <td><input type=\"text\" name=\"spellid_2\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
923
924 <td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
925 <td><select name=\"spelltrigger_2\">
926 <option value=\"0\">0: {$lang_item['spell_use']}</option>
927 <option value=\"1\">1: {$lang_item['spell_equip']}</option>
928 <option value=\"2\">2: {$lang_item['spell_coh']}</option>
929 <option value=\"4\">4: {$lang_item['soul_stone']}</option>
930 </select></td>
931 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
932 <td><input type=\"text\" name=\"spellcharges_2\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
933</tr>
934<tr>
935 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
936 <td><input type=\"text\" name=\"spellcooldown_2\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
937
938 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
939 <td><input type=\"text\" name=\"spellcategory_2\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
940
941 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
942 <td><input type=\"text\" name=\"spellcategorycooldown_2\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
943
944 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
945 <td><input type=\"text\" name=\"spellppmRate_2\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
946</tr>
947<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
948<tr>
949 <td colspan=\"2\">{$lang_item_edit['item_spell']} 3</td>
950 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
951 <td><input type=\"text\" name=\"spellid_3\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
952
953 <td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
954 <td><select name=\"spelltrigger_3\">
955 <option value=\"0\">0: {$lang_item['spell_use']}</option>
956 <option value=\"1\">1: {$lang_item['spell_equip']}</option>
957 <option value=\"2\">2: {$lang_item['spell_coh']}</option>
958 <option value=\"4\">4: {$lang_item['soul_stone']}</option>
959 </select></td>
960 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
961 <td><input type=\"text\" name=\"spellcharges_3\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
962</tr>
963<tr>
964 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
965 <td><input type=\"text\" name=\"spellcooldown_3\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
966
967 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
968 <td><input type=\"text\" name=\"spellcategory_3\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
969
970 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
971 <td><input type=\"text\" name=\"spellcategorycooldown_3\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
972
973 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
974 <td><input type=\"text\" name=\"spellppmRate_3\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
975</tr>
976<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
977<tr>
978 <td colspan=\"2\">{$lang_item_edit['item_spell']} 4</td>
979 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
980 <td><input type=\"text\" name=\"spellid_4\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
981
982 <td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
983 <td><select name=\"spelltrigger_4\">
984 <option value=\"0\">0: {$lang_item['spell_use']}</option>
985 <option value=\"1\">1: {$lang_item['spell_equip']}</option>
986 <option value=\"2\">2: {$lang_item['spell_coh']}</option>
987 <option value=\"4\">4: {$lang_item['soul_stone']}</option>
988 </select></td>
989 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
990 <td><input type=\"text\" name=\"spellcharges_4\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
991</tr>
992<tr>
993 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
994 <td><input type=\"text\" name=\"spellcooldown_4\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
995
996 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
997 <td><input type=\"text\" name=\"spellcategory_4\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
998
999 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1000 <td><input type=\"text\" name=\"spellcategorycooldown_4\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
1001
1002 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1003 <td><input type=\"text\" name=\"spellppmRate_4\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
1004</tr>
1005<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
1006<tr>
1007 <td colspan=\"2\">{$lang_item_edit['item_spell']} 5</td>
1008 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
1009 <td><input type=\"text\" name=\"spellid_5\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
1010
1011 <td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
1012 <td><select name=\"spelltrigger_5\">
1013 <option value=\"0\">0: {$lang_item['spell_use']}</option>
1014 <option value=\"1\">1: {$lang_item['spell_equip']}</option>
1015 <option value=\"2\">2: {$lang_item['spell_coh']}</option>
1016 <option value=\"4\">4: {$lang_item['soul_stone']}</option>
1017 </select></td>
1018 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
1019 <td><input type=\"text\" name=\"spellcharges_5\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
1020</tr>
1021<tr>
1022 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
1023 <td><input type=\"text\" name=\"spellcooldown_5\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
1024
1025 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
1026 <td><input type=\"text\" name=\"spellcategory_5\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
1027
1028 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1029 <td><input type=\"text\" name=\"spellcategorycooldown_5\" size=\"6\" maxlength=\"30\" value=\"-1\" /></td>
1030
1031 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1032 <td><input type=\"text\" name=\"spellppmRate_5\" size=\"6\" maxlength=\"30\" value=\"0\" /></td>
1033 </tr>
1034
1035 </table><br /><br />
1036</div>";
1037
1038$output .= "<div id=\"pane6\">
1039 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1040 <tr>
1041 <td>".makeinfocell($lang_item_edit['allow_class'],$lang_item_edit['allow_class_desc'])."</td>
1042 <td><select multiple=\"multiple\" name=\"AllowableClass[]\" size=\"5\">
1043 <option value=\"-1\">-1 - {$lang_item_edit['all']}</option>
1044 <option value=\"1\">1 - {$lang_id_tab['warrior']}</option>
1045 <option value=\"2\">2 - {$lang_id_tab['paladin']}</option>
1046 <option value=\"4\">4 - {$lang_id_tab['hunter']}</option>
1047 <option value=\"8\">8 - {$lang_id_tab['rogue']}</option>
1048 <option value=\"16\">16 - {$lang_id_tab['priest']}</option>
1049 <option value=\"64\">64 - {$lang_id_tab['shaman']}</option>
1050 <option value=\"128\">128 - {$lang_id_tab['mage']}</option>
1051 <option value=\"256\">256 - {$lang_id_tab['warlock']}</option>
1052 <option value=\"1024\">1024 - {$lang_id_tab['druid']}</option>
1053 </select></td>
1054
1055 <td>".makeinfocell($lang_item_edit['allow_race'],$lang_item_edit['allow_race_desc'])."</td>
1056 <td><select multiple=\"multiple\" name=\"AllowableRace[]\" size=\"5\">
1057 <option value=\"-1\">-1 - {$lang_item_edit['all']}</option>
1058 <option value=\"1\">1 - {$lang_id_tab['human']}</option>
1059 <option value=\"2\">2 - {$lang_id_tab['orc']}</option>
1060 <option value=\"4\">4 - {$lang_id_tab['dwarf']}</option>
1061 <option value=\"8\">8 - {$lang_id_tab['nightelf']}</option>
1062 <option value=\"16\">16 - {$lang_id_tab['undead']}</option>
1063 <option value=\"32\">32 - {$lang_id_tab['tauren']}</option>
1064 <option value=\"64\">64 - {$lang_id_tab['gnome']}</option>
1065 <option value=\"128\">128 - {$lang_id_tab['troll']}</option>
1066 <option value=\"256\">256 - {$lang_id_tab['draenei']}</option>
1067 <option value=\"512\">512 - {$lang_id_tab['bloodelf']}</option>
1068 </select></td>
1069
1070</tr>
1071<tr>
1072 <td>".makeinfocell($lang_item_edit['req_skill'],$lang_item_edit['req_skill_desc'])."</td>
1073 <td><input type=\"text\" name=\"RequiredSkill\" size=\"15\" maxlength=\"30\" value=\"0\" /></td>
1074
1075 <td>".makeinfocell($lang_item_edit['req_skill_rank'],$lang_item_edit['req_skill_rank_desc'])."</td>
1076 <td><input type=\"text\" name=\"RequiredSkillRank\" size=\"15\" maxlength=\"30\" value=\"0\" /></td>
1077</tr>
1078<tr>
1079 <td>".makeinfocell($lang_item_edit['req_spell'],$lang_item_edit['req_spell_desc'])."</td>
1080 <td><input type=\"text\" name=\"requiredspell\" size=\"15\" maxlength=\"30\" value=\"0\" /></td>
1081
1082 <td>".makeinfocell($lang_item_edit['req_honor_rank'],$lang_item_edit['req_honor_rank_desc'])."</td>
1083 <td><input type=\"text\" name=\"requiredhonorrank\" size=\"15\" maxlength=\"30\" value=\"0\" /></td>
1084</tr>
1085<tr>
1086 <td>".makeinfocell($lang_item_edit['req_rep_faction'],$lang_item_edit['req_rep_faction_desc'])."</td>
1087 <td><input type=\"text\" name=\"RequiredReputationFaction\" size=\"15\" maxlength=\"30\" value=\"0\" /></td>
1088
1089 <td>".makeinfocell($lang_item_edit['req_rep_rank'],$lang_item_edit['req_rep_rank_desc'])."</td>
1090 <td><select name=\"RequiredReputationRank\">
1091 <option value=\"0\">0 - {$lang_item_edit['hated']}</option>
1092 <option value=\"1\">1 - {$lang_item_edit['hostile']}</option>
1093 <option value=\"2\">2 - {$lang_item_edit['unfriendly']}</option>
1094 <option value=\"3\">3 - {$lang_item_edit['neutral']}</option>
1095 <option value=\"4\">4 - {$lang_item_edit['friendly']}</option>
1096 <option value=\"5\">5 - {$lang_item_edit['honored']}</option>
1097 <option value=\"6\">6 - {$lang_item_edit['reverted']}</option>
1098 <option value=\"7\">7 - {$lang_item_edit['exalted']}</option>
1099 </select></td>
1100</tr>
1101<tr>
1102 <td colspan=\"2\">".makeinfocell($lang_item_edit['req_city_rank'],$lang_item_edit['req_city_rank_desc'])."</td>
1103 <td colspan=\"2\"><input type=\"text\" name=\"RequiredCityRank\" size=\"15\" maxlength=\"30\" value=\"0\" /></td>
1104</tr>
1105
1106 </table><br /><br />
1107 </div>";
1108
1109$output .= "<div id=\"pane7\">
1110 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1111
1112<tr>
1113 <td>".makeinfocell($lang_item_edit['socket_color']." 1",$lang_item_edit['socket_color_desc'])."</td>
1114 <td><select name=\"socketColor_1\">
1115 <option value=\"0\">0: {$lang_item['none']}</option>
1116 <option value=\"1\">1: {$lang_item['socket_meta']}</option>
1117 <option value=\"2\">2: {$lang_item['socket_red']}</option>
1118 <option value=\"4\">4: {$lang_item['socket_yellow']}</option>
1119 <option value=\"8\">8: {$lang_item['socket_blue']}</option>
1120 </select></td>
1121
1122 <td>".makeinfocell($lang_item_edit['socket_content']." 1",$lang_item_edit['socket_content_desc'])."</td>
1123 <td><input type=\"text\" name=\"socketContent_1\" size=\"15\" maxlength=\"10\" value=\"0\" /></td>
1124</tr>
1125<tr>
1126 <td>".makeinfocell($lang_item_edit['socket_color']." 2",$lang_item_edit['socket_color_desc'])."</td>
1127 <td><select name=\"socketColor_2\">
1128 <option value=\"0\">0: {$lang_item['none']}</option>
1129 <option value=\"1\">1: {$lang_item['socket_meta']}</option>
1130 <option value=\"2\">2: {$lang_item['socket_red']}</option>
1131 <option value=\"4\">4: {$lang_item['socket_yellow']}</option>
1132 <option value=\"8\">8: {$lang_item['socket_blue']}</option>
1133 </select></td>
1134
1135 <td>".makeinfocell($lang_item_edit['socket_content']." 2",$lang_item_edit['socket_content_desc'])."</td>
1136 <td><input type=\"text\" name=\"socketContent_2\" size=\"15\" maxlength=\"10\" value=\"0\" /></td>
1137</tr>
1138<tr>
1139 <td>".makeinfocell($lang_item_edit['socket_color']." 3",$lang_item_edit['socket_color_desc'])."</td>
1140 <td><select name=\"socketColor_3\">
1141 <option value=\"0\">0: {$lang_item['none']}</option>
1142 <option value=\"1\">1: {$lang_item['socket_meta']}</option>
1143 <option value=\"2\">2: {$lang_item['socket_red']}</option>
1144 <option value=\"4\">4: {$lang_item['socket_yellow']}</option>
1145 <option value=\"8\">8: {$lang_item['socket_blue']}</option>
1146 </select></td>
1147
1148 <td>".makeinfocell($lang_item_edit['socket_content']." 3",$lang_item_edit['socket_content_desc'])."</td>
1149 <td><input type=\"text\" name=\"socketContent_3\" size=\"15\" maxlength=\"10\" value=\"0\" /></td>
1150</tr>
1151
1152<tr>
1153 <td>".makeinfocell($lang_item_edit['socket_bonus'],$lang_item_edit['socket_bonus_desc'])."</td>
1154 <td><input type=\"text\" name=\"socketBonus\" size=\"15\" maxlength=\"10\" value=\"0\" /></td>
1155
1156 <td>".makeinfocell($lang_item_edit['gem_properties'],$lang_item_edit['gem_properties_desc'])."</td>
1157 <td><input type=\"text\" name=\"GemProperties\" size=\"15\" maxlength=\"10\" value=\"0\" /></td>
1158</tr>
1159
1160 </table><br /><br />
1161 </div>
1162
1163 </div>
1164</div>
1165<br />
1166</form>
1167
1168<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
1169
1170 $output .= "<table class=\"hidden\">
1171 <tr><td>";
1172 makebutton($lang_item_edit['update'], "javascript:do_submit('form1',0)",180);
1173 makebutton($lang_item_edit['export_sql'], "javascript:do_submit('form1',1)",180);
1174 makebutton($lang_item_edit['search_items'], "item.php",180);
1175 $output .= "</td></tr>
1176 </table></center>";
1177
1178}
1179
1180
1181//########################################################################################################################
1182// EDIT ITEM FORM
1183//########################################################################################################################
1184function edit() {
1185 global $lang_global, $lang_item_templ, $lang_item, $lang_item_edit, $output, $world_db, $realm_id,
1186 $item_datasite, $lang_id_tab, $quest_datasite;
1187
1188 if (!isset($_GET['entry'])) redirect("item.php?error=1");
1189
1190 $sql = new SQL;
1191 $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
1192
1193 $entry = $sql->quote_smart($_GET['entry']);
1194 $deplang = get_lang_id();
1195 $result = $sql->query("SELECT `item_template`.`entry`,`class`,`subclass`,`unk0`,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`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`,`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`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`RandomSuffix`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`TotemCategory`,`socketColor_1`,`socketContent_1`,`socketColor_2`,`socketContent_2`,`socketColor_3`,`socketContent_3`,`socketBonus`,`GemProperties`,`RequiredDisenchantSkill`,`ArmorDamageModifier`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot` FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry WHERE item_template.entry = '$entry'");
1196
1197 if ($result){
1198 $item = $sql->fetch_assoc($result);
1199 require_once("scripts/get_lib.php");
1200 $tooltip = get_item_tooltip($entry);
1201
1202 $output .= "<script type=\"text/javascript\" src=\"js/tab.js\"></script>
1203 <center>
1204 <br /><br /><br />
1205 <form method=\"post\" action=\"item.php?action=do_update\" name=\"form1\">
1206 <input type=\"hidden\" name=\"backup_op\" value=\"0\"/>
1207 <input type=\"hidden\" name=\"type\" value=\"edit\"/>
1208 <input type=\"hidden\" name=\"entry\" value=\"$entry\"/>
1209
1210<div class=\"jtab-container\" id=\"container\">
1211 <ul class=\"jtabs\">
1212 <li><a href=\"#\" onclick=\"return showPane('pane1', this)\" id=\"tab1\">{$lang_item_edit['general_tab']}</a></li>
1213 <li><a href=\"#\" onclick=\"return showPane('pane2', this)\">{$lang_item_edit['additional_tab']}</a></li>
1214 <li><a href=\"#\" onclick=\"return showPane('pane3', this)\">{$lang_item_edit['stats_tab']}</a></li>
1215 <li><a href=\"#\" onclick=\"return showPane('pane4', this)\">{$lang_item_edit['damage_tab']}</a></li>
1216 <li><a href=\"#\" onclick=\"return showPane('pane5', this)\">{$lang_item_edit['spell_tab']}</a></li>
1217 <li><a href=\"#\" onclick=\"return showPane('pane7', this)\">{$lang_item_edit['sock_tab']}</a></li>
1218 <li><a href=\"#\" onclick=\"return showPane('pane6', this)\">{$lang_item_edit['req_tab']}</a></li>
1219 <li><a href=\"#\" onclick=\"return showPane('pane8', this)\">{$lang_item_edit['info']}</a></li>";
1220 if ($item['DisenchantID']) $output .= "<li><a href=\"#\" onclick=\"return showPane('pane9', this)\">{$lang_item_edit['disenchant_tab']}</a></li>";
1221$output .= "</ul>
1222 <div class=\"jtab-panes\">";
1223
1224
1225$output .= "<div id=\"pane1\">
1226 <br /><br />
1227<table class=\"lined\" style=\"width: 720px;\">
1228<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['general']}:</td></tr>
1229<tr>
1230 <td>".makeinfocell($lang_item_edit['entry'],$lang_item_edit['entry_desc'])."</td>
1231 <td>";
1232 $output .= maketooltip($entry, "$item_datasite$entry", $tooltip, "item_tooltip");
1233 $output .= "</td>
1234 <td>".makeinfocell($lang_item_edit['display_id'],$lang_item_edit['display_id_desc'])."</td>
1235 <td><input type=\"text\" name=\"displayid\" size=\"8\" maxlength=\"11\" value=\"{$item['displayid']}\" /></td>
1236
1237 <td>".makeinfocell($lang_item_edit['req_level'],$lang_item_edit['req_level_desc'])."</td>
1238 <td><input type=\"text\" name=\"RequiredLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['RequiredLevel']}\" /></td>
1239
1240 <td>".makeinfocell($lang_item_edit['item_level'],$lang_item_edit['item_level_desc'])."</td>
1241 <td><input type=\"text\" name=\"ItemLevel\" size=\"8\" maxlength=\"4\" value=\"{$item['ItemLevel']}\" /></td>
1242</tr>
1243
1244<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['names']}:</td></tr>
1245<tr>
1246 <td>".makeinfocell($lang_item_edit['item_name'],$lang_item_edit['item_name_desc'])."</td>
1247 <td colspan=\"3\"><input type=\"text\" name=\"name\" size=\"30\" maxlength=\"225\" value=\"{$item['name']}\" /></td>
1248
1249 <td>".makeinfocell($lang_item_edit['script_name'],$lang_item_edit['script_name_desc'])."</td>
1250 <td colspan=\"3\"><input type=\"text\" name=\"ScriptName\" size=\"30\" maxlength=\"100\" value=\"{$item['ScriptName']}\" /></td>
1251</tr>
1252
1253<tr>
1254 <td>".makeinfocell($lang_item_edit['description'],$lang_item_edit['description_desc'])."</td>
1255 <td colspan=\"3\"><input type=\"text\" name=\"description\" size=\"30\" maxlength=\"225\" value=\"{$item['description']}\" /></td>
1256 <td colspan=\"4\"></td>
1257</tr>
1258
1259<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['type']}:</td></tr>
1260 <tr>";
1261
1262 $class = array( 0 => "", 1 => "", 2 => "", 4 => "", 5 => "", 6 => "", 7 => "", 9 => "", 11 => "", 12 => "", 13 => "",
1263 14 => "",15 => "" );
1264 $class[$item['class']] = " selected=\"selected\" ";
1265
1266$output .= "<td>".makeinfocell($lang_item_edit['class'],$lang_item_edit['class_desc'])."</td>
1267 <td colspan=\"3\"><select name=\"class\">
1268 <option value=\"0\" {$class[0]}>0 - {$lang_item['consumable']}</option>
1269 <option value=\"1\" {$class[1]}>1 - {$lang_item['bag']}</option>
1270 <option value=\"2\" {$class[2]}>2 - {$lang_item['weapon']}</option>
1271 <option value=\"4\" {$class[4]}>4 - {$lang_item['armor']}</option>
1272 <option value=\"5\" {$class[5]}>5 - {$lang_item['reagent']}</option>
1273 <option value=\"6\" {$class[6]}>6 - {$lang_item['projectile']}</option>
1274 <option value=\"7\" {$class[7]}>7 - {$lang_item['trade_goods']}s</option>
1275 <option value=\"9\" {$class[9]}>9 - {$lang_item['recipe']}</option>
1276 <option value=\"11\" {$class[11]}>11 - {$lang_item['quiver']}</option>
1277 <option value=\"12\" {$class[12]}>12 - {$lang_item['quest']}</option>
1278 <option value=\"13\" {$class[13]}>13 - {$lang_item['key']}</option>
1279 <option value=\"14\" {$class[14]}>14 - {$lang_item['permanent']}</option>
1280 <option value=\"15\" {$class[15]}>15 - {$lang_item['misc_short']}</option>
1281 </select></td>";
1282 unset($class);
1283
1284 $subclass = array(
1285 0 => array(0 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => ""),
1286 1 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => ""),
1287 2 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 10 => "",
1288 11 => "", 12 => "", 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => ""),
1289 4 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => ""),
1290 6 => array(2 => "", 3 => ""),
1291 7 => array(0 => "", 1 => "", 2 => "", 3 => ""),
1292 9 => array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "",10 => ""),
1293 11 => array(2 => "", 3 => ""),
1294 13 => array(0 => "", 1 => "")
1295 );
1296 $subclass[$item['class']][$item['subclass']] = " selected=\"selected\" ";
1297
1298$output .= "<td>".makeinfocell($lang_item_edit['subclass'],$lang_item_edit['subclass_desc'])."</td>
1299 <td colspan=\"3\"><select name=\"subclass\">
1300 <option value=\"0\" {$subclass[0][0]}>0 - {$lang_item['none']}</option>
1301 <optgroup label=\"Class 0: {$lang_item['consumable']}\">
1302 <option value=\"0\" {$subclass[0][0]}>0 - {$lang_item['consumable']}</option>
1303 <option value=\"3\" {$subclass[0][3]}>3 - {$lang_item['potion']}</option>
1304 <option value=\"4\" {$subclass[0][4]}>4 - {$lang_item['scroll']}</option>
1305 <option value=\"5\" {$subclass[0][5]}>5 - {$lang_item['bandage']}</option>
1306 <option value=\"6\" {$subclass[0][6]}>6 - {$lang_item['healthstone']}</option>
1307 <option value=\"7\" {$subclass[0][7]}>7 - {$lang_item['combat_effect']}</option>
1308 <optgroup label=\"Class 1: {$lang_item['bag']}\">
1309 <option value=\"0\" {$subclass[1][0]}>0 - {$lang_item['bag']}</option>
1310 <option value=\"1\" {$subclass[1][1]}>1 - {$lang_item['soul_shards']}</option>
1311 <option value=\"2\" {$subclass[1][2]}>2 - {$lang_item['herbs']}</option>
1312 <option value=\"3\" {$subclass[1][3]}>3 - {$lang_item['enchanting']}</option>
1313 <option value=\"4\" {$subclass[1][4]}>4 - {$lang_item['engineering']}</option>
1314 <option value=\"5\" {$subclass[1][5]}>5 - {$lang_item['gems']}</option>
1315 <option value=\"6\" {$subclass[1][6]}>6 - {$lang_item['mining']}</option>
1316 <optgroup label=\"Class 2: {$lang_item['weapon']}\">
1317 <option value=\"0\" {$subclass[2][0]}>0 - {$lang_item['axe_1h']}</option>
1318 <option value=\"1\" {$subclass[2][2]}>1 - {$lang_item['axe_2h']}</option>
1319 <option value=\"2\" {$subclass[2][2]}>2 - {$lang_item['bow']}</option>
1320 <option value=\"3\" {$subclass[2][2]}>3 - {$lang_item['rifle']}</option>
1321 <option value=\"4\" {$subclass[2][4]}>4 - {$lang_item['mace_1h']}</option>
1322 <option value=\"5\" {$subclass[2][5]}>5 - {$lang_item['mace_2h']}</option>
1323 <option value=\"6\" {$subclass[2][6]}>6 - {$lang_item['polearm']}</option>
1324 <option value=\"7\" {$subclass[2][7]}>7 - {$lang_item['sword_1h']}</option>
1325 <option value=\"8\" {$subclass[2][8]}>8 - {$lang_item['sword_2h']}</option>
1326 <option value=\"10\" {$subclass[2][10]}>10 - {$lang_item['staff']}</option>
1327 <option value=\"11\" {$subclass[2][11]}>11 - {$lang_item['exotic_1h']}</option>
1328 <option value=\"12\" {$subclass[2][12]}>12 - {$lang_item['exotic_2h']}</option>
1329 <option value=\"13\" {$subclass[2][13]}>13 - {$lang_item['fist_weapon']}</option>
1330 <option value=\"14\" {$subclass[2][14]}>14 - {$lang_item['misc_weapon']}</option>
1331 <option value=\"15\" {$subclass[2][15]}>15 - {$lang_item['dagger']}</option>
1332 <option value=\"16\" {$subclass[2][16]}>16 - {$lang_item['thrown']}</option>
1333 <option value=\"17\" {$subclass[2][17]}>17 - {$lang_item['spear']}</option>
1334 <option value=\"18\" {$subclass[2][18]}>18 - {$lang_item['crossbow']}</option>
1335 <option value=\"19\" {$subclass[2][19]}>19 - {$lang_item['wand']}</option>
1336 <option value=\"20\" {$subclass[2][20]}>20 - {$lang_item['fishing_pole']}</option>
1337 </optgroup>
1338 <optgroup label=\"Class 4: {$lang_item['armor']}\">
1339 <option value=\"0\" {$subclass[4][0]}>0 - {$lang_item['misc']}</option>
1340 <option value=\"1\" {$subclass[4][1]}>1 - {$lang_item['cloth']}</option>
1341 <option value=\"2\" {$subclass[4][2]}>2 - {$lang_item['leather']}</option>
1342 <option value=\"3\" {$subclass[4][3]}>3 - {$lang_item['mail']}</option>
1343 <option value=\"4\" {$subclass[4][4]}>4 - {$lang_item['plate']}</option>
1344 <option value=\"5\" {$subclass[4][5]}>5 - {$lang_item['buckler']}</option>
1345 <option value=\"6\" {$subclass[4][6]}>6 - {$lang_item['shield']}</option>
1346 <option value=\"7\" {$subclass[4][7]}>7 - {$lang_item['libram']}</option>
1347 <option value=\"8\" {$subclass[4][8]}>8 - {$lang_item['idol']}</option>
1348 <option value=\"9\" {$subclass[4][9]}>9 - {$lang_item['totem']}</option>
1349 </optgroup>
1350 <optgroup label=\"Class 6: {$lang_item['projectile']}\">
1351 <option value=\"2\" {$subclass[6][2]}>2 - {$lang_item['arrows']}</option>
1352 <option value=\"3\" {$subclass[6][3]}>3 - {$lang_item['bullets']}</option>
1353 </optgroup>
1354 <optgroup label=\"Class 7: {$lang_item['trade_goods']}\">
1355 <option value=\"0\" {$subclass[7][0]}>0 - {$lang_item['trade_goods']}</option>
1356 <option value=\"1\" {$subclass[7][1]}>1 - {$lang_item['parts']}</option>
1357 <option value=\"2\" {$subclass[7][2]}>2 - {$lang_item['explosives']}</option>
1358 <option value=\"3\" {$subclass[7][3]}>3 - {$lang_item['devices']}</option>
1359 </optgroup>
1360 <optgroup label=\"Class 9: {$lang_item['recipe']}\">
1361 <option value=\"0\" {$subclass[9][0]}>0 - {$lang_item['book']}</option>
1362 <option value=\"1\" {$subclass[9][1]}>1 - {$lang_item['LW_pattern']}</option>
1363 <option value=\"2\" {$subclass[9][2]}>2 - {$lang_item['tailoring_pattern']}</option>
1364 <option value=\"3\" {$subclass[9][3]}>3 - {$lang_item['ENG_Schematic']}</option>
1365 <option value=\"4\" {$subclass[9][4]}>4 - {$lang_item['BS_plans']}</option>
1366 <option value=\"5\" {$subclass[9][5]}>5 - {$lang_item['cooking_recipe']}</option>
1367 <option value=\"6\" {$subclass[9][6]}>6 - {$lang_item['alchemy_recipe']}</option>
1368 <option value=\"7\" {$subclass[9][7]}>7 - {$lang_item['FA_manual']}</option>
1369 <option value=\"8\" {$subclass[9][8]}>8 - {$lang_item['ench_formula']}</option>
1370 <option value=\"9\" {$subclass[9][9]}>9 - {$lang_item['fishing_manual']}</option>
1371 <option value=\"10\" {$subclass[9][10]}>10 - {$lang_item['JC_formula']}</option>
1372 </optgroup>
1373 <optgroup label=\"Class 11: {$lang_item['quiver']}\">
1374 <option value=\"2\" {$subclass[11][2]}>2 - {$lang_item['quiver']}</option>
1375 <option value=\"3\" {$subclass[11][3]}>3 - {$lang_item['ammo_pouch']}</option>
1376 </optgroup>
1377 <optgroup label=\"Class 13: {$lang_item['key']}\">
1378 <option value=\"0\" {$subclass[13][0]}>0 - {$lang_item['key']}</option>
1379 <option value=\"1\" {$subclass[13][1]}>1 - {$lang_item['lockpick']}</option>
1380 </optgroup>
1381 </select></td>
1382</tr>
1383<tr>";
1384unset($subclass);
1385
1386$quality = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "" );
1387$quality[$item['Quality']] = " selected=\"selected\" ";
1388
1389$output .= "<td>".makeinfocell($lang_item_edit['quality'],$lang_item_edit['quality_desc'])."</td>
1390 <td colspan=\"2\"><select name=\"Quality\">
1391 <option value=\"0\" {$quality[0]}>0 - {$lang_item['poor']}</option>
1392 <option value=\"1\" {$quality[1]}>1 - {$lang_item['common']}</option>
1393 <option value=\"2\" {$quality[2]}>2 - {$lang_item['uncommon']}</option>
1394 <option value=\"3\" {$quality[3]}>3 - {$lang_item['rare']}</option>
1395 <option value=\"4\" {$quality[4]}>4 - {$lang_item['epic']}</option>
1396 <option value=\"5\" {$quality[5]}>5 - {$lang_item['legendary']}</option>
1397 <option value=\"6\" {$quality[6]}>6 - {$lang_item['artifact']}</option>
1398 </select></td>";
1399 unset($quality);
1400
1401$inv_type = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "", 12 => "",
1402 13 => "", 14 => "", 15 => "", 16 => "", 17 => "", 18 => "", 19 => "", 20 => "", 21 => "", 22 => "", 23 => "",
1403 24 => "", 25 => "", 26 => "");
1404$inv_type[$item['InventoryType']] = " selected=\"selected\" ";
1405
1406$output .= "<td>".makeinfocell($lang_item_edit['inv_type'],$lang_item_edit['inv_type_desc'])."</td>
1407 <td colspan=\"2\"><select name=\"InventoryType\">
1408 <option value=\"0\" {$inv_type[0]}>0 - {$lang_item['other']}</option>
1409 <option value=\"1\" {$inv_type[1]}>1 - {$lang_item['head']}</option>
1410 <option value=\"2\" {$inv_type[2]}>2 - {$lang_item['neck']}</option>
1411 <option value=\"3\" {$inv_type[3]}>3 - {$lang_item['shoulder']}</option>
1412 <option value=\"4\" {$inv_type[4]}>4 - {$lang_item['shirt']}</option>
1413 <option value=\"5\" {$inv_type[5]}>5 - {$lang_item['chest']}</option>
1414 <option value=\"6\" {$inv_type[6]}>6 - {$lang_item['belt']}</option>
1415 <option value=\"7\" {$inv_type[7]}>7 - {$lang_item['legs']}</option>
1416 <option value=\"8\" {$inv_type[8]}>8 - {$lang_item['feet']}</option>
1417 <option value=\"9\" {$inv_type[9]}>9 - {$lang_item['belt']}</option>
1418 <option value=\"10\" {$inv_type[10]}>10 - {$lang_item['gloves']}</option>
1419 <option value=\"11\" {$inv_type[11]}>11 - {$lang_item['finger']}</option>
1420 <option value=\"12\" {$inv_type[12]}>12 - {$lang_item['trinket']}</option>
1421 <option value=\"13\" {$inv_type[13]}>13 - {$lang_item['one_hand']}</option>
1422 <option value=\"14\" {$inv_type[14]}>14 - {$lang_item['off_hand']}</option>
1423 <option value=\"15\" {$inv_type[15]}>15 - {$lang_item['bow']}</option>
1424 <option value=\"16\" {$inv_type[16]}>16 - {$lang_item['back']}</option>
1425 <option value=\"17\" {$inv_type[17]}>17 - {$lang_item['two_hand']}</option>
1426 <option value=\"18\" {$inv_type[18]}>18 - {$lang_item['bag']}</option>
1427 <option value=\"19\" {$inv_type[19]}>19 - {$lang_item['tabard']}</option>
1428 <option value=\"20\" {$inv_type[20]}>20 - {$lang_item['robe']}</option>
1429 <option value=\"21\" {$inv_type[21]}>21 - {$lang_item['main_hand']}</option>
1430 <option value=\"22\" {$inv_type[22]}>22 - {$lang_item['off_misc']}</option>
1431 <option value=\"23\" {$inv_type[23]}>23 - {$lang_item['tome']}</option>
1432 <option value=\"24\" {$inv_type[24]}>24 - {$lang_item['projectile']}</option>
1433 <option value=\"25\" {$inv_type[25]}>25 - {$lang_item['thrown']}</option>
1434 <option value=\"26\" {$inv_type[26]}>26 - {$lang_item['rifle']}</option>
1435 </select></td>
1436
1437 <td>".makeinfocell($lang_item_edit['flags'],$lang_item_edit['flags_desc'])."</td>
1438 <td><input type=\"text\" name=\"Flags\" size=\"10\" maxlength=\"30\" value=\"{$item['Flags']}\" /></td>
1439 </tr>
1440
1441 <tr>
1442 <td>".makeinfocell($lang_item_edit['item_set'],$lang_item_edit['item_set_desc'])."</td>
1443 <td><input type=\"text\" name=\"itemset\" size=\"10\" maxlength=\"30\" value=\"{$item['itemset']}\" /></td>";
1444 unset($inv_type);
1445
1446$bonding = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "" );
1447$bonding[$item['bonding']] = " selected=\"selected\" ";
1448
1449$output .= "<td>".makeinfocell($lang_item_edit['bonding'],$lang_item_edit['bonding_desc'])."</td>
1450 <td colspan=\"3\"><select name=\"bonding\">
1451 <option value=\"0\" {$bonding[0]}>0 - {$lang_item['no_bind']}</option>
1452 <option value=\"1\" {$bonding[1]}>1 - {$lang_item['bop']}</option>
1453 <option value=\"2\" {$bonding[2]}>2 - {$lang_item['boe']}</option>
1454 <option value=\"3\" {$bonding[3]}>3 - {$lang_item['bou']}</option>
1455 <option value=\"4\" {$bonding[4]}>4 - {$lang_item['quest_item']}</option>
1456 <option value=\"5\" {$bonding[5]}>5 - {$lang_item['quest_item']}1</option>
1457 </select></td>
1458
1459<td>".makeinfocell($lang_item_edit['start_quest'],$lang_item_edit['start_quest_desc'])."</td>
1460<td><input type=\"text\" name=\"startquest\" size=\"10\" maxlength=\"30\" value=\"{$item['startquest']}\" /></td>
1461
1462</tr>
1463</table>
1464<br />{$lang_item_edit['short_rules_desc']}<br /><br />
1465</div>";
1466 unset($bonding);
1467
1468$output .= "<div id=\"pane2\">
1469 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1470 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['vendor']}:</td></tr>
1471 <tr>
1472 <td>".makeinfocell($lang_item_edit['buy_count'],$lang_item_edit['buy_count_desc'])."</td>
1473 <td><input type=\"text\" name=\"BuyCount\" size=\"8\" maxlength=\"3\" value=\"{$item['BuyCount']}\" /></td>
1474
1475 <td>".makeinfocell($lang_item_edit['buy_price'],$lang_item_edit['buy_price_desc'])."</td>
1476 <td><input type=\"text\" name=\"BuyPrice\" size=\"8\" maxlength=\"30\" value=\"{$item['BuyPrice']}\" /></td>
1477
1478 <td>".makeinfocell($lang_item_edit['sell_price'],$lang_item_edit['sell_price_desc'])."</td>
1479 <td><input type=\"text\" name=\"SellPrice\" size=\"8\" maxlength=\"30\" value=\"{$item['SellPrice']}\" /></td>
1480 <td></td><td></td>
1481 </tr>
1482
1483 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['container']}:</td></tr>
1484 <tr>
1485
1486 <td>".makeinfocell($lang_item_edit['max_count'],$lang_item_edit['max_count_desc'])."</td>
1487 <td><input type=\"text\" name=\"maxcount\" size=\"6\" maxlength=\"5\" value=\"{$item['maxcount']}\" /></td>
1488
1489 <td>".makeinfocell($lang_item_edit['stackable'],$lang_item_edit['stackable_desc'])."</td>
1490 <td><input type=\"text\" name=\"stackable\" size=\"6\" maxlength=\"5\" value=\"{$item['stackable']}\" /></td>
1491
1492 <td>".makeinfocell($lang_item_edit['bag_family'],$lang_item_edit['bag_family_desc'])."</td>";
1493
1494$bagfamily = array( 0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 12 => "" );
1495$bagfamily[$item['BagFamily']] = " selected=\"selected\" ";
1496
1497$output .= "<td><select name=\"BagFamily\">
1498 <option value=\"0\" {$bagfamily[0]}>0 - {$lang_item['none']}</option>
1499 <option value=\"1\" {$bagfamily[1]}>1 - {$lang_item['arrows']}</option>
1500 <option value=\"2\" {$bagfamily[2]}>2 - {$lang_item['bullets']}</option>
1501 <option value=\"3\" {$bagfamily[3]}>3 - {$lang_item['soul_shards']}</option>
1502 <option value=\"6\" {$bagfamily[6]}>6 - {$lang_item['herbs']}</option>
1503 <option value=\"7\" {$bagfamily[7]}>7 - {$lang_item['enchanting']}</option>
1504 <option value=\"8\" {$bagfamily[8]}>8 - {$lang_item['engineering']}</option>
1505 <option value=\"9\" {$bagfamily[9]}>9 - {$lang_item['keys']}</option>
1506 <option value=\"10\" {$bagfamily[10]}>10 - {$lang_item['gems']}</option>
1507 <option value=\"12\" {$bagfamily[12]}>12 - {$lang_item['mining']}</option>
1508 </select></td>
1509 <td>".makeinfocell($lang_item_edit['bag_slots'],$lang_item_edit['bag_slots_desc'])."</td>
1510 <td><input type=\"text\" name=\"ContainerSlots\" size=\"10\" maxlength=\"3\" value=\"{$item['ContainerSlots']}\" /></td>
1511 </tr>
1512 <tr>
1513
1514 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['materials']}:</td></tr>";
1515 unset($bagfamily);
1516
1517$Material = array( -1 => "", 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 6 => "", 7 => "", 8 => "");
1518$Material[$item['Material']] = " selected=\"selected\" ";
1519
1520$output .= "<tr>
1521 <td>".makeinfocell($lang_item_edit['material'],$lang_item_edit['material_desc'])."</td>
1522 <td colspan=\"2\"><select name=\"Material\">
1523 <option value=\"-1\" {$Material[-1]}>-1 - {$lang_item_edit['consumables']}</option>
1524 <option value=\"0\" {$Material[0]}>0 - {$lang_item_edit['none']}</option>
1525 <option value=\"1\" {$Material[1]}>1 - {$lang_item_edit['metal']}</option>
1526 <option value=\"2\" {$Material[2]}>2 - {$lang_item_edit['wood']}</option>
1527 <option value=\"3\" {$Material[3]}>3 - {$lang_item_edit['liquid']}</option>
1528 <option value=\"4\" {$Material[4]}>4 - {$lang_item_edit['jewelry']}</option>
1529 <option value=\"5\" {$Material[5]}>5 - {$lang_item_edit['chain']}</option>
1530 <option value=\"6\" {$Material[6]}>6 - {$lang_item_edit['plate']}</option>
1531 <option value=\"7\" {$Material[7]}>7 - {$lang_item_edit['cloth']}</option>
1532 <option value=\"8\" {$Material[8]}>8 - {$lang_item_edit['leather']}</option>
1533 </select></td>";
1534 unset($Material);
1535
1536$PageMaterial = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "");
1537$PageMaterial[$item['PageMaterial']] = " selected=\"selected\" ";
1538
1539$output .= "<td>".makeinfocell($lang_item_edit['page_material'],$lang_item_edit['page_material_desc'])."</td>
1540 <td colspan=\"2\"><select name=\"PageMaterial\">
1541 <option value=\"0\" {$PageMaterial[0]}>0 - {$lang_item_edit['none']}</option>
1542 <option value=\"1\" {$PageMaterial[1]}>1 - {$lang_item_edit['parchment']}</option>
1543 <option value=\"2\" {$PageMaterial[2]}>2 - {$lang_item_edit['stone']}</option>
1544 <option value=\"3\" {$PageMaterial[3]}>3 - {$lang_item_edit['marble']}</option>
1545 <option value=\"4\" {$PageMaterial[4]}>4 - {$lang_item_edit['silver']}</option>
1546 <option value=\"5\" {$PageMaterial[5]}>5 - {$lang_item_edit['bronze']}</option>
1547 </select></td>";
1548 unset($PageMaterial);
1549
1550$output .= "<td>".makeinfocell($lang_item_edit['max_durability'],$lang_item_edit['max_durability_desc'])."</td>
1551 <td><input type=\"text\" name=\"MaxDurability\" size=\"8\" maxlength=\"30\" value=\"{$item['MaxDurability']}\" /></td>
1552</tr>
1553
1554<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['RandomProperty']}:</td></tr>
1555<tr>
1556 <td colspan=\"2\">".makeinfocell($lang_item_edit['RandomProperty'],$lang_item_edit['RandomProperty_desc'])."</td>
1557 <td colspan=\"2\"><input type=\"text\" name=\"RandomProperty\" size=\"8\" maxlength=\"30\" value=\"{$item['RandomProperty']}\" /></td>
1558
1559 <td colspan=\"2\">".makeinfocell($lang_item_edit['RandomSuffix'],$lang_item_edit['RandomSuffix_desc'])."</td>
1560 <td colspan=\"2\"><input type=\"text\" name=\"RandomSuffix\" size=\"8\" maxlength=\"10\" value=\"{$item['RandomSuffix']}\" /></td>
1561</tr>
1562
1563
1564<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['other']}:</td></tr>
1565 <tr>
1566 <td>".makeinfocell($lang_item_edit['area'],$lang_item_edit['area_desc'])."</td>
1567 <td><input type=\"text\" name=\"area\" size=\"8\" maxlength=\"10\" value=\"{$item['area']}\" /></td>
1568
1569 <td>".makeinfocell($lang_item_edit['map'],$lang_item_edit['map_desc'])."</td>
1570 <td><input type=\"text\" name=\"Map\" size=\"8\" maxlength=\"10\" value=\"{$item['Map']}\" /></td>
1571
1572 <td>".makeinfocell($lang_item_edit['page_text'],$lang_item_edit['page_text_desc'])."</td>
1573 <td><input type=\"text\" name=\"PageText\" size=\"6\" maxlength=\"30\" value=\"{$item['PageText']}\" /></td>
1574
1575 <td>".makeinfocell($lang_item_edit['unk0'],$lang_item_edit['unk0_desc'])."</td>
1576 <td><input type=\"text\" name=\"unk0\" size=\"8\" maxlength=\"10\" value=\"{$item['unk0']}\" /></td>
1577 </tr>
1578 <tr>
1579
1580 <tr>
1581 <td colspan=\"2\">".makeinfocell($lang_item_edit['disenchant_id'],$lang_item_edit['disenchant_id_desc'])."</td>
1582 <td><input type=\"text\" name=\"DisenchantID\" size=\"10\" maxlength=\"10\" value=\"{$item['DisenchantID']}\" /></td>
1583
1584 <td colspan=\"2\">".makeinfocell($lang_item_edit['req_skill_disenchant'],$lang_item_edit['req_skill_disenchant_desc'])."</td>
1585 <td><input type=\"text\" name=\"RequiredDisenchantSkill\" size=\"10\" maxlength=\"10\" value=\"{$item['RequiredDisenchantSkill']}\" /></td>
1586
1587 <td>".makeinfocell($lang_item_edit['lock_id'],$lang_item_edit['lock_id_desc'])."</td>
1588 <td><input type=\"text\" name=\"lockid\" size=\"8\" maxlength=\"30\" value=\"{$item['lockid']}\" /></td>
1589 </tr>";
1590
1591
1592$LanguageID = array( 0 => "", 1 => "", 2 => "", 3 => "", 6 => "", 7 => "", 8 => "", 9 => "", 10 => "", 11 => "",
1593 12 => "", 13 => "", 14 => "", 33 => "");
1594$LanguageID[$item['LanguageID']] = " selected=\"selected\" ";
1595
1596$output .= "<tr>
1597 <td>".makeinfocell($lang_item_edit['lang_id'],$lang_item_edit['lang_id_desc'])."</td>
1598 <td colspan=\"2\"><select name=\"LanguageID\">
1599 <option value=\"0\" {$LanguageID[0]}>0 - {$lang_item_edit['other']}</option>
1600 <option value=\"1\" {$LanguageID[1]}>1 - Orcish</option>
1601 <option value=\"2\" {$LanguageID[2]}>2 - Darnassian</option>
1602 <option value=\"3\" {$LanguageID[3]}>3 - Taurahe</option>
1603 <option value=\"6\" {$LanguageID[6]}>6 - Dwarvish</option>
1604 <option value=\"7\" {$LanguageID[7]}>7 - Common</option>
1605 <option value=\"8\" {$LanguageID[8]}>8 - Demonic</option>
1606 <option value=\"9\" {$LanguageID[9]}>9 - Titan</option>
1607 <option value=\"10\" {$LanguageID[10]}>10 - Thelassian</option>
1608 <option value=\"11\" {$LanguageID[11]}>11 - Draconic</option>
1609 <option value=\"12\" {$LanguageID[12]}>12 - Kalimag</option>
1610 <option value=\"13\" {$LanguageID[13]}>13 - Gnomish</option>
1611 <option value=\"14\" {$LanguageID[14]}>14 - Troll</option>
1612 <option value=\"33\" {$LanguageID[33]}>33 - Gutterspeak</option>
1613 </select></td>";
1614 unset($LanguageID);
1615
1616$sheath = array( 0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5 => "", 7 => "");
1617$sheath[$item['sheath']] = " selected=\"selected\" ";
1618
1619$output .= "<td>".makeinfocell($lang_item_edit['sheath'],$lang_item_edit['sheath_desc'])."</td>
1620 <td colspan=\"2\"><select name=\"sheath\">
1621 <option value=\"0\" {$sheath[0]}>0 - {$lang_item_edit['other']}</option>
1622 <option value=\"1\" {$sheath[1]}>1 - {$lang_item['sword_2h']}</option>
1623 <option value=\"2\" {$sheath[2]}>2 - {$lang_item['staff']}</option>
1624 <option value=\"3\" {$sheath[3]}>3 - {$lang_item['sword_1h']}</option>
1625 <option value=\"4\" {$sheath[4]}>4 - {$lang_item['shield']}</option>
1626 <option value=\"5\" {$sheath[5]}>5 - {$lang_item['rod']}</option>
1627 <option value=\"7\" {$sheath[7]}>7 - {$lang_item['off_hand']}</option>
1628 </select></td>
1629
1630 <td>".makeinfocell($lang_item_edit['totem_category'],$lang_item_edit['totem_category_desc'])."</td>
1631 <td><input type=\"text\" name=\"TotemCategory\" size=\"8\" maxlength=\"10\" value=\"{$item['TotemCategory']}\" /></td>
1632 </tr>
1633
1634 </table><br /><br />
1635 </div>";
1636 unset($sheath);
1637
1638$output .= "<div id=\"pane3\">
1639 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1640 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['stats']}:</td></tr>
1641 <tr>
1642
1643 <td>".makeinfocell($lang_item_edit['stat_type']." 1",$lang_item_edit['stat_type_desc'])."</td>
1644 <td><select name=\"stat_type1\">";
1645 output_status_options($item['stat_type1']);
1646$output .= "</select></td>
1647
1648 <td><input type=\"text\" name=\"stat_value1\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value1']}\" /></td>
1649 <td>".makeinfocell($lang_item_edit['stat_type']." 2",$lang_item_edit['stat_type_desc'])."</td>
1650 <td><select name=\"stat_type2\">";
1651 output_status_options($item['stat_type2']);
1652$output .= "</select></td>
1653
1654 <td><input type=\"text\" name=\"stat_value2\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value2']}\" /></td>
1655 </tr>
1656 <tr>
1657 <td>".makeinfocell($lang_item_edit['stat_type']." 3",$lang_item_edit['stat_type_desc'])."</td>
1658 <td><select name=\"stat_type3\">";
1659 output_status_options($item['stat_type3']);
1660$output .= "</select></td>
1661
1662 <td><input type=\"text\" name=\"stat_value3\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value3']}\" /></td>
1663 <td>".makeinfocell($lang_item_edit['stat_type']." 4",$lang_item_edit['stat_type_desc'])."</td>
1664 <td><select name=\"stat_type4\">";
1665 output_status_options($item['stat_type4']);
1666$output .= "</select></td>
1667
1668 <td><input type=\"text\" name=\"stat_value4\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value4']}\" /></td>
1669 </tr>
1670<tr>
1671 <td>".makeinfocell($lang_item_edit['stat_type']." 5",$lang_item_edit['stat_type_desc'])."</td>
1672 <td><select name=\"stat_type5\">";
1673 output_status_options($item['stat_type5']);
1674$output .= "</select></td>
1675
1676 <td><input type=\"text\" name=\"stat_value5\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value5']}\" /></td>
1677 <td>".makeinfocell($lang_item_edit['stat_type']." 6",$lang_item_edit['stat_type_desc'])."</td>
1678 <td><select name=\"stat_type6\">";
1679 output_status_options($item['stat_type1']);
1680$output .= "</select></td>
1681
1682 <td><input type=\"text\" name=\"stat_value6\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value6']}\" /></td>
1683 </tr>
1684<tr>
1685 <td>".makeinfocell($lang_item_edit['stat_type']." 7",$lang_item_edit['stat_type_desc'])."</td>
1686 <td><select name=\"stat_type7\">";
1687 output_status_options($item['stat_type7']);
1688$output .= "</select></td>
1689 <td><input type=\"text\" name=\"stat_value7\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value7']}\" /></td>
1690 <td>".makeinfocell($lang_item_edit['stat_type']." 8",$lang_item_edit['stat_type_desc'])."</td>
1691 <td><select name=\"stat_type8\">";
1692 output_status_options($item['stat_type8']);
1693$output .= "</select></td>
1694
1695 <td><input type=\"text\" name=\"stat_value8\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value8']}\" /></td>
1696 </tr>
1697<tr>
1698 <td>".makeinfocell($lang_item_edit['stat_type']." 9",$lang_item_edit['stat_type_desc'])."</td>
1699 <td><select name=\"stat_type9\">";
1700 output_status_options($item['stat_type9']);
1701$output .= "</select></td>
1702 <td><input type=\"text\" name=\"stat_value9\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value9']}\" /></td>
1703 <td>".makeinfocell($lang_item_edit['stat_type']." 10",$lang_item_edit['stat_type_desc'])."</td>
1704 <td><select name=\"stat_type10\">";
1705 output_status_options($item['stat_type10']);
1706$output .= "</select></td>
1707
1708 <td><input type=\"text\" name=\"stat_value10\" size=\"10\" maxlength=\"6\" value=\"{$item['stat_value10']}\" /></td>
1709 </tr>
1710
1711 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['resis_armor']}:</td></tr>
1712 <tr>
1713 <td colspan=\"2\">".makeinfocell($lang_item['armor'],$lang_item_edit['armor_desc'])."</td>
1714 <td><input type=\"text\" name=\"armor\" size=\"10\" maxlength=\"30\" value=\"{$item['armor']}\" /></td>
1715
1716 <td colspan=\"2\">".makeinfocell($lang_item['block'],$lang_item_edit['block_desc'])."</td>
1717 <td><input type=\"text\" name=\"block\" size=\"10\" maxlength=\"30\" value=\"{$item['block']}\" /></td>
1718 </tr>
1719 <tr>
1720 <td colspan=\"2\">".makeinfocell($lang_item['res_holy'],$lang_item_edit['res_holy_desc'])."</td>
1721 <td><input type=\"text\" name=\"holy_res\" size=\"10\" maxlength=\"30\" value=\"{$item['holy_res']}\" /></td>
1722
1723 <td colspan=\"2\">".makeinfocell($lang_item['res_fire'],$lang_item_edit['res_fire_desc'])."</td>
1724 <td><input type=\"text\" name=\"fire_res\" size=\"10\" maxlength=\"30\" value=\"{$item['fire_res']}\" /></td>
1725 </tr>
1726 <tr>
1727 <td colspan=\"2\">".makeinfocell($lang_item['res_nature'],$lang_item_edit['res_nature_desc'])."</td>
1728 <td><input type=\"text\" name=\"nature_res\" size=\"10\" maxlength=\"30\" value=\"{$item['nature_res']}\" /></td>
1729
1730 <td colspan=\"2\">".makeinfocell($lang_item['res_frost'],$lang_item_edit['res_frost_desc'])."</td>
1731 <td><input type=\"text\" name=\"frost_res\" size=\"10\" maxlength=\"30\" value=\"{$item['frost_res']}\" /></td>
1732 </tr>
1733 <tr>
1734 <td colspan=\"2\">".makeinfocell($lang_item['res_shadow'],$lang_item_edit['res_shadow_desc'])."</td>
1735 <td><input type=\"text\" name=\"shadow_res\" size=\"10\" maxlength=\"30\" value=\"{$item['shadow_res']}\" /></td>
1736
1737 <td colspan=\"2\">".makeinfocell($lang_item['res_arcane'],$lang_item_edit['res_arcane_desc'])."</td>
1738 <td><input type=\"text\" name=\"arcane_res\" size=\"10\" maxlength=\"30\" value=\"{$item['arcane_res']}\" /></td>
1739 </tr>
1740
1741 </table><br /><br />
1742 </div>";
1743
1744$output .= "<div id=\"pane4\">
1745 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1746 <tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_properties']}:</td></tr>
1747<tr>
1748 <td>".makeinfocell($lang_item_edit['delay'],$lang_item_edit['delay_desc'])."</td>
1749 <td colspan=\"2\"><input type=\"text\" name=\"delay\" size=\"10\" maxlength=\"11\" value=\"{$item['delay']}\" /></td>
1750
1751 <td>".makeinfocell($lang_item_edit['ranged_mod'],$lang_item_edit['ranged_mod_desc'])."</td>
1752 <td colspan=\"2\"><input type=\"text\" name=\"RangedModRange\" size=\"10\" maxlength=\"40\" value=\"{$item['RangedModRange']}\" /></td>
1753</tr>
1754<tr>
1755 <td>".makeinfocell($lang_item_edit['armor_dmg_mod'],$lang_item_edit['armor_dmg_mod_desc'])."</td>
1756 <td colspan=\"2\"><input type=\"text\" name=\"ArmorDamageModifier\" size=\"10\" maxlength=\"40\" value=\"{$item['ArmorDamageModifier']}\" /></td>";
1757
1758$ammo_type = array( 0 => "", 2 => "", 3 => "" );
1759$ammo_type [$item['ammo_type']] = " selected=\"selected\" ";
1760
1761$output .= "<td>".makeinfocell($lang_item_edit['ammo_type'],$lang_item_edit['ammo_type_desc'])."</td>
1762 <td colspan=\"2\"><select name=\"ammo_type\">
1763 <option value=\"0\" {$ammo_type[0]}>0 - {$lang_item['none']}</option>
1764 <option value=\"2\" {$ammo_type[2]}>2 - {$lang_item['arrows']}</option>
1765 <option value=\"3\" {$ammo_type[3]}>3 - {$lang_item['bullets']}</option>
1766 </select></td>
1767</tr>
1768<tr class=\"large_bold\"><td colspan=\"8\" class=\"hidden\" align=\"left\">{$lang_item_edit['weapon_damage']}:</td></tr>
1769<tr>";
1770 unset($ammo_type);
1771
1772$output .= "<td>".makeinfocell($lang_item_edit['damage_type']." 1",$lang_item_edit['damage_type_desc'])."</td>
1773 <td colspan=\"2\"><select name=\"dmg_type1\">";
1774 output_dmgtype_options($item['dmg_type1']);
1775$output .= "</select></td>
1776
1777 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
1778 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min1']}\" /> - <input type=\"text\" name=\"dmg_max1\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max1']}\" /></td>
1779
1780</tr>
1781<tr>
1782 <td>".makeinfocell($lang_item_edit['damage_type']." 2",$lang_item_edit['damage_type_desc'])."</td>
1783 <td colspan=\"2\"><select name=\"dmg_type2\">";
1784 output_dmgtype_options($item['dmg_type2']);
1785$output .= "</select></td>
1786
1787 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
1788 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min2']}\" /> - <input type=\"text\" name=\"dmg_max2\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max2']}\" /></td>
1789
1790</tr>
1791<tr>
1792 <td>".makeinfocell($lang_item_edit['damage_type']." 3",$lang_item_edit['damage_type_desc'])."</td>
1793 <td colspan=\"2\"><select name=\"dmg_type3\">";
1794 output_dmgtype_options($item['dmg_type3']);
1795$output .= "</select></td>
1796
1797 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
1798 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min3\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min3']}\" /> - <input type=\"text\" name=\"dmg_max3\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max3']}\" /></td>
1799</tr>
1800<tr>
1801 <td>".makeinfocell($lang_item_edit['damage_type']." 4",$lang_item_edit['damage_type_desc'])."</td>
1802 <td colspan=\"2\"><select name=\"dmg_type4\">";
1803 output_dmgtype_options($item['dmg_type4']);
1804$output .= "</select></td>
1805
1806 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
1807 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min4\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min4']}\" /> - <input type=\"text\" name=\"dmg_max4\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max4']}\" /></td>
1808
1809</tr>
1810<tr>
1811 <td>".makeinfocell($lang_item_edit['damage_type']." 5",$lang_item_edit['damage_type_desc'])."</td>
1812 <td colspan=\"2\"><select name=\"dmg_type5\">";
1813 output_dmgtype_options($item['dmg_type5']);
1814$output .= "</select></td>
1815
1816 <td>".makeinfocell($lang_item_edit['dmg_min_max'],$lang_item_edit['dmg_min_max_desc'])."</td>
1817 <td colspan=\"4\"><input type=\"text\" name=\"dmg_min5\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_min5']}\" /> - <input type=\"text\" name=\"dmg_max5\" size=\"8\" maxlength=\"45\" value=\"{$item['dmg_max5']}\" /></td>
1818</tr>
1819
1820</table><br /><br />
1821 </div>";
1822
1823$output .= "<div id=\"pane5\">
1824 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1825<tr>
1826 <td colspan=\"2\">{$lang_item_edit['item_spell']} 1</td>
1827 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
1828 <td><input type=\"text\" name=\"spellid_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_1']}\" /></td>";
1829
1830$spelltrigger_1 = array( 0 => "", 1 => "", 2 => "", 4 => "");
1831$spelltrigger_1 [$item['spelltrigger_1']] = " selected=\"selected\" ";
1832
1833$output .= "<td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
1834 <td><select name=\"spelltrigger_1\">
1835 <option value=\"0\" {$spelltrigger_1[0]}>0: {$lang_item['spell_use']}</option>
1836 <option value=\"1\" {$spelltrigger_1[1]}>1: {$lang_item['spell_equip']}</option>
1837 <option value=\"2\" {$spelltrigger_1[2]}>2: {$lang_item['spell_coh']}</option>
1838 <option value=\"4\" {$spelltrigger_1[4]}>4: {$lang_item['soul_stone']}</option>
1839 </select></td>
1840 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
1841 <td><input type=\"text\" name=\"spellcharges_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_1']}\" /></td>
1842</tr>
1843<tr>
1844 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
1845 <td><input type=\"text\" name=\"spellcooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_1']}\" /></td>
1846
1847 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
1848 <td><input type=\"text\" name=\"spellcategory_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_1']}\" /></td>
1849
1850 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1851 <td><input type=\"text\" name=\"spellcategorycooldown_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_1']}\" /></td>
1852
1853 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1854 <td><input type=\"text\" name=\"spellppmRate_1\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_1']}\" /></td>
1855</tr>
1856<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
1857<tr>
1858 <td colspan=\"2\">{$lang_item_edit['item_spell']} 2</td>
1859 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
1860 <td><input type=\"text\" name=\"spellid_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_2']}\" /></td>";
1861 unset($spelltrigger_1);
1862
1863$spelltrigger_2 = array( 0 => "", 1 => "", 2 => "", 4 => "");
1864$spelltrigger_2 [$item['spelltrigger_2']] = " selected=\"selected\" ";
1865
1866$output .= "<td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
1867 <td><select name=\"spelltrigger_2\">
1868 <option value=\"0\" {$spelltrigger_2[0]}>0: {$lang_item['spell_use']}</option>
1869 <option value=\"1\" {$spelltrigger_2[1]}>1: {$lang_item['spell_equip']}</option>
1870 <option value=\"2\" {$spelltrigger_2[2]}>2: {$lang_item['spell_coh']}</option>
1871 <option value=\"4\" {$spelltrigger_2[4]}>4: {$lang_item['soul_stone']}</option>
1872 </select></td>
1873 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
1874 <td><input type=\"text\" name=\"spellcharges_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_2']}\" /></td>
1875</tr>
1876<tr>
1877 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
1878 <td><input type=\"text\" name=\"spellcooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_2']}\" /></td>
1879
1880 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
1881 <td><input type=\"text\" name=\"spellcategory_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_2']}\" /></td>
1882
1883 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1884 <td><input type=\"text\" name=\"spellcategorycooldown_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_2']}\" /></td>
1885
1886 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1887 <td><input type=\"text\" name=\"spellppmRate_2\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_2']}\" /></td>
1888</tr>
1889<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
1890<tr>
1891 <td colspan=\"2\">{$lang_item_edit['item_spell']} 3</td>
1892 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
1893 <td><input type=\"text\" name=\"spellid_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_3']}\" /></td>";
1894 unset($spelltrigger_2);
1895
1896$spelltrigger_3 = array( 0 => "", 1 => "", 2 => "", 4 => "");
1897$spelltrigger_3 [$item['spelltrigger_3']] = " selected=\"selected\" ";
1898
1899$output .= "<td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
1900 <td><select name=\"spelltrigger_3\">
1901 <option value=\"0\" {$spelltrigger_3[0]}>0: {$lang_item['spell_use']}</option>
1902 <option value=\"1\" {$spelltrigger_3[1]}>1: {$lang_item['spell_equip']}</option>
1903 <option value=\"2\" {$spelltrigger_3[2]}>2: {$lang_item['spell_coh']}</option>
1904 <option value=\"4\" {$spelltrigger_3[4]}>4: {$lang_item['soul_stone']}</option>
1905 </select></td>
1906 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
1907 <td><input type=\"text\" name=\"spellcharges_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_3']}\" /></td>
1908</tr>
1909<tr>
1910 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
1911 <td><input type=\"text\" name=\"spellcooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_3']}\" /></td>
1912
1913 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
1914 <td><input type=\"text\" name=\"spellcategory_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_3']}\" /></td>
1915
1916 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1917 <td><input type=\"text\" name=\"spellcategorycooldown_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_3']}\" /></td>
1918
1919 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1920 <td><input type=\"text\" name=\"spellppmRate_3\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_3']}\" /></td>
1921</tr>
1922<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
1923<tr>
1924 <td colspan=\"2\">{$lang_item_edit['item_spell']} 4</td>
1925 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
1926 <td><input type=\"text\" name=\"spellid_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_4']}\" /></td>";
1927 unset($spelltrigger_3);
1928
1929$spelltrigger_4 = array( 0 => "", 1 => "", 2 => "", 4 => "");
1930$spelltrigger_4 [$item['spelltrigger_4']] = " selected=\"selected\" ";
1931
1932$output .= "<td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
1933 <td><select name=\"spelltrigger_4\">
1934 <option value=\"0\" {$spelltrigger_4[0]}>0: {$lang_item['spell_use']}</option>
1935 <option value=\"1\" {$spelltrigger_4[1]}>1: {$lang_item['spell_equip']}</option>
1936 <option value=\"2\" {$spelltrigger_4[2]}>2: {$lang_item['spell_coh']}</option>
1937 <option value=\"4\" {$spelltrigger_4[4]}>4: {$lang_item['soul_stone']}</option>
1938 </select></td>
1939 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
1940 <td><input type=\"text\" name=\"spellcharges_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_4']}\" /></td>
1941</tr>
1942<tr>
1943 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
1944 <td><input type=\"text\" name=\"spellcooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_4']}\" /></td>
1945
1946 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
1947 <td><input type=\"text\" name=\"spellcategory_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_4']}\" /></td>
1948
1949 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1950 <td><input type=\"text\" name=\"spellcategorycooldown_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_4']}\" /></td>
1951
1952 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1953 <td><input type=\"text\" name=\"spellppmRate_4\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_4']}\" /></td>
1954</tr>
1955<tr><td colspan=\"6\" class=\"hidden\"></td></tr>
1956<tr>
1957 <td colspan=\"2\">{$lang_item_edit['item_spell']} 5</td>
1958 <td>".makeinfocell($lang_item_edit['spell_id'],$lang_item_edit['spell_id_desc'])."</td>
1959 <td><input type=\"text\" name=\"spellid_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellid_5']}\" /></td>";
1960 unset($spelltrigger_4);
1961
1962$spelltrigger_5 = array( 0 => "", 1 => "", 2 => "", 4 => "");
1963$spelltrigger_5 [$item['spelltrigger_5']] = " selected=\"selected\" ";
1964
1965$output .= "<td>".makeinfocell($lang_item_edit['spell_trigger'],$lang_item_edit['spell_trigger_desc'])."</td>
1966 <td><select name=\"spelltrigger_5\">
1967 <option value=\"0\" {$spelltrigger_5[0]}>0: {$lang_item['spell_use']}</option>
1968 <option value=\"1\" {$spelltrigger_5[1]}>1: {$lang_item['spell_equip']}</option>
1969 <option value=\"2\" {$spelltrigger_5[2]}>2: {$lang_item['spell_coh']}</option>
1970 <option value=\"4\" {$spelltrigger_5[4]}>4: {$lang_item['soul_stone']}</option>
1971 </select></td>
1972 <td>".makeinfocell($lang_item_edit['spell_charges'],$lang_item_edit['spell_charges_desc'])."</td>
1973 <td><input type=\"text\" name=\"spellcharges_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcharges_5']}\" /></td>
1974</tr>
1975<tr>
1976 <td>".makeinfocell($lang_item_edit['spell_cooldown'],$lang_item_edit['spell_cooldown_desc'])."</td>
1977 <td><input type=\"text\" name=\"spellcooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcooldown_5']}\" /></td>
1978
1979 <td>".makeinfocell($lang_item_edit['spell_category'],$lang_item_edit['spell_category_desc'])."</td>
1980 <td><input type=\"text\" name=\"spellcategory_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategory_5']}\" /></td>
1981
1982 <td>".makeinfocell($lang_item_edit['spell_category_cooldown'],$lang_item_edit['spell_category_cooldown_desc'])."</td>
1983 <td><input type=\"text\" name=\"spellcategorycooldown_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellcategorycooldown_5']}\" /></td>
1984
1985 <td>".makeinfocell($lang_item_edit['ppm_rate'],$lang_item_edit['ppm_rate_desc'])."</td>
1986 <td><input type=\"text\" name=\"spellppmRate_5\" size=\"6\" maxlength=\"30\" value=\"{$item['spellppmRate_5']}\" /></td>
1987</tr>
1988
1989</table>
1990 </div>";
1991 unset($spelltrigger_5);
1992
1993$output .= "<div id=\"pane6\">
1994 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
1995 <tr>";
1996
1997$AllowableClass = array( -1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "",
1998 256 => "", 512 => "", 1024 => "");
1999
2000if($item['AllowableClass'] == -1) $AllowableClass[-1] = " selected=\"selected\" ";
2001else {
2002 if ($item['AllowableClass'] & 1) $AllowableClass[1] = " selected=\"selected\" ";
2003 if ($item['AllowableClass'] & 2) $AllowableClass[2] = " selected=\"selected\" ";
2004 if ($item['AllowableClass'] & 4) $AllowableClass[4] = " selected=\"selected\" ";
2005 if ($item['AllowableClass'] & 8) $AllowableClass[8] = " selected=\"selected\" ";
2006 if ($item['AllowableClass'] & 16) $AllowableClass[16] = " selected=\"selected\" ";
2007 if ($item['AllowableClass'] & 32) $AllowableClass[32] = " selected=\"selected\" ";
2008 if ($item['AllowableClass'] & 64) $AllowableClass[64] = " selected=\"selected\" ";
2009 if ($item['AllowableClass'] & 128) $AllowableClass[128] = " selected=\"selected\" ";
2010 if ($item['AllowableClass'] & 256) $AllowableClass[256] = " selected=\"selected\" ";
2011 if ($item['AllowableClass'] & 512) $AllowableClass[512] = " selected=\"selected\" ";
2012 if ($item['AllowableClass'] & 1024) $AllowableClass[1024] = " selected=\"selected\" ";
2013 }
2014$output .= "<td>".makeinfocell($lang_item_edit['allow_class'],$lang_item_edit['allow_class_desc'])."</td>
2015 <td><select multiple=\"multiple\" name=\"AllowableClass[]\" size=\"5\">
2016 <option value=\"-1\" {$AllowableClass[-1]}>-1 - {$lang_item_edit['all']}</option>
2017 <option value=\"1\" {$AllowableClass[1]}>1 - {$lang_id_tab['warrior']}</option>
2018 <option value=\"2\" {$AllowableClass[2]}>2 - {$lang_id_tab['paladin']}</option>
2019 <option value=\"4\" {$AllowableClass[4]}>4 - {$lang_id_tab['hunter']}</option>
2020 <option value=\"8\" {$AllowableClass[8]}>8 - {$lang_id_tab['rogue']}</option>
2021 <option value=\"16\" {$AllowableClass[16]}>16 - {$lang_id_tab['priest']}</option>
2022 <option value=\"32\" {$AllowableClass[32]}>32 - FUTURE_1</option>
2023 <option value=\"64\" {$AllowableClass[64]}>64 - {$lang_id_tab['shaman']}</option>
2024 <option value=\"128\" {$AllowableClass[128]}>128 - {$lang_id_tab['mage']}</option>
2025 <option value=\"256\" {$AllowableClass[256]}>256 - {$lang_id_tab['warlock']}</option>
2026 <option value=\"512\" {$AllowableClass[512]}>512 - FUTURE_2</option>
2027 <option value=\"1024\" {$AllowableClass[1024]}>1024 - {$lang_id_tab['druid']}</option>
2028 </select></td>";
2029 unset($AllowableClass);
2030
2031$AllowableRace = array( -1 => "", 1 => "", 2 => "", 4 => "", 8 => "", 16 => "", 32 => "", 64 => "", 128 => "",
2032 256 => "", 512 => "");
2033
2034if($item['AllowableRace'] == -1) $AllowableRace[-1] = " selected=\"selected\" ";
2035else {
2036 if ($item['AllowableRace'] & 1) $AllowableRace[1] = " selected=\"selected\" ";
2037 if ($item['AllowableRace'] & 2) $AllowableRace[2] = " selected=\"selected\" ";
2038 if ($item['AllowableRace'] & 4) $AllowableRace[4] = " selected=\"selected\" ";
2039 if ($item['AllowableRace'] & 8) $AllowableRace[8] = " selected=\"selected\" ";
2040 if ($item['AllowableRace'] & 16) $AllowableRace[16] = " selected=\"selected\" ";
2041 if ($item['AllowableRace'] & 32) $AllowableRace[32] = " selected=\"selected\" ";
2042 if ($item['AllowableRace'] & 64) $AllowableRace[64] = " selected=\"selected\" ";
2043 if ($item['AllowableRace'] & 128) $AllowableRace[128] = " selected=\"selected\" ";
2044 if ($item['AllowableRace'] & 256) $AllowableRace[256] = " selected=\"selected\" ";
2045 if ($item['AllowableRace'] & 512) $AllowableRace[512] = " selected=\"selected\" ";
2046 }
2047
2048$output .= "<td>".makeinfocell($lang_item_edit['allow_race'],$lang_item_edit['allow_race_desc'])."</td>
2049 <td><select multiple=\"multiple\" name=\"AllowableRace[]\" size=\"5\">
2050 <option value=\"-1\" {$AllowableRace[-1]}>-1 - {$lang_item_edit['all']}</option>
2051 <option value=\"1\" {$AllowableRace[1]}>1 - {$lang_id_tab['human']}</option>
2052 <option value=\"2\" {$AllowableRace[2]}>2 - {$lang_id_tab['orc']}</option>
2053 <option value=\"4\" {$AllowableRace[4]}>4 - {$lang_id_tab['dwarf']}</option>
2054 <option value=\"8\" {$AllowableRace[8]}>8 - {$lang_id_tab['nightelf']}</option>
2055 <option value=\"16\" {$AllowableRace[16]}>16 - {$lang_id_tab['undead']}</option>
2056 <option value=\"32\" {$AllowableRace[32]}>32 - {$lang_id_tab['tauren']}</option>
2057 <option value=\"64\" {$AllowableRace[64]}>64 - {$lang_id_tab['gnome']}</option>
2058 <option value=\"128\" {$AllowableRace[128]}>128 - {$lang_id_tab['troll']}</option>
2059 <option value=\"256\" {$AllowableRace[256]}>256 - {$lang_id_tab['draenei']}</option>
2060 <option value=\"512\" {$AllowableRace[512]}>512 - {$lang_id_tab['bloodelf']}</option>
2061 </select></td>
2062</tr>
2063<tr>
2064 <td>".makeinfocell($lang_item_edit['req_skill'],$lang_item_edit['req_skill_desc'])."</td>
2065 <td><input type=\"text\" name=\"RequiredSkill\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkill']}\" /></td>
2066
2067 <td>".makeinfocell($lang_item_edit['req_skill_rank'],$lang_item_edit['req_skill_rank_desc'])."</td>
2068 <td><input type=\"text\" name=\"RequiredSkillRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredSkillRank']}\" /></td>
2069</tr>
2070<tr>
2071 <td>".makeinfocell($lang_item_edit['req_spell'],$lang_item_edit['req_spell_desc'])."</td>
2072 <td><input type=\"text\" name=\"requiredspell\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredspell']}\" /></td>
2073
2074 <td>".makeinfocell($lang_item_edit['req_honor_rank'],$lang_item_edit['req_honor_rank_desc'])."</td>
2075 <td><input type=\"text\" name=\"requiredhonorrank\" size=\"15\" maxlength=\"30\" value=\"{$item['requiredhonorrank']}\" /></td>
2076</tr>
2077<tr>
2078 <td>".makeinfocell($lang_item_edit['req_rep_faction'],$lang_item_edit['req_rep_faction_desc'])."</td>
2079 <td><input type=\"text\" name=\"RequiredReputationFaction\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredReputationFaction']}\" /></td>";
2080 unset($AllowableRace);
2081
2082$RequiredReputationRank = array(0 => "", 1 => "", 2 => "", 3 => "", 4 => "", 5=> "", 6 => "", 7 => "");
2083$RequiredReputationRank [$item['RequiredReputationRank']] = " selected=\"selected\" ";
2084
2085$output .= "<td>".makeinfocell($lang_item_edit['req_rep_rank'],$lang_item_edit['req_rep_rank_desc'])."</td>
2086 <td><select name=\"RequiredReputationRank\">
2087 <option value=\"0\" {$RequiredReputationRank[0]}>0 - {$lang_item_edit['hated']}</option>
2088 <option value=\"1\" {$RequiredReputationRank[1]}>1 - {$lang_item_edit['hostile']}</option>
2089 <option value=\"2\" {$RequiredReputationRank[2]}>2 - {$lang_item_edit['unfriendly']}</option>
2090 <option value=\"3\" {$RequiredReputationRank[3]}>3 - {$lang_item_edit['neutral']}</option>
2091 <option value=\"4\" {$RequiredReputationRank[4]}>4 - {$lang_item_edit['friendly']}</option>
2092 <option value=\"5\" {$RequiredReputationRank[5]}>5 - {$lang_item_edit['honored']}</option>
2093 <option value=\"6\" {$RequiredReputationRank[6]}>6 - {$lang_item_edit['reverted']}</option>
2094 <option value=\"7\" {$RequiredReputationRank[7]}>7 - {$lang_item_edit['exalted']}</option>
2095 </select></td>
2096</tr>
2097<tr>
2098 <td colspan=\"2\">".makeinfocell($lang_item_edit['req_city_rank'],$lang_item_edit['req_city_rank_desc'])."</td>
2099 <td colspan=\"2\"><input type=\"text\" name=\"RequiredCityRank\" size=\"15\" maxlength=\"30\" value=\"{$item['RequiredCityRank']}\" /></td>
2100</tr>
2101
2102 </table><br /><br />
2103 </div>";
2104 unset($RequiredReputationRank);
2105
2106$output .= "<div id=\"pane7\">
2107 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
2108<tr>";
2109
2110$socketColor_1 = array(0 => "", 1 => "", 2 => "", 4 => "", 8=> "");
2111$socketColor_1 [$item['socketColor_1']] = " selected=\"selected\" ";
2112
2113$output .= "<td>".makeinfocell($lang_item_edit['socket_color']." 1",$lang_item_edit['socket_color_desc'])."</td>
2114 <td><select name=\"socketColor_1\">
2115 <option value=\"0\" {$socketColor_1[0]}>0: {$lang_item['none']}</option>
2116 <option value=\"1\" {$socketColor_1[1]}>1: {$lang_item['socket_meta']}</option>
2117 <option value=\"2\" {$socketColor_1[2]}>2: {$lang_item['socket_red']}</option>
2118 <option value=\"4\" {$socketColor_1[4]}>4: {$lang_item['socket_yellow']}</option>
2119 <option value=\"8\" {$socketColor_1[8]}>8: {$lang_item['socket_blue']}</option>
2120 </select></td>
2121 <td>".makeinfocell($lang_item_edit['socket_content']." 1",$lang_item_edit['socket_content_desc'])."</td>
2122 <td><input type=\"text\" name=\"socketContent_1\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_1']}\" /></td>
2123</tr>
2124<tr>";
2125 unset($socketColor_1);
2126
2127$socketColor_2 = array(0 => "", 1 => "", 2 => "", 4 => "", 8=> "");
2128$socketColor_2 [$item['socketColor_2']] = " selected=\"selected\" ";
2129
2130$output .= "<td>".makeinfocell($lang_item_edit['socket_color']." 2",$lang_item_edit['socket_color_desc'])."</td>
2131 <td><select name=\"socketColor_2\">
2132 <option value=\"0\" {$socketColor_2[0]}>0: {$lang_item['none']}</option>
2133 <option value=\"1\" {$socketColor_2[1]}>1: {$lang_item['socket_meta']}</option>
2134 <option value=\"2\" {$socketColor_2[2]}>2: {$lang_item['socket_red']}</option>
2135 <option value=\"4\" {$socketColor_2[4]}>4: {$lang_item['socket_yellow']}</option>
2136 <option value=\"8\" {$socketColor_2[8]}>8: {$lang_item['socket_blue']}</option>
2137 </select></td>
2138
2139 <td>".makeinfocell($lang_item_edit['socket_content']." 2",$lang_item_edit['socket_content_desc'])."</td>
2140 <td><input type=\"text\" name=\"socketContent_2\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_2']}\" /></td>
2141</tr>
2142<tr>";
2143 unset($socketColor_2);
2144
2145$socketColor_3 = array(0 => "", 1 => "", 2 => "", 4 => "", 8=> "");
2146$socketColor_3 [$item['socketColor_3']] = " selected=\"selected\" ";
2147
2148$output .= "<td>".makeinfocell($lang_item_edit['socket_color']." 3",$lang_item_edit['socket_color_desc'])."</td>
2149 <td><select name=\"socketColor_3\">
2150 <option value=\"0\" {$socketColor_3[0]}>0: {$lang_item['none']}</option>
2151 <option value=\"1\" {$socketColor_3[1]}>1: {$lang_item['socket_meta']}</option>
2152 <option value=\"2\" {$socketColor_3[2]}>2: {$lang_item['socket_red']}</option>
2153 <option value=\"4\" {$socketColor_3[4]}>4: {$lang_item['socket_yellow']}</option>
2154 <option value=\"8\" {$socketColor_3[8]}>8: {$lang_item['socket_blue']}</option>
2155 </select></td>
2156
2157 <td>".makeinfocell($lang_item_edit['socket_content']." 3",$lang_item_edit['socket_content_desc'])."</td>
2158 <td><input type=\"text\" name=\"socketContent_3\" size=\"15\" maxlength=\"10\" value=\"{$item['socketContent_3']}\" /></td>
2159</tr>
2160
2161<tr>
2162 <td>".makeinfocell($lang_item_edit['socket_bonus'],$lang_item_edit['socket_bonus_desc'])."</td>
2163 <td><input type=\"text\" name=\"socketBonus\" size=\"15\" maxlength=\"10\" value=\"{$item['socketBonus']}\" /></td>
2164
2165 <td>".makeinfocell($lang_item_edit['gem_properties'],$lang_item_edit['gem_properties_desc'])."</td>
2166 <td><input type=\"text\" name=\"GemProperties\" size=\"15\" maxlength=\"10\" value=\"{$item['GemProperties']}\" /></td>
2167</tr>
2168
2169 </table><br /><br />
2170 </div>";
2171
2172$output .= "<div id=\"pane8\">
2173 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
2174 <tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['dropped_by']}: {$lang_item_edit['top_x']}</td></tr>
2175 <tr>
2176 <th width=\"35%\">{$lang_item_edit['mob_name']}</th>
2177 <th width=\"15%\">{$lang_item_edit['mob_level']}</th>
2178 <th width=\"25%\">{$lang_item_edit['mob_drop_chance']}</th>
2179 <th width=\"25%\">{$lang_item_edit['mob_quest_drop_chance']}</th>
2180 </tr>";
2181 $result2 = $sql->query("SELECT entry,ChanceOrQuestChance,`groupid` FROM creature_loot_template WHERE item = {$item['entry']} ORDER BY `groupid`,ChanceOrQuestChance DESC LIMIT 5");
2182 while ($info = $sql->fetch_row($result2)){
2183 $result3 = $sql->query("SELECT creature_template.entry,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,maxlevel FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE lootid = {$info[0]} LIMIT 1");
2184 while ($mob = $sql->fetch_row($result3)){
2185 $output .= "<tr><td><a class=\"tooltip\" href=\"creature.php?action=edit&amp;entry=$mob[0]&amp;error=4\" target=\"_blank\">$mob[1]</a></td>
2186 <td>$mob[2]</td>
2187 <td>$info[1]%</td>
2188 <td>$info[2]%</td></tr>";
2189 }
2190 }
2191
2192$result2 = $sql->query("SELECT creature_template.entry,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,maxlevel FROM creature_template LEFT JOIN locales_creature ON creature_template.entry = locales_creature.entry WHERE creature_template.entry IN (SELECT entry FROM npc_vendor WHERE item = {$item['entry']}) ORDER BY maxlevel DESC LIMIT 5");
2193 if ($sql->num_rows($result2)){
2194 $output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['soled_by']}: {$lang_item_edit['limit_x']}</td></tr>";
2195 while ($mob = $sql->fetch_row($result2)){
2196 $output .= "<tr><td width=\"20%\">$mob[2]</td>
2197 <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"creature.php?action=edit&amp;entry=$mob[0]&amp;error=4\" target=\"_blank\">$mob[1]</a></td></tr>";
2198 }
2199}
2200
2201 $result2 = $sql->query("SELECT quest_template.entry,IFNULL(".($deplang<>0?"title_loc$deplang":"NULL").",`title`) as title,QuestLevel FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE ( SrcItemId = {$item['entry']} OR ReqItemId1 = {$item['entry']} OR
2202 ReqItemId2 = {$item['entry']} OR ReqItemId3 = {$item['entry']} OR ReqItemId4 = {$item['entry']} OR RewItemId1 = {$item['entry']} OR
2203 RewItemId2 = {$item['entry']} OR RewItemId3 = {$item['entry']} OR RewItemId4 = {$item['entry']} ) ORDER BY QuestLevel DESC");
2204 if ($sql->num_rows($result2)){
2205 $output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['involved_in_quests']}:</td></tr>";
2206 while ($quest = $sql->fetch_row($result2)){
2207 $output .= "<tr><td width=\"20%\">id: $quest[0]</td>
2208 <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"$quest_datasite$quest[0]\" target=\"_blank\">($quest[2]) $quest[1]</a></td></tr>";
2209 }
2210
2211 }
2212
2213$result2 = $sql->query("SELECT quest_template.entry,IFNULL(".($deplang<>0?"title_loc$deplang":"NULL").",`title`) as title,QuestLevel FROM quest_template LEFT JOIN locales_quest ON quest_template.entry = locales_quest.entry WHERE ( RewChoiceItemId1 = {$item['entry']} OR RewChoiceItemId2 = {$item['entry']} OR
2214 RewChoiceItemId3 = {$item['entry']} OR RewChoiceItemId4 = {$item['entry']} OR RewChoiceItemId5 = {$item['entry']} OR RewChoiceItemId6 = {$item['entry']} )
2215 ORDER BY QuestLevel DESC");
2216 if ($sql->num_rows($result2)){
2217 $output .= "<tr class=\"large_bold\"><td colspan=\"4\" class=\"hidden\" align=\"left\">{$lang_item_edit['reward_from_quest']}:</td></tr>";
2218 while ($quest = $sql->fetch_row($result2)){
2219 $output .= "<tr><td width=\"20%\">id: $quest[0]</td>
2220 <td width=\"80%\" colspan=\"3\" align=\"left\"><a class=\"tooltip\" href=\"$quest_datasite$quest[0]\" target=\"_blank\">($quest[2]) $quest[1]</a></td></tr>";
2221 }
2222 }
2223$output .= "</tr></table><br /><br />
2224 </div>";
2225
2226 if ($item['DisenchantID']){
2227 $output .= "<div id=\"pane9\">
2228 <br /><br /><table class=\"lined\" style=\"width: 720px;\">
2229 <tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_item_edit['disenchant_templ']}: {$item['DisenchantID']}</td></tr>
2230 <tr><td colspan=\"6\">";
2231
2232 $cel_counter = 0;
2233 $row_flag = 0;
2234 $output .= "<table class=\"hidden\" align=\"center\"><tr>";
2235 $result1 = $sql->query("SELECT item,ChanceOrQuestChance,`groupid`,mincountOrRef,maxcount,lootcondition,condition_value1, condition_value2 FROM disenchant_loot_template WHERE entry = {$item['DisenchantID']} ORDER BY ChanceOrQuestChance DESC");
2236 while ($item = $sql->fetch_row($result1)){
2237 $cel_counter++;
2238 $tooltip = get_item_name($item[0])." ($item[0])<br />{$lang_item_edit['drop_chance']}: $item[1]%<br />{$lang_item_edit['quest_drop_chance']}: $item[2]%<br />{$lang_item_edit['drop_chance']}: $item[3]-$item[4]<br />{$lang_item_edit['lootcondition']}: $item[5]<br />{$lang_item_edit['condition_value1']}: $item[6]<br />{$lang_item_edit['condition_value2']}: $item[7]";
2239 $output .= "<td>";
2240 $output .= maketooltip("<img src=\"".get_icon($item[0])."\" class=\"icon_border\" alt=\"\" />", "$item_datasite$item[0]", $tooltip, "item_tooltip");
2241 $output .= "<br /><input type=\"checkbox\" name=\"del_de_items[]\" value=\"$item[0]\" /></td>";
2242
2243 if ($cel_counter >= 16) {
2244 $cel_counter = 0;
2245 $output .= "</tr><tr>";
2246 $row_flag++;
2247 }
2248 };
2249 if ($row_flag) $output .= "<td colspan=\"".(16 - $cel_counter)."\"></td>";
2250 $output .= "</td></tr></table>
2251 </td>
2252</tr>
2253<tr class=\"large_bold\"><td colspan=\"6\" class=\"hidden\" align=\"left\">{$lang_item_edit['add_items_to_templ']}:</td></tr>
2254<tr>
2255<td>".makeinfocell($lang_item_edit['loot_item_id'],$lang_item_edit['loot_item_id_desc'])."</td>
2256 <td><input type=\"text\" name=\"de_item\" size=\"8\" maxlength=\"10\" value=\"\" /></td>
2257<td>".makeinfocell($lang_item_edit['loot_drop_chance'],$lang_item_edit['loot_drop_chance_desc'])."</td>
2258 <td><input type=\"text\" name=\"de_ChanceOrQuestChance\" size=\"8\" maxlength=\"11\" value=\"0\" /></td>
2259<td>".makeinfocell($lang_item_edit['loot_quest_drop_chance'],$lang_item_edit['loot_quest_drop_chance_desc'])."</td>
2260 <td><input type=\"text\" name=\"de_groupid\" size=\"8\" maxlength=\"10\" value=\"0\" /></td>
2261</tr>
2262<tr>
2263<td>".makeinfocell($lang_item_edit['min_count'],$lang_item_edit['min_count_desc'])."</td>
2264 <td><input type=\"text\" name=\"de_mincountOrRef\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
2265<td>".makeinfocell($lang_item_edit['max_count'],$lang_item_edit['max_count_desc'])."</td>
2266 <td><input type=\"text\" name=\"de_maxcount\" size=\"8\" maxlength=\"3\" value=\"1\" /></td>
2267</tr>
2268<tr>
2269<td>".makeinfocell($lang_item_edit['lootcondition'],$lang_item_edit['lootcondition_desc'])."</td>
2270 <td><input type=\"text\" name=\"de_lootcondition\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
2271<td>".makeinfocell($lang_item_edit['condition_value1'],$lang_item_edit['condition_value1_desc'])."</td>
2272 <td><input type=\"text\" name=\"de_condition_value1\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
2273<td>".makeinfocell($lang_item_edit['condition_value2'],$lang_item_edit['condition_value2_desc'])."</td>
2274 <td><input type=\"text\" name=\"de_condition_value2\" size=\"8\" maxlength=\"3\" value=\"0\" /></td>
2275</tr>
2276</table>
2277</div>";
2278}
2279
2280$output .= "</div>
2281</div>
2282<br />
2283</form>
2284
2285<script type=\"text/javascript\">setupPanes(\"container\", \"tab1\")</script>";
2286 unset($socketColor_3);
2287
2288 $output .= "<table class=\"hidden\">
2289 <tr><td>";
2290 makebutton($lang_item_edit['update'], "javascript:do_submit('form1',0)",180);
2291 makebutton($lang_item_edit['del_item'], "item.php?action=delete&amp;entry=$entry",180);
2292 makebutton($lang_item_edit['export_sql'], "javascript:do_submit('form1',1)",180);
2293 makebutton($lang_item_edit['search_items'], "item.php",180);
2294 $output .= "</td></tr>
2295 </table></center>";
2296
2297
2298 $sql->close();
2299 } else {
2300 $sql->close();
2301 error($lang_item_edit['item_not_found']);
2302 exit();
2303 }
2304}
2305
2306
2307//########################################################################################################################
2308//DO UPDATE ITEM
2309//########################################################################################################################
2310function do_update() {
2311 global $world_db, $realm_id;
2312
2313 if (!isset($_POST['type']) || $_POST['type'] === '') redirect("item.php?error=1");
2314 if (!isset($_POST['entry']) || $_POST['entry'] === '') redirect("item.php?error=1");
2315
2316 $sql = new SQL;
2317 $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
2318
2319 $entry = $sql->quote_smart($_POST['entry']);
2320 if (isset($_POST['class']) && $_POST['class'] != '') $class = $sql->quote_smart($_POST['class']);
2321 else $class = 0;
2322 if (isset($_POST['subclass']) && $_POST['subclass'] != '') $subclass = $sql->quote_smart($_POST['subclass']);
2323 else $subclass = 0;
2324 if (isset($_POST['name']) && $_POST['name'] != '') $name = $sql->quote_smart($_POST['name']);
2325 else $name = 0;
2326 if (isset($_POST['displayid']) && $_POST['displayid'] != '') $displayid = $sql->quote_smart($_POST['displayid']);
2327 else $displayid = 0;
2328 if (isset($_POST['Quality']) && $_POST['Quality'] != '') $Quality = $sql->quote_smart($_POST['Quality']);
2329 else $Quality = 0;
2330 if (isset($_POST['Flags']) && $_POST['Flags'] != '') $Flags = $sql->quote_smart($_POST['Flags']);
2331 else $Flags = 0;
2332 if (isset($_POST['BuyCount']) && $_POST['BuyCount'] != '') $BuyCount = $sql->quote_smart($_POST['BuyCount']);
2333 else $BuyCount = 0;
2334 if (isset($_POST['BuyPrice']) && $_POST['BuyPrice'] != '') $BuyPrice = $sql->quote_smart($_POST['BuyPrice']);
2335 else $BuyPrice = 0;
2336 if (isset($_POST['SellPrice']) && $_POST['SellPrice'] != '') $SellPrice = $sql->quote_smart($_POST['SellPrice']);
2337 else $SellPrice = 0;
2338 if (isset($_POST['InventoryType']) && $_POST['InventoryType'] != '') $InventoryType = $sql->quote_smart($_POST['InventoryType']);
2339 else $AllowableClass = 0;
2340 if (isset($_POST['AllowableClass'])) $AllowableClass = $sql->quote_smart($_POST['AllowableClass']);
2341 else $AllowableClass = -1;
2342 if (isset($_POST['AllowableRace'])) $AllowableRace = $sql->quote_smart($_POST['AllowableRace']);
2343 else $AllowableRace = -1;
2344 if (isset($_POST['ItemLevel']) && $_POST['ItemLevel'] != '') $ItemLevel = $sql->quote_smart($_POST['ItemLevel']);
2345 else $ItemLevel = 1;
2346 if (isset($_POST['RequiredLevel']) && $_POST['RequiredLevel'] != '') $RequiredLevel = $sql->quote_smart($_POST['RequiredLevel']);
2347 else $RequiredLevel = 0;
2348 if (isset($_POST['RequiredSkill']) && $_POST['RequiredSkill'] != '') $RequiredSkill = $sql->quote_smart($_POST['RequiredSkill']);
2349 else $RequiredSkill = 0;
2350 if (isset($_POST['RequiredSkillRank']) && $_POST['RequiredSkillRank'] != '') $RequiredSkillRank = $sql->quote_smart($_POST['RequiredSkillRank']);
2351 else $RequiredSkillRank = 0;
2352 if (isset($_POST['requiredspell']) && $_POST['requiredspell'] != '') $requiredspell = $sql->quote_smart($_POST['requiredspell']);
2353 else $requiredspell = 0;
2354 if (isset($_POST['requiredhonorrank']) && $_POST['requiredhonorrank'] != '') $requiredhonorrank = $sql->quote_smart($_POST['requiredhonorrank']);
2355 else $requiredhonorrank = 0;
2356 if (isset($_POST['RequiredCityRank']) && $_POST['RequiredCityRank'] != '') $RequiredCityRank = $sql->quote_smart($_POST['RequiredCityRank']);
2357 else $RequiredCityRank = 0;
2358 if (isset($_POST['RequiredReputationFaction']) && $_POST['RequiredReputationFaction'] != '') $RequiredReputationFaction = $sql->quote_smart($_POST['RequiredReputationFaction']);
2359 else $RequiredReputationFaction = 0;
2360 if (isset($_POST['RequiredReputationRank']) && $_POST['RequiredReputationRank'] != '') $RequiredReputationRank = $sql->quote_smart($_POST['RequiredReputationRank']);
2361 else $RequiredReputationRank = 0;
2362 if (isset($_POST['maxcount']) && $_POST['maxcount'] != '') $maxcount = $sql->quote_smart($_POST['maxcount']);
2363 else $maxcount = 0;
2364 if (isset($_POST['stackable']) && $_POST['stackable'] != '') $stackable = $sql->quote_smart($_POST['stackable']);
2365 else $description = 0;
2366 if (isset($_POST['ContainerSlots']) && $_POST['ContainerSlots'] != '') $ContainerSlots = $sql->quote_smart($_POST['ContainerSlots']);
2367 else $ContainerSlots = 0;
2368 if (isset($_POST['stat_type1']) && $_POST['stat_type1'] != '') $stat_type1 = $sql->quote_smart($_POST['stat_type1']);
2369 else $stat_type1 = 0;
2370 if (isset($_POST['stat_value1']) && $_POST['stat_value1'] != '') $stat_value1 = $sql->quote_smart($_POST['stat_value1']);
2371 else $stat_value1 = 0;
2372 if (isset($_POST['stat_type2']) && $_POST['stat_type2'] != '') $stat_type2 = $sql->quote_smart($_POST['stat_type2']);
2373 else $stat_type2 = 0;
2374 if (isset($_POST['stat_value2']) && $_POST['stat_value2'] != '') $stat_value2 = $sql->quote_smart($_POST['stat_value2']);
2375 else $stat_value2 = 0;
2376 if (isset($_POST['stat_type3']) && $_POST['stat_type3'] != '') $stat_type3 = $sql->quote_smart($_POST['stat_type3']);
2377 else $stat_type3 = 0;
2378 if (isset($_POST['stat_value3']) && $_POST['stat_value3'] != '') $stat_value3 = $sql->quote_smart($_POST['stat_value3']);
2379 else $stat_value3 = 0;
2380 if (isset($_POST['stat_type4']) && $_POST['stat_type4'] != '') $stat_type4 = $sql->quote_smart($_POST['stat_type4']);
2381 else $stat_type4 = 0;
2382 if (isset($_POST['stat_value4']) && $_POST['stat_value4'] != '') $stat_value4 = $sql->quote_smart($_POST['stat_value4']);
2383 else $stat_value4 = 0;
2384 if (isset($_POST['stat_type5']) && $_POST['stat_type5'] != '') $stat_type5 = $sql->quote_smart($_POST['stat_type5']);
2385 else $stat_type5 = 0;
2386 if (isset($_POST['stat_value5']) && $_POST['stat_value5'] != '') $stat_value5 = $sql->quote_smart($_POST['stat_value5']);
2387 else $stat_value5 = 0;
2388 if (isset($_POST['stat_type6']) && $_POST['stat_type6'] != '') $stat_type6 = $sql->quote_smart($_POST['stat_type6']);
2389 else $stat_type6 = 0;
2390 if (isset($_POST['stat_value6']) && $_POST['stat_value6'] != '') $stat_value6 = $sql->quote_smart($_POST['stat_value6']);
2391 else $stat_value6 = 0;
2392 if (isset($_POST['stat_type7']) && $_POST['stat_type7'] != '') $stat_type7 = $sql->quote_smart($_POST['stat_type7']);
2393 else $stat_type7 = 0;
2394 if (isset($_POST['stat_value7']) && $_POST['stat_value7'] != '') $stat_value7 = $sql->quote_smart($_POST['stat_value7']);
2395 else $stat_value7 = 0;
2396 if (isset($_POST['stat_type8']) && $_POST['stat_type8'] != '') $stat_type8 = $sql->quote_smart($_POST['stat_type8']);
2397 else $stat_type8 = 0;
2398 if (isset($_POST['stat_value8']) && $_POST['stat_value8'] != '') $stat_value8 = $sql->quote_smart($_POST['stat_value8']);
2399 else $stat_value8 = 0;
2400 if (isset($_POST['stat_type9']) && $_POST['stat_type9'] != '') $stat_type9 = $sql->quote_smart($_POST['stat_type9']);
2401 else $stat_type9 = 0;
2402 if (isset($_POST['stat_value9']) && $_POST['stat_value9'] != '') $stat_value9 = $sql->quote_smart($_POST['stat_value9']);
2403 else $stat_value9 = 0;
2404 if (isset($_POST['stat_type10']) && $_POST['stat_type10'] != '') $stat_type10 = $sql->quote_smart($_POST['stat_type10']);
2405 else $stat_type10 = 0;
2406 if (isset($_POST['stat_value10']) && $_POST['stat_value10'] != '') $stat_value10 = $sql->quote_smart($_POST['stat_value10']);
2407 else $stat_value10 = 0;
2408 if (isset($_POST['dmg_min1']) && $_POST['dmg_min1'] != '') $dmg_min1 = $sql->quote_smart($_POST['dmg_min1']);
2409 else $dmg_min1 = 0;
2410 if (isset($_POST['dmg_max1']) && $_POST['dmg_max1'] != '') $dmg_max1 = $sql->quote_smart($_POST['dmg_max1']);
2411 else $dmg_max1 = 0;
2412 if (isset($_POST['dmg_type1']) && $_POST['dmg_type1'] != '') $dmg_type1 = $sql->quote_smart($_POST['dmg_type1']);
2413 else $dmg_type1 = 0;
2414 if (isset($_POST['dmg_min2']) && $_POST['dmg_min2'] != '') $dmg_min2 = $sql->quote_smart($_POST['dmg_min2']);
2415 else $dmg_min2 = 0;
2416 if (isset($_POST['dmg_max2']) && $_POST['dmg_max2'] != '') $dmg_max2 = $sql->quote_smart($_POST['dmg_max2']);
2417 else $dmg_max2 = 0;
2418 if (isset($_POST['dmg_type2']) && $_POST['dmg_type2'] != '') $dmg_type2 = $sql->quote_smart($_POST['dmg_type2']);
2419 else $dmg_type2 = 0;
2420 if (isset($_POST['dmg_min3']) && $_POST['dmg_min3'] != '') $dmg_min3 = $sql->quote_smart($_POST['dmg_min3']);
2421 else $dmg_min3 = 0;
2422 if (isset($_POST['dmg_max3']) && $_POST['dmg_max3'] != '') $dmg_max3 = $sql->quote_smart($_POST['dmg_max3']);
2423 else $dmg_max3 = 0;
2424 if (isset($_POST['dmg_type3']) && $_POST['dmg_type3'] != '') $dmg_type3 = $sql->quote_smart($_POST['dmg_type3']);
2425 else $dmg_type3 = 0;
2426 if (isset($_POST['dmg_min4']) && $_POST['dmg_min4'] != '') $dmg_min4 = $sql->quote_smart($_POST['dmg_min4']);
2427 else $dmg_min4 = 0;
2428 if (isset($_POST['dmg_max4']) && $_POST['dmg_max4'] != '') $dmg_max4 = $sql->quote_smart($_POST['dmg_max4']);
2429 else $dmg_max4 = 0;
2430 if (isset($_POST['dmg_type4']) && $_POST['dmg_type4'] != '') $dmg_type4 = $sql->quote_smart($_POST['dmg_type4']);
2431 else $dmg_type4 = 0;
2432 if (isset($_POST['dmg_min5']) && $_POST['dmg_min5'] != '') $dmg_min5 = $sql->quote_smart($_POST['dmg_min5']);
2433 else $dmg_min5 = 0;
2434 if (isset($_POST['dmg_max5']) && $_POST['dmg_max5'] != '') $dmg_max5 = $sql->quote_smart($_POST['dmg_max5']);
2435 else $dmg_max5 = 0;
2436 if (isset($_POST['dmg_type5']) && $_POST['dmg_type5'] != '') $dmg_type5 = $sql->quote_smart($_POST['dmg_type5']);
2437 else $dmg_type5 = 0;
2438 if (isset($_POST['armor']) && $_POST['armor'] != '') $armor = $sql->quote_smart($_POST['armor']);
2439 else $armor = 0;
2440 if (isset($_POST['holy_res']) && $_POST['holy_res'] != '') $holy_res = $sql->quote_smart($_POST['holy_res']);
2441 else $holy_res = 0;
2442 if (isset($_POST['fire_res']) && $_POST['fire_res'] != '') $fire_res = $sql->quote_smart($_POST['fire_res']);
2443 else $fire_res = 0;
2444 if (isset($_POST['nature_res']) && $_POST['nature_res'] != '') $nature_res = $sql->quote_smart($_POST['nature_res']);
2445 else $nature_res = 0;
2446 if (isset($_POST['frost_res']) && $_POST['frost_res'] != '') $frost_res = $sql->quote_smart($_POST['frost_res']);
2447 else $frost_res = 0;
2448 if (isset($_POST['shadow_res']) && $_POST['shadow_res'] != '') $shadow_res = $sql->quote_smart($_POST['shadow_res']);
2449 else $shadow_res = 0;
2450 if (isset($_POST['arcane_res']) && $_POST['arcane_res'] != '') $arcane_res = $sql->quote_smart($_POST['arcane_res']);
2451 else $arcane_res = 0;
2452 if (isset($_POST['delay']) && $_POST['delay'] != '') $delay = $sql->quote_smart($_POST['delay']);
2453 else $delay = 0;
2454 if (isset($_POST['ammo_type']) && $_POST['ammo_type'] != '') $ammo_type = $sql->quote_smart($_POST['ammo_type']);
2455 else $ammo_type = 0;
2456 if (isset($_POST['RangedModRange']) && $_POST['RangedModRange'] != '') $RangedModRange = $sql->quote_smart($_POST['RangedModRange']);
2457 else $RangedModRange = 0;
2458 if (isset($_POST['spellid_1']) && $_POST['spellid_1'] != '') $spellid_1 = $sql->quote_smart($_POST['spellid_1']);
2459 else $spellid_1 = 0;
2460 if (isset($_POST['spelltrigger_1']) && $_POST['spelltrigger_1'] != '') $spelltrigger_1 = $sql->quote_smart($_POST['spelltrigger_1']);
2461 else $spelltrigger_1 = 0;
2462 if (isset($_POST['spellcharges_1']) && $_POST['spellcharges_1'] != '') $spellcharges_1 = $sql->quote_smart($_POST['spellcharges_1']);
2463 else $spellcharges_1 = 0;
2464 if (isset($_POST['spellcooldown_1']) && $_POST['spellcooldown_1'] != '') $spellcooldown_1 = $sql->quote_smart($_POST['spellcooldown_1']);
2465 else $spellcooldown_1 = -1;
2466 if (isset($_POST['spellcategory_1']) && $_POST['spellcategory_1'] != '') $spellcategory_1 = $sql->quote_smart($_POST['spellcategory_1']);
2467 else $spellcategory_1 = 0;
2468 if (isset($_POST['spellcategorycooldown_1']) && $_POST['spellcategorycooldown_1'] != '') $spellcategorycooldown_1 = $sql->quote_smart($_POST['spellcategorycooldown_1']);
2469 else $spellcategorycooldown_1 = -1;
2470 if (isset($_POST['spellppmRate_1']) && $_POST['spellppmRate_1'] != '') $spellppmRate_1 = $sql->quote_smart($_POST['spellppmRate_1']);
2471 else $spellppmRate_1 = 0;
2472 if (isset($_POST['spellid_2']) && $_POST['spellid_2'] != '') $spellid_2 = $sql->quote_smart($_POST['spellid_2']);
2473 else $spellid_2 = 0;
2474 if (isset($_POST['spelltrigger_2']) && $_POST['spelltrigger_2'] != '') $spelltrigger_2 = $sql->quote_smart($_POST['spelltrigger_2']);
2475 else $spelltrigger_2 = 0;
2476 if (isset($_POST['spellcharges_2']) && $_POST['spellcharges_2'] != '') $spellcharges_2 = $sql->quote_smart($_POST['spellcharges_2']);
2477 else $spellcharges_2 = 0;
2478 if (isset($_POST['spellcooldown_2']) && $_POST['spellcooldown_2'] != '') $spellcooldown_2 = $sql->quote_smart($_POST['spellcooldown_2']);
2479 else $spellcooldown_2 = -1;
2480 if (isset($_POST['spellcategory_2']) && $_POST['spellcategory_2'] != '') $spellcategory_2 = $sql->quote_smart($_POST['spellcategory_2']);
2481 else $spellcategory_2 = 0;
2482 if (isset($_POST['spellcategorycooldown_2']) && $_POST['spellcategorycooldown_2'] != '') $spellcategorycooldown_2 = $sql->quote_smart($_POST['spellcategorycooldown_2']);
2483 else $spellcategorycooldown_2 = -1;
2484 if (isset($_POST['spellppmRate_2']) && $_POST['spellppmRate_2'] != '') $spellppmRate_2 = $sql->quote_smart($_POST['spellppmRate_2']);
2485 else $spellppmRate_2 = 0;
2486 if (isset($_POST['spellid_3']) && $_POST['spellid_3'] != '') $spellid_3 = $sql->quote_smart($_POST['spellid_3']);
2487 else $spellid_3 = 0;
2488 if (isset($_POST['spelltrigger_3']) && $_POST['spelltrigger_3'] != '') $spelltrigger_3 = $sql->quote_smart($_POST['spelltrigger_3']);
2489 else $spelltrigger_3 = 0;
2490 if (isset($_POST['spellcharges_3']) && $_POST['spellcharges_3'] != '') $spellcharges_3 = $sql->quote_smart($_POST['spellcharges_3']);
2491 else $spellcharges_3 = 0;
2492 if (isset($_POST['spellcooldown_3']) && $_POST['spellcooldown_3'] != '') $spellcooldown_3 = $sql->quote_smart($_POST['spellcooldown_3']);
2493 else $spellcooldown_3 = -1;
2494 if (isset($_POST['spellcategory_3']) && $_POST['spellcategory_3'] != '') $spellcategory_3 = $sql->quote_smart($_POST['spellcategory_3']);
2495 else $description = 0;
2496 if (isset($_POST['spellcategorycooldown_3']) && $_POST['spellcategorycooldown_3'] != '') $spellcategorycooldown_3 = $sql->quote_smart($_POST['spellcategorycooldown_3']);
2497 else $spellcategorycooldown_3 = -1;
2498 if (isset($_POST['spellppmRate_3']) && $_POST['spellppmRate_3'] != '') $spellppmRate_3 = $sql->quote_smart($_POST['spellppmRate_3']);
2499 else $spellppmRate_3 = 0;
2500 if (isset($_POST['spellid_4']) && $_POST['spellid_4'] != '') $spellid_4 = $sql->quote_smart($_POST['spellid_4']);
2501 else $spellid_4 = 0;
2502 if (isset($_POST['spelltrigger_4']) && $_POST['spelltrigger_4'] != '') $spelltrigger_4 = $sql->quote_smart($_POST['spelltrigger_4']);
2503 else $spelltrigger_4 = 0;
2504 if (isset($_POST['spellcharges_4']) && $_POST['spellcharges_4'] != '') $spellcharges_4 = $sql->quote_smart($_POST['spellcharges_4']);
2505 else $spellcharges_4 = 0;
2506 if (isset($_POST['spellcooldown_4']) && $_POST['spellcooldown_4'] != '') $spellcooldown_4 = $sql->quote_smart($_POST['spellcooldown_4']);
2507 else $spellcooldown_4 = -1;
2508 if (isset($_POST['spellcategory_4']) && $_POST['spellcategory_4'] != '') $spellcategory_4 = $sql->quote_smart($_POST['spellcategory_4']);
2509 else $spellcategory_4 = 0;
2510 if (isset($_POST['spellcategorycooldown_4']) && $_POST['spellcategorycooldown_4'] != '') $spellcategorycooldown_4 = $sql->quote_smart($_POST['spellcategorycooldown_4']);
2511 else $spellcategorycooldown_4 = -1;
2512 if (isset($_POST['spellppmRate_4']) && $_POST['spellppmRate_4'] != '') $spellppmRate_4 = $sql->quote_smart($_POST['spellppmRate_4']);
2513 else $spellppmRate_4 = 0;
2514 if (isset($_POST['spellid_5']) && $_POST['spellid_5'] != '') $spellid_5 = $sql->quote_smart($_POST['spellid_5']);
2515 else $spellid_5 = 0;
2516 if (isset($_POST['spelltrigger_5']) && $_POST['spelltrigger_5'] != '') $spelltrigger_5 = $sql->quote_smart($_POST['spelltrigger_5']);
2517 else $spelltrigger_5 = 0;
2518 if (isset($_POST['spellcharges_5']) && $_POST['spellcharges_5'] != '') $spellcharges_5 = $sql->quote_smart($_POST['spellcharges_5']);
2519 else $spellcharges_5 = 0;
2520 if (isset($_POST['spellcooldown_5']) && $_POST['spellcooldown_5'] != '') $spellcooldown_5 = $sql->quote_smart($_POST['spellcooldown_5']);
2521 else $spellcooldown_5 = -1;
2522 if (isset($_POST['spellcategory_5']) && $_POST['spellcategory_5'] != '') $spellcategory_5 = $sql->quote_smart($_POST['spellcategory_5']);
2523 else $spellcategory_5 = 0;
2524 if (isset($_POST['spellcategorycooldown_5']) && $_POST['spellcategorycooldown_5'] != '') $spellcategorycooldown_5 = $sql->quote_smart($_POST['spellcategorycooldown_5']);
2525 else $spellcategorycooldown_5 = -1;
2526 if (isset($_POST['spellppmRate_5']) && $_POST['spellppmRate_5'] != '') $spellppmRate_5 = $sql->quote_smart($_POST['spellppmRate_5']);
2527 else $spellppmRate_5 = 0;
2528 if (isset($_POST['bonding']) && $_POST['bonding'] != '') $bonding = $sql->quote_smart($_POST['bonding']);
2529 else $bonding = 0;
2530 if (isset($_POST['description']) && $_POST['description'] != '') $description = $sql->quote_smart($_POST['description']);
2531 else $description = "";
2532 if (isset($_POST['PageText']) && $_POST['PageText'] != '') $PageText = $sql->quote_smart($_POST['PageText']);
2533 else $PageText = 0;
2534 if (isset($_POST['LanguageID']) && $_POST['LanguageID'] != '') $LanguageID = $sql->quote_smart($_POST['LanguageID']);
2535 else $LanguageID = 0;
2536 if (isset($_POST['PageMaterial']) && $_POST['PageMaterial'] != '') $PageMaterial = $sql->quote_smart($_POST['PageMaterial']);
2537 else $PageMaterial = 0;
2538 if (isset($_POST['startquest']) && $_POST['startquest'] != '') $startquest = $sql->quote_smart($_POST['startquest']);
2539 else $startquest = 0;
2540 if (isset($_POST['lockid']) && $_POST['lockid'] != '') $lockid = $sql->quote_smart($_POST['lockid']);
2541 else $lockid = 0;
2542 if (isset($_POST['Material']) && $_POST['Material'] != '') $Material = $sql->quote_smart($_POST['Material']);
2543 else $Material = 0;
2544 if (isset($_POST['sheath']) && $_POST['sheath'] != '') $sheath = $sql->quote_smart($_POST['sheath']);
2545 else $sheath = 0;
2546 if (isset($_POST['RandomProperty']) && $_POST['RandomProperty'] != '') $RandomProperty = $sql->quote_smart($_POST['RandomProperty']);
2547 else $RandomProperty = 0;
2548 if (isset($_POST['block ']) && $_POST['block '] != '') $block = $sql->quote_smart($_POST['block']);
2549 else $block = 0;
2550 if (isset($_POST['itemset']) && $_POST['itemset'] != '') $itemset = $sql->quote_smart($_POST['itemset']);
2551 else $itemset = 0;
2552 if (isset($_POST['MaxDurability']) && $_POST['MaxDurability'] != '') $MaxDurability = $sql->quote_smart($_POST['MaxDurability']);
2553 else $MaxDurability = 0;
2554 if (isset($_POST['area']) && $_POST['area'] != '') $area = $sql->quote_smart($_POST['area']);
2555 else $area = 0;
2556 if (isset($_POST['BagFamily']) && $_POST['BagFamily'] != '') $BagFamily = $sql->quote_smart($_POST['BagFamily']);
2557 else $BagFamily = 0;
2558 if (isset($_POST['Map']) && $_POST['Map'] != '') $Map = $sql->quote_smart($_POST['Map']);
2559 else $Map = 0;
2560 if (isset($_POST['ScriptName']) && $_POST['ScriptName'] != '') $ScriptName = $sql->quote_smart($_POST['ScriptName']);
2561 else $ScriptName = 0;
2562 if (isset($_POST['DisenchantID']) && $_POST['DisenchantID'] != '') $DisenchantID = $sql->quote_smart($_POST['DisenchantID']);
2563 else $DisenchantID = 0;
2564 if (isset($_POST['RequiredDisenchantSkill']) && $_POST['RequiredDisenchantSkill'] != '') $RequiredDisenchantSkill = $sql->quote_smart($_POST['RequiredDisenchantSkill']);
2565 else $RequiredDisenchantSkill = -1;
2566 if (isset($_POST['unk0']) && $_POST['unk0'] != '') $unk0 = $sql->quote_smart($_POST['unk0']);
2567 else $unk0 = -1;
2568 if (isset($_POST['RandomSuffix']) && $_POST['RandomSuffix'] != '') $RandomSuffix = $sql->quote_smart($_POST['RandomSuffix']);
2569 else $RandomSuffix = 0;
2570 if (isset($_POST['TotemCategory']) && $_POST['TotemCategory'] != '') $TotemCategory = $sql->quote_smart($_POST['TotemCategory']);
2571 else $TotemCategory = 0;
2572 if (isset($_POST['socketColor_1']) && $_POST['socketColor_1'] != '') $socketColor_1 = $sql->quote_smart($_POST['socketColor_1']);
2573 else $socketColor_1 = 0;
2574 if (isset($_POST['socketContent_1']) && $_POST['socketContent_1'] != '') $socketContent_1 = $sql->quote_smart($_POST['socketContent_1']);
2575 else $socketContent_1 = 0;
2576 if (isset($_POST['socketColor_2']) && $_POST['socketColor_2'] != '') $socketColor_2 = $sql->quote_smart($_POST['socketColor_2']);
2577 else $socketColor_2 = 0;
2578 if (isset($_POST['socketContent_2']) && $_POST['socketContent_2'] != '') $socketContent_2 = $sql->quote_smart($_POST['socketContent_2']);
2579 else $socketContent_2 = 0;
2580 if (isset($_POST['socketColor_3']) && $_POST['socketColor_3'] != '') $socketColor_3 = $sql->quote_smart($_POST['socketColor_3']);
2581 else $socketColor_3 = 0;
2582 if (isset($_POST['socketContent_3']) && $_POST['socketContent_3'] != '') $socketContent_3 = $sql->quote_smart($_POST['socketContent_3']);
2583 else $socketContent_3 = 0;
2584 if (isset($_POST['socketBonus']) && $_POST['socketBonus'] != '') $socketBonus = $sql->quote_smart($_POST['socketBonus']);
2585 else $socketBonus = 0;
2586 if (isset($_POST['GemProperties']) && $_POST['GemProperties'] != '') $GemProperties = $sql->quote_smart($_POST['GemProperties']);
2587 else $GemProperties = 0;
2588 if (isset($_POST['ArmorDamageModifier']) && $_POST['ArmorDamageModifier'] != '') $ArmorDamageModifier = $sql->quote_smart($_POST['ArmorDamageModifier']);
2589 else $ArmorDamageModifier = 0;
2590
2591 if (isset($_POST['de_ChanceOrQuestChance']) && $_POST['de_ChanceOrQuestChance'] != '') $de_ChanceOrQuestChance = $sql->quote_smart($_POST['de_ChanceOrQuestChance']);
2592 else $de_ChanceOrQuestChance = 0;
2593 if (isset($_POST['de_groupid']) && $_POST['de_groupid'] != '') $de_groupid = $sql->quote_smart($_POST['de_groupid']);
2594 else $de_groupid = 0;
2595 if (isset($_POST['de_mincountOrRef']) && $_POST['de_mincountOrRef'] != '') $de_mincountOrRef = $sql->quote_smart($_POST['de_mincountOrRef']);
2596 else $de_mincountOrRef = 0;
2597 if (isset($_POST['de_maxcount']) && $_POST['de_maxcount'] != '') $de_maxcount = $sql->quote_smart($_POST['de_maxcount']);
2598 else $de_maxcount = 0;
2599 if (isset($_POST['de_lootcondition']) && $_POST['de_lootcondition'] != '') $de_lootcondition = $sql->quote_smart($_POST['de_lootcondition']);
2600 else $de_lootcondition = 0;
2601 if (isset($_POST['de_condition_value1']) && $_POST['de_condition_value1'] != '') $de_condition_value1 = $sql->quote_smart($_POST['de_condition_value1']);
2602 else $de_condition_value1 = 0;
2603 if (isset($_POST['de_condition_value2']) && $_POST['de_condition_value2'] != '') $de_condition_value2 = $sql->quote_smart($_POST['de_condition_value2']);
2604 else $de_condition_value2 = 0;
2605 if (isset($_POST['de_item']) && $_POST['de_item'] != '') $de_item = $sql->quote_smart($_POST['de_item']);
2606 else $de_item = 0;
2607 if (isset($_POST['del_de_items']) && $_POST['del_de_items'] != '') $del_de_items = $sql->quote_smart($_POST['del_de_items']);
2608 else $del_de_items = NULL;
2609
2610
2611 $tmp = 0;
2612 if ($AllowableClass[0] != -1){
2613 for ($t=0; $t<count($AllowableClass); $t++){
2614 if ($AllowableClass[$t] & 1) $tmp = $tmp +1;
2615 if ($AllowableClass[$t] & 2) $tmp = $tmp +2;
2616 if ($AllowableClass[$t] & 4) $tmp = $tmp +4;
2617 if ($AllowableClass[$t] & 8) $tmp = $tmp +8;
2618 if ($AllowableClass[$t] & 16) $tmp = $tmp +16;
2619 if ($AllowableClass[$t] & 32) $tmp = $tmp +32;
2620 if ($AllowableClass[$t] & 64) $tmp = $tmp +64;
2621 if ($AllowableClass[$t] & 128) $tmp = $tmp +128;
2622 if ($AllowableClass[$t] & 256) $tmp = $tmp +256;
2623 if ($AllowableClass[$t] & 512) $tmp = $tmp +512;
2624 if ($AllowableClass[$t] & 1024) $tmp = $tmp +1024;
2625 }
2626 }
2627 if ($tmp) $AllowableClass = $tmp;
2628 else $AllowableClass = -1;
2629
2630 $tmp = 0;
2631 if ($AllowableRace[0] != -1){
2632 for ($t=0; $t<count($AllowableRace); $t++){
2633 if ($AllowableRace[$t] & 1) $tmp = $tmp +1;
2634 if ($AllowableRace[$t] & 2) $tmp = $tmp +2;
2635 if ($AllowableRace[$t] & 4) $tmp = $tmp +4;
2636 if ($AllowableRace[$t] & 8) $tmp = $tmp +8;
2637 if ($AllowableRace[$t] & 16) $tmp = $tmp +16;
2638 if ($AllowableRace[$t] & 32) $tmp = $tmp +32;
2639 if ($AllowableRace[$t] & 64) $tmp = $tmp +64;
2640 if ($AllowableRace[$t] & 128) $tmp = $tmp +128;
2641 if ($AllowableRace[$t] & 256) $tmp = $tmp +256;
2642 if ($AllowableRace[$t] & 512) $tmp = $tmp +512;
2643 }
2644 }
2645 if ($tmp) $AllowableRace = $tmp;
2646 else $AllowableRace = -1;
2647
2648 if ($_POST['type'] == "add_new"){
2649 $sql_query = "INSERT INTO item_template (entry, class, subclass, name,displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel,
2650 RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1,
2651 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,
2652 stat_value9, stat_type10, stat_value10, 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, armor,
2653 holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellppmRate_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1,
2654 spellid_2, spelltrigger_2, spellcharges_2, spellppmRate_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellppmRate_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3,
2655 spellid_4, spelltrigger_4, spellcharges_4, spellppmRate_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellppmRate_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5,
2656 bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, block, itemset, MaxDurability, area, BagFamily, Map, ScriptName, DisenchantID,RequiredDisenchantSkill,
2657 ArmorDamageModifier,unk0,RandomSuffix,TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties)
2658 VALUES ('$entry', '$class', '$subclass', '$name','$displayid', '$Quality', '$Flags', '$BuyCount', '$BuyPrice', '$SellPrice', '$InventoryType', '$AllowableClass', '$AllowableRace', '$ItemLevel', '$RequiredLevel',
2659 '$RequiredSkill', '$RequiredSkillRank', '$requiredspell', '$requiredhonorrank', '$RequiredCityRank', '$RequiredReputationFaction', '$RequiredReputationRank', '$maxcount', '$stackable', '$ContainerSlots', '$stat_type1',
2660 '$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',
2661 '$stat_type9', '$stat_value9', '$stat_type10', '$stat_value10', '$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',
2662 '$dmg_max5', '$dmg_type5', '$armor', '$holy_res', '$fire_res', '$nature_res', '$frost_res', '$shadow_res', '$arcane_res', '$delay', '$ammo_type', '$RangedModRange', '$spellid_1', '$spelltrigger_1', '$spellcharges_1', '$spellppmRate_1', '$spellcooldown_1',
2663 '$spellcategory_1', '$spellcategorycooldown_1', '$spellid_2', '$spelltrigger_2', '$spellcharges_2', '$spellppmRate_2', '$spellcooldown_2', '$spellcategory_2', '$spellcategorycooldown_2', '$spellid_3', '$spelltrigger_3', '$spellcharges_3', '$spellppmRate_3',
2664 '$spellcooldown_3', '$spellcategory_3', '$spellcategorycooldown_3', '$spellid_4', '$spelltrigger_4', '$spellcharges_4', '$spellppmRate_4', '$spellcooldown_4', '$spellcategory_4', '$spellcategorycooldown_4', '$spellid_5', '$spelltrigger_5',
2665 '$spellcharges_5', '$spellppmRate_5', '$spellcooldown_5', '$spellcategory_5', '$spellcategorycooldown_5', '$bonding', '$description', '$PageText', '$LanguageID', '$PageMaterial', '$startquest', '$lockid', '$Material', '$sheath', '$RandomProperty', '$block',
2666 '$itemset', '$MaxDurability', '$area', '$BagFamily', '$Map', '$ScriptName', '$DisenchantID', '$RequiredDisenchantSkill','$ArmorDamageModifier','$unk0','$RandomSuffix', '$TotemCategory', '$socketColor_1', '$socketContent_1', '$socketColor_2',
2667 '$socketContent_2', '$socketColor_3', '$socketContent_3', '$socketBonus', '$GemProperties')";
2668
2669 } elseif ($_POST['type'] == "edit"){
2670
2671 $sql_query = "UPDATE item_template SET ";
2672
2673 $result = $sql->query("SELECT `item_template`.`entry`,`class`,`subclass`,`unk0`,IFNULL(".($deplang<>0?"name_loc$deplang":"NULL").",`name`) as name,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`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`,`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`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`RandomSuffix`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`TotemCategory`,`socketColor_1`,`socketContent_1`,`socketColor_2`,`socketContent_2`,`socketColor_3`,`socketContent_3`,`socketBonus`,`GemProperties`,`RequiredDisenchantSkill`,`ArmorDamageModifier`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot` FROM item_template LEFT JOIN locales_item ON item_template.entry = locales_item.entry WHERE item_template.entry = '$entry'");
2674 if ($item_templ = $sql->fetch_assoc($result)){
2675
2676 if ($item_templ['class'] != $class) $sql_query .= "class='$class',";
2677 if ($item_templ['subclass'] != $subclass) $sql_query .= "subclass='$subclass',";
2678 if ($item_templ['name'] != $name) $sql_query .= "name='$name',";
2679 if ($item_templ['displayid'] != $displayid) $sql_query .= "displayid='$displayid',";
2680 if ($item_templ['Quality'] != $Quality) $sql_query .= "Quality='$Quality',";
2681 if ($item_templ['Flags'] != $Flags) $sql_query .= "Flags='$Flags',";
2682 if ($item_templ['BuyCount'] != $BuyCount) $sql_query .= "BuyCount='$BuyCount',";
2683 if ($item_templ['BuyPrice'] != $BuyPrice) $sql_query .= "BuyPrice='$BuyPrice',";
2684 if ($item_templ['SellPrice'] != $SellPrice) $sql_query .= "SellPrice='$SellPrice',";
2685 if ($item_templ['InventoryType'] != $InventoryType) $sql_query .= "InventoryType='$InventoryType',";
2686 if ($item_templ['AllowableClass'] != $AllowableClass) $sql_query .= "AllowableClass='$AllowableClass',";
2687 if ($item_templ['AllowableRace'] != $AllowableRace) $sql_query .= "AllowableRace='$AllowableRace',";
2688 if ($item_templ['ItemLevel'] != $ItemLevel) $sql_query .= "ItemLevel='$ItemLevel',";
2689 if ($item_templ['RequiredLevel'] != $RequiredLevel) $sql_query .= "RequiredLevel='$RequiredLevel',";
2690 if ($item_templ['RequiredSkill'] != $RequiredSkill) $sql_query .= "RequiredSkill='$RequiredSkill',";
2691 if ($item_templ['RequiredSkillRank'] != $RequiredSkillRank) $sql_query .= "RequiredSkillRank='$RequiredSkillRank',";
2692 if ($item_templ['requiredspell'] != $requiredspell) $sql_query .= "requiredspell='$requiredspell',";
2693 if ($item_templ['requiredhonorrank'] != $requiredhonorrank) $sql_query .= "requiredhonorrank='$requiredhonorrank',";
2694 if ($item_templ['RequiredCityRank'] != $RequiredCityRank) $sql_query .= "RequiredCityRank='$RequiredCityRank',";
2695 if ($item_templ['RequiredReputationFaction'] != $RequiredReputationFaction) $sql_query .= "RequiredReputationFaction='$RequiredReputationFaction',";
2696 if ($item_templ['RequiredReputationRank'] != $RequiredReputationRank) $sql_query .= "RequiredReputationRank='$RequiredReputationRank',";
2697 if ($item_templ['maxcount'] != $maxcount) $sql_query .= "maxcount='$maxcount',";
2698 if ($item_templ['stackable'] != $stackable) $sql_query .= "stackable='$stackable',";
2699 if ($item_templ['ContainerSlots'] != $ContainerSlots) $sql_query .= "ContainerSlots='$ContainerSlots',";
2700 if ($item_templ['stat_type1'] != $stat_type1) $sql_query .= "stat_type1='$stat_type1',";
2701 if ($item_templ['stat_value1'] != $stat_value1) $sql_query .= "stat_value1='$stat_value1',";
2702 if ($item_templ['stat_type2'] != $stat_type2) $sql_query .= "stat_type2='$stat_type2',";
2703 if ($item_templ['stat_value2'] != $stat_value2) $sql_query .= "stat_value2='$stat_value2',";
2704 if ($item_templ['stat_type3'] != $stat_type3) $sql_query .= "stat_type3='$stat_type3',";
2705 if ($item_templ['stat_value3'] != $stat_value3) $sql_query .= "stat_value3='$stat_value3',";
2706 if ($item_templ['stat_type4'] != $stat_type4) $sql_query .= "stat_type4='$stat_type4',";
2707 if ($item_templ['stat_value4'] != $stat_value4) $sql_query .= "stat_value4='$stat_value4',";
2708 if ($item_templ['stat_type5'] != $stat_type5) $sql_query .= "stat_type5='$stat_type5',";
2709 if ($item_templ['stat_value5'] != $stat_value5) $sql_query .= "stat_value5='$stat_value5',";
2710 if ($item_templ['stat_type6'] != $stat_type6) $sql_query .= "stat_type6='$stat_type6',";
2711 if ($item_templ['stat_value6'] != $stat_value6) $sql_query .= "stat_value6='$stat_value6',";
2712 if ($item_templ['stat_type7'] != $stat_type7) $sql_query .= "stat_type7='$stat_type7',";
2713 if ($item_templ['stat_value7'] != $stat_value7) $sql_query .= "stat_value7='$stat_value7',";
2714 if ($item_templ['stat_type8'] != $stat_type8) $sql_query .= "stat_type8='$stat_type8',";
2715 if ($item_templ['stat_value8'] != $stat_value8) $sql_query .= "stat_value8='$stat_value8',";
2716 if ($item_templ['stat_type9'] != $stat_type9) $sql_query .= "stat_type9='$stat_type9',";
2717 if ($item_templ['stat_value9'] != $stat_value9) $sql_query .= "stat_value9='$stat_value9',";
2718 if ($item_templ['stat_type10'] != $stat_type10) $sql_query .= "stat_type10='$stat_type10',";
2719 if ($item_templ['stat_value10'] != $stat_value10) $sql_query .= "stat_value10='$stat_value10',";
2720 if ($item_templ['dmg_min1'] != $dmg_min1) $sql_query .= "dmg_min1='$dmg_min1',";
2721 if ($item_templ['dmg_max1'] != $dmg_max1) $sql_query .= "dmg_max1='$dmg_max1',";
2722 if ($item_templ['dmg_type1'] != $dmg_type1) $sql_query .= "dmg_type1='$dmg_type1',";
2723 if ($item_templ['dmg_min2'] != $dmg_min2) $sql_query .= "dmg_min2='$dmg_min2',";
2724 if ($item_templ['dmg_max2'] != $dmg_max2) $sql_query .= "dmg_max2='$dmg_max2',";
2725 if ($item_templ['dmg_type2'] != $dmg_type2) $sql_query .= "dmg_type2='$dmg_type2',";
2726 if ($item_templ['dmg_min3'] != $dmg_min3) $sql_query .= "dmg_min3='$dmg_min3',";
2727 if ($item_templ['dmg_max3'] != $dmg_max3) $sql_query .= "dmg_max3='$dmg_max3',";
2728 if ($item_templ['dmg_type3'] != $dmg_type3) $sql_query .= "dmg_type3='$dmg_type3',";
2729 if ($item_templ['dmg_min4'] != $dmg_min4) $sql_query .= "dmg_min4='$dmg_min4',";
2730 if ($item_templ['dmg_max4'] != $dmg_max4) $sql_query .= "dmg_max4='$dmg_max4',";
2731 if ($item_templ['dmg_type4'] != $dmg_type4) $sql_query .= "dmg_type4='$dmg_type4',";
2732 if ($item_templ['dmg_min5'] != $dmg_min5) $sql_query .= "dmg_min5='$dmg_min5',";
2733 if ($item_templ['dmg_max5'] != $dmg_max5) $sql_query .= "dmg_max5='$dmg_max5',";
2734 if ($item_templ['dmg_type5'] != $dmg_type5) $sql_query .= "dmg_type5='$dmg_type5',";
2735 if ($item_templ['armor'] != $armor) $sql_query .= "armor='$armor',";
2736 if ($item_templ['holy_res'] != $holy_res) $sql_query .= "holy_res='$holy_res',";
2737 if ($item_templ['fire_res'] != $fire_res) $sql_query .= "fire_res='$fire_res',";
2738 if ($item_templ['nature_res'] != $nature_res) $sql_query .= "nature_res='$nature_res',";
2739 if ($item_templ['frost_res'] != $frost_res) $sql_query .= "frost_res='$frost_res',";
2740 if ($item_templ['shadow_res'] != $shadow_res) $sql_query .= "shadow_res='$shadow_res',";
2741 if ($item_templ['arcane_res'] != $arcane_res) $sql_query .= "arcane_res='$arcane_res',";
2742 if ($item_templ['delay'] != $delay) $sql_query .= "delay='$delay',";
2743 if ($item_templ['ammo_type'] != $ammo_type) $sql_query .= "ammo_type='$ammo_type',";
2744 if ($item_templ['RangedModRange'] != $RangedModRange) $sql_query .= "RangedModRange='$RangedModRange',";
2745 if ($item_templ['spellid_1'] != $spellid_1) $sql_query .= "spellid_1='$spellid_1',";
2746 if ($item_templ['spelltrigger_1'] != $spelltrigger_1) $sql_query .= "spelltrigger_1='$spelltrigger_1',";
2747 if ($item_templ['spellcharges_1'] != $spellcharges_1) $sql_query .= "spellcharges_1='$spellcharges_1',";
2748 if ($item_templ['spellppmRate_1'] != $spellppmRate_1) $sql_query .= "spellppmRate_1='$spellppmRate_1',";
2749 if ($item_templ['spellcooldown_1'] != $spellcooldown_1) $sql_query .= "spellcooldown_1='$spellcooldown_1',";
2750 if ($item_templ['spellcategory_1'] != $spellcategory_1) $sql_query .= "spellcategory_1='$spellcategory_1',";
2751 if ($item_templ['spellcategorycooldown_1'] != $spellcategorycooldown_1) $sql_query .= "spellcategorycooldown_1='$spellcategorycooldown_1',";
2752 if ($item_templ['spellid_2'] != $spellid_2) $sql_query .= "spellid_2='$spellid_2',";
2753 if ($item_templ['spelltrigger_2'] != $spelltrigger_2) $sql_query .= "spelltrigger_2='$spelltrigger_2',";
2754 if ($item_templ['spellcharges_2'] != $spellcharges_2) $sql_query .= "spellcharges_2='$spellcharges_2',";
2755 if ($item_templ['spellppmRate_2'] != $spellppmRate_2) $sql_query .= "spellppmRate_2='$spellppmRate_2',";
2756 if ($item_templ['spellcooldown_2'] != $spellcooldown_2) $sql_query .= "spellcooldown_2='$spellcooldown_2',";
2757 if ($item_templ['spellcategory_2'] != $spellcategory_2) $sql_query .= "spellcategory_2='$spellcategory_2',";
2758 if ($item_templ['spellcategorycooldown_2'] != $spellcategorycooldown_2) $sql_query .= "spellcategorycooldown_2='$spellcategorycooldown_2',";
2759 if ($item_templ['spellid_3'] != $spellid_3) $sql_query .= "spellid_3='$spellid_3',";
2760 if ($item_templ['spelltrigger_3'] != $spelltrigger_3) $sql_query .= "spelltrigger_3='$spelltrigger_3',";
2761 if ($item_templ['spellcharges_3'] != $spellcharges_3) $sql_query .= "spellcharges_3='$spellcharges_3',";
2762 if ($item_templ['spellppmRate_3'] != $spellppmRate_3) $sql_query .= "spellppmRate_3='$spellppmRate_3',";
2763 if ($item_templ['spellcooldown_3'] != $spellcooldown_3) $sql_query .= "spellcooldown_3='$spellcooldown_3',";
2764 if ($item_templ['spellcategory_3'] != $spellcategory_3) $sql_query .= "spellcategory_3='$spellcategory_3',";
2765 if ($item_templ['spellcategorycooldown_3'] != $spellcategorycooldown_3) $sql_query .= "spellcategorycooldown_3='$spellcategorycooldown_3',";
2766 if ($item_templ['spellid_4'] != $spellid_4) $sql_query .= "spellid_4='$spellid_4',";
2767 if ($item_templ['spelltrigger_4'] != $spelltrigger_4) $sql_query .= "spelltrigger_4='$spelltrigger_4',";
2768 if ($item_templ['spellcharges_4'] != $spellcharges_4) $sql_query .= "spellcharges_4='$spellcharges_4',";
2769 if ($item_templ['spellppmRate_4'] != $spellppmRate_4) $sql_query .= "spellppmRate_4='$spellppmRate_4',";
2770 if ($item_templ['spellcooldown_4'] != $spellcooldown_4) $sql_query .= "spellcooldown_4='$spellcooldown_4',";
2771 if ($item_templ['spellcategory_4'] != $spellcategory_4) $sql_query .= "spellcategory_4='$spellcategory_4',";
2772 if ($item_templ['spellcategorycooldown_4'] != $spellcategorycooldown_4) $sql_query .= "spellcategorycooldown_4='$spellcategorycooldown_4', ";
2773 if ($item_templ['spellid_5'] != $spellid_5) $sql_query .= "spellid_5='$spellid_5',";
2774 if ($item_templ['spelltrigger_5'] != $spelltrigger_5) $sql_query .= "spelltrigger_5='$spelltrigger_5',";
2775 if ($item_templ['spellcharges_5'] != $spellcharges_5) $sql_query .= "spellcharges_5='$spellcharges_5',";
2776 if ($item_templ['spellppmRate_5'] != $spellppmRate_5) $sql_query .= "spellppmRate_5='$spellppmRate_5',";
2777 if ($item_templ['spellcooldown_5'] != $spellcooldown_5) $sql_query .= "spellcooldown_5='$spellcooldown_5',";
2778 if ($item_templ['spellcategory_5'] != $spellcategory_5) $sql_query .= "spellcategory_5='$spellcategory_5',";
2779 if ($item_templ['spellcategorycooldown_5'] != $spellcategorycooldown_5) $sql_query .= "spellcategorycooldown_5='$spellcategorycooldown_5',";
2780 if ($item_templ['bonding'] != $bonding) $sql_query .= "bonding='$bonding',";
2781 if ($item_templ['description'] != $description) $sql_query .= "description='$description',";
2782 if ($item_templ['PageText'] != $PageText) $sql_query .= "PageText='$PageText',";
2783 if ($item_templ['LanguageID'] != $LanguageID) $sql_query .= "LanguageID='$LanguageID',";
2784 if ($item_templ['PageMaterial'] != $PageMaterial) $sql_query .= "PageMaterial='$PageMaterial',";
2785 if ($item_templ['startquest'] != $startquest) $sql_query .= "startquest='$startquest',";
2786 if ($item_templ['lockid'] != $lockid) $sql_query .= "lockid='$lockid',";
2787 if ($item_templ['Material'] != $Material) $sql_query .= "Material='$Material',";
2788 if ($item_templ['sheath'] != $sheath) $sql_query .= "sheath='$sheath',";
2789 if ($item_templ['RandomProperty'] != $RandomProperty) $sql_query .= "RandomProperty='$RandomProperty',";
2790 if ($item_templ['block'] != $block) $sql_query .= "block='$block',";
2791 if ($item_templ['itemset'] != $itemset) $sql_query .= "itemset='$itemset',";
2792 if ($item_templ['MaxDurability'] != $MaxDurability) $sql_query .= "MaxDurability='$MaxDurability',";
2793 if ($item_templ['area'] != $area) $sql_query .= "area='$area',";
2794 if ($item_templ['BagFamily'] != $BagFamily) $sql_query .= "BagFamily='$BagFamily',";
2795 if ($item_templ['Map'] != $Map) $sql_query .= "Map='$Map',";
2796 if ($item_templ['ScriptName'] != $ScriptName) $sql_query .= "ScriptName='$ScriptName',";
2797 if ($item_templ['DisenchantID'] != $DisenchantID) $sql_query .= "DisenchantID='$DisenchantID',";
2798 if ($item_templ['RequiredDisenchantSkill'] != $RequiredDisenchantSkill) $sql_query .= "RequiredDisenchantSkill='$RequiredDisenchantSkill',";
2799 if ($item_templ['ArmorDamageModifier'] != $ArmorDamageModifier) $sql_query .= "ArmorDamageModifier='$ArmorDamageModifier',";
2800 if ($item_templ['unk0'] != $unk0) $sql_query .= "unk0='$unk0',";
2801 if ($item_templ['RandomSuffix'] != $RandomSuffix) $sql_query .= "RandomSuffix='$RandomSuffix',";
2802 if ($item_templ['TotemCategory'] != $TotemCategory) $sql_query .= "TotemCategory='$TotemCategory',";
2803 if ($item_templ['socketColor_1'] != $socketColor_1) $sql_query .= "socketColor_1='$socketColor_1',";
2804 if ($item_templ['socketContent_1'] != $socketContent_1) $sql_query .= "socketContent_1='$socketContent_1',";
2805 if ($item_templ['socketColor_2'] != $socketColor_2) $sql_query .= "socketColor_2='$socketColor_2',";
2806 if ($item_templ['socketContent_2'] != $socketContent_2) $sql_query .= "socketContent_2='$socketContent_2',";
2807 if ($item_templ['socketColor_3'] != $socketColor_3) $sql_query .= "socketColor_3='$socketColor_3',";
2808 if ($item_templ['socketContent_3'] != $socketContent_3) $sql_query .= "socketContent_3='$socketContent_3',";
2809 if ($item_templ['socketBonus'] != $socketBonus) $sql_query .= "socketBonus='$socketBonus',";
2810 if ($item_templ['GemProperties'] != $GemProperties) $sql_query .= "GemProperties='$GemProperties',";
2811
2812 $sql->free_result($result);
2813 unset($item_templ);
2814
2815 if (($sql_query == "UPDATE item_template SET ")&&(!$de_item)&&(!$del_de_items)){
2816 $sql->close();
2817 redirect("item.php?action=edit&entry=$entry&error=6");
2818 } else {
2819 if ($sql_query != "UPDATE item_template SET "){
2820 $sql_query[strlen($sql_query)-1] = " ";
2821 $sql_query .= " WHERE entry = '$entry';\n";
2822 } else $sql_query = "";
2823 }
2824
2825 if ($de_item){
2826 $sql_query .= "INSERT INTO disenchant_loot_template (entry, item, ChanceOrQuestChance, `groupid`, mincountOrRef, maxcount, lootcondition, condition_value1, condition_value2)
2827 VALUES ($DisenchantID,$de_item,'$de_ChanceOrQuestChance', '$de_groupid' ,$de_mincountOrRef ,$de_maxcount ,$de_lootcondition ,$de_condition_value1 ,$de_condition_value2);\n";
2828 }
2829
2830 if ($del_de_items){
2831 foreach($del_de_items as $item_id)
2832 $sql_query .= "DELETE FROM disenchant_loot_template WHERE entry = $DisenchantID AND item = $item_id;\n";
2833 }
2834
2835 } else {
2836 $sql->close();
2837 redirect("item.php?error=5");
2838 }
2839 } else {
2840 $sql->close();
2841 redirect("item.php?error=5");
2842 }
2843
2844 if ( isset($_POST['backup_op']) && ($_POST['backup_op'] == 1) ){
2845 $sql->close();
2846 Header("Content-type: application/octet-stream");
2847 Header("Content-Disposition: attachment; filename=itemid_$entry.sql");
2848 echo $sql_query;
2849 exit();
2850 } else {
2851 $sql_query = explode(';',$sql_query);
2852 foreach($sql_query as $tmp_query) if(($tmp_query)&&($tmp_query != "\n")) $result = $sql->query($tmp_query);
2853 $sql->close();
2854 }
2855
2856 if ($result) redirect("item.php?action=edit&entry=$entry&error=4");
2857 else redirect("item.php");
2858
2859}
2860
2861
2862//#######################################################################################################
2863// DELETE ITEM
2864//#######################################################################################################
2865function delete() {
2866global $lang_global, $lang_item_edit, $output;
2867 if(isset($_GET['entry'])) $entry = $_GET['entry'];
2868 else redirect("item.php?error=1");
2869
2870 $output .= "<center><h1><font class=\"error\">{$lang_global['are_you_sure']}</font></h1><br />
2871 <font class=\"bold\">{$lang_item_edit['item_id']}: <a href=\"item.php?action=edit&amp;entry=$entry\" target=\"_blank\">$entry</a>
2872 {$lang_global['will_be_erased']}</font><br /><br />
2873 <table class=\"hidden\">
2874 <tr>
2875 <td>";
2876 makebutton($lang_global['yes'], "item.php?action=do_delete&amp;entry=$entry",120);
2877 makebutton($lang_global['no'], "item.php",120);
2878 $output .= "</td>
2879 </tr>
2880 </table></center><br />";
2881}
2882
2883
2884//########################################################################################################################
2885// DO DELETE ITEM
2886//########################################################################################################################
2887function do_delete() {
2888 global $world_db, $realm_id;
2889
2890 if(isset($_GET['entry'])) $entry = $_GET['entry'];
2891 else redirect("item.php?error=1");
2892
2893 $sql = new SQL;
2894 $sql->connect($world_db[$realm_id]['addr'], $world_db[$realm_id]['user'], $world_db[$realm_id]['pass'], $world_db[$realm_id]['name']);
2895
2896 $result = $sql->query("DELETE FROM item_template WHERE entry = '$entry'");
2897
2898 $sql->close();
2899 redirect("item.php");
2900 }
2901
2902
2903//########################################################################################################################
2904// MAIN
2905//########################################################################################################################
2906$err = (isset($_GET['error'])) ? $_GET['error'] : NULL;
2907
2908$output .= "<div class=\"top\">";
2909switch ($err) {
2910case 1:
2911 $output .= "<h1><font class=\"error\">{$lang_global['empty_fields']}</font></h1>";
2912 break;
2913case 2:
2914 $output .= "<h1><font class=\"error\">{$lang_item_edit['search_results']}</font></h1>";
2915 break;
2916case 3:
2917 $output .= "<h1><font class=\"error\">{$lang_item_edit['add_new_item']}</font></h1>";
2918 break;
2919case 4:
2920 $output .= "<h1><font class=\"error\">{$lang_item_edit['edit_item']}</font></h1>";
2921 break;
2922case 5:
2923 $output .= "<h1><font class=\"error\">{$lang_item_edit['err_adding_item']}</font></h1>";
2924 break;
2925case 6:
2926 $output .= "<h1><font class=\"error\">{$lang_item_edit['err_no_field_updated']}</font></h1>";
2927 break;
2928default: //no error
2929 $output .= "<h1>{$lang_item_edit['search_items']}</h1>";
2930}
2931$output .= "</div>";
2932
2933$action = (isset($_GET['action'])) ? $_GET['action'] : NULL;
2934
2935switch ($action) {
2936case "search":
2937 search();
2938 break;
2939case "do_search":
2940 do_search();
2941 break;
2942case "add_new":
2943 add_new();
2944 break;
2945case "do_update":
2946 do_update();
2947 break;
2948case "edit":
2949 edit();
2950 break;
2951case "delete":
2952 delete();
2953 break;
2954case "do_delete":
2955 do_delete();
2956 break;
2957default:
2958 search();
2959}
2960
2961require_once("footer.php");
2962?>
Note: See TracBrowser for help on using the repository browser.