}
}
if ($glo_sjleijipv == 1) {
$sql = "update {$db_prefix}users set bdmoney=bdmoney+'{$span_bdmoney}',bdnum=bdnum+'{$span_num}',bdnum_team=bdnum_team+'{$span_num}',pv_reg=pv_reg+'{$span_bdmoney}',pv_team_reg=pv_team_reg+'{$span_bdmoney}',pv_team_regp=pv_team_regp+'{$span_bdmoney}' where username='******'";
$db->query($sql);
$year = date("Y", $modtime);
$month = date("m", $modtime);
$day = date("d", $modtime);
editpv($year, $month, $day, trim($rr["username"]), $span_bdmoney, $span_num);
if (trim($prename)) {
$glnetupstr = "";
getglnetupstr(trim($prename));
$glnetary = explode(",", $glnetupstr);
foreach ($glnetary as $u => $u1) {
updateglnetusertdpv2($u1, $span_bdmoney, $span_num);
updateglnettdpv($year, $month, $day, $u1, $span_bdmoney, $span_num);
}
}
if (trim($tjrname)) {
$tjnetupstr = "";
gettjnetupstr(trim($tjrname));
$tjnetary = explode(",", $tjnetupstr);
foreach ($tjnetary as $u => $u1) {
updatetjnetusertdpv2($u1, $span_bdmoney);
updatetjnettdpv($year, $month, $day, $u1, $span_bdmoney);
}
}
$db->query("update {$db_prefix}users set tjbdnum=tjbdnum+'{$span_num}' where username='******' limit 1");
}
if ($glo_sjkoumoney || $glo_sjleijipv) {
$ysmemo = "后台修改" . $rr['username'] . "级别";
exit;
}
$db->query("update {$db_prefix}users set tjnum=tjnum+1 where username='******'");
}
$sql = "insert into {$db_prefix}users(username,realname,pwd,pwd1,tjrname,prename,tjstr,glstr,pos,zmdname,price,bv,bdmoney,bdnum,bdnum_team,pv_reg,pv_team_reg,pv_team_regp,rank0,rank,isdp,state,lognum,regtime,confirmtime,sex,province,city,area,mobile,postcode,address,receiver,email,idcard,bank,zhanghao,huzhu,bankaddress,fax,qq,gldept,tjdept,regusername,regrealname,regtype,timepre,tghttp,timeok,tjnet) values('" . trim($username) . "','" . trim($realname) . "','" . mymd5($pwd, "EN") . "','" . mymd5($pwd1, "EN") . "','" . trim($tjrname) . "','" . trim($prename) . "','" . $tjstr . "','" . $glstr . "','{$pos}','" . trim($zmdname) . "','{$price}','{$bv}','{$bdmoney}','{$bdnum}','{$bdnum}','{$bdmoney}','{$bdmoney}','{$bdmoney}','{$rank}','{$rank}','{$isdp}','{$regstate}','0','{$modtime}','{$confirmtime}','{$sex}','{$province}','{$city}','{$area}','{$mobile}','{$postcode}','{$address}','{$receiver}','{$email}','{$idcard}','{$bank}','{$zhanghao}','{$huzhu}','{$bankaddress}','{$fax}','{$qq}','{$gldept}','{$tjdept}','" . $_SESSION["glo_username"] . "','" . $_SESSION["glo_realname"] . "','1','{$timepre}','{$tghttp}','{$timeok}','{$tjnet}')";
$db->query($sql);
if ($bdmoney > 0) {
if ($regstate == 1) {
$db->query("update {$db_prefix}users set tjnum=tjnum+1,rfd=0,zfd=0 where username='******' limit 1");
$tjnetary = explode(",", trim($tjstr));
include "../mjjsalfecals.php";
insertintopv_1($year, $month, $day, $username, $bdmoney, $bdnum, 1);
if (trim($glstr) != '') {
$glnetary = explode(",", trim($glstr));
foreach ($glnetary as $u => $u1) {
updateglnettdpv($year, $month, $day, $u1, $bdmoney, $bdnum, 1);
}
unset($glnetary);
}
$tjnetupstr = "";
gettjnetupstr(trim($tjrname));
$tjnetary = explode(",", $tjnetupstr);
foreach ($tjnetary as $u => $u1) {
updatetjnetusertdpv2($u1, $bdmoney);
updatetjnettdpv($year, $month, $day, $u1, $bdmoney);
}
}
}
echo ' <script>alert(\'注册完成\');location.href=\'register.php?tj=';
echo $tj;
echo '\';</script>
$result = $db->query($sqlyj);
if ($db->num_rows($result) > 0) {
while ($rsyj = $db->fetch_array($result)) {
$year = $rsyj['year'];
$month = $rsyj['month'];
$day = $rsyj['day'];
$bdpv = $rsyj['pv1'];
$bdnum = $rsyj['num_2'];
if ($bdpv > 0 || $bdnum > 0) {
foreach ($glnetary as $u => $u1) {
updateglnetusertdpv2($u1, $bdpv, $bdnum);
updateglnettdpv($year, $month, $day, $u1, $bdpv, $bdnum, $rsyj['type']);
}
foreach ($oldglnetary as $u => $u1) {
updateglnetusertdpv2($u1, -$bdpv, -$bdnum);
updateglnettdpv($year, $month, $day, $u1, -$bdpv, -$bdnum, $rsyj['type']);
}
}
}
}
}
$sql5 = "select gldept from {$db_prefix}users where username='******'";
$rs5 = $db->get_one($sql5);
$gldept = $rs5['gldept'] - $rs2['gldept'];
$sql7 = "update {$db_prefix}users set prename='" . trim($tousername) . "',pos='{$pos}',gldept=gldept-'{$gldept}' where username='******'";
$db->query($sql7);
$db->query("update {$db_prefix}users set gldept=gldept-'" . $gldept . "' where find_in_set(" . $rs1['id'] . ",glstr)>0");
$sqlgx = "select glstr from {$db_prefix}users where username='******'";
$rsgx = $db->get_one($sqlgx);
if ($rsgx['glstr']) {
$glstr = $rsgx['glstr'] . "," . $rs2['id'];
if (!empty($rs1["id"])) {
die("<center>参与过结算的会员不允许删除 </center>");
}
$sqlyj = "select pv_1,num_1,year,month,day from {$db_prefix}tdpv where username='******' and pv_1>0 and type=0";
$result = $db->query($sqlyj);
if ($db->num_rows($result) > 0) {
while ($rsyj = $db->fetch_array($result)) {
$year = $rsyj['year'];
$month = $rsyj['month'];
$day = $rsyj['day'];
$glnetupstr = "";
getglnetupstr(trim($prename));
$glnetary = explode(",", $glnetupstr);
foreach ($glnetary as $u => $u1) {
updateglnetusertdpv2($u1, -$rsyj['pv_1'], -$rsyj['num_1']);
updateglnettdpv($year, $month, $day, $u1, -$rsyj['pv_1'], -$rsyj['num_1']);
}
$tjnetupstr = "";
gettjnetupstr(trim($tjrname));
$tjnetary = explode(",", $tjnetupstr);
foreach ($tjnetary as $u => $u1) {
updatetjnetusertdpv2($u1, -$rsyj['pv_1']);
updatetjnettdpv($year, $month, $day, $u1, -$rsyj['pv_1']);
}
}
}
$db->query("update {$db_prefix}users set tjnum=tjnum-1,tjbdnum=tjbdnum-'" . $bdnum . "' where username='******'");
$sql_1 = "delete from {$db_prefix}users where id='" . $id . "'";
$db->query($sql_1);
$db->query("update {$db_prefix}users set timeok=0 where state=1 order by id desc limit 1");
$sql_2 = "delete from {$db_prefix}tdpv where username='******'";
