Need vendoren

12/26/2010 05:35 ignor16#1
Hi ich suche fertige vendoren für 3.3.5 pserver.
was ich suche
1.Entchant/Verzauberungen
2.Berufsmaterialien/ Mats
3. Juwelnenhändler-sockel

wäre cool wenn jemand so ein packed hätte bitte um schnelle hilfe danke :)
12/26/2010 09:34 Arras#2
1. Was für ein Emulator benutzt du? Trinity, Mangos usw
2. Wenn du die SuFu benutzt findest du ne gaze Menge an SQL Dateien für alle möglichen händler.
12/26/2010 16:57 ignor16#3
Emulator ist Trinity
12/26/2010 17:18 °"Crazy"°#4
[Only registered and activated users can see links. Click Here To Register...]

Included:
Code:
(799997, 26072, 0, 26072, 0, 'Arena Season 5 Grausam', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (799998, 26072, 0, 26072, 0, 'Arena Season 5 Hasserfüllt', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (799999, 26072, 0, 26072, 0, 'Arena Season 5 Tödlich', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800000, 26072, 0, 26072, 0, 'Arena Season 6', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800001, 26072, 0, 26072, 0, 'Arena Season 7', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800002, 26072, 0, 26072, 0, 'Arena Season 8', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800003, 26072, 0, 26072, 0, 'Arena Season Waffen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800004, 26072, 0, 26072, 0, 'Tier 7 Platte', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800005, 26072, 0, 26072, 0, 'Tier 7/8 Leder', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800006, 26072, 0, 26072, 0, 'Tier 7/8 Schwere Rüstung', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800007, 26072, 0, 26072, 0, 'Tier 7/8 Stoff', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800008, 26072, 0, 26072, 0, 'Tier 8 Platte', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800009, 26072, 0, 26072, 0, 'Tier 9 Allianz 232', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800010, 26072, 0, 26072, 0, 'Tier 9 Allianz 245', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800011, 26072, 0, 26072, 0, 'Tier 9 Allianz 258', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800012, 26072, 0, 26072, 0, 'Allianz Waffen 245', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800013, 26072, 0, 26072, 0, 'Tier 9 Horde 232', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800014, 26072, 0, 26072, 0, 'Tier 9 Horde 245', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800015, 26072, 0, 26072, 0, 'Tier 9 Horde 258', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800016, 26072, 0, 26072, 0, 'Horde Waffen 245', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800017, 26072, 0, 26072, 0, 'Tier 10 Platte', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800018, 26072, 0, 26072, 0, 'Tier 10 Leder', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800019, 26072, 0, 26072, 0, 'Tier 10 Schwere Rüstung', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800020, 26072, 0, 26072, 0, 'Tier 10 Stoff', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800021, 26072, 0, 26072, 0, 'Äschenes Verdikt Rüstmeister', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800022, 26072, 0, 26072, 0, 'Relikte', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800023, 26072, 0, 26072, 0, 'Frostmarkenhändler', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (200024, 26072, 0, 26072, 0, 'Verzauberungen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800025, 26072, 0, 26072, 0, 'Todesritterglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800026, 26072, 0, 26072, 0, 'Druidenglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800027, 26072, 0, 26072, 0, 'Jägerglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800028, 26072, 0, 26072, 0, 'Magierglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800029, 26072, 0, 26072, 0, 'Paladinglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800030, 26072, 0, 26072, 0, 'Priesterglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800031, 26072, 0, 26072, 0, 'Schurkenglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800032, 26072, 0, 26072, 0, 'Schamanenglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800033, 26072, 0, 26072, 0, 'Hexenmeisterglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800034, 26072, 0, 26072, 0, 'Kriegerglyphen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800035, 26072, 0, 26072, 0, 'Metasockel', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800036, 26072, 0, 26072, 0, 'Rote Sockel', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800037, 26072, 0, 26072, 0, 'Blaue Sockel', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800038, 26072, 0, 26072, 0, 'Gelbe Sockel', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800039, 26072, 0, 26072, 0, 'Reittiere', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800040, 26072, 0, 26072, 0, 'Fliegende Reittiere', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800041, 26072, 0, 26072, 0, 'Taschen/Munition', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800042, 26072, 0, 26072, 0, 'Einhandaxt', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800043, 26072, 0, 26072, 0, 'Zweihandaxt', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800044, 26072, 0, 26072, 0, 'Armbrust', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800045, 26072, 0, 26072, 0, 'Schusswaffen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800046, 26072, 0, 26072, 0, 'Einhandstreitkolben', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800047, 26072, 0, 26072, 0, 'Zweihandstreitkolben', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800048, 26072, 0, 26072, 0, 'Stangenwaffen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800049, 26072, 0, 26072, 0, 'Einhandschwert', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800050, 26072, 0, 26072, 0, 'Zweihandschwert', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800051, 26072, 0, 26072, 0, 'Stäbe', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800052, 26072, 0, 26072, 0, 'Faustwaffen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800053, 26072, 0, 26072, 0, 'Dolche', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800054, 26072, 0, 26072, 0, 'Wurfwaffen', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800055, 26072, 0, 26072, 0, 'Crossbows', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800056, 26072, 0, 26072, 0, 'Zauberstab', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800057, 26072, 0, 26072, 0, 'Umhang', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800058, 26072, 0, 26072, 0, 'Schuhe', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800059, 26072, 0, 26072, 0, 'Gürtel', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800060, 26072, 0, 26072, 0, 'Armschiene', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800061, 26072, 0, 26072, 0, 'Schild', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800062, 26072, 0, 26072, 0, 'Relikte', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800063, 26072, 0, 26072, 0, 'Hals', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800064, 26072, 0, 26072, 0, 'Rings', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800065, 26072, 0, 26072, 0, 'Trinkets', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800066, 26072, 0, 26072, 0, 'Offhand', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800067, 26072, 0, 26072, 0, 'Bufffood', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800068, 26072, 0, 26072, 0, 'Reagenzien', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0),
      (800069, 26072, 0, 26072, 0, 'Gifte', 80, 80, 2, 35, 35, 130, 0.77, 1.14, 1, 1, 1, 2, 2000, 1, 1, 1000, 1, 80, 80, 1, 2, 1, 7, 7, 1, 1.02, 1, 1, 1, 0);
Hatte gerade keine Lust, alles rauszukopieren. ;)
12/26/2010 17:44 ignor16#5
das ja cool danke
12/26/2010 17:49 °"Crazy"°#6
Kann sein, dass die struktur veraltet ist, da diese aus dem August stammen
12/28/2010 14:37 Minoras#7
Nice :D wieder einer der SQLs klaut und seinen Namen drunter setzt
12/29/2010 08:10 Gordge#8
Quote:
Originally Posted by Minoras View Post
Nice :D wieder einer der SQLs klaut und seinen Namen drunter setzt
bevor die den Hals so weit aufreist, solltest du mal beweise ranschaffen, in denen du beweisst das die sachen geklaut sind, denn ich kann das auf den tot nicht leiden wenn jemand einen anderen Beschuldigt ohne Beweise zu erbringen!
12/29/2010 15:20 Minoras#9
gerne ich hab n ganzen Repo voll mit meinen sqls -,-'
die einzige veränderungen die der gemacht hat sind die Händler und Waren zusammenzusetzen und n Tippfehler auszubessern.
bitteschön firsch von meinem repo gezogen
[Only registered and activated users can see links. Click Here To Register...]
is zwar alles noch scheiß Codestyle aber naja

EDIT: Hatte den Repo in nem anderen Forum public gestellt kann da leider im Moment keine Screens von machen weil die wegen Updates off sind. Werd ich noch hinzufügen wenns wieder geht.
12/30/2010 07:49 Gordge#10
sorry, aber mal eben schnell uploaden kann ich das auch, sorry das reicht mir so nicht als beweis, weiterhin, wo hat er denn behauptet das das auf seinem Mist bewachsen ist, nächste Frage, hast du irgendwo gesagt, das man es nicht veröffentlichen darf?
wg. dem Hotfile Link, wer sagt das er das bei Hotfile hochgeladen hat?
Wo steht das Du die SQL´s entworfen hast?

Das ist alles etwas wage.....
12/30/2010 10:01 °"Crazy"°#11
Minoras,

um Dein Geflame ein Ende zu setzen, setze ich mal ein Statement zu der SQL hier hin, damit du ruhig schlafen kannst.
Ich habe noch ein paar SQLs, welche ich bei Element Network (war erst WoW - Leiter, dann Personalleiter) entworfen habe. Ich verzichte mit Absicht darauf, meinen Namen drunter zu setzen. Warum? Weil ichs kann. :D
Die Kommentare werden nicht mit in die DB gebatcht und sonst sind SQL's alle sehr schnell und einfach zu schreiben. Da könnte ich Deine nehmen, dein KOmmentar löschen, vill. die ModelID ändern und sagen, dass ich die entworfen habe. Du, als Datenbankspezialist, als welches du Dich ausgibst, musst es natürlich besser wissen. Soll ich nun ein Repo machen und meine FIles da hochladen? Nö, mache ich nicht. AUs dem Grunde nicht, da viele nichtmal wissen, wie man das zieht.

Nun Rege Dich ab, lass andere Leute ihren Kommi drunter setzen und gut ist. Wenn du weißt, dass es deine Arbeit ist, so kannst du stolz auf Dich sein. Sollten andere die SQL's klauen, ist es nicht dein Problem, denn beweisen kannst du nichts.

MfG


Edit: Beweise mir, dass ich die SQL's geklaut habe und nicht andere von mir.
12/30/2010 11:17 Bastiao#12
Mal nur so eben zum Verständnis. Du stellst SQL's zur Verfügung bzw uploadest die und beschwerst dich dann das sie geklaut werden? Ähm ja...
12/30/2010 13:11 Minoras#13
Stand extra dabei dürfen nicht ohne meine Erlaubnis weitergegeben werden. Und wie gesagt die Screens bekommt ihr, wenn des andere Forum wieder online is da dort ja das Erstellungsdatum dabei steht.
Und nachdem das "Datenbankspezialist" so sarkastisch klingt...

Code:
#####################################
#
#  Allianz
#
#####################################

DELETE FROM `creature_template` WHERE `entry`='100000';
INSERT INTO `creature_template` (`entry`,`modelid1`, `name`, `subname`,`gossip_menu_id`, `minlevel`, `maxlevel`,
`faction_A`, `faction_H`, `npcflag`,`rank`, `mindmg`, `maxdmg`,`unit_class`, `unit_flags`, `Health_mod`,
`Mana_mod`,`RegenHealth`, `equipment_id`)
VALUES
('100000', '3167', 'Allianzwache von Acheron', '', '30000', '80', '80', '35', '1078', '1', '1', '1000000', '2000000', '1', '2', '20', '10', '1', '');
# SET FACTION TO 35 For Horde

## GOSSIPS:
DELETE FROM `npc_text` WHERE `ID`='30000';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('30000', 'Hallo $N! Ich zeige dir den Weg durch Acheron! Solltest du Fragen haben, wende dich einfach an einen GM oder melde dich im Forum.',
'Hallo $N! Ich zeige dir den Weg durch Acheron! Solltest du Fragen haben, wende dich einfach an einen GM oder melde dich im Forum.');

DELETE FROM `gossip_menu` WHERE `entry`='30000';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('30000', '30000');

DELETE FROM `gossip_menu_option` WHERE `menu_id`='30000';

# Teleports
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '1', '4', 'Teleports', '1', '1', '30052', '', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='30052';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30052', '1', '4', 'Stormwind', '1', '1', '', '', '20101'),
('30052', '2', '4', 'Eisenschmiede', '1', '1', '', '', '20102'),
('30052', '3', '4', 'Darnassus', '1', '1', '', '', '20103'),
('30052', '4', '4', 'Exodar', '1', '1', '', '', '20104'),
('30052', '5', '4', 'Shattrath', '1', '1', '', '', '20105'),
('30052', '6', '4', 'Dalaran', '1', '1', '', '', '20106'),
('30052', '7', '4', 'Acheron', '1', '1', '', '', '20107'),
('30052', '8', '11', 'zurück', '1', '1', '30000', '', '');
DELETE FROM `gossip_scripts` WHERE `id` BETWEEN '20101' AND '20107';
INSERT INTO `gossip_scripts` (`id`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES
('20101', '6', '0', '-8910.91', '556.19', '93.64', '0.65'),
('20102', '6', '0', '-5011.86', '-845.86', '497.14', '5.42'),
('20103', '6', '1', '9951.86', '2280.74', '1341.4', '1.59'),
('20104', '6', '530', '-3829.71', '-11693.36', '-106.85', '1.86'),
('20105', '6', '530', '-1690.84', '5369.99', '7.5', '2.78'),
('20106', '6', '571', '5804.81', '615.20', '651.16', '1.64'),
('20107', '6', '1', '-8644.83', '-1552.22', '55.80', '5.51');

# Klassenlehrer
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '2', '3', 'Klassenlehrer', '1', '1', '30051', '', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='30051';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30051', '1', '3', 'Schurke', '1', '1', '', '20015', ''),
('30051', '2', '3', 'Jäger', '1', '1', '', '20016', ''),
('30051', '3', '3', 'Krieger', '1', '1', '', '20017', ''),
('30051', '4', '3', 'Schamane', '1', '1', '', '20018', ''),
#('30051', '5', '3', 'Todesritter', '1', '1', '', '20019', ''),
('30051', '6', '3', 'Magier', '1', '1', '', '20020', ''),
('30051', '7', '3', 'Hexenmeister', '1', '1', '', '20021', ''),
('30051', '8', '3', 'Priester', '1', '1', '', '20022', ''),
('30051', '9', '3', 'Paladin', '1', '1', '', '20023', ''),
('30051', '10', '3', 'Druide', '1', '1', '', '20024', ''),
('30051', '11', '11', 'zurück', '1', '1', '30000', '', '');
DELETE FROM `points_of_interest` WHERE `entry` BETWEEN '20015' AND '20024';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20015', '-8671.43', '-1432.88', '7', '99', 'Schurke'),
('20016', '-8713.52', '-1535.12', '7', '99', 'Jäger'),
('20017', '-8671.55', '-1432.95', '7', '99', 'Krieger'),
('20018', '-8645.54', '-1554.39', '7', '99', 'Schamane'),
#('20019', 'x', 'y', '7', '99', 'Todesritter'),
('20020', '-8642.62', '-1549.07', '7', '99', 'Magier'),
('20021', '-8607.08', '-1468.16', '7', '99', 'Hexenmeister'),
('20022', '-8568.14', '-1458.79', '7', '99', 'Priester'),
('20023', '-8658.47', '-1429.01', '7', '99', 'Paladin'),
('20024', '-8639.37', '-1548.40', '7', '99', 'Druide');

# Berufe
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '3', '3', 'Berufslehrer', '1', '1', '30050', '', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='30050';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30050', '1', '3', 'Juwelenschleifen', '1', '1', '', '20001', ''),
('30050', '2', '3', 'Schmiedekunst', '1', '1', '', '20002', ''),
('30050', '3', '3', 'Bergbau', '1', '1', '', '20003', ''),
('30050', '4', '3', 'Ingineurskunst', '1', '1', '', '20004', ''),
('30050', '5', '3', 'Schneider', '1', '1', '', '20005', ''),
('30050', '6', '3', 'Verzauberunskunst', '1', '1', '', '20006', ''),
('30050', '7', '3', 'Kräuterkunde', '1', '1', '', '20007', ''),
('30050', '8', '3', 'Alchemie', '1', '1', '', '20008', ''),
('30050', '9', '3', 'Inschriftenkunde', '1', '1', '', '20009', ''),
('30050', '10', '3', 'Lederverarbeitung', '1', '1', '', '20010', ''),
('30050', '11', '3', 'Kürschner', '1', '1', '', '20011', ''),
('30050', '12', '3', 'Angeln', '1', '1', '', '20012', ''),
('30050', '13', '3', 'Kochkunst', '1', '1', '', '20013', ''),
('30050', '14', '3', 'Erste Hilfe', '1', '1', '', '20014', ''),
('30050', '15', '11', 'zurück', '1', '1', '30000', '', '');
DELETE FROM `points_of_interest` WHERE `entry` BETWEEN '20001' AND '20014';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20001', '-8599.25', '-1503.05', '7', '99', 'Juwelenschleifen'),
('20002', '-8742.96', '-1476.17', '7', '99', 'Schmiedekunst'),
('20003', '-8752.53', '-1472.08', '7', '99', 'Bergbau'),
('20004', '-8756.70', '-1479.76', '7', '99', 'Ingineurskunst'),
('20005', '-8770.72', '-1513.23', '7', '99', 'Schneider'),
('20006', '-8770.45', '-1525.11', '7', '99', 'Verzauberungskunst'),
('20007', '-8616.06', '-1515.31', '7', '99', 'Kräuterkunde'),
('20008', '-8610.84', '-1513.39', '7', '99', 'Alchemie'),
('20009', '-8625.49', '-1515.51', '7', '99', 'Inschriftenkunde'),
('20010', '-8544.36', '-1390.77', '7', '99', 'Lederverarbeitung'),
('20011', '-8544.36', '-1390.77', '7', '99', 'Kürschner'),
('20012', '-8643.12', '-1513.44', '7', '99', 'Angeln'),
('20013', '-8621.61', '-1513.93', '7', '99', 'Kochkunst'),
('20014', '-8618.26', '-1496.15', '7', '99', 'Erste Hilfe');

# Reagenzien & Gifte
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '4', '1', 'Reagenzien & Gifte', '1', '1', '', '20215', '');
DELETE FROM `points_of_interest` WHERE `entry`='20215';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20215', '-8674.54', '-1415.77', '7', '99', 'Reagenzien & Gifte');


# Bank
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '5', '1', 'Bank', '1', '1', '', '20216', '');
DELETE FROM `points_of_interest` WHERE `entry`='20216';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20216', '-8674.54', '-1415.77', '7', '99', 'Bank & Auktionshaus');

# PvP Gebiet
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '6', '9', 'PvP Gebiet', '1', '1', '', '20217', '');
DELETE FROM `points_of_interest` WHERE `entry`='20217';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20217', '-8694.69', '-1334.81', '7', '99', 'PvP Gebiet');

