public static function getEnchantmentData($EnchantmentID) { $Statement = Items::$DBConnection->prepare('SELECT * FROM freedomcore_itemenchantmet WHERE itemenchantmetID = :id'); $Statement->bindParam(':id', $EnchantmentID); $Statement->execute(); if (Database::IsEmpty($Statement)) { return false; } else { $Result = $Statement->fetch(PDO::FETCH_ASSOC); $GetSpellData = Spells::GetSpellByMisc($Result['itemenchantmetID']); if ($GetSpellData && $GetSpellData['effect1id'] == 53) { $Result['enchant_id'] = $GetSpellData['effect1itemtype']; $Result['name'] = $GetSpellData['spellname_loc0']; if ($GetSpellData['effect1itemtype'] != 0) { $Result['create_tooltip'] = 1; } else { $Result['create_tooltip'] = 0; } $Result['is_spell'] = 1; $Result['is_socket'] = 0; } else { $GemData = Items::getGemData($Result['itemenchantmetID']); $Result['enchant_id'] = $GemData['entry']; $Result['name'] = $GemData['name']; $Result['icon'] = $GemData['icon']; $Result['is_spell'] = 0; $Result['is_socket'] = 1; } return $Result; } }