Calculator but complicated...
Moderator: General Moderators
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Calculator but complicated...
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
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Re: Calculator but complicated...
can anyone give me advise?
Re: Calculator but complicated...
Two things.
1. If you bump your post it no longer appears in the "unanswered posts" list so it's less likely people will see it.
2. Would I be right in thinking you have a list of required skills with minimum levels for each quest? How are you storing that data?
1. If you bump your post it no longer appears in the "unanswered posts" list so it's less likely people will see it.
2. Would I be right in thinking you have a list of required skills with minimum levels for each quest? How are you storing that data?
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Re: Calculator but complicated...
1. Oh, didnt know... thought the post had died...onion2k wrote:Two things.
1. If you bump your post it no longer appears in the "unanswered posts" list so it's less likely people will see it.
2. Would I be right in thinking you have a list of required skills with minimum levels for each quest? How are you storing that data?
2. I am not sure, I think i want it stored in a database... but not 100% sure how i could do this...
Re: Calculator but complicated...
Ok. Without mentioning any code, database structures or real data, describe exactly what it is you want to do. The more detail the better.
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Re: Calculator but complicated...
its for a game that has millions of users
you logon, you fill out some the data (skills, your skills from the MMORPG) then you can see what quests you can do. When you complete a quest, you click quest completed.
Some quests need to be done before others, and some require certain skill levels to start the quest.
When you see what quest you can do, it will link it to a walkthrough guide (optional) and then you can click quest complete.
Each quest when complete is worth different points, there are new quests added every month, from all the quests you havent done, there will be a end result page, where you can see all your skills with the added experience points (the more experience points you get, the more levels you gain) The closest thing i have found to what i want, is no where near as good as i want it.
Oh, in the feature, i want it to auto updated via the hiscores... which updates everytime you logout as long as you are in the top million in all skills...
Still confused? Contact me for more info...
you logon, you fill out some the data (skills, your skills from the MMORPG) then you can see what quests you can do. When you complete a quest, you click quest completed.
Some quests need to be done before others, and some require certain skill levels to start the quest.
When you see what quest you can do, it will link it to a walkthrough guide (optional) and then you can click quest complete.
Each quest when complete is worth different points, there are new quests added every month, from all the quests you havent done, there will be a end result page, where you can see all your skills with the added experience points (the more experience points you get, the more levels you gain) The closest thing i have found to what i want, is no where near as good as i want it.
Oh, in the feature, i want it to auto updated via the hiscores... which updates everytime you logout as long as you are in the top million in all skills...
Still confused? Contact me for more info...
Re: Calculator but complicated...
Username and password?
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Re: Calculator but complicated...
user- gaogier
pass - monday
pass - monday
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Re: Calculator but complicated...
any ideas?