Mangos Teleport master [No core edits]

[**Sweeny**]

This was posted on UDB community forums (Powered by Invision Power Board) credits go to Derseb
Derseb- Updating it with the latest core format (Tried it, and works perfectly)
This is pretty much just a quest, when you click on him you can teleport to major city's. (can add new locations if needed)
Just run this query through your MySQL GUI i.e. Navicat.

I have made some changes to the orginial script.
Now it works fine for me with Mangos 5441 UDB 342

/* Stormwind Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91201';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91201', '3459', '1', '70', '1101', '1', 'Teleport to Stormwind', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91201');
DELETE FROM `quest_end_scripts` WHERE `id` = '91201';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91201', '0', '6', '', '0', '-8833.164063', '479.762543', '112.095619', '0.587327');

/* Ironforge Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91202';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91202', '3459', '1', '70', '1101', '1', 'Teleport to Ironforge', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91202');
DELETE FROM `quest_end_scripts` WHERE `id` = '91202';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91202', '0', '6', '', '0', '-4821.613281', '-1155.579468', '502.212250', '3.335226');

/* Darnassus Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91203';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91203', '3459', '1', '70', '1101', '1', 'Teleport to Darnassus', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91203');
DELETE FROM `quest_end_scripts` WHERE `id` = '91203';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91203', '0', '6', '', '1', '9947.525391', '2604.150879', '1316.187988', '4.223004');

/* Exodar Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91204';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91204', '3459', '1', '70', '1101', '1', 'Teleport to Exodar', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91204');
DELETE FROM `quest_end_scripts` WHERE `id` = '91204';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91204', '0', '6', '', '530', '-4054.751709', '-11793.398438', '11.113947', '1.515031');

/* Orgrimmar Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91205';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91205', '3459', '1', '70', '690', '1', 'Teleport to Orgrimmar', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91205');
DELETE FROM `quest_end_scripts` WHERE `id` = '91205';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91205', '0', '6', '', '1', '1677.910400', '-4314.788574', '62.500027', '2.669688');

/* Thunder Bluff Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91206';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91206', '3459', '1', '70', '690', '1', 'Teleport to Thunder Bluff', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91206');
DELETE FROM `quest_end_scripts` WHERE `id` = '91206';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91206', '0', '6', '', '1', '-1197.183716', '29.270617', '179.754837', '2.966604');

/* Undercity Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91207';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91207', '3459', '1', '70', '690', '1', 'Teleport to Undercity', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91207');
DELETE FROM `quest_end_scripts` WHERE `id` = '91207';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91207', '0', '6', '', '0', '1568.478760', '268.519928', '-42.138416', '1.697186');

/* Silvermoon Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91208';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91208', '3459', '1', '70', '690', '1', 'Teleport to Silvermoon', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91208');
DELETE FROM `quest_end_scripts` WHERE `id` = '91208';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91208', '0', '6', '', '530', '9373.077148', '-7166.074219', '11.476312', '5.386526');

/* Shattrath Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91209';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91209', '3459', '1', '70', '0', '1', 'Teleport to Shattrath', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91209');
DELETE FROM `quest_end_scripts` WHERE `id` = '91209';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91209', '0', '6', '', '530', '-1879.500977', '5409.461426', '-12.427713', '1.033202');

/* Gurubashi Arena Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '91210';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91210', '3459', '1', '70', '0', '1', 'Teleport to Gurubashi Arena', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91210');
DELETE FROM `quest_end_scripts` WHERE `id` = '91210';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91210', '0', '6', '', '0', '-13234.119141', '217.386627', '31.675938', '1.068150');

/* Teleport Master NPC */
DELETE FROM `creature_template` WHERE `entry` = '91200';
INSERT INTO `creature_template` (`entry`, `modelid_A`, `modelid_H`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `faction_A`, `faction_H`, `npcflag`, `speed`, `mindmg`, `maxdmg`, `attackpower`, `baseattacktime`, `rangeattacktime`, `minrangedmg`, `maxrangedmg`, `type`, `civilian`, `InhabitType`, `RegenHealth`) VALUES ('91200', '15235', '15235', 'Mr. Green', 'Teleport Master', '70', '70', '5000', '5000', '35', '35', '2', '1', '50', '200', '500', '1500', '1500', '50', '100', '7', '1', '3', '1');
DELETE FROM `creature_questrelation` WHERE `id` = '91200';
DELETE FROM `creature_involvedrelation` WHERE `id` = '91200';
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91201');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91202');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91203');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91204');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91205');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91206');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91207');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91208');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91209');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91210');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91201');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91202');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91203');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91204');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91205');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91206');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91207');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91208');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91209');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91210');