aboutsummaryrefslogtreecommitdiff
path: root/sql/scripts
diff options
context:
space:
mode:
authorShauren <none@none>2010-12-03 17:47:33 +0100
committerShauren <none@none>2010-12-03 17:47:33 +0100
commite0c992a8ba499d3ae7302d134017593f4ee6dae5 (patch)
tree3c89735d023eab966c190355a0eabfec0104039a /sql/scripts
parent892f56c37d919381b5a98910eaccaf3374a9afb6 (diff)
Scripts/Icecrown Citadel: Added script for Blood Queen Lana'Thel
Scripts/Icecrown Citadel: Fixed Invocation of Blood announcement emote for Blood Prince Council Scripts/Icecrown Citadel: Fixed intro for Lady Deathwhisper Scripts/Icecrown Citadel: Fixed Bone Spike for Lord Marrowgar --HG-- branch : trunk
Diffstat (limited to 'sql/scripts')
-rw-r--r--sql/scripts/world_scripts_full.sql9
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 */