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