From 9a67aaa8b85b72732d2103c3b013cd70281453cb Mon Sep 17 00:00:00 2001 From: kaelima Date: Mon, 27 Jun 2011 20:22:53 +0200 Subject: DB/Creature: - Nuke the hacky column DeathState. - Removed some hacks from Kologarn script, including some cleanup. - Removed set deathstate command. BIG thanks to Malcrom for replacing all creatures that had deathstate with proper dynamicflags/auras. --- sql/updates/world/2011_06_27_06_world_command.sql | 1 + sql/updates/world/2011_06_27_06_world_creature.sql | 4 ++++ 2 files changed, 5 insertions(+) create mode 100644 sql/updates/world/2011_06_27_06_world_command.sql create mode 100644 sql/updates/world/2011_06_27_06_world_creature.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_06_27_06_world_command.sql b/sql/updates/world/2011_06_27_06_world_command.sql new file mode 100644 index 00000000000..7b3f1e5765f --- /dev/null +++ b/sql/updates/world/2011_06_27_06_world_command.sql @@ -0,0 +1 @@ +DELETE FROM `command` WHERE `name`= 'npc set deathstate'; diff --git a/sql/updates/world/2011_06_27_06_world_creature.sql b/sql/updates/world/2011_06_27_06_world_creature.sql new file mode 100644 index 00000000000..e4e6d3c98ce --- /dev/null +++ b/sql/updates/world/2011_06_27_06_world_creature.sql @@ -0,0 +1,4 @@ +-- Drop DeathState column +ALTER TABLE `creature` DROP COLUMN `DeathState`; +-- Remove spawns for Kologarn (not boss) and Focused Eyebeam (summoned). +DELETE FROM `creature` WHERE `id` IN (34297,33632,33802); -- cgit v1.2.3