$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)) {