Database development...

[oinquer]

Hello everyone,
now that i managed to get a normal Private server running, im starting to customize it for my Lan Party project.

question is...where the hell should i start learning to do database development? cant find any usefull info....in trinity forums the only answer to the topic was...look at database structure in wiki....which is good info but just says what is what...not how to start? etc etc...

[schlumpf]

And what exactly do you want to do? "Where to start?" is kind of a useless question, as the wiki would be a good start. At least seems to me. Also, just looking at the database in a SQL browser would be fine.

[oinquer]

glad you think that way... if i tought that way i wouldnt be Here....
i looked at the wiki database and seen per example...NPC_vendor, which asks for an entry, that is the ID for the creature, that is in listed creature_template, which among a ton of other stuff includes model_id, and so on....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....

thanks for your time...

[schlumpf]

Point is: That's all documentation you get. Also, the schema changes too often to maintain a correct documentation as well as guides.
Best really would be analyzing the database using tools for mySQL. You can get graphs etc easily.
You may also find guides in the MMOwned forums: http://www.mmowned.com/forums/world-of- ... tutorials/

[krispig]

this will help you learn sql syntax.

http://www.w3schools.com/sql/default.asp

[Jack]

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....

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)