自动删除注册10天后未激活或未通过审核会员的帐号 for pw4.3.2

Copy code

require_once('global.php');

Copy code

$uids='';
$query = $db->query("SELECT uid,regdate FROM pw_members WHERE yz>1 and regdate<'$timestamp'-864000");//86400=1天，你要几天就改这里吧：）
//如果使用注册会员审核功能，请使用下句替换上句
//$query=$db->query("SELECT m.uid,username,regdate,email,i.regreason FROM pw_members m LEFT JOIN pw_memberinfo i ON i.uid=m.uid WHERE groupid='7' and regdate<'$timestamp'-864000");
while($yzmem = $db->fetch_array($query)){
$uids .= $yzmem['uid'].',';
}
if($uids){
$uids=substr($uids,0,-1);
$db->update("DELETE FROM pw_msg WHERE touid IN ($uids)");//删除多余的邮件
$db->update("DELETE FROM pw_members WHERE uid IN ($uids)");
$db->update("DELETE FROM pw_memberdata WHERE uid IN ($uids)");
$db->update("DELETE FROM pw_memberinfo WHERE uid IN ($uids)");
@extract($db->get_one("SELECT count(*) AS count FROM pw_members"));
@extract($db->get_one("SELECT username FROM pw_members ORDER BY uid DESC LIMIT 1"));
$db->update("UPDATE pw_bbsinfo SET newmember='$username', totalmember='$count' WHERE id='1'");
}
unset($yzmem);

Quote:

引用第7楼⌒_⌒γ于2006-08-08 15:23发表的“”:
能不能弄个注册后,30内只登陆一次,未发贴的用户自动删除啊