Skip to content

Instantly share code, notes, and snippets.

@s9011514

s9011514/bulk-comments-1.sql

Last active June 22, 2016 16:54
Show Gist options
  • Save s9011514/344d438cae0e7bd15d4221693cc73bf7 to your computer and use it in GitHub Desktop.
Save s9011514/344d438cae0e7bd15d4221693cc73bf7 to your computer and use it in GitHub Desktop.
Download ZIP
WordPress 批次開啟/關閉留言功能，教學說明： https://sofree.cc/wordpress-bulk-comment-close/
Raw
bulk-comments-1.sql
/*批次關閉所有文章留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_type = 'post' ;
Raw
bulk-comments-10.sql
/*針對全部草稿文章關閉留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_status = 'draft' AND post_type = 'post' ;
Raw
bulk-comments-2.sql
/*批次開啟所有文章留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_type = 'post' ;
Raw
bulk-comments-3.sql
/*批次開啟所有頁面留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_type = 'page' ;
Raw
bulk-comments-4.sql
/*批次關閉所有頁面留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_type = 'page' ;
Raw
bulk-comments-5.sql
/*批次關閉所有文章Trackback通知引用*/
UPDATE wp_posts SET ping_status = 'closed' WHERE post_type = 'post' ;
Raw
bulk-comments-6.sql
/*批次開啟所有文章Trackback通知引用*/
UPDATE wp_posts SET ping_status = 'open' WHERE post_type = 'post' ;
Raw
bulk-comments-7.sql
/*針對全部已發表文章開啟留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_status = 'publish' AND post_type = 'post' ;
Raw
bulk-comments-8.sql
/*針對全部已發表文章關閉留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_status = 'publish' AND post_type = 'post' ;
Raw
bulk-comments-9.sql
/*針對全部草稿文章開啟留言*/
UPDATE wp_posts SET comment_status = 'open' WHERE post_status = 'draft' AND post_type = 'post' ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment