[COLOR=#000000][COLOR=#0000BB]$siteposts [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$db[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000BB]query_read[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"
SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM " [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000BB]TABLE_PREFIX [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#DD0000]"thread as thread
LEFT JOIN " [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#0000BB]TABLE_PREFIX [/COLOR][COLOR=#007700]. [/COLOR][COLOR=#DD0000]"user AS user ON (user.username = thread.lastposter) WHERE forumid NOT IN (132, 138, 139, 140, 133, 137, 96, 98, 97, 150, 90, 63, 92, 121 ,152 ,146) ORDER BY lastpost DESC LIMIT 0, 10"[/COLOR][COLOR=#007700]);
while([/COLOR][COLOR=#0000BB]$latest [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]$db[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000BB]fetch_array[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$siteposts[/COLOR][COLOR=#007700]))
{
[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]str_replace[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$hidechar[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]" "[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]]);
if ([/COLOR][COLOR=#0000BB]strlen[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]]) > [/COLOR][COLOR=#0000BB]28[/COLOR][COLOR=#007700])
{
[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]substr[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#0000BB]0[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]80[/COLOR][COLOR=#007700]) . [/COLOR][COLOR=#DD0000]'...'[/COLOR][COLOR=#007700];
}
else
{
[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]];
}
[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]htmlspecialchars[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]]);
[/COLOR][COLOR=#0000BB]$trans [/COLOR][COLOR=#007700]= array([/COLOR][COLOR=#DD0000]"&" [/COLOR][COLOR=#007700]=> [/COLOR][COLOR=#DD0000]"&"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]strtr[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'title'[/COLOR][COLOR=#007700]], [/COLOR][COLOR=#0000BB]$trans[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'replycount'[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]number_format[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'replycount'[/COLOR][COLOR=#007700]]);
[/COLOR][COLOR=#0000BB]$lastest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000BB]musername[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]fetch_musername[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$lastest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#0000BB]musername[/COLOR][COLOR=#007700]] = [/COLOR][COLOR=#0000BB]$db[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000BB]escape_string[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$lastest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'musername'[/COLOR][COLOR=#007700]]);
[/COLOR][COLOR=#0000BB]$date [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]date[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"g:i a"[/COLOR][COLOR=#007700],[/COLOR][COLOR=#0000BB]$latest[/COLOR][COLOR=#007700][[/COLOR][COLOR=#DD0000]'lastpost'[/COLOR][COLOR=#007700]]);
[/COLOR][COLOR=#0000BB]$latest_posts [/COLOR][COLOR=#007700].= [/COLOR][COLOR=#DD0000]"
<div style='padding: 4px; border-bottom: 1px dashed gray;' >
<div style='font-size: 12px;'>• <a href='showthread.php?t=$latest[threadid]' title='$latest[title]' style='font-size: 11px;'>$latest[title]</a></div>
<div style='padding-top: 1px; padding-bottom: 2px; font-size: 7pt;'>
<a href='member.php?u=$latest[userid]' style='font-size: 11px;'>$latest[musername]</a> replied in this thread at $date
</div>
</div>"[/COLOR][COLOR=#007700];
}
[/COLOR][COLOR=#0000BB]$db[/COLOR][COLOR=#007700]->[/COLOR][COLOR=#0000BB]free_result[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$siteposts[/COLOR][COLOR=#007700]); [/COLOR][/COLOR]