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.

[Omero]

PPN btw im still running my "modified" version of your hack. Could you come up with the final version, even if that means an added query, as I did? I would love to see your version instead of my crappy mod

[bigmo]

After installing the hack I get these errors if I try to post, to reply and to update froum info:

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT forumid,threadcount,replycount,parentlist,parentid ,lastpost,lastposter,lasttitle FROM forum WHERE INSTR(CONCAT(',',parentlist,','),',10,')>0
mysql error: Unknown column 'lasttitle' in 'field list'

mysql error number: 1054

Date: Tuesday 12th of March 2002 11:29:33 PM
Script: http://64.239.47.216/vb/vb/postings.php
Referer: http://64.239.47.216/vb/postings.php...d&threadid=186

Some ideas ???

THX for help

So long...
BigMo

[Mystics]

Originally posted by bigmo
Some ideas ???

Just read the Instructions from the beginning

first thing to do is to run this mysql query :P
ALTER TABLE `forum` ADD `lasttitle` VARCHAR(100) NOT NULL AFTER `lastposter`

You need phpMyAdmin (for example) to run this Query.

[Scott MacVicar]

Sorry i never posted the changes..
here they are

look for

PHP Code:

      if (!$hideprivateforums) {
        $forumperms['canview']=1;
      } 


above it add

PHP Code:

$trueperm['canview'] = $forumperms['canview']; 


now use

PHP Code:

          if($trueperm['canview']) {
            $forum['lasttitle']=unhtmlspecialchars($forum['lasttitle']);
            if (strlen($forum['lasttitle']) > 30) {
              $forum['lasttitle'] = substr($forum['lasttitle'], 0, 28);
              $forum['lasttitle'] .= '..';
            }
          } 


i've updated the main file now.

[inetd]

In what file it is necessary to make these changes?

[bigmo]

@Mystics

Hihi...sorry I didnt see it...

THX

@ppn

i've updated the main file now.

Where can I get these main file ???

[Scott MacVicar]

index.php and forumdisplay.php and look at the very first post for the main hack file

[bigmo]

what is the diference betwen vb_last_title.txt and vb_last_title_new.txt ??

[Scott MacVicar]

the vb_last_title_new.txt was by Omero, though it runs an extra query for each forums, I'll go remove it in a minute.
Anyway my version doesn't run the extra query and is therefore ideal :P

[TWTCommish]

Therefore ideal? Hardly. I find mine are always getting mucked up...moved threads, deleted threads, stuff like that. There is definitely something to be said for another query here or there if it helps keep the integrity of the last post display.