Code:
SET @BUFFNPC := 993368; ## (Entry ID of the NPC) SET @GOPTION := 60500; SET @GMENU := @GOPTION; SET @GSCRIPT := 60500; SET @NPCTXT := 54006; SET @DISPLAY := 28641; ## (DisplayID of the NPC) SET @NAME := Bernie Buffer; ## (Name of the NPC) SET @SUBNAME:= BuffNPC; ## (Subname of the NPC) SET @REALMNAME:= Project X; ## (Name of the Realm) 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+12; DELETE FROM npc_text WHERE ID=@NPCTXT OR ID=@NPCTXT+1 OR ID=@NPCTXT+2 OR ID=@NPCTXT+3 OR ID=@NPCTXT+4; 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,'@NAME','@SUBNAME','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); ## Menü 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, '|cff00ffffMachtwort: Seelenstärke', 1, 1, @GOPTION, 0, @GSCRIPT, 0, 0, NULL), (@GOPTION, 2, 2, '|cff00ffffGöttlicher Wille', 1, 1, @GOPTION, 0, @GSCRIPT+1, 0, 0, NULL), (@GOPTION, 3, 2, '|cff00ffffSchattenschutz', 1, 1, @GOPTION, 0, @GSCRIPT+2, 0, 0, NULL), (@GOPTION, 4, 2, '|cff00ffffArkane Intelligenz', 1, 1, @GOPTION, 0, @GSCRIPT+3, 0, 0, NULL), (@GOPTION, 5, 2, '|cff00ffffIntelligenz von Dalaran', 1, 1, @GOPTION, 0, @GSCRIPT+4, 0, 0, NULL), (@GOPTION, 6, 2, '|cff00ffffGroßer Segen der Könige', 1, 1, @GOPTION, 0, @GSCRIPT+5, 0, 0, NULL), (@GOPTION, 7, 2, '|cff00ffffGroßer Segen der Macht', 1, 1, @GOPTION, 0, @GSCRIPT+6, 0, 0, NULL), (@GOPTION, 8, 2, '|cff00ffffGroßer Segen der Weisheit', 1, 1, @GOPTION, 0, @GSCRIPT+7, 0, 0, NULL), (@GOPTION, 9, 2, '|cff00ffffGroßer Segen des Refugiums', 1, 1, @GOPTION, 0, @GSCRIPT+8, 0, 0, NULL), (@GOPTION, 10, 2, '|cff00ffffMal der Wildnis', 1, 1, @GOPTION, 0, @GSCRIPT+9, 0, 0, NULL), (@GOPTION, 11, 2, '|cff00ffffDornen', 1, 1, @GOPTION, 0, @GSCRIPT+10, 0, 0, NULL), (@GOPTION, 12, 2, '|cff00ffffWiederbelebungsnachwirkungen entfernen', 1, 1, @GOPTION, 0, @GSCRIPT+11, 0, 0, NULL); ## Text INSERT INTO npc_text (ID, text0_0, em0_1) VALUES (@NPCTXT, '$B |cffff0000@REALMNAME$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), (@GSCRIPT+10, 0, 15, 66068, 3, 0, 0, 0, 0, 0), (@GSCRIPT+11, 0, 14, 15007, 1, 0, 0, 0, 0, 0);