Teszt

SET @id :=60000;
SET @spell :=48932; -- Blessing of Might
SET @spell2 :=41983; -- Fel Orc Illusion
SET @spell3 :=48161; -- Power Word: Fortitude
DELETE FROM `gossip_scripts` WHERE `id`=@id;
INSERT INTO `gossip_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
(@id,0,15,@spell,0,0,0,0,0,0),
(@id,0,15,@spell2,0,0,0,0,0,0),
(@id,0,15,@spell3,0,0,0,0,0,0);

DELETE FROM `npc_text` WHERE `id`=@id;
INSERT INTO `npc_text` (`id`,`text0_0`) VALUES (@id,'Teszt');

DELETE FROM `gossip_menu` WHERE `entry`=@id;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES (@id,@id);

SET @gossip :=(SELECT `menu_id` FROM `gossip_menu_option` ORDER BY `menu_id` DESC LIMIT 1)+1;
DELETE FROM `gossip_menu_option` WHERE `menu_id`=(SELECT `menu_id` FROM `gossip_menu_option` ORDER BY `menu_id` DESC LIMIT 1);
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
(@gossip,@gossip,10,'Please buff me!',1,3,0,0,@id,0,0,'Really?');

UPDATE `creature_template` SET `gossip_menu_id`=@gossip,`faction_A`=35,`faction_H`=35,`npcflag`=3 WHERE `entry`=80000;