public static function getDataForItemInstance($IDs)
{
$Query = "SELECT entry, name, MaxDurability, InventoryType FROM item_template WHERE ENTRY IN (%s)";
$ItemsString = "";
for ($i = 0; $i < count($IDs); $i++) {
if ($i == count($IDs) - 1) {
$ItemsString .= $IDs[$i];
} else {
$ItemsString .= $IDs[$i] . ', ';
}
}
$Query = sprintf($Query, $ItemsString);
return Database::getMultiRow('World', $Query);
}
public static function getCharactersProfessions($CharacterGUID)
{
$Professions = [];
$Data = Database::getMultiRow('Characters', 'SELECT * FROM character_skills WHERE guid = :guid', [['id' => ':guid', 'value' => $CharacterGUID]]);
foreach ($Data as $Skill) {
$Profession = self::GetProfessionData($Skill['skill']);
if ($Profession) {
$Skill['profession_name'] = $Profession['translation'];
$Professions[] = $Skill;
}
}
return $Professions;
}
