PlayerTreff Bauen

[tatakiller]

Hallo Erstmal also ich möchte euch erklären wie ihr am besten einen Playertreff macht.

Das Wichtigste ist ihr brauch NAVICAT.(Novo hat einen Link dafür post komm in Tagen muss ihn raus suchen)

1.Schritt ist erstmal einen Platz zu suchen igal wo haubtsache er hat viel Platz

2.Die Ids für GameObject oder sonstige sachen eigentlich gibtes dafür listen hir is eine von Etherian.(Sehr Sehr Gut Gemacht)


3.NPC Erstellen dafür gibtes eine Gute Seite. Da kann man Vendoren, Items und sonstige sachen erstellen . (Schlecht is ihr müsst euch Regen)

4.Alles Speichern und Saven. Die GameObject kann man mit der id z.b .gobject spawn 48921 (<1>) die 1 ist wichtig um das Gameobject zu Speichern.

Das war es erstmal es kommt noch was dazu also alle neulinge und anfänger vieleicht Hilft euch das weiter.







Die Rechtschreibfehler hab ich EXTRA gemacht.

[Gordge]

öhm.... einwenig.... kurz.... da fehlen jetzt irgendwie erklärungen, wie komme ich dahin (portstein, portal mit erklärung wie man die macht). Beispiel gebiete die sich anbieten usw.....

[Ediso]

jo die is mir auch zu kurz als ich hätte es sogar länger ausdrücken könenn was was bedeutet bei wow-v und so^^ mein ultrakleines tut (xD):

♦macht mir einen account auf euren server mit admin rechten und ich "zauber" euch ein gt

[Babacik]

Ich finde auch das es zu kurz ist ;( versteht man garnicht

[Obilee]

rofl holy **** wie soll ein neuling daimt was anfangen können

[Vicious26]

^^

[Blackrier]

ok, vllt is das mein einziger post aber ich musste das jetzt klar stellen^^

wie man einen playertreff baut.(auf Basis von Mangos Befehlen)

1.schritt: ort

ich habe einen playertreff unter der Kuppel von Dalaran gebaut.
-> .tele Dalaran

2.schritt: npcs
am besten besorgt ihr euch alle spawn ids von den npcs auf der gm insel.
->tele gmisland und dann bei jedem vendor .npcinfo und die retry aufschreiben

3.schritt: einen port basteln
ich gebe euch jetzt hier einen kompletten port npc der VON MIR selbst gescriptet wurde, ihr müsst den folgenden inhalt in eine sql datei(besorgt sie euch von wow-v)einfügen und die datei in die db batchen. der port Playertreff ist in meinem Script Dalaran, in goldhain hab ich en jump event gebaut, im arathihochland ne arena und in tyrs hand noch en pt.

/* 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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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.', 'ganz oben erwartet dich eine überraschung beim vendor-schau mal auf seite 2 seiner liste.', '0', '9123124');
DELETE FROM `quest_end_scripts` WHERE `id` = '9123124';
INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `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`, `datatext`, `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`, `datatext`, `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`, `civilian`, `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', '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', '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');

da wir alle wissen wie man die kreatur spawnt(mit .addspw 91200...) gehen wir über nach schritt 4.

schritt 4: architektur

so leute jetzt könnt ihr euch richtig austoben!
gestalltet euren playertreff so wie ihr es wollt. ich habe eine Rennstrecke gebaut und einen NPC der euch automatisch verwandelt und schneller macht( mal x3).

ihr könnt für Tribünen Tische nehmen und und und.

sollte es noch Fragen geben, dann konataktiert mich bitte unter

[KratosSs]

Ich Hab ne PSDB x13 und dein Teleport npc geht nicht als unerfolgreich reingebatcht.

[Gordge]

Fehlermeldung?

[Lemuna]

Ist schon ein Kreuz gell chris, mach das mit der Fehlermeldung mal in deine Sig xD

Und ja das erste Tut ist kurz, verdammt kurz^^

[RuSSe1111111]

hi mal ne frage

welche ip hat das portal nach arathiehochland
wäre nett wen ihr es mir beantworten würdet



mfg RuSSe

[Gordge]

Du meinst das grosse Tor? stell dich davor und les die ID aus?!

[Joshii139]

In welche DB muss ich das batchen, bzw wie mache Ich das genau ?

[stoppel]

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:

[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');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91202', '0', '6', '', '0', '-4821.613281', '-1155.579468', '502.212250', '3.335226');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91203', '0', '6', '', '1', '9947.525391', '2604.150879', '1316.187988', '4.223004');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91204', '0', '6', '', '530', '-4054.751709', '-11793.398438', '11.113947', '1.515031');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91205', '0', '6', '', '1', '1677.910400', '-4314.788574', '62.500027', '2.669688');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91206', '0', '6', '', '1', '-1197.183716', '29.270617', '179.754837', '2.966604');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91207', '0', '6', '', '0', '1568.478760', '268.519928', '-42.138416', '1.697186');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91208', '0', '6', '', '530', '9373.077148', '-7166.074219', '11.476312', '5.386526');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91209', '0', '6', '', '530', '-1879.500977', '5409.461426', '-12.427713', '1.033202');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('91210', '0', '6', '', '0', '-13243', '204.711', '30.87', '0.9');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123123', '0', '6', '', '0', '258', '351', '41.9076', '5');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123124', '0', '6', '', '0', '-9450,82', '64,98', '56,07', '3');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123125', '0', '6', '', '0', '1684.698', '-5328.58', '73.6232', '5');
[Err] 1054 - Unknown column 'datatext' in 'field list'
[Err] INSERT INTO `quest_end_scripts` (`id`, `delay`, `command`, `datatext`, `datalong`, `x`, `y`, `z`, `o`) VALUES ('9123128', '0', '6', '', '0', '-470.634827', '-1363.873535', '55.440914', '3.993');
[Err] 1054 - Unknown column 'civilian' in 'field list'
[Err] 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', '14560', '14560', 'Teleport Master', 'Master of all Teleports', '255', '255', '99999', '99999', '35', '35', '2', '1', '99999', '99999', '5009', '1500', '1500', '50', '100', '7', '1', '3', '1');
[Msg] Finished - Unsuccessfully

MfG $toppel
NEED HELP PLS

[lpl909090]

würde sich vllt jemand bereiterklären einem noob wie mmir ein guten server zu erstellen
also mir helfen vllt bitte
den ich bin njeu impserver geschäft
Suche dringend hilfe!
icq 350461566
msn
skype xx_waldi_xx