修正热情评论员

<?php
//获得缓存的数据并作出判断
function get_xing($comment_email){
//获得主题后台设置
$options = get_option('philna2_options');
//获取热情评论缓存
$result=get_option('philna_commenter_star');
	//为空.从新查数据库.重获缓存.
	if(empty($result)){
	philna_commenter_star($options['xing_limit_days']);
	$result=get_option('philna_commenter_star');
	}
	//判断输出.
	$times=$result[$comment_email];
	if($times>=$options['xing_limit_cm']){
	$style= ' style'."=".'"cursor:pointer;"';
	$output =" ";
	$output .='<img src='.'"'.get_bloginfo('template_url').'/i/star.gif" alt="Enthusiastic commentator! This guy comment '.$times.' times in'.$options['xing_limit_days'].'days . 	
	So get this reward" '.' title="'.'Enthusiastic commentator! This guy comment '.$times.' times in '.$options['xing_limit_days'].' days. So get this reward" />';
	echo $output;
	}else return;
}
//查询并缓存函数
function philna_commenter_star( $limit_days=30){
global $wpdb, $tablecomments;
//获取后台限制条件并查表.
$options = get_option('philna2_options');
$limit_days=$options['xing_limit_days'];
$sql=$wpdb->get_results(
	"SELECT comment_author_email, count( comment_author_email ) AS cmtcount
	FROM  $tablecomments
	WHERE comment_approved =1
	AND comment_type = ''
	AND TO_DAYS( now( ) )-TO_DAYS(`comment_date`)<$limit_days
	GROUP BY comment_author_email
	ORDER BY cmtcount DESC
	LIMIT 0 ,2000"
	);
//历遍结果,生成新的数组.存放邮件和次数.
foreach ($sql as $mycomment){
$mail=$mycomment->comment_author_email;
$comment_times=$mycomment->cmtcount;
$cache[$mail]=$comment_times;
}
//将这个数组更新到缓存.
update_option('philna_commenter_star',$cache);
}
//wordpress API Hook 每次有新评论,运行更新缓存.
add_action('comment_post', 'philna_commenter_star');
?>