AND d.ub = b.ub
ORDER BY d.id DESC';
$result = sql_rowset(sql_filter($sql, $user->data['user_id'], UH_D));
foreach ($result as $i => $row) {
if (!$i) {
_style('items.downloads', array(
'ELEMENT' => UH_D)
);
}
_style('items.downloads.item', array(
'S_MARK_ID' => $row['id'],
'UB_URL' => s_link('a', $row['subdomain']),
'UD_URL' => s_link('a', $row['subdomain'], 9, $row['id']),
'UD_TYPE' => array_key($downloads->dl_type($row['ud_type']), 'av'),
'DATETIME' => $user->format_date($row['date']),
'UB' => $row['name'],
'UD' => $row['title'])
);
}
}
//
// Forum Topics
//
if (isset($items[UH_T]))
{
$sql = 'SELECT t.*, f.forum_alias, f.forum_id, f.forum_name, p.post_id, p.post_username, p.post_time, m.user_id, m.username, m.username_base
FROM _members_unread u, _forums f, _forum_topics t, _forum_posts p, _members m
WHERE u.user_id = ?
