[Marco van Herwaarden]

Originally Posted by HR3rdGen

I was just looking over the xml file and the tables it adds/alters and I think you might be able to add a new search to search for most recently updated profiles.

Or at least search and order by most recent.

Yes this is easily possible.
There are 2 datestamps added to the user table:
- mh_upcd_lastprofilechange: The real last changed timestamp
- mh_upcd_lastprofilelist: The last timestamp this user was put on the list of recent changes. Only updated if the user change his profile after the wait limit has passed since the previous listing. This is done to avoid users changing their profile (or not even really changing) all the time, just to stay on the recent changed list (spamming).

For example, the limit is set to 60 minutes:
00:00 User updates profile. Both timestamps are updated, and he is put in the recent change list.
00:10 User updates his avatar, only mh_upcd_lastprofilechange is updated, and user is not put on the list again
00:55 User update profile again, same as 00:10
01:05 User update Avatar again, waittime has passed, so both are updated again and he is put on the list again.

You can choose yourself which timestamp you want to do a select on if you want to write your own recent changed query, depending if you want the real change time, or the 'anti-spam' time.

You can look up the logic in the plugin on either of the following locations (they are all identical, but didn't want to create an includes/functions_....php file):
- profile_updateavatar_complete
- profile_updateprofile
- profile_updateprofilepic_complete

PS:
On the Member Profile page you will see the real changed time.
For the Latest changes on forumhome, a datastore row is used that is filled whenever the recent list needs to be updated.