header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}&npcid={$npcid}"); exit; case 21: // Delete faction hit check_authorization(); delete_factionhit(); header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}&npcid={$npcid}"); exit; case 22: // Edit merchant id check_authorization(); $body = new Template("templates/npc/merchantid.edit.tmpl.php"); $body->set('currzone', $z); $body->set('currzoneid', $zoneid); $body->set('npcid', $npcid); $body->set('merchant_id', get_merchant_id()); $body->set('suggested_id', suggest_merchant_id()); break; case 23: // Update merchant id check_authorization(); update_merchant_id(); header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}&npcid={$npcid}"); exit; case 24: // Delete npc check_authorization(); delete_npc(); header("Location: index.php?editor=npc&z={$z}&zoneid={$zoneid}"); exit; case 25:
function sort_merchantlist() { check_authorization(); global $mysql; $merchantid = get_merchant_id(); $item_id = array(); $query = "SELECT COUNT(slot) AS item_count FROM merchantlist WHERE merchantid={$merchantid}"; $result = $mysql->query_assoc($query); $item_count = $result['item_count']; $query = "SELECT MAX(slot) AS max_slot FROM merchantlist WHERE merchantid={$merchantid}"; $result = $mysql->query_assoc($query); $max_slot = $result['max_slot']; $query = "SELECT item FROM merchantlist WHERE merchantid={$merchantid}"; $results = $mysql->query_mult_assoc($query); foreach ($results as $result) { $item_id[] = $result['item']; } for ($i = 0; $i < $item_count; $i++) { $query = "UPDATE merchantlist SET slot={$max_slot}+{$i}+1 WHERE merchantid={$merchantid} AND item={$item_id[$i]}"; $mysql->query_no_result($query); } for ($i = 0; $i < $item_count; $i++) { $query = "UPDATE merchantlist SET slot={$i}+1 WHERE merchantid={$merchantid} AND item={$item_id[$i]}"; $mysql->query_no_result($query); } }