brokenmech Posted January 31, 2010 Share Posted January 31, 2010 I want to modify my phpmotion site to include a column that will display a users name and a description of their most recent activity. example: Johnny has commented on Alex's video called The Joy of Turnips 5 minutes ago Sasha has posted a new video called This site is cool 3 hours ago Can anyone give me some tips on how this could be done? Link to comment https://forums.phpfreaks.com/topic/190476-recent-activity-column/ Share on other sites More sharing options...
teamatomic Posted January 31, 2010 Share Posted January 31, 2010 add to the users table last_action action_timestamp Make it so everything that a user could do is written to the DB. Decide how long ago is the limit then compare to the action_timestamp. if its after your limit use the user,last_action and action_timestamp. HTH Teamatomic Link to comment https://forums.phpfreaks.com/topic/190476-recent-activity-column/#findComment-1004732 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.