mangos 3.2.2a teleporter

Mericat · 01/26/2010, 05:19

hi leutz

ich habe einen eigenen 3.2.2a mangos teleporter erstellt

die 11 norm ports

sturmwind
eisenschmiede
darnassus
exodar

orgrimmar
unterstadt
donnerfels
silbermond

shattrath
dalaran

und die guru arena

wer will dem kann dies in eine .sql speichern [halt die 11 norm ports]

hier ist das fügt das einfach in ne sql datei ein

Spoiler

zu faul dazu ? ^^
okok ^^

dan hier:

link 1

link 2

link 3

link 4

link 5

thx währ dan nice

hab mir dafür echt mühe gegeben und bin eig totale anfängerin

ich hoffe ich konnte euch helfen <3
MFG eure cindy =)

.$am · 01/26/2010, 14:25

SO als 1 mal^^
noch ein kleines tut wie man den teleporter auf seinen eigenen Teleporter macht zb Id 67777 oder so (ich weiß es zwar aber für die anfänger wäre es hilfreich)

2.Du kannst auch gleich zeigen wie man ein neue Zeile hinzufügt und wie man dies dann einfügt^^

aber eig ein nettes teil

~Phoenix~ · 01/26/2010, 19:10

1. den ich hab aus ner .txt von nem 1klick server und da wars n totalschaden
2. damit gibts entlich n 3.2.2a teleporter also isses finde ich egal das ich die liste eines 3.0.3 server genomm hab x) solange es funzt ^_^

azzarrel · 05/12/2010, 23:48

hab grade für 3.3.3a ausprobiert, geht beinahe einwandfrei wenn man den alten npc code ersetzt, die neuen dbs erkennen speed nichtmehr an

allerdings habe ich einige Feler gefunden

Code:

/* donnerfels */
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', [U][B]'Du bist dir sicher das du teleportiert werden willst?[/B][/U]', '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');

das ist zuviel, mit dem gehts nicht

auch portet er bei race = 0 garnicht

ich hab mir erlaubt ihn etwas zu optimieren, er ist nun 3.3.3 fähig

Code:

/* sturmwind (Allianz) */
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');



/* eisenschmiede (Allianz) */
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');



/* darnassus (Allianz) */
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');



/* exodar (Allianz) */
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');



/* orgrimmar (Horde) */
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');



/* donnerfels (Horde) */
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', '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');



/* uc - unterstadt (Horde) */
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');



/* silbermond (Horde) */
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');



/* shattrath (Horde) */
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', '690', '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');



/* gurubashi arena [bei beutebucht] (Horde) */
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', '690', '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');



/* dalaran (Horde) */
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', '690', '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');




/* shattrath (Allianz) */
DELETE FROM `quest_template` WHERE `entry` = '99915';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, 

`OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99915', '876', '60', '70', '1101', '136', '1', 'port nach shattrath', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99915');
DELETE FROM `quest_end_scripts` WHERE `id` = '99915';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99915', '0', '6', '530', '-1879.500977', '5409.461426', '-12.427713', '1.033202');



/* gurubashi arena [bei beutebucht] (Allianz) */
DELETE FROM `quest_template` WHERE `entry` = '99914';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, 

`OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99914', '876', '1', '70', '1101', '136', '1', 'port zur gurubashi arena', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99914');
DELETE FROM `quest_end_scripts` WHERE `id` = '99914';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99914', '0', '6', '0', '-13234.119141', '217.386627', '31.675938', '1.068150');



/* dalaran (Allianz) */
DELETE FROM `quest_template` WHERE `entry` = '99913';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, 

`OfferRewardText`, `PointOpt`, `CompleteScript`)
VALUES ('99913', '876', '1', '70', '1101', '136', '1', 'port nach dalaran', 'ok auf gehts', 'rede nochmal mit mir', 'du wirst nun geportet', '0', '99913');
DELETE FROM `quest_end_scripts` WHERE `id` = '99913';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES ('99913', '0', '6', '571', '5807.82', '645.0798', '647.55', '4.05597');


/*Westfall (Allianz) */
DELETE FROM `quest_template` WHERE `entry` = '99912';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `QuestFlags`, `SpecialFlags`, `Title`, `Details`, `Objectives`, 





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_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `baseattacktime`, `family`, `type`, `resistance1`, 

`resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `mingold`, `maxgold`)
values ('999907', '27762', '0', '0', '0', "Teleportmeister", "Porter", '80', '80', '10000', '10000', '0', '0', '0', '35', '35', '2', '2.50', '8.00', '1', '0', '0', '0', '100', 

'0', '10', '0', '0', '0', '0', '0', '0', '0', '0');



DELETE FROM `creature_questrelation` WHERE `id` = '999907';
DELETE FROM `creature_involvedrelation` WHERE `id` = '999907';
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99990');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99901');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99902');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99903');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99904');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99905');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99906');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99907');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99908');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99909');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99910');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99911');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99912');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99913');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99914');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999907', '99915');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99990');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99901');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99902');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99903');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99904');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99905');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99906');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99907');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99908');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99909');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99910');  
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99913'); 
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99914'); 
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999907', '99915');

hoffe du hast nix dagegen

Maxi400 · 06/01/2010, 12:32

wie geht des jetzt ich weis garnix ich hab nen npc fertig aber wie soll ich denn machen ?

Könt einer bitte ein video in youtube ode so machen ??