View Single Post
Old 18-09-2007, 02:11 PM   #1 (permalink)
Brian Turner
Business Guru
 
Brian Turner's Avatar
 
Join Date: Dec 2003
Location: Near Inverness, Highlands, Scotland
Posts: 7,892
Default Open/close comments in Wordpress with phpmyadmin

If you've enabled comments and found you only get spam (common) else disabled comments but get so much traffic users are complaining of not being able to comment, here's some handy code for you.

In most admin panels this is seriously easy.

For example, in CPanel, go to Databases, then PHPmyadmin.

Select the database.

Then click on SQL.

Then run the following code to close all comments:

Quote:
UPDATE wp_posts SET comment_status = 'closed', ping_status = 'closed' WHERE comment_status = 'open';
or run the following code to open all comments:

Quote:
UPDATE wp_posts SET comment_status = 'open', ping_status = 'open' WHERE comment_status = 'closed';
Simple and easy.
__________________
SEO specialist
Brian Turner is offline   Reply With Quote