虎绿林管理SQL:查询已有发言但access=0的用户并将access置为1

@Ta 03-19 10:11发布,03-19 10:16修改 1325点击
被下沉

查询已有发言但access=0的用户

select uid,name from hu60_user where access=0
and
(
  ((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
  or
  ((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
)

查看这些用户的帖子和回复

select uid,content from hu60_bbs_topic_content where uid in
(
  select uid from hu60_user where access=0
  and
  (
    ((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
    or
    ((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
  )
)

查看这些用户的聊天室发言

select uid,content from hu60_addin_chat_data where uid in
(
  select uid from hu60_user where access=0
  and
  (
    ((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
    or
    ((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
  )
)

将这些用户的access置为1

update hu60_user set access=1 where access=0
and
(
  ((select count(*) from hu60_bbs_topic_content where uid=hu60_user.uid) > 0)
  or
  ((select count(*) from hu60_addin_chat_data where uid=hu60_user.uid) > 0)
)
回复列表(1|隐藏机器人聊天)
添加新回复
回复需要登录