$file_bd = "'pdf','jpg'";
$time_period = 90;
$time = time() - 86400*$time_period;
$query = ' SELECT f.id, a.id as aid'
. ' FROM jos_brief_files f, jos_brief_accesses a'
. ' WHERE f.date_create < \'' . date("Y-m-d H:i:s", $time) . '\' and f.id = a.fileid and f.filetype in ({$file_bd})';
$database->setQuery($query);

 
   $mainframe =& JFactory::getApplication('site');
    $database =& JFactory::getDBO();
    $query = ' SELECT u.id'
        . ' FROM jos_users u'
        . ' WHERE u.username = \'' . $id . '\'';
    $database->setQuery($query);

$sql_host = 'localhost';
$sql_user = 'mysite_client';
$sql_pass = 'ldaslLLKDlsajld';
$sql_db = 'mysite_client';
$sql_table = 'xeoport';

$sql_link = mysql_connect("$sql_host", "$sql_user", "$sql_pass") or die('not connect');
mysql_select_db("$sql_db");

$query = ' SELECT f.id, a.id as aid'
	. ' FROM jos_brief_files f, jos_brief_accesses a'
           . ' WHERE f.date_create < \'' . date("Y-m-d H:i:s", $time) . '\' and f.id = a.fileid and f.filetype in ({$file_bd})';

$query = "SELECT f.id, a.id as aid FROM jos_brief_files f, jos_brief_accesses a WHERE f.date_create < '" . date("Y-m-d H:i:s", $time) . "' and f.id = a.fileid and f.filetype in ({$file_bd})";