case "members": $theSortId = 3; break; case "faction": $theSortId = 4; break; case "type": $theSortId = 5; break; default: $theSortId = 6; // rating } $theSortType = $orderSort == "DESC" ? 1 : 0; } $arenateams = asort2d($arenateams, $theSortId, $theSortType, 6); $chunks = array_chunk($arenateams, $config["results_per_page_arenateam"], 1); $arenateams = $chunks[$pageNo - 1]; foreach ($arenateams as $key => $data) { ?> <tr> <td> <div> <p></p> </div> </td><td class="<?php echo $orderClassSuffix["name"]; ?> "><q><a href="index.php?searchType=teaminfo&arenateamid=<?php echo $data[0]; ?>
case "ItemName": $TheSortId = 1; break; case "ItemLevel": $TheSortId = 2; break; case "Source": $TheSortId = 3; break; default: $TheSortId = 4; // Relevance } $TheSortType = $OrderSort == "DESC" ? 1 : 0; } $Items = asort2d($Items, $TheSortId, $TheSortType, 4); $Chunks = array_chunk($Items, $config["results_per_page_items"], 1); $Items = $Chunks[$PageNo - 1]; $visible_item_ids = ""; foreach ($Items as $Key => $Data) { $visible_item_ids .= $Data[0] . ","; } $visible_item_ids .= "0"; switchConnection("armory", REALM_NAME); $doquery_pls_gm = execute_query("SELECT * FROM `cache_item` WHERE `item_id` IN (" . $visible_item_ids . ") AND `mangosdbkey` = " . $realms[REALM_NAME][2]); $item_cache = array(); while ($result_pls_gm = mysql_fetch_assoc($doquery_pls_gm)) { $item_cache[$result_pls_gm["item_id"]] = $result_pls_gm; } switchConnection("armory", REALM_NAME); $doquery_pls_gm = execute_query("SELECT `item_id` FROM `cache_item_tooltip` WHERE `item_id` IN (" . $visible_item_ids . ") AND `mangosdbkey` = " . $realms[REALM_NAME][2]);
case "name": $theSortId = 1; break; case "leader": $theSortId = 2; break; case "faction": $theSortId = 4; break; default: $theSortId = 3; // members } $theSortType = $orderSort == "DESC" ? 1 : 0; } $guilds = asort2d($guilds, $theSortId, $theSortType, 3); $chunks = array_chunk($guilds, $config["results_per_page_guild"], 1); $guilds = $chunks[$pageNo - 1]; foreach ($guilds as $key => $data) { ?> <tr> <td> <div> <p></p> </div> </td><td class="<?php echo $orderClassSuffix["name"]; ?> "><q><a href="index.php?searchType=guildinfo&guildid=<?php echo $data[0], "&realm=", REALM_NAME; ?>