Register for your free account! | Forgot your password?

You last visited: Today at 05:12

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

 

Need vendoren

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
Exclamation Need vendoren

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



ignor16 is offline  
Old   #2
 
elite*gold: 60
Join Date: Mar 2010
Posts: 233
Received Thanks: 54
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.


Arras is offline  
Old   #3
 
elite*gold: 0
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
Emulator ist Trinity
ignor16 is offline  
Old   #4
 
elite*gold: 2703
Join Date: Jul 2010
Posts: 6,451
Received Thanks: 1,232


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.


°"Crazy"° is offline  
Thanks
1 User
Old   #5
 
elite*gold: 0
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
das ja cool danke
ignor16 is offline  
Old   #6
 
elite*gold: 2703
Join Date: Jul 2010
Posts: 6,451
Received Thanks: 1,232
Kann sein, dass die struktur veraltet ist, da diese aus dem August stammen
°"Crazy"° is offline  
Old   #7
 
elite*gold: 0
Join Date: Dec 2010
Posts: 72
Received Thanks: 6
Nice wieder einer der SQLs klaut und seinen Namen drunter setzt
Minoras is offline  
Thanks
1 User
Old   #8
 
elite*gold: 62
Join Date: Apr 2006
Posts: 12,492
Received Thanks: 2,859
Quote:
Originally Posted by Minoras View Post
Nice 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!
Gordge is offline  
Thanks
1 User
Old   #9
 
elite*gold: 0
Join Date: Dec 2010
Posts: 72
Received Thanks: 6
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

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.
Minoras is offline  
Old   #10
 
elite*gold: 62
Join Date: Apr 2006
Posts: 12,492
Received Thanks: 2,859
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.....
Gordge is offline  
Old   #11
 
elite*gold: 2703
Join Date: Jul 2010
Posts: 6,451
Received Thanks: 1,232
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.
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.
°"Crazy"° is offline  
Old   #12
 
elite*gold: 110
Join Date: Mar 2008
Posts: 1,064
Received Thanks: 180
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...
Bastiao is offline  
Old   #13
 
elite*gold: 0
Join Date: Dec 2010
Posts: 72
Received Thanks: 6
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 =)


Minoras is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Mangos 3.3.5a Vendoren
Hay LEute aknn mir jemand nen Link für Vendoren (Mounts, Waffe usw...) geben? ICh habe im E*pvp nichts gefunden und in Google auch nichts wahres! ...
7 Replies - WoW PServer Hosting
vendoren für mango 0.3.7
hallo weiß einer wo man für den neuen mango server 0.3.7 die vendoren herbekommt? weil man die nicht rein spawmen kann da steht dann das es die nicht...
4 Replies - WoW PServer Hosting
*TuT*Vendoren*TuT*
Hallo , Ich möchte euch jetzt Zeigen wie ihr Vendoren erstellt. 1. Ihr geht auf wow-v.c*m *= o :) 2.Ihr macht euch einen account. 3.Ihr...
2 Replies - WoW PServer Hosting
Ascent - Vendoren (Suche)
Hallo, Habe schon viel durchsucht aber bis jetz noch keine voll funktionstüchtigen Waffen,Rüstungs,Schmuck,Ring Vendoren gefunden... Kann mir...
3 Replies - WoW PServer Hosting



All times are GMT +1. The time now is 05:12.


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.