# Arena und Battleground
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '7', '9', 'Arena & Battleground', '1', '1', '', '20218', '');
DELETE FROM `points_of_interest` WHERE `entry`='20218';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20218', '-8578.03', '-1485.75', '7', '99', 'Arena & Battleground');

# Mailbox
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '8', '2', 'Briefkasten', '1', '1', '', '20219', '');
DELETE FROM `points_of_interest` WHERE `entry`='20219';
INSERT INTO .`points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20219', '-8656.38', '-1517.25', '7', '99', 'Briefkasten');

# Gildenbereich
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '9', '8', 'Gildenbereich', '1', '1', '', '20220', '');
DELETE FROM `points_of_interest` WHERE `entry`='20220';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20220', '-8714.69', '-1433.55', '7', '99', 'Gildenbereich');

# Gastwirt
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30000', '10', '6', 'Gastwirt', '1', '1', '', '20221', '');
DELETE FROM `points_of_interest` WHERE `entry`='20221';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('20221', '-8578.03', '-1485.75', '7', '99', 'Gastwirt');

#######################
#### NPC #### TEXT ####
#######################

# Teleports
DELETE FROM `npc_text` WHERE `ID`='30052';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('30052', 'Wohin darf ich dich bringen?',
'Wohin darf ich dich bringen?');

DELETE FROM `gossip_menu` WHERE `entry`='30052';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('30052', '30052');

# Klassenlehrer
DELETE FROM `npc_text` WHERE `ID`='30051';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('30051', 'Welchen Lehrer suchst du, $N?',
'Welchen Lehrer suchst du, N$?');

DELETE FROM `gossip_menu` WHERE `entry`='30051';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('30051', '30051');

# Berufslehrer
DELETE FROM `npc_text` WHERE `ID`='30050';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('30050', 'Welchen Lehrer suchst du, $N?',
'Welchen Lehrer suchst du, N$?');

DELETE FROM `gossip_menu` WHERE `entry`='30050';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('30050', '30050');


###########################################
#
#   HORDE
#
###########################################

DELETE FROM `creature_template` WHERE `entry`='100010';
INSERT INTO `creature_template` (`entry`,`modelid1`, `name`, `subname`,`gossip_menu_id`, `minlevel`, `maxlevel`,
`faction_A`, `faction_H`, `npcflag`,`rank`, `mindmg`, `maxdmg`,`unit_class`, `unit_flags`, `Health_mod`,
`Mana_mod`,`RegenHealth`, `equipment_id`)
VALUES
('100010', '4259', 'Hordewache von Acheron', '', '40000', '80', '80', '85', '85', '1', '1', '1000000', '2000000', '1', '2', '20', '10', '1', '');

## GOSSIPS:
DELETE FROM `npc_text` WHERE `ID`='40000';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('40000', 'Hallo $N! Ich zeige dir den Weg durch Acheron! Solltest du Fragen haben, wende dich einfach an einen GM oder melde dich im Forum.',
 'Hallo $N! Ich zeige dir den Weg durch Acheron! Solltest du Fragen haben, wende dich einfach an einen GM oder melde dich im Forum.');

DELETE FROM `gossip_menu` WHERE `entry`='40000';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('40000', '40000');

DELETE FROM `gossip_menu_option` WHERE `menu_id`='40000';

# Teleports
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '1', '4', 'Teleports', '1', '1', '40052', '', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='40052';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40052', '1', '4', 'Orgrimmar', '1', '1', '', '', '30101'),
('40052', '2', '4', 'Donnerfels', '1', '1', '', '', '30102'),
('40052', '3', '4', 'Unterstadt', '1', '1', '', '', '30103'),
('40052', '4', '4', 'Silbermond', '1', '1', '', '', '30104'),
('40052', '5', '4', 'Shattrath', '1', '1', '', '', '30105'),
('40052', '6', '4', 'Dalaran', '1', '1', '', '', '30106'),
('40052', '7', '4', 'Acheron', '1', '1', '', '', '30107'),
('40052', '8', '11', 'zurück', '1', '1', '40000', '', '');
DELETE FROM `gossip_scripts` WHERE `id` BETWEEN '30101' AND '30107';
INSERT INTO `gossip_scripts` (`id`, `command`, `datalong`, `x`, `y`, `z`, `o`)
VALUES
('30101', '6', '1', '1486.84', '-4415.16', '24.09', '0.11'),
('30102', '6', '1', '-1278.72', '127.22', '131.33', '5.22'),
('30103', '6', '0', '1560.98', '240.36', '-43.1', '0.05'),
('30104', '6', '530', '9361.34', '-7277.76', '14.25', '6.22'),
('30105', '6', '530', '-1690.84', '5369.99', '7.5', '2.78'),
('30106', '6', '571', '5804.81', '615.20', '651.16', '1.64'),
('30107', '6', '1', '-8984.69', '1430.90', '56.50', '0.66');

# Klassenlehrer
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '2', '3', 'Klassenlehrer', '1', '1', '40051', '', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='40051';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40051', '1', '3', 'Schurke', '1', '1', '', '30015', ''),
('40051', '2', '3', 'Jäger', '1', '1', '', '30016', ''),
('40051', '3', '3', 'Krieger', '1', '1', '', '30017', ''),
('40051', '4', '3', 'Schamane', '1', '1', '', '30018', ''),
#('40051', '5', '3', 'Todesritter', '1', '1', '', '30019', ''),
('40051', '6', '3', 'Magier', '1', '1', '', '30020', ''),
('40051', '7', '3', 'Hexenmeister', '1', '1', '', '30021', ''),
('40051', '8', '3', 'Priester', '1', '1', '', '30022', ''),
('40051', '9', '3', 'Paladin', '1', '1', '', '30023', ''),
('40051', '10', '3', 'Druide', '1', '1', '', '30024', ''),
('40051', '11', '11', 'zurück', '1', '1', '40000', '', '');
DELETE FROM `points_of_interest` WHERE `entry` BETWEEN '30015' AND '30024';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30015', '-8909.28', '-1470.70', '7', '99', 'Schurke'),
('30016', '-8952.46', '-1349.48', '7', '99', 'Jäger'),
('30017', '-8924.38', '-1461.26', '7', '99', 'Krieger'),
('30018', '-8964.32', '-1346.39', '7', '99', 'Schamane'),
#('20019', 'x', 'y', '7', '99', 'Todesritter'),
('30020', '-8929.39', '-1465.90', '7', '99', 'Magier'),
('30021', '-8931.61', '-1470.83', '7', '99', 'Hexenmeister'),
('30022', '-8924.93', '-1476.11', '7', '99', 'Priester'),
('30023', '-8962.14', '-1363.65', '7', '99', 'Paladin'),
('30024', '-8957.12', '-1346.63', '7', '99', 'Druide');

# Berufe
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '3', '3', 'Berufslehrer', '1', '1', '40050', '', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='40050';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40050', '1', '3', 'Juwelenschleifen', '1', '1', '', '30001', ''),
('40050', '2', '3', 'Schmiedekunst', '1', '1', '', '30002', ''),
('40050', '3', '3', 'Bergbau', '1', '1', '', '30003', ''),
('40050', '4', '3', 'Ingineurskunst', '1', '1', '', '30004', ''),
('40050', '5', '3', 'Schneider', '1', '1', '', '30005', ''),
('40050', '6', '3', 'Verzauberunskunst', '1', '1', '', '30006', ''),
('40050', '7', '3', 'Kräuterkunde', '1', '1', '', '30007', ''),
('40050', '8', '3', 'Alchemie', '1', '1', '', '30008', ''),
('40050', '9', '3', 'Inschriftenkunde', '1', '1', '', '30009', ''),
('40050', '10', '3', 'Lederverarbeitung', '1', '1', '', '30010', ''),
('40050', '11', '3', 'Kürschner', '1', '1', '', '30011', ''),
('40050', '12', '3', 'Angeln', '1', '1', '', '30012', ''),
('40050', '13', '3', 'Kochkunst', '1', '1', '', '30013', ''),
('40050', '14', '3', 'Erste Hilfe', '1', '1', '', '30014', ''),
('40050', '15', '11', 'zurück', '1', '1', '40000', '', '');
DELETE FROM `points_of_interest` WHERE `entry` BETWEEN '30001' AND '30014';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30001', '-8926.90', '-1472.65', '7', '99', 'Juwelenschleifen'),
('30002', '-8932.63', '-1447.12', '7', '99', 'Schmiedekunst'),
('30003', '-8932.63', '-1447.12', '7', '99', 'Bergbau'),
('30004', '-8927.34', '-1466.80', '7', '99', 'Ingineurskunst'),
('30005', '-8940.19', '-1324.67', '7', '99', 'Schneider'),
('30006', '-8932.20', '-1321.22', '7', '99', 'Verzauberungskunst'),
('30007', '-8914.24', '-1479.48', '7', '99', 'Kräuterkunde'),
('30008', '-8879.95', '-1462.04', '7', '99', 'Alchemie'),
('30009', '-8878.55', '-1464.14', '7', '99', 'Inschriftenkunde'),
('30010', '-8831.87', '-1493.31', '7', '99', 'Lederverarbeitung'),
('30011', '-8831.87', '-1493.31', '7', '99', 'Kürschner'),
('30012', '-8827.94', '-1508.64', '7', '99', 'Angeln'),
('30013', '-8963.10', '-1346.76', '7', '99', 'Kochkunst'),
('30014', '-8839.56', '-1475.61', '7', '99', 'Erste Hilfe');

# Reagenzien & Gifte
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '4', '1', 'Reagenzien & Gifte', '1', '1', '', '30215', '');
DELETE FROM `points_of_interest` WHERE `entry`='30215';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30215', '-8812.51', '-1355.89', '7', '99', 'Reagenzien & Gifte');


# Bank
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '5', '1', 'Bank', '1', '1', '', '30216', '');
DELETE FROM `points_of_interest` WHERE `entry`='30216';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30216', '-8955.52', '-1330.42', '7', '99', 'Bank & Auktionshaus');

# PvP Gebiet
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '6', '9', 'PvP Gebiet', '1', '1', '', '30217', '');
DELETE FROM `points_of_interest` WHERE `entry`='30217';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30217', '-8754.02', '-1321.19', '7', '99', 'PvP Gebiet');

# Arena und Battleground
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '7', '9', 'Arena & Battleground', '1', '1', '', '30218', '');
DELETE FROM `points_of_interest` WHERE `entry`='30218';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30218', '-8892.44', '1277.57', '7', '99', 'Arena & Battleground');

# Mailbox
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '8', '2', 'Briefkasten', '1', '1', '', '30219', '');
DELETE FROM `points_of_interest` WHERE `entry`='30219';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30219', '-8885.17', '1332.84', '7', '99', 'Briefkasten');

# Gildenbereich
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '9', '8', 'Gildenbereich', '1', '1', '', '30220', '');
DELETE FROM `points_of_interest` WHERE `entry`='30220';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30220', '-8965.55', '1375.39', '7', '99', 'Gildenbereich');

# Gastwirt
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40000', '10', '6', 'Gastwirt', '1', '1', '', '30221', '');
DELETE FROM `points_of_interest` WHERE `entry`='30221';
INSERT INTO `points_of_interest` (`entry`, `x`, `y`, `icon`, `flags`, `icon_name`)
VALUES
('30221', '-8800.51', '-1383.48', '7', '99', 'Gastwirt');

#######################
#### NPC #### TEXT ####
#######################

# Teleports
DELETE FROM `npc_text` WHERE `ID`='40052';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('40052', 'Wohin darf ich dich bringen?',
'Wohin darf ich dich bringen?');

DELETE FROM `gossip_menu` WHERE `entry`='40052';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('40052', '40052');

# Klassenlehrer
DELETE FROM `npc_text` WHERE `ID`='40051';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('40051', 'Welchen Lehrer suchst du, $N?',
'Welchen Lehrer suchst du, N$?');

DELETE FROM `gossip_menu` WHERE `entry`='40051';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('40051', '40051');

# Berufslehrer
DELETE FROM `npc_text` WHERE `ID`='40050';
INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`)
VALUES
('40050', 'Welchen Lehrer suchst du, $N?',
'Welchen Lehrer suchst du, N$?');

