DZone Snippets: comments code

Perform Comment Recount for WordPress

breakerjump (Josh) — Wed, 14 May 2008 23:11:28 GMT

Run from the command line and uncomment line #2 if your mysql adapter is installed via RubyGems. Fast as hell.



#!/usr/bin/ruby

#require 'rubygems'

require 'mysql'

 

db = Mysql.real_connect("host", "username", "password", "database")

ids = db.query("SELECT `ID` FROM `wp_posts` WHERE 1")

 

ids.each_hash do |post|

  id = post['ID']

  num = 0

  comments = db.query("SELECT COUNT(1) FROM `wp_comments` WHERE `comment_post_ID`='#{id}' AND `comment_approved`='1';")

  comments.each {|x| num = x[0]}

  up = db.query("UPDATE `wp_posts` SET `comment_count`='#{num}' WHERE `ID`='#{id}';")

end

RSS Feed for DZone Snippets Comments

timmorgan (Tim Morgan) — Wed, 23 Jan 2008 14:23:09 GMT

http://feed43.com/8055673348816228.xml

Remove comments from a file

fak3r (fak3r) — Wed, 20 Jun 2007 18:24:22 GMT

Remove all comment lines from a file.



sed -e '/^#/d' $1 | more

or to output it to a new file



sed -e '/^#/d' $1 > $1.nocomments