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.

[NTLDR]

Change:

PHP Code:

$threadtitle=$DB_site->fetch_array($DB_site->query("SELECT * FROM thread WHERE forumid='$forumid' AND lastposter='$getchildforum[lastposter]' AND lastpost='$getchildforum[lastpost]'")); 


To:

PHP Code:

$threadtitle=$DB_site->fetch_array($DB_site->query("SELECT * FROM thread WHERE forumid='$forumid' AND lastposter='".addslashes(htmlspecialchars($getchildforum[lastposter]))."' AND lastpost='$getchildforum[lastpost]'")); 


That should fix the problem.

[pgowder]

Which file does that change go in?

[NTLDR]

admin/functions.php You need tyo replace whats in the text file with the change I made above so it should work.

[pgowder]

I found it, and that fixed it.

Thanks for the quick responses!!

[NTLDR]

No problem, happy to help

[Erwin]

Bug: If the parent forum is NOT private, but the child forum IS private, the last title appears to show up for members who have no access to the private child forum.

Is there a fix for this? Thanks in advance.

[N9ne]

@Erwin, I also noticed this problem + this one:

When a thread is the latest thread and its title is shown on forumhome, and I edit the thread's title, and go back to forumhome, it still shows the old thread title, and not the new one...my guess is maybe modifying editpost so when the thread title is changed, it changes it in the DB?

[desi]

i ave v-bulletin 2.2.8 running and i tried adding this hack but this is what i got ....

i went through the entire thread but no luck

Parse error: parse error, expecting `']'' in /home/123.com/httpdocs/forums/index.php(321) : eval()'d code on line 6

Parse error: parse error, expecting `']'' in /home/123.com/httpdocs/forums/index.php(321) : eval()'d code on line 6
===============================

line 321 is this
eval("\$forum['lastpostinfo'] = \"".gettemplate('forumhome_lastpostby')."\";");

According to instructions i am suppose to add this
<a
href="showthread.php?s=$session[sessionhash]&goto=lastpost&forumid=$forum[forumid]">$forum[lastthread]</a> to the 'forumhome_lastpostby'


any suggestions ....

thankx for helping

[N9ne]

It is telling you to add that HTML into the TEMPLATE forumhome_lastpostby not in the code

[CtrlAltDel]

I installed this hack and the thread names rarely update on the homepage at all. I have tried a few fixes in this thread but they dont seem to work, 2.2.8, etc. I'm going to look at the file tek posted, but atm its not working right.