SET @Entry := NPC_ENTRYT_IRD_IDE;
-- creature_template
DELETE FROM `creature_template` WHERE `entry`=@Entry;
INSERT INTO `world`.`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`,`mechanic_immune_mask`,`flags_extra`,`ScriptName`,`WDBVerified`) VALUES
(@Entry,0,0,0,0,0,31030,0,0,0, 'TEST_SAI', 'TELEPORTER', 'Directions',50000,80,80,2,35,35,1,1,1.14286,0.6,1,0,0,0,0,1,0,0,0,2,0,0,0,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 'SmartAI',0,1,1,1,1,1,0,0,0,0,0,0,0,1,2147483647,0, '',1);
-- creature_text
-- DELETE FROM `world`.`creature_text` WHERE `entry` = '50000' AND `groupid` = '0';
-- DELETE FROM `world`.`creature_text` WHERE `entry` = '50000' AND `groupid` = '1';
INSERT INTO `world`.`creature_text` (`entry`, `groupid`, `text`, `type`, `probability`, `comment`) VALUES ('50000', '0', 'See ya!', '15', '100', 'For Smart AI'),
('50000', '1', 'Teleportation costs 1 Badge of Justice!', '15', '100', 'For Smart AI');
-- gossip_menu
-- DELETE FROM `world`.`gossip_menu` WHERE `entry` = '50000' AND `text_id` = '50000';
INSERT INTO `world`.`gossip_menu` (`entry`, `text_id`) VALUES ('50000', '50000');
-- gossip_menu_option
-- DELETE FROM `world`.`gossip_menu_option` WHERE `menu_id` = '50000' AND `id` = '0';
-- DELETE FROM `world`.`gossip_menu_option` WHERE `menu_id` = '50000' AND `id` = '1';
INSERT INTO `world`.`gossip_menu_option` (`menu_id`, `id`,`option_text`, `option_id`, `npc_option_npcflag`, `box_text`) VALUES
('50000', 0, 'GM Island (1 Badge of Justice)', '1', '1', 'Teleport to GM Island (costs 1 Badge of Justice)'),
('50000', 1, 'GM Island', '1', '1', 'Teleport to GM Island');
-- npc_text
-- DELETE FROM `world`.`npc_text` WHERE `ID`=50000;
INSERT INTO `world`.`npc_text` (`ID`, `text0_0`) VALUES ('50000', 'Where?');
-- smart_scipts
-- DELETE FROM `world`.`smart_scripts` WHERE `entryorguid` = '50000' AND `source_type` = '0' AND `id` = '1' AND `link` = '0';
INSERT INTO `world`.`smart_scripts` (`entryorguid`, `id`, `event_type`, `event_param1`, `event_param2`, `event_param3`,`event_param4`, `event_param5`, `action_type`, `action_param1`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
('50000', '0', '62', '50000', '0', '0', '29434', '1', '62', '1', '16226', '16257', '13', '3.48', 'SCRIPT - Teleport to GM Island (token)'),
('50000', '1', '62', '50000', '1', '0', '0', '0', '62', '1', '16226', '16257', '13', '3.48', 'SCRIPT - Teleport to GM Island');