$result = dbquery(
"SELECT * FROM ".$db_prefix."master_download_files
WHERE file_name LIKE '%$stext%' || file_desc LIKE '%$stext%'"
);
$rows = dbrows($result);
if ($rows != 0) {
echo $rows." ".($rows == 1 ? $locale['416'] : $locale['417']).$locale['422'].":
\n";
$result = dbquery(
"SELECT * FROM ".$db_prefix."master_download_files
WHERE file_name LIKE '%$stext%' || file_desc LIKE '%$stext%'
ORDER BY file_name DESC 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['file_name']." $new
\n";
if ($data['file_desc'] != "") echo stripslashes($data['file_desc'])."
\n";
echo "".$locale['454']." ".showdate("%d.%m.%y", $data['file_date'])." | ".$locale['455']." ".$data['file_count']."\n";
if ($i != $numrows) { echo "
\n"; } else { echo "\n"; }