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.

[danielillo]

Does it work with subforums?

[Longbow]

reported as there is no "lasttitle" field in my forum table.

any hint?

[Recon_Boy]

First line of the instructions tells you to add that column to the forum table...

[Scott MacVicar]

danielillo

yes it does as long as you remember to add the code to forumdisplay.php as well as it says in the bottom of the instructions.

[h4p3]

@PPN

There is still one little Bug. If you make "" in your threadtitle, then it will display (&q ... on the forum home.

I think there should be something enabled, that allows special chars.

[floleb7]

any news for adding posticon ?

[pgowder]

I'm getting this error:

Database error in vBulletin 2.2.1:

Invalid SQL: UPDATE user SET lastactivity=1009592618,inforum='19' WHERE userid='2'
mysql error: Incorrect key file for table: 'user'. Try to repair it

mysql error number: 1034

Date: Friday 28th of December 2001 09:23:39 PM
Script: http://www.powwows.com/gathering/gathering/newreply.php
Referer: http://www.powwows.com/gathering/ne...ly&postid=14569

[Scott MacVicar]

h4p3
-------------
the only problem i noticed is that   counts as 6 chracters from the limit so if you have "Something"

it becomes  Something 

and thats 23 characters so if its limited to 20 characters you will get "Something&nbs shown
it does allow for special characters.

floleb7
-------------
The post icon would really require you adding another field and then adding to the sql query as its not practicle to pull it from the database each time.

pgowder
-------------
My hack doesn't touch anything within that section and it doesn't edit the user table, i'd have a look at other hacks you have installed or try the vBulletin.com support forums

[pgowder]

It wasn't the hack. It was a problem with a power outage and my database became corrupted.

[floleb7]

Originally posted by PPN


floleb7
-------------
The post icon would really require you adding another field and then adding to the sql query as its not practicle to pull it from the database each time.

oki