-- Yuula UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`minhealth`='5600',`maxhealth`='5600',`faction_A`='1870',`faction_H`='1870' WHERE (`entry`='23449'); UPDATE `creature` SET `curhealth`='5600' WHERE (`guid`='79033'); -- Skyguard Nether Ray UPDATE `creature_template` SET `minlevel`='69',`maxlevel`='70',`minhealth`='4400',`maxhealth`='5800',`faction_A`='1870',`faction_H`='1870' WHERE (`entry`='22987'); UPDATE `creature` SET `curhealth`='5800' WHERE (`guid`='47651'); -- Archer Delvinar UPDATE `creature_template` SET `minlevel`='62',`maxlevel`='62',`minhealth`='5300',`maxhealth`='5300',`minmana`='2568',`maxmana`='2568',`npcflag`='4224' WHERE (`entry`='25196'); UPDATE `creature` SET `curhealth`='5300',`curmana`='2568' WHERE (`guid`='90922'); -- Vindicator Kaan UPDATE `creature_template` SET `minlevel`='70',`maxlevel`='70',`minhealth`='5600',`maxhealth`='5600',`minmana`='3155',`maxmana`='3155',`faction_A`='1805',`faction_H`='1805',`rank`='1',`npcflag`='2',`spell1`='36642',`ScriptName`='generic_creature' WHERE (`entry`='23271'); UPDATE `creature` SET `curhealth`='5600',`curmana`='3155' WHERE (`guid`='96756'); INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES ('23271','11038'); -- Nicole Bartlett UPDATE `creature_template` SET `minhealth`='2000',`maxhealth`='2000',`npcflag`='0' WHERE (`entry`='19033'); UPDATE `creature` SET `curhealth`='2000' WHERE (`guid`='68341'); -- Barthamus UPDATE `creature_template` SET `modelid_A`='21504',`modelid_H`='21504',`minhealth`='5900',`maxhealth`='5900',`type`='7' WHERE (`entry`='23433'); UPDATE `creature` SET `curhealth`='5900' WHERE (`id`='23433'); -- Grisy Spicecrackle UPDATE `creature_template` SET `faction_A`='1818',`faction_H`='1818' WHERE (`entry`='24416'); -- Gargoth UPDATE `creature_template` SET `minhealth`='5800',`maxhealth`='5800',`faction_A`='1818',`faction_H`='1818' WHERE (`entry`='24436'); UPDATE `creature` SET `curhealth`='5800' WHERE (`guid`='84721'); -- Harbinger Haronem UPDATE `creature_template` SET `modelid_A`='18914',`modelid_H`='18914',`minhealth`='11000',`maxhealth`='11000',`faction_A`='1956',`faction_H`='1956',`type`='7' WHERE (`entry`='19475'); UPDATE `creature` SET `curhealth`='11000' WHERE (`guid`='96592'); -- Caylee Dak UPDATE `creature_template` SET `minhealth`='5900',`maxhealth`='5900',`faction_A`='79',`faction_H`='69' WHERE (`entry`='24727'); UPDATE `creature` SET `curhealth`='5900' WHERE (`guid`='96757'); -- Aldor Anchorite UPDATE `creature_template` SET `faction_A`='1805',`faction_H`='1805' WHERE (`entry`='19142'); -- Adyen the Lightwarden UPDATE `creature_template` SET `faction_A`='1805',`faction_H`='1805' WHERE (`entry`='18537'); -- Aldor Vindicator UPDATE `creature_template` SET `minhealth`='5500',`maxhealth`='5500',`faction_A`='1805',`faction_H`='1805',`type`='7',`spell1`='36642' WHERE (`entry`='18549'); UPDATE `creature` SET `curhealth`='5500' WHERE (`id`='18549'); -- Ishanah UPDATE `creature_template` SET `faction_A`='1805',`faction_H`='1805',`type`='7' WHERE (`entry`='18538'); -- Oruhe UPDATE `creature_template` SET `faction_A`='1805',`faction_H`='1805' WHERE (`entry`='21518'); -- Marksman Bova UPDATE `creature_template` SET `faction_A`='1805',`faction_H`='1805' WHERE (`entry`='25195'); -- Haldor the Compulsive UPDATE `creature_template` SET `faction_A`='1805',`faction_H`='1805' WHERE (`entry`='23484'); -- Anchorite Nindumen UPDATE `creature_template` SET `minhealth`='6400',`maxhealth`='6400' WHERE (`entry`='19378'); UPDATE `creature` SET `curhealth`='6400' WHERE (`guid`='69110');