<title><$title></title> <description><$description></description> <link>' . $base_config['baseurl'] . '/messages</link> <generator>FutureBB</generator>'; if (!isset($dirs[2])) { httperror(404); } $q = new DBSelect('users', array('username', 'id'), 'rss_token=\'' . $db->escape($dirs[2]) . '\'', 'Failed to find users'); $result = $q->commit(); if (!$db->num_rows($result)) { httperror(404); } list($username, $id) = $db->fetch_row($result); $q = new DBSelect('notifications', array('type', 'send_time', 'contents', 'arguments'), 'user='******'Failed to get notification list'); $q->set_order('send_time DESC'); $q->set_limit('20'); $result = $q->commit(); $title = translate('notifsfor', $username); while ($notif = $db->fetch_assoc($result)) { switch ($notif['type']) { case 'warning': $type = 'Warning'; break; case 'msg': $type = 'Message'; break; case 'notification': $type = 'Notification'; break; default: echo '<img src="' . $base_config['baseurl'] . '/static/img/msg_msg.png" alt="message" width="22" />';
$order = 'u.username'; break; } if (isset($_GET['order']) && $_GET['order'] == 'desc') { $order .= ' DESC'; } else { $order .= ' ASC'; } } else { $order = 'u.username ASC'; } $q = new DBSelect('users', array('u.username', 'u.num_posts', 'u.registered', 'g.g_title AS title'), ' u.id>0 AND u.username<>\'Guest\' ' . $sql . ($visible_groups == '' ? '' : ' AND u.group_id IN(' . $visible_groups . ')') . ' AND u.deleted=0', 'Failed to get users'); $q->table_as('u'); $join = new DBLeftJoin('user_groups', 'g', 'g.g_id=u.group_id'); $q->add_join($join); $q->set_limit(($page - 1) * $per_page . ',' . $per_page); $q->set_order($order); $result = $q->commit(); unset($q); while ($cur_user = $db->fetch_assoc($result)) { echo '<tr> <td><a href="' . $base_config['baseurl'] . '/users/' . rawurlencode(htmlspecialchars($cur_user['username'])) . '">' . htmlspecialchars($cur_user['username']) . '</a></td> <td>' . htmlspecialchars($cur_user['title']) . '</td> <td>' . $cur_user['num_posts'] . '</td> <td>' . user_date($cur_user['registered']) . '</td> </tr>'; } ?> </table> </div> <p><?php