- 916
- 2015
- 24
- Location
- Barryton Michigan USA
Mount and Rider. Fixes spawning, pathing, mounting, vehicleid, Spells, and scripts. and removes wrong spawns.
Code:
-- 29863 Persistence
UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry`=29863;
UPDATE `creature_template` SET `VehicleId` = 203 WHERE `entry` = 29863;
DELETE FROM `smart_scripts` WHERE (`entryorguid`=29863 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
(29863, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 80, 2986300, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Persistence - On Just Summoned - Run Script");
DELETE FROM `smart_scripts` WHERE (`entryorguid`=2986300 AND `source_type`=9);
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
(2986300, 9, 0, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 69, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, "Persistence - On Just Summoned - Run Script");
DELETE FROM `creature_template_addon` WHERE `entry`=29863;
INSERT INTO `creature_template_addon` (`entry`,`bytes1`,`bytes2`) VALUES
(29863,50331648,1);
DELETE FROM `creature` WHERE `id`=29863;
-- 28518 Stefan Vadu
DELETE FROM `spell_script_names` WHERE `spell_id`=55368 AND `ScriptName`='spell_q12661_q12669_q12676_q12677_q12713_summon_stefan';
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (55368, 'spell_q12661_q12669_q12676_q12677_q12713_summon_stefan');
DELETE FROM `spell_scripts` WHERE `id`=50630 AND `effIndex`=0 AND `delay`=0 AND `command`=14 AND `datalong`=46598 AND `datalong2`=0 AND `dataint`=0 AND `x`=0 AND `y`=0 AND `z`=0 AND `o`=0;
INSERT INTO `spell_scripts` (`id`, `effIndex`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`) VALUES (50630, 0, 0, 14, 46598, 0, 0, 0, 0, 0, 0);
DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (28669,29863);
INSERT INTO `vehicle_template_accessory` (`entry`,`accessory_entry`,`seat_id`,`minion`,`description`,`summontype`,`summontimer`) VALUES
(28669,28717,1,1,'Flying Fiend',8,0),
(29863,28518,0,1,'Persistence',8,0);
DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28669,29863);
INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`cast_flags`,`user_type`) VALUES
(28669,46598,0,1),
(29863,46598,0,1);
UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` = 28669;
UPDATE `creature_template` SET `npcflag` = 16777216 WHERE `entry` = 29863;