Serifaz Posted January 16, 2015 Share Posted January 16, 2015 So I have been slowly working on a custom forum. I have recently been trying to implement an achievement system. For the most part achievements would work based on the users amount of posts amount of characters in a post amount of replies on a post time past from the users join date. I was hoping to find out how I could put an entry into a database field based on the above. Any help would be greatly appreciated Quote Link to comment https://forums.phpfreaks.com/topic/293997-a-few-questions-reguarding-php-and-sql/ Share on other sites More sharing options...
Barand Posted January 16, 2015 Share Posted January 16, 2015 You wouldn't store any of those items in a database, you should be able to derive them from the existing post data when required. Quote Link to comment https://forums.phpfreaks.com/topic/293997-a-few-questions-reguarding-php-and-sql/#findComment-1503185 Share on other sites More sharing options...
Serifaz Posted January 16, 2015 Author Share Posted January 16, 2015 no I was just going to store the users achievements in the db Quote Link to comment https://forums.phpfreaks.com/topic/293997-a-few-questions-reguarding-php-and-sql/#findComment-1503187 Share on other sites More sharing options...
CroNiX Posted January 16, 2015 Share Posted January 16, 2015 achievement_types (lists all of the various achievement types) -id -name achievements (stores each users achievements) -id -user_id -achievement_type_id Quote Link to comment https://forums.phpfreaks.com/topic/293997-a-few-questions-reguarding-php-and-sql/#findComment-1503188 Share on other sites More sharing options...
Serifaz Posted January 16, 2015 Author Share Posted January 16, 2015 sorry I am not extremely knoweledgeable with php yet. can you possibly give me an example? Quote Link to comment https://forums.phpfreaks.com/topic/293997-a-few-questions-reguarding-php-and-sql/#findComment-1503219 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.