get_lastcommentmodified

Source code

function get_lastcommentmodified($timezone = 'server') {

	global $cache_lastcommentmodified, $wpdb;



	if ( isset($cache_lastcommentmodified[$timezone]) )

		return $cache_lastcommentmodified[$timezone];



	$add_seconds_server = date('Z');



	switch ( strtolower($timezone)) {

		case 'gmt':

			$lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1");

			break;

		case 'blog':

			$lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1");

			break;

		case 'server':

			$lastcommentmodified = $wpdb->get_var($wpdb->prepare("SELECT DATE_ADD(comment_date_gmt, INTERVAL %s SECOND) FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1", $add_seconds_server));

			break;

	}



	$cache_lastcommentmodified[$timezone] = $lastcommentmodified;



	return $lastcommentmodified;

}