if($wbbuserdata['a_can_use_acp']==1) {
$pop = $db->query( "SELECT bb" . $n . "_threads.topic, bb" . $n . "_threads.threadid, bb" . $n . "_threads.lastposttime, bb" . $n . "_threads.views, bb" . $n . "_users.userid, bb" . $n . "_threads.boardid as parentid, bb" . $n . "_users.username FROM bb" . $n . "_threads LEFT JOIN bb" . $n . "_users ON (bb" . $n . "_users.userid=bb" . $n . "_threads.lastposterid) LEFT JOIN bb" . $n . "_boards ON (bb" . $n . "_boards.boardid=bb" . $n . "_threads.boardid) WHERE bb" . $n . "_threads.boardid IN (" . getBoards() . ") ORDER BY bb" . $n . "_threads.lastposttime DESC LIMIT " . $top5limit );
}
else {
$pop = $db->query( "SELECT bb" . $n . "_threads.topic, bb" . $n . "_threads.threadid, bb" . $n . "_threads.lastposttime, bb" . $n . "_threads.views, bb" . $n . "_users.userid, bb" . $n . "_threads.boardid as parentid, bb" . $n . "_users.username FROM bb" . $n . "_threads LEFT JOIN bb" . $n . "_users ON (bb" . $n . "_users.userid=bb" . $n . "_threads.lastposterid) LEFT JOIN bb" . $n . "_boards ON (bb" . $n . "_boards.boardid=bb" . $n . "_threads.boardid) WHERE bb" . $n . "_threads.boardid IN (" . getBoards() . ") AND bb".$n."_threads.visible = '1' ORDER BY bb" . $n . "_threads.lastposttime DESC LIMIT " . $top5limit );
}
|