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.

[Webmasta XT]

Originally posted by Austin Dea
It works fine, but I can't restrict the length so it's messing my tables up.

Can anyone help out there? Restricting the Length of the title?? so it doesn't mess up the tables! :dead:

[Webmasta XT]

works perfect on vb2.2.6

[Webmasta XT]

ok, here..

my problem was resolved!

Find this bit of code in index.php

PHP Code:

$forum['lasttitle'] = substr($forum['lasttitle'], 0, 28); 


the 28 is the number of characters it can display on the title just change that to whatever you want, i changed mine to 15.

[Baptizer]

HMMMM....i think i might have found what i did wrong. I never ran the mysql command:
ALTER TABLE `forum` ADD `lasttitle` VARCHAR(100) NOT NULL AFTER `lastposter`

If i didnt run that commmand what problems should i expect? SO far, when i move a post/or delete a post, it still shows that post title as the recent post. Is this a problem due to not running that command?

[rodsterAce]

VB Portal users: If anyone is intrested I found a way to hide the last post topic titles from private forums using the list of excluded forums in the vbp config file. It works on the forums and index page. email me

[king98]

I am using vb 2.2.5 . it works but only if I delete the last post of the forum (This mean the last titles are updated manually)!. Any one faced such a problem ?
btw, I mad the modifications through the browser, should this be the reason ?

[Baptizer]

I have the same problem...i beleive this code does not support deletions. So if you delete/move something, it will be screwed up for a bit until someone replies/posts a new topic.

[TECK]

i'm posting the new updated version for 2.2.7 in about 15min...

[TECK]

Ok, these are the new updated file instructions to install PPN's hack onto VB227...
Now you have the VB3 style onto your VB227.

PPN, I hope you dont mind i did this update. If you find it usefull, please place it on your first post, and delete from it the sentence "updated by TECK". For the rest of you, please let me know if you got it up and running using this update. It's working great for me...

[eckels2]

Originally posted by TECK
scott, there is a bug in the upgrade...
look at the query with "SELECT MAX(lastpost) AS lastpost,title FROM thread" i realised i cannot mix it. is there a way around?
thanks.

Does this mean that the 2.2.7 update doesn't work right yet?

[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.

[TECK]

ok.. another little bug discovered... and fixed.
in forum/postings.php, find:

  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 fixes a bug regarding the lastthread update, while you edit the thread (admin options).
if you download the file, make sure it says version 1.2.

[TECK]

now the only problem in postings.php is when you delete a thread, the title is not updated.. i'm working on this as we speak..

[TECK]

ok, in postings.php, under "start do delete thread", i added this way the code:

  deletethread($threadid,$foruminfo[countposts]);

  $lastpost = $DB_site->query_first("SELECT title,lastpost FROM thread WHERE forumid='$threadinfo[forumid]' ORDER BY lastpost DESC LIMIT 1");
  $DB_site->query("UPDATE forum SET lastthread='".addslashes(htmlspecialchars($lastpost['title']))."' WHERE forumid='$threadinfo[forumid]'");

what do i miss scott?

[Scott MacVicar]

Actually if you just change updateforumcount function to do it, as it gets called when a thread gets moved / deleted

I will write this in my diary to get done tonight just about to go out to work.