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第3柱主題放寬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發布免費下載
