| |
if ( $numsub==10 ) $temp=50; else $temp=10;
if ( ! $id ) echo "Senaste $numsub översättningarna ($temp)"; else echo "Subinfo";
?>
|
|
| |
if ( ! $id ) {
$sql = "select * from subs where file != '' order by date desc limit 0,".$numsub;
$res = mysql_query($sql, $db);
while ( $s = mysql_fetch_row($res) ) {
echo "$s[1]
";
}
} else {
$sql = "select * from subs where id=$id";
$res = mysql_query($sql, $db);
while ( $s = mysql_fetch_row($res) ) {
if ( $s[3] ) $checked="checked";
else $checked="";
echo "| Swe.titel |
$s[1] |
| Eng.titel |
$s[7] |
| FPS |
$s[2] |
| CDs |
$s[3] |
| Översättare |
";
$sql = "select username,id from user order by username";
$r = mysql_query($sql, $db);
while ($q = mysql_fetch_row($r) ) {
$u = explode(",", $s[12]);
foreach ( $u as $bice ) if ( $bice == $q[1] ) echo "$q[0] " ;
}
echo " | ";
if ( $s[10] ) {
echo "| Rippad av |
$s[10] | ";
}
if ( $s[13] ) {
echo "| Övrigt |
$s[13] | ";
}
if ( $s[14] ) {
echo "| Downloads |
$s[14] | ";
}
echo " | Ladda ner
|
";
}
}
?>
|
|
| |
|
|
if ( ! $id ){
# $sql = "select * from subs where file != '' and downloads != 0 order by downloads desc limit 0,".$numtop;
$sql = "select id,namn,sum(downloads) as nof from subs group by namn order by nof desc limit 0,".$numtop;
$res = mysql_query($sql, $db);
$num = mysql_num_rows($res);
?>
| |
if ( $numtop==5 ) $temp=50; else $temp=5;
echo "$num mest nerladdade ($temp)";
?>
|
|
| |
while ( $s = mysql_fetch_row($res) ) {
echo "$s[1]
($s[2]) ";
}
?>
|
|
| |
|
|
}
?>
|
| |
Undertextarkivet (Innehållande översättningar) |
|
include("top10.php");
?>
|
# phpcode (c) 2002 Urban Jonsson (ube@planeturban.net) this code may not be copied or redistributed without permission from the author ?>