Register for your free account! | Forgot your password?

Go Back   elitepvpers > World of Warcraft > WoW Private Server > WoW PServer Hosting
You last visited: Today at 00:56

  • Please register to post and access all features, it's quick, easy and FREE!

 

teleporterskript für mangos 0.3.5

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2010
Posts: 22
Received Thanks: 0
Arrow teleporterskript für mangos 0.3.5

hey liebe Community,
ich habe im Forum nichts (oder nur skripts die nicht zu meiner Version passen)
gefunden. Deshalb hab ich mir gedacht frag ich einfach mal hier
Also ich suche ein skript oder eine Anleitung für einen Teleporter mit standartports (hauptstädte, pvparenen usw...) und benutze
Navicat 8 Portable, habe die Datenbank von Novos 1Click server v0.3.5

hoffe auf Antworten.


mfg 200designer



200designer is offline  
Old   #2
 
elite*gold: 0
Join Date: Jan 2010
Posts: 55
Received Thanks: 15
helf mir mal auf die sprünge ^_^ welche version ist 0.3.5 ?
also welche WoW version


~Phoenix~ is offline  
Old   #3
 
elite*gold: 0
Join Date: Jan 2010
Posts: 22
Received Thanks: 0
Quote:
Originally Posted by ~Phoenix~ View Post
helf mir mal auf die sprünge ^_^ welche version ist 0.3.5 ?
also welche WoW version
Novos easy mangos 0.3.5 ist wow patch 3.2.2a
200designer is offline  
Old   #4
 
elite*gold: 0
Join Date: Jan 2010
Posts: 55
Received Thanks: 15
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');


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');


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');


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');


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');


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', 'Du bist dir sicher das du teleportiert werden willst?', '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');


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');


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');


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', '0', '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');


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', '0', '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');


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', '0', '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');


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 ('999900', '21661', '21661', '21661', '21661', "Teleporter", "Porter", '78', '85', '1000000', '1000000', '10000', '10000', '3000', '35', '35', '2', '8.00', '1.5', '1', '1200', '2000', '2000', '0', '10', '55', '55', '55', '55', '55', '55', '500000', '500000');



DELETE FROM `creature_questrelation` WHERE `id` = '999900';
DELETE FROM `creature_involvedrelation` WHERE `id` = '999900';
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99900');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99901');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99902');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99903');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99904');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99905');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99906');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99907');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99908');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99909');
INSERT INTO `creature_questrelation` (`id`, `quest`)
VALUES ('999900', '99910');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99900');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99901');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99902');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99903');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99904');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99905');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99906');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '99907');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91208');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91209');
INSERT INTO `creature_involvedrelation` (`id`, `quest`)
VALUES ('999900', '91210');




viel spaß =)


~Phoenix~ is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Jan 2010
Posts: 22
Received Thanks: 0
ERROR 1136 : Column count doesn't match value count at row 1
Query OK, 1 row affected

ERROR 1054 : Unknown column 'modelid_A' in 'field list'
Query OK, 11 rows affected


geht wieder nicht, wie so viele scripts die ich schon ausprobiert habe -.-
trozdem danke
200designer is offline  
Old   #6
 
elite*gold: 0
Join Date: Jan 2010
Posts: 22
Received Thanks: 0
Quote:
Originally Posted by 200designer View Post
ERROR 1136 : Column count doesn't match value count at row 1
Query OK, 1 row affected

ERROR 1054 : Unknown column 'modelid_A' in 'field list'
Query OK, 11 rows affected


geht wieder nicht, wie so viele scripts die ich schon ausprobiert habe -.-
trozdem danke
ok das einbatchen der quests klappt bloß den NPC will er nicht haben Oo
an was könnte das liegen? hier die Fehlermeldung und der Code:

Quote:

[Err] 1054 - Unknown column 'modelid_A' in 'field list'

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 ('999900', '21661', '21661', '21661', '21661', "Teleporter", "Porter", '78', '85', '1000000', '1000000', '10000', '10000', '3000', '35', '35', '2', '8.00', '1.5', '1', '1200', '2000', '2000', '0', '10', '55', '55', '55', '55', '55', '55', '500000', '500000');


200designer is offline  
Reply

Tags
0.3.5, mangos, mysql, novos, teleporter



« Previous Thread | Next Thread »

Similar Threads
Suche: Mangos 2.4.3 Fun DB Frage: Mangos Web
Hallo liebe Elitepvpers Und zwar suche ich eine mangos 2.4.3 Fun Database auf der man alles kaufen kann und dann halt nur noch pvp und so macht...
0 Replies - WoW Private Server
Mangos 3.3.3
Hey Leuts, Ich hab ein Problem nähmlich ich habe Mangos von 3.3.2 auf 3.3.3 raugepatch und alles gemacht Server startet ohne Probs usw.! Aber wenn...
3 Replies - WoW Private Server
MaNGOS Webcms? WoW MaNGOS GM Hilfe? Wachen?
Also wie im Titel zu sehen ist suche ich ein MaNGOS webcms, eine MaNGOS GM Hilfe und ich möchte wissen wie ich den Wachen einen Hilfe text geben kann...
5 Replies - WoW Private Server
Mangos Webseite und weitere Fragen rund um Mangos und WoW
Fragen: Also ich suche hier eigentlich eher die "Fachmänner" für Mangos, weil ich einige fachliche Fragen habe, die man als Anfänger oder...
0 Replies - WoW Ask the Experts
TBC Mangos 2.0.12 TuT
Ja ich weiß gibt schon ein TBC TuT, allerding gehen dort z.b. Inis nicht weswegen ich schon mehrere Fragen bekommen habe per PM sowie hier im Forum...
70 Replies - WoW PServer Hosting



All times are GMT +1. The time now is 00:56.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.