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 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. 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 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 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? 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
Archived
This topic is now archived and is closed to further replies.