📄 insert_opr.php
字号:
<?
require "inc/check.php";
require "inc/func.php";
require "inc/error.php";
?>
<html>
<head>
<title>"追风"--晨风创意</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; scrollbar-face-color: ffffff; scrollbar-shadow-color: C1C1BB; scrollbar-highlight-color: C1C1BB; scrollbar-3dlight-color: EBEBE4; scrollbar-darkshadow-color: EBEBE4; scrollbar-track-color: F4F4F0; scrollbar-arrow-color: CACAB7
}
P {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
INPUT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FONT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
SELECT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
OPTION {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TEXTAREA {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FORM {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TD {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; TABLE-LAYOUT: fixed; WORD-BREAK: break-all
}
A:link {
TEXT-DECORATION: none
}
A:visited {
TEXT-DECORATION: none
}
A:hover {
TEXT-DECORATION: underline
}
A:active {
FONT-SIZE: 12px; TEXT-DECORATION: none
}
.border {
BACKGROUND-COLOR: #efefef; BORDER-BOTTOM: 1px dotted; BORDER-COLLAPSE: collapse; BORDER-LEFT: 1px dotted; BORDER-RIGHT: 1px dotted; BORDER-TOP: 1px dotted; COLOR: #000000
}
.shadow1 {
COLOR: #ffffff; FILTER: dropshadow(color=#000000,offx=1,offy=1); FONT-SIZE: 12px
}
.shadow2 {
COLOR: #000000; FILTER: dropshadow(color=#d5d5d5,offx=1,offy=1); FONT-SIZE: 12px
}
.p1 {
COLOR: #ffffff; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p2 {
COLOR: #000000; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p3 {
COLOR: #004080; FONT-SIZE: 14px; TEXT-DECORATION: none
}
</STYLE>
<?
$sqldo1="insert into baseact values(baseactact_id.nextval,'新闻提交','')";
$sqldo2="insert into baseact values(baseactact_id.nextval,'新闻修改','')";
$sqldo3="insert into baseact values(baseactact_id.nextval,'新闻发布','')";
$sqldo4="insert into baseact values(baseactact_id.nextval,'导读制作','')";
$sqldo5="insert into baseact values(baseactact_id.nextval,'专题管理','')";
$sqldo6="insert into baseact values(baseactact_id.nextval,'专题制作','')";
$sqldo7="insert into baseact values(baseactact_id.nextval,'专题导读','')";
$sqldo8="insert into baseact values(baseactact_id.nextval,'栏目管理','')";
$sqldo9="insert into baseact values(baseactact_id.nextval,'用户管理','')";
$sqldo10="insert into baseact values(baseactact_id.nextval,'会员管理','')";
$sqldo11="insert into baseact values(baseactact_id.nextval,'日志管理','')";
$sqldo12="insert into baseact values(baseactact_id.nextval,'考核管理','')";
$sqldo13="insert into baseact values(baseactact_id.nextval,'模板管理','')";
$sqldo14="insert into baseact values(baseactact_id.nextval,'投稿人管理','')";
$sqldo15="insert into baseact values(baseactact_id.nextval,'系统设置','')";
$sqldo16="insert into baseact values(baseactact_id.nextval,'栏目导读','')";
$sqldo17="insert into baseact values(baseactact_id.nextval,'专题导读','')";
$i=1;
$sqldo="delete from baseclass where class_name='222'";
if($cla->db_delete($sqldo)){
echo $sqldo;
$cla->db_commit();
}
if($sub){ //如果是增加一个用户
if($login_name=="")
{
show_msg("用户名不可为空！");
}
$sqldo="select user_id from wateruser where login_name='$login_name'";
// $result=mysql_query($sqldo);
$result_array=$cla->db_query($sqldo);
//while($result_array=mysql_fetch_array($result)){
if($result_array[0][0]<>"")
{
show_msg("该登录名已经存在,请换名！");exit;
}
if(check_emp($real_name))
{
show_msg("真实姓名不可为空！");
}
if(check_emp($login_password)||check_emp($login_password2))
{
show_msg("密码不可为空！");
}
if(($user_email<>"")and(!eregi("^[_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,3}$",$user_email))){
show_msg("邮箱错误！");
}
if(md5($login_password)<>md5($login_password2))
{
show_msg("密码不一致！");
}
if(check_emp($right_level))
{
show_msg("权限级别不可为空！");
}
$login_password=md5($login_password);
$group_id_user="";
$operate_right_user="";
$class_right_user="";
$special_right_user="";
if($sel_groupname<>""){
//获取组号
$group_id_user=$sel_groupname;
//获取所在组的操作权限
if(trim($right_level)=="组长"){
$sqldo_in="select operate_right from groups where group_id='$sel_groupname'";
$userful_in=$cla->db_query($sqldo_in);
$operate_right_user=$operate_right_user.$userful_in[0][0];
}
//获得所在组的栏目权限
if(trim($right_level)=="组长"){
$sqldo_in="select class_right from groups where group_id='$sel_groupname'";
$userful_in=$cla->db_query($sqldo_in);
$class_right_user=$class_right_user.$userful_in[0][0];
}
}
$sqldo="insert into wateruser(user_id,login_name,real_name,login_password,email,group_id,right_level,operate_right,class_right,special_right,user_description) values(wateruseruser_id.nextval,'$login_name','$real_name','$login_password','$user_email','$group_id_user','$right_level','$operate_right_user','$class_right_user','$special_right_user','$user_description')";
echo $sqldo;
// if(mysql_query($sqldo)){
if($cla->db_insert($sqldo)){
$cla->db_commit();
show_msg("新用户 ".$real_name." 添加成功！");
}
else{
show_msg(" 意外错误 <br> 添加失败！");
}
}
?>
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
<body bgcolor="#FFFFFF">
<center>
<div align="center">
<table width="100%" border="0" height="95" >
<tr>
<td height="383" width="5%">
<p> </p>
<p> </p>
</td>
<td height="383" width="16%" valign="top">
<table border=1 bordercolor=#111111 cellpadding=3 cellspacing=0
class=border width="85%" height="257">
<tbody>
<tr>
<td bgcolor=#efefef width="100%">
<div align="center"><img src="images/list.gif" width="16" height="16">
控制面板</div>
</td>
</tr>
<tr>
<td align=middle class=shadow2 height=230 valign=top
width="100%">
<div align="center">
<p><br>
</p>
<p><img src="images/edit.gif" width="18" height="13"> <a href="add_grp.php" >增
加 新 组</a></p>
<p><br>
<img src="images/edit.gif" width="18" height="13"> <a href="add_usr.php" >增
加 成 员</a></p>
<p><br>
<img src="images/edit.gif" width="18" height="13"> <a href="user_mag_view.php">查
看 某 组</a></p>
<p><br>
<img src="images/edit.gif" width="18" height="13"> <a href="user_view.php" target="_self">查
看 成 员</a><br>
<br>
<br>
<br>
</p>
</div>
</td>
</tr>
</tbody>
</table>
</td>
<td width="80%" height="140" valign="top">
<form name="form1" method="post" action="add_usr.php?sub=1" onSubmit="return checkblank()">
<table width="97%" border="2" cellspacing="0" cellpadding="3" bordercolor="#111111" class=border>
<tr bgcolor="#f7f7f7">
<td colspan="2">
<div align="center">
<p> </p>
<p><font size="4"><b>增加用户</b></font> </p>
<p> </p>
</div>
</td>
</tr>
<tr bgcolor="#f7f7f7">
<td width="24%">
<div align="right">登录名：</div>
</td>
<td width="76%">
<input type="text" name="login_name" class="border" size="20">
（*）</td>
</tr>
<tr>
<td width="24%">
<div align="right">真实姓名：</div>
</td>
<td width="76%">
<input type="text" name="real_name" class="border" size="20">
（*）</td>
</tr>
<tr bgcolor="#f7f7f7">
<td width="24%">
<div align="right">密码：</div>
</td>
<td width="76%">
<input type="password" name="login_password" class="border" size="20">
（*） </td>
</tr>
<tr>
<td width="24%">
<div align="right">确认密码：</div>
</td>
<td width="76%">
<input type="password" name="login_password2" class="border" size="20">
（*）</td>
</tr>
<tr bgcolor="#f7f7f7">
<td width="24%">
<div align="right">邮箱：</div>
</td>
<td width="76%">
<input type="text" name="user_email" class="border" size="20">
</td>
</tr>
<tr>
<td width="24%" height="23">
<div align="right">所加入组：</div>
</td>
<td width="76%" height="23">
<select name="sel_groupname">
<option value=""> </option>
<?
$sqldo="select group_id,group_name from groups";
$group=$cla->db_query($sqldo);
$i=0;
while($group[$i][0]){
?>
<option value="<? echo $group[$i]['GROUP_ID']; ?>">
<? echo $group[$i]['GROUP_NAME']; ?>
</option>
<? $i++;}
?>
</select>
</td>
<tr bgcolor="#f7f7f7">
<td width="24%">
<div align="right">权限级别：</div>
</td>
<td width="76%">
<select name="right_level">
<option value="录入员" selected >录入员</option>
<option value="组长">组长 </option>
<option value="管理员">管理员</option>
</select>
（*）</td>
</tr>
<tr>
<td width="24%">
<div align="right">备注：</div>
</td>
<td width="76%">
<input type="text" name="user_description" class="border" size="60">
</td>
</tr>
<tr bgcolor="#f7f7f7">
<td width="24%">
<p> </p>
<p> </p>
</td>
<td width="76%">
<div align="center"><font size="2">注：带（*）为必填项</font></div>
</td>
</tr>
</table>
<p align="center">
<input type="submit" name="sub" value="确定" >
<input type="reset" name="Submit32" value="重置">
</p>
</form>
</td>
</tr>
</table>
</div>
<p> </p>
</center>
<hr size="1" noshade width="100%">
<div align="center">
Copyright © 2002 - 2002 Waterinfo.net.cn, TianJinU TianQin.
All Rights Reserved 龙网公司 天大天勤 版权所有<br>
<p> </p>
</div>
<SCRIPT language="JavaScript">
<!--
function checkblank()
{
if(form1.login_name.value=="") {
alert("登录名不可为空！")
form1.login_name.focus()
return false
}
if(document.form1.real_name.value==""){
alert("真实姓名不可为空！")
form1.real_name.focus()
return false
}
if(document.form1.login_password.value==""||document.form1.login_password2.value==""){
alert("密码不可为空！")
form1.login_password.focus()
return false
}
if(document.form1.login_password.value!=document.form1.login_password2.value){
alert("密码不一致！")
form1.login_password.focus()
return false
}
if(document.form1.right_level.value==""){
alert("权限级别不可为空！")
form1.right_level.focus()
return false
}
}
-->
</SCRIPT>
<? $cla->db_logoff();?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -