EDIT: da ich noch ne anfrage gehabt habe hier die daten für einen mangos-teleporter vers. 3.2.2a in JEDE hauptstadt + arena + dala + shat
DELETE FROM `quest_template` WHERE `entry` = '99990';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99990', '876', '1', '1', '1101', '136', '1', 'port nach sw', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99990');
DELETE FROM `quest_end_scripts` WHERE `id` = '99990';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99990', '0', '6', '0', '-8833.164063', '479.762543', '112.095619', '0.587327');
DELETE FROM `quest_template` WHERE `entry` = '99901';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99901', '876', '1', '1', '1101', '136', '1', 'port nach if', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99901');
DELETE FROM `quest_end_scripts` WHERE `id` = '99901';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99901', '0', '6', '0', '-4821.613281', '-1155.579468', '502.212250', '3.335226');
DELETE FROM `quest_template` WHERE `entry` = '99902';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99902', '876', '1', '1', '1101', '136', '1', 'port nach darnassus', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99902');
DELETE FROM `quest_end_scripts` WHERE `id` = '99902';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99902', '0', '6', '1', '9947.525391', '2604.150879', '1316.187988', '4.223004');
DELETE FROM `quest_template` WHERE `entry` = '99903';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99903', '876', '1', '1', '1101', '136', '1', 'port nach exodar', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99903');
DELETE FROM `quest_end_scripts` WHERE `id` = '99903';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99903', '0', '6', '530', '-4054.751709', '-11793.398438', '11.113947', '1.515031');
DELETE FROM `quest_template` WHERE `entry` = '99904';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99904', '876', '1', '1', '690', '136', '1', 'port nach orgrimmar', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99904');
DELETE FROM `quest_end_scripts` WHERE `id` = '99904';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99904', '0', '6', '1', '1677.910400', '-4314.788574', '62.500027', '2.669688');
DELETE FROM `quest_template` WHERE `entry` = '99905';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99905', '876', '1', '1', '690', '136', '1', 'port nach donnerfels', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', 'Du bist dir sicher das du teleportiert werden willst?', '0', '99905');
DELETE FROM `quest_end_scripts` WHERE `id` = '99905';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99905', '0', '6', '1', '-1197.183716', '29.270617', '179.754837', '2.966604');
DELETE FROM `quest_template` WHERE `entry` = '99906';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99906', '876', '1', '1', '690', '136', '1', 'port nach unterstadt', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99906');
DELETE FROM `quest_end_scripts` WHERE `id` = '99906';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99906', '0', '6', '0', '1568.478760', '268.519928', '-42.138416', '1.697186');
DELETE FROM `quest_template` WHERE `entry` = '99907';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99907', '876', '1', '1', '690', '136', '1', 'port nach silbermond', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99907');
DELETE FROM `quest_end_scripts` WHERE `id` = '99907';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99907', '0', '6', '530', '9373.077148', '-7166.074219', '11.476312', '5.386526');
DELETE FROM `quest_template` WHERE `entry` = '99908';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99908', '876', '60', '70', '0', '136', '1', 'port nach shattrath', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99908');
DELETE FROM `quest_end_scripts` WHERE `id` = '99908';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99908', '0', '6', '530', '-1879.500977', '5409.461426', '-12.427713', '1.033202');
DELETE FROM `quest_template` WHERE `entry` = '99909';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99909', '876', '1', '70', '0', '136', '1', 'port zur gurubashi arena', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99909');
DELETE FROM `quest_end_scripts` WHERE `id` = '99909';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99909', '0', '6', '0', '-13234.119141', '217.386627', '31.675938', '1.068150');
DELETE FROM `quest_template` WHERE `entry` = '99910';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99910', '876', '1', '70', '0', '136', '1', 'port nach dalaran', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99910');
DELETE FROM `quest_end_scripts` WHERE `id` = '99910';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99910', '0', '6', '571', '5807.82', '645.0798', '647.55', '4.05597');
insert into `creature_template` (`entry`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('999900', '21661', '21661', '21661', '21661', "Teleporter", "Porter", '78', '85', '1000000', '1000000', '10000', '10000', '3000', '35', '35', '2', '8.00', '1.5', '1', '1200', '2000', '2000', '0', '10', '55', '55', '55', '55', '55', '55', '500000', '500000');
DELETE FROM `creature_questrelation` WHERE `id` = '999900';
DELETE FROM `creature_involvedrelation` WHERE `id` = '999900';
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99900');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99901');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99902');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99903');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99904');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99905');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99906');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99907');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99908');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99909');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99910');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99900');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99901');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99902');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99903');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99904');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99905');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99906');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99907');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91208');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91209');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91210');