$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'];
} else {
$glstr = $rs2['id'];
}
$sqlgx1 = "update {$db_prefix}users set glstr='" . trim($glstr) . "' where username='******'";
$db->query($sqlgx1);
$sqlxj = "select * from {$db_prefix}users where find_in_set('" . $rs1['id'] . "',glstr)>0";
$resultxj = $db->query($sqlxj);
while ($rsxj = $db->fetch_array($resultxj)) {
$glnetupstr = "";
$newglstr = '';
getglnetupstr($rsxj['prename']);
$glnetary = explode(",", $glnetupstr);
foreach ($glnetary as $u => $u1) {
$sqlt = "select id from {$db_prefix}users where username='******'";
$rst = $db->get_one($sqlt);
if ($newglstr != '') {
$newglstr = $rst['id'] . ',' . $newglstr;
} else {
$newglstr = $rst['id'];
}
}
$sqlgx1 = "update {$db_prefix}users set glstr='" . trim($newglstr) . "' where id='" . $rsxj['id'] . "'";
$db->query($sqlgx1);
}
$db->free_result($resultxj);
$log_adminid = $_SESSION["glo_adminid"];
} else {
$hint = "该会员没有足够的电子货币！请先补足电子货币后再升级.";
echo "<script>alert('" . $hint . "');history.back();</script>";
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);
}
}
function getglnetupstr($username)
{
global $db, $db_prefix, $glnetupstr;
$sql = "select id,username,prename from {$db_prefix}users where username='******' limit 1";
$rs = $db->get_one($sql);
if ($rs['id']) {
if ($glnetupstr != "") {
$glnetupstr .= ",";
}
$glnetupstr .= $rs["username"];
if (!empty($rs["prename"])) {
getglnetupstr($rs["prename"]);
}
}
}