Forum > Serverside Modding

Database development...

<< < (2/2)

Jack:

--- Quote from: "oinquer" ---for one creature im already using 3 tables (and seeing the big list i'd say alot more...).....its not so easy learning....i would say it has some degree of learning....but im just a stupid humanoid....not a gnome or goblin....
--- End quote ---

In the last week I learned the structure of over 20 WoW databases, SQL as well as DBCs. Some of the DBCs are poorly to not at all documented and you have to figure out what's what by comparing the values, changing stuff and seeing what happens. (and no, I DO have a real life and have to learn far more complicated stuff every day)

I definitly agree with schlumpf here, you won't get more documentation than that. There are quite a lot of "hurr durr custom item" tutorials in the web, go have a look at them, maybe that's a start for you.
If you actually sit down for an hour or two, mess with the SQL, try to do some custom item etc then eventually you'll get to know that database structure. Then proceed to the next one etc, maybe small steps is what would be best for you.
(Btw if you just want to create a simple NPC that's 1 SQL and 1 DBC you have to change, npc_vendor simply defines what items which npc sells, in case he IS a vendor, which is stated in the npc template and as long as you don't have any custom displayID (meaning a new model or else) you only have to change that one SQL, not even the DBC)

Navigation

[0] Message Index

[*] Previous page