public static function GetAllItemsInSubCategoryByInventoryType($CategoryID, $SubCategoryID, $InventoryType, $Offset) { global $FCCore; $Result = array(); $Statement = Items::$WConnection->prepare(' SELECT it.*, LOWER(fi.iconname) as icon FROM item_template it LEFT JOIN ' . $FCCore['Database']['database'] . '.freedomcore_icons fi ON it.displayid = fi.id WHERE it.class = :class AND it.subclass = :subclass AND it.InventoryType = :invtype ORDER BY it.ItemLevel DESC LIMIT 50 OFFSET ' . $Offset . ' '); $Statement->bindParam(':class', $CategoryID); $Statement->bindParam(':subclass', $SubCategoryID); $Statement->bindParam(':invtype', $InventoryType); $Statement->execute(); $Result['item_list'] = $Statement->fetchAll(PDO::FETCH_ASSOC); if (!empty($Result['item_list'])) { for ($i = 0; $i < 1; $i++) { $Result['category_data'] = array('name' => Items::ItemClass($Result['item_list'][$i]['class']), 'subname' => Items::ItemSubClass($Result['item_list'][$i]['class'], $Result['item_list'][$i]['subclass']), 'inventorytype' => array('id' => $InventoryType, 'translation' => Items::InventoryTypeTranslation($InventoryType))); } } $Index = 0; if (!empty($Result['item_list'])) { foreach ($Result['item_list'] as $Item) { $Result['item_list'][$Index]['subclass'] = Items::ItemSubClass($Item['class'], $Item['subclass']); $Result['item_list'][$Index]['class'] = Items::ItemClass($Item['class']); $Index++; } } return array('count' => Items::SelectCount('item_template', array('class' => $CategoryID, 'subclass' => $SubCategoryID, 'InventoryType' => $InventoryType)), 'items' => $Result); }
private static function GetItemArrayData($ItemArray) { global $FCCore; $SQL = 'SELECT it.entry, it.class, it.subclass, it.name, it.displayid, it.Quality, it.BuyPrice, it.SellPrice, it.bonding, it.RequiredLevel, it.InventoryType, LOWER(fi.iconname) as icon FROM item_template it LEFT JOIN ' . $FCCore['Database']['database'] . '.freedomcore_icons fi ON it.displayid = fi.id WHERE entry IN (' . $ItemArray . ')'; $Statement = Zones::$WConnection->prepare($SQL); $Statement->execute(); $Result = $Statement->fetchAll(PDO::FETCH_ASSOC); $ArrayIndex = 0; foreach ($Result as $Item) { $Result[$ArrayIndex]['subclass'] = Items::ItemSubClass($Item['class'], $Item['subclass']); $Result[$ArrayIndex]['class'] = Items::ItemClass($Item['class']); $Result[$ArrayIndex]['BuyPrice'] = Text::MoneyToCoins($Item['BuyPrice']); $Result[$ArrayIndex]['SellPrice'] = Text::MoneyToCoins($Item['SellPrice']); $Result[$ArrayIndex]['bond_translation'] = Items::BondTranslation($Item['bonding']); $Result[$ArrayIndex]['it_translation'] = Items::InventoryTypeTranslation($Item['InventoryType']); $ArrayIndex++; } return $Result; }