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.

[Boofo]

One last time, is anyone supporting this hack?

[N9ne]

I found a bug in this hack, say you disallow guests to view threads in a forum, the guest can still see the title on forumhome, what can I do to make it so they only see the last post they're supposed to see?

[KevinM]

I have installed this hack and it partly works. I have checked the installation and all seems to be as per instructions. I also have a gateway (usenet) hack installed which maybe causing a conflict.

My problem is:
The last post date / name etc are fine
The last post title is incorrect - it was correct the first time but won't update.
The link from the last post title works, and takes you to the last post.

Why won't the title update?

You can see the site at http://www.gardenbanter.co.uk

I hope one of you can help.

Ok - I think I've figured it out. As all my threads come from usenet, the gateway script imports them into the db. Therefore after each import, the 'update forums info' needs to be run. In my case this is 6 times every hour. I have written a cron job calling the misc.php file. It seems to be working, but don't know what it will mean to the server load.

[webhost]

have the same problem using 2.2.9 Hack was working then I installed this hack https://vborg.vbsupport.ru/showthrea...threadid=34361 now when someone registers it puts the info for that user in the post but does not update on forumhome page. I can go and run update counters in admin cp and it updates then. Any ideas.?

[maxxxxxx]

All works great but i want this last post on left side under the forums list like the picture...




thx and cu
maxxxxxx

[maxxxxxx]

Originally posted by Omero
I've tried to edit the code to make the title NOT appear for all forums where the user don't have access to, copying a couple of lines from forumdisplay.php (I'm no hacker, i'm simply a user, and know very little of PHP).

It works perfectly for me (but TEST IT AT YOUR OWN RISK, im no php coder ), but:

A) I'm sure there is a better way to implement it... i RECHECK permissions, while probably permissions are already checked and i should just pull them out from the right variable... but i dont know how

B) I'm not sure at all if the title will display or not, in the case

Category
- Private subforum
- Non private subforum

I think this mini edit i did just remove the title in the case the forum is VISIBLE from homepage, and NOT in the case the title is in a category visibile, but comes from a private subforum you shouldnt have access to (that's because i simply check if the user can enter the forum, and display nothing if he can't... the user can access that category, so the title is shown, even if the title comes from a "non accessible for the user" forum

Yet, it works, it doesn't show the title for the forums you don't have access to I tested it, but USE IT AT YOUR OWN RISK.

         // Last post hack + check for view

          $titleperm=getpermissions($forumid,-1,-1,$foruminfo['parentlist']);
          if ($titleperm[canview]) {
            $showtitle=1;
          }

          if ($showtitle) {

            $forum['lasttitle']=unhtmlspecialchars($forum['lasttitle']);
            if (strlen($forum['lasttitle']) > 25) {
              $forum['lasttitle'] = substr($forum['lasttitle'], 0, 23);
              $forum['lasttitle'] .= '..';
            }
          } else {
            $forum['lasttitle']='';
          }

Hello... at wich plase i must paste with code in.... sorry my english is not the best and i dont understand all that you write...

Best regards
maxxxxxx

[Boofo]

Sometimes when I click on the last title on the forum home I get the dreaded no thread specified error. I have narrowed it down to this piece of code (which is an addon to this hack posted by PPN elsewhere in this thread).

PHP Code:

// goto newest thread
if ($goto=="newthread") {
  if (isset($forumid) and $forumid!=0) {
    $foruminfo=verifyid("forum",$forumid,1,1);
    $forumid=$foruminfo['forumid'];
    $lastthread=$DB_site->query_first("SELECT threadid FROM post WHERE username='".addslashes($foruminfo[lastposter])."' AND dateline='$foruminfo[lastpost]'");
//    $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;
  }
} 


and here is the line to replace in the "forumhome_lastpostby" template:

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

Can anyone please tell me why the threadid will not update at times? If I go into the Admin CP and use the update counters, then it works fine.

[MetroSports82]

I've actually come really close to fixing that very issue. but unfortunately, i only had it working for some usergroups, while it was not updating for the others, is this the same problem your having? i'm using v2.2.9.

Metro.

[Boofo]

I am using 2.2.9, also. I "think" I might have it fixed, but not sure. In the code above, try changing:

PHP Code:

$forumid=$foruminfo['forumid']; 


to:

PHP Code:

$forumid=$threadinfo['forumid']; 


and let me know if that fixes it for you.

[webhost]

What file is that in?

[Boofo]

The showthread.php, but you must be using the addon by PPN. If anyone can verify this fixes it, I would appreciate it.

[webhost]

I lloked in showthread php and that is not in the file, could you tell me where the add on is located at

[Boofo]

That code is the addon. It changes the last title to go to the first post in the thread instead of going to the last post like the arrow already does.

[iggemonster]

hi !

does this hack work with 2.3.0 ?

greetz

[Kianor]

i was trying this hack for 2.3.0 but i did't appear to wrk, cause it shows the last title for everyone even if you are not logged in or the forum is a private one.

There's no support for this hack anymore?