Log of calls to RHaworth.com

\n"; if (strlen($_REQUEST['orby'])<1) $_REQUEST['orby']='datim'; $opthash= $_REQUEST['shown'] . $_REQUEST['orby'] . $_REQUEST['groub']; if (strcmp($_REQUEST['optha'],$opthash)<>0) $_REQUEST['lfrom']=0; if ($_REQUEST['lfor']<=0) $_REQUEST['lfor']=250; echo "

\n". "\n". "\n\n". '\n". "

\n"; sel_db(''); $sres=mysql_query("select * from sldriver"); $j=0; echo ""; while ($row=mysql_fetch_array($sres)) { if (strlen($row['key'])!=0) { echo "\n". ($row['rowend'] ? "\n" : ""); } else { echo "\n"; } } echo ' ". $row['rpdesc'] ." '; echo "

Show hidden calls \n". ' Group rows

From item number \n". 'for items '. ''. '

'. "

\n"; $drivl = mysql_fetch_array( mysql_query("select * from sldriver where `key`='". $_REQUEST['orby'] ."'") ) or die("Report type ". $_REQUEST['orby'] ." not recognised"); # echo '

dirivl:'. var_export( $drivl, TRUE ) .'

'; sel_db('log'); $msq ="SELECT `callog`.*,`name`,`fixtype`". ($_REQUEST['groub'] ? ',count(*) as `ctr` ' : ''). "FROM `callog` ". "left join `known_ips` ON `callog`.`ipaddr` = `known_ips`.`ipaddr` ". "left join `rh_com_fix` on `callog`.`pagename` = `rh_com_fix`.`pagename` ". " where $wherecl ". ($_REQUEST['groub'] ? 'group by '. $drivl['groubystr'] .' ' : ''). 'ORDER BY '. $drivl['querystr'] . ' limit '. $_REQUEST['lfrom'] .','. $_REQUEST['lfor']; $sres= mysql_query($msq); $cdn= mysql_num_rows($sres); if (mysql_errno()) echo $msq .'
sres = '. $sres .' error = '. mysql_error() .'
'; echo "\n"; echo "". ($_REQUEST['shown'] ? '' : ''). ($_REQUEST['groub'] ? '' : ''). "". "\n"; echo "". ($_REQUEST['shown'] ? '' : ''). "". ($_REQUEST['groub'] ? "" : ""). "\n"; $row = mysql_fetch_assoc($sres); // get first #echo '

'. var_export( $row, TRUE ) .'

'; while ($row) { echo "\n"; echo '\n"; if ($_REQUEST['shown']) echo ""; echo '\n"; if ($_REQUEST['groub']) { echo "\n"; } $reslink= $row['pagename'] . (strlen($row['params'])>0 ? '?' : '') . $row['params']; echo "". "\n"; echo '\n"; echo '\n"; echo "\n"; $row = mysql_fetch_array($sres); // get next } echo "

	h	= hidden			n	= no fix offered yet	Hover mouse over browser ". "name to see full description
datim		IP addr	ctr	f	resource	referer	browser
'. str_replace(' ',' ',$row['datim']) ."	". ($row['hide'] ? 'h' : '') ."	'. (strlen($row['name'])>0 ? $row['name'] : "{$row['ipaddr']}" ). "	". ($row['ctr']>1 ? $row['ctr'] : '') ."	". ($row['fixtype'] ? "" : "n") ."	". htmlspecialchars(substr($reslink,1,36)) . (strlen($reslink)>37 ? '…' : '') ."	'. (strlen($row['referer'])<8 ? $row['referer'] : ''. (strlen($row['referer'])<40 ? htmlspecialchars(substr($row['referer'],7)) : htmlspecialchars(substr($row['referer'],7,30)).'…') .'') ."	'. htmlspecialchars(brwsr_trim($row['browser'])) ."

"; ?>  
Remove trivial log entries