public static function GetItemInfo($ItemID) { global $FCCore; $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 entry = :itemid '); $Statement->bindParam(':itemid', $ItemID); $Statement->execute(); $Result = $Statement->fetch(PDO::FETCH_ASSOC); if (empty($Result) || $ItemID != $Result['entry']) { return false; } else { $Result['subclass'] = Items::ItemSubClass($Result['class'], $Result['subclass']); $Result['class'] = Items::ItemClass($Result['class']); $Result['BuyPrice'] = Text::MoneyToCoins($Result['BuyPrice']); $Result['SellPrice'] = Text::MoneyToCoins($Result['SellPrice']); $Result['bond_translation'] = Items::BondTranslation($Result['bonding']); $Result['it_translation'] = Items::InventoryTypeTranslation($Result['InventoryType']); if ($Result['RequiredSkill'] != 0) { $Result['SkillData'] = Items::GetSkillReqs($Result['RequiredSkill'], $Result['RequiredSkillRank']); } $StatsCount = 0; for ($i = 1; $i <= 10; $i++) { if ($Result['stat_type' . $i] != 0) { $StatsCount++; } } if ($StatsCount > 0) { for ($i = 1; $i <= $StatsCount; $i++) { $Result['stat_translation' . $i] = Items::StatTranslation($Result['stat_type' . $i]); } } for ($i = 1; $i <= 3; $i++) { if ($Result['socketColor_' . $i] != 0) { $Result['socket' . $i] = Items::SocketDescription($Result['socketColor_' . $i]); } } for ($i = 1; $i <= 5; $i++) { if ($Result['spellid_' . $i] != 0 && $Result['spellid_' . $i] != -1) { $Result['spt_translation' . $i] = Items::SpellTrigger($Result['spelltrigger_' . $i]); $Result['spell_data' . $i] = Spells::SpellInfo($Result['spellid_' . $i]); if (strstr($Result['name'], $Result['spell_data' . $i]['Name'])) { $Result['spell_data' . $i]['SearchForCreature'] = Items::FindCreatureBySpell($Result['spellid_' . $i]); } } } if ($Result['socketBonus'] != 0) { $Result['socketBonusDescription'] = Items::SocketBonus($Result['socketBonus']); } $Result['itemsetinfo'] = Items::GetItemSetInfo($ItemID); if ($Result['GemProperties'] != 0) { $Result['gem_bonus'] = Items::getGemBonus($Result['GemProperties']); } return $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; }