echo "<b>{$strDeleteUserMessage} <font color=#002E80>{$delete_user}@{$delete_host}</font><br>{$strRememberReload}</b>";
} else {
echo "<b>{$strDeleteFailed}</b>";
}
}
if (isset($edit) && $edit) {
# Edit an user
table_users($host, $user);
edit_operations($host, $user);
} elseif (isset($grants) && $grants) {
# Revoke/Grant Privileges
table_grants($host, $user);
grant_operations();
} elseif (isset($check) && $check) {
# Check Database Privileges
check_db($db);
check_operations();
} else {
# Users actions
if (!isset($host)) {
$host = FALSE;
}
if (!isset($user)) {
$user = FALSE;
}
table_users($host, $user) || mysql_die($strNoUsersFound);
normal_operations();
}
require './footer.inc.php';
?>
</html>
<?php
require "subs.php";
require_once "conf.inc.php";
require_once "lib/dblayer.php";
$btn_home = "<a class='button' href='./'><<</a>";
$db = new DBLayer($CNF["db_host"], $CNF["db_user"], $CNF["db_pass"], $CNF["db_name"]);
$db->query("SET NAMES utf8");
$q = "SELECT\n u.`uid`,\n u.`modiff`,\n DATE_FORMAT(u.`modiff`,'%d.%m.%Y %H:%i:%s') AS `modiff_fmt`,\n (SELECT CONCAT(`lastname`,' ',`firstname`) FROM users WHERE `uid`=u.`modiff_uid`) AS `modiff_uid`,\n u.`status_id`,\n u.`lastname`,\n u.`firstname`,\n u.`middlename`,\n u.`login`,\n u.`pass`\n FROM users AS u ORDER BY `uid` DESC LIMIT 5";
if ($qry = $db->query($q)) {
eval(tmplt_gen("stat/forms/begin.form"));
eval(tmplt_gen("users/forms/filter.form"));
while ($res = $db->fetch_assoc($qry)) {
$page .= table_users($res);
}
$page .= "</table>";
$page .= "<div class='table-footer'><span class='statusbar'> </span>";
} else {
echo 'error';
}
//print_r($res);
echo $page;
$db_err = $db->error();
$db->close();
if ($db_err["error_no"] != null) {
print_r($db_err);
}
// DB-errors
$pages = ceil($index_cnt / $rows_in_page);
// Количество страниц
$query_index = "SELECT\r\n u.`uid`,\r\n DATE_FORMAT(`modiff`,'%d.%m.%Y %H:%i') AS `modiff_fmt`,\r\n (SELECT CONCAT(`lastname`,' ',`firstname`) FROM users WHERE `uid`=u.`modiff_uid`) AS `modiff_uid`,\r\n u.`status_id`,\r\n u.`lastname`,\r\n u.`firstname`,\r\n u.`middlename`,\r\n u.`login`,\r\n u.`pass`,\r\n u.`area_id`,\r\n u.`dept_id`,\r\n u.`post_id`\r\n FROM users AS u {$filter_sql} {$order_by}";
if ($page_num == 0) {
$query_index .= " LIMIT {$rows_in_page}";
} else {
$query_index .= " LIMIT " . $page_num * $rows_in_page . "," . $rows_in_page;
}
// Лимиты
//$page .= "<h3>Пользователи</h3>";
eval(tmplt_gen("forms/filter.form"));
// Форма фильтра
if ($query_index_res = $db->query($query_index)) {
if ($index_cnt > 0) {
while ($index_res = $db->fetch_assoc($query_index_res)) {
$page .= table_users($index_res);
}
} else {
$page .= "<tr><td colspan='8' class='not_found'>Не найдено записей</td></tr>";
}
$page .= "</table>";
$page .= "<div class='table-footer'><span class='statusbar'>Всего пользователей: {$index_cnt}</span>";
$page .= switch_pages("", $page_num, $pages, $filter);
// Переключатель страниц
if ($stage == "list") {
$page .= "</div><div class='buttons'>{$btn_home} <div class='right'>{$btn_show_del} {$btn_new_user}</div></div>";
} else {
$page .= "</div><div class='buttons'><div class='right'>{$btn_show_del} {$btn_new_user}</div></div>";
}
}
}
