Edited posts to show in Recent.php

Started by bedges, August 08, 2009, 02:46:00 PM

Previous topic - Next topic

bedges

SMF 1.1.10, double post stopper, slightly modified default theme.

I've searched the forum and the modifications section and nothing like this seems to have been done by anyone else.

I've had a request for post edits to show in the Recent Unread Topics/Updated Topics lists. I've traced the lists to Recent.php, but I'm none too confident about modifying the SQL in there.

Can someone point me in the right direction?

Kill Em All



My Site: KEAGaming.com

Manual Installation of Mods
Prevent Spam and Forum Attacks
Please do not PM or email me for support unless offered, help should be publicly displayed to others.

Arantor

The question is about having it so that edited posts are treated as new for the purposes of the recent list.

The problem with doing it is that the edited time is separate to the posted time. What you might be worth doing is modifying Post.php, and in the insert query, adding the timestamp to the edited time column as well as the primary column, then modify the query in Recent.php to order on the edited time in the messages table, not the original post time.
Holder of controversial views, all of which my own.


bedges

@Arantor - understood, thanks for the pointer.

Arantor

I'm actually tempted to write that as a mod, to be honest. I think it might help all around, though that does raise other questions, since in my mind at least if you edit a post you would also want it to be considered unread as well?
Holder of controversial views, all of which my own.


Advertisement: