How to List and Show WordPress Posts That Comments and Pings Off (Not Allow)如何查看名单和职位WordPress的评论和坪关闭（不允许）
WordPress blog publishing platform allows individual author to override global discussion setting and set whether to allow reader to post comment on the article, or whether to allow link notification (aka pingback and trackback) from other blogs at single post or page level. WordPress的博客发布平台允许个人凌驾于作者讨论全球规定设置和是否允许读者张贴评论文章，或是否允许连结的通知（又名pingback和引用）由其他blog单邮寄或网页的水平。 The feature allows all new posts and pages to be created with comments and pings on, but can always be turned off on specific posts or pages when needed.该功能可让所有新员额和网页创建意见和坪，但总是可以关闭的具体职位或网页时，需要。
When come to time to housekeeping, WordPress does not provide an easy way to list or show all posts or paged articles that has its comments and pings off.当来的时候家务， WordPress的不提供一种简单的方式，列表或显示全部职位或分页的文章，有它的意见和坪赶走。 For blog administrators who want to see a list blog posts and articles that have forbid readers and visitors to leave comments, and stop other blogs to pingback or trackback, use the following trick to list out all posts and pages that are currently set to comment and pingback/trackback off.对于博客管理员谁希望看到一个清单博客帖子和文章有禁止读者和游客留下意见，并停止其他博客pingback或引用，请使用下面的把戏，列出所有职位和网页，目前正在为评论和pingback /引用赶走。
Log on to the MySQL database that powers the WordPress blog, and then use the following SQL query statement to get all posts or pages that either comment is not allowed, pings (trackback and ping back) is not allowed or both.登录到MySQL数据库的权力WordPress的博客，然后使用下面的SQL查询的发言得到所有职位或网页，或者评论是不允许，坪（跟踪和平回）是不允许的或两者兼施。
SELECT * FROM `wp_posts` where `comment_status` <> ‘open’ or `ping_status` <> ‘open’;
Tip: To make the selection from database easier, it’s recommended to use窍门：为了使从数据库选择更容易，这是推荐使用 phpMyAdmin or other GUI interface to MySQL DB.或其他GUI界面，到MySQL数据库。
The query above will return all row (both posts and pages in WordPress) that has either “Allow Comments” or “Allow Pings” set to off (untick).上述查询将返回所有行（包括员额和WordPress的网页）这是“允许评论”或“允许坪”设置为关闭（ untick ） 。 To return only articles where comments is not allowed, use only “comment_status”, or “ping_status” for articles that do not allow pingback and trackback.要返回的条款只在评论是不允许的，只能使用“ comment_status ” ，或“ ping_status ”的文章，不允许pingback和跟踪。
Both comment_status and ping_status fields have only two easily understand values - open and closed.这comment_status和ping_status领域只有两个容易理解的价值观-开启和关闭。 Open means allow, which closed means disallowed.开放式的手段让，这意味着不允许关闭。 Once the result is displayed, the posts that have one or both of the criteria can be determined, and changed if required.一旦结果显示，职位有一个或两个标准才能确定，而且如果需要改变。
IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明：这是一台机器翻译网页是“现状”提供不附带。 Machine translation may be difficult to understand.机器翻译可能是很难理解。 Please refer to请参阅 original English article英文原文的文章 whenever possible.只要有可能。
Share and contribute or get technical support and help at共享和贡献或获得技术支持和帮助 My Digital Life Forums 我的数字生活论坛 . 。
Related Articles相关文章
- Reduce Server Load Using Akismet to Automatically Discard Spam Comments on Posts Older than A Month减少服务器负载使用Akismet自动丢弃垃圾评论职位以上一个月
- 3 Column Relaxation WordPress Theme comments-paged.php for Paged-Comments WordPress Plugin三栏松弛WordPress的主题评论， paged.php为分页，评论WordPress的插件
- Integrate WordPress including Comments with bbPress Forum using bbSync WordPress的整合，包括评论与bbPress论坛使用bbSync
- Moderate WordPress Blog Comments Via Moderator with Desktop Client适度WordPress的博客评论通过主持人与桌面客户端
- How to Delete Existing WordPress Post Revisions Stored/Saved如何删除现有的WordPress的修改后储存/保存
- How to Move WordPress Blog to New Domain or Location如何将WordPress的博客新域或位置
- Show,List Out and Identify All Shared Files and Folders in Windows Vista显示，列出，并确定所有共享文件和文件夹在Windows Vista
- Free Download: Akismet for WordPress Plugin 2.0 to Stop Comment, Trackback and Pingback Spam免费下载：为WordPress的Akismet插件2.0停止评论，引用和Pingback垃圾邮件
- Paginating or Split WordPress Post or Page with NextPage in WordPress Not Working Paginating或斯普利特WordPress的邮政或与下一页页在WordPress的不工作
- WordPress 2.2 Released for Free Download WordPress的2.2发布免费下载
