function change_loottable_byrace() { check_authorization(); global $mysql, $npcid, $z; $zid = getZoneID($z); $min_id = $zid * 1000 - 1; $max_id = $zid * 1000 + 1000; $ltid = $_GET['ltid']; $npcrace = $_POST['npcrace']; $updateall = $_POST['updateall']; if ($updateall == 0) { $query = "UPDATE npc_types SET loottable_id={$ltid} WHERE race = {$npcrace} AND id > {$min_id} AND id < {$max_id} AND loottable_id = 0"; $mysql->query_no_result($query); } if ($updateall == 1) { $query = "UPDATE npc_types SET loottable_id={$ltid} WHERE race = {$npcrace} AND id > {$min_id} AND id < {$max_id}"; $mysql->query_no_result($query); } }
function get_npcs_by_grid() { global $mysql; $pathgrid = $_GET['pathgrid']; $zone = getZoneName(getZoneID($_GET['z'])); $query = "SELECT sg.name AS name, sp.spawngroupid AS spawngroupid, sp.zone AS zone, se.npcid AS npcid FROM spawngroup sg, spawn2 sp, spawnentry se WHERE sg.id = sp.spawngroupid AND sp.spawngroupid = se.spawngroupid AND pathgrid = {$pathgrid} AND zone = \"{$zone}\""; $results = $mysql->query_mult_assoc($query); return $results; }
function delete_global() { global $mysql, $z, $zoneid; $zid = getZoneID($z); $query1 = "SELECT version AS zversion FROM zone where id={$zoneid}"; $result1 = $mysql->query_assoc($query1); $zversion = $result1['zversion']; $query = "DELETE FROM instance_list WHERE zone={$zid} AND version={$zversion} AND id < 30"; $mysql->query_no_result($query); }
function build_filter() { global $mysql, $npcid, $z; $zid = getZoneID($z); $filter1 = $_GET['filter1']; $filter2 = $_GET['filter2']; $filter3 = $_GET['filter3']; $filter4 = $_GET['filter4']; $filter_final = array(); if ($filter1) { // Filter by emoteid $filter_emoteid = "emoteid = '" . $filter1 . "'"; $filter_final['sql'] = $filter_emoteid; } if ($filter2 != '') { // Filter by type $filter_type = "type = '" . $filter2 . "'"; if ($filter_final['sql']) { $filter_final['sql'] .= " AND "; } $filter_final['sql'] .= $filter_type; } if ($filter3 != '') { // Filter by event $filter_event = "event_ = '" . $filter3 . "'"; if ($filter_final['sql']) { $filter_final['sql'] .= " AND "; } $filter_final['sql'] .= $filter_event; } if ($filter4) { // Filter by text $filter_text = "text LIKE '%" . $filter4 . "%'"; if ($filter_final['sql']) { $filter_final['sql'] .= " AND "; } $filter_final['sql'] .= $filter_text; } $filter_final['url'] = "&filter=on&filter1={$filter1}&filter2={$filter2}&filter3={$filter3}&filter4={$filter4}"; $filter_final['status'] = "on"; $filter_final['filter1'] = $filter1; $filter_final['filter2'] = $filter2; $filter_final['filter3'] = $filter3; $filter_final['filter4'] = $filter4; return $filter_final; }
function change_spellset_byclass() { check_authorization(); global $mysql, $npcid, $z; $zid = getZoneID($z); $min_id = $zid * 1000 - 1; $max_id = $zid * 1000 + 1000; $id = $_GET['id']; $npcclass = $_POST['npcclass']; $updateall = $_POST['updateall']; if ($updateall == 0) { $query = "UPDATE npc_types SET npc_spells_id={$id} WHERE class = {$npcclass} AND id > {$min_id} AND id < {$max_id} AND npc_spells_id = 0"; $mysql->query_no_result($query); } if ($updateall == 1) { $query = "UPDATE npc_types SET npc_spells_id={$id} WHERE class = {$npcclass} AND id > {$min_id} AND id < {$max_id}"; $mysql->query_no_result($query); } }
function npcs_by_spellid() { global $mysql, $z, $zoneid; $version = 0; $zid = "___"; $results = array(); if ($z) { $zid = getZoneID($z) . "___"; $query = "SELECT version FROM zone WHERE id = {$zoneid}"; $result = $mysql->query_assoc($query); $version = $result['version']; if ($version > 0) { $query = "SELECT id, name FROM npc_types WHERE id like \"{$zid}\" AND version = {$version} AND npc_spells_id != 0 GROUP BY id ORDER BY name ASC"; $results = $mysql->query_mult_assoc($query); } if ($version == 0) { $query = "SELECT id, name FROM npc_types WHERE id like \"{$zid}\" AND npc_spells_id != 0 GROUP BY id ORDER BY name ASC"; $results = $mysql->query_mult_assoc($query); } } else { $query = "SELECT id, name FROM npc_types WHERE id like \"{$zid}\" AND npc_spells_id != 0 GROUP BY id ORDER BY name ASC"; $results = $mysql->query_mult_assoc($query); } return $results; }
function delete_objects_ver() { global $mysql, $z; $zid = getZoneID($z); $object_version = $_POST['object_version']; $query = "DELETE from object WHERE version=\"{$object_version}\" AND zoneid=\"{$zid}\""; $mysql->query_no_result($query); }