public static function GetBossLoot($LootID) { $Statement = Zones::$WConnection->prepare('SELECT * FROM creature_loot_template WHERE Entry = :lootid'); $Statement->bindParam(':lootid', $LootID); $Statement->execute(); $Result = $Statement->fetchAll(PDO::FETCH_ASSOC); $ArrayIndex = 0; $GetDataForItems = array(); foreach ($Result as $ItemDrop) { if ($ItemDrop['Reference'] != 0) { unset($Result[$ArrayIndex]); } else { $GetDataForItems[] = $ItemDrop['Item']; } $ArrayIndex++; } $Result = array_values($Result); $ItemArray = implode(', ', $GetDataForItems); return Zones::GetItemArrayData($ItemArray); }