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 {