What are the additional fields in wp_comments used for?

comment_karma

This field is used by a few plug-ins to help you manage your comments. There are a few good articles explaining its exact use floating around on the Internet. But you should note that this field is actually just not used. As Mark Jaquith said once, it’s a “there if you want to use it this.”

There was a short movement to remove it for version 3.1 … but since some systems still hook onto it, it’s staying there for now.

comment_type

Is this a comment, a trackback, or a pingback? This helps theme devs separate out the different types of “comments” in the front-end display.

comment_approved

Is the comment pending moderation, spam, or approved by the author? Just helps you manage what is and isn’t OK for display on the site.

Related Posts:

  1. What for is the table “wp_commentmeta” exactly?
  2. comment_post_ID 0 (cannot remove from dashboard)
  3. Resetting comment count
  4. Would switching to InnoDB from MyISAM improve performance of comments table?
  5. Running a function on comment status change
  6. Is it possible to show custom comment metadata in the admin panel?
  7. Can I store my custom comment_type into wp_comments table?
  8. Using Disqus, how to stop storing comments in wp database?
  9. Add Comment Custom Field
  10. Upload images with comment
  11. Add a drop down list to comment form?
  12. An action hook where a comment meta is updated
  13. Display comment meta data after quick update
  14. migrate comments from old database to new database
  15. WordPress unresponsive after calling wp_update_comment()
  16. What is the correct/safe way to delete all comments?
  17. WordPress Comment. Need some details of wp_comments DB table
  18. How would I count the number of times a comment meta field’s value is in a post’s entire comments?
  19. Recent comments from my blogs only
  20. Add action on delete comments?
  21. How can I get a list of comments by target
  22. Get comments from post and sort by commentmeta value
  23. How to sort posts by the average of comment meta values
  24. WordPress ‘comment counts’ got messed up, because of a plugin – DISQUS
  25. delete duplicate comments
  26. How to get a value from comment meta
  27. Name of comment field differs on different sites
  28. Make every comment go to the spam folder
  29. How to display comment meta under each comment content
  30. Update comment meta for all comments of specific post
  31. How to get Post title by locale with Qtranslate-X
  32. get_comment_meta not behaving as expected
  33. How to filter comments by comment_meta
  34. Top rated posts Average rating issue
  35. WordPress Commenting System User access and Security
  36. Add comment meta
  37. Comment-Meta doesn’t work with latest wordpress update
  38. add field comment [duplicate]
  39. Use country flag as user avatar based on comments IP address?
  40. Paginate result set from $wpdb->get_results()
  41. Change Comment Author Display Name
  42. comments reply script not working
  43. Threaded comments – deleting parent comment leads to orphan comments
  44. How to remove commenters ability to add hyperlinks to comments?
  45. How to remove or replace the log-in link for comment replies?
  46. Exclude internal links from comment moderation?
  47. Remove link preview in discussion dashboard
  48. Can’t add default comments to custom post type
  49. Disable Admin account being emailed for comment notification
  50. How to allow commentetors to get notifications on replies to their comments?
  51. Comments: Approve when admin Replies, from the Front end
  52. Setting comment text as required
  53. How to remove these comments and html tags from the content?
  54. Show only if x comments?
  55. Display WordPress commenter nice name
  56. In wp_list_comments(), what is a short_ping?
  57. Ajax comments not working
  58. Changing the comments link produced by the get_comments_link() and get_comments_pagenum_link() functions
  59. How to display nothing (instead default) when no user gravatar is present?
  60. Redirect to page 2 after comment
  61. How to change avatar of the comment author using comment ID?
  62. Automatically increase comment karma on comment save
  63. Fastest way to get the comment and ping total count for a post
  64. All users/comments suspected as bot? [closed]
  65. Count comment threads, not total comments in a post
  66. comments in Admin
  67. Get all child comments ids from parent comment id
  68. How can get comment link by comment id?
  69. How to amend time format of comments, using child-theme?
  70. Display avatar with comment form?
  71. Add comment_id on Comments page within wp-admin
  72. Sent comments notifications to multiple users
  73. Getting comments of an specefic user
  74. I update a post and it creates a pingback? Any idea why?
  75. How can I embed comments plugin to my own website?
  76. Limit action in comment according to IP
  77. How to get recent comment link
  78. Can I create a new comment type?
  79. How / where is the wp_query object created for RSS feeds?
  80. Separate page for comments using permalinks and add_rewrite_rule
  81. Return count for characters in the comment and perform action based on the length
  82. Cannot Remove Title Reply from Custom Comment Template for Signup Page
  83. Add custom field on admin dashboard comments / reviews
  84. How to make email field not required in comments?
  85. WordPress Comments – Divide by conversation like Medium.com
  86. I want to limit registered user to 1 comment per post in WordPress
  87. What is wrong with this? [closed]
  88. Comment moderation
  89. I have tried using Plugins to remove 72K comments with no success
  90. How to check if post has previous_comments_link() and next_comments_link()
  91. Comment text area in single blog post and show comments if approved
  92. How to ‘If Author’ Comments Check
  93. selectively disable akismet
  94. Disqus moderation page not working in WordPress admin section
  95. Comment Blacklist
  96. Modify “Recent Comments” List in WP-Admin
  97. Comment submission & navigation redirects to default language
  98. comments are going to spam
  99. How to hide the login / profile urls on top of comment box for a post
  100. wp_list_comments adds unnecessary elements

Leave a Comment