📄 addbb.php
字号:
<?
include "../check.php"
?>
<?
include "../sql.php"
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../nmisall.css" rel="stylesheet" type="text/css">
</head>
<body>
<?
$datetime=date("Y-m-d H:i:s",time());
//nasport数据库
$sql =sprintf("update nasport set port%s='checkbox' where nas_ip='$nasip'",$nasport);
mysql_query($sql);
//验证,防止后退后重复/
$sql ="select * from user where nas_ip='$nasip' and nas_port='$nasport'";
$result=mysql_query($sql);
if ($row=mysql_fetch_row($result))
{
echo "<script language='javascript'>";
echo 'alert("用户已存在,请更换用户！");';
echo "javascript:history.go(-2);";
echo "</script>";
}
else
{ ////////////////////////////{
$sql="insert into user (name,id,address,contact,getpassword,sales_name,status,answerques,admin_address,nas_ip,
nas_port,username,password,startdate) values ('$xm','$sfz','$dz','$lxfs','$mmda','$ywyxm','ok','$qhmmwt','$gldzxx','$nasip','$nasport','$dlmb','$dlmmb','$datetime')";
mysql_query($sql);
//写RADIUS数据库
//charge
$sql ="select * from user where nas_ip='$nasip' and nas_port='$nasport'";
$reslust=mysql_query($sql);
while ($row=mysql_fetch_row($reslust))
{$number=$row[0];
}
$sql ="select * from charge_rate where service_type='包月'";
$reslust=mysql_query($sql);
while ($row=mysql_fetch_row($reslust))
{$freeday=$row[4];//开户送的天数
$linemonth=$row[5];//最低奖励交纳月份,
$addday=$row[6];//奖励天数
}
$sess=session_name();
$sql ="select * from admin where operator='$sess'";
$reslust=mysql_query($sql);
while ($row=mysql_fetch_row($reslust))
{$opname=$row[2];
}
if($yjnyb>=$linemonth)
{
$totaldays=$yjnyb*30+$freeday+$addday;
}
else
{//$freexdays=0;
$totaldays=$yjnyb*30+$freeday;
$addday=0;
}
//$datetime=date("Y-m-d H:i:s",time());
$sql ="select * from charge where user_serialno='$number' and del=''";
$result=mysql_query($sql);
if ($row=mysql_fetch_row($result))
{
echo "<script language='javascript'>";
echo 'alert("记录已存在,添加失败!");';
echo "javascript:history.go(-1);";
echo "</script>";
}
else
{
//新记录user流水号 $number
//当前日期时间 $datetime
//init_fee $czfb
//month_fee $yfwfdjb
//months $yjnyb
//service_fee $sumb
//freeo_days $freeday
//freex_days $freexdays
//total_days $totaldays
//admin_address $gldzxx
//sales_name $ywyxm
//operator $opname
$sql="insert into charge
(user_serialno,datetime,init_fee,month_fee,months,service_fee,freeo_days,freex_days,total_days,admin_address,
sales_name,operator) values ('$number','$datetime','$czfb','$yfwfdjb','$yjnyb','$sumb','$freeday','$addday',
'$totaldays','$gldzxx','$ywyxm','$opname')";
mysql_query($sql);
//添加有效服务日期
function dadd($datejs,$addts)
{ $sql=sprintf("select DATE_ADD('%s',INTERVAL %s DAY)",$datejs,$addts);
$result=mysql_query($sql);
$t=mysql_fetch_row($result);
return $t[0];
}
$td=dadd($datetime,$totaldays);
$sql="update user set valid_date='$td' where user_serialno='$number'";
//echo var_dump($sql);
mysql_query($sql);
//echo mysql_error();
echo '<p align="center">添加成功</p>
<p> </p>
<p> </p>
<p align="center"><a href="startadd.php" class="nmisall">[返回]</a> </p>';
}
}
//更新radius库
include ("../rsql.php");
$sql="insert into radcheck (Username,Attribute,op,Value) values ('$dlmb','Password',':=','$dlmmb')";
mysql_query($sql);
$sql="insert into usergroup (UserName,GroupName) values ('$dlmb','netcore')";
mysql_query($sql);
?>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -