require "ajax-shared-functions.php";
require "../../configuration/defines.php";
if (!isset($_GET["searchQuery"])) {
$do_query = 0;
} else {
$SearchQuery = validate_string($_GET["searchQuery"]);
if (strlen($SearchQuery) >= $config["min_arenateam_search"]) {
$do_query = 1;
} else {
$do_query = 0;
}
}
if ($do_query) {
$arenateams = array();
switchConnection("characters", REALM_NAME);
$gquery = execute_query("SELECT `arena_team`.`arenateamid`, `name`, `captainguid`, `type`, `rating` FROM `arena_team`, `arena_team_stats` WHERE `arena_team`.`arenateamid` = `arena_team_stats`.`arenateamid` AND `arena_team`.`name` LIKE '%" . change_whitespace($SearchQuery) . "%'");
$totalResults = mysql_num_rows($gquery);
while ($gresults = mysql_fetch_assoc($gquery)) {
$theGuid = $gresults["arenateamid"];
$theName = $gresults["name"];
$theType = $gresults["type"];
$theRating = $gresults["rating"];
$theCaptain = $gresults["captainguid"];
$theMembers = mysql_result(execute_query("SELECT COUNT(*) FROM `arena_team_member` WHERE `arenateamid` = " . $gresults["arenateamid"]), 0);
$captaindata = mysql_fetch_assoc(execute_query("SELECT `name`, `race` FROM `characters` WHERE `guid` = " . $theCaptain . " LIMIT 1"));
$theCaptainName = $captaindata["name"];
$theCaptainRace = $captaindata["race"];
$theFaction = GetFaction($theCaptainRace);
$arenateams[] = array($theGuid, $theName, $theCaptainName, $theMembers, $theFaction, $theType, $theRating);
}
if ($totalResults) {
}
}
if ($do_query) {
switchConnection("armory", REALM_NAME);
$doquery_pls_gm = execute_query("SELECT * FROM `cache_item_search` WHERE `item_name` LIKE '%" . change_whitespace($SearchQuery) . "%' AND `mangosdbkey` = " . $realms[REALM_NAME][2]);
$TotalCachedItems = mysql_num_rows($doquery_pls_gm);
$item_search_cache = array();
while ($result_pls_gm = mysql_fetch_assoc($doquery_pls_gm)) {
$item_search_cache[$result_pls_gm["item_id"]] = $result_pls_gm;
$Items[] = array($result_pls_gm["item_id"], $result_pls_gm["item_name"], $result_pls_gm["item_level"], $result_pls_gm["item_source"], $result_pls_gm["item_relevance"]);
}
switchConnection("mangos", REALM_NAME);
if ($config["locales"]) {
$ItemsQuery = execute_query("SELECT `entry` FROM `locales_item` WHERE `name_loc" . $config["locales"] . "` LIKE '%" . change_whitespace($SearchQuery) . "%'");
} else {
$ItemsQuery = execute_query("SELECT `entry` FROM `item_template` WHERE `name` LIKE '%" . change_whitespace($SearchQuery) . "%'");
}
$TotalItems = mysql_num_rows($ItemsQuery);
if ($TotalItems > $TotalCachedItems) {
while ($ItemInfo = mysql_fetch_assoc($ItemsQuery)) {
if (!isset($item_search_cache[$ItemInfo["entry"]])) {
$item_search_cache[$ItemInfo["entry"]] = cache_item_search($ItemInfo["entry"]);
$Items[] = array($ItemInfo["entry"], $item_search_cache[$ItemInfo["entry"]]["item_name"], $item_search_cache[$ItemInfo["entry"]]["item_level"], $item_search_cache[$ItemInfo["entry"]]["item_source"], $item_search_cache[$ItemInfo["entry"]]["item_relevance"]);
}
}
}
unset($item_search_cache);
if ($TotalItems) {
$Orders = array("ItemName", "ItemLevel", "Source", "Relevance");
$OrderOppositeSort = array();
$OrderSymbol = array();
require "ajax-shared-functions.php";
require "../../configuration/defines.php";
if (!isset($_GET["searchQuery"])) {
$do_query = 0;
} else {
$SearchQuery = validate_string($_GET["searchQuery"]);
if (strlen($SearchQuery) >= $config["min_guild_search"]) {
$do_query = 1;
} else {
$do_query = 0;
}
}
if ($do_query) {
$guilds = array();
switchConnection("characters", REALM_NAME);
$gquery = execute_query("SELECT `guildid`, `name`, `leaderguid` FROM `guild` WHERE `name` LIKE '%" . change_whitespace($SearchQuery) . "%'");
$totalResults = mysql_num_rows($gquery);
while ($gresults = mysql_fetch_assoc($gquery)) {
$theGuid = $gresults["guildid"];
$theName = $gresults["name"];
$theLeader = $gresults["leaderguid"];
$theMembers = mysql_result(execute_query("SELECT COUNT(*) FROM `guild_member` WHERE `guildid` = " . $gresults["guildid"]), 0);
$leaderdata = mysql_fetch_assoc(execute_query("SELECT `name`, `race` FROM `characters` WHERE `guid` = " . $theLeader . " LIMIT 1"));
$theLeaderName = $leaderdata["name"];
$theLeaderRace = $leaderdata["race"];
$theFaction = GetFaction($theLeaderRace);
$guilds[] = array($theGuid, $theName, $theLeaderName, $theMembers, $theFaction);
}
if ($totalResults) {
// Now output guild data //
$orders = array("name", "leader", "members", "faction");
