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.

[pgowder]

I installed the hack on my forums running v2.2.8. Here is the error I get:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT * FROM thread WHERE forumid='33' AND lastposter='Smokin' Ace' AND lastpost='1034790242'
mysql error: You have an error in your SQL syntax near 'Ace' AND lastpost='1034790242'' at line 1

mysql error number: 1064

Date: Wednesday 16th of October 2002 04:26:52 PM
Script: http://www.powwows.com/gathering/gat...admin/misc.php
Referer: http://www.powwows.com/gathering/adm...action=chooser


I believe it might be having problems with a user that's username is Smokin' Ace because of the ' in the username. How can I fix that?

Thanks

[N9ne]

Maybe you can post in that forum, so your username is shown then try again...?

[pgowder]

But won't it give an error next time she posts?

[N9ne]

Was that error message created while hacking or does it come up when she posts?

[pgowder]

Sorry, I should have said that I get this error while running forum update.

Thanks

[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?

[pgowder]

I found it, and that fixed it.

Thanks for the quick responses!!

[NTLDR]

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

[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.