$sqlyj = "select pv1,num_2,year,month,day from {$db_prefix}tdpv where username='******'"; $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']) {
exit; } } 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) {
$rs1 = $db->get_one($sql1); 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");