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.

[coRtALoS]

got an error in admin functions so, just backedup and got rid of it

[Jakor Sevel]

I tried update counter and it gave me this error

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE thread SET lastpost=1067558684,replycount=2,postusername='Hie iHimura', postuserid='86', lastposter='EightDYuber',attach= WHERE threadid=543
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE threadid=543' at line 1

mysql error number: 1064

Date: Thursday 30th of October 2003 07:07:00 PM
Script: http://www.nemxx.net/forums/forums/admin/misc.php
Referer: http://www.nemxx.net/forums/admin/misc.php?

[assassingod]

Jakor Sevel;
Use this fix:
https://vborg.vbsupport.ru/showthrea...167#post444167

[Jakor Sevel]

nope, now it gives me this error
and its admin/misc.php right..
Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE thread SET lastpost=1067572008,replycount=2,postusername='Ash uel Malkin', postuserid='82', lastposter='twistedheat',attach=0WHERE threadid=550
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'threadid=550' at line 1

mysql error number: 1064

Date: Thursday 30th of October 2003 10:49:48 PM
Script: http://www.nemxx.net/forums/forums/admin/misc.php
Referer: http://www.nemxx.net/forums/admin/mi...ction=chooser&

[VirtualHogwarts]

/me clicks install! I love this THANKS! Why isn't it default? notice it is in vB3 hehe.

[ENZcom]

Didn't work.

Parse error: parse error, expecting `T_VARIABLE' or `'$'' in functions.php on line 2007

[Hoffi]

Works great with 2.3.3 *install*

[Oblivion Knight]

Originally Posted by Oblivion Knight

Hrm.. Just a small bug is occurring with 2.3.2
If an & is used in the title, this get's displayed as & amp; (without the space) on the forum summary and forum display.

Any fix for this Scott?

Heh, this is fixed automatically in 2.3.3.. Woo.!

[Fenriz]

I really need an icon on the left side of this hack..

[Anthony_IGO]

Can you start working on a version for VB 2.3.x? I have 2.3.2 and would love to have this hack.