MyBB Community Forums

Full Version: SQL Query for displaying all sigs

You're currently viewing a stripped down version of our content. View the full version with proper formatting.

I'd like a SQL to change

Quote:admin panel --> users & groups --> group --> Users and Permissions --> Can add a signature

to yes for all groups and enable signature on all posts for all users.

I found a friend on it, but it was old and the SQL query didn't work.

UPDATE mybb_usergroups SET canusesig='1'

UPDATE mybb_posts SET includesig='1'

Thanks!

risker