diff options
| -rw-r--r-- | sql/updates/world/2011_12_30_04_world_misc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_12_30_05_world_misc.sql | 11 | ||||
| -rw-r--r-- | sql/updates/world/2012_01_06_02_world_achievement_criteria_data.sql | 24 |
3 files changed, 37 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/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 |