Easy enough to give a signature to all members of a group, but what if they are in more than one group? Anyway:
Code: Select all
UPDATE phpbb_users SET user_sig = 'whatever' WHERE user_id IN(SELECT user_id FROM phpbb_user_group WHERE group_id = X)
Harder to keep them from changing it. If it were my board, I would just tell them not to change their signature.
But, you can make it difficult by:
Backup styles/prosilver/template/ucp_prosile_signature
OPEN styles/prosilver/template/ucp_prosile_signature
FIND:
Code: Select all
<form id="postform" method="post" action="{S_UCP_ACTION}"{S_FORM_ENCTYPE}>
BEFORE, ADD:
FIND:
AFTER, ADD:
If your table prefix is not
phpbb_
change accordingly.
Purge the cache.
This will remove the signature form from the UCP for all but Admins and Moderators. Not tested. You would also have to run the SQL every time you add a new user to a group. Your interim solution (which I learned of after writing the above) may be better.