[SQL] Buff NPC

Custom Code and Mods Custom Code and Requests
1

Hey all

This is pretty easy to do but… I will share it with you… its ready why must you write it again if you need it xD


SET @BUFFNPC := 400000; -- # (Entry ID of the NPC)

SET @GOPTION := 40000; -- # (--)

SET @GMENU := @GOPTION; -- # (--) Changes as Goption changes

SET @GSCRIPT := 40000; -- # (--)

SET @NPCTXT := 400000; -- # (--)

SET @DISPLAY := 28213; -- # (DisplayID of the NPC)


DELETE FROM creature_template WHERE entry=@BUFFNPC;

DELETE FROM gossip_menu WHERE entry=@GMENU OR entry=@GMENU+1 OR entry=@GMENU+2 OR entry=@GMENU+3 OR entry=@GMENU+4 OR entry=@GMENU+5 OR entry=@GMENU+6 OR entry=@GMENU+7 OR entry=@GMENU+8;

DELETE FROM gossip_menu_option WHERE menu_id=@GOPTION OR menu_id=@GOPTION+1 OR menu_id=@GOPTION+2 OR menu_id=@GOPTION+3 OR menu_id=@GOPTION+4 OR menu_id=@GOPTION+5 OR menu_id=@GOPTION+6 OR menu_id=@GOPTION+7 OR menu_id=@GOPTION+8;

DELETE FROM gossip_scripts WHERE id>@GSCRIPT-1 AND id<@GSCRIPT+135;

DELETE FROM npc_text WHERE ID=@NPCTXT OR ID=@NPCTXT+1 OR ID=@NPCTXT+2 OR ID=@NPCTXT+3 OR ID=@NPCTXT+4;

DELETE FROM conditions WHERE SourceTypeOrReferenceId=15 AND SourceGroup>=@GOPTION AND SourceGroup<=@GOPTION+6 AND ConditionTypeOrReference=6 AND (ConditionValue1=469 OR ConditionValue1=67);

DELETE FROM conditions WHERE SourceTypeOrReferenceId=14 AND SourceGroup=@GMENU AND (SourceEntry=@NPCTXT+1 OR SourceEntry=@NPCTXT) AND ConditionTypeOrReference=6 AND (ConditionValue1=469 OR ConditionValue1=67);


INSERT INTO creature_template (entry,modelid1,name,subname,IconName,gossip_menu_id,minlevel,maxlevel,Health_mod,Mana_mod,Armor_mod,faction_A,faction_H,npcflag,speed_walk,speed_run,scale,rank,dmg_multiplier,unit_class,unit_flags,type,type_flags,InhabitType,RegenHealth,flags_extra) 

VALUES (@BUFFNPC,@DISPLAY,'Bubblez','Buffer','Directions',@GMENU,71,71,1.56,1.56,1.56,35,35,3,1,1.14286,1,1,1,1,2,7,138936390,3,1,2);


-- # Linking texts to the menus


INSERT INTO gossip_menu (entry, text_id) 

VALUES (@GMENU, @NPCTXT);


-- # Gossip options


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

(@GOPTION, 1, 2, '|cffffffffPower Word: Fortitude', 1, 1, @GOPTION, 0, @GSCRIPT, 0, 0, NULL), 

(@GOPTION, 2, 2, '|cffffffffDivine Spirit', 1, 1, @GOPTION, 0, @GSCRIPT+1, 0, 0, NULL), 

(@GOPTION, 3, 2, '|cffffffffShadow Protection', 1, 1, @GOPTION, 0, @GSCRIPT+2, 0, 0, NULL), 

(@GOPTION, 4, 2, '|cffffffffArcane Intellect', 1, 1, @GOPTION, 0, @GSCRIPT+3, 0, 0, NULL),

(@GOPTION, 5, 2, '|cffffffffDalaran Inellect', 1, 1, @GOPTION, 0, @GSCRIPT+4, 0, 0, NULL), 

(@GOPTION, 6, 2, '|cffffffffBlessing of Kings', 1, 1, @GOPTION, 0, @GSCRIPT+5, 0, 0, NULL), 

(@GOPTION, 7, 2, '|cffffffffBlessing of Might', 1, 1, @GOPTION, 0, @GSCRIPT+6, 0, 0, NULL), 

(@GOPTION, 8, 2, '|cffffffffBlessing of Wisdom', 1, 1, @GOPTION, 0, @GSCRIPT+7, 0, 0, NULL), 

(@GOPTION, 9, 2, '|cffffffffBlessing of Santuary', 1, 1, @GOPTION, 0, @GSCRIPT+8, 0, 0, NULL), 

(@GOPTION, 10, 2, '|cffffffffMark of the Wild', 1, 1, @GOPTION, 0, @GSCRIPT+9, 0, 0, NULL); 



-- # Text shown in the menus


