Просмотр файла pages/users.php

<?php 
// by mides, icq: 529-899-6, mail: [email protected]

$title = 'Пользователи сайта';
require ('../config.php');
require ('../includes/start.php');
require ('../includes/functions.php');

tp('Пользователи сайта');

echo '<div class="s1">Список</div><div class="s2">';

$users = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `users`"), 0);
if($users > 0){
	$pages = ceil($users/$config['onpage']);
	if(isset($_REQUEST['page'])){
		$page = num($_REQUEST['page']);
	}else{
		$page = 1;
	}
	$from = ($page-1)*$config['onpage'];

	$result = mysql_query("SELECT `user_login`, `user_points` FROM `users` ORDER BY `user_points` DESC LIMIT $from, ".$config['onpage']."");
	while($user = mysql_fetch_assoc($result)){
		echo '<a href="profile.php?u='.$user['user_login'].'">'.$user['user_login'].'</a> ('.$user['user_points'].')<br/>';
	}
}else{
	echo 'Пользователей еще нет<br/>';
}

echo '</div><div class="s1">Навигация</div><div class="s2">';
navig($page, '?', $pages);
echo '<a href="../">на главную</a></div>';

require ('../includes/tail.php');
?>