좋아요 (추천) sql 쿼리문 > 기술자료

• 목록

아미나빌더 추천

select * from `g5_apms_like` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
select * from `{$g5['apms_like']}` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'

delete from `g5_apms_like` where id ='글번호'
delete from `{$g5['apms_good']}` where id ='글번호'


아미나빌더 ( 영카트 ) 좋아요

select * from `g5_apms_good` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
select * from `{$g5['apms_good']}` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'

delete from `g5_apms_like` where id ='글번호'
delete from `{$g5['apms_good']}` where id ='글번호'


그누보드5 좋아요

select * from `g5_board_good` where mb_id = '추천누른_회원ID' and bo_table = '게시판' and wr_id = '추천글_ID'
select * from `{$g5['board_good_table']}` where mb_id = '추천누른_회원ID' and bo_table = '게시판' and wr_id = '추천글_ID'

delete from `g5_board_good` where bg_id = '글번호''
delete from `{$g5['board_good_table']}` where bg_id = '글번호''