/** 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"' : '') . '>