Page 1 of 1

Calculator but complicated...

Posted: Sat Apr 12, 2008 3:26 pm
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

Re: Calculator but complicated...

Posted: Mon Apr 14, 2008 5:35 am
by gaogier
can anyone give me advise?

Re: Calculator but complicated...

Posted: Mon Apr 14, 2008 6:38 am
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?

Re: Calculator but complicated...

Posted: Mon Apr 14, 2008 10:14 am
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...

Re: Calculator but complicated...

Posted: Mon Apr 14, 2008 10:18 am
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.

Re: Calculator but complicated...

Posted: Mon Apr 14, 2008 11:53 am
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...

Re: Calculator but complicated...

Posted: Thu Apr 17, 2008 8:53 am
by gaogier
can anyone help?

here is a link to what i have got so far, http://questcalc.runehints.com

Re: Calculator but complicated...

Posted: Thu Apr 17, 2008 9:03 am
by onion2k
Username and password?

Re: Calculator but complicated...

Posted: Fri Apr 18, 2008 10:49 am
by gaogier
user- gaogier
pass - monday

Re: Calculator but complicated...

Posted: Thu Apr 24, 2008 1:12 pm
by gaogier
any ideas?