perryratcliff Posted January 13, 2011 Share Posted January 13, 2011 Not sure if I can post this here, or if I should go to a mySQL forum but... I'm trying to keep track of my user's "score". Each time they do a certain thing they get a preset amount of points, depending on what they did. The way I see it would be having a table that is joined to the user's ID, and have a column for each task. Then when they do a task the number in that column will go up. Then I will multiply that number by amount the task is worth. I can't just adjust there score because they need to be able to see what they did. So I hope that made sense. And if you know a better way to deal with this please let me know! Link to comment https://forums.phpfreaks.com/topic/224287-help-with-database/ Share on other sites More sharing options...
ttocskcaj Posted January 13, 2011 Share Posted January 13, 2011 What's the question? lol. That's probably the way I'd do it. When they complete a task, retrieve the current score from the db, add the prize to the variable then update it back into the db. And show it on the screen if you want. Link to comment https://forums.phpfreaks.com/topic/224287-help-with-database/#findComment-1158815 Share on other sites More sharing options...
perryratcliff Posted January 13, 2011 Author Share Posted January 13, 2011 Yeah, sorry. I was asking if there was a more 'normal' way of doing this. The one problem I see is I won't be able to say in which order they completed a task. So maybe I need to rethink it... Link to comment https://forums.phpfreaks.com/topic/224287-help-with-database/#findComment-1158817 Share on other sites More sharing options...
ttocskcaj Posted January 13, 2011 Share Posted January 13, 2011 Have a table with username or id (varchar) task_name (varchar) task_stage or task_part (int) task_score (int) Each time they complete a task or part of a quest, whatever you wanna call it, then insert a new row into that table. For example Row1: ttocskcaj kill_orc 1 10 Row2: ttocskcaj kill_orc 1 20 For the task Kill Orc, I have completed 2 stages, and have got 30 points overall. Link to comment https://forums.phpfreaks.com/topic/224287-help-with-database/#findComment-1158827 Share on other sites More sharing options...
revraz Posted January 13, 2011 Share Posted January 13, 2011 If you are asking if you can do addition and multiplication in MySql, then the answer is yes. Link to comment https://forums.phpfreaks.com/topic/224287-help-with-database/#findComment-1158853 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.