diff options
Diffstat (limited to 'sql/scripts')
| -rw-r--r-- | sql/scripts/world_scripts_full.sql | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql index e18f803f9e5..ddb0c52a5e6 100644 --- a/sql/scripts/world_scripts_full.sql +++ b/sql/scripts/world_scripts_full.sql @@ -861,6 +861,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_blood_queen_lana_thel' WHERE `e UPDATE `creature_template` SET `ScriptName`='npc_kinetic_bomb' WHERE `entry`=38454; UPDATE `creature_template` SET `ScriptName`='npc_dark_nucleus' WHERE `entry`=38369; UPDATE `creature_template` SET `ScriptName`='npc_ball_of_flame' WHERE `entry` IN (38332,38451); +UPDATE `creature_template` SET `ScriptName`='boss_blood_queen_lana_thel' WHERE `entry`=37955; /* IRONFORGE */ UPDATE `creature_template` SET `ScriptName`='npc_royal_historian_archesonus' WHERE `entry`=8879; @@ -1751,7 +1752,7 @@ UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_si' WHERE `TypeId`=5; UPDATE `outdoorpvp_template` SET `ScriptName`='outdoorpvp_ep' WHERE `TypeId`=6; /* ACHIEVEMENTS */ -DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982) AND `type` IN (0,11); +DELETE FROM `achievement_criteria_data` WHERE `criteria_id` IN (3693,6641,6642,6643,6644,3804,3805,3806,3807,3808,3809,3810,3811,3812,3813,1234,1239,5605,5606,12778,13036,13035,13037,12977,12967,12986,12982,12780,13012,13011,13013) AND `type` IN (0,11); INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`,`ScriptName`) VALUES (3693,11,0,0, 'achievement_storm_glory'), (6641,11,0,0, 'achievement_school_of_hard_knocks'), @@ -1779,6 +1780,10 @@ INSERT INTO `achievement_criteria_data` (`criteria_id`,`type`,`value1`,`value2`, (12977,11,0,0, 'achievement_flu_shot_shortage'), (12967,11,0,0, 'achievement_flu_shot_shortage'), (12986,11,0,0, 'achievement_flu_shot_shortage'), -(12982,11,0,0, 'achievement_flu_shot_shortage'); +(12982,11,0,0, 'achievement_flu_shot_shortage'), +(12780,11,0,0, 'achievement_once_bitten_twice_shy_n'), +(13012,11,0,0, 'achievement_once_bitten_twice_shy_n'), +(13011,11,0,0, 'achievement_once_bitten_twice_shy_v'), +(13013,11,0,0, 'achievement_once_bitten_twice_shy_v'); /* EOF */ |