1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
|
/* users lastpost */
$showlastpost = 0;
if ($showlastpostinprofile == 1 && $wbbuserdata['can_enter_board'] == 1) {
$boardids = '';
$permissioncache = getPermissions();
$result = $db->unbuffered_query("SELECT boardid, password, invisible FROM bb".$n."_boards");
while ($row = $db->fetch_array($result)) {
if ($row['password'] != '' || $row['invisible'] == 2) continue;
if (!isset($permissioncache[$row['boardid']]['can_enter_board']) || $permissioncache[$row['boardid']]['can_enter_board'] != 0) $boardids .= ",".$row['boardid'];
}
if ($boardids != '') {
$lastpost = $db->query_first("SELECT p.postid, p.posttime, t.topic, t.boardid, b.title FROM bb".$n."_posts p, bb".$n."_threads t
LEFT JOIN bb".$n."_boards b ON (t.boardid=b.boardid)
WHERE p.threadid=t.threadid AND t.boardid IN (0$boardids) AND p.userid = '".$boarduserinfo['userid']."' AND p.visible=1
ORDER BY p.posttime DESC", 1);
if ($lastpost['postid']) {
$lastpostdate = formatdate($wbbuserdata['dateformat'], $lastpost['posttime'], 1);
$lastposttime = formatdate($wbbuserdata['timeformat'], $lastpost['posttime']);
$lastpost['topic'] = htmlconverter(textwrap($lastpost['topic']));
$lastpost['title'] = getlangvar($lastpost['title'], $lang);
$showlastpost = 1;
}
}
} |