From 8224116f89f1b37f67a9faff5104582d7e5a519c Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 20 Jun 2013 18:05:21 +0300 Subject: DB/Misc: Cleaning db --- sql/updates/world/2013_06_20_00_world_creature.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2013_06_20_00_world_creature.sql diff --git a/sql/updates/world/2013_06_20_00_world_creature.sql b/sql/updates/world/2013_06_20_00_world_creature.sql new file mode 100644 index 00000000000..1ce9bce76d7 --- /dev/null +++ b/sql/updates/world/2013_06_20_00_world_creature.sql @@ -0,0 +1,2 @@ +-- Cleaning db, those mobs already have emote asigned on creature_template_addon +DELETE FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE `id` = 33236) AND `emote`=27; -- cgit v1.2.3