. */ include "../inc.php"; ?> <?=$appname; ?> - Admin
Filtering
Date (YYYY-MM-DD)

to
Type
Filename
Source IP
Email
Show:
> Date
> Type
> Filename
> Source IP
 
> Source Email
> Destination Email
> Browser

= "' . $searchdate . '"'; elseif (isset($searchdate) && $searchdate != '' && isset($searchdate2) && $searchdate2 != '') $querymid .= ' and moddate between "' . $searchdate . '" and "' . $searchdate2 . '"'; elseif (isset($searchdate2) && $searchdate2 != '' && (! isset($searchdate) || $searchdate == '')) $querymid .= ' and moddate <= "' . $searchdate2 . '"'; //if (isset($searchdate2) && $searchdate2 != '') $querymid .= ' and moddate between "' . $searchdate . '" and "' . $searchdate2 . '"'; //elseif (isset($searchdate) && $searchdate != '') $querymid .= ' and moddate = "' . $searchdate . '"'; if (isset($type) && $type != '') $querymid .= ' and type = "' . $type . '"'; if (isset($filename) && $filename != '') $querymid .= ' and filename like "%' . $filename . '%"'; if (isset ($srcip) && $srcip != '') $querymid .= ' and srcip like "%' . $srcip . '%"'; if (isset($email) && $email != '') $querymid .= ' and (srcemail like "%' . $email . '%" or dstemail like "%' . $email . '%")'; if ($querymid == '') $querymid = ' and moddate = "' . $mydate . '"'; // needs "and" part or the below substr command will fail; $queryend = ' order by id'; $querymid = ' ' . substr($querymid,strpos($querymid,'and ')+4); $query = $querystart . $querymid . $queryend; $res = mysql_query($query,$dbh) or die("

A fatal database error occured.\n
Query: " . $query . "
\nError: (" . mysql_errno() . ") " . mysql_error()); while ($row = mysql_fetch_row($res)) { ?>

Date Type File Source IP From To Browser
Back to admin page

'; } print $footer; ?>