Facebook - Mists of Pandaria
Facebook - Draenor

AbonnentenAbonnenten: 0
LesezeichenLesezeichen: 0
Zugriffe: 43

Full Tables from WoWHead 7.1.0 and xxx

Beitragvon Gerhard Reiss » 29. Dez 2016 01:35

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
Gerhard Reiss
Benutzeravatar
 
Beiträge: 121
Registriert: 02.2014
Geschlecht: nicht angegeben




Forum Statistiken

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast

Optionen

Zurück zu "Sql skripte & C++"


 
cron