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

[influence]

+-----------------------------------------------+
| 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) {
+--------------------------------------------------------------------------+

that dont show for me either on vb 2.2.6 for the postings.php file.

when i search for updateforumcount($threadinfo[forumid]); .. about 4 of them comes up without the invisible part.

any help?

[Boofo]

I just installed this on 2.2.9 but I got an error when I went to update the forum info. This is the error:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT * FROM thread WHERE forumid='10' AND lastposter='Boofo's Babe' AND lastpost='1042060020'
mysql error: You have an error in your SQL syntax near 's Babe' AND lastpost='1042060020'' at line 1

mysql error number: 1064

Date: Thursday 09th of January 2003 09:51:30 PM
Script: http://www.bearfacts2.com/forum/forum/admin/misc.php
Referer: http://www.bearfacts2.com/forum/admin/misc.php

I changed the user name causing this to Boofos Babe without the apostrophe, but it still gives me the error. Can anyone please help me with this as my board is messed up now?

[Boofo]

Ok, I finally got the forum update counters to work by making the last post by someone other than the user with an apostrophe in the name. If they post any last posts in the future, then we are going to run into the problem again. I think it has something to do with adding htmlspecialchars or something like that to the last poster in the hack but I'm not sure where to add that to avoid the db error problem in the future. Can anyone lend a hand on that? Also, I get this error when I click on a last post link from a forum that has only 1 thread and 1 post in it.

No thread specified. If you followed a valid link, please notify the webmaster

It seems if there is more than 1 post in 1 thread, then the link clicks through fine. Anyone have any ideas on how to fix this?

[Boofo]

Originally posted by TECK
it's fixed now. make sure when you download the file, at the top it says version 1.1, not 1.0.
if it says 1.0, clear your browser temp files.

for those of you who want to have a link the the thread itself, instead of going to the last post do this:

open showthread.php and find:

if ($goto=="nextnewest") {

replace it with:

// goto newest thread
if ($goto=="newthread") {
  if (isset($forumid) and $forumid!=0) {
    $foruminfo=verifyid("forum",$forumid,1,1);
    $forumid=$foruminfo['forumid'];

    $forumslist = "";
    $getchildforums=$DB_site->query("SELECT forumid,parentlist FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',$forumid,')>0");
    while ($getchildforum=$DB_site->fetch_array($getchildforums)) {
      if ($getchildforum[forumid]==$forumid) {
        $parentlist=$getchildforum[parentlist];
      }
      $forumslist.=",$getchildforum[forumid]";
    }

    $thread=$DB_site->query_first("SELECT threadid FROM thread WHERE forumid IN (0$forumslist) AND visible=1 AND (sticky=1 OR sticky=0) AND lastpost>='".($foruminfo[lastpost]-30)."' AND open<>10 ORDER BY lastpost DESC LIMIT 1");
    header("Location: showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]");
    exit;
  }
}

if ($goto=="nextnewest") {

your link to the latest thread will become:

<a href="showthread.php?s=$session[sessionhash]&goto=newthread&forumid=$forum[forumid]">$forum[lastthread]</a>

scott, let me know if you found the code acceptable on the .txt file. thanks you.

update: i'm gonna look also in postings.php file, it needs to be also modified. for example if you edit a thread title, it wont update the thread... i will look into it and post the mod here...

floren.

Floren, will the following code do the same thing or do I need to change it to your code above?

open showthread.php and above:

if ($goto=="nextnewest") {
  $thread = verifyid("thread",$threadid,1,1);


add:

// goto newest thread
if ($goto=="newthread") {
  if (isset($forumid) and $forumid!=0) {
    $foruminfo=verifyid("forum",$forumid,1,1);
    $forumid=$foruminfo['forumid'];
    $lastthread=$DB_site->fetch_array($DB_site->query("SELECT threadid FROM post WHERE username='".addslashes($foruminfo[lastposter])."' AND dateline='$foruminfo[lastpost]'"));
    header("Location: showthread.php?s=$session[sessionhash]&threadid=$lastthread[threadid]");
    exit;
  }
}


In the "forumhome_lastpostby" template:

change:

<a href="showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]">$forum[lastthread]</a>


to:

<a href="showthread.php?s=$session[sessionhash]&goto=newthread&forumid=$forum[forumid]" title="Go to first post">$forum[lastthread]</a>

[Boofo]

Is anyone still supporting this hack? I finally got it working ok, but I ran into a problem earlier tonight. I got the

No thread specified. If you followed a valid link, please notify the webmaster

error again while clicking on the last title link on one of the forums on the forumhome. When I ran the update counters for the threads and then the forums, the link was clickable again. Does anyone have any idea what would cause this to happen? The thread in question did have some dashes in the title name, if that means anything.