Exemple #1
0
	<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" />';
Exemple #2
0
            $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