[Wip] Seek The Wind Serpent Goddess

Pitcrawler · September 19, 2011, 10:26am

Next quest in the chain I’m working on.

Source:

-- QUEST 12667 'Seek the Wind Serpent Goddess'

SET @GUID := XXX; -- Need 3
SET @GOSSIP := YYY; -- Need sniff
SET @ENTRY_QUETZLUN := 28030;
SET @ENTRY_ALTAR_GATEWAY_REAL_WORLD := 28469;
SET @ENTRY_ALTAR_GATEWAY := 28478;
SET @QUEST_START := 12667;
SET @QUEST_END := 12675;
SET @SPELL_GHOSTLY := 51671;

UPDATE `creature_template` SET `gossip_menu_id`=@GOSSIP, `faction_A`=7 , `faction_H`=7 WHERE `entry`=@ENTRY_QUETZLUN;
UPDATE `creature_template` SET `name`='Altar of Quetz''lun Gateway - Real World', `unit_flags`=`unit_flags`|33554432|512|256 WHERE `entry`=@ENTRY_ALTAR_GATEWAY_REAL_WORLD; -- should not be UNUSED as its name was

DELETE FROM `creature` WHERE `id` IN (@ENTRY_QUETZLUN,@ENTRY_ALTAR_GATEWAY_REAL_WORLD,@ENTRY_ALTAR_GATEWAY);
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES
(@GUID,@ENTRY_QUETZLUN,571,1,2,0,0,5717.330,-4369.834,385.802,1.627,300,0,0,1,0,0,0,0,8), -- Quetz'lun's Spirit
(@GUID+1,@ENTRY_ALTAR_GATEWAY_REAL_WORLD,571,1,1,25181,0,5715.42,-3999.43,372.07,1.58825,300,0,0,1,0,0,0,0,8), -- Altar of Quetz'lun Gateway - Real World
(@GUID+2,@ENTRY_ALTAR_GATEWAY,571,1,2,25181,0,5715.42,-3999.43,372.07,1.58825,300,0,0,1,0,0,0,0,8); -- Altar of Quetz'lun Gateway

DELETE FROM `creature_template_addon` WHERE `entry` IN (@ENTRY_QUETZLUN,@ENTRY_ALTAR_GATEWAY_REAL_WORLD,@ENTRY_ALTAR_GATEWAY);
INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES
(@ENTRY_QUETZLUN,0,0,0,1,0,'51126 41408'), -- Shadowform
(@ENTRY_ALTAR_GATEWAY_REAL_WORLD,0,0,0,1,0,'51715'), -- Altar of Quetz'lun
(@ENTRY_ALTAR_GATEWAY,0,0,0,1,0,'51715'); -- Altar of Quetz'lun

DELETE FROM `creature_addon` WHERE `guid`=101830; -- Remove as there is only one spawn of @ENTRY_ALTAR_GATEWAY so creature_template_addon fits better imo

DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES
(@GOSSIP,13331);

DELETE FROM`spell_area` WHERE `spell`=@SPELL_GHOSTLY;
INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_start_active`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`) VALUES
(@SPELL_GHOSTLY,4325,@QUEST_START,1,@QUEST_END,0,0,2,1);
[/sql]

