PlayerTreff Bauen

Page 2 of 3 1 2 3
04/30/2009 14:47 stoppel#16
Also ich finde, wenn man gar nix von P-Servern versteht sollte man auch nicht damit anfangen.
Sag mal was du schon hast. Dann kann man sich ja mal überlegen wie groß der aufwand wäre, und obs überhaupt nutzt.
04/30/2009 15:52 lpl909090#17
selfmade pt
Selfmade instanzen
kaum bugs
Todesritter geht
Norden + instanzen gehen alle instanzen klappen
nur ein paar quest und skills buggy !
04/30/2009 17:44 Joshii139#18
Quote:
Originally Posted by stoppel View Post
Der letzte Beitrag ist ja noch nicht allzu lang her, und ich hoffe ich bekomme noch eine Antwort. Ich habe ein paar Fehler beim reinbatchen deines NPC's usw. Hier die Meldung:



MfG $toppel
NEED HELP PLS
Die SQL Dateien sind veraltet, oder nicht compatibel mit deiner Version.

[Mangos - Arcemu - ect]
07/17/2009 20:34 Noobdown#19
Quote:
Originally Posted by Blackrier View Post
/* 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', '876', '1', '70', '1', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '1', '70', '0', '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`, `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', '876', '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`, `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', '876', '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`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91210', '0', '6', '0', '-13243', '204.711', '30.87', '0.9');

/* Playertreff Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '9123123';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('9123123', '876', '1', '70', '0', '1', 'Teleport to Playertreff', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '9123123');
DELETE FROM `quest_end_scripts` WHERE `id` = '9123123';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123123', '0', '6', '0', '258', '351', '41.9076', '5');

/* Jump City Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '9123124';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('9123124', '876', '1', '70', '0', '1', 'Teleport to Danger City', 'So you want to teleport?', 'Speak with the Teleport Master again.', '', '0', '9123124');
DELETE FROM `quest_end_scripts` WHERE `id` = '9123124';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123124', '0', '6', '0', '-9450,82', '64,98', '56,07', '3');

/* Fun-City Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '9123125';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('9123125', '876', '1', '70', '0', '1', 'Teleport to Fun City', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '9123125');
DELETE FROM `quest_end_scripts` WHERE `id` = '9123125';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123125', '0', '6', '0', '1684.698', '-5328.58', '73.6232', '5');

/* Fun-Arena Teleport Quest */
DELETE FROM `quest_template` WHERE `entry` = '9123128';
INSERT INTO `quest_template` (`entry`, `ZoneOrSort`, `MinLevel`, `QuestLevel`, `RequiredRaces`, `SpecialFlags`, `Title`, `Details`, `Objectives`, `OfferRewardText`, `PointOpt`, `CompleteScript`) VALUES ('9123128', '876', '1', '70', '0', '1', 'Teleport to Fun Arena', 'So you want to teleport?', 'Speak with the Teleport Master again.', 'Are you sure, you\'re ready to teleport?', '0', '91231285');
DELETE FROM `quest_end_scripts` WHERE `id` = '9123128';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123128', '0', '6', '0', '-470.634827', '-1363.873535', '55.440914', '3.993');

/* 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`, `InhabitType`, `RegenHealth`) VALUES ('91200', '14560', '14560', 'Teleport Master', 'Master of all Teleports', '255', '255', '99999', '99999', '35', '35', '2', '1', '99999', '99999', '5009', '1500', '1500', '50', '100', '7', '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', '9123123');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '9123124');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '9123125');
INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES ('91200', '9123128');
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', '9123123');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '9123124');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '9123125');
INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES ('91200', '9123128');

So sollte es gehen..
Hab es zumindest gerade so auch bei mir reingehauen.. ;)
07/18/2009 13:29 Lemuna#20
Quote:
Originally Posted by stoppel View Post
Also ich finde, wenn man gar nix von P-Servern versteht sollte man auch nicht damit anfangen.
Sag mal was du schon hast. Dann kann man sich ja mal überlegen wie groß der aufwand wäre, und obs überhaupt nutzt.
Du bist lustig, wie soll man dann was über WoW Server lernen wenn man nie damit anfängt?^^
11/28/2009 19:09 Silver43#21
naja wenn ich ein NPC einfügen will von wow-v.com kommt "immer"ein Error kann mir da ma pls helfen?:o Error:

[Err] 1054 - Unknown column 'modelid_A' 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 ('777777', '1000', '1000', '1000', '1000', "Custom", "Vendor", '81', '82', '45000', '50000', '50000', '50000', '45000', '7', '7', '69761', '8.00', '1', '1', '9000', '9000', '4000', '0', '10', '1000', '1000', '1000', '1000', '1000', '1000', '10000000', '10000000');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
12/09/2009 20:13 ds12#22
Wie kann man was in die datenbank einfügen?
12/09/2009 20:55 Gordge#23
navicat?
suchfunktion benutzen?
Stickies lesen?
12/25/2009 15:16 crick42#24
Quote:
Originally Posted by Silver43 View Post
naja wenn ich ein NPC einfügen will von wow-v.com kommt "immer"ein Error kann mir da ma pls helfen?:o Error:

[Err] 1054 - Unknown column 'modelid_A' 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 ('777777', '1000', '1000', '1000', '1000', "Custom", "Vendor", '81', '82', '45000', '50000', '50000', '50000', '45000', '7', '7', '69761', '8.00', '1', '1', '9000', '9000', '4000', '0', '10', '1000', '1000', '1000', '1000', '1000', '1000', '10000000', '10000000');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
du musst einfach modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2` in modelid1`, `modelid2`, `modelid3`, `modelid4` ändern... dann gehts war bei mir genauso, frag mich aber nich wieso^^
12/30/2009 21:21 Mericat#25
hey
es währe toll wenn einer einfach ne
sql datei hochladen würde und link hier postet
ne sql datei zum sofort einbatchen
ne funktionierende !!!
bei mir kommt auch error und ich finde ne funzende sql währe besser dan würde keiner mehr fragen ^-^
12/30/2009 21:52 Mericat#26
[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
12/31/2009 00:06 .$am#27
Du hast eine nicht passende SQL datei bei WoW-V gedownloadet die die du runtergeladen hast ist nit kompartibel mit deiner datenbank(würde ich sagen^^))
12/31/2009 19:40 Mericat#28
ich habe heute um die 200 dinge gebatcht =/ alle erfolgreich
ich habe dan eine der sql genommen die gebatcht wurden
inhalt gelöscht
versucht zu batchen
selber error =/
funzt der teleporter den nicht bei einem mangos server 3.2.2a
01/15/2010 15:11 alexbigking#29
natoll aktuell scheint hier aber nix zu seien hab nen server 3.2.2 und das funkt alles nixm XD
01/25/2010 22:50 Mericat#30
Quote:
Originally Posted by alexbigking View Post
natoll aktuell scheint hier aber nix zu seien hab nen server 3.2.2 und das funkt alles nixm XD
jop... irgentwie scheint keiner mehr was für 3.2.2a machen zu wollen ._.
ich verstehe es nit >_< 3.3.0 server sind ehh meistens verbuggt und für 3.2.2a gibt schon tolle bugfreie dbs aber keiner bemüht sich drum einen portstein/porter/portal oder sonst was zum porten zu machen
alle nur arc 3.2.2a oder 3.3.0

also FALLS jemand weiß wie man für ein 3.2.2a server >>>>>MANGOS<<<<<
einen teleporter / portstein / portal erstellt BITTE schreibt es rein oder meldet euch über icq

591-468-712

MFG cindy
Page 2 of 3 1 2 3