PHP Items::GetItemInfo方法代码示例

 public static function GetCharactersDeletedItems($CharacterGUID)
 {
     $Statement = parent::$CConnection->prepare('SELECT * FROM item_restoration WHERE character_guid = :guid');
     $Statement->bindParam(':guid', $CharacterGUID);
     $Statement->execute();
     if (Database::IsEmpty($Statement)) {
         return false;
     } else {
         $Index = 0;
         $Result = $Statement->fetchAll(PDO::FETCH_ASSOC);
         foreach ($Result as $Item) {
             $Result[$Index]['price'] = Text::MoneyToCoins($Item['item_price']);
             $Result[$Index]['data'] = parent::GetItemInfo($Item['item_id']);
             $Index++;
         }
         return $Result;
     }
 }

 public static function QuestInfo($QuestID)
 {
     global $FCCore;
     $Statement = Items::$WConnection->prepare('
       SELECT
         qt.*,
         ff.name_loc0 as factionname
       FROM
         quest_template qt, ' . $FCCore['Database']['database'] . '.freedomcore_factions ff
       WHERE
         qt.RewardFactionId1 = ff.factionID
       AND
         id = :questid
     ');
     $Statement->bindParam(':questid', $QuestID);
     $Statement->execute();
     $Result = $Statement->fetch(PDO::FETCH_ASSOC);
     for ($i = 1; $i <= 4; $i++) {
         if ($Result['RewardItem' . $i] != 0) {
             $Result['RewardItem' . $i] = Items::GetItemInfo($Result['RewardItem' . $i]);
         }
     }
     $Result['XPReward'] = Items::QuestXP($Result['QuestLevel'], $Result['RewardXPId']);
     $Result['MoneyReward'] = Text::MoneyToCoins($Result['RewardOrRequiredMoney']);
     return $Result;
 }

                         $ItemName = 'creature' . $Item['spell_data' . $i]['SearchForCreature'] . '.jpg';
                         if (!File::Exists($StorageDir . $ItemName)) {
                             File::Download('http://media.blizzard.com/wow/renders/npcs/rotate/creature' . $Item['spell_data' . $i]['SearchForCreature'] . '.jpg', $StorageDir . $ItemName);
                         }
                     }
                 }
             }
         }
         $Smarty->assign('Item', $Item);
         $Smarty->assign('ItemRelation', $ItemRelation);
         $Smarty->assign('Page', Page::Info('admin', array('bodycss' => 'item-' . $Item['entry'], 'pagetitle' => $Item['name'] . ' - ' . $Smarty->GetConfigVars('Menu_Game') . ' - ')));
         $Smarty->display('pages/item_info');
     }
 } else {
     if ($_REQUEST['lastcategory'] == 'tooltip') {
         $Item = Items::GetItemInfo($_REQUEST['subcategory']);
         if ($Item) {
             $Smarty->assign('Item', $Item);
             $Smarty->display('blocks/item_tooltip');
         } else {
             echo "Not Found!";
         }
     } elseif (strstr($_REQUEST['lastcategory'], '.frag')) {
         $Smarty->assign('RandomCommentCode', md5(uniqid(rand(), true)));
         $Fragment = str_replace('.frag', '', $_REQUEST['lastcategory']);
         $Smarty->assign('SelectedItem', $_REQUEST['subcategory']);
         $ItemRelation = Items::GetItemRelatedInfo($_REQUEST['subcategory']);
         $Smarty->assign('Relations', $ItemRelation[$Fragment]);
         $Smarty->display('fragments/' . $Fragment);
     } else {
         header('Location: /');

 private static function GetEventToys($String)
 {
     $ToysArray = [];
     if (Text::IsNull($String)) {
         return false;
     } else {
         $Exploded = explode(',', $String);
         foreach ($Exploded as $Entry) {
             $GetData = Items::GetItemInfo($Entry);
             if ($GetData != false) {
                 $ToysArray[] = $GetData;
             }
         }
     }
     return $ToysArray;
 }

 /**
  * Returns list of items that stored in guild bank
  * @category Guilds class
  * @example Guilds::BuildGuildBankItemList()
  * @return array
  **/
 public function BuildGuildBankItemList()
 {
     if (!$this->guildId) {
         $this->Log()->writeError('%s : guildId not defined', __METHOD__);
         return false;
     }
     $items_list = $this->cDB->select("SELECT `item_entry` AS `id`, `item_guid` AS `seed`, `SlotId` AS `slot`, `TabId` AS `bag` FROM `guild_bank_item` WHERE `guildid`=?", $this->guildId);
     $count_items = count($items_list);
     for ($i = 0; $i < $count_items; $i++) {
         $tmp_durability = Items::GetItemDurabilityByItemGuid($items_list[$i]['seed']);
         $items_list[$i]['durability'] = $tmp_durability['current'];
         $items_list[$i]['maxDurability'] = $tmp_durability['max'];
         unset($tmp_durability);
         $items_list[$i]['icon'] = Items::getItemIcon($items_list[$i]['id']);
         $items_list[$i]['name'] = Items::getItemName($items_list[$i]['id']);
         $items_list[$i]['qi'] = Items::GetItemInfo($items_list[$i]['id'], 'quality');
         $items_list[$i]['quantity'] = Items::GetItemDataField(ITEM_FIELD_STACK_COUNT, 0, 0, $items_list[$i]['seed']);
         $items_list[$i]['randomPropertiesId'] = 0;
         $tmp_classinfo = Items::GetItemSubTypeInfo($items_list[$i]['id']);
         $items_list[$i]['subtype'] = '';
         $items_list[$i]['subtypeLoc'] = $tmp_classinfo['subclass_name'];
         $items_list[$i]['type'] = $tmp_classinfo['key'];
         $items_list[$i]['slot']++;
     }
     return $items_list;
 }

 public static function GetLearnedRecipesForProfession($ProfessionID, $CharacterGUID)
 {
     global $FCCore;
     $Statement = Characters::$CharConnection->prepare('
     SELECT
         cs.spell, fsla.skillID, fsla.req_skill_value, fsla.max_value, fsla.min_value, fs.reagent1, fs.reagent2, fs.reagent3, fs.reagent4, fs.reagent5, fs.reagent6, fs.reagent7, fs.reagent8, fs.reagentcount1, fs.reagentcount2, fs.reagentcount3, fs.reagentcount4, fs.reagentcount5, fs.reagentcount6, fs.reagentcount7, fs.reagentcount8, fs.effect1itemtype, fs.spellname_loc0 as recipe_name, it.Quality as effect1itemquality
     FROM
         character_spell cs
     LEFT JOIN ' . $FCCore['Database']['database'] . '.freedomcore_skill_line_ability fsla ON
         fsla.spellID = cs.spell
     LEFT JOIN ' . $FCCore['Database']['database'] . '.freedomcore_spell fs ON
         fsla.spellID = fs.spellID
     LEFT JOIN ' . $FCCore['WorldDB']['database'] . '.item_template it ON
         fs.effect1itemtype = it.entry
     WHERE
             fsla.skillID = :profid
         AND
             cs.guid = :charguid
     ORDER BY fsla.req_skill_value DESC;
     ');
     $Statement->bindParam(':charguid', $CharacterGUID);
     $Statement->bindParam(':profid', $ProfessionID);
     $Statement->execute();
     $Result = $Statement->fetchAll(PDO::FETCH_ASSOC);
     $Index = 0;
     foreach ($Result as $Recipe) {
         for ($i = 1; $i < 9; $i++) {
             if ($Recipe['reagent' . $i] != 0) {
                 $ItemInfo = Items::GetItemInfo($Recipe['reagent' . $i]);
                 $Result[$Index]['reagent' . $i . '_name'] = $ItemInfo['name'];
                 $Result[$Index]['reagent' . $i . '_icon'] = $ItemInfo['icon'];
             }
         }
         if ($Recipe['effect1itemtype'] != 0) {
             $ItemInfo = Items::GetItemInfo($Recipe['effect1itemtype']);
             $Result[$Index]['resultingitem_name'] = $ItemInfo['name'];
             $Result[$Index]['resultingitem_icon'] = $ItemInfo['icon'];
         }
         $Index++;
     }
     return $Result;
 }

 /**
  * Returns guild bank items
  * @category Guilds class
  * @category Guilds class
  * @access   public
  * @return   array
  **/
 public function BuildGuildBankItemList()
 {
     if (!$this->guildId) {
         Armory::Log()->writeError('%s : guildId not defined', __METHOD__);
         return false;
     }
     $items_list = Armory::$cDB->select("SELECT `item_entry` AS `id`, `item_guid` AS `seed`, `SlotId` AS `slot`, `TabId` AS `bag` FROM `guild_bank_item` WHERE `guildid`=%d", $this->guildId);
     $count_items = count($items_list);
     for ($i = 0; $i < $count_items; $i++) {
         $item_data = Armory::$wDB->selectRow("SELECT `RandomProperty`, `RandomSuffix` FROM `item_template` WHERE `entry` = %d LIMIT 1", $items_list[$i]['id']);
         $tmp_durability = Items::GetItemDurabilityByItemGuid($items_list[$i]['seed'], $this->m_server);
         $items_list[$i]['durability'] = (int) $tmp_durability['current'];
         $items_list[$i]['maxDurability'] = (int) $tmp_durability['max'];
         $items_list[$i]['icon'] = Items::GetItemIcon($items_list[$i]['id']);
         $items_list[$i]['name'] = Items::GetItemName($items_list[$i]['id']);
         $items_list[$i]['qi'] = Items::GetItemInfo($items_list[$i]['id'], 'quality');
         if ($this->m_server == SERVER_MANGOS) {
             $items_list[$i]['quantity'] = Items::GetItemDataField(ITEM_FIELD_STACK_COUNT, 0, 0, $items_list[$i]['seed']);
         } elseif ($this->m_server == SERVER_TRINITY) {
             $items_list[$i]['quantity'] = Armory::$cDB->selectCell("SELECT `count` FROM `item_instance` WHERE `guid`=%d", $items_list[$i]['seed']);
         }
         //TODO: Find correct random property/suffix for items in guild vault.
         $items_list[$i]['randomPropertiesId'] = Items::GetRandomPropertiesData($items_list[$i]['id'], 0, $items_list[$i]['seed'], true, $this->m_server, null, $item_data);
         $tmp_classinfo = Items::GetItemSubTypeInfo($items_list[$i]['id']);
         $items_list[$i]['subtype'] = null;
         $items_list[$i]['subtypeLoc'] = $tmp_classinfo['subclass_name'];
         $items_list[$i]['type'] = $tmp_classinfo['key'];
         $items_list[$i]['slot']++;
     }
     return $items_list;
 }

 /**
  * Returns guild bank logs
  * @category Guilds class
  * @category Guilds class
  * @access   public
  * @return   array
  **/
 public function BuildGuildBankLogList()
 {
     if (!$this->guildId) {
         Armory::Log()->writeError('%s : guildId not defined', __METHOD__);
         return false;
     }
     $log_list = Armory::$cDB->select("SELECT `LogGuid` AS `logId`, `TabId` AS `obag`, `EventType` AS `type`,\n\t\t`DestTabId` AS `dbag`, (SELECT `name` FROM `characters` WHERE `guid`=`PlayerGuid`) AS `player`,\t\n\t\t(SELECT `guild_rank`.`rname` FROM `guild_rank` WHERE `guildid`=%d AND `rid`=`guild_member`.`rank`) AS `rname`,\n\t\t`guild_member`.`rank`, `ItemOrMoney` AS `entry`, `ItemStackCount` AS `quantity`, `TimeStamp` AS `ts`\n\t\tFROM `guild_bank_eventlog` AS `guild_bank_eventlog`\n\t\tLEFT JOIN `guild_member` AS `guild_member` ON `guild_member`.`guid`=`guild_bank_eventlog`.`PlayerGuid` AND `guild_member`.`guildid`=%d\n\t\tWHERE `guild_bank_eventlog`.`guildid`=%d ORDER BY `ts` DESC LIMIT 500;", $this->guildId, $this->guildId, $this->guildId);
     $count_logs = count($log_list);
     for ($i = 0; $i < $count_logs; $i++) {
         $log_list[$i]['ts'] = date('Y-m-d H:i:s', $log_list[$i]['ts']);
         switch ($log_list[$i]['type']) {
             case 1:
                 //deposit
                 $log_list[$i]['item'] = 1;
                 $log_list[$i]['dbag'] = $log_list[$i]['obag'];
                 $log_list[$i]['obag'] = '';
                 break;
             case 2:
                 //withdraw
                 $log_list[$i]['item'] = 1;
                 $log_list[$i]['dbag'] = '';
                 break;
             case 3:
                 //move
             //move
             case 7:
                 //move
                 $log_list[$i]['item'] = 1;
                 break;
             case 4:
             case 5:
             case 6:
                 //repair
             //repair
             case 8:
             case 9:
                 //buytab
             //buytab
             default:
                 $log_list[$i]['item'] = 0;
                 $log_list[$i]['dbag'] = '';
                 $log_list[$i]['obag'] = '';
                 $log_list[$i]['money'] = $log_list[$i]['entry'];
                 break;
         }
         if ($log_list[$i]['item']) {
             $log_list[$i]['icon'] = Items::GetItemIcon($log_list[$i]['entry']);
             $log_list[$i]['name'] = Items::GetItemName($log_list[$i]['entry']);
             $log_list[$i]['qi'] = Items::GetItemInfo($log_list[$i]['entry'], 'quality');
         }
     }
     return $log_list;
 }

 public static function GetSingleItem($ItemID, $JSONP)
 {
     $NewArray = [];
     $Item = Items::GetItemInfo($ItemID);
     if ($Item != false) {
         $NewArray['id'] = $Item['entry'];
         foreach (array('description', 'name', 'icon', 'stackable') as $Field) {
             $NewArray[$Field] = $Item[$Field];
         }
         $NewArray['allowableClasses'] = 'NYI';
         $NewArray['itemBind'] = $Item['bonding'];
         for ($i = 1; $i <= 10; $i++) {
             if ($Item['stat_type' . $i] != 0) {
                 $NewArray['bonusStats'][] = ['stat' => $Item['stat_type' . $i], 'amount' => $Item['stat_value' . $i]];
             }
         }
         for ($i = 1; $i <= 5; $i++) {
             if ($Item['spellid_' . $i] != -1 && $Item['spellid_' . $i] != 0) {
                 $NewArray['itemSpells'][] = ['spellId' => $Item['spell_data' . $i]['SpellID'], 'spell' => ['id' => $Item['spell_data' . $i]['SpellID'], 'name' => $Item['spell_data' . $i]['Name'], 'icon' => $Item['spell_data' . $i]['icon'], 'description' => $Item['spell_data' . $i]['Description']]];
             }
         }
         if (isset($Item['BuyPrice']['gold'])) {
             $FinalBuyPrice = $Item['BuyPrice']['gold'];
         }
         if (isset($Item['BuyPrice']['silver'])) {
             $FinalBuyPrice = $Item['BuyPrice']['silver'];
         }
         if (isset($Item['BuyPrice']['copper'])) {
             $FinalBuyPrice = $Item['BuyPrice']['copper'];
         }
         $NewArray['buyPrice'] = $FinalBuyPrice;
         $NewArray['itemClass'] = $Item['class']['class'];
         $NewArray['itemSubClass'] = $Item['subclass']['subclass'];
         $NewArray['containerSlots'] = $Item['ContainerSlots'];
         if ($Item['class']['class'] == 2) {
             if ($Item['dmg_min1'] != 0) {
                 $DPS = ($Item['dmg_min1'] + $Item['dmg_max1']) / 2 / ($Item['delay'] / 1000);
                 $DamageMin = $Item['dmg_min1'];
                 $DamageMax = $Item['dmg_max1'];
             } elseif ($Item['dmg_min2'] != 0) {
                 $DPS = ($Item['dmg_min2'] + $Item['dmg_max2']) / 2 / ($Item['delay'] / 1000);
                 $DamageMin = $Item['dmg_min2'];
                 $DamageMax = $Item['dmg_max2'];
             }
             $NewArray['weaponInfo'] = ['damage' => ['min' => $DamageMin, 'max' => $DamageMax, 'exactMin' => number_format((double) $DamageMin, 1, '.', ''), 'exactMax' => number_format((double) $DamageMax, 1, '.', '')], 'weaponSpeed' => $Item['delay'] / 1000, 'dps' => $DPS];
         }
         $NewArray['inventoryType'] = $Item['InventoryType'];
         $NewArray['itemLevel'] = $Item['ItemLevel'];
         $NewArray['maxCount'] = $Item['maxcount'];
         $NewArray['maxDurability'] = $Item['MaxDurability'];
         $NewArray['minFactionId'] = $Item['RequiredReputationFaction'];
         $NewArray['minReputation'] = $Item['RequiredReputationRank'];
         $NewArray['quality'] = $Item['Quality'];
         if (isset($Item['SellPrice']['gold'])) {
             $FinalSellPrice = $Item['SellPrice']['gold'];
         }
         if (isset($Item['SellPrice']['silver'])) {
             $FinalSellPrice = $Item['SellPrice']['silver'];
         }
         if (isset($Item['SellPrice']['copper'])) {
             $FinalSellPrice = $Item['SellPrice']['copper'];
         }
         $NewArray['sellPrice'] = $FinalSellPrice;
         $NewArray['requiredSkill'] = $Item['RequiredSkill'];
         $NewArray['requiredLevel'] = $Item['RequiredLevel'];
         $NewArray['requiredSkillRank'] = $Item['RequiredSkillRank'];
         $SocketsCount = 0;
         for ($i = 1; $i <= 3; $i++) {
             if ($Item['socketColor_' . $i] != 0) {
                 $NewArray['socketInfo']['sockets'][] = ['type' => Items::SocketDescription($Item['socketColor_' . $i])['type']];
                 $SocketsCount++;
             }
         }
         if ($SocketsCount > 0) {
             $NewArray['socketInfo']['socketBonus'] = $Item['socketBonusDescription'];
         }
         $NewArray['baseArmor'] = $Item['armor'];
         if ($SocketsCount > 0) {
             $NewArray['hasSockets'] = true;
         } else {
             $NewArray['hasSockets'] = false;
         }
         $NewArray['displayInfoId'] = $Item['displayid'];
         return parent::Encode($NewArray, $JSONP);
     } else {
         return parent::GenerateResponse(404, true);
     }
 }