How to clear all signatures

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
mexus
Registered User
Posts: 4
Joined: Wed Feb 11, 2004 5:44 pm

How to clear all signatures

Post by mexus » Sat Aug 25, 2007 11:57 pm

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!

FX
Registered User
Posts: 254
Joined: Thu Aug 01, 2002 9:29 pm
Location: France
Contact:

Re: How to clear all signatures

Post by FX » Sun Aug 26, 2007 12:38 am

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` = *;

Locked

Return to “[3.0.x] Support Forum”