From 78916e2fa43a4659471595e02f725617d7002263 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 23 Jun 2013 01:50:13 +0200 Subject: DB/Misc: Cleaning db of unused/obsolete stuff --- sql/updates/characters/2013_03_23_00_characters_game_event.sql | 3 +++ sql/updates/world/2013_06_23_00_world_misc.sql | 10 ++++++++++ 2 files changed, 13 insertions(+) create mode 100644 sql/updates/characters/2013_03_23_00_characters_game_event.sql create mode 100644 sql/updates/world/2013_06_23_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/characters/2013_03_23_00_characters_game_event.sql b/sql/updates/characters/2013_03_23_00_characters_game_event.sql new file mode 100644 index 00000000000..d8a58832ce1 --- /dev/null +++ b/sql/updates/characters/2013_03_23_00_characters_game_event.sql @@ -0,0 +1,3 @@ +-- Delete no longer used data from Characters Database +DELETE FROM `game_event_save` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event_condition_save` WHERE `eventEntry` BETWEEN 33 AND 47; diff --git a/sql/updates/world/2013_06_23_00_world_misc.sql b/sql/updates/world/2013_06_23_00_world_misc.sql new file mode 100644 index 00000000000..981f1236dfd --- /dev/null +++ b/sql/updates/world/2013_06_23_00_world_misc.sql @@ -0,0 +1,10 @@ +-- Delete no longer used data from World Database +DELETE FROM `game_event_condition` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event_creature_quest` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event_npc_vendor` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event_npcflag` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event_prerequisite` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event_quest_condition` WHERE `eventEntry` BETWEEN 33 AND 47; +DELETE FROM `game_event` WHERE `description` LIKE '%Shattered Sun Offensive:%'; + +UPDATE `creature_template` SET `lootid`=0 WHERE `entry`=29833; -- cgit v1.2.3