[Release]Eigene Stadtwachen

saifi · 08/04/2010, 00:28

Heyho ElitePvPers ich möchte euch nun meine Wachen Releasen

ihr müsst sie halt nur umschreiben die wachen sind genau so wie

die wachen von Orgrimmar, Sturmwind, Dalaran etc.

Code:

-- Hauptmenu
DELETE FROM `npc_text` WHERE `ID` = 50000;
DELETE FROM `gossip_menu` WHERE `entry` = 6000;
REPLACE INTO `npc_text` VALUES ('50000', 'Bitte haltet euch an die Gesetze des Landes, Fremder.$B$BHabt Ihr euch verlaufen? Kann ich euch behilflich sein etwas 
Bestimmtes zu finden?', 'Bitte haltet euch an die Gesetze des Land der Sterne, Fremder.$B$BHabt Ihr euch verlaufen? Kann ich euch behilflich sein etwas Bestimmtes zu 
finden?', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', ''
, '0', '0', '0', '0', '0', '0', '0', '0');
REPLACE INTO `gossip_menu` VALUES ('6000', '50000', '0', '0', '0', '0', '0', '0');

-- Hauptmenu Verzeichniss
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 6000;
INSERT INTO `gossip_menu_option` VALUES (6000, 1, 8, 'Klassenlehrer', 1, 1, 7001, 6001, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 2, 8, 'Berufelehrer', 1, 1, 7002, 6002, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 3, 8, 'Gasthaus', 1, 1, 7003, 6003, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 4, 8, 'Flugmeister', 1, 1, 7004, 6004, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 5, 8, 'Rathaus', 1, 1, 7005, 6005, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 6, 8, 'Bank & Auktionator', 1, 1, 7006, 6006, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 7, 8, 'Reit- und Waffenlehrer', 1, 1, 7007, 6007, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 8, 8, 'Verbesser- und Verzauberungen', 1, 1, 7008, 6008, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 9, 8, 'Glyphen', 1, 1, 7009, 6009, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 10, 8, 'Edelsteine', 1, 1, 7010, 6010, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 11, 8, 'Barbier', 1, 1, 7011, 6011, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 12, 8, 'Waffenhändler', 1, 1, 7012, 6012, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `gossip_menu_option` VALUES (6000, 13, 8, 'Rüstungshändler', 1, 1, 7012, 6012, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0);


-- Untermenü Klassenlehrer
DELETE FROM `gossip_menu` WHERE (`entry`=7001);
DELETE FROM `npc_text` WHERE `ID` = 50001;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7001;
DELETE FROM `points_of_interest` WHERE `entry` = 6001;
REPLACE INTO `gossip_menu` VALUES ('7001', '50001', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50001', 'Alle Lehrer findet Ihr im Magischen Bezirk, ich habe euch die stelle auf eurer Karte Makiert.', 'Alle Lehrer findet Ihr im Magischen Bezirk, ich habe euch die stelle auf eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6001', '-7598.43', '864.95', '7', '99', '0', 'Land der Sterne, Klassenlehrer');

-- Untermenü Berufelehrer
DELETE FROM `gossip_menu` WHERE (`entry`=7002);
DELETE FROM `npc_text` WHERE `ID` = 50002;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7002;
DELETE FROM `points_of_interest` WHERE `entry` = 6002;
INSERT INTO `gossip_menu` VALUES ('7002', '50002', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50002', 'Alle Berufelehrer mit Reagenzien und co. findet Ihr in der Gasse der Experimente. Ich habe Euch die stelle auf Eurer Karte Makiert.', 'Alle Berufelehrer mit Reagenzien und co. findet Ihr in der Gasse der Experimente. Ich habe Euch die stelle auf Eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6001', '-7551.64', '884.37', '7', '99', '0', 'Land der Sterne, Berufe');

-- Untermenü Gasthaus
DELETE FROM `gossip_menu` WHERE (`entry`=7003);
DELETE FROM `npc_text` WHERE `ID` = 50003;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7003;
DELETE FROM `points_of_interest` WHERE `entry` = 6003;
INSERT INTO `gossip_menu` VALUES ('7003', '50003', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50003', 'Das Gasthaus ist gegenüber des Magischen Bezirk. Ich habe Euch die stelle auf Eurer Karte Makiert.', 'Das Gasthaus liegt im Magischen Bezirk. Ich habe Euch die stelle auf Eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6003', '-7455.59', '858.03', '7', '99', '0', 'Land der Sterne, Gasthaus');

-- Untermenü Flugmeister
DELETE FROM `gossip_menu` WHERE (`entry`=7004);
DELETE FROM `npc_text` WHERE `ID` = 50004;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7004;
DELETE FROM `points_of_interest` WHERE `entry` = 6004;
INSERT INTO `gossip_menu` VALUES ('7004', '50004', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50004', 'Den Flugmeister findet ihr neben dem Stall. Ich habe Euch die stelle auf Eurer Karte Makiert.', 'Den Flugmeister findet ihr neben dem Stall. Ich habe Euch die stelle auf Eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6004', '-7583.31', '978.21', '7', '99', '0', 'Land der Sterne, Flugmeister');

-- Untermenü Level Burg
DELETE FROM `gossip_menu` WHERE (`entry`=7005);
DELETE FROM `npc_text` WHERE `ID` = 50005;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7005;
DELETE FROM `points_of_interest` WHERE `entry` = 6005;
INSERT INTO `gossip_menu` VALUES ('7005', '50005', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50005', 'Im Rathaus findet ihr immer wieder Aufgaben mit höhe Belohnungen. Ausserdem werden im Rathaus Ausrüsstungen der Legänderen Art verkauft, die ihr euch aber erst hart verdienen müsst. Ich habe Euch die stelle auf Eurer Karte Makiert.', 'Im Rathaus findet ihr immer wieder Aufgaben mit höhe Belohnungen. Ausserdem werden im Rathaus Ausrüsstungen der Legänderen Art verkauft, die ihr euch aber erst hart verdienen müsst. Ich habe Euch die stelle auf Eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6005', '12891.2', '-6874.83', '7', '99', '0', 'Quel Danas Rathaus');

-- Untermenü Bank & Auktionator
DELETE FROM `gossip_menu` WHERE (`entry`=7006);
DELETE FROM `npc_text` WHERE `ID` = 50006;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7006;
DELETE FROM `points_of_interest` WHERE `entry` = 6006;
INSERT INTO `gossip_menu` VALUES ('7006', '50006', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50006', 'Die Bank und das Auktionhaus befinden sich auf dem Land der Sterne. Ich habe Euch die stelle auf Eurer Karte Makiert.', ' Die Bank und das Auktionhaus befinden sich auf dem Land der Sterne. Ich habe Euch die stelle auf Eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6006', '12771.4', '-6704.15', '7', '99', '0', 'Bank & Auktionator vom Land der Sterne');

-- Untermenü Reit- und Waffenlehrer
DELETE FROM `gossip_menu` WHERE (`entry`=7007);
DELETE FROM `npc_text` WHERE `ID` = 50007;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7007;
DELETE FROM `points_of_interest` WHERE `entry` = 6007;
INSERT INTO `gossip_menu` VALUES ('7007', '50007', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50007', 'EUER TEXT.', 'EUER TEXT WIEDERHOLEN.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6007', '12787', '-6886.77', '7', '99', '0', 'Verzauberungs laden');

-- Untermenü Verbesser- und Verzauberungen
DELETE FROM `gossip_menu` WHERE (`entry`=7008);
DELETE FROM `npc_text` WHERE `ID` = 50008;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7008;
DELETE FROM `points_of_interest` WHERE `entry` = 6008;
INSERT INTO `gossip_menu` VALUES ('7008', '50008', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50008', 'EUER TEXT.', 'EUER TEXT WIEDERHOLEN.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6008', '12787', '-6886.77', '7', '99', '0', 'Verzauberung Laden');

-- Untermenü Glyphen
DELETE FROM `gossip_menu` WHERE (`entry`=7009);
DELETE FROM `npc_text` WHERE `ID` = 50009;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7009;
DELETE FROM `points_of_interest` WHERE `entry` = 6009;
INSERT INTO `gossip_menu` VALUES ('7009', '50009', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50009', 'EUER TEXT.', 'EUER TEXT WIEDERHOLEN.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6009', '12614.8', '-6700.14', '7', '99', '0', 'Glyphenhändler');

-- Untermenü Edelsteine
DELETE FROM `gossip_menu` WHERE (`entry`=7010);
DELETE FROM `npc_text` WHERE `ID` = 50010;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7010;
DELETE FROM `points_of_interest` WHERE `entry` = 6010;
INSERT INTO `gossip_menu` VALUES ('7010', '50010', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50010', 'EUER TEXT.', 'EUER TEXT WIEDERHOLLEN.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6010', '12665.3', '-6631.41', '7', '99', '0', 'Edelsteinhändler ');

-- Untermenü Barbier
DELETE FROM `gossip_menu` WHERE (`entry`=7011);
DELETE FROM `npc_text` WHERE `ID` = 50011;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7011;
DELETE FROM `points_of_interest` WHERE `entry` = 6011;
INSERT INTO `gossip_menu` VALUES ('7011', '50011', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50011', 'Den Barbier findet ihr im ersten Stock überhalb des Gasthauses. Ich habe Euch die stelle auf Eurer Karte Makiert.', 'Den Barbier findet ihr im ersten Stock überhalb des Gasthauses. Ich habe Euch die stelle auf Eurer Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6011', '12824.5', '-7013.47', '7', '99', '0', 'Barbier');

-- Untermenü Waffen Händler
DELETE FROM `gossip_menu` WHERE (`entry`=7012);
DELETE FROM `npc_text` WHERE `ID` = 50012;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7012;
DELETE FROM `points_of_interest` WHERE `entry` = 6012;
INSERT INTO `gossip_menu` VALUES ('7012', '50012', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50012', 'EUER TEXT.', 'Euer Test Wiederholen.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6012', '12824.5', '-7013.47', '7', '99', '0', ' Waffenhändler (2.Stock)');

-- Rüstungshändler
DELETE FROM `gossip_menu` WHERE (`entry`=7013);
DELETE FROM `npc_text` WHERE `ID` = 50013;
DELETE FROM `gossip_menu_option` WHERE `menu_id` = 7013;
DELETE FROM `points_of_interest` WHERE `entry` = 6013;
INSERT INTO `gossip_menu` VALUES ('7013', '50013', '0', '0', '0', '0', '0', '0');
INSERT INTO `npc_text` VALUES ('50013', 'In der Kammer des Millitäres findet ihr Rüstungen, Umhänge, Ringe etc.,
ich habe euch den weg auf der Karte Makiert.', 'In der Kammer des Millitäres findet ihr Rüstungen, Umhänge, Ringe etc. ,ich habe euch den weg auf der Karte Makiert.', '0', '1', '0', '1', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `points_of_interest` VALUES ('6012', '12682', '-6958,47', '7', '99', '0', 'Land Der Sterne, Rüstungshändler (2. Stock)');

Wenn ich jemanden damit geholfen habe bitte ein thanks

das sind meine wachen aus meinem PlayerTreff

ihr müsst die koordinaten etc. umschreiben

Trinity!!