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.

[NYI Fan]

Ok, Im feeling might foolish right now
I installed this awesome hack with no trouble on 2.2.0
I upgraded to 2.2.2 the other day and was just now getting to re-installing hacks - for some very bizzare reason, I cannot make this one work on 2.2.2

I've gone thru it 3 or 4 times now, each time i end up with parse errors. I should have been copying them down, but i was so sure it was just me being an idiot and missing something, i didnt bother.

Im gonna try again sometime tonight, but i was wondering if anyone else had any trouble getting it to work after they upgraded to 2.2.2?

If it fails again later, i will document my errors - I know you cant offer help without specifics... i'm just miffed cuz this is such a great addition, and not only do I miss it, my members are asking for it back...
Thanks!

[Omero]

I have 2.2.2 and the hack is working perfectly

[Scott MacVicar]

I've installed this fine on everything from 2.0 RC1 to 2.2.2
I'll gladly help if your having problems though.

[NYI Fan]

Thanks PPN
I will be trying again later today
i finished putting everything else back in so now this is the only one I'm missing
i have "real world" stuff to do today (i need an errand boy LOL)
but when i try again later i will post if im still experiencing fits of stupidity

[x28]

PPN

Every thing was working great untill i moved a topic form a main forum to a sub-form. Title shows but after a member posted to it when you click on the link it reads

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

url shows "www.myaddress/community/showthread.php?s=&threadid="

Also added this piece

https://vborg.vbsupport.ru/showthrea...306#post175306

What do i need to do?

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