25543 Circle the Wagons... er, Boats Quest Order

[eyerobot]

25543 Circle the Wagons... er, Boats Quest Order Spell Area

-- 25543 Circle the Wagons... er, Boats Quest Order Spell Area

UPDATE `quest_template` SET `PrevQuestId` = 25533 WHERE `Id` = 25543;
UPDATE `quest_template` SET `PrevQuestId` = 25533 WHERE `Id` = 25562;

DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5041 AND `quest_start`=25533 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5041, 25533, 1, 25562, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5041 AND `quest_start`=25532 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5041, 25532, 1, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5041 AND `quest_start`=25532 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5041, 25532, 0, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5041 AND `quest_start`=25533 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5041, 25533, 0, 25562, 0, 0, 2, 1, 74, 11);

DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5046 AND `quest_start`=25533 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5046, 25533, 1, 25562, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5046 AND `quest_start`=25532 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5046, 25532, 1, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5046 AND `quest_start`=25532 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5046, 25532, 0, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5046 AND `quest_start`=25533 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5046, 25533, 0, 25562, 0, 0, 2, 1, 74, 11);

DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5048 AND `quest_start`=25533 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5048, 25533, 1, 25562, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5048 AND `quest_start`=25532 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5048, 25532, 1, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5048 AND `quest_start`=25532 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5048, 25532, 0, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5048 AND `quest_start`=25533 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5048, 25533, 0, 25562, 0, 0, 2, 1, 74, 11);

DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5025 AND `quest_start`=25533 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5025, 25533, 1, 25562, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=71256 AND `area`=5025 AND `quest_start`=25532 AND `quest_start_active`=1 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (71256, 5025, 25532, 1, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5025 AND `quest_start`=25532 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5025, 25532, 0, 25561, 0, 0, 2, 1, 74, 11);
DELETE FROM `spell_area` WHERE `spell`=72049 AND `area`=5025 AND `quest_start`=25533 AND `quest_start_active`=0 AND `aura_spell`=0 AND `racemask`=0 AND `gender`=2;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES (72049, 5025, 25533, 0, 25562, 0, 0, 2, 1, 74, 11);

 

[eyerobot]

This is now updated to include the spell area fixes.

This quest is missing the spell that makes the player jump from the boat and land back on the barge when you complete the second boat quest.
Also when the first quest completes, You should be given the second boat quest automatically by the server. At which time it should put that boat spell on you, So you have the cannons instead of the water cannon.
As it is now you have to swim back to the barge, But at least your in the right phase during the quests.

 

[mastermind]

Nicely done as always.
Thank you

 

[ExO]

Executed to the upcoming release, thanks!