tag.class.php

来自「一款开源的sns系统源码 安装简单」· PHP 代码 · 共 108 行

<?php

// -----------------------------------------------------------------------
// This file is part of AROUNDMe
// 
// Copyright (C) 2003-2007 Barnraiser
// http://www.barnraiser.org/
// [e-mail]
// 
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
// 
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// 
// You should have received a copy of the GNU General Public License
// along with this program; see the file COPYING.txt.  If not, see
// <http://www.gnu.org/licenses/>
// -----------------------------------------------------------------------


class Tag {

	// the constructor
	// Tom Calthrop, 20th March 2007
	//
	function Tag($db) {
		$this->db = $db;
	} //EO Rate

	
	// Selects ratings (rating, your vote this month)
	// Tom Calthrop, 20th March 2007
	//
	function selTag ($plugin, $item_id) {

		$rating['total'] = 0;
		$rating['votes'] = 0;
		$rating['average'] = 0;
		
		// select average 
		$query = "
			SELECT sum(rate_value) as total 
			FROM " . $this->db->prefix . "_rate 
			WHERE
			webspace_id=" . $_SESSION['webspace_id'] . " AND 
			plugin_name=" . $this->db->qstr($plugin, get_magic_quotes_gpc()) . " AND
			plugin_item_id=" . $item_id
		;
		
		
		$result = $this->db->Execute($query);

		if (isset($result->fields)) {
			$rating['total'] = $result->fields['total'];
		}

		// select total 
		$query = "
			SELECT count(rate_value) as total
			FROM " . $this->db->prefix . "_rate 
			WHERE
			webspace_id=" . $_SESSION['webspace_id'] . " AND 
			plugin_name=" . $this->db->qstr($plugin, get_magic_quotes_gpc()) . " AND
			plugin_item_id=" . $item_id
		;
		
		$result = $this->db->Execute($query);

		if (isset($result->fields)) {
			$rating['votes'] = $result->fields['total'];
		}

		if ($rating['total'] > 0 && $rating['votes'] > 0) {
			$rating['average'] = round($rating['total'] / $rating['votes']);
		}
		

		// select my vote
		if (isset($_SESSION['connection_id'])) {
			$query = "
				SELECT rate_value as total
				FROM " . $this->db->prefix . "_rate 
				WHERE
				webspace_id=" . $_SESSION['webspace_id'] . " AND 
				plugin_name=" . $this->db->qstr($plugin, get_magic_quotes_gpc()) . " AND
				plugin_item_id=" . $item_id . " AND
				connection_id=" . $_SESSION['connection_id']
			;
			
			$result = $this->db->SelectLimit($query, 1);
	
			if (isset($result->fields)) {
				$rating['vote'] = $result->fields['total'];
			}
		}

		return $rating;

		
	}//EO selRating
}

?>