diff options
| -rw-r--r-- | sql/updates/world/2011_03_09_0_world_creature_addon.sql (renamed from sql/updates/world/2011_03_08_1_world_creature_addon.sql) | 0 | ||||
| -rw-r--r-- | sql/updates/world/2011_03_09_1_world_misc.sql (renamed from sql/updates/world/2011_03_08_2_world_misc.sql) | 4 |
2 files changed, 2 insertions, 2 deletions
diff --git a/sql/updates/world/2011_03_08_1_world_creature_addon.sql b/sql/updates/world/2011_03_09_0_world_creature_addon.sql index e3ca476d684..e3ca476d684 100644 --- a/sql/updates/world/2011_03_08_1_world_creature_addon.sql +++ b/sql/updates/world/2011_03_09_0_world_creature_addon.sql diff --git a/sql/updates/world/2011_03_08_2_world_misc.sql b/sql/updates/world/2011_03_09_1_world_misc.sql index e3940a32172..5570aa97a32 100644 --- a/sql/updates/world/2011_03_08_2_world_misc.sql +++ b/sql/updates/world/2011_03_09_1_world_misc.sql @@ -1,5 +1,5 @@ -- SrcItemCount is not a WDB field (0/1). -UPDATE `quest_template` SET `SrcItemCount`=1 WHERE `SrcItemId!=0` AND `SrcItemCount`=0; +UPDATE `quest_template` SET `SrcItemCount` = 1 WHERE `SrcItemId` != 0 AND `SrcItemCount` = 0; -- Missing items DELETE FROM `item_template` WHERE `entry` IN (52274,52275,52276,52344,52562,52563,52565,52706,52707,52729,52835,53048,54516) AND `WDBVerified` < 0; @@ -71,4 +71,4 @@ DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=25461; -- Trollin' For V DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=25480; -- Dance Of De Spirits (world event: Zalazane's Fall) DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=25482; -- World Event Dungeon - Headless Horseman DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=25483; -- World Event Dungeon - Coren Direbrew -DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=25485; -- World Event Dungeon - Hummel +-- DELETE FROM `disables` WHERE `sourceType`=1 AND `entry`=25485; -- World Event Dungeon - Hummel (missing item) |