[TC] Gossip BuffNPC

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);