mirror of
https://github.com/psenough/pouet.net.git
synced 2025-01-16 12:49:42 +01:00
117 lines
3.6 KiB
PHP
117 lines
3.6 KiB
PHP
<?
|
|
require("include/top.php");
|
|
|
|
if ($platform == 'any platform')
|
|
unset($platform);
|
|
if ($type == 'prods')
|
|
unset($type);
|
|
|
|
// get all the platforms
|
|
$query="select * from platforms order by name asc";
|
|
$result = mysql_query($query);
|
|
while($tmp = mysql_fetch_array($result)) {
|
|
$platforms[]=$tmp;
|
|
}
|
|
|
|
// get all the types
|
|
unset($tmp);
|
|
unset($types);
|
|
$result = mysql_query("DESC prods type");
|
|
$row = mysql_fetch_row($result);
|
|
$tmp = explode("'",$row[1]);
|
|
for($i=1;$i<count($tmp);$i+=2)
|
|
$types[]=$tmp[$i];
|
|
|
|
// get the top 10 prods
|
|
unset($tmp);
|
|
$query ="SELECT prods.id,prods.name,prods.group1,prods.group2,prods.group3,prods.type ";
|
|
$query.="FROM prods ";
|
|
if ($platform) $query.=", prods_platforms, platforms ";
|
|
$query.="WHERE rank!=0 ";
|
|
if ($platform)
|
|
$query.="and prods_platforms.platform=platforms.id and platforms.name='".$platform."' and prods_platforms.prod=prods.id ";
|
|
if ($type)
|
|
$query.="AND FIND_IN_SET('".$type."',prods.type)>0 ";
|
|
$query.="ORDER BY rank ASC LIMIT ".min(max(10,$_GET["limit"]),100);
|
|
// print($query);
|
|
$result = mysql_query($query);
|
|
while($tmp = mysql_fetch_assoc($result)) {
|
|
$top10[] = $tmp;
|
|
}
|
|
for($j=0;$j<count($top10);$j++) {
|
|
$query="SELECT name FROM groups WHERE id=".$top10[$j]["group1"];
|
|
$result=mysql_query($query);
|
|
if(mysql_num_rows($result))
|
|
$top10[$j]["groupname1"]=mysql_result($result,0);
|
|
$query="SELECT name FROM groups WHERE id=".$top10[$j]["group2"];
|
|
$result=mysql_query($query);
|
|
if(mysql_num_rows($result))
|
|
$top10[$j]["groupname2"]=mysql_result($result,0);
|
|
$query="SELECT name FROM groups WHERE id=".$top10[$j]["group3"];
|
|
$result=mysql_query($query);
|
|
if(mysql_num_rows($result))
|
|
$top10[$j]["groupname3"]=mysql_result($result,0);
|
|
}
|
|
?>
|
|
<br />
|
|
<form action="<?=basename($_SERVER['SCRIPT_FILENAME'])?>" method="get">
|
|
<table bgcolor="#000000" cellspacing="1" cellpadding="0">
|
|
<tr>
|
|
<td>
|
|
<table bgcolor="#000000" cellspacing="1" cellpadding="2" width="100%">
|
|
<tr>
|
|
<td bgcolor="#224488">
|
|
<table width="100%"><tr>
|
|
<td><b>top 10</b></td>
|
|
<td>
|
|
<select name="type">
|
|
<option>prods</option>
|
|
<? foreach ($types as $t) { ?>
|
|
<? if ($type == $t) : ?>
|
|
<option selected><?=$t?></option>
|
|
<? else : ?>
|
|
<option><?=$t?></option>
|
|
<? endif; ?>
|
|
<? } ?>
|
|
</select>
|
|
</td>
|
|
<td><b>on</b></td>
|
|
<td>
|
|
<select name="platform">
|
|
<option>any platform</option>
|
|
<? foreach ($platforms as $p) { ?>
|
|
<? if ($platform == $p["name"]) : ?>
|
|
<option selected><?=$p["name"]?></option>
|
|
<? else : ?>
|
|
<option><?=$p["name"]?></option>
|
|
<? endif; ?>
|
|
<? } ?>
|
|
</select>
|
|
</td>
|
|
<td><input type="image" src="gfx/submit.gif"></td>
|
|
</tr></table>
|
|
</td>
|
|
</tr>
|
|
<? for($j=0;$j<count($top10);$j++): ?>
|
|
<tr>
|
|
<td bgcolor="#446688">
|
|
<?=$j+1?>.
|
|
<b><a href="prod.php?which=<?=$top10[$j]["id"]?>"><?=$top10[$j]["name"]?></a></b>
|
|
<? if(strlen($top10[$j]["groupname1"])>0): ?>
|
|
by <a href="groups.php?which=<? print($top10[$j]["group1"]); ?>"><? print(strtolower($top10[$j]["groupname1"])); ?></a>
|
|
<? endif; ?>
|
|
<? if(strlen($top10[$j]["groupname2"])>0): ?> & <a href="groups.php?which=<? print($top10[$j]["group2"]); ?>"><? print(strtolower($top10[$j]["groupname2"])); ?></a>
|
|
<? endif; ?>
|
|
<? if(strlen($top10[$j]["groupname3"])>0): ?> & <a href="groups.php?which=<? print($top10[$j]["group3"]); ?>"><? print(strtolower($top10[$j]["groupname3"])); ?></a>
|
|
<? endif; ?>
|
|
</td>
|
|
</tr>
|
|
<? endfor; ?>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
<br />
|
|
<? require("include/bottom.php"); ?>
|