How do I remove Signatures?

[scottct1]

How do I remove ALL signtures from the registered usergroup. (#2)

I found one query which got rid of all signatures that had URL's in it, it worked but I want to get rid of all signatures for that usergroup.
UPDATE usertextfield AS ut INNER JOIN user AS u ON ut.userid = u.userid SET signature=NULL WHERE ut.signature LIKE '%url%' AND u.usergroupid = 2;

[Wayne Luke]

Just turn them off with permissions. You don't have to remove them from the system.

Usergroups -> Usergroup Manager. Edit the Registered Usergroup and set "Can Use Signatures" to No.

To delete them all though, just remove the "ut.signature LIKE '%url%' AND" part of your query. Without removing the permission, they'll just create new ones though.

[scottct1]

I did that, but the signatures are still showing. Must be cached or something.

[zylstra]

My question is essentially the same so I'll ask it here. How do I prevent signatures from appearing? i.e. How where is the setting to toggle $post['signature']?

[zylstra]

I think I understand now. It's a per user setting, settable by the user in General Settings.

But I do still see the Edit Signature link even though I set "Can Use Signatures" to No. Why is this? I would guess it's the setting for the $show['siglink'] variable.