<?php

/**

 * Manages WordPress comments

 *

 * @package WordPress

 * @subpackage Comment

 */

/**

 * Checks whether a comment passes internal checks to be allowed to add.

 *

 * If comment moderation is set in the administration, then all comments,

 * regardless of their type and whitelist will be set to false. If the number of

 * links exceeds the amount in the administration, then the check fails. If any

 * of the parameter contents match the blacklist of words, then the check fails.

 *

 * If the number of links exceeds the amount in the administration, then the

 * check fails. If any of the parameter contents match the blacklist of words,

 * then the check fails.

 *

 *

 * If none of the checks fail, then the failback is to set the check to pass

 * (return true).

 *

 * @since 1.2.0

 * @uses $wpdb

 *

 * @param string $author Comment Author's name

 * @param string $email Comment Author's email

 * @param string $url Comment Author's URL

 * @param string $comment Comment contents

 * @param string $user_ip Comment Author's IP address

 * @param string $user_agent Comment Author's User Agent

 * @param string $comment_type Comment type, either user submitted comment,

 *		trackback, or pingback

 * @return bool Whether the checks passed (true) and the comments should be

 *		displayed or set to moderated

 */

function check_comment($author, $email, $url, $comment, $user_ip, $user_agent, $comment_type) {

	global $wpdb;

	if ( 1 == get_option('comment_moderation') )

		return false; // If moderation is set to manual

	$mod_keys = trim(get_option('moderation_keys'));

	if ( !empty($mod_keys) ) {

		$words = explode("\n", $mod_keys );

		foreach ( (array) $words as $word) {

			$word = trim($word);

			// Skip empty lines

			if ( empty($word) )

				continue;

			// Do some escaping magic so that '#' chars in the

			// spam words don't break things:

			$word = preg_quote($word, '#');

			$pattern = "#$word#i";

			if ( preg_match($pattern, $author) ) return false;

			if ( preg_match($pattern, $email) ) return false;

			if ( preg_match($pattern, $url) ) return false;

			if ( preg_match($pattern, $comment) ) return false;

			if ( preg_match($pattern, $user_ip) ) return false;

			if ( preg_match($pattern, $user_agent) ) return false;

		}

	}

	// Comment whitelisting:

	if ( 1 == get_option('comment_whitelist')) {

			// expected_slashed ($author, $email)

			$ok_to_comment = $wpdb->get_var("SELECT comment_approved FROM $wpdb->comments WHERE comment_author = '$author' AND comment_author_email = '$email' and comment_approved = '1' LIMIT 1");

			if ( ( 1 == $ok_to_comment ) &&

				( empty($mod_keys) || false === strpos( $email, $mod_keys) ) )

					return true;

			else

				return false;

		} else {

			return false;

		}

	}

	return true;

}

/**

 * Retrieve the approved comments for post $post_id.

 *

 * @since 2.0.0

 * @uses $wpdb

 *

 * @param int $post_id The ID of the post

 * @return array $comments The approved comments

 */

function get_approved_comments($post_id) {

	global $wpdb;

	return $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_post_ID = %d AND comment_approved = '1' ORDER BY comment_date", $post_id));

}

/**

 * Retrieves comment data given a comment ID or comment object.

 *

 * If an object is passed then the comment data will be cached and then returned

 * after being passed through a filter. If the comment is empty, then the global

 * comment variable will be used, if it is set.

 *

 * If the comment is empty, then the global comment variable will be used, if it

 * is set.

 *

 * @since 2.0.0

 * @uses $wpdb

 *

 * @param object|string|int $comment Comment to retrieve.

 * @param string $output Optional. OBJECT or ARRAY_A or ARRAY_N constants.

 * @return object|array|null Depends on $output value.

 */

function &get_comment(&$comment, $output = OBJECT) {

	global $wpdb;

	$null = null;

	if ( empty($comment) ) {

		if ( isset($GLOBALS['comment']) )

			$_comment = & $GLOBALS['comment'];

		else

			$_comment = null;

	} elseif ( is_object($comment) ) {

		wp_cache_add($comment->comment_ID, $comment, 'comment');

		$_comment = $comment;

	} else {

		if ( isset($GLOBALS['comment']) && ($GLOBALS['comment']->comment_ID == $comment) ) {

			$_comment = & $GLOBALS['comment'];

		} elseif ( ! $_comment = wp_cache_get($comment, 'comment') ) {

			$_comment = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpdb->comments WHERE comment_ID = %d LIMIT 1", $comment));

			if ( ! $_comment )

				return $null;

			wp_cache_add($_comment->comment_ID, $_comment, 'comment');

		}

	}

	$_comment = apply_filters('get_comment', $_comment);

	if ( $output == OBJECT ) {

		return $_comment;

	} elseif ( $output == ARRAY_A ) {

		$__comment = get_object_vars($_comment);

		return $__comment;

	} elseif ( $output == ARRAY_N ) {

		$__comment = array_values(get_object_vars($_comment));

		return $__comment;

	} else {

		return $_comment;

	}

}

/**

 * Retrieve a list of comments.

 *

 * The comment list can be for the blog as a whole or for an individual post.

 *

 * The list of comment arguments are 'status', 'orderby', 'comment_date_gmt',

 * 'order', 'number', 'offset', and 'post_id'.

 *

 * @since 2.7.0

 * @uses $wpdb

 *

 * @param mixed $args Optional. Array or string of options to override defaults.

 * @return array List of comments.

 */

function get_comments( $args = '' ) {

	}

}

/**

 * Retrieve all of the WordPress supported comment statuses.

 *

 * Comments have a limited set of valid status values, this provides the comment

 * status values and descriptions.

 *

 * @package WordPress

 * @subpackage Post

 * @since 2.7.0

 *

 * @return array List of comment statuses.

 */

function get_comment_statuses( ) {

	$status = array(

		'hold'		=> __('Unapproved'),

		/* translators: comment status  */

		'approve'	=> _x('Approved', 'adjective'),

		/* translators: comment status */

		'spam'		=> _x('Spam', 'adjective'),

	);

	return $status;

}

/**

 * The date the last comment was modified.

 *

 * @since 1.5.0

 * @uses $wpdb

 * @global array $cache_lastcommentmodified

 *

 * @param string $timezone Which timezone to use in reference to 'gmt', 'blog',

 *		or 'server' locations.

 * @return string Last comment modified date.

 */

function get_lastcommentmodified($timezone = 'server') {

	global $cache_lastcommentmodified, $wpdb;

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