title = $aInt->lang('system', 'emailmessagelog');
$aInt->sidebar = 'utilities';
$aInt->icon = 'logs';
$aInt->sortableTableInit('date');
$select_keyword = 'SQL_CALC_FOUND_ROWS';
$result = select_query('tblemails,tblclients', $select_keyword . " tblemails.id,tblemails.date,tblemails.subject,tblemails.userid,tblclients.firstname,tblclients.lastname", "tblemails.userid=tblclients.id", "tblemails`.`id", 'DESC', $page * $limit . ',' . $limit);
while( $data = mysql_fetch_array($result) )
{
$id = (int) $data['id'];
$date = WHMCS_Input_Sanitize::makesafeforoutput($data['date']);
$subject = WHMCS_Input_Sanitize::makesafeforoutput($data['subject']);
$userid = (int) $data['userid'];
$firstname = WHMCS_Input_Sanitize::makesafeforoutput($data['firstname']);
$lastname = WHMCS_Input_Sanitize::makesafeforoutput($data['lastname']);
$tabledata[] = array( fromMySQLDate($date, 'time'), "" . $subject . "", "" . $firstname . " " . $lastname . "", "![\""](\"images/icons/resendemail.png\")
lang('emails', 'resendemail') . "\">" );
}
if( !count($tabledata) )
{
$numrows = 0;
}
else
{
$result = full_query("SELECT FOUND_ROWS()");
$data = mysql_fetch_array($result);
$numrows = $data[0];
}
$content = $aInt->sortableTable(array( $aInt->lang('fields', 'date'), $aInt->lang('fields', 'subject'), $aInt->lang('system', 'recipient'), '' ), $tabledata);
$aInt->content = $content;
$aInt->display();