[Forum] Delete all signatures

[Alastor]

I've set new parameters for my forum. The problem is the same problem that's existed since VB first did signatures. The old sigs are allowed to display and do not have to conform to the new standards. I also can't force the board to check and make sure that the new standards are being conformed to.

So I need to clear out all of the signatures on my community. I know there's an SQL query code I need to use, but I don't remember the query. Can someone help me out here?

Thanks in advance for any help you can offer.

[Alastor]

I need to do the same for avatars and signature pictures as well. If you folks could help me out, I'd really appreciate that.

[borbole]

I need to do the same for avatars and signature pictures as well. If you folks could help me out, I'd really appreciate that.

To delete the signatures for everyone run this query:

UPDATE usertextfield SET signature = '';

To delete the custom avatars that your users have run this query:

DELETE FROM customavatar USING customavatar 
LEFT JOIN user ON (user.userid = customavatar.userid);

The queries posted above should be run either at the SQL Box at your forum 's database phpmyadmin. Or you can also run it from your Admin Panel->Maintenance->Execute SQL Query. But for this you must enter your user id at the below area at the config.php file:

$config['SpecialUsers']['canrunqueries'] = 'x'; 

Where x equals your user id. And also if you are using a custom prefix for your database tables, append it to the table names in the queries. Hope it helps.

[Alastor]

Thank you very much. I appreciate it.

[borbole]

Thank you very much. I appreciate it.

You are welcome. Glad to have been of help.

[rahuldhangar]

To delete the signatures for everyone run this query:

UPDATE usertextfield SET signature = '';

To delete the custom avatars that your users have run this query:

DELETE FROM customavatar USING customavatar
LEFT JOIN user ON (user.userid = customavatar.userid);

The queries posted above should be run either at the SQL Box at your forum 's database phpmyadmin. Or you can also run it from your Admin Panel->Maintenance->Execute SQL Query. But for this you must enter your user id at the below area at the config.php file:

$config['SpecialUsers']['canrunqueries'] = 'x'; 

Where x equals your user id. And also if you are using a custom prefix for your database tables, append it to the table names in the queries. Hope it helps.

Bravo! Thanks a lot

Only one thing I found lagging in this solution is: we need to add table prefix so the query looks something like:

UPDATE {table-prefix}usertextfield SET signature = '';

Since My vBulletin forum setup have a table prefix for all vBulletin tables, I needed to run this query instead:

UPDATE vb_usertextfield SET signature = '';

here "vb_" is the database table prefix. Hope this info will help someone

[dan325ci]

Sorry to bump this old thread but does anybody know a query to delete the signatures of all users who joined before a certain date?