comment.class.php

Phpcms2008 是一款基于 PHP+Mysql 架构的网站内容管理系统

<?php
class comment {
	var $db = '';
	var $_comment_table = '';
	function comment()
    {
		global $db;
		$this->db = $db;
		$this->_comment_table = DB_PRE.'comment';
		$this->count_table = DB_PRE.'content_count';
	}

	/**
	 *
	 *	@params
	 *	@return
	 */
	 function get_list($keyid, $page = 1, $pagesize)
     {
        global $MODULE;
		$keyid = trim($keyid);
		$page = max(intval($page), 1);
        $offset = $pagesize*($page-1);
		$comments = array();
        $count = cache_count("SELECT COUNT(*) AS `count` FROM `$this->_comment_table` WHERE `keyid`='{$keyid}' AND `status`='1'");
		$comments['pages'] = pages($count, $page, $pagesize);
		$ip_area = load('ip_area.class.php');
		$result = $this->db->query("SELECT `commentid`,`username`,`support`,`against`,`ip`,`addtime`,`status`,`content`, `userid` FROM `$this->_comment_table` WHERE `keyid` = '{$keyid}' AND `status` = '1' ORDER BY `addtime` DESC limit $offset,$pagesize");
		while($r = $this->db->fetch_array($result))
        {
			//$r['content'] = preg_replace_callback("/\[smile_[0-9]{1,3}\]/", 'smilecallback', $r['content']);
			$r['content'] = str_replace( '[quote]', '<div class="reply">', $r['content']);
			$r['content'] = str_replace( '[blue]', '<div href="#" class ="blue"><p>', $r['content']);
			$r['content'] = str_replace( '[/quote]', '</div>', $r['content']);
			$r['content'] = str_replace( '[/blue]', '</p></div>', $r['content']);
			$r['addtime'] = date('Y-m-d H:m:s',$r['addtime']);
            list($r['ip_area'], ) = explode(' ', $ip_area->get($r['ip']));
            $r['ip_area'] = $r['ip_area'].'缃戝弸';
			$r['ip'] = preg_replace("/^([0-9]{1,3}\.[0-9]{1,3})\.[0-9]{1,3}\.[0-9]{1,3}$/", "\\1.*.*", $r['ip']);
            //$r['ip'] = $r['ip'].'锛