$sql = "update {$tbl_columns} set sort_order={$less_sort_order} where id = {$id}";
$db->Execute($sql);
}
} else {
$sql = "select sort_order from {$tbl_columns} where id = {$id}";
$sort_order = $db->GetOne($sql);
$sql = "select sort_order from {$tbl_columns} where sort_order>{$sort_order} and pcatalog={$pid} order by sort_order limit 1";
$less_sort_order = $db->GetOne($sql);
if ($less_sort_order) {
$sql = "update {$tbl_columns} set sort_order={$sort_order} where sort_order={$less_sort_order} and pcatalog={$pid}";
$db->Execute($sql);
$sql = "update {$tbl_columns} set sort_order={$less_sort_order} where id = {$id}";
$db->Execute($sql);
}
}
frame_redirection("mainFrame", "control.php?act=catalog_list&pcatalog_id={$pid}");
} else {
alert("未定义操作！");
exit;
}
}
}
}
}
function catalog_delete($id)
{
global $cfg;
global $db;
$tbl_columns = $cfg['tbl_columns'];
$tbl_article = $cfg['tbl_article'];
$sql = "select id from {$tbl_columns} where pcatalog = {$id}";
}
if (!$sql1) {
$db->CommitTrans();
frame_redirection("mainFrame", "control.php?act=browse_catalog&catalog_id=" . $_GET['catalog_id']);
exit;
} else {
if ($db->Execute($sql1)) {
$db->CommitTrans();
alert("文章更新成功！");
} else {
$db->RollbackTrans();
alert("文章更新失败！");
exit;
}
}
frame_redirection("mainFrame", "control.php?act=browse_catalog&catalog_id=" . $_GET['catalog_id']);
}
}
} else {
if ($cmd == "publish") {
$db->BeginTrans();
article_operation("status = 1", "文章发布成功", "文章发布失败");
} else {
if ($cmd == "unpublish") {
$db->BeginTrans();
article_operation("status = 0", "文章取消发布成功", "文章取消发布失败");
} else {
if ($cmd == "delete") {
$db->BeginTrans();
$cause = " ( 0";
$article_ids = explode(',', $_GET['article_id']);
$_POST['password'] = MD5($_POST['password']);
$sql = "select * from {$tbl_user} where id = 0";
$rs = $db->Execute($sql);
if (!isset($_POST['lock_flag'])) {
$_POST['lock_flag'] = "0";
}
unset($_POST['id']);
$sql = $db->GetInsertSQL($rs, $_POST);
if (!$sql) {
alert("没有任何改动");
frame_redirection("mainFrame", "control.php?act=user_manage&cmd=list");
exit;
}
if ($db->Execute($sql)) {
alert("用户添加成功！");
frame_redirection("mainFrame", "control.php?act=user_manage&cmd=list");
} else {
alert("用户添加失败！");
}
}
} else {
if ($cmd == "delete") {
$cause = " ( 0";
$user_ids = explode(',', $_GET['uid']);
foreach ($user_ids as $id) {
$id = intval($id);
$cause = $cause . " or id = " . $id;
}
$cause = $cause . ")";
$sql = "delete from {$tbl_user} where {$cause}";
if ($db->Execute($sql)) {
