How can I delete All signatures ?

[haXan]

Hi

I converted my MYBB forum to Vbulletin 4.0.1. Everthing is ok. But I want to delete all members of signatures..

Because the old forum links are deactive.
MyBB SEO systems and vBulletin SEO systems are different. So I need to delete all signatures.

Can you explain how can I do on phpmyadmin ?

[borbole]

Originally Posted by haXan

Hi

I converted my MYBB forum to Vbulletin 4.0.1. Everthing ok. But I want to delete all members signatures..

Because old forum links are deactive.
MyBB SEO systems and vBulletin SEO systems are different. So I need delete all signatures.

Can you explain how can I do on phpmyadmin ?

First make a backup of your db, then run the following query:

UPDATE post SET showsignature = 0;

If you tables have a prefix, you must add it as well in the query, before the table name.

Note that this will delete all the signatures for all the members and not for particular members.

And welcome to Vb btw

[haXan]

Thanks guy...

[borbole]

You are welcome.