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.

[psychopathic]

i just figured that i'd get SOMETHING after 10 hours of waiting, but alas, i got nothing.

Thanks for the response PPN. Right now my vB is offline, but the ftp seems to still work.. strange, anyway, i had previously updated everything in attempt to fix it, and just now i re-modified functions.php and i'll let you know how it turns out when my site comes back online. thanks.

[Tim Wheatley]

Originally posted by PPN

PHP Code:

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


above that add the following

PHP Code:

$forum['lasttitle']=unhtmlspecialchars($forum['lasttitle']); 


if the length is over 30, remove everything after 28 characters and add two dots to the end.

Hope this helps, instruction file now updated.

Doesn't seem to work for Opera... Any ideas?

[Tim Wheatley]

Originally posted by PPN
sorry about this i forgot to unhtmlspecialchars the title.


within index.php and forumdisplay.php look for the follow lines which you added.

PHP Code:

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


above that add the following

PHP Code:

$forum['lasttitle']=unhtmlspecialchars($forum['lasttitle']); 


this should solve the problem with the characters not being converted.

Also the decision on length is made by the top code a quick explanation is, if the length is over 30, remove everything after 28 characters and add two dots to the end.

Hope this helps, instruction file now updated.

This does not seem to work for Opera - any ideas?

(The text limiting I mean - Opera users get a big long line of text...)

[bigmo]

Originally posted by PPN
Though this could be changed to check if they are allowed to view other threads or any other sort of permission for a forum. Will show the changes when i get home.

@PPN
Have you forgotten me????

Please post the changes here...thats would be fine

THX
BigMo

[Scott MacVicar]

you can change

PHP Code:

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


change the $forumperms['canview']; to whatever sort of permission you want.

such as
canview, canpostnew, canviewothers, canreplyothers, canreplyown

[bigmo]

OK THX...

My last question:

in which file at which position I must add/change the

PHP:

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

???

[Wayne2k1.com]

It doesn't work 4 me.



The hack works perfectly, but it shows last post for private forums, too...and that's baaaad.

[bigmo]

Yes I tested it vesterday (I changed the index.php und the forumdisplay.php) and it dont work for me too. The lastpost is still displayed at forums the user dont have the right to access...

Some other solutions ???

THX

[Harvey]

ok, here is an better but still untested!!! version.

It looks up, if a registered user can view a forum.
if Yes: put the title into the forum and the patents.
if No: put "(private message)" into the forum and the patents.

This design is because IMHO it is impossible to look up if the title is from a private subforum without doing a query.

First apply the changes from PPN
then my changes
then post dummy threads in the private forums.

Sorry for not testing, I currently have no testforum.

[Wayne2k1.com]

Doesn't work.

Invalid SQL: max(canview) as cveiw ,count(canview) as cnt from forumpermission where usergroupid=2 and forumid=5
mysql error: You have an error in your SQL syntax near 'max(canview) as cveiw ,count(canview) as cnt from forumpermission where usergrou' at line 1

That's the error.