That there is an Altar Gateway Bunny on the dead side, too can be verified at 0:14 [http://www.youtube.c...?v=nHgbnXKaAAE.](http://www.youtube.com/watch?v=nHgbnXKaAAE.)

Seemed logical to use the one that was marked as UNUSED in the db.

Dunno if the creature_template_addon for Quetz'lun is correct but at least it looks so.

The gossip_menu_id for Quetz'lun is missing in the db but the text 13331 is already there.

Discover · September 19, 2011, 10:46am

Doesn’t belong to SAI but to DB dev section. I like it though. /emoticons/default_smile.png

Pitcrawler · September 19, 2011, 11:31am

Oops you’re right. Please move it over there.

Pitcrawler · October 3, 2011, 11:36am

Any opinions about this one…?

bredafan · October 15, 2011, 9:32pm

great /emoticons/default_smile.png works 100%

but Im also looking for the quest http://www.wowhead.com/quest=12668

But at the risk that I get flames /emoticons/default_smile.png I have to ask for “how could I spawn the creatures with id 28713 in the ghostworld?” I hope I got the right SQL conform syntax /emoticons/default_smile.png

I read the Wiki but Im not sure about the right phase and aura i have to add, My current workaround looks like

[CODE]
– Quest Foundation for Revenge Q 12668

– Defines VARIABLES
SET @GUID :=XXXXXX; – need 12
SET @bunny :=28713; – creature to kill from Q_Template

– Creature Undo flags extra=128
UPDATE creature_template SET flags_extra=‘64’, unit_flags=0 WHERE (entry=@bunny);

– Creature spawn
DELETE FROM creature where id = @bunny;
INSERT INTO creature (guid, id, map, spawnMask, phaseMask, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, curhealth, curmana, MovementType, npcflag, unit_flags, dynamicflags) VALUES
(@GUID, @bunny, 571, 1, 2, 17612, 0, 5678.64, -4279, 375.282, 3.3728, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+1, @bunny, 571, 1, 2, 17612, 0, 5678.67, -4274.91, 375.246, 3.24243, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+2, @bunny, 571, 1, 2, 17612, 0, 5681.29, -4274.64, 375.319, 3.24243, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+3, @bunny, 571, 1, 2, 17612, 0, 5684.05, -4274.36, 375.334, 3.24243, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+4, @bunny, 571, 1, 2, 17612, 0, 5685.62, -4274.2, 375.304, 3.24243, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+5, @bunny, 571, 1, 2, 17612, 0, 5687.85, -4273.98, 375.384, 3.24243, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+6, @bunny, 571, 1, 2, 17612, 0, 5689.72, -4273.79, 375.396, 3.24243, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+7, @bunny, 571, 1, 2, 17612, 0, 5681.36, -4278.91, 375.232, 3.33747, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+8, @bunny, 571, 1, 2, 17612, 0, 5684.47, -4278.3, 375.266, 3.33747, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+9, @bunny, 571, 1, 2, 17612, 0, 5688.23, -4277.55, 375.351, 3.33747, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+10, @bunny, 571, 1, 2, 17612, 0, 5690, -4277.2, 375.317, 3.33747, 300, 0, 0, 42, 0, 0, 0, 0, 8),
(@GUID+11, @bunny, 571, 1, 2, 17612, 0, 5686.31, -4277.93, 375.413, 3.33747, 300, 0, 0, 42, 0, 0, 0, 0, 8);

– Aura Phasing, Creature in sight of phasing
DELETE FROM creature_template_addon WHERE entry=@bunny;
INSERT INTO creature_template_addon (entry,path_id,mount,bytes1,bytes2,emote,auras) VALUES
(@bunny, 0,0,0,1,0,‘51126 41408’);

[/sql][/CODE]

Any ideas ?

thanks in advance!

Pitcrawler · October 16, 2011, 7:32pm

If you wait a few days I’ll post the working quest fix for your quest. Have to do some additional testing…

bredafan · October 16, 2011, 10:15pm

thank you! Maybe I did a thing you called hack /emoticons/default_sad.png .

I spawned the bunny triggers with another model id an flagd them in another faction so you could kill them. All other tries I did faild…maybe I don´t know enough about the things…sry when I bug you…just learning /emoticons/default_smile.png

So the Quest is completeable, but if you post a right working script I´ll remove my crap /emoticons/default_smile.png

The Quest http://www.wowhead.com/quest=12674 that follows after, is also with a spell on a NPC Trigger. NPCid+1 = Trigger NPC stands in the Quest template, as default.

Thanks for your patience and I hope I´m not to hard /emoticons/default_smile.png

Pitcrawler · October 17, 2011, 9:28am

No problem. I just prefer to make things as blizzlike as possible, not just completable /emoticons/default_wink.png .

For the following quest you posted I also have a quite well working quest fix. Just be patient…

bredafan · October 17, 2011, 1:44pm

Thats what I´m valuing…but I´m just on the first steps on my way of learning, and I´ll forecasting a great fix from you. I´ll only do these workarounds because we´d like to start our Server in the next weeks and I realy don´t like to change dropp rates oder xp rates for the reason that “soo many bugs “here”” like other servers do. The top of our start is to be so Blizzlike as we could. /emoticons/default_smile.png so I very appreciate your work and all @trinity

Trista · July 31, 2012, 2:40pm

So what is the problem here currently?

nelegalno · July 31, 2012, 6:16pm


-- https://github.com/TrinityCore/TrinityCore/issues/2927#issuecomment-6961489

SET @GOSSIP := 9734;

SET @ENTRY_QUETZLUN := 28030;


UPDATE `creature_template` SET `gossip_menu_id`=@GOSSIP WHERE `entry`=@ENTRY_QUETZLUN;

DELETE FROM `gossip_menu` WHERE `entry`= AND `text_id`=13331;

INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (@GOSSIP,13331);