Blog How to Mass Set Blog Comments to Allowed-
 

All usergroups (except unregistered) have permission to comment on blog posts. However, when I go to a members profile in the admincp>user manager> Blogs> sometimes the setting "Allow comments to be posted" is set to 'NO'.

I want to know what is the correct MySQL Command field to Mass Update ALL Users to set this field to YES automatically.

blog.JPG

For example:

UPDATE blog set state=replace(hidden, 'visible')

I just can't seem to find the correct table field while searching through the tables! Anyone know?
Attached Images

• https://www.vbulletin.com/forum/images/attach/jpg.gif blog.JPG‎ (37.8 KB)