'; echo 'parent.$("#modal-login").modal();'; echo ''; exit; } if (!$R['uid']) exit; if ($d['post']['denylikemy'] && ($R['mbruid']==$my['uid'])) getLink('','','자신 글은 평가할 수 없습니다.',''); } $mbruid = $my['uid']; $check_like_qry = "mbruid='".$mbruid."' and module='".$m."' and entry='".$uid."' and opinion='like'"; $check_dislike_qry = "mbruid='".$mbruid."' and module='".$m."' and entry='".$uid."' and opinion='dislike'"; $is_liked = getDbRows($table['s_opinion'],$check_like_qry); $is_disliked = getDbRows($table['s_opinion'],$check_dislike_qry); // 로그인한 사용자가 좋아요를 했는지 여부 체크하여 처리 if ($opinion=='like') { $opinion_type = '좋아요'; if($is_liked){ // 좋아요를 했던 경우 $opinion_act = '취소'; $OP = getDbData($table['s_opinion'],$check_like_qry,'*'); getDbDelete($table['s_opinion'],$check_like_qry); getDbUpdate($table[$m.'data'],'likes=likes-1','uid='.$uid); getDbUpdate($table['s_mbrdata'],'likes_post=likes_post-1','memberuid='.$R['mbruid']); getDbUpdate($table['s_mbrmonth'],'post_likes=post_likes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 월별 조회수 갱신 getDbUpdate($table['s_mbrday'],'post_likes=post_likes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 일별조회수 갱신 getDbUpdate($table[$m.'month'],'likes=likes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and data='.$R['uid']); //포스트별 월별 좋아요수 갱신 getDbUpdate($table[$m.'day'],'likes=likes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and data='.$R['uid']); //포스트별 일별 좋아요수 갱신 }else{ // 좋아요 안한 경우 추가 $opinion_act = '추가'; $QKEY = "mbruid,module,entry,opinion,d_regis"; $QVAL = "'$mbruid','$m','$uid','like','".$date['totime']."'"; getDbInsert($table['s_opinion'],$QKEY,$QVAL); getDbUpdate($table[$m.'data'],'likes=likes+1','uid='.$uid); getDbUpdate($table['s_mbrdata'],'likes_post=likes_post+1','memberuid='.$R['mbruid']); getDbUpdate($table['s_mbrmonth'],'post_likes=post_likes+1',"date='".$date['month']."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 월별 조회수 갱신 getDbUpdate($table['s_mbrday'],'post_likes=post_likes+1',"date='".$date['today']."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 일별조회수 갱신 getDbUpdate($table[$m.'month'],'likes=likes+1',"date='".$date['month']."' and site=".$s.' and data='.$R['uid']); //포스트별 월별 좋아요수 갱신 getDbUpdate($table[$m.'day'],'likes=likes+1',"date='".$date['today']."' and site=".$s.' and data='.$R['uid']); //포스트별 일별 좋아요수 갱신 if ($is_disliked) { $OP = getDbData($table['s_opinion'],$check_dislike_qry,'*'); getDbDelete($table['s_opinion'],$check_dislike_qry); getDbUpdate($table[$m.'data'],'dislikes=dislikes-1','uid='.$uid); getDbUpdate($table['s_mbrdata'],'dislikes_post=dislikes_post-1','memberuid='.$R['mbruid']); getDbUpdate($table['s_mbrmonth'],'post_dislikes=post_dislikes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 월별 싫어요수 갱신 getDbUpdate($table['s_mbrday'],'post_dislikes=post_dislikes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 일별 싫어요수 갱신 getDbUpdate($table[$m.'month'],'dislikes=dislikes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and data='.$R['uid']); //포스트별 월별 싫어요수 갱신 getDbUpdate($table[$m.'day'],'dislikes=dislikes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and data='.$R['uid']); //포스트별 일별 싫어요수 갱신 } } } // 로그인한 사용자가 싫어요를 했는지 여부 체크하여 처리 if ($opinion=='dislike') { $opinion_type = '싫어요'; if($is_disliked){ // 싫어요를 했던 경우 $opinion_act = '취소'; $OP = getDbData($table['s_opinion'],$check_dislike_qry,'*'); getDbDelete($table['s_opinion'],$check_dislike_qry); getDbUpdate($table[$m.'data'],'dislikes=dislikes-1','uid='.$uid); getDbUpdate($table['s_mbrdata'],'dislikes_post=dislikes_post-1','memberuid='.$R['mbruid']); getDbUpdate($table['s_mbrmonth'],'post_dislikes=post_dislikes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 월별 싫어요수 갱신 getDbUpdate($table['s_mbrday'],'post_dislikes=post_dislikes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 일별 싫어요수 갱신 getDbUpdate($table[$m.'month'],'dislikes=dislikes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and data='.$R['uid']); //포스트별 월별 싫어요수 갱신 getDbUpdate($table[$m.'day'],'dislikes=dislikes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and data='.$R['uid']); //포스트별 일별 싫어요수 갱신 }else{ // 싫어요를 안한 경우 추가 $opinion_act = '추가'; $QKEY = "mbruid,module,entry,opinion,d_regis"; $QVAL = "'$mbruid','$m','$uid','dislike','".$date['totime']."'"; getDbInsert($table['s_opinion'],$QKEY,$QVAL); getDbUpdate($table[$m.'data'],'dislikes=dislikes+1','uid='.$uid); getDbUpdate($table['s_mbrdata'],'dislikes_post=dislikes_post+1','memberuid='.$R['mbruid']); getDbUpdate($table['s_mbrmonth'],'post_dislikes=post_dislikes+1',"date='".$date['month']."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 월별 싫어요수 갱신 getDbUpdate($table['s_mbrday'],'post_dislikes=post_dislikes+1',"date='".$date['today']."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 일별 싫어요수 갱신 getDbUpdate($table[$m.'month'],'dislikes=dislikes+1',"date='".$date['month']."' and site=".$s.' and data='.$R['uid']); //포스트별 월별 싫어요수 갱신 getDbUpdate($table[$m.'day'],'dislikes=dislikes+1',"date='".$date['today']."' and site=".$s.' and data='.$R['uid']); //포스트별 일별 싫어요수 갱신 if ($is_liked) { $OP = getDbData($table['s_opinion'],$check_like_qry,'*'); getDbDelete($table['s_opinion'],$check_like_qry); getDbUpdate($table[$m.'data'],'likes=likes-1','uid='.$uid); getDbUpdate($table['s_mbrdata'],'likes_post=likes_post-1','memberuid='.$R['mbruid']); getDbUpdate($table['s_mbrmonth'],'post_likes=post_likes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 월별 조회수 갱신 getDbUpdate($table['s_mbrday'],'post_likes=post_likes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and mbruid='.$R['mbruid']); //회원별 일별조회수 갱신 getDbUpdate($table[$m.'month'],'likes=likes-1',"date='".substr($OP['d_regis'],0,6)."' and site=".$s.' and data='.$R['uid']); //포스트별 월별 조회수 갱신 getDbUpdate($table[$m.'day'],'likes=likes-1',"date='".substr($OP['d_regis'],0,8)."' and site=".$s.' and data='.$R['uid']); //포스트별 일별 조회수 갱신 } } } // 포스트 등록자에게 알림전송 if ($d['post']['noti_opinion']) { $B = getDbData($table['postlist'],'id="'.$R['postid'].'"','name'); $referer = $g['url_http'].'/'.$r.'/b/'.$bid.'/'.$uid; include $g['dir_module'].'var/noti/_'.$a.'.php'; // 알림메시지 양식 $noti_title = $d['post']['noti_title']; $noti_title = str_replace('{post}',$name,$noti_title); $noti_title = str_replace('{OPINION_TYPE}',$opinion_type,$noti_title); $noti_title = str_replace('{OPINION_ACT}',$opinion_act,$noti_title); $noti_title = str_replace('{MEMBER}',$my[$_HS['nametype']],$noti_title); $noti_body = $d['post']['noti_body']; $noti_body = str_replace('{MEMBER}',$my[$_HS['nametype']],$noti_body); $noti_body = str_replace('{SUBJECT}',$R['subject'],$noti_body); $noti_referer = $g['url_http'].'/?r='.$r.'&mod=settings&page=noti'; $noti_button = '게시물 확인'; $noti_tag = ''; $noti_skipEmail = 0; $noti_skipPush = 0; putNotice($R['mbruid'],$m,$my['uid'],$noti_title,$noti_body,$noti_referer,$noti_button,$noti_tag,$noti_skipEmail,$noti_skipPush); } $R = getUidData($table[$m.'data'],$uid); // getDbInsert($table['s_point'],'my_mbruid,by_mbruid,price,content,d_regis',"'".$R['mbruid']."','0','2','글추천 포인트 by ".$my['nic']."님 (".getStrCut($R['subject'],15,'').")','".$date['totime']."'"); // getDbUpdate($table['s_mbrdata'],'point=point+2','memberuid='.$R['mbruid']); if ($send=='ajax') { $result['error']=false; if ($is_liked) $result['is_post_liked'] = 1; else $result['is_post_liked'] = 0; if ($is_disliked) $result['is_post_disliked'] = 1; else $result['is_post_disliked'] = 0; $result['likes'] = $R['likes']; $result['dislikes'] = $R['dislikes']; echo json_encode($result); exit; } ?>