/** VIEW RATES **/
function rate($result, $i)
{
include 'db_connect.php';
$avgRate = avgRating(mysql_result($result, $i, 'productId'));
$roundRate = round($avgRate, 0, PHP_ROUND_HALF_DOWN);
$maxRate = 5;
$numRate = numRate(mysql_result($result, $i, 'productId'));
?>
<table align="center"> <tr> <?php
/** View rates via monkeys **/
for ($j = 0; $j < $roundRate; $j++) {
if (isLoggedIn()) {
?>
<form action="?p=rate" method="post">
<td><input type="hidden" id="rate" name="rate" value="<?php
echo $j + 1;
?>
"></td>
<td><input type="hidden" id="prodId" name="prodId" value="<?php
echo mysql_result($result, $i, 'productId');
?>
"></td>
<td><input class="rateFill" type="image" src="commentsRatings/monkey.png" alt="Submit"> </td>
</form>
<?php
} else {
?>
<td><img class="rateFill" src="commentsRatings/monkey.png" alt="monkey"></td>
<?php
}
}
/** View rest of monkeys with lower opacity **/
for ($k = 0; $k < $maxRate - $roundRate; $k++) {
if (isLoggedIn()) {
?>
<form action="?p=rate" method="post">
<td><input type="hidden" id="rate" name="rate" value="<?php
echo $roundRate + $k + 1;
?>
"></td>
<td><input type="hidden" id="prodId" name="prodId" value="<?php
echo mysql_result($result, $i, 'productId');
?>
"></td>
<td><input class="rateTotal" type="image" src="commentsRatings/monkey.png" alt="Submit"></td>
</form>
<?php
} else {
?>
<td><img class="rateTotal" src="commentsRatings/monkey.png" alt="monkey"></td>
<?php
}
}
echo "</tr></table>";
echo "<small> [" . $avgRate . "/" . $maxRate . "] " . $numRate . " votes</small>";
}
return 0;
} else {
return $rating['ratings'] / $rating['raters'];
}
}
$articleQuery = "select a.*,u.name from articles as a, user as u where a.id = " . $_REQUEST['id'] . " and u.id = a.uid";
$articleRes = mysql_query($articleQuery);
if (mysql_num_rows($articleRes) == 0) {
echo "<li><p class=\"none\">Article has been moved or deleted</p></li>";
} else {
$article = mysql_fetch_array($articleRes);
$title = $article['title'];
$name = $article['name'];
$dos = date("j-m-Y", strtotime($article['dos']));
$text = $article['text'];
$artId = $_REQUEST['id'];
$avgRating = avgRating($artId);
echo <<<VIEWER
<span class="title">{$title}</span>
<br><br>
<span class="who">{$name}</span>
<span class="when">Submitted on {$dos}</span>
<span class="rating">Average rating: {$avgRating}</span>
<br>
<br>
<span class="txt">{$text}</span>
VIEWER;
}
<option value="topRated" id="topRatedo" class="son">Top Rated</option>
<option value="mostViewed" id="mostViewedo" class="soff">Most Viewed</option>
<option value="mostDownloaded" id="mostDownloadedo" class="soff">Most Downloaded</option>
</select>
</td></tr></table><br />
<?php
//Top Rated
$max = 10;
echo '<table id="topRatedc" class="shown" cellpadding="0" cellspacing="0" border="0">';
unset($tracks);
$inc = 0;
$blankinc = 0;
unset($tracks, $rating);
$result = mysql_query("SELECT * FROM tracks");
while ($row = mysql_fetch_array($result)) {
$rating[] = round(avgRating($row['rating']) * 16) + 2;
$tracks[] = $row['id'];
}
if (count($rating) > 0) {
array_multisort($rating, SORT_DESC, $tracks);
if (count($rating) < $max) {
$max = count($rating);
}
for ($i = 0; $i < $max; $i++) {
$infoTag = "Created by " . getInfo($tracks[$i], "author");
echo '<tr><td align="right">' . intval($i + 1) . '. </td><td align="left"><a href="track.php?id=' . $tracks[$i] . '" title="' . $infoTag . '">' . getInfo($tracks[$i], "label") . '</a></td></tr>';
echo '<tr><td></td><td>';
echo '<table align="center" cellpadding="0" cellspacing="0"><tr><td>Rating:</td><td width="8"></td><td width="' . $rating[$i] . '" height="16" style="background: url(\'images/stars.png\') top left;"></td><td width="' . (86 - $rating[$i]) . '" height="16" style="background: url(\'images/nostars.png\') top right;"></td></tr></table>';
echo '</td>';
}
} else {
if ($_SESSION['user'] != $author && isset($_SESSION['user'])) {
echo '<tr class="trshown" id="ratebutton"><td colspan="4" align="center"><input type="button" value="Rate It!" class="rateit" onclick="rateIt();"></td></tr>';
echo '<tr class="hidden" id="rateline"><td colspan="4" align="center"><table cellpadding="0" cellspacing="0" border="0"><tr><td><select name="rating">';
echo '<option>No Rating</option>';
for ($i = 1; $i <= 5; $i++) {
echo '<option value="' . $i . '">' . $i . ' Stars</option>';
}
echo '</select></td><td width="4"></td><td><a href="#"><img src="images/check.gif" border="0" onclick="document.edit.submit();"></a></td></tr></table></td></tr>';
}
echo '</table>';
echo '<br />';
} else {
$result = mysql_query("SELECT * FROM tracks WHERE id=" . $_REQUEST['id']);
$row = mysql_fetch_array($result);
$ratedby = count(explode(chr(0), $row['rating']));
$rnum = avgRating($row['rating']);
// Real number/rating
$num = $rnum * 16 + 2;
// Num should be a number between 0 and 80
echo '<table align="center" cellpadding="0" cellspacing="0"><tr><td style="font-weight: bold;">Track Rating:</td><td width="8"></td><td width="' . $num . '" height="16" style="background: url(\'images/stars.png\') top left;" title="Rated by ' . $ratedby . ' users."></td><td width="' . (86 - $num) . '" height="16" style="background: url(\'images/nostars.png\') top right;" title="Rated ' . $rnum . ' by ' . count($rating) . ' users."></td><td width="8"></td><td title="Rated ' . $rnum . ' by ' . count($rating) . ' users.">(' . round($rnum, 1) . ')</td></tr>';
if ($_SESSION['user'] != $author && isset($_SESSION['user'])) {
if ($found) {
echo '<tr class="trshown" id="ratebutton"><td colspan="4" align="center"><input type="button" value="Rate It!" class="rateit" onclick="rateIt();"></td></tr>';
echo '<tr class="hidden" id="rateline"><td colspan="4" align="center"><table cellpadding="0" cellspacing="0" border="0"><tr><td><select name="rating">';
for ($i = 1; $i <= 5; $i++) {
echo '<option value="' . $i . '"';
if ($def == $i) {
echo ' selected="yes"';
}
echo '>' . $i . ' Stars</option>';
}
?>
<a href="single.php?videoid=<?php
echo $videoId;
?>
&contestid=<?php
echo $contestId;
?>
">Readmore</a></p>
</div>
<div class="ratings">
<div class="videoRateing">
<div id="ratings"></div>
<strong><?php
echo avgRating($videoId);
?>
</strong>
<div id="rate_status"></div>
</div>
</div>
</div>
</div>
<?php
}
?>
echo '
<div id="cse-search-results"></div>
<script type="text/javascript">
var googleSearchIframeName = "cse-search-results";
var googleSearchFormName = "cse-search-box";
var googleSearchFrameWidth = 800;
var googleSearchDomain = "www.google.com";
var googleSearchPath = "/cse";
</script>
<script type="text/javascript" src="http://www.google.com/afsonline/show_afs_search.js"></script>
';
/*********** GOOGLE ANALYTICS SEARCH RESULTS ************/
echo '<table cellpadding="0" cellspacing="0" border="0" width="100%">';
echo '<tr><td width="6%" class="header" align="right">ID <a href="tracks.php?a=id&o=asc"><img src="images/asc.png" border="0"></a><a href="tracks.php?a=id&o=desc"><img src="images/desc.png" border="0"></a></td><td width="1%"></td><td width="28%" class="header">Name <a href="tracks.php?a=name&o=asc"><img src="images/asc.png" border="0"></a><a href="tracks.php?a=name&o=desc"><img src="images/desc.png" border="0"></a></td><td width="14%" class="header">Author <a href="tracks.php?a=author&o=asc"><img src="images/asc.png" border="0"></a><a href="tracks.php?a=author&o=desc"><img src="images/desc.png" border="0"></a></td><td width="16%" class="header">Creation Date <a href="tracks.php?a=created&o=asc"><img src="images/asc.png" border="0"></a><a href="tracks.php?a=created&o=desc"><img src="images/desc.png" border="0"></a></td><td width="9%" class="header">Views <a href="tracks.php?a=views&o=asc"><img src="images/asc.png" border="0"></a><a href="tracks.php?a=views&o=desc"><img src="images/desc.png" border="0"></a></td><td width="13%" class="header">Downloads <a href="tracks.php?a=downloads&o=asc"><img src="images/asc.png" border="0"></a><a href="tracks.php?a=downloads&o=desc"><img src="images/desc.png" border="0"></a></td></tr>';
while ($row = mysql_fetch_array($result)) {
$row['avg'] = avgRating($row['rating']) * 16 + 2;
echo '<tr height="16" class="dull" onMouseOver="this.className=\'bright\';" onMouseOut="this.className=\'dull\';"><td align="right"><a href="track.php?id=' . $row['id'] . '" title="Track #' . $row['id'] . '">' . $row['id'] . '.</a></td><td></td><td><b><a href="track.php?id=' . $row['id'] . '">' . $row['label'] . '</a></b></td><td><a href="analyze.php?u=' . $row['author'] . '"';
if (rights($row['author']) == 'admin') {
echo ' style="color: #CC0000;" title="' . $row['author'] . ' is an administrator."';
} elseif (rights($row['author']) == 'moderator') {
echo ' style="color: #00CC00;" title="' . $row['author'] . ' is a moderator."';
}
echo '>' . $row['author'] . '</a></td><td>' . date("n/d/y (g:i A)", $row['created']) . '</td>';
echo '<td>' . $row['views'] . '</td><td>' . $row['downloads'] . '</td></tr>';
}
echo '<tr><td colspan="7"><hr size="1" color="#666699" /></td></tr>';
echo '<tr><td colspan="7"><form name="options" action="tracks.php" method="GET">
<input type="button" value="< Back" onclick="document.options.from.value = ' . ($_REQUEST['from'] - 100) . '; document.options.to.value = ' . $_REQUEST['from'] . '; document.options.submit();" ' . ($_REQUEST['from'] < 100 ? 'disabled="true"' : '') . '>
<input type="button" value="Next >" onclick="document.options.from.value = ' . ($_REQUEST['from'] + 100) . '; document.options.to.value = ' . ($_REQUEST['from'] + 200) . '; document.options.submit();" ' . ($_REQUEST['to'] > $last - 100 ? 'disabled="true"' : '') . '>
