7B2主题批量修改文章/圈子话题隐藏内容阅读权限

登录可见的话题修改为公开可见

UPDATE wpb2_postmeta 
SET meta_value = replace(meta_value,'login','public')
WHERE meta_key = 'b2_topic_read_role'

评论可见的话题修改为公开可见

UPDATE wpb2_postmeta 
SET meta_value = replace(meta_value,'comment','public')
WHERE meta_key = 'b2_topic_read_role'

积分可见的话题修改为公开可见

UPDATE wpb2_postmeta 
SET meta_value = replace(meta_value,'credit','public')
WHERE meta_key = 'b2_topic_read_role'

付费可见的话题修改为公开可见

UPDATE wpb2_postmeta 
SET meta_value = replace(meta_value,'money','public')
WHERE meta_key = 'b2_topic_read_role'

等级可见的话题修改为公开可见

UPDATE wpb2_postmeta 
SET meta_value = replace(meta_value,'lv','public')
WHERE meta_key = 'b2_topic_read_role'

2. 批量修改 7B2 主题文章隐藏内容阅读权限
文章的修改也是跟圈子话题比较类似，有所变化的就是判断的字段而已，大家参照修改就行

登录可见的隐藏内容修改为公开可见

UPDATE wpb2_postmeta 
SET meta_value = replace(meta_value,'login','public')
WHERE meta_key = 'b2_post_reading_role'