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>"; } } }