티스토리 뷰

DBMS

[그누보드] 좋아요 (추천) sql 쿼리문

비용러브 2023. 4. 2. 22:38
아미나빌더 추천

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 = '글번호''
 
댓글