• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Updating Signature Permissions

Joe Link

Well-known member
#1
I have disabled signature permissions for non-upgraded members, but imported users still have their signatures showing. How can I hide these signatures?
 

borbole

Well-known member
#2
I have disabled signature permissions for non-upgraded members, but imported users still have their signatures showing. How can I hide these signatures?
Go to your phpmyadmin and choose the database that you have installed your xenforo forum. Then at the SQL tab run this query:

Code:
UPDATE xf_user_profile
LEFT JOIN xf_user ON (xf_user.user_id = xf_user_profile.user_id)
SET signature = ''
WHERE xf_user.user_group_id = x;
Replace x with the id of the group whose signatures you want to remove. And if you are using another prefix for your tables, replace xf_ with your custom prefix at the query above. Hope it helps.
 

Martok

Well-known member
#3
Go to your phpmyadmin and choose the database that you have installed your xenforo forum. Then at the SQL tab run this query:

Code:
UPDATE xf_user_profile
LEFT JOIN xf_user ON (xf_user.user_id = xf_user_profile.user_id)
SET signature = ''
WHERE xf_user.user_group_id = x;
Replace x with the id of the group whose signatures you want to remove. And if you are using another prefix for your tables, replace xf_ with your custom prefix at the query above. Hope it helps.
Couldn't the OP just use the batch update users option in the ACP to remove signatures from the group?