Calculator but complicated...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Calculator but complicated...

Post by gaogier »

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
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Re: Calculator but complicated...

Post by gaogier »

can anyone give me advise?
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Calculator but complicated...

Post by onion2k »

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?
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Re: Calculator but complicated...

Post by gaogier »

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?
1. Oh, didnt know... thought the post had died...

2. I am not sure, I think i want it stored in a database... but not 100% sure how i could do this...
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Calculator but complicated...

Post by onion2k »

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

Post by gaogier »

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...
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Re: Calculator but complicated...

Post by gaogier »

can anyone help?

here is a link to what i have got so far, http://questcalc.runehints.com
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Calculator but complicated...

Post by onion2k »

Username and password?
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Re: Calculator but complicated...

Post by gaogier »

user- gaogier
pass - monday
gaogier
Forum Contributor
Posts: 391
Joined: Wed Mar 02, 2005 1:02 pm
Location: Portsmouth, UK
Contact:

Re: Calculator but complicated...

Post by gaogier »

any ideas?
Post Reply