\n"; debug(3); // generate log listing $q = "select * from changelog "; // -> date? if (!empty($_SESSION['changelogsearch']['fdate'])) { echo "\n"; $sdate = "log_date >= '".str_replace(array("-",".","/","\\",":"),"", $_SESSION['changelogsearch']['fdate'])."'"; } if (!empty($_SESSION['changelogsearch']['tdate'])) { if (!empty($sdate)) { echo "\n"; $sdate .= " and "; } $sdate .= "log_date <= '".str_replace(array("-",".","/","\\",":"),"", $_SESSION['changelogsearch']['tdate'])."'"; } if (!empty($sdate)) $sldate = " and ($sdate)"; echo "\n"; // -> start time? // -> end time? if (!empty($_SESSION['changelogsearch']['expression'])) { // we have a search target; is it text or regex? if ($_SESSION['changelogsearch']['type'] == "TEXT") { // text search $q .= "where {$_SESSION['changelogsearch']['target']} LIKE '%{$_SESSION['changelogsearch']['expression']}%'".$sldate." "; } else if ($_SESSION['changelogsearch']['type'] == "REGEX") { // regex search $q .= "where {$_SESSION['changelogsearch']['target']} REGEXP '{$_SESSION['changelogsearch']['expression']}'$sldate "; } else { // free-form sql search //$q .= "where ".str_replace("´", "'", $_SESSION['changelogsearch']['expression'])." "; $q .= "where {$_SESSION['changelogsearch']['expression']} "; } if (!empty($_SESSION['changelogsearch']['client'])) $q .= "and log_client = '{$_SESSION['changelogsearch']['client']}' "; } else if (!empty($sdate)) { $q .= "where $sdate "; } $q .= "order by log_date desc,log_start desc,log_end desc"; if (!empty($_SESSION['changelogsearch']['listlimit'])) $q .= " limit ".$_SESSION['changelogsearch']['listlimit']; $logList = sqlEx($q); debugMarker("Log Query: \"$q\""); $_SESSION['changelogsearch']['cnt'] = mysql_num_rows($logList); if ($_SESSION['changelogsearch']['cnt'] == 0) echo "No Responsive Records
\n"; else { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; echo " \n"; while ($logentry = mysql_fetch_assoc($logList)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; } echo "

Date	Start	End	Source	Method	Area	Comment
".formatDate($logentry['log_date'])."	".formatTime($logentry['log_start'])."	".formatTime($logentry['log_end'])."	{$logentry['log_source']}	{$logentry['log_method']}	{$logentry['log_area']}	".str_replace("\n", " ", $logentry['log_comment'])."
	{$logentry['log_tags']}

\n"; } //debug(3); echo "\n"; ?>