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]

You need to change the length you want the last time to be in this line:

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

The default length of the last title is 28 right now. Either make it a smaller number or add space.gif to your forumhome_forumbit_level1_nopost like this:

<td bgcolor="#1D6AA0" nowrap><smallfont color="#EEEEFF"><img src="https://vborg.vbsupport.ru/images/space.gif" width="200" height="1"><br><b>Last Post</b></smallfont></td>

Originally posted by alanvo
it screws up my tables, why is that, can anybody please help me...

http://www.demsang.net/forums

[fonzerelli_79]

i installed the hack on my test forums and everything seems fine when i upload the files

when i change the template though i get this error on the forums home

Parse error: parse error, expecting `']'' in ......./index.php(362) : eval()'d code on line 2

any ideas folks?

[Dark Jim]

I would also like to have the posticon used last next to it on the forum home.

[N9ne]

[QUOTE]Originally posted by PPN
ok open showthread.php and above

PHP Code:

if ($goto=="nextnewest") {
  $thread = verifyid("thread",$threadid,1,1); 


add

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->fetch_array($DB_site->query("SELECT threadid FROM post WHERE username='$foruminfo[lastposter]' AND dateline='$foruminfo[lastpost]'"));
    header("Location: showthread.php?s=$session[sessionhash]&threadid=$lastthread[threadid]");
    exit;
  }
} 


now change the bit i told you to to

PHP Code:

<a href="showthread.php?s=$session[sessionhash]&goto=newthread&forumid=$forum[forumid]">$forum[lasttitle]</a> 


sorry it took so long to reply, i thought vBulletin would have had a way to do this, but it didn't so i wrote one.

[Boofo]

Scott,

Have you had a chance to look at the problem I am haing with apostrophes in the last poster name? (Posts 185 and 186 of this thread).

[Courage]

If someone post a new thread with the subject

<iframe src="http://www.vbulletin.org"></iframe>

the iframe apears in the main page of my forum ! :@
My forum is so ++++ed UP ! ;(

Need support !

[Boofo]

Scott,

I have one last title on the forum home that keeps giving me the errorid error when I click on the last title link. The others work fine but this one thread will not go to the first post when you click on it. The last post button will take you to the last post ok. Any ideas what could be causing this? And I already did the updates for forum counters and stuff and it didn't change anything.

And any word on the apostophes in the name causing db errors when I update the counters? Any help would be appreciated.

[si@smscworld]

Hi, not sure if this has already been mentioned, but here goes anyway:

I have installed this hack fine and it works great, thanks PNN. But I have a Admin Only Area and I don't want other members seeing what threads are being made in this forum. Can someone tell me how to remove the last thread on that section. Thank you for reading and I hope someone can help me

[si@smscworld]

Anyone? surely someone has sorted this out!

[Austin Dea]

I had my sizs all set and it was working fine but I upgraded to 2.2.6 and now I can't get the sizes to work at all.

PHP Code:

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


Is it something to do with the new php version o_O...

[Boofo]

Here's what I have and it works fine.

PHP Code:

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


Originally posted by Austin Dea
I had my sizs all set and it was working fine but I upgraded to 2.2.6 and now I can't get the sizes to work at all.

PHP Code:

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


Is it something to do with the new php version o_O...

[Austin Dea]

Yours is the same thing only longer..

Maybe I need to reinstall... but i thought the index.php part of the hack would be the only thing that controls the length...

[Austin Dea]

ARe you on 2.2.6? Because mine stilll doesn't work after re-installing...

[Austin Dea]

Boofo, you're not using vB 2.2.6 at www.bearfacts2.com/forum/ ...

[Boofo]

You got me there.

The code is the same code I have given a few people with 2.2.6 and it has worked fine for them. Sorry that it doesn't for you. :disappointed:

What is exactly happening when you insert your code? Is anything showing at all? The forumhome template was supposed to be changed in 2.2.6. Could that possibly be a problem? I don't know, I'm just guessing here.

Originally posted by Austin Dea
Boofo, you're not using vB 2.2.6 at www.bearfacts2.com/forum/ ...