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.

[Mr. X]

I installed this hack on my public forum finally (after an upgrade to 2.3.0) and so far I've had no errors at all, same with my localhost test forum. I wish there was a way to disable lastpost for a forum that only registered members can see, but thats my only gripe. I'd really like to get that icon addon though, so I'll install that tomorrow on my test board and see how it goes.

For my private forum, I have that set that only admins/mods can view it, so it doesnt appear to anyone else, so no problems there.

[kms]

i've had it working on 2.26/7/8&9 but its not straight forward on 2.3 because

$lastposts=$DB_site->query_first("SELECT MAX(lastpost) AS lastpost FROM thread WHERE forumid=$forumid AND visible=1 AND open<>10");
  if ($lastposts['lastpost']>$lastpost) {
  $lastposts=$DB_site->query_first("
      SELECT lastpost,lastposter
      FROM thread
      WHERE forumid = $forumid AND lastpost = '$lastposts[lastpost]'");
  $lastpost=$lastposts['lastpost'];
  $lastposter=$lastposts['lastposter'];
  }

  $lastpostquery=",lastpost='$lastpost',lastposter='".addslashes($lastposter)."'";

isnt in v2.3 /functions/admin/functions.php. How did you get your v2.3.0 working? TIA

[Boofo]

This code was taken straight out of the 2.3.0 functions.php

PHP Code:

  $lastposts=$DB_site->query_first("SELECT MAX(lastpost) AS lastpost FROM thread WHERE forumid=$forumid AND visible=1 AND open<>10");
  if ($lastposts['lastpost']>$lastpost) {
    $lastposts=$DB_site->query_first("
            SELECT lastpost,lastposter
            FROM thread
            WHERE forumid = $forumid AND lastpost = '$lastposts[lastpost]'");
    $lastpost=$lastposts['lastpost'];
    $lastposter=$lastposts['lastposter'];
  }

  $lastpostquery=",lastpost='$lastpost',lastposter='".addslashes($lastposter)."'"; 


[kms]

odd ? but thnx, will try again. Yours works ok?

[Boofo]

I'm using 2.2.9, but I took that straight out of the functions.php for 2.3.0. I little tip...if you can't find a block of code, try looking for a single line of code and check it out for the rest of it. Sometimes the formatting is different which will throw things off.

[kms]

thnx. Ignore me btw, its all there, works a treat. Not sure what iwas doing b4?

[Mr. X]

"if you can't find a block of code, try looking for a single line of code and check it out for the rest of it. Sometimes the formatting is different which will throw things off."

Yep, thats exactly what I do. Ultraedit's search isnt great, so I just search for the first line, but if its a line that appears a bunch of times in a file, I move to the next and narrow it down, then compare the block of code.

It sucks, wish I could find blocks of code in Ultraedit though.

[Boofo]

Try EditPlus2. You can find whole blocks of code with it, no matter how big. The one line search is why I ditched Ultra-Edit and switched to EditPlus2. Far better editor.

[Mr. X]

Hmm yeah I've been looking into it. UE does have alot of stuff I like, but I might consider switching.

Does the Icon addon work? I get alot of lines that dont appear in 2.3.0 code so Im guessing its a no go now. Bummer, an Icon addition would be nice with this hack.

[Oblivion Knight]

Thanks Scott, it's working flawlessly on 2.3.0 RC3
This is one of those modifications that I believe vBulletin should have as default..

[high]* Oblivion Knight clicks install.[/high]

[XP Kid 86]

hmm odd no matter where i put the

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

i cant get it to work .. can you help me out maybe by takin a look at my forum or something .. the hacking went smoothly enough .. im runnin' 2.3.0 .. so can someone please help me this is like a must for a vB


- Speedy

[Holidazed]

I am getting a parse error when trying to delete in posts.

It says:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Parse error: parse error in /home2/webbhelp/webbhelper-www/mb/postings.php on line 837
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

It does not give any more information. When deleting a post from within the "Edit Post" section, all is cool, but after viewing the thread (showthread.php) and choosing "Delete Thread / Post" from the " Admin Options" menu, it give me the error above.

See for yourself

http://www.dungeonkeepersdomain.com/mb/postings.php

Help

[Alien]

Just installed this on 2.3.0, and it worked flawlessly SO FAR.

Tested deleting threads (using edit post AS WELL AS deleting directly from the admin options menu inside showthread), moving threads, etc. So far so good...

I'll keep poking around and see if I crash it, heh.

-Jason

[Emrys]

Installed this and everything seems to work fine. Although I cannot figure out how to get a last post with the 25 characters to be even with a last post with say 15 characters.

In other words, everytime that the script adds the "..."s the title is out of line with the non "..."s posts. Example at : http://www.mac-forums.com.

I have tried to edit the template and changing the length of the string. Nothing has an effect on the alignment. Also tried it with bold and not bold. This one is just messing with me.

Any ideas?

I've noticed some boards don't have this issue, so I know it can be fixed. I just can't remember which ones, and I'm not gonna re-read a 25 page thread. I've already read it twice

Added an example for quick reference



See how the top post is a little left of the red line and the other 2 are right on the redline?

It is easier to see when you are looking at whole page.

[Alien]

I'd recommend going over the steps again, as that issue does NOT happen on my side of things...?

Anyone else get this problem?