Aktuelle Zeit: 27. Apr 2017 16:44

Alle Zeiten sind UTC + 1 Stunde [ Sommerzeit ]


Spenden Block 3
Neue Beiträge



Ein neues Thema erstellen Auf das Thema antworten  [ 1 Beitrag ] 
AbonnentenAbonnenten: 0
LesezeichenLesezeichen: 0
Zugriffe: 115

AutorNachricht
 Betreff des Beitrags: Full Tables from WoWHead 7.1.0 and xxx
BeitragVerfasst: 29. Dez 2016 02:35 
Offline
Benutzeravatar

Registriert: 02.2014
Beiträge: 127
Geschlecht: nicht angegeben
Hi
Fully taken from wowhead (all except levels which is taken from wowdb) taken with the program made by me, so that it's according to 7.1.0 columns and different fixes.
Download link for the SQL :
SQL for free

Currently :

creature_template (missing id's + name + levels (!!) + gold)
creature_loot_template
gameobject_loot_template
npc_vendor (!!)
!! WARNING !! regarding creature_template (level) and npc_vendor :

creature_template (level) will break all the mobs that are tagged in wowdb with (??) , made them lvl 200-200 so that they are easyer to see, bosses mostly and some other which have missing lvls, still need to do some more tweaks (checked a few random and wowhead had less npcs with level then wowdb)
npc_vendor will break all the entrys with timer for spawn and extended costs, it will fix most vendors without those 2 tags , like those in feralas / southern barrens. Can't realy be merged with current db unless it's checked manualy at every id, currently some still have honor or ids which don't exist, you can check random. Still needs some tweaks also to highlight the npcs that have extended cost or timer so that they can get changed easyer.
A few pointers regarding the rest :

0 & 1 - It will fix old npc which are no longer in the db, should still be obsolete but it's closer to live, it will add more npcs from wod / legion from what I've checked. There shouldn't be any issues with theese two.
2 - Check warning above.
3 - Should be mostly fine, it will fix gold drop on all the npcs that have gold drop on wowhead. Might be minor issues like npcs without gold but minor.
4 & 5 - Drop it's not 100% accurate expecialy because of quests.
6 - Check warning above.

_________________
Bild


Nach oben
 Profil  
 
Beiträge der letzten Zeit anzeigen:  Sortiere nach  
Ein neues Thema erstellen Auf das Thema antworten  [ 1 Beitrag ] 

Alle Zeiten sind UTC + 1 Stunde [ Sommerzeit ]


Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast


Du darfst keine neuen Themen in diesem Forum erstellen.
Du darfst keine Antworten zu Themen in diesem Forum erstellen.
Du darfst deine Beiträge in diesem Forum nicht ändern.
Du darfst deine Beiträge in diesem Forum nicht löschen.

Suche nach:
Gehe zu:  
cron
© phpBB® Forum Software | phpBB3 Forum von phpBB8.de
» Kontakt & Rechtliches Support / Hilfe Forum Gooof Webdesign Kostenloses Forum Dein Forumo Forum web tracker