admin_privilege_valid('db_optimize.php', 'optimize');
/* 所有数据表的信息*/
$tables = $db->getCol("SHOW TABLE STATUS");
foreach ($tables as $table) {
if ($row = $db->getRow("OPTIMIZE TABLE `{$table}`")) {
/* 优化出错，尝试修复 */
if ($row['Msg_type'] == 'error' && strpos($row['Msg_text'], 'repair') !== false) {
$db->query("REPAIR TABLE `{$table}`");
}
}
}
/* 返回 */
make_json_ok(admin_privilege_name_fk('db_optimize.php', 'optimize') . $_LANG['msg_ok']);
} else {
/* 权限检查 */
admin_privilege_valid('db_optimize.php', 'optimize');
/* 所有数据表的信息 */
$tables = $db->getAll('SHOW TABLE STATUS');
/* 数据表的信息 - 数据格式化 */
$tpl['all'] = array();
$tpl['stat'] = array('chip' => 0, 'row' => 0, 'size' => 0, 'table' => 0);
foreach ($tables as $table) {
if (strtoupper($table['Engine']) == 'MEMORY') {
$check['Msg_text'] = 'Ignore';
$table['Data_free'] = '0';
} else {
$check = $db->GetRow("CHECK TABLE `{$table['Name']}`");
$tpl['stat']['rows'] += $table['Rows'];
$tpl['stat']['chip'] += $table['Data_free'];
$tpl['stat']['size'] += $table['Data_length'];
$tpl['stat']['table'] += 1;
$sql = 'SELECT ' . $fields['sql'] . ' FROM ' . tname('admin') . ' LEFT JOIN ' . tname('role') . ' USING(role_id) WHERE';
$sql .= admin_id() == 1 ? ' (' . tname('admin') . '.role_id = 0' : ' 1<>1';
$sql .= ' OR (' . tname('role') . '.lft>' . $_PRIV['role']['lft'];
$sql .= ' AND ' . tname('role') . '.rht<' . $_PRIV['role']['rht'] . '))';
if ($_GET['limit'] == 'choice') {
if (is_string($_GET['ids']) || $_GET['ids'] != '') {
$sql .= ' AND admin_id IN("' . implode('","', explode(',', $_GET['ids'])) . '")';
} else {
$sql .= ' LIMIT 0,0';
}
}
/* 导出数据 */
list_export('admin.csv', $db->getAll($sql));
} else {
/* 权限检查 */
admin_privilege_valid('admin.php', 'list');
/* 取得管理员的非增加、列表操作 */
$m_aa = admin_module_acts('admin.php');
$m_ac = filter_module_acts($m_aa, array('add', 'list'), false);
/* 管理员列表(子级管理员) - 如果是当前管理员ID为1，则列出所有无角色的管理员 */
$tpl['list'] = list_admin(array('role_info' => $_PRIV['role']));
/* 管理员列表 - 数据重构，绑定操作权限 */
foreach ($tpl['list']['data'] as $i => $r) {
/* 编辑操作 */
$attribs = array();
$attribs['edit']['onclick'] = "wnd_admin_fill(this,'edit',{$r[admin_id]})";
/* 删除操作 */
$attribs['del']['onclick'] = "ListTable.del(this,{$r[admin_id]},'";
$attribs['del']['onclick'] .= f(sprintf($_LANG['spr_confirm_del'], $r['name']), 'hstr') . "')";
/* 绑定操作 */
$tpl['list']['data'][$i]['acts'] = format_module_acts($m_ac, $attribs, 'a');
/* 权限检查 */
admin_privilege_valid('db_backup.php', 'backup');
/* 初始化参数 */
$_POST['ids'] = is_array($_POST['ids']) ? $_POST['ids'] : array();
/* 删除SQL文件 */
foreach ($_POST['ids'] as $findex) {
/* 根据索引获取所有SQL文件 */
$fnames = all_sqlfile(array('findex' => $findex));
foreach ($fnames as $fname) {
@unlink($_CFG['DIR_ADMIN_DUMPSQL'] . $fname);
}
}
make_json_ok();
} else {
/* 权限检查 */
admin_privilege_valid('db_backup.php', 'backup');
/* 备份文件夹权限检查 */
valid_dbbackup_folder();
/* SQL文件列表 - 数据格式化 */
$tpl['all'] = all_sqlfile();
/* 初始化页面信息 */
$tpl['_body'] = 'index';
/* ------------------------------------------------------ */
// - 异步 - 列表页，列表查询
/* ------------------------------------------------------ */
if ($_REQUEST['act'] == 'list') {
/* 初始化页面信息 */
$tpl['_body'] = 'list';
/* 列表查询 */
if ($_REQUEST['actsub'] == 'query') {
/* 初始化页面信息 */
/* 权限检查 */
admin_privilege_valid('sysmodule.php', 'myaccount');
/* 数据提取 */
$fields = post_myaccount();
/* 更新数据库 */
if (!empty($fields)) {
/* 更新数据库 */
$db->update(tname('admin'), $fields, 'admin_id=' . admin_id());
/* 系统提示 */
make_json_ok($_LANG['ok_myaccount_upassword']);
}
/* 系统提示 */
make_json_ok();
} else {
/* 权限检查 */
admin_privilege_valid('sysmodule.php', 'myaccount');
/* 管理员信息 */
$tpl['info'] = info_admin(array('admin_id' => admin_id()));
}
/* 加载视图 */
include $_CFG['DIR_ADMIN_TPL'] . 'myaccount.html';
?>
<?php
/**
* 取得POST过来的帐号字段
*/
function post_myaccount()
{
global $_LANG;
/* 基本字段提取 */
admin_privilege_valid('role.php', 'list');
/* 上级角色信息 */
$info_p = info_role(array('role_id' => $_GET['prole_id']));
/* 允许获取权限表检查 */
allow_privtable($info_p);
/* 角色权限IDS */
$role_priv_ids = all_role_privilege_id(array('role_id' => $info_p['role_id']));
/* 角色权限表 */
if (empty($role_priv_ids)) {
exit('<div class="tips-div"><span>' . $_LANG['str_role_nopriv'] . '</span></div>');
} else {
exit(html_privilege_table('privilege_ids', '', $role_priv_ids));
}
} else {
/* 权限检查 */
admin_privilege_valid('role.php', 'list');
/* 取得管理员的非增加、列表操作 */
$m_aa = admin_module_acts('role.php');
$m_ac = filter_module_acts($m_aa, array('add', 'list'), false);
array_unshift($m_ac, array('module_act_name' => $_LANG['act_dmove'], 'module_act_code' => 'dmove'));
array_unshift($m_ac, array('module_act_name' => $_LANG['act_umove'], 'module_act_code' => 'umove'));
/* 角色列表，小于当前管理员角色的角色 */
$tpl['all'] = sub_role(array('info' => $_PRIV['role']), false);
/* 角色列表 - 数据重构，绑定操作权限 */
foreach ($tpl['all'] as $i => $r) {
$tpl['all'][$i]['pre'] = '<span class="';
$tpl['all'][$i]['pre'] .= ($r['lvl'] == 1 && $r['rht'] - $r['lft'] > 1 ? 'plus' : 'minus') . '" style="';
$tpl['all'][$i]['pre'] .= $r['rht'] - $r['lft'] > 1 ? 'cursor:pointer;' : '';
$tpl['all'][$i]['pre'] .= 'margin-left:' . intval($r['lvl'] - $tpl['all'][0]['lvl']) * 2 . 'em;" ';
$tpl['all'][$i]['pre'] .= 'onclick="tabletree_click(this)"></span>';
/* 编辑操作 */
$tpl['all'][$i]['pre'] .= $r['rht'] - $r['lft'] > 1 ? 'cursor:pointer;' : '';
$tpl['all'][$i]['pre'] .= 'margin-left:' . intval($r['lvl'] - $tpl['all'][0]['lvl']) * 2 . 'em;" ';
$tpl['all'][$i]['pre'] .= 'onclick="tabletree_click(this)"></span>';
/* 编辑操作 */
$attribs = array();
$attribs['edit']['onclick'] = "wnd_module_fill(this,'edit',{$r[module_id]})";
/* 上/下移操作 */
$attribs['umove']['onclick'] = "deal_tbltr_move(this,'up',{$r[module_id]},'modules/kernel/module.php')";
$attribs['dmove']['onclick'] = "deal_tbltr_move(this,'down',{$r[module_id]},'modules/kernel/module.php')";
/* 增加操作 */
if ($r['lft'] != $r['rht'] - 1) {
$attribs['add']['onclick'] = "wnd_module_fill(this,'add',{$r[module_id]})";
$tpl['all'][$i]['acts'] = format_module_acts($m_ab, $attribs, 'a');
}
/* 权限搜索操作 */
if ($r['lft'] == $r['rht'] - 1 && admin_privilege_valid('privilege.php', 'list', false)) {
$tpl['all'][$i]['acts'] .= "<a href=\"javascript:void(0)\" onclick=\"module_mtree_request('modules/kernel/privilege.php?act=index&module_id={$r[module_id]}";
$tpl['all'][$i]['acts'] .= "',{'reload':true,'complete':function(){ListTable.init('listtable-privilege','modules/kernel/privilege.php','?act=list');";
$tpl['all'][$i]['acts'] .= "ListTable.filter('module_id','{$r[module_id]}')}})\">" . $_LANG['act_priv'] . '</a> ';
}
/* 删除操作 */
$attribs['del']['onclick'] = $r['lft'] == $r['rht'] - 1 ? "ListTable.del(this,{$r[module_id]},'" . f(sprintf($_LANG['spr_confirm_del'], $r['name']), 'hstr') . "')" : "wnd_alert('{$_LANG[warn_module_dels]}'); return false;";
/* 绑定操作 */
$tpl['all'][$i]['acts'] .= format_module_acts($m_ac, $attribs, 'a');
}
/* 初始化页面信息 */
$tpl['_body'] = 'list';
/* ------------------------------------------------------ */
// - 异步 - 列表页，列表查询
/* ------------------------------------------------------ */
if ($_REQUEST['act'] == 'list') {
