Find All Thanked Posts Ordered by Post Date (Descending)

I just made some quick PHP changes so if "userid 2" is selected, all users will appear in the search results:

https://www.unix.com/post_thanks.php?do=findthanks&u=2

Basically, this search will bring all thanked posts by all users ordered by time, from newest to oldest.

Search for Thanked Posts by All Users

Hope this helps.

3 Likes

Good thing, thank you... while you're at it: it seems that in the members modal, "Find all thanked posts by MEMBER (most recent first)" the algorithm doesn't always show the most recent thanks given (i.e. ordered by date desc) if more than one person thanked, but it seems to order by the thank date of the the alphabetically first sorted member's name, so if a second, third etc. thanks comes later it is not recognized.

1 Like

The time of thanks is not saved or stored in the DB, so the posts are ordered based on the time posted.

However I agree it is a good idea to maybe update the post time stamp when the post is thanked.

Or instead maybe add a ""lastthanked" field to the post table?!

How is the "Neo (5 Minutes Ago)" calculated?

1 Like

Will look into ... thanks Rudi.

Good catch!