echo "
0 ".$locale['415'].$locale['422'].".\n";
}
closetable();
if ($rows > 10) echo "\n".makePageNav($rowstart,10,$rows,3,FUSION_SELF."?stype=f&stext=$stext&")."\n
\n";
} elseif ($stype == "d") {
$result = dbquery(
"SELECT td.*,tdc.* FROM ".$db_prefix."downloads td
INNER JOIN ".$db_prefix."download_cats tdc ON td.download_cat=tdc.download_cat_id
WHERE ".groupaccess('download_cat_access')." AND (download_title LIKE '%$stext%' || download_description LIKE '%$stext%')"
);
$rows = dbrows($result);
if ($rows != 0) {
echo $rows." ".($rows == 1 ? $locale['416'] : $locale['417']).$locale['422'].":
\n";
$result = dbquery(
"SELECT td.*,tdc.* FROM ".$db_prefix."downloads td
INNER JOIN ".$db_prefix."download_cats tdc ON td.download_cat=tdc.download_cat_id
WHERE ".groupaccess('download_cat_access')." AND (download_title LIKE '%$stext%' || download_description LIKE '%$stext%')
ORDER BY download_title LIMIT $rowstart,10"
);
$i = 1;
while ($data = dbarray($result)) {
if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
$new = " ".$locale['450']."";
} else {
$new = "";
}
echo "".$data['download_title']." - ".$data['download_filesize']." $new
\n";
if ($data['download_description'] != "") echo $data['download_description']."
\n";
echo "".$locale['451']." ".$data['download_license']." |
".$locale['452']." ".$data['download_os']." |
".$locale['453']." ".$data['download_version']."
".$locale['454']." ".showdate("%d.%m.%y", $data['download_datestamp'])." |
".$locale['455']." ".$data['download_count']."\n";
if ($i != $numrows) { echo "
\n"; } else { echo "\n"; }
$i++;
}
} else {