[joeroberts]

PHP Code:

<?php
require_once 'global.php';
dbconn();
$i_post_limit = '1';
$_res_lt_query = sql_query("SELECT t.tid, t.iconid, t.subject, t.dateline, t.uid, t.username, t.replies, t.lastpost, t.lastposter, t.lastposteruid, t.views FROM ".TSF_PREFIX."threads t WHERE 1=1 {$where_sql} ORDER BY t.lastpost RAND() LIMIT 1, ".$i_post_limit);
    while($thread = mysql_fetch_assoc($_res_lt_query))
 
   echo '<table width="100%" border="0" cellspacing="0" cellpadding="5">
            <tr>
                <td align="left"><img src="./tsf_forums/images/icons/icon'.$thread['iconid'].'.gif" border="0" class="inlineimg">
                <td align="left"><strong><style="padding-top: 6px;"><a href="'.$BASEURL.'/tsf_forums/showthread.php?tid='.$thread['tid'].'" alt="'.htmlspecialchars_uni($thread['subject']).'" title="'.htmlspecialchars_uni($thread['subject']).'">'.cutename(htmlspecialchars_uni($thread['subject']), 50).'</a></strong><br> '.sprintf($lang->index['by'], '<a href="'.$BASEURL.'/userdetails.php?id='.$thread['uid'].'">'.$thread['username'].'</a>' ).'<br />'.my_datee($dateformat, $thread['dateline']).' '.my_datee($timeformat, $thread['dateline']).'</td>
                <td align="right">'.my_datee($dateformat, $thread['lastpost']).' '.my_datee($timeformat, $thread['lastpost']).'<br />&nbsp;'.sprintf($lang->index['by'], '<a href="'.$BASEURL.'/userdetails.php?id='.$thread['lastposteruid'].'">'.$thread['lastposter'].'</a>' ).'&nbsp;<a href="./tsf_forums/showthread.php?tid='.$thread['tid'].'&amp;page=last"><img src="./tsf_forums/images/lastpost.gif" class="inlineimg" border="0" alt="'.$lang->index['last'].'" title="'.$lang->index['last'].'"></a></td>
                <td align="center"><strong>'.ts_nf($thread['replies']).'</strong></td>
                <td align="center"><strong>'.ts_nf($thread['views']).'</strong></td>
            </tr></table>';
?>

You do know your missing a veritable here don't you?

PHP Code:

{$where_sql}