public static function search($id = '', $userid = '', $action = '')
{
$where = '';
if (!empty($id)) {
$where .= " log.`id`={$id} AND";
}
if (!empty($userid)) {
$where .= " log.`userid`={$userid} AND";
}
if (!empty($action)) {
$where .= " log.`action`='{$action}' AND";
}
if (substr($where, -3) == "AND") {
$where = substr($where, 0, -3);
}
//
$logs = array();
$query = "\n\t\t\tSELECT\tlog.`id` AS id,\n log.`time` AS time,\n log.`userid` AS userid,\n log.`ipAddress` AS ipAddress,\n log.`action` AS action,\n log.`url` AS url,\n log.`info` AS info\n\t\t\tFROM\t`" . SESSION_NAME . "log` log\n WHERE {$where}";
//echo "query-->{$query}<br>";
if (!sql_select($query, $results)) {
return false;
}
settype($response, 'array');
while ($row = $results->fetch(PDO::FETCH_ASSOC)) {
$nlog = Log::load($row['id']);
$response[] = $nlog;
}
return $response;
}