Last thread on main page
 

This hack was requsted by me :) here.

It displays last thread on main page yours vB.

Download doesn't seem to work.

-JRW

Try once again. At me with download it hack everything is all right.

demo please

heh just checking
will this show last thread title with private forums?

Screenshot ?

Demo you will find on http://boltalka.com.ua , and screenshot is attached in this message.

Add $last_thread in forumhome template (in that place where it should be output last thread).

wtf does that mean? where do i put it exactly

Wherever you want it to show up.

well i want it in the same place as the screen shot ^. where would i put the $last_thread

Find:
Put after it:

does not work

Yes it does...

I dont like it though...

Nice Hack and all, but at our forums, it updates every 2 seconds, so it is never accurate enough...

Satan

It works instead of $last_thread put $lastthread in your forumhome. Stop saying it works because it doesnt. Not until you make thiese changes. Start helping out guys and stop htinking your all that.

lol, and thats coming from a guy named BigJohnson.

This hack is coded a little inefficiently. I suggest that instead of of SELECTing everything ("*"), you select only the necessary items or columns/fields from the database. Also, doing a count() on a certain field with an INDEX is a lot faster than a count(*).

No offense please, didn't mean to bash you or your coding skills, but it's what I noticed since vBulletin tends to "rape" our server already and this hack is quite nice, and I don't want the hack to add to the load. ;)

This Hack doesn't do work by me i become follow error:

Parse error: parse error, expecting `']'' in /is/htdocs/15766/www.xxxxxxx.com/vb/index.php(43) : eval()'d code on line 5

thx for a fix

P.S. I use vB 2.6

Hellburn, please check code when you put in index.php.

The code is :

$forums=$DB_site->query('SELECT forum.*, thread.title AS threadtitle FROM forum LEFT JOIN thread ON (thread.forumid=forum.forumid AND thread.lastpost=forum.lastpost) WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder');

and:

// dates
if ($forum['lastpost']>0) {
// title lenght (change it to suit your forum)
$titlelenght='32';
$forum['titleextra']='';
if (strlen($forum['threadtitle'])>$titlelenght) {
$forum['titleextra']='[...]';
}
$forum['threadtitle']=substr($forum['threadtitle'],0,$titlelenght);

This code not from my hack!
Please read first post of this thread.

can't het the $lastthread in the right place on the forumhome template.

Can someone tell me how to do it please

Thanks

anyone?

si@smscworld, sorry, but my main page different from default vb page. You can place $lastthread anywhere in forumhome template. Please see post #11.

that only shows one last thread on the homepage, I want it where its on every Forum, like yours.

I want it where you have time of the thread, last thread's name and posted by who.

Need your help guys

si@smscworld, you need use other hack! :)
see Last post on forum home, working version hack by PPN.