1  
   2  #!/usr/bin/ruby
   3  #require 'rubygems'
   4  require 'mysql'
   5   
   6  db = Mysql.real_connect("host", "username", "password", "database")
   7  ids = db.query("SELECT `ID` FROM `wp_posts` WHERE 1")
   8   
   9  ids.each_hash do |post|
  10    id = post['ID']
  11    num = 0
  12    comments = db.query("SELECT COUNT(1) FROM `wp_comments` WHERE `comment_post_ID`='#{id}' AND `comment_approved`='1';")
  13    comments.each {|x| num = x[0]}
  14    up = db.query("UPDATE `wp_posts` SET `comment_count`='#{num}' WHERE `ID`='#{id}';")
  15  end