INSERT INTO npc_text (ID, text0_0, em0_1) 

VALUES 

(@NPCTXT, '$B |cff00ff00Azeroth-Gaming!$B $B Buffer $B', 6);


-- -----------------------------------------------------------------------------------------------------------------------------

-- # Buffing scripts


INSERT INTO gossip_scripts (id, delay, command, datalong, datalong2, dataint, x, y, z, o) 

VALUES (@GSCRIPT, 0, 15, 48161, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+1, 0, 15, 48073, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+2, 0, 15, 48169, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+3, 0, 15, 42995, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+4, 0, 15, 61024, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+5, 0, 15, 25898, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+6, 0, 15, 48934, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+7, 0, 15, 48938, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+8, 0, 15, 25899, 3, 0, 0, 0, 0, 0),

(@GSCRIPT+9, 0, 15, 48469, 3, 0, 0, 0, 0, 0);

OUTDATED

2

Looks Good . Good job

3

Nice work, but gossip_scripts are being deprecated in favor of smart_scripts. Now your challenge is to do this exact same thing using the smart_scripts table /emoticons/default_cool.png

4

I really like this, could you make a mod morph one also?

5

Yeah why not but… gossip_scripts are not working good so i made the buff and a morph npc in c++ should i release it?

6

gossip in the first one was good.

i’m interested by a mod morph too : )

7

Now I made Buff/Tele/Morph NPCs but in c++ … will post later… making them better atm…

8

implemented your buff npc from the start post, but it doesn’t buff :confused: you can click on the names in the Gossip menu, but he doesn’t cast the buff :confused: can you help me?

9

UPDATED.

[SPOILER]-- Based on the work of hrr_95

– Copyright © Hex.

– Permission is granted to copy, distribute and/or modify this document

– under the terms of the GNU Free Documentation License, Version 1.3

– or any later version published by the Free Software Foundation;

– with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts.

– A copy of the license is included in the section entitled "GNU

– Free Documentation License".

SET @NPC :=xxx; – Entry of the creature.

SET @DISPLAY :=xxx; – Modellid of the creature

SET @GOPTION :=xxx; – Gossip_menu_option /needed 10/

SET @GOMENU :=@GOPTION; – Gossip_menu entry

SET @NPCTEXT :=xxx; – Displayed text

INSERT INTO creature_template (entry, difficulty_entry_1, difficulty_entry_2, difficulty_entry_3, KillCredit1, KillCredit2, modelid1, modelid2, modelid3, modelid4, name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp, faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank, mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime, rangeattacktime, unit_class, unit_flags, dynamicflags, family, trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg, maxrangedmg, rangedattackpower, type, type_flags, lootid, pickpocketloot, skinloot, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold, maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod, Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4, questItem5, questItem6, movementId, RegenHealth, equipment_id, mechanic_immune_mask, flags_extra, ScriptName, WDBVerified) VALUES

(@NPC, 0, 0, 0, 0, 0, @DISPLAY, 0, 0, 0, ‘Buffer Mage’, ‘Since PreBC’, NULL, @GOMENU, 80, 80, 2, 35, 35, 3, 1, 1, 1, 1, 422, 586, 0, 642, 1, 2000, 2200, 2, 8, 4, 0, 0, 0, 0, 0, 345, 509, 103, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘SmartAI’, 0, 3, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ‘’, 0);

–

INSERT INTO gossip_menu (entry, text_id)

VALUES (@GOMENU, @NPCTEXT);

–

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

(@GOPTION, 1, 0, ‘Power Word: Fortitude’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 2, 0, ‘Divine Spirit’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 3, 0, ‘Shadow Protection’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 4, 0, ‘Arcane Intellect’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 5, 0, ‘Dalaran Inellect’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 6, 0, ‘Blessing of Kings’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 7, 0, ‘Blessing of Might’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 8, 0, ‘Blessing of Wisdom’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 9, 0, ‘Blessing of Santuary’, 1, 1, 0, 0, 0, 0, 0, NULL),

(@GOPTION, 10, 0, ‘Mark of the Wild’, 1, 1, 0, 0, 0, 0, 0, NULL);

–

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

(@NPC, 0, 0, 0, 62, 0, 100, 1, @GOPTION, 1, 0, 0, 85, 48161, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Power of Word:Fortitude’);

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

(@NPC, 0, 1, 0, 62, 0, 100, 1, @GOPTION, 2, 0, 0, 85, 48073, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Divine Spirit’);

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

(@NPC, 0, 2, 0, 62, 0, 100, 1, @GOPTION, 3, 0, 0, 85, 48169, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Shadow Protection’);

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

(@NPC, 0, 3, 0, 62, 0, 100, 1, @GOPTION, 4, 0, 0, 85, 42995, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Arcane Intellect’);

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

