그누보드 및 영카트 회원삭제관련 #

//회원삭제
//http://gnustudy.com/bbs/board.php?bo_table=gnu_tip&wr_id=104
functionmember_delete($mb_id)
{
global$config;
global$g5;
  
$sql="selectmb_name,mb_nick,mb_ip,mb_recommend,mb_memo,mb_levelfrom{$g5['member_table']}wheremb_id='".$mb_id."'";
$mb=sql_fetch($sql);
  
//이미삭제된회원은제외
//if(preg_match('#^[0-9]{8}.*삭제함#',$mb['mb_memo']))
//return;
  
if($mb['mb_recommend']){
$row=sql_fetch("selectcount(*)ascntfrom{$g5['member_table']}wheremb_id='".addslashes($mb['mb_recommend'])."'");
if($row['cnt'])
insert_point($mb['mb_recommend'],$config['cf_recommend_point']*(-1),$mb_id.'님의회원자료삭제로인한추천인포인트반환',"@member",$mb['mb_recommend'],$mb_id.'추천인삭제');
}
  
//회원자료는정보만없앤후아이디는보관하여다른사람이사용하지못하도록함:061025
//$sql="update{$g5['member_table']}setmb_password='',mb_level=1,mb_email='',mb_homepage='',mb_tel='',mb_hp='',mb_zip1='',mb_zip2='',mb_addr1='',mb_addr2='',mb_birth='',mb_sex='',mb_signature='',mb_memo='".date('Ymd',G5_SERVER_TIME)."삭제함\n{$mb['mb_memo']}'wheremb_id='{$mb_id}'";
//sql_query($sql);
//회원삭제20190930원래는삭제가안되는데삭제하게만듦
/*
*글쓰기하셔도회원목록에서삭제가안되고탈퇴회원으로처리가되요
*이유는재가입방지(이전아이디글슬경우)기타등등문제사유가되기때문에
*탈퇴회원으로처리되지삭제하려면따로작업하셔야합니다.
*/
sql_query("update{$g5['member_table']}setmb_leave_date=now()wheremb_id='$mb_id'");
  
//포인트테이블에서삭제
sql_query("deletefrom{$g5['point_table']}wheremb_id='$mb_id'");
  
//그룹접근가능삭제
sql_query("deletefrom{$g5['group_member_table']}wheremb_id='$mb_id'");
  
//쪽지삭제
sql_query("deletefrom{$g5['memo_table']}whereme_recv_mb_id='$mb_id'orme_send_mb_id='$mb_id'");
  
//스크랩삭제
sql_query("deletefrom{$g5['scrap_table']}wheremb_id='$mb_id'");
  
//관리권한삭제
sql_query("deletefrom{$g5['auth_table']}wheremb_id='$mb_id'");
  
//그룹관리자인경우그룹관리자를공백으로
sql_query("update{$g5['group_table']}setgr_admin=''wheregr_admin='$mb_id'");
  
//게시판관리자인경우게시판관리자를공백으로
sql_query("update{$g5['board_table']}setbo_admin=''wherebo_admin='$mb_id'");
  
//소셜로그인에서삭제또는해제
if(function_exists('social_member_link_delete')){
social_member_link_delete($mb_id);
}
  
//아이콘삭제
@unlink(G5_DATA_PATH.'/member/'.substr($mb_id,0,2).'/'.$mb_id.'.gif');
  
//프로필이미지삭제
@unlink(G5_DATA_PATH.'/member_image/'.substr($mb_id,0,2).'/'.$mb_id.'.gif');
}