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 = ?