- 916
- 2015
- 24
- Location
- Barryton Michigan USA
A gun was missing, No skills on gun, Gun wasn't usable. Defenders are spawned instead of scripted, Could change this later i guess.
Code:
-- 11421 It Goes to 11...
-- 27992 Vrykul Harpoon Gun
UPDATE `creature_template` SET `unit_flags` = 16777216 WHERE `entry` = 27992;
UPDATE `creature_template` SET `spell1` = 43986, `spell2` = 43997 WHERE `entry` = 27992;
UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` = 27992;
DELETE FROM `creature` WHERE `id`=27992;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (27992, 571, 0, 0, 1, 1, 22524, 0, 994.286, -5312, 175.574, 1.18682, 90, 0, 0, 1, 0, 0, 0, 0, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (27992, 571, 495, 3980, 1, 65535, 0, 0, 925.186, -5299.73, 175.2, 1.81514, 300, 0, 0, 8982, 0, 0, 16777216, 0, 0, 0);
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=27992 AND `spell_id`=46598;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES (27992, 46598, 1, 0);
-- 24533 Dragonflayer Defender
UPDATE `creature_template` SET `MovementType` = 1, `InhabitType` = 4 WHERE `entry` = 24533;
UPDATE `creature_template` SET `RegenHealth` = 0 WHERE `entry` = 24533;
DELETE FROM `creature` WHERE `id`=24533;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3984, 1, 65535, 0, 0, 888.688, -5273.4, 176.86, 1.80729, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 930.923, -5239.65, 199.174, 0.417131, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 968.878, -5241.27, 187.928, 5.45939, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 1015.03, -5224.85, 181.801, 0.464257, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 990.608, -5188.77, 191.263, 2.1725, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 927.818, -5161.04, 174.344, 3.01287, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 866.052, -5200.33, 179.739, 4.20668, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 913.395, -5156.75, 137.167, 1.10042, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 1011.61, -5141.51, 102.239, 0.0519132, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 850.601, -5093.83, 100.61, 2.62802, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 745.831, -5292.57, 173.203, 2.30208, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 698.811, -5198.14, 91.2654, 1.91331, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 811.39, -5223.13, 226.008, 4.90961, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 690.885, -5345.81, 196.049, 3.83361, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 1076.98, -5254.72, 159.084, 0.424984, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 1075.12, -5134.77, 134.488, 1.80728, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 1010.97, -5145.05, 68.4657, 3.35845, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 857.279, -5188.21, 89.8145, 3.71188, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 864.617, -5243.83, 269.323, 4.79572, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES (24533, 571, 495, 3980, 1, 65535, 0, 0, 1020.38, -5232.4, 237.024, 6.25262, 300, 50, 0, 7984, 0, 1, 0, 134250496, 0, 0);
UPDATE `creature` SET `spawndist`='50', `MovementType`='1' WHERE `id`= 24533;