Code:
for the creature:
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
(80003, 0, 0, 0, 0, 0, 11053, 3085, 7805, 0, 'Uldamane', 'Mystischer Zwergenorden', '', 0, 80, 83, 2, 0, 0, 1, 1.99206, 1, 0, 520, 581, 0, 390, 2, 2000, 2000, 2, 32768, 2048, 0, 0, 0, 0, 0, 0, 393, 486, 53, 7, 0, 80003, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1299, 2165, 'SmartAI', 0, 3, 1, 1, 1, 1, 0, 0, 1, 0, 0, '', 12340);
Try for the Spellcasting:
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(80003, 0, 0, 0, 8, 0, 100, 0, 0, 4, 12000, 15000, 0, 11, 51758, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nFeuerreflektion'),
(80003, 0, 1, 0, 8, 0, 100, 0, 0, 4, 12000, 15000, 0, 11, 7101, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nFeuerstoß'),
(80003, 0, 2, 0, 8, 0, 100, 0, 0, 16, 12000, 15000, 0, 11, 51763, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nFrostrelektion'),
(80003, 0, 3, 0, 8, 0, 100, 0, 0, 16, 12000, 15000, 0, 11, 8085, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nFrostschock'),
(80003, 0, 4, 0, 8, 0, 100, 0, 0, 32, 12000, 15000, 0, 11, 51764, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nSchattenreflektion'),
(80003, 0, 5, 0, 8, 0, 100, 0, 0, 32, 12000, 15000, 0, 11, 9613, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nSchattenblitz'),
(80003, 0, 6, 0, 8, 0, 100, 0, 0, 64, 12000, 15000, 0, 11, 51766, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nArkanreflektion');
(80003, 0, 7, 0, 8, 0, 100, 0, 0, 64, 12000, 15000, 0, 11, 10274, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'Uldamanen - Zwerg\r\nArkane Geschosse');