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);
}
