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

查询已有发言但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)
)