Database Design Help
Posted: Wed Nov 12, 2008 4:45 pm
Hi everyone
I'm beginning on created a website and need help with the database structure. It's for a MMORPG; the rpg now has an "Achievement System" where if you complete certain criteria you gain that achievement which awards points, usually 10-25, and rarely an item and sometimes two, ie an item and a title before/after your name. The achievements are also grouped, such as a General group, a Classic Group, 1st expansion group ect...
What I want is to put all of the achievements in a database so you can view the criteria of said achievement and then be able to click on one item on the criteria to get more information.
So for instance:
"Well Read" achievement awards 10 points, and an item; the criteria to meet achievement is to read 10 specific books->
"Well Read" - 10 Points, item
Book #1
Book #2
Book #3
Book #4
I've been dabbling in php for lil over a year and consider myself decent, however I'm still lost on database design, so I request an suggestions you might be able to supply.
Basic Idea
Acheivements
Achievement name
Achievement group
Criteria
Points awarded
other reward (if any up to 3 or 4)
possibly a user-rated difficulty rating
I'm beginning on created a website and need help with the database structure. It's for a MMORPG; the rpg now has an "Achievement System" where if you complete certain criteria you gain that achievement which awards points, usually 10-25, and rarely an item and sometimes two, ie an item and a title before/after your name. The achievements are also grouped, such as a General group, a Classic Group, 1st expansion group ect...
What I want is to put all of the achievements in a database so you can view the criteria of said achievement and then be able to click on one item on the criteria to get more information.
So for instance:
"Well Read" achievement awards 10 points, and an item; the criteria to meet achievement is to read 10 specific books->
"Well Read" - 10 Points, item
Book #1
Book #2
Book #3
Book #4
I've been dabbling in php for lil over a year and consider myself decent, however I'm still lost on database design, so I request an suggestions you might be able to supply.
Basic Idea
Acheivements
Achievement name
Achievement group
Criteria
Points awarded
other reward (if any up to 3 or 4)
possibly a user-rated difficulty rating