function admin_DelMember_all($userid, $logininid, $loginin)
{
global $empire, $user_tablename, $user_username, $user_userid, $dbtbpre, $level_r, $user_group;
CheckLevel($logininid, $loginin, $classid, "member");
//验证权限
$count = count($userid);
if (!$count) {
printerror("NotDelMemberid", "history.go(-1)");
}
$dh = "";
for ($i = 0; $i < $count; $i++) {
$euid = (int) $userid[$i];
//删除短信息
$ur = $empire->fetch1("select " . $user_username . "," . $user_group . " from " . $user_tablename . " where " . $user_userid . "='" . $euid . "'");
if (empty($ur[$user_username])) {
continue;
}
$dousername = doUtfAndGbk($ur[$user_username], 1);
//删除附加表
$fid = GetMemberFormId($ur[$user_group]);
DoDelMemberF($fid, $euid, $dousername);
$del = $empire->query("delete from {$dbtbpre}enewsqmsg where to_username='******'");
//集合
$inid .= $dh . $euid;
$dh = ",";
}
if (empty($inid)) {
printerror("NotDelMemberid", "history.go(-1)");
}
$add = $user_userid . " in (" . $inid . ")";
$adda = "userid in (" . $inid . ")";
$sql = $empire->query("delete from " . $user_tablename . " where " . $add);
//删除收藏
$del = $empire->query("delete from {$dbtbpre}enewsfava where " . $adda);
$del = $empire->query("delete from {$dbtbpre}enewsfavaclass where " . $adda);
//删除购买记录
$del = $empire->query("delete from {$dbtbpre}enewsbuybak where " . $adda);
//删除下载记录
$del = $empire->query("delete from {$dbtbpre}enewsdownrecord where " . $adda);
//删除好友记录
$del = $empire->query("delete from {$dbtbpre}enewshy where " . $adda);
$del = $empire->query("delete from {$dbtbpre}enewshyclass where " . $adda);
//删除留言
$del = $empire->query("delete from {$dbtbpre}enewsmembergbook where " . $adda);
//删除反馈
$del = $empire->query("delete from {$dbtbpre}enewsmemberfeedback where " . $adda);
if ($sql) {
insert_dolog("");
//操作日志
printerror("DelMemberSuccess", "ListMember.php");
} else {
printerror("DbError", "history.go(-1)");
}
}
function admin_ClearMember($add, $logininid, $loginin)
{
global $empire, $user_tablename, $user_username, $user_userid, $dbtbpre, $level_r, $user_group, $user_email, $user_checked, $user_registertime, $user_register, $user_group, $user_userfen, $user_money;
CheckLevel($logininid, $loginin, $classid, "member");
//验证权限
//变量处理
$username = RepPostVar($add['username']);
$email = RepPostStr($add['email']);
$startuserid = (int) $add['startuserid'];
$enduserid = (int) $add['enduserid'];
$groupid = (int) $add['groupid'];
$startregtime = RepPostVar($add['startregtime']);
$endregtime = RepPostVar($add['endregtime']);
$startuserfen = (int) $add['startuserfen'];
$enduserfen = (int) $add['enduserfen'];
$startmoney = (int) $add['startmoney'];
$endmoney = (int) $add['endmoney'];
$checked = (int) $add['checked'];
$where = '';
if ($username) {
$where .= " and " . $user_username . " like '%{$username}%'";
}
if ($email) {
$where .= " and " . $user_email . " like '%{$email}%'";
}
if ($enduserid) {
$where .= ' and ' . $user_userid . ' BETWEEN ' . $startuserid . ' and ' . $enduserid;
}
if ($groupid) {
$where .= " and " . $user_group . "='{$groupid}'";
}
if ($startregtime && $endregtime) {
if ($user_register) {
$startregtime = to_time($startregtime);
$endregtime = to_time($endregtime);
}
$where .= " and " . $user_registertime . ">='{$startregtime}' and " . $user_registertime . "<='{$endregtime}'";
}
if ($enduserfen) {
$where .= ' and ' . $user_userfen . ' BETWEEN ' . $startuserfen . ' and ' . $enduserfen;
}
if ($endmoney) {
$where .= ' and ' . $user_money . ' BETWEEN ' . $startmoney . ' and ' . $endmoney;
}
if ($checked) {
$checkval = $checked == 1 ? 1 : 0;
$where .= " and " . $user_checked . "='{$checkval}'";
}
if (!$where) {
printerror("EmptyClearMember", "history.go(-1)");
}
$where = substr($where, 5);
$sql = $empire->query("select " . $user_userid . "," . $user_username . "," . $user_group . " from " . $user_tablename . " where " . $where);
$dh = '';
$inid = '';
while ($r = $empire->fetch($sql)) {
$euid = $r[$user_userid];
//删除短信息
$dousername = doUtfAndGbk($r[$user_username], 1);
//删除附加表
$fid = GetMemberFormId($r[$user_group]);
DoDelMemberF($fid, $euid, $dousername);
$empire->query("delete from {$dbtbpre}enewsqmsg where to_username='******'");
//集合
$inid .= $dh . $euid;
$dh = ',';
}
if ($inid) {
$addw = $user_userid . " in (" . $inid . ")";
$addaw = "userid in (" . $inid . ")";
$sql = $empire->query("delete from " . $user_tablename . " where " . $addw);
//删除收藏
$del = $empire->query("delete from {$dbtbpre}enewsfava where " . $addaw);
$del = $empire->query("delete from {$dbtbpre}enewsfavaclass where " . $addaw);
//删除购买记录
$del = $empire->query("delete from {$dbtbpre}enewsbuybak where " . $addaw);
//删除下载记录
$del = $empire->query("delete from {$dbtbpre}enewsdownrecord where " . $addaw);
//删除好友记录
$del = $empire->query("delete from {$dbtbpre}enewshy where " . $addaw);
$del = $empire->query("delete from {$dbtbpre}enewshyclass where " . $addaw);
//删除留言
$del = $empire->query("delete from {$dbtbpre}enewsmembergbook where " . $addaw);
//删除反馈
$del = $empire->query("delete from {$dbtbpre}enewsmemberfeedback where " . $addaw);
}
insert_dolog("");
//操作日志
printerror("DelMemberSuccess", "ClearMember.php");
}
