require_once('global.php');

$uids='';

$query = $db->query("SELECT uid,regdate FROM blog_members WHERE yz>1 and regdate<'$timestamp'-604800");//86400=1天，你要几天就改这里吧：）
//如果使用注册会员审核功能，请使用下句替换上句
//$query=$db->query("SELECT m.uid,username,regdate,email,i.regreason FROM blog_members m LEFT JOIN blog_memberinfo i ON i.uid=m.uid WHERE groupid='7' and regdate<'$timestamp'-604800");

while($yzmem = $db->fetch_array($query)){
$uids .= $yzmem['uid'].',';
}

if($uids){
  $uids=substr($uids,0,-1);
  $db->update("DELETE FROM blog_msg WHERE touid IN ($uids)");//删除多余的邮件
  $db->update("DELETE FROM blog_members WHERE uid IN ($uids)");
  $db->update("DELETE FROM blog_memberdata WHERE uid IN ($uids)");
  $db->update("DELETE FROM blog_memberinfo WHERE uid IN ($uids)");
  @extract($db->get_one("SELECT count(*) AS count FROM blog_members"));
  @extract($db->get_one("SELECT username FROM blog_members ORDER BY uid DESC LIMIT 1"));
  $db->update("UPDATE blog_bbsinfo SET newmember='$username', totalmember='$count' WHERE id='1'");
}
unset($yzmem);