public static function generateCharacterSpellsSQL($CharacterGUID, $Spells)
{
$NewSpells = [];
$SQLArray = [];
foreach ($Spells as $Spell) {
$Status = Database::getSingleRow('Characters', 'SELECT * FROM character_spell WHERE guid = :guid AND spell = :spell', [['id' => ':guid', 'value' => $CharacterGUID], ['id' => ':spell', 'value' => $Spell]]);
if (!$Status) {
$NewSpells[] = $Spell;
}
}
foreach ($NewSpells as $Spell) {
$SQLArray[] = "INSERT INTO character_spell (guid, spell, active, disabled) VALUES ('{$CharacterGUID}', '{$Spell}', '1', '0')";
}
return $SQLArray;
}