- 916
- 2015
- 24
- Location
- Barryton Michigan USA
Missing Spawns, Missing Scripts, Missing Text
Code:
-- 27231 Reinforcements from Fenris
-- 27226 Hair Of The Dog
-- 45196 Orc Sea Dog
-- 60870 Barrel Of Explosive Ale
-- 84514 Barrel of Explosive Ale Channeled Spell
-- 84516 Barrel of Explosive Ale Player Buff
-- 84511 Mortally Wounded
-- 44916 Admiral Hatchet Missing Spawn
DELETE FROM `creature` WHERE `id`=44916;
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 (44916, 0, 0, 0, 1, 1, 34181, 0, 1068.75, 1601.3, 28.0847, 2.28638, 120, 0, 0, 1640, 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 (44916, 0, 130, 228, 1, 3, 34181, 44916, 507.885, 1544.52, 130.039, 3.39379, 120, 0, 0, 1640, 0, 0, 0, 0, 0, 0);
-- 44917 Warlord Torok Missing Spawn
DELETE FROM `creature` WHERE `id`=44917;
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 (44917, 0, 0, 0, 1, 1, 0, 0, 1070.59, 1602.1, 28.0824, 1.97222, 120, 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 (44917, 0, 130, 228, 1, 3, 0, 0, 507.932, 1542.43, 130.07, 3.21301, 300, 0, 0, 1500, 0, 0, 0, 0, 0, 0);
-- 45196 Orc Sea Dog
UPDATE `creature_template` SET `faction_A` = 29, `faction_H` = 29, `AIName` = 'SmartAI' WHERE `entry` = 45196;
DELETE FROM `creature_template_addon` WHERE `entry`=45196;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES (45196, 0, 0, 0, 1, 0, '');
DELETE FROM `smart_scripts` WHERE (`entryorguid`=45196 AND `source_type`=0);
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`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
(45196, 0, 0, 1, 8, 0, 100, 1, 84514, 0, 0, 0, 33, 45196, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "On Spellhit - Give Killed Credit To Invoker"),
(45196, 0, 1, 2, 61, 0, 100, 0, 84514, 0, 0, 0, 1, 0, 1000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Link - Say 0"),
(45196, 0, 2, 3, 61, 0, 100, 0, 84514, 0, 0, 0, 28, 84511, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Link - Remove Mortally Wounded"),
(45196, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 19, 33536, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Link - Remove Unit Flags"),
(45196, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 19, 45254, 25, 0, 0, 0, 0, 0, "On Link - Attack Nearest Hillsbrad Worgen"),
(45196, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 120000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Link - Despawn Self"),
(45196, 0, 6, 0, 25, 0, 100, 1, 0, 0, 0, 0, 11, 84511, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "On Spawn - Cast Mortally Wounded On Self");
-- Missing Creature Text
DELETE FROM `creature_text` WHERE `entry`=45196 AND `groupid`=0 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (45196, 0, 0, 'AAAAAAAAAALLLLLLLLLLEEEEEEEEE!!! ARRRRRRRRGGGHHHH!', 12, 0, 100, 1, 0, 0, 0, 'Orc Sea Dog');
DELETE FROM `creature_text` WHERE `entry`=45196 AND `groupid`=0 AND `id`=1;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (45196, 0, 1, 'Crush and clobber! Bobber slobber!', 12, 0, 100, 1, 0, 0, 0, 'Orc Sea Dog');
DELETE FROM `creature_text` WHERE `entry`=45196 AND `groupid`=0 AND `id`=2;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (45196, 0, 2, ' HELL OF A KICK TO THAT ALE!', 12, 0, 100, 1, 0, 0, 0, 'Orc Sea Dog');
DELETE FROM `creature_text` WHERE `entry`=45196 AND `groupid`=0 AND `id`=3;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (45196, 0, 3, 'I may or may not have pissed myself.', 12, 0, 100, 1, 0, 0, 0, 'Orc Sea Dog');
DELETE FROM `creature_text` WHERE `entry`=45196 AND `groupid`=0 AND `id`=4;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (45196, 0, 4, 'My power has returned!', 12, 0, 100, 1, 0, 0, 0, 'Orc Sea Dog');
DELETE FROM `creature_text` WHERE `entry`=45196 AND `groupid`=0 AND `id`=5;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (45196, 0, 5, 'ORC NEEDS PEANUTS!', 12, 0, 100, 1, 0, 0, 0, 'Orc Sea Dog');