Latest threads/latest posts

[Nordinho]

I'm trying to get my copied recent threads module to show only the latest threads in the left column while the original center module functions as the 'latest forum posts'...

I tried it a bit myself and come up with the following in latesttopics.php...

PHP Code:

if ($mods['modcol'] == 1)
{
ORDER BY lastpost DESC;
}
else
{
ORDER BY thread.dateline DESC;
} 


but this doesn't work...getting a parse error...any ideas how it could be done right??

[Nordinho]

bump

[Brian]

if ($mods['modcol'] == 1) 
{
$torder = 'lastpost'; 
} 
else 
{ 
$torder = 'thread.dateline'; 
}

Then replace 'ORDER BY lastpost DESC' with 'ORDER BY $torder DESC'.

[Nordinho]

thanks for your help, but I'm still getting an parse error...this is the part

PHP Code:

    WHERE open != 10 AND thread.visible = 1 
                $mods[threadids]
                $mods[inforums]
                $mods[exforums]
                $notdeleted
                if ($mods['modcol'] == 1) 
                {
                $torder = 'lastpost'; 
                } 
                else 
                { 
                $torder = 'thread.dateline'; 
                }
                ORDER BY $torder DESC
                LIMIT $mod_options[portal_threads_maxthreads]
        "); 


[Brian]

That code needs to be added somewhere above the query.

[Nordinho]

that was too easy thanks a lot!!