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; }