Hello,
I am currently trying to fix quest A Rough Ride (http://old.wowhead.com/12536), but i am experiencing a few problems.
This is the full query:
-- [QUEST] A Rough Ride (12536)
-- NPC entry 28298 (Captive Crocolisk)
SET @ENTRY := 28298;
SET @GOSSIP := 9674;
SET @TEXT_ID := 13120;
UPDATE `creature_template ` SET `gossip_ menu_id`[email protected], ` npcflag`=npcflag|1, ` VehicleId`=0 WHERE ` entry`[email protected];
DELETE FROM `gossip _menu` WHERE ` entry`[email protected];
INSERT INTO `gossip _menu` (`entry` , `text_id `)
VALUES (@GOSSIP, @ TEXT_ID);
-- Added condition so player can only select it once he has the quest
SET @GOSSIP_ENTRY := 9674;
SET @QUEST := 12536;
DELETE FROM `conditions` WHERE `SourceGroup`[email protected]_ ENTRY AND `SourceTypeOrReferenceId`=15 ;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry` , `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue 1`, `ConditionValue2 `, `ConditionValue3` , `ErrorTextId`, ` ScriptName`, `Comment`)
VALUES (15, @ GOSSIP_ENTRY, 0 , 0, 9, @QUEST, 0 , 0, 0 , 0, 'Only show gossip 9674 when quest 12536 is added');
-- Add missing gossip
SET @GOSSIP := 9674;
DELETE FROM `gossip _menu_option` WHERE `menu_id`=9674 AND `id`=0 ;
INSERT INTO `gossip _menu_option` (` menu_id`, ` id`, `option_ icon`, `option _text`, ` option_id`, ` npc_option_npcflag`, ` action_menu_id`, `action_poi_id` , `box_coded` , `box_money` , `box_text`)
VALUES
(@GOSSIP, 0, 0, "You look safe enough.. . let's do this.", 1, 1, 0, 0, 0 , 0, '');
-- [SAI] On gossip select - mount and waypoint
SET @ENTRY := 28298;
SET @GOSSIP := 9674;
SET @SPELL := 51258;
SET @ENTRY_MOUNT := 28308;
SET @MODELID_MOUNT := 25107;
SET @QUEST := 12536;
UPDATE `creature_template ` SET `AIName`='SmartAI' WHERE `entry`[email protected] ;
UPDATE `creature_template ` SET `VehicleId`=115 WHERE `entry`[email protected]_ MOUNT;
UPDATE `creature_template ` SET `unit_ flags`=`unit_flags`|512| 256 WHERE `entry`[email protected] _MOUNT;
DELETE FROM `smart _scripts` WHERE ` entryorguid` IN (@ENTRY, @ENTRY_MOUNT) AND `source_type`=0 ;
INSERT INTO `smart _scripts` (`entryorguid`, `source_type`, `id`, ` link`, `event _type`, ` event_phase_mask` , `event_chance` , `event_flags `, `event_param 1`, `event _param2`, ` event_param3`, `event_param4` , `action_type `, `action_param 1`, `action_ param2`, ` action_param3`, `action_param4`, `action_param5` , `action_param6 `, `target_ type`, `target_ param1`, ` target_param2`, `target_param3`, `target_x`, `target_y`, `target_z` , `target_o` , `comment`)
VALUES
(@ENTRY, 0, 0, 0, 62, 0, 100, 0, @ GOSSIP, 0, 0 , 0, 11 , @SPELL, 0 , 0, 0 , 0, 0 , 7, 0, 0, 0, 0, 0, 0, 0, 'On gossip select - cast spell 51258 (spawn crocolisk)'),
(@ENTRY_MOUNT, 0, 1, 0 , 54, 0 , 100, 0, 0, 0, 0, 0, 53, 1, @ENTRY_MOUNT, 0 , @QUEST, 0, 1, 1, 0, 0 , 0, 0 , 0, 0 , 0, ' On summon - start wp');
-- Waypoints
DELETE FROM `waypoints ` WHERE `entry`=@ ENTRY_MOUNT;
INSERT INTO `waypoints ` (`entry`, `pointid`, `position _x`, ` position_y`, `position_z`, `point_comment`)
VALUES
(@ENTRY_MOUNT, 0, 5268.226, 4425.439, - 95.55899, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 1, 5270.647, 4422.33, -95.36928, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 2, 5274.147, 4417.33, -96.11928, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 3, 5276.147, 4414.58, -96.61928, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 4, 5280.147, 4417.58, -97.11928, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 5, 5285.647, 4421.58, -97.86928, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 6, 5301.897, 4433.08, -98.36928, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 7, 5249.557, 4405.892, - 96.04365, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 8, 5252.021, 4407.61, -96.46158, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 9, 5268.271, 4419.36, -96.96158, ' Captive Crocolisk'),
(@ENTRY_MOUNT, 10, 5268.521, 4419.86, - 96.96158, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 11, 5266.678, 4365.464, - 98.19455, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 12, 5277.914, 4377.498, - 97.96861, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 13, 5276.164, 4382.248, - 98.71861, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 14, 5265.664, 4406.748, - 98.21861, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 15, 5264.414, 4409.498, - 97.46861, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 16, 5263.914, 4411.498, - 96.96861, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 17, 5262.664, 4414.248, - 96.21861, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 18, 5289.138, 4366.553, - 102.234, 'Captive Crocolisk '),
(@ENTRY_MOUNT, 19, 5287.381, 4369.894, - 102.304, 'Captive Crocolisk '),
(@ENTRY_MOUNT, 20, 5286.381, 4372.644, - 101.804, 'Captive Crocolisk '),
(@ENTRY_MOUNT, 21, 5285.631, 4374.144, - 101.054, 'Captive Crocolisk '),
(@ENTRY_MOUNT, 22, 5284.381, 4376.894, - 100.304, 'Captive Crocolisk '),
(@ENTRY_MOUNT, 23, 5282.881, 4380.644, - 100.504, 'Captive Crocolisk '),
(@ENTRY_MOUNT, 24, 5276.881, 4380.394, - 99.05396, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 25, 5274.881, 4380.144, - 98.55396, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 26, 5272.131, 4380.144, - 97.80396, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 27, 5265.131, 4379.644, - 97.05396, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 28, 5261.131, 4379.394, - 96.30396, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 29, 5330.018, 4363.27, - 121.0311, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 30, 5328.354, 4363.276, - 120.7407, 'Captive Crocolisk'),
(@ENTRY_MOUNT, 31, 5325.354, 4363.026, - 119.9907, 'Captive Crocolisk');
-- waypoints not finished yet
[/sql]
This is what should happen: select gossip, spawn and mount crocolisk, croco should start the waypoints and the quest should be completed at the end of his last waypoint (i haven’t added them all yet).
Well the problem is that the crocolisk doesn’t start te waypoints. I tried it with SAI but it still doesn’t work :S
Any help would be appreciated.
P.S there is a quest that looks like this one and Nay linked it to me nut it seems that he is using a timed actionlist to start the WP, owever i don’t quite understand it why he uses that (can’t link the topic atm, cant find it on my phone i will link it once im on my PC).