teleport slipstream

hi , i have made a custom tele inside of the Vortex pinacle and Throne of the four Winds and all looks the sql codes didnt give any errors was ok but the tele dont show menu , can some one guide me how can i fix please ?

btw i use them in trinity 4.3.4 in the mentioned instances

Throne Of The Four Winds creatures who teleport you between platforms


DELETE FROM creature WHERE id = '47066';

DELETE FROM creature_template WHERE entry = '47066';

INSERT INTO `creature_template` VALUES ('47066', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '55550', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55550';

INSERT INTO `gossip_menu_option` VALUES ('55550', '1', '2', 'West Wind', '1', '1', '55550', '0', '55550', '0', null);

DELETE FROM gossip_scripts WHERE id = '55550';

INSERT INTO `gossip_scripts` VALUES ('55550', '0', '6', '754', '0', '0', '-83', '1020', '199', '0');

DELETE FROM npc_text WHERE id = '47066';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('47066', '$B West Wind!$B', 1);

DELETE FROM gossip_menu WHERE entry = '47066';

INSERT INTO gossip_menu (entry, text_id) VALUES ('47066', '47066');

DELETE FROM smart_scripts WHERE entryorguid = '47066';

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

('47066', 0, 1, 0, 62, 0, 100, 0, '47066', 1, 0, 0, 62, 754, 0, 0, 0, 0, 0, 0, 8, 0, 0, -83, 1020, 199, 0, 'Teleporter script');

DELETE FROM creature_template WHERE entry = '46047';

INSERT INTO `creature_template` VALUES ('46047', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '55550', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55551';

INSERT INTO `gossip_menu_option` VALUES ('55551', '2', '2', 'North Wind', '1', '1', '55551', '0', '55551', '0', null);

DELETE FROM gossip_scripts WHERE id = '55551';

INSERT INTO `gossip_scripts` VALUES ('55551', '0', '6', '754', '0', '0', '188', '813', '198', '3');

DELETE FROM npc_text WHERE id = '46047';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('46047', '$B North Wind!$B', 1);

DELETE FROM gossip_menu WHERE entry = '46047';

INSERT INTO gossip_menu (entry, text_id) VALUES ('46047', '46047');

DELETE FROM smart_scripts WHERE entryorguid = '46047';

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

('46047', 0, 1, 0, 62, 0, 100, 0, '47066', 1, 0, 0, 62, 754, 0, 0, 0, 0, 0, 0, 8, 0, 0, 188, 813, 198, 3, 'Teleporter script');

DELETE FROM creature_template WHERE entry = '46045';

INSERT INTO `creature_template` VALUES ('46045', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '55550', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55552';

INSERT INTO `gossip_menu_option` VALUES ('55552', '3', '2', 'East Wind', '1', '1', '55552', '0', '55552', '0', null);

DELETE FROM gossip_scripts WHERE id = '55552';

INSERT INTO `gossip_scripts` VALUES ('55552', '0', '6', '754', '0', '0', '-52', '577', '198', '1');

DELETE FROM npc_text WHERE id = '46045';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('46045', '$B East Wind!$B', 1);

DELETE FROM gossip_menu WHERE entry = '46045';

INSERT INTO gossip_menu (entry, text_id) VALUES ('46045', '46045');

DELETE FROM smart_scripts WHERE entryorguid = '46045';

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

('46045', 0, 1, 0, 62, 0, 100, 0, '47066', 1, 0, 0, 62, 754, 0, 0, 0, 0, 0, 0, 8, 0, 0, -52, 577, 198, 1, 'Teleporter script');

DELETE FROM creature_template WHERE entry = '46046';

INSERT INTO `creature_template` VALUES ('46046', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '55550', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55553';

INSERT INTO `gossip_menu_option` VALUES ('55553', '4', '2', 'Portal To Exit Entrance', '1', '1', '55553', '0', '55553', '0', null);

DELETE FROM gossip_scripts WHERE id = '55553';

INSERT INTO `gossip_scripts` VALUES ('55553', '0', '6', '754', '0', '0', '-289', '817', '200', '5');

DELETE FROM npc_text WHERE id = '46046';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('46046', '$B Portal To Exit Entrance!$B', 1);

DELETE FROM gossip_menu WHERE entry = '46046';

INSERT INTO gossip_menu (entry, text_id) VALUES ('46046', '46046');

DELETE FROM smart_scripts WHERE entryorguid = '46046';

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

('46046', 0, 1, 0, 62, 0, 100, 0, '47066', 1, 0, 0, 62, 754, 0, 0, 0, 0, 0, 0, 8, 0, 0, -289, 817, 200, 0, 'Teleporter script');

DELETE FROM creature_template WHERE entry = '46044';

INSERT INTO `creature_template` VALUES ('46044', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '55550', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55554';

INSERT INTO `gossip_menu_option` VALUES ('55554', '5', '2', 'Final Boss', '1', '1', '55554', '0', '55554', '0', null);

DELETE FROM gossip_scripts WHERE id = '55554';

INSERT INTO `gossip_scripts` VALUES ('55554', '0', '6', '754', '0', '0', '-108', '840', '192', '5');

DELETE FROM npc_text WHERE id = '46044';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('46044', '$B Final Boss!$B', 1);

DELETE FROM gossip_menu WHERE entry = '46044';

INSERT INTO gossip_menu (entry, text_id) VALUES ('46044', '46044');

DELETE FROM smart_scripts WHERE entryorguid = '46044';

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

('46044', 0, 1, 0, 62, 0, 100, 0, '47066', 1, 0, 0, 62, 754, 0, 0, 0, 0, 0, 0, 8, 0, 0, -108, 840, 192, 5, 'Teleporter script');


Vortex Pinacle creatures who teleport you between platforms


DELETE FROM creature_template WHERE entry = '45455';

INSERT INTO `creature_template` VALUES ('45455', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '60000', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '60000';

INSERT INTO `gossip_menu_option` VALUES ('60000', '1', '2', 'Nimbus Rise', '1', '1', '60000', '0', '60000', '0', '0', null);

DELETE FROM gossip_scripts WHERE id = '60000';

INSERT INTO `gossip_scripts` VALUES ('60000', '0', '6', '657', '0', '0', '-905', '-175', '665', '2');

DELETE FROM npc_text WHERE id = '45455';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('45455', '$B Nimbus Rise!$B', 1);

DELETE FROM gossip_menu WHERE entry = '45455';

INSERT INTO gossip_menu (entry, text_id) VALUES ('45455', '45455');

DELETE FROM smart_scripts WHERE entryorguid = '45455';

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

('45455', 0, 1, 0, 62, 0, 100, 0, '45455', 1, 0, 0, 62, 657, 0, 0, 0, 0, 0, 0, 8, 0, 0, -905, -175, 665, 2, 'Teleporter script');


DELETE FROM creature_template WHERE entry = '54232';

INSERT INTO `creature_template` VALUES ('54232', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '60000', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55556';

INSERT INTO `gossip_menu_option` VALUES ('55556', '1', '2', 'Temple of Asaad', '1', '1', '55556', '0', '55556', '0', '0', null);

DELETE FROM gossip_scripts WHERE id = '55556';

INSERT INTO `gossip_scripts` VALUES ('55556', '0', '6', '657', '0', '0', '-1199', '465', '633', '0');

DELETE FROM npc_text WHERE id = '54232';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('54232', '$B Temple of Asaad!$B', 1);

DELETE FROM gossip_menu WHERE entry = '54232';

INSERT INTO gossip_menu (entry, text_id) VALUES ('54232', '54232');

DELETE FROM smart_scripts WHERE entryorguid = '54232';

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

('54232', 0, 1, 0, 62, 0, 100, 0, '54232', 1, 0, 0, 62, 657, 0, 0, 0, 0, 0, 0, 8, 0, 0, -1199, 465, 633, 0, 'Teleporter script');

DELETE FROM creature_template WHERE entry = '54233';

INSERT INTO `creature_template` VALUES ('54233', '0', '0', '0', '0', '0', '35507', '0', '0', '0', 'Slipstream', '', 'Directions', '60000', '71', '71', '0', '0', '35', '35', '3', '1', '1.14286', '1.25', '1', '0', '0', '0', '0', '1', '0', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '7', '138936390', '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', '1', '1.56', '1.56', '1', '1.56', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '2', '', '1');

DELETE FROM gossip_menu_option WHERE menu_id = '55557';

INSERT INTO `gossip_menu_option` VALUES ('55557', '1', '2', 'Cyclone Summit', '1', '1', '55557', '0', '55557', '0', '0', null);

DELETE FROM gossip_scripts WHERE id = '55557';

INSERT INTO `gossip_scripts` VALUES ('55557', '0', '6', '657', '0', '0', '-336', '15', '628', '5');

DELETE FROM npc_text WHERE id = '54233';

INSERT INTO npc_text (ID, text0_0, em0_1) VALUES('54233', '$B Cyclone Summit!$B', 1);

DELETE FROM gossip_menu WHERE entry = '54233';

INSERT INTO gossip_menu (entry, text_id) VALUES ('54233', '54233');

DELETE FROM smart_scripts WHERE entryorguid = '54233';

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

('54233', 0, 1, 0, 62, 0, 100, 0, '54233', 1, 0, 0, 62, 657, 0, 0, 0, 0, 0, 0, 8, 0, 0, -336, 15, 628, 5, 'Teleporter script');

.thread visible on , maybe the thread was in wrong phase for rest of the members , /emoticons/default_tongue.png

im very patient , im not hurry i can w8 years for a reply so , take your time its ok , i know all have life or dosent have time for this , so when ur ready , who ever you are , please give me a solution why thoose teleports npc dosent work and not showing the menu or something …

see my TeleNPC DB only thread, use that for checking your NPC, also your SQL is insanely hard to read/check, clean it up for reviews please

thanks for reply and becose you say this is insane /emoticons/default_smile.png you mention about your TeleNPC , but yours have houndreats of locations i need with 1 or 4 maxim go locations like how is mine , can you help me with that please ?