DELETE FROM `gossip_menu` WHERE `entry`='40050';
INSERT INTO `gossip_menu` (`entry`, `text_id`)
VALUES
('40050', '40050');


##################################################
#
# Teleporter
#
##################################################

DELETE FROM `creature_template` WHERE `entry`='100001';
INSERT INTO `creature_template` (`entry`,`modelid1`, `name`, `subname`,`gossip_menu_id`, `minlevel`, `maxlevel`,
`faction_A`, `faction_H`, `npcflag`,`rank`, `mindmg`, `maxdmg`,`unit_class`, `unit_flags`, `Health_mod`,
`Mana_mod`,`RegenHealth`, `equipment_id`)
VALUES
('100001', '3167', 'Gesandter aus Acheron', '', '30060', '80', '80', '35', '1078', '1', '1', '1000000', '2000000', '1', '2', '20', '10', '1', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='30060';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('30060', '1', '4', 'Stormwind', '1', '1', '', '', '20101'),
('30060', '2', '4', 'Eisenschmiede', '1', '1', '', '', '20102'),
('30060', '3', '4', 'Darnassus', '1', '1', '', '', '20103'),
('30060', '4', '4', 'Exodar', '1', '1', '', '', '20104'),
('30060', '7', '4', 'Acheron', '1', '1', '', '', '20107');

DELETE FROM `creature_template` WHERE `entry`='100011';
INSERT INTO `creature_template` (`entry`,`modelid1`, `name`, `subname`,`gossip_menu_id`, `minlevel`, `maxlevel`,
`faction_A`, `faction_H`, `npcflag`,`rank`, `mindmg`, `maxdmg`,`unit_class`, `unit_flags`, `Health_mod`,
`Mana_mod`,`RegenHealth`, `equipment_id`)
VALUES
('100011', '4259', 'Gesandter von Acheron', '', '40060', '80', '80', '85', '85', '1', '1', '1000000', '2000000', '1', '2', '20', '10', '1', '');
DELETE FROM `gossip_menu_option` WHERE `menu_id`='40060';
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`)
VALUES
('40060', '1', '4', 'Orgrimmar', '1', '1', '', '', '30101'),
('40060', '2', '4', 'Donnerfels', '1', '1', '', '', '30102'),
('40060', '3', '4', 'Unterstadt', '1', '1', '', '', '30103'),
('40060', '4', '4', 'Silbermond', '1', '1', '', '', '30104'),
('40060', '7', '4', 'Acheron', '1', '1', '', '', '30107');

#######################################
#
# FIXXES
#
#######################################

UPDATE `creature_template` SET `flags_extra`='2' WHERE `entry` IN (100000, 100001, 100010, 100011);
UPDATE `creature_template` SET `faction_A`='1078' WHERE `entry`=100000;
Könnt ihr wenig mit Anfangen weil alle Coords in der City verteilt sind =)