Calculator but complicated...
Posted: Sat Apr 12, 2008 3:26 pm
FIrst of, Database...
Quest database
questid
questname text
questtype
questdiflvl
questrequire
questskilrequire
questitems text
questreward
questqpreward
questsneedtobecompleted
Member database
userid
mstatus
username
password
emailaddress
Questsdone
userid
questname text
qpoints
questid
If i wanted to add a skills database, where a user needs x amount of skills for questskilrequire if i make a database consisting of the table below how could i make it work so that a user has all the skills set to 1, and they can add them via a site... but each is different for each user.
Then when they view a quest, there are minimum level requirements (questskilrequire) would somehow say that the quests needs to be completed only if your skills are equal or greater than the minimum requirements...
skills
Attack
Strenght
Defence
Hits
Magic
Ranged
Woodcutting
Firemaking
Smithing
Mining
Runecraft
Prayer
Cooking
Fletching
Fishing
Crafting
Herblore
Agility
Theiving
Slayer
Farming
Hunter
Construction
Summoning
Quest database
questid
questname text
questtype
questdiflvl
questrequire
questskilrequire
questitems text
questreward
questqpreward
questsneedtobecompleted
Member database
userid
mstatus
username
password
emailaddress
Questsdone
userid
questname text
qpoints
questid
If i wanted to add a skills database, where a user needs x amount of skills for questskilrequire if i make a database consisting of the table below how could i make it work so that a user has all the skills set to 1, and they can add them via a site... but each is different for each user.
Then when they view a quest, there are minimum level requirements (questskilrequire) would somehow say that the quests needs to be completed only if your skills are equal or greater than the minimum requirements...
skills
Attack
Strenght
Defence
Hits
Magic
Ranged
Woodcutting
Firemaking
Smithing
Mining
Runecraft
Prayer
Cooking
Fletching
Fishing
Crafting
Herblore
Agility
Theiving
Slayer
Farming
Hunter
Construction
Summoning