[Complete] Incense for the Summer Scorchlings

[CODE]UPDATE creature_template SET faction_A = 1801, flags_extra = 2 WHERE entry = 26124;

– hack dunno how to make it auto complete like it was on global
UPDATE quest_template SET SrcSpell=46825 WHERE entry=11964;
UPDATE quest_template SET SrcSpell=46826 WHERE entry=11966;

UPDATE creature_template SET AIName= ‘SmartAI’ WHERE entryin (26401,26520);
DELETE FROM smart_scripts WHERE source_type=0 AND entryorguid in (26401,26520);
DELETE FROM smart_scripts WHERE source_type=9 AND entryorguid in (2640100,2652000);
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
(26401,0,0,0,20,0,100,0,11964,0,0,0,80,2640100,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - On quest reward start script - ally’),
(2640100,9,0,0,1,0,100,0,2500,2600,2500,2600,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2640100,9,1,0,1,0,100,0,2500,2600,2500,2600,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Emote’),
(2640100,9,2,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2640100,9,3,0,1,0,100,0,2500,2600,2500,2600,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2640100,9,4,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2640100,9,5,0,1,0,100,0,2500,2600,2500,2600,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2640100,9,6,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2640100,9,7,0,1,0,100,0,2500,2600,2500,2600,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2640100,9,8,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2640100,9,9,0,1,0,100,0,2500,2600,2500,2600,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Emote’),
(2640100,9,10,0,1,0,100,0,2500,2600,2500,2600,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2640100,9,11,0,1,0,100,0,2500,2600,2500,2600,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2640100,9,12,0,1,0,100,0,2500,2600,2500,2600,1,8,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Emote’),
(2640100,9,13,0,1,0,100,0,2500,2600,2500,2600,11,46660,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Extinguished’),
(2640100,9,14,0,1,0,100,0,2500,2600,2500,2600,28,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Remove Scorchling Grow aura’),
(2640100,9,15,0,1,0,100,0,2500,2600,2500,2600,1,9,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(26520,0,1,0,20,0,100,0,11966,0,0,0,80,2652000,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - On quest reward start script - horde’),
(2652000,9,0,0,1,0,100,0,2500,2600,2500,2600,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2652000,9,1,0,1,0,100,0,2500,2600,2500,2600,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Emote’),
(2652000,9,2,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2652000,9,3,0,1,0,100,0,2500,2600,2500,2600,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2652000,9,4,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2652000,9,5,0,1,0,100,0,2500,2600,2500,2600,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2652000,9,6,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2652000,9,7,0,1,0,100,0,2500,2600,2500,2600,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2652000,9,8,0,1,0,100,0,2500,2600,2500,2600,11,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Grow’),
(2652000,9,9,0,1,0,100,0,2500,2600,2500,2600,1,5,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Emote’),
(2652000,9,10,0,1,0,100,0,2500,2600,2500,2600,1,6,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2652000,9,11,0,1,0,100,0,2500,2600,2500,2600,1,7,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’),
(2652000,9,12,0,1,0,100,0,2500,2600,2500,2600,1,8,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Emote’),
(2652000,9,13,0,1,0,100,0,2500,2600,2500,2600,11,46660,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Cast Scorchling Extinguished’),
(2652000,9,14,0,1,0,100,0,2500,2600,2500,2600,28,47114,1,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Remove Scorchling Grow aura’),
(2652000,9,15,0,1,0,100,0,2500,2600,2500,2600,1,9,0,0,0,0,0,1,0,0,0,0,0,0,0, ‘Summer Scorchling - OOC - Say’);

DELETE FROM creature_text WHERE entry in (26401,26520);
INSERT INTO creature_text (entry,groupid,id,text,type,language,probability,emote,duration,sound,comment) VALUES
(26401,0,0, ‘Thank you again, $N for this delectable incense.’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26401,1,0, ‘%s devours the incense. It’‘s ravenous!’,16,0,100,0,0,0, 'Summer Scorchling '),
(26401,2,0, ‘So good! So packed with energy!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26401,3,0, ‘It has everything a growing scorchling needs!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26401,4,0, ‘I can feel the power SURGING within me!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26401,5,0, ‘%s bellows with laughter!’,16,0,100,0,0,0, ‘Summer Scorchling’),
(26401,6,0, ‘KNEEL, LITTLE MORTAL! KNEEL BEFORE THE MIGHT OF THE HERALD OF RAGNAROS!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26401,7,0, ‘YOU WILL ALL PERISH IN FLAMES!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26401,8,0, ‘%s blinks…’,16,0,100,0,0,0, ‘Summer Scorchling’),
(26401,9,0, ‘Ah. I was merely jesting…’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,0,0, ‘Thank you again, $N for this delectable incense.’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,1,0, ‘%s devours the incense. It’‘s ravenous!’,16,0,100,0,0,0, 'Summer Scorchling '),
(26520,2,0, ‘So good! So packed with energy!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,3,0, ‘It has everything a growing scorchling needs!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,4,0, ‘I can feel the power SURGING within me!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,5,0, ‘%s bellows with laughter!’,16,0,100,0,0,0, ‘Summer Scorchling’),
(26520,6,0, ‘KNEEL, LITTLE MORTAL! KNEEL BEFORE THE MIGHT OF THE HERALD OF RAGNAROS!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,7,0, ‘YOU WILL ALL PERISH IN FLAMES!’,12,0,100,0,0,0, ‘Summer Scorchling’),
(26520,8,0, ‘%s blinks…’,16,0,100,0,0,0, ‘Summer Scorchling’),
(26520,9,0, ‘Ah. I was merely jesting…’,12,0,100,0,0,0, ‘Summer Scorchling’);[/sql][/CODE]