magmaw sql

INSERT INTO `vehicle_accessory` (`entry`, `accessory_entry`, `description`) VALUES (42347, 41570, 'magmaw head');
UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16, `unit_flags`=33554432, `minlevel`=88, `maxlevel`=88, `ScriptName`='npc_magmaw_head' WHERE `entry`=42347;
UPDATE `creature_template` SET `vehicleID` = 522, `ScriptName`='boss_magmaw' WHERE `entry`=41570;
UPDATE `creature_template` SET `minlevel`=87, `maxlevel`=88, `faction_A`=16, `faction_H`=16, `flags_extra`=128, `ScriptName`='npc_pillar_of_flame' WHERE `entry`=41843;
UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16, `ScriptName`='npc_lava_parasite' WHERE `entry`=41806;
UPDATE `creature_template` SET `minlevel`=85, `maxlevel`=87, `modelid1`=1126, `modelid2`=0, `modelid3`=0, `faction_A`=16, `faction_H`=16, `ScriptName`='npc_magmaw_spike_stalker' WHERE `entry`=41767;

UPDATE `creature_template` SET `spell1`=77917, `minlevel`=85, `maxlevel`=87, `modelid1`=1126, `modelid2`=0, `modelid3`=0 WHERE `entry`=41620;
UPDATE `creature_template` SET `spell1`=77941, `minlevel`=85, `maxlevel`=87, `modelid1`=1126, `modelid2`=0, `modelid3`=0 WHERE `entry`=41789;