[Teleporter NPC]

[tdavid123]

kezdö vok az ilyenbe még,azt szeretném kérdezni hogy hova kell ezt betenni?

[DJ]

Nekem segítsetek én módosítottam ezt a teleporter npc-t még egy másik topicból ahonnan kimásoltam és még adtam is hozzá plusz 2 teleport helyet de amikor raknám be a db-be ezt írja ki:

[Err] 1265 - Data truncated for column 'y' at row 1
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91208', '0', '6', '0', '530', '1502.709961', '-4415-419922', '21.551201', '0.000000');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

ezt a teleportert használom:

/* Alliance Vendor Island */
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 Alliance Vendor Islandra', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91201');
DELETE FROM `quest_end_scripts` WHERE `id` = '91201';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91201', '0', '6', '0', '0', '-11830.299805', '1248.369995', '4.012740', '5.034730');

/* Alliance Duel Zone */
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 Alliance Duel Zoneba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91202');
DELETE FROM `quest_end_scripts` WHERE `id` = '91202';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91202', '0', '6', '0', '0', '-4821.613281', '-1155.579468', '502.212250', '3.335226');

/* Barber - Jump Zone */
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 Barber - Jump Zoneba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91203');
DELETE FROM `quest_end_scripts` WHERE `id` = '91203';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91203', '0', '6', '0', '1', '4290.068359', '-6398.651367', '82.337029', '2.815650');

/* Stormwind City */
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 Stormwind City-be', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91204');
DELETE FROM `quest_end_scripts` WHERE `id` = '91204';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91204', '0', '6', '0', '530', '-8886.200195', '574.577026', '92.769897', '0.728850');

/* Horde Vendor Island */
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 Horde Vendor Islandra', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91205');
DELETE FROM `quest_end_scripts` WHERE `id` = '91205';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91205', '0', '6', '0', '1', '-12138.453125', '897.416565', '8.973920', '1.210622');

/* Horde Duel Zone */
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 Horde Duel Zoneba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91206');
DELETE FROM `quest_end_scripts` WHERE `id` = '91206';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91206', '0', '6', '0', '1', '-7403.279297', '-1997.809937', '313.734680', '4.592992');

/* Barber - Jump Zone */
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 Barber - Jump Zoneba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91207');
DELETE FROM `quest_end_scripts` WHERE `id` = '91207';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91207', '0', '6', '0', '0', '4290.068359', '-6398.651367', '82.337029', '2.815650');

/* Orgrimmar */
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 Orgrimmar-ba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91208');
DELETE FROM `quest_end_scripts` WHERE `id` = '91208';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91208', '0', '6', '0', '530', '1502.709961', '-4415-419922', '21.551201', '0.000000');

/* Shattrath City */
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 Shattrat City-be', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91209');
DELETE FROM `quest_end_scripts` WHERE `id` = '91209';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91209', '0', '6', '0', '530', '-1846.849976', '5396.640137', '-12.428200', '2.039000');

/* Gurubashi Arena */
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 Gurubashi Arena-ba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91210');
DELETE FROM `quest_end_scripts` WHERE `id` = '91210';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91210', '0', '6', '0', '0', '-13224.513672', '235.640350', '33.463028', '1.116049');

/* Egyedi Insta */
DELETE FROM `quest_template` WHERE `entry` = '91211';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91210', '3459', '1', '70', '0', '1', 'Teleport Egyedi Instaba', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91210');
DELETE FROM `quest_end_scripts` WHERE `id` = '91211';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91211', '0', '6', '0', '0', '1813.489990', '-4418.580078', '-18.570000', '5.135220');

/* Jump Event */
DELETE FROM `quest_template` WHERE `entry` = '91212';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91210', '3459', '1', '70', '0', '1', 'Teleport Jump Eventre', 'Szeretned a Teleportot?', 'Beszelj a Teleporterrel ujra.', 'Biztos ezt akarod?', '0', '91210');
DELETE FROM `quest_end_scripts` WHERE `id` = '91212';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91212', '0', '6', '0', '0', '-13250.667969', '183.197708', '109.302498', '1.252708')

/* Teleporter */
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', 'Teleporter', 'Hammer WoW', '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_questrelation` (`id`, `quest`) VALUES ('91200', '91211');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '91212');
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');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91211');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '91212');

[Tamass]

MaNGOS-ra tudna valaki?

[Szilárd]

MaNGOS-ra is használható, a creature importot a mostani tdb-re nem is lehet elvégezni, kicsit másabbak lettek az oszlopok.

[Tamass]

#1265 - Data truncated for column 'y' at row 1

[Szilárd]

[Err] 1265 - Data truncated for column 'y' at row 1
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `datalong2`, `x`, `y`, `z`, `o`) VALUES ('91208', '0', '6', '0', '530', '1502.709961', '-4415-419922', '21.551201', '0.000000');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Az

[Szilárd]

Egy

[pityuka88]

Üdv. Az lenne a kérdésem hogy tudna valaki feltenni egy teleporter npc-t amiben benne van orgrimmar durotar silvermoon thunder bluff goldshire nagrand aréna és gurubashi aréna? Ez lenne hordának a porterje alinak pedig stormwind elwynn forest razor hill gurubashi aréna nagrand lenne benne. Erre a 2 porter npcre lenne szükségünk ugyanis már 2ik napja kínlódunk vele hogy megcsináljuk őket de nem engedi betenni a dbbe. Trinitycore2 7276 revisionos emut használunk 3.2.2a-val. Nagyon megköszönném ha valaki tudna linkelni.

[RaZoR93]

több npc teleporter van fent csak használní kéne keresés gombot

[free.run]

nekem ezt ijra: [Err] 1062 - Duplicate entry '91211' for key 1
[Err] INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('91211', '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', '91211');
[Msg] Finished - Unsuccessfully
Lécci help h miért!

[Szilárd]

Azt

[free.run]

[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] 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');
[Msg] Finished - Unsuccessfully most meg ezt irja xĐ

[Action]

[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] 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');
[Msg] Finished - Unsuccessfully most meg ezt irja xĐ

column - oszlop
unknown - ismeretlen
field - mező
list - lista

Remélem ebből rájössz
Egy kis logika és fordítás.

[Szilárd]

Egyébként ezt én nem értem, hogy hogy sikerült kivitelezned... "Unknown column .... "

[yocimc]

[Err] 1054 - Unknown column 'speed' in 'field list'
[Err] 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 ('91500', '23158', '0', '0', '0', "Hitsu", "Teleport Master", '80', '80', '100000', '1000000', '10000', '10000', '50000', '35', '35', '0', '8.00', '1', '3', '2000', '2000', '3000', '0', '7', '500', '505', '500', '500', '500', '500', '100000', '100000');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
tudnátok segíteni? :S akármien NPC-t töltök be mindig ezt írja :S