Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('mysql.php');
- include('functions.php');
- // Get random 2
- $query="SELECT * FROM images ORDER BY RAND() LIMIT 0,2";
- $result = @mysql_query($query);
- while($row = mysql_fetch_object($result)) {
- $images[] = (object) $row;
- }
- // Get the top10
- $result = mysql_query("SELECT *, ROUND(score/(1+(losses/wins))) AS performance FROM images ORDER BY ROUND(score/(1+(losses/wins))) DESC LIMIT 0,10");
- while($row = mysql_fetch_object($result)) $top_ratings[] = (object) $row;
- // Close the connection
- mysql_close();
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
- <title>title_add_here</title>
- <style type="text/css">
- body, html {font-family:Arial, Helvetica, sans-serif;width:100%;margin:0;padding:0;text-align:center;}
- h1 {background-color:#600;color:#fff;padding:20px 0;margin:0;}
- a img {border:0;}
- td {font-size:11px;}
- .image {background-color:#eee;border:1px solid #ddd;border-bottom:1px solid #bbb;padding:5px;}
- </style>
- <script type="text/javascript">
- var _gaq = _gaq || [];
- _gaq.push(['_setAccount', 'UA-25273091-1']);
- _gaq.push(['_trackPageview']);
- (function() {
- var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
- ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
- var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
- })();
- </script>
- </head>
- <body>
- <h1>website_name/url</h1>
- <h2>arvizturotukorfurogep_vagy_arvizturotukorfurogep</h2>
- <center>
- <table>
- <tr>
- <td valign="top" class="image"><a href="rate.php?winner=<?=$images[0]->image_id?>&loser=<?=$images[1]->image_id?>"><img src="images/<?=$images[0]->filename?>" /></a></td>
- <td valign="top" class="image"><a href="rate.php?winner=<?=$images[1]->image_id?>&loser=<?=$images[0]->image_id?>"><img src="images/<?=$images[1]->filename?>" /></a></td>
- </tr>
- <tr>
- <td>Won: <?=$images[0]->wins?>, Lost: <?=$images[0]->losses?></td>
- <td>Won: <?=$images[1]->wins?>, Lost: <?=$images[1]->losses?></td>
- </tr>
- <tr>
- <td>Score: <?=$images[0]->score?></td>
- <td>Score: <?=$images[1]->score?></td>
- </tr>
- <tr>
- <td>Expected: <?=round(expected($images[1]->score, $images[0]->score), 4)?></td>
- <td>Expected: <?=round(expected($images[0]->score, $images[1]->score), 4)?></td>
- </tr>
- </table>
- </center>
- <h2>top_csajok</h2>
- <center>
- <table>
- <tr>
- <? foreach($top_ratings as $key => $image) : ?>
- <td valign="top"><img src="images/<?=$image->filename?>" width="70" /></td>
- <? endforeach ?>
- </tr>
- <? /* Remove this to see the scoring
- <tr>
- <? foreach($top_ratings as $key => $image) : ?>
- <td valign="top">Score: <?=$image->score?></td>
- <? endforeach ?>
- </tr>
- <tr>
- <? foreach($top_ratings as $key => $image) : ?>
- <td valign="top">Performance: <?=$image->performance?></td>
- <? endforeach ?>
- </tr>
- <tr>
- <? foreach($top_ratings as $key => $image) : ?>
- <td valign="top">Won: <?=$image->wins?></td>
- <? endforeach ?>
- </tr>
- <tr>
- <? foreach($top_ratings as $key => $image) : ?>
- <td valign="top">Lost: <?=$image->losses?></td>
- <? endforeach ?>
- </tr>
- */ ?>
- </table>
- </center>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement