From 385cb3e116a5ea3d5bf4059400bc58c5a97497ad Mon Sep 17 00:00:00 2001 From: Malcrom Date: Fri, 21 Jun 2013 18:52:12 -0230 Subject: DB/Creature: Fix pathed movement errors. --- sql/updates/world/2013_06_21_02_world_creature.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/2013_06_21_02_world_creature.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_06_21_02_world_creature.sql b/sql/updates/world/2013_06_21_02_world_creature.sql new file mode 100644 index 00000000000..29c83f882da --- /dev/null +++ b/sql/updates/world/2013_06_21_02_world_creature.sql @@ -0,0 +1,14 @@ +UPDATE `creature` SET `modelid`=0, `curhealth`=1, `curmana`=0 WHERE `id`=2591; +UPDATE `creature` SET `modelid`=0, `curhealth`=1, `curmana`=0 WHERE `id`=4844; +UPDATE `creature` SET `modelid`=0, `curhealth`=1 WHERE `id`=5471; +UPDATE `creature` SET `modelid`=0, `curhealth`=1 WHERE `id`=5615; +UPDATE `creature` SET `modelid`=0, `curhealth`=1, `MovementType`=0 WHERE `guid` IN (200617,200618); +UPDATE `creature` SET `modelid`=0, `curhealth`=1, `curmana`=0 WHERE `id`=14876; +UPDATE `creature` SET `MovementType`=0 WHERE `guid` IN (14564,14556,151934,151935,151936,151947,151948,151949,151995,151996,151997,151998,201735,201757,201764,28686,152002,152003,151979,151959,151940,151937,209098,209097,202337,78554,78555,200615,42880,152311,152315); +DELETE FROM `creature_addon` WHERE `guid` IN (7690,23130,23466,23467,14564,128582); +INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES +(7690,76900,1,0, ''), +(23130,231300,1,0, ''), +(23466,234660,1,0, ''), +(23467,234670,1,0, ''), +(128582,1285820,1,0, ''); -- cgit v1.2.3 From 9589cbef3489bbb2a6712570b077b2ca4f72ae85 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Fri, 21 Jun 2013 23:17:48 -0230 Subject: DB/instance_template: Update scriptname for map 269 --- sql/updates/world/2013_06_21_03_world_instance_template.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_06_21_03_world_instance_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2013_06_21_03_world_instance_template.sql b/sql/updates/world/2013_06_21_03_world_instance_template.sql new file mode 100644 index 00000000000..2a22dfcf774 --- /dev/null +++ b/sql/updates/world/2013_06_21_03_world_instance_template.sql @@ -0,0 +1 @@ +UPDATE `instance_template` SET `script`= 'instance_the_black_morass' WHERE `map`=269; -- cgit v1.2.3 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/updates') 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