|
You last visited: Today at 00:22
Advertisement
Need vendoren
Discussion on Need vendoren within the WoW Private Server forum part of the World of Warcraft category.
12/26/2010, 05:35
|
#1
|
elite*gold: 0 
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
|
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 
|
|
|
|
12/26/2010, 09:34
|
#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.
|
|
|
|
|
12/26/2010, 16:57
|
#3
|
elite*gold: 0
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
|
Emulator ist Trinity
|
|
|
|
|
12/26/2010, 17:18
|
#4
|
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
|
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
|
#5
|
elite*gold: 0
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
|
das ja cool danke
|
|
|
|
|
12/26/2010, 17:49
|
#6
|
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
|
Kann sein, dass die struktur veraltet ist, da diese aus dem August stammen
|
|
|
|
|
12/28/2010, 14:37
|
#7
|
elite*gold: 0
Join Date: Dec 2010
Posts: 72
Received Thanks: 6
|
Nice  wieder einer der SQLs klaut und seinen Namen drunter setzt
|
|
|
|
|
12/29/2010, 08:10
|
#8
|
elite*gold: 62
Join Date: Apr 2006
Posts: 12,490
Received Thanks: 2,859
|
Quote:
Originally Posted by Minoras
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!
|
|
|
|
|
12/29/2010, 15:20
|
#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.
|
|
|
|
|
12/30/2010, 07:49
|
#10
|
elite*gold: 62
Join Date: Apr 2006
Posts: 12,490
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.....
|
|
|
|
|
12/30/2010, 10:01
|
#11
|
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
|
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.
|
|
|
|
|
12/30/2010, 11:17
|
#12
|
elite*gold: 110
Join Date: Mar 2008
Posts: 1,066
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...
|
|
|
|
|
12/30/2010, 13:11
|
#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 =)
|
|
|
|
 |
Similar Threads
|
Mangos 3.3.5a Vendoren
09/02/2010 - WoW Private Server - 7 Replies
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!
Wäre echt nett
-Robert :D
|
vendoren für mango 0.3.7
03/15/2010 - WoW Private Server - 4 Replies
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 gibt!! pls damit ich weiter machen kann:handsdown::handsdown::handsdown:
|
*TuT*Vendoren*TuT*
03/03/2010 - WoW Private Server - 2 Replies
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 geht auf Mob/Npc erstellen.
4.Ihr gebt ein :
|
Ascent - Vendoren (Suche)
03/28/2008 - WoW Private Server - 3 Replies
Hallo,
Habe schon viel durchsucht aber bis jetz noch keine voll funktionstüchtigen Waffen,Rüstungs,Schmuck,Ring Vendoren gefunden... Kann mir jemand welche posten pls :)
|
All times are GMT +1. The time now is 00:25.
|
|
