Public feed
#380336
$searchReqs = str_replace(" ", "%", $searchReqs['s'] ); $sql = sprintf("SELECT fileid,file_downloads,file_disp,file_cat,file_desc,cu.username,cat_name,cat_disp,TIMESTAMPDIFF(DAY, file_add_date, NOW()) AS file_days, TIMESTAMPDIFF(HOUR, file_add_date, NOW()) AS file_hours,TIMESTAMPDIFF(MINUTE, file_add_date, NOW()) AS file_minutes FROM com_files cf LEFT JOIN com_users cu ON cf.file_owner=cu.userid LEFT JOIN com_categories ON file_cat=catid WHERE file_disp LIKE '%s' AND file_active = 1 ORDER BY file_downloads DESC LIMIT $start, 15", mysql_escape_string($searchReqs));