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=@GOSSIP,AIName=‘SmartAI’ WHERE entry=15481;
– UPDATE creature_template SET gossip_menu_id=0 WHERE entry=6109;
DELETE FROM gossip_menu WHERE entry BETWEEN @GOSSIP AND @GOSSIP+13;
INSERT INTO gossip_menu (entry,text_id) VALUES
(@GOSSIP+0,7885),
(@GOSSIP+1,7886),
(@GOSSIP+2,7887),
(@GOSSIP+3,7888),
(@GOSSIP+4,7889),
(@GOSSIP+5,7890),
(@GOSSIP+6,7891),
(@GOSSIP+7,7892),
(@GOSSIP+8,7893),
(@GOSSIP+9,7894),
(@GOSSIP+10,7895),
(@GOSSIP+11,7896),
(@GOSSIP+12,7897),
(@GOSSIP+13,7901);
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+5,0,0,‘…’,1,1,@GOSSIP+6,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,‘’),
(@GOSSIP+12,0,0,‘But…’,1,1,@GOSSIP+13,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=@GOSSIP;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup=@GOSSIP;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=14 AND SourceGroup=@GOSSIP+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[/SPOILER]