1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80

<?php
/**
* @package Joostina
* @copyright Авторские права (C) 2008-2009 Joostina team. Все права защищены.
* @license Лицензия http://www.gnu.org/licenses/gpl-2.0.htm GNU/GPL, или help/license.php
* Joostina! - свободное программное обеспечение распространяемое по условиям лицензии GNU/GPL
* Для получения информации о используемых расширениях и замечаний об авторском праве, смотрите файл help/copyright.php.
*/

define( "_VALID_MOS", 1 );

$basePath = dirname( __FILE__ );
require( $basePath . '/../../../includes/globals.php' );

// $basepath reintialization required as globals.php will kill initial when RGs Emulation `Off`
$basePath = dirname(dirname(dirname(dirname( __FILE__ ))));
require( $basePath . '/configuration.php' );

require_once($basePath.'/includes/libraries/database/database.php');

if ( $GLOBALS['mosConfig_db'] != "") {
	$database = new database( $GLOBALS['mosConfig_host'], $GLOBALS['mosConfig_user'], $GLOBALS['mosConfig_password'], $GLOBALS['mosConfig_db'], $GLOBALS['mosConfig_dbprefix'] );
}

switch($_GET['task']){
	case 'vote':
		echo recordVote(); break;
	case 'show':
		echo showVotes(); break;
}

function recordVote() {
	global $database;

	$user_rating 	= intval( $_GET['user_rating'] );
	$cid 			= intval( $_GET['cid'] );

	if (($user_rating >= 1) and ($user_rating <= 5)) {
		$currip = $_SERVER['REMOTE_ADDR'];

		$query = "SELECT * FROM #__content_rating WHERE content_id = " . $cid;
		$database->setQuery( $query );
		$votesdb = NULL;
		if ( !( $database->loadObject( $votesdb ) ) ) {
			$query = "INSERT INTO #__content_rating ( content_id, lastip, rating_sum, rating_count ) VALUES ( " . $cid . ", " . $database->Quote( $currip ) . ", " . $user_rating . ", 1 )";
			$database->setQuery( $query );
			$database->query() or die( $database->stderr() );;
		} else {
			if ($currip != ($votesdb->lastip)) {
				$query = "UPDATE #__content_rating"
				. "\n SET rating_count = rating_count + 1, rating_sum = rating_sum + " . $user_rating . ", lastip = " . $database->Quote( $currip )
				. "\n WHERE content_id = " . (int) $cid;
				$database->setQuery( $query );
				$database->query() or die( $database->stderr() );
			} else {
				$query = "SELECT rating_count FROM #__content_rating WHERE content_id = " . (int) $cid;
				$database->setQuery( $query );
				echo $database->loadResult();
			}
		}
		return 1;
	}
	
}

function getPercentage (){
	global $database;
	$result = 0;

	$id = intval( $_GET['cid'] );

	$database->setQuery('SELECT * FROM #__content_rating WHERE content_id='.$id);
	$database->loadObject($vote);

	if($vote->rating_count!=0){
		$result = number_format(intval($vote->rating_sum) / intval( $vote->rating_count ),2)*100;
	}

	echo $result;
}