diff options
| author | TCKiper <kiperek@o2.pl> | 2011-05-18 15:56:24 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-05-18 15:56:24 +0100 |
| commit | ddd530edd24109e65206842c02a69d8fbde3a907 (patch) | |
| tree | 06a8ebeb1ad56521d2d8f1d798f58adb1d534b87 | |
| parent | e6e3174d9a869fac2df7c6bbd6ebcdbabfdd1509 (diff) | |
DB/Achievements: Fix criterias for Not In My House and for Take a Chill Pill
| -rw-r--r-- | sql/updates/world/2011_05_18_04_world_achievements.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/sql/updates/world/2011_05_18_04_world_achievements.sql b/sql/updates/world/2011_05_18_04_world_achievements.sql new file mode 100644 index 00000000000..82e04bc1f93 --- /dev/null +++ b/sql/updates/world/2011_05_18_04_world_achievements.sql @@ -0,0 +1,18 @@ +-- Fix achievement criteria for Not In My House +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7021; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7021; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(7021,6,4572,0, ''), -- check if player is in Warsong Flag Room +(7021,7,23333,0, ''); -- check if victim has a Horde Flag buff +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7020; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=7020; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(7020,6,4571,0, ''), -- check if player is in Silverwing Flag Room +(7020,7,23335,0, ''); -- check if victim has a Alliance Flag buff + +-- Fix achievement criteria for Take a Chill Pill +DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=3879; +DELETE FROM `achievement_criteria_data` WHERE `criteria_id`=3879; +INSERT INTO `achievement_criteria_data` (`criteria_id`, `type`, `value1`, `value2`, `ScriptName`) VALUES +(3879,6,3820,0, ''), -- check if player is in Eye of the Storm +(3879,7,23505,0, ''); -- check if victim has a Berserking buff |