SAI for Quest Gluttonous Lurkers

This is my first time trying this out and I’m not sure if this is being posted in the correct spot xD lol.

This seems to work fine for http://www.trinitycore.org/t/trinitycore/ticket/871.

Hopefully this works out!

Also, is modify npcflag considered “hacky”? The orginal was a npc_spellclick flag, but I don’t know that too well. SmartAI seems to create the same effect and is easier to code.

-- SAI for Quest Gluttonous Lurkers SET @ENTRYRAT := 28202; -- Zul'Drak Rat "Creature" SET @ITEMRAT := 38380; -- Zul'Drak Rat "Item" SET @ENTRYBASILISK := 28203; -- Gorged Lurking Basilisk SET @ITEMBASILISK := 38382; -- Basilisk Crystal -- Set npcflag to gossip, and AIName to SmartAI for Zul'drak Rat and Gorged Lurking Basilisk UPDATE `creature_template` SET `AIName`='SmartAI',`npcflag`=`npcflag`|1 WHERE `entry` IN (@ENTRYRAT,@ENTRYBASILISK); DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRYRAT,@ENTRYBASILISK); 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 (@ENTRYRAT,0,0,1,64,0,100,0,0,0,0,0,56,@ITEMRAT,1,0,0,0,0,7,0,0,0,0,0,0,0, 'Zul''Drak Rat - create item Zul\'Drak Rat'), -- Zul'drak Rat create item 383380 Zul'drak rat and give it to the player who clicked (@ENTRYRAT,0,1,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Zul''Drak Rat - Despawn after creating Zul''Drak Rat'), -- Zul'Drak rat despawn after giving item Zul'drak rat to player (@ENTRYBASILISK,0,0,1,64,0,100,0,0,0,0,0,56,@ITEMBASILISK,1,0,0,0,0,7,0,0,0,0,0,0,0, 'Gorged Lurking Basilisk - Create item Basilisk Crystal'), -- Gorged Lurking Basilisk create item 38382 Basilisk Crystal and give to player (@ENTRYBASILISK,0,1,0,61,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Gorged Lurking Basilisk - Despawn after creating Basilisk Crystal'); -- Gorged Lurking Basilisk despawn after creating item[/sql]

Malcrom was here /emoticons/default_smile.png

Nay was here too (next time add delete before insert, Mr. Malc) /emoticons/default_tongue.png

Please take a look at the SQL in this post: http://www.trinitycore.org/f/index.php?/topic/1187-sai-scripting-tutorial/ for how code should be posted.

Also, please use the SQL code tags.

– Brian

Alright, I’ve made the changes.

Not quite. I edited the first one to meet Trinity SQL coding standards. Much more readable /emoticons/default_smile.png

– Brian

I finished it.

I would like to see spells http://www.wowhead.com/spell=50927 and http://www.wowhead.com/spell=50919 being used.

They are probably related to npc_spellclick_spells.

The spellclick spells are already there but they dont work correctly for some reason, maybe castflag?