diff options
| author | kaelima <jeppo_meyer@msn.com> | 2011-06-27 20:22:53 +0200 |
|---|---|---|
| committer | kaelima <jeppo_meyer@msn.com> | 2011-06-27 20:22:53 +0200 |
| commit | 9a67aaa8b85b72732d2103c3b013cd70281453cb (patch) | |
| tree | eb1ea2f154e08afcf5eb8fe6851f5a4b624c62ae /sql/updates | |
| parent | 8fc13f508f4cabae491f3754fbe6ba63f2ea2a63 (diff) | |
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.
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_06_27_06_world_command.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_27_06_world_creature.sql | 4 |
2 files changed, 5 insertions, 0 deletions
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); |