diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-03-09 16:32:44 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-03-09 16:32:44 +0000 |
| commit | 6e158f90a399dede2e60ad09ed653e67429e7060 (patch) | |
| tree | a501ee80fc754d434b3f1b41435f0c1d5bbe7eb5 | |
| parent | d8a401194506a0cffbe0e3c6c442223c515f656b (diff) | |
SQL: Fix typo in previous commit
| -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) |