diff options
| author | CeIa <thijs.emmerink@gmail.com> | 2012-12-14 01:23:53 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-12-14 01:23:53 +0000 |
| commit | b87cc3110665cecf860abfd2dcf2df3b6266ccf2 (patch) | |
| tree | d7e3452d10974c1f1f36c15cf9c29b93a477dd20 /sql | |
| parent | 388bb4361025b1a65fd57b6891077df9da9c0917 (diff) | |
Scripts/Events/Achievement: fix 'Out With It'
Credits to @darkman1983
Closes #8211
Closes #8126
Signed-off-by: Nay <dnpd.dd@gmail.com>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_12_14_02_world_misc.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/2012_12_14_02_world_misc.sql b/sql/updates/world/2012_12_14_02_world_misc.sql new file mode 100644 index 00000000000..8e51865dad0 --- /dev/null +++ b/sql/updates/world/2012_12_14_02_world_misc.sql @@ -0,0 +1,15 @@ +DELETE FROM `spell_script_names` WHERE `spell_id` IN (24750, 24751, 44436); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(24750, 'spell_trick'), +(24751, 'spell_trick_or_treat'), +(44436, 'spell_gen_tricky_treat'); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (42965,42966); +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(42965,42919,0, 'Hallows End - Tricky Treat'), +(42966,-42965,0, 'Hallows End - Upset Tummy removes Tricky Treat'), +(42966,-42919,0, 'Hallows End - Upset Tummy removes Tricky Treat'); + +DELETE FROM `conditions` WHERE `SourceEntry`=44436 AND `SourceTypeOrReferenceId`=17; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(17, 0, 44436, 0, 0, 1, 0, 42966, 0, 0, 1, 0, '','Tricky Treat casted only if Upset Tummy aura is missing'); |