Forcing signature rules on current members

[jayunsplanet]

Hi all,

Members of a forum that I administer have gotten out of hand with their signatures. I have edited the signature permissions in the AdminCP which I believe will work for new members. How do I go about "forcing" permissions on current members. i.e. - automatically pruning anything against the "rules" out of their signatures? For example, I only allowed 1 image. So if there are 2, 1 would get deleted...

Are there any other ways to go about what I want to do?

Thanks for your ideas and help.

[xlguy]

Bulk remove all signatures using a MySQL command and force everyone to set up new ones, that would then follow the rules?

[jayunsplanet]

Thanks for the reply.
What type of command would do such a thing?

Any other less drastic and obvious ideas?

[SCRIPT3R]

SQL >>

UPDATE user
SET sigpicrevision = 0

DELETE FROM sigpic

DELETE FROM sigparsed