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.

[TECK]

thanks alot scott...........
wow it was faster then i expected your answer, i pm'ed you to your new lounge, vb.com... hihi

[Baptizer]

Teck,
does your 'last post on forum home' display properly when a thread is deleted/moved? just curious.

[TECK]

no. it will be fixed by PPN today, or whenever he can spare some time beside his school.
that's the only part i could not fix. the rest is all working great.

[ExAvIoUr]

just a kind request that PPN or someone post the complete info when it is completed. this thread is making my head spin. :O thanx!

[TECK]

hmm, it doesnt make sense scott. the way it is updateforumcount($forumid) function now, it should update it... what did i miss in the steps???
thanks.

[Dark Jim]

When I do update the foruminfo in the admin cp it removes all titles on the forum home.

[Mystic Gohan]

Nice hack I installed on my vB but I need to know how to shorten the length if it exceeds so big it will be .......... instead of blabla because big thread names are stretching out my main page

[Dark Jim]

Originally posted by Dark Jim
When I do update the foruminfo in the admin cp it removes all titles on the forum home.

Uhm and any more updates?

[Dark Jim]

I guess not. I guess I will take a look at it myself but I doubt I can make it work. :ermm:

[TECK]

just be patient, scott is busy. i'm sure he didnt forget.
keep in mind that he's making us a favor that he posts his hacks, like any other hacker here.

[Dark Jim]

Yeah you're right. Btw will you (PPN) also include the posticon addon in the updated version?

[ModshackUK]

I did the hack according to TecK's instructions and I am having the problem where by when a new reply is made to the post it does not update the title of the last posted thread until a new thread is made.

Replying to existing posts does not alter the thread title on forum home.

Can anyone help as its driving me total looney tunes trying to get it to work.

Cheers

HM

[Dark Jim]

TECK, you need to fix your instructions a little.

This:
----------------------------------------
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
$lastposts=$DB_site->query_first("SELECT MAX(title) as title,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'];
$lastthread=$lastposts['title'];
$lastposter=$lastposts['lastposter'];
}

$lastpostquery=",lastpost='$lastpost',lastthread=' ".addslashes($lastthread)."',lastposter='".addslas hes($lastposter)."'";
-----------------------------------

should be:

------------------------------------
+-----------------------------------------------+
| Replace it with:
+--------------------------------------------------------------------------+
$lastposts=$DB_site->query_first("SELECT MAX(title) as title,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,title
FROM thread
WHERE forumid = $forumid AND lastpost = '$lastposts[lastpost]'");
$lastpost=$lastposts['lastpost'];
$lastthread=$lastposts['title'];
$lastposter=$lastposts['lastposter'];
}

$lastpostquery=",lastpost='$lastpost',lastthread=' ".addslashes($lastthread)."',lastposter='".addslas hes($lastposter)."'";
----------------------------------------

Now updating works in the admin cp.

[Dark Jim]

Hey, could someone help me out getting the posticons to update correctly in the admin cp? I updated the file and added the posticon stuff in it. It seems to work fine when posting but when I do a forum count update all posticons are gone (but titles work with my fix in the post above).

See the attached file.

[TECK]

dark jim, i'm gonna ask you to take out my file and put a file only with your mods.
or even better, to post here using the [code] vb code. thanks.