(@NPC, 0, 4, 0, 62, 0, 100, 1, @GOPTION, 5, 0, 0, 85, 61024, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Dalaran Intellect’);

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

(@NPC, 0, 5, 0, 62, 0, 100, 1, @GOPTION, 6, 0, 0, 85, 20217, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Blessing of Kings’);

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

(@NPC, 0, 6, 0, 62, 0, 100, 1, @GOPTION, 7, 0, 0, 85, 48932, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Blessing of Might’);

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

(@NPC, 0, 7, 0, 62, 0, 100, 1, @GOPTION, 8, 0, 0, 85, 48936, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Blessing of Wisdom’);

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

(@NPC, 0, 8, 0, 62, 0, 100, 1, @GOPTION, 9, 0, 0, 85, 20911, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Blessing of Sanctuary’);

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

(@NPC, 0, 9, 0, 62, 0, 100, 1, @GOPTION, 10, 0, 0, 85, 48469, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘NPC-Buff-Mark of the Wild’);

[/SPOILER]

10

Does it work now Regen? i really wish for someone to upload an NPC buffer :S I cant C++ lol

EDIT: Nvm it works /emoticons/default_smile.png

11

I Fixed this SQL 2012 /08 /28

delete action_script_id and NPC id = 400010


-- Based on the work of hrr_95

-- Copyright ©  Hex.

-- Permission is granted to copy, distribute and/or modify this document

-- under the terms of the GNU Free Documentation License, Version 1.3

-- or any later version published by the Free Software Foundation;

-- with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts.

-- A copy of the license is included in the section entitled "GNU

-- Free Documentation License".

SET @NPC :=400010; -- Entry of the creature.

SET @DISPLAY :=23946; -- Modellid of the creature

SET @GOPTION :=60050; -- Gossip_menu_option /needed 10/

SET @GOMENU :=@GOPTION; -- Gossip_menu entry

SET @NPCTEXT :=400010; -- Displayed text

INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES

(@NPC, 0, 0, 0, 0, 0, @DISPLAY, 0, 0, 0, 'Buffer Mage', 'Since PreBC', NULL, @GOMENU, 80, 80, 2, 35, 35, 3, 1, 1, 1, 1, 422, 586, 0, 642, 1, 2000, 2200, 2, 8, 4, 0, 0, 0, 0, 0, 345, 509, 103, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 8, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 0);

--

INSERT INTO gossip_menu (entry, text_id)

VALUES (@GOMENU, @NPCTEXT);

--

INSERT INTO gossip_menu_option (menu_id, id, option_icon, option_text, option_id, npc_option_npcflag, action_menu_id, action_poi_id, box_coded, box_money, box_text)

VALUES

(@GOPTION, 1, 0, 'Power Word: Fortitude', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 2, 0, 'Divine Spirit', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 3, 0, 'Shadow Protection', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 4, 0, 'Arcane Intellect', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 5, 0, 'Dalaran Inellect', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 6, 0, 'Blessing of Kings', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 7, 0, 'Blessing of Might', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 8, 0, 'Blessing of Wisdom', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 9, 0, 'Blessing of Santuary', 1, 1, 0, 0, 0, 0, NULL),

(@GOPTION, 10, 0, 'Mark of the Wild', 1, 1, 0, 0, 0, 0, NULL);

--

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

(@NPC, 0, 0, 0, 62, 0, 100, 1, @GOPTION, 1, 0, 0, 85, 48161, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Power of Word:Fortitude');

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

(@NPC, 0, 1, 0, 62, 0, 100, 1, @GOPTION, 2, 0, 0, 85, 48073, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Divine Spirit');

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

(@NPC, 0, 2, 0, 62, 0, 100, 1, @GOPTION, 3, 0, 0, 85, 48169, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Shadow Protection');

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

(@NPC, 0, 3, 0, 62, 0, 100, 1, @GOPTION, 4, 0, 0, 85, 42995, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Arcane Intellect');

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

(@NPC, 0, 4, 0, 62, 0, 100, 1, @GOPTION, 5, 0, 0, 85, 61024, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Dalaran Intellect');

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

(@NPC, 0, 5, 0, 62, 0, 100, 1, @GOPTION, 6, 0, 0, 85, 20217, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Kings');

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

(@NPC, 0, 6, 0, 62, 0, 100, 1, @GOPTION, 7, 0, 0, 85, 48932, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Might');

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

(@NPC, 0, 7, 0, 62, 0, 100, 1, @GOPTION, 8, 0, 0, 85, 48936, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Wisdom');

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

(@NPC, 0, 8, 0, 62, 0, 100, 1, @GOPTION, 9, 0, 0, 85, 20911, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Blessing of Sanctuary');

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

(@NPC, 0, 9, 0, 62, 0, 100, 1, @GOPTION, 10, 0, 0, 85, 48469, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'NPC-Buff-Mark of the Wild');