Fortes

h2?php _e('Recent Comments'); ?/h2
ul
?php
	global $wpdb, $postlevels_current_user_level;
	
	$sql = "SELECT {$wpdb-comments}.comment_ID, {$wpdb-comments}.comment_author, {$wpdb-comments}.comment_date, {$wpdb-posts}.id, {$wpdb-posts}.post_title
			FROM {$wpdb-comments}, {$wpdb-posts} LEFT JOIN {$wpdb-postmeta} ON {$wpdb-posts}.ID = {$wpdb-postmeta}.post_id
			WHERE {$wpdb-comments}.comment_post_ID = {$wpdb-posts}.id AND {$wpdb-comments}.comment_approved='1' AND {$wpdb-comments}.comment_type != 'pingback' ";
			
	if (!empty($postlevels_current_user_level)) {
		$sql .= " AND ({$wpdb-posts}.post_status = 'publish' OR ({$wpdb-posts}.post_status = 'private' AND {$wpdb-postmeta}.meta_key = 'post_level' AND {$wpdb-postmeta}.meta_value = $postlevels_current_user_level))";
	}
	else {
		$sql .= " AND {$wpdb-posts}.post_status = 'publish'";
	}
	$sql .= " ORDER BY comment_ID DESC LIMIT 5";	

	$LatestActivities = $wpdb-get_results($sql);

	foreach($LatestActivities as $LatestActivity) {
    	//print 'li'.date("j M", strtotime($LatestActivity-CDate)).' '.$LatestActivity-auth.' on a href="'.get_permalink($LatestActivity-PostID).'"'.$LatestActivity-post_title.'/a/li';
		print 'listrong'.$LatestActivity-comment_author.'/strong on a href="'.get_permalink($LatestActivity-id).'"'.$LatestActivity-post_title.'/a span style="font-size: smaller;"('.date('Y.m.d', strtotime($LatestActivity-comment_date)).')/span/li';
	}
?
/ul