"Bump" topic on any edit

[SWFans.net]

Is there already a hack that will "bump" a topic to the top if there is an edit to any of the posts by any user? If not, is it possible?

[JTMON]

This would be very nice! I was suprised that vBulletin didn't already do this.

[Admin]

In editpost.php, add this:

  $DB_site->query("UPDATE thread SET lastpost='".time()."' WHERE threadid='$threadinfo[threadid]'");

right before this:

  $DB_site->query("DELETE FROM searchindex WHERE postid=$postid");

Should work.

[SWFans.net]

Goes to test it out

[SWFans.net]

Works like a dream. Thank you FireFly.

[Admin]

No problem.

[SWFans.net]

The only downside to it is that it doesn't adjust the "last posted by" on the index, but that is actually a very minor thing that I can live without.

[Admin]

Yeah, that's how it works.
You could in theory add another field to the thread table, let's say "lastactivity" and order everything by it, but it would be such a headache...

[SWFans.net]

Don't want any of those. I just wanted to let people know its behavior.

[Freddie Bingham]

vBulletin used to do this by default but I changed it as users found it fun to bump posts just be editing them.