diff options
| -rw-r--r-- | sql/updates/world/2011_03_24_0_world_creature_template.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/2011_03_24_1_world_loot_template.sql (renamed from sql/updates/world/2011_03_23_10_world_loot_template.sql) | 0 |
2 files changed, 2 insertions, 3 deletions
diff --git a/sql/updates/world/2011_03_24_0_world_creature_template.sql b/sql/updates/world/2011_03_24_0_world_creature_template.sql index 4f35a668ea8..d1dd1653f33 100644 --- a/sql/updates/world/2011_03_24_0_world_creature_template.sql +++ b/sql/updates/world/2011_03_24_0_world_creature_template.sql @@ -64,7 +64,6 @@ UPDATE `creature_template` SET `difficulty_entry_1`=0,`difficulty_entry_2`=0,`di UPDATE `creature_template` SET `difficulty_entry_1`=0,`difficulty_entry_2`=0,`difficulty_entry_3`=0 WHERE `entry`=38456; -- Frozen Orb -- Delete all the fake/temp diffentry templates -DELETE FROM `creature_template` WHERE `entry` > 100000 ; +DELETE FROM `creature_template` WHERE `entry` BETWEEN 3460602 AND 3845601 OR `entry` IN (1040402,1040403); DELETE FROM `creature_loot_template` WHERE `entry` IN (3672402,3672403,3672502,3672503,3680502,3680503,3680702,3680703,3680802,3680803,3681102,3681103,3682902,3682903,3688002,3688003,3699802,3699803,3700302,3700303,3700402,3700403,3700702,3700703,3701102,3701103,3701202,3701203,3701602,3701603,3701702,3701703,3702102,3702103,3702202,3702203,3702302,3702303,3702502,3702503,3702702,3702703,3703002,3703003,3703102,3703103,3703202,3703203,3703302,3703303,3703402,3703403,3703502,3703503,3703802,3703803,3709802,3709803,3714402,3714403,3714602,3714603,3714802,3714803,3714902,3714903,3721702,3721703,3723002,3723003,3750102,3750103,3750202,3750203,3754402,3754403,3754502,3754503,3754602,3754603,3757102,3757103,3759502,3759503,3766202,3766203,3766302,3766303,3766402,3766403,3766502,3766503,3766602,3766603); -DELETE FROM `creature_onkill_reputation` WHERE `creature_id`>100000; - +DELETE FROM `creature_onkill_reputation` WHERE `creature_id` BETWEEN 3460602 AND 3845601 OR `creature_id` IN (1040402,1040403); diff --git a/sql/updates/world/2011_03_23_10_world_loot_template.sql b/sql/updates/world/2011_03_24_1_world_loot_template.sql index a039b5d1933..a039b5d1933 100644 --- a/sql/updates/world/2011_03_23_10_world_loot_template.sql +++ b/sql/updates/world/2011_03_24_1_world_loot_template.sql |