\n"; echo " \n"; echo " \n"; echo "
System Update Log     

\n"; if (!empty($_REQUEST['slFilter'])) { $slFilter = ""; $filtList = explode("|", $_REQUEST['slFilter']); foreach($filtList as $filt) $slFilter .= " and note like '%$filt%'"; } $q = "select * from logents where eType='u'$slFilter order by lastmod desc limit 18"; $r = sqlEx($q); if (mysql_num_rows($r)) { echo "\n"; while ($record = mysql_fetch_assoc($r)) { echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "
".formatDateAndTime($record['wDate'].$record['wStart'])."".$record['note']; if ($_SESSION['user']['empNo'] == 3) echo " (".date("Y.m.d H:i", substr($record['note'], -11)).")"; // echo " (".date("Y.m.d H:i", substr(substr($record['note'], -11), 0, 10)).")"; echo "
\n"; } else echo "No records
\n"; echo "
Last Touches and Updates

\n"; $q = "select * from (select * from touches order by tdate desc) as dummy group by remote_unit order by remote_unit"; $r = sqlEx($q); if (mysql_num_rows($r)) { echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($record = mysql_fetch_assoc($r)) { $q = "select * from logents where eType='u' and note like '{$record['remote_unit']}:%' order by lastmod desc limit 1"; $lud = sqlEx($q); if (mysql_num_rows($lud)) { $lud = mysql_fetch_assoc($lud); $lud = formatDateAndTime($lud['wDate'].$lud['wStart']); } else $lud = ""; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; } echo "
RemoteTouchUpdate
".$record['remote_unit']."".formatDateandTime($record['lastmod'])."$lud
\n"; } else echo "No records
\n"; echo "\t\t\t\n"; ?>