diff options
5 files changed, 65 insertions, 0 deletions
diff --git a/sql/updates/world/2011_12_30_04_world_misc.sql b/sql/updates/world/2011_12_30_04_world_misc.sql new file mode 100644 index 00000000000..d59a5551f14 --- /dev/null +++ b/sql/updates/world/2011_12_30_04_world_misc.sql @@ -0,0 +1,2 @@ +-- Tiger Matriarch Credit have no SAI script +UPDATE `creature_template` SET `AIName`='' WHERE `entry`=40301; diff --git a/sql/updates/world/2011_12_30_05_world_misc.sql b/sql/updates/world/2011_12_30_05_world_misc.sql new file mode 100644 index 00000000000..1ee9c8799ca --- /dev/null +++ b/sql/updates/world/2011_12_30_05_world_misc.sql @@ -0,0 +1,11 @@ +-- Fix Report to Gryan Stoutmantle creature_questrelation values by nelegalno +-- Closes #4461 + +DELETE FROM `creature_questrelation` WHERE `quest` = 109; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES +(233, 109), -- Farmer Saldean +(237, 109), -- Farmer Furlbrow +(240, 109), -- Marshal Dughan +(261, 109), -- Guard Thomas +(294, 109), -- Marshal Haggard +(963, 109); -- Deputy Rainer diff --git a/sql/updates/world/2011_12_30_06_world_misc.sql b/sql/updates/world/2011_12_30_06_world_misc.sql new file mode 100644 index 00000000000..ecd6360b911 --- /dev/null +++ b/sql/updates/world/2011_12_30_06_world_misc.sql @@ -0,0 +1,3 @@ +-- Drowned Guardian & Phylactery Guardian summoned NPC should not give XP fix by tobmaps +-- Closes #1860 +UPDATE `creature_template` SET `flags_extra` = 64 WHERE `entry` IN (26225, 26224); diff --git a/sql/updates/world/2011_12_30_08_world_misc.sql b/sql/updates/world/2011_12_30_08_world_misc.sql new file mode 100644 index 00000000000..df9a75bacd3 --- /dev/null +++ b/sql/updates/world/2011_12_30_08_world_misc.sql @@ -0,0 +1,25 @@ +-- Fix Quest 11795, 11887 'Emergency Protocol: Section 8.2, Paragraph C', 'Emergency Supplies' by Pitcrawler +-- Closes #2026 & #4187 + +SET @NPC :=25841; -- Fizzcrank Recon Pilot +SET @Gossip :=21248; + +DELETE FROM `gossip_menu_option` WHERE (`menu_id`=@Gossip AND `id`=1); +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES +(@Gossip,1,0,"Search the body for the pilot's insignia.",1,1,0,0,0,0,''); + +DELETE FROM `conditions` WHERE `SourceGroup`=21248; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,@Gossip,0,0,9,11887,0,0,0,'',''), +(15,@Gossip,1,0,9,11795,0,0,0,'',''); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=@NPC 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`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@NPC,0,0,0,11,0,100,0,0,0,0,0,82,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - On spawn - set gossip flag'), +(@NPC,0,1,2,62,0,100,0,@Gossip,0,0,0,11,46362,2,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - On gossip option 0 select - cast spell'), +(@NPC,0,2,3,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - close gossip'), +(@NPC,0,3,7,61,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - remove gossip flag'), +(@NPC,0,4,5,62,0,100,0,@Gossip,1,0,0,11,46166,2,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - On gossip option 1 select - cast spell'), +(@NPC,0,5,6,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - close gossip'), +(@NPC,0,6,7,61,0,100,0,0,0,0,0,83,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - remove gossip flag'), +(@NPC,0,7,0,61,0,100,0,0,0,0,0,41,3000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Fizzcrank Recon Pilot - Despawn'); diff --git a/sql/updates/world/2012_01_06_02_world_achievement_criteria_data.sql b/sql/updates/world/2012_01_06_02_world_achievement_criteria_data.sql new file mode 100644 index 00000000000..9e6dddfb949 --- /dev/null +++ b/sql/updates/world/2012_01_06_02_world_achievement_criteria_data.sql @@ -0,0 +1,24 @@ +DELETE FROM `achievement_criteria_data` WHERE criteria_id IN (5220, 5215, 5218, 5221, 5216, 5219, 5213, 5018, 5217, 5214, 5233, 5235, 5232, 5234, 5238, 5236, 5229, 5237, 5230, 5231); +INSERT INTO `achievement_criteria_data` VALUES +-- Classes +(5220,21, 1,0,''), -- Realm First! Level 80 Warrior +(5215,21, 2,0,''), -- Realm First! Level 80 Paladin +(5218,21, 3,0,''), -- Realm First! Level 80 Hunter +(5221,21, 4,0,''), -- Realm First! Level 80 Rogue +(5216,21, 5,0,''), -- Realm First! Level 80 Priest +(5219,21, 6,0,''), -- Realm First! Level 80 Death Knight +(5213,21, 7,0,''), -- Realm First! Level 80 Shaman +(5018,21, 8,0,''), -- Realm First! Level 80 Mage +(5217,21, 9,0,''), -- Realm First! Level 80 Warlock +(5214,21,11,0,''), -- Realm First! Level 80 Druid +-- Races +(5233,21,0,1,''), -- Realm First! Level 80 Human +(5235,21,0,2,''), -- Realm First! Level 80 Orc +(5232,21,0,3,''), -- Realm First! Level 80 Dwarf +(5234,21,0,4,''), -- Realm First! Level 80 Night Elf +(5238,21,0,5,''), -- Realm First! Level 80 Undead +(5236,21,0,6,''), -- Realm First! Level 80 Tauren +(5229,21,0,7,''), -- Realm First! Level 80 Gnome +(5237,21,0,8,''), -- Realm First! Level 80 Troll +(5230,21,0,10,''), -- Realm First! Level 80 Blood Elf +(5231,21,0,11,''); -- Realm First! Level 80 Draenei |