Last post on forum home, working version

I had tried a version suggested by someone else instead of my own and well, all it did was send the load average up by about 10 times what it was.

This version inserts the last title into the forum database when it is updating the last post name and time. There is no difference in loading time as everything is called normally by vBulletin.

This works on 2.0.x and 2.2.x

Updated at 11:34 GMT on 28th September 2002

Thanks to floren for the latest update.

[CtrlAltDel]

its the newreply code i think
as the newpost code works fine

[CtrlAltDel]

hmm seemed to have fixed it
musta missed a line

[Sue]

+-----------------------------------------------+
| File: FORUM/postings.php (1 change)           |
+-----------------------------------------------+
| 1. Find this code:
+--------------------------------------------------------------------------+
  updateforumcount($threadinfo[forumid]);

  if ($visible) {
+--------------------------------------------------------------------------+
|
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
  updateforumcount($threadinfo[forumid]);

  $lastpost=$DB_site->query_first("SELECT * FROM forum WHERE forumid='$threadinfo[forumid]'");
  if($lastpost['lastpost']==$threadinfo['dateline']) {
    $DB_site->query("UPDATE forum SET lastthread='".addslashes(htmlspecialchars($title))."' WHERE forumid='$threadinfo[forumid]'");
  }

  if ($visible) {
+--------------------------------------------------------------------------+

I don't have the " if ($visible) {" anywhere underneath any of the "updateforumcount($threadinfo[forumid]);" in the file...

[M.C.]

sorry, may be you already talk about, but... how to add lastthread icon for that hack on forumhome?

thanx

[Mr. X]

^check back a few pages.

I read quickly through each page, but didnt see what I was looking for, at least not quite.

I have a forum where almost every thread has a cuss word in the title. The forum can only be read and posted in for registered users, logged out/unreg users still see the forum in question listed on the index, but when they enter, they wont be able to see any threads.

This hack works great on 2.2.9, have it working on my test installation on my workstation, however I'd really like to know if its possible, to disable the last post for this one forum I have? I know I can change permissions to make it invisible to unregistered users, but I dont want to do that, since the forum still needs to appear in the index. Thanks!

[N9ne]

Has anyone figured out how to update the title on forumhome when the thread's title is edited?

[N9ne]

...Hmm...ok I just looked in the instructions once again and found this:

lastthread

That's the row that's created in a table in the DB....

My guess is...upon editing a thread, the change is entered somewhere, but the code isn't calling it?

[M.C.]

N9ne, use "Update Counters" in your AdminCP

Mr. X, please, can you give me link to message, couse i have not time to search.... please!

[N9ne]

M.C.: I could use update counters, but that would mean everytime someone edits a thread's title, I would have to update counters...not practical.

[Highlander]

hi there.. i just got a little error on my site: http://www.spieleplanet.org/forum

look on the main boards "Spieleplanet Communizty .. there it shows 2x times the last threads.. but only in this forums.. on all others its okay.. please give me an idea!?

thx