[REJECTED]Quest: Azuregos's Magical Ledger (8575)[REJECTED]

Have the Gossip working correctly. Have the Give Item Working and the one line of Speach Working.

Conditions NOT working. Menu 0 should only show if you have quest 8555 rewarded and dont have the leger (20494) or its Quest (8575) otherwise show Menu+13

[SPOILER]-- Quest: Azuregos’s Magical Ledger (8575)
UPDATE creature_template SET gossip_menu_id[email protected],AIName=‘SmartAI’ WHERE entry=15481;

– UPDATE creature_template SET gossip_menu_id=0 WHERE entry=6109;
INSERT INTO gossip_menu (entry,text_id) VALUES

DELETE FROM gossip_menu_option WHERE menu_id BETWEEN @GOSSIP AND @GOSSIP+13;
INSERT INTO gossip_menu_option (menu_id,id,option_icon,option_text,option_id,npc_option_npcflag,action_menu_id,action_poi_id,action_script_id,box_coded,box_money,box_text) VALUES
(@GOSSIP+0,0,0,‘How did you know? I mean, yes… Yes I am looking for that shard. Do you have it?’,1,1,@GOSSIP+1,0,0,0,0,‘’),
(@GOSSIP+1,0,0,‘Alright. Where?’,1,1,@GOSSIP+2,0,0,0,0,‘’),
(@GOSSIP+2,0,0,‘By Bronzbeard's… um, beard! What are you talking about?’,1,1,@GOSSIP+3,0,0,0,0,‘’),
(@GOSSIP+3,0,0,‘Fish? You gave a piece of what could be the key to saving all life on Kalimdor to a fish?’,1,1,@GOSSIP+4,0,0,0,0,‘’),
(@GOSSIP+4,0,0,‘A minnow? The oceans are filled with minnows! There could be a hundred million minnows out there!’,1,1,@GOSSIP+5,0,0,0,0,‘’),
(@GOSSIP+6,0,0,‘You put the piece in a minnow and placed the minnow somewhere in the waters of the sea betwen here and the Eastern Kingdoms? And this minnow has special powers?’,1,1,@GOSSIP+7,0,0,0,0,‘’),
(@GOSSIP+7,0,0,‘You're insane.’,1,1,@GOSSIP+8,0,0,0,0,‘’),
(@GOSSIP+8,0,0,‘I'm all ears.’,1,1,@GOSSIP+9,0,0,0,0,‘’),
(@GOSSIP+9,0,0,‘Come again.’,1,1,@GOSSIP+10,0,0,0,0,‘’),
(@GOSSIP+10,0,0,‘Ok, let me get this straight. You put the scepter shard entrusted to your Flight by Anachronos on a minnow of your own making and now you expect me to build an… an arcanite buoy or something… to force your minnow out of hiding? AND potentially incur the wrath of an Elemental Lord? Did I miss anything? Perhaps I am to do this without any clothes on, during a solar eclipse, on a leap year?’,1,1,@GOSSIP+11,0,0,0,0,‘’),
(@GOSSIP+11,0,0,‘FINE! And how, dare I ask, am I supposed to acquire an arcanite buoy?’,1,1,@GOSSIP+12,0,0,0,0,‘’),

DELETE FROM smart_scripts WHERE entryorguid=15481;
INSERT INTO smart_scripts (entryorguid,source_type,id,link,event_type,event_phase_mask,event_chance,event_flags,event_param1,event_param2,event_param3,event_param4,action_type,action_param1,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
(15481,0,0,0,62,0,100,0,@GOSSIP+11,0,0,0,56,20949,1,0,0,0,0,7,0,0,0,0,0,0,0, ‘Spirit of Azuregos Give Ledger’),
(15481,0,1,0,62,0,100,0,@GOSSIP+12,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Spirit of Azuregos Closing Speach’);

DELETE FROM creature_text WHERE entry=15481;
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(15481,0,0, ‘I SAID GOOD DAY!’,0,0,100,0,0,0, ‘Spirit of Azuregos’);

– Should show the Scripted Menu only when quest 8555 is rewared and you dont have the ledger or ledgers’s quest
– Otherwise should show the Final Menu
– Conditions Not working
DELETE FROM conditions WHERE SourceTypeOrReferenceId=14 AND SourceGroup[email protected];
DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup[email protected];
DELETE FROM conditions WHERE SourceTypeOrReferenceId=14 AND SourceGroup[email protected]+13;
INSERT INTO conditions (SourceTypeOrReferenceId,SourceGroup,SourceEntry,ElseGroup,ConditionTypeOrReference,ConditionValue1,ConditionValue2,ConditionValue3,ErrorTextId,ScriptName,Comment) VALUES
(14,@GOSSIP,7885,0,8,8555,0,0,0,‘’,‘Only Show once Previous quest Chain Complete’),
(15,@GOSSIP,0,0,8,8555,0,0,0,‘’,‘Only Show once Previous quest Chain Complete’),
(14,@GOSSIP,7901,0,9,8575,0,0,0,‘’,‘Skip to End if quest taken’),
(14,@GOSSIP,7901,0,2,20949,1,0,0,‘’,‘Skip to end if have item’);

SET @GOSSIP=XXXXXX; -- need 14


You should use SAI rather than gossip scripts.

i think that is also a matter of complexity, in this case its not bad to use the gossip_scripts if you ask me

In case you didn’t know; we want to move all gossip_scripts TO smartAI, therefor its not very smart adding it to gossip_scripts /emoticons/default_tongue.png

So everyone is on the same page, ALL *_scripts tables (with spell_scripts having a few exceptions) are going to go to SAI. Also, EAI will slowly be phased out…

One DB scripting system to rule them all!

– Brian

fine, gossip_script works fine for fast & easy scripts though

ok, ill rewirte for SAI, but original Problem with conditions still preset.

First Post updated with SAI

This was fixed in https://github.com/TrinityCore/TrinityCore/commit/b7e914321d271b517acc577eb4fe704971db9455