Page 1 of 1

How to clear all signatures

Posted: Sat Aug 25, 2007 11:57 pm
by mexus
I wonder how to delete all user's signatures.
I need them to renew them. Because all the signatures in written in Cyrillic are not shown properly!

I don't want to disable the signatures!

Re: How to clear all signatures

Posted: Sun Aug 26, 2007 12:38 am
by FX
Hi,

If you have phpmyadmin run this query :

Code: Select all

UPDATE `phpbb3_users` SET `user_sig` = '' WHERE `phpbb3_users`.`user_id` = *;
UPDATE `phpbb3_users` SET `user_sig_bbcode_uid` = '' WHERE `phpbb3_users`.`user_id` = *;
UPDATE `phpbb3_users` SET `user_sig_bbcode_bitfield` = '' WHERE `phpbb3_users`.`user_id` = *;