magmaw sql

DELETE FROM `vehicle_accessory` WHERE `entry` = 41570;
INSERT INTO `vehicle_accessory` (`entry`, `accessory_entry`, `seat_id`, `minion`, `description`) VALUES (41570, 42347, 0, 1, 'Magmaw Head');

UPDATE `creature_template` SET `faction_A`=16, `faction_H`=16, `unit_flags`=33554432, `minlevel`=88, `maxlevel`=88, `ScriptName`='' WHERE `entry`=42347;
UPDATE `creature_template` SET `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 `minlevel` = 87, `maxlevel` = 87, `faction_A` = 16, `faction_H` = 16, `ScriptName` = 'npc_lava_parasite' WHERE entry = 42321;
DELETE FROM `spell_script_names` WHERE `spell_id` = 89773;
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (89773, 'spell_magmaw_mangle');