mangos 3.2.2a teleporter

01/26/2010 05:19 Mericat#1
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


zu faul dazu ? ^^
okok ^^

dan hier:

link 1

[Only registered and activated users can see links. Click Here To Register...]

link 2

[Only registered and activated users can see links. Click Here To Register...]

link 3

[Only registered and activated users can see links. Click Here To Register...]

link 4

[Only registered and activated users can see links. Click Here To Register...]

link 5

[Only registered and activated users can see links. Click Here To Register...]

thx währ dan nice :D hab mir dafür echt mühe gegeben und bin eig totale anfängerin :)
ich hoffe ich konnte euch helfen <3
MFG eure cindy =)
01/26/2010 14:25 .$am#2
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 :D
01/26/2010 19:10 ~Phoenix~#3
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 ^_^
05/12/2010 23:48 azzarrel#4
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
06/01/2010 12:32 Maxi400#5
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 ??