diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2014-07-21 15:54:17 +0200 |
|---|---|---|
| committer | Aokromes <Aokromes@users.noreply.github.com> | 2014-07-21 15:54:17 +0200 |
| commit | 210fb1526583635a16b61a43683b213495b2b0f1 (patch) | |
| tree | c501806bbfad0fdd5d5897bff4585f721ee052af | |
| parent | 569bfc3abaeb371d3c07531e8d8674321947b6d0 (diff) | |
DB/Creature: Remove no longer needed Summon Imp quests
Closes #12557
| -rw-r--r-- | sql/updates/world/2014_07_21_08_world_misc.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_07_21_08_world_misc.sql b/sql/updates/world/2014_07_21_08_world_misc.sql new file mode 100644 index 00000000000..08665638fc9 --- /dev/null +++ b/sql/updates/world/2014_07_21_08_world_misc.sql @@ -0,0 +1,6 @@ +-- +UPDATE `npc_trainer` SET `spellcost`=100 WHERE `spell`=688; +DELETE FROM `creature_queststarter` WHERE `quest` IN (1598,1599,1470,1485,8344); +DELETE FROM `creature_questender` WHERE `quest` IN (1598,1599,1470,1485,8344); +UPDATE `creature` SET `position_z`=118.247 WHERE `guid`=93289; +UPDATE `creature` SET `position_z`=120.9 WHERE `guid`=92879; |