diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_02_08_01_world_335.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_02_08_01_world_335.sql b/sql/updates/world/3.3.5/2021_02_08_01_world_335.sql new file mode 100644 index 00000000000..a929ff7127b --- /dev/null +++ b/sql/updates/world/3.3.5/2021_02_08_01_world_335.sql @@ -0,0 +1,30 @@ +-- Healthy Dragon Scale +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 1 AND `SourceGroup` = 10678 AND `SourceEntry` = 13920; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(1,10678,13920,0,0,8,0,5529,0,0,0,0,0,"","Group 0: Item 'Healthy Dragon Scale' can be looted if quest 'Plagued Hatchlings' is rewarded"); + +UPDATE `creature_loot_template` SET `Chance` = 10 WHERE `Item` = 13920 AND `Reference` = 0; + +-- Ras Frostwhisper +UPDATE `creature` SET `MovementType` = 2 WHERE `id` = 10508; +DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 10508); +UPDATE `creature_template_addon` SET `path_id` = 488500, `bytes2` = 4097 WHERE `entry` = 10508; +DELETE FROM `waypoint_data` WHERE `id` = 488500; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(488500,1,-22.732965,147.52971,83.90764,0,0,0,0,0,0), +(488500,2,-42.24653,147.56828,83.931465,0,0,0,0,0,0), +(488500,3,-42.204754,141.33911,83.93054,6.2831853072,90000,0,0,0,0), +(488500,4,-41.44412,134.91525,83.940956,0,0,0,0,0,0), +(488500,5,-22.852322,135.15367,83.90838,0,0,0,0,0,0), +(488500,6,-22.853083,141.41121,83.90816,0,0,0,0,0,0), +(488500,7,-25.107857,141.28365,83.91359,0.03490658476948738,75000,0,0,0,0); + +-- Illusion of Jandice Barov +-- Cleave - removed, nothing in sniffs or another sources +-- Immunity - physical removed, they are immune only to AoE and for some reason not to Mind Flay (Wiki), not to all magic damage +UPDATE `creature_template` SET `spell_school_immune_mask` = 126 WHERE `entry` = 11439; +DELETE FROM `smart_scripts` WHERE `entryorguid` = 11439 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`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(11439,0,0,0,54,0,100,0,0,0,0,0,0,11,17772,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Illusion of Jandice Barov - On Just Summoned - Cast 'Spread'"), +(11439,0,1,0,54,0,100,0,0,0,0,0,0,11,7131,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Illusion of Jandice Barov - On Just Summoned - Cast 'Illusion Passive'"), +(11439,0,2,0,32,0,100,1,1,100000,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Illusion of Jandice Barov - On Damage Taken - Despawn Instant"); |