diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2016-03-10 16:12:02 +0000 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2016-03-10 16:12:02 +0000 |
| commit | d1efa0b8b1a553b184f884ad757bcebc913f117b (patch) | |
| tree | 8f85e3d3597635a932e9ff09e8f57195e556258c | |
| parent | 5c064e1e73283928f95d0c2fcbff6ef72a8837f0 (diff) | |
DB/Quest: Survey Alcaz Island Credit
If you already had this quest in log prior you may need to abandon and retake/add quest before it will work as I had been trying to figure out why credit spell would not work even if cast on self, as soon as I removed and re-added quest worked
Thanks to @Kodekc
| -rw-r--r-- | sql/updates/world/2016_03_10_01_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/2016_03_10_01_world.sql b/sql/updates/world/2016_03_10_01_world.sql new file mode 100644 index 00000000000..80b23be82c2 --- /dev/null +++ b/sql/updates/world/2016_03_10_01_world.sql @@ -0,0 +1,4 @@ +DELETE FROM `spell_area` WHERE `spell`=42316 AND `area`=2079 AND `quest_start`=11142 AND `aura_spell`=0 AND `racemask`=1101 AND `gender`=2; +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = -42385; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(-42385, 42316, 0, 'On remove Alcaz Survey Aura - cast Alcaz Survey Credit'); |