toxicengine-cvs

[Jonathan P. <jp...@us...>]

Update of /cvsroot/toxicengine/website/admin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv8330/admin

Modified Files:
	admin_statistics.php 
Log Message:
- use of CVS keywords
- replaced useragent logging with referrer and IP logging


Index: admin_statistics.php
===================================================================
RCS file: /cvsroot/toxicengine/website/admin/admin_statistics.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** admin_statistics.php	21 Oct 2004 22:36:06 -0000	1.3
--- admin_statistics.php	30 Oct 2004 19:16:20 -0000	1.4
***************
*** 39,45 ****
  
  	$page_hit_vector = mysql_query(
! 		'SELECT useragentid, pageid ' .
  		'  FROM pagehits ' .
! 		'  WHERE adminpage=\'0\'');
  
  	$total_page_hits = mysql_num_rows($page_hit_vector);
--- 39,45 ----
  
  	$page_hit_vector = mysql_query(
! 		'SELECT pageid ' .
  		'  FROM pagehits ' .
! 		'  WHERE adminpage=0');
  
  	$total_page_hits = mysql_num_rows($page_hit_vector);
***************
*** 106,109 ****
--- 106,112 ----
  
  	<p></p>
+ where
+ referrer!='' and referrer not like 'http://toxicengine.%'
+ 
  
  	<p class="title">Last 10 Hits</p>
***************
*** 114,122 ****
  		<tr class="tableheader">
  			<td>Page Title</td>
! 			<td>Last Hit</td>
  		</tr>
  <?php
  	$entry_vector = mysql_query(
! 		'SELECT pageid, timestamp ' .
  		'  FROM pagehits ' .
  		'  WHERE adminpage=\'0\' ' .
--- 117,128 ----
  		<tr class="tableheader">
  			<td>Page Title</td>
! 			<td>Date/time</td>
! 			<td>Referrer</td>
! 			<td>IP</td>
! 			<td>Host</td>
  		</tr>
  <?php
  	$entry_vector = mysql_query(
! 		'SELECT pageid, timestamp, referrer, ip, host ' .
  		'  FROM pagehits ' .
  		'  WHERE adminpage=\'0\' ' .
***************
*** 125,132 ****
--- 131,142 ----
  
  	while($row = mysql_fetch_array($entry_vector)) {
+ 		$saferefr = htmlspecialchars($row['referrer']);
  ?>
  		<tr class="tablerow">
  			<td><?php echo get_page_title($row['pageid']); ?></td>
  			<td><?php echo date('r', $row['timestamp']); ?></td>
+ 			<td><a href="<?php echo $saferefr; ?>"><?php echo $saferefr; ?></a></td>
+ 			<td><?php echo $row['ip']; ?></td>
+ 			<td><?php echo $row['host']; ?></td>
  		</tr>
  <?php
***************
*** 137,198 ****
  	<p></p>
  
! 	<p class="title">Browsers Popularity</p>
  
  	<table width="100%" border="0" cellpadding="5">
  		<tr class="tableheader">
! 			<td align="right">Rank</td>
! 			<td align="left">Browser</td>
! 			<td align="right">Hits</td>
! 			<td align="right">Percentage</td>
  		</tr>
  <?php
! 	unset($page_hits);
! 
! 	mysql_data_seek($page_hit_vector, 0);
! 	while($row = mysql_fetch_array($page_hit_vector)) {
! 		$user_agent_id = $row['useragentid'];
! 
! 		if(isset($page_hits[$user_agent_id]))
! 			++$page_hits[$user_agent_id];
! 		else $page_hits[$user_agent_id] = 1;
! 	}
! 
! 	arsort($page_hits);
! 	reset($page_hits);
! 
! 	$full_browser_list = $_GET['fullbrowserlist'];
! 
! 	$rank = 0;
! 
! 	reset($page_hits);
! 	foreach($page_hits as $key => $value) {
! 		++$rank;
  
! 		if(!$full_browser_list) {
! 			if($rank > 10)
! 				break;
! 		}
  ?>
  		<tr class="tablerow">
! 			<td align="right"><?php echo $rank; ?></td>
! 			<td align="left"><?php
! 				$result = mysql_query(
! 					'SELECT identstring ' .
! 					'  FROM useragents ' .
! 					'  WHERE id=\'' . $key . '\'');
! 
! 				assert(mysql_num_rows($result) == 1);
! 				$row = mysql_fetch_array($result);
! 
! 				echo htmlspecialchars(stripslashes($row['identstring']));
! 			?></td>
! 			<td align="right"><?php echo $value; ?></td>
! 			<td align="right"><?php
! 				$percent = round($value / $total_page_hits * 100.0);
! 
! 				if($percent < 1)
! 					echo '&lt; 1 %';
! 				else echo $percent . ' %';
! 			?></td>
  		</tr>
  <?php
--- 147,176 ----
  	<p></p>
  
! 	<p class="title">Top referrals</p>
! 
! 	<p>Most recent hit appears first.</p>
  
  	<table width="100%" border="0" cellpadding="5">
  		<tr class="tableheader">
! 			<td>Referrer</td>
! 			<td>Count</td>
! 			<td>Latest hit</td>
  		</tr>
  <?php
! 	$entry_vector = mysql_query(
! 		'SELECT referrer, max( timestamp ) AS latest, COUNT(*) AS refcnt ' .
! 		'  FROM pagehits ' .
! 		'  WHERE adminpage=\'0\' AND referrer!=\'\' AND referrer NOT LIKE \'http://toxicengine.%\'' .
! 		'  GROUP BY referrer' .
! 		'  ORDER BY refcnt DESC, latest DESC ' .
! 		'  LIMIT 0, 50');
  
! 	while($row = mysql_fetch_array($entry_vector)) {
! 		$saferefr = htmlspecialchars($row['referrer']);
  ?>
  		<tr class="tablerow">
! 			<td><a href="<?php echo $saferefr; ?>"><?php echo $saferefr; ?></a></td>
! 			<td><?php echo $row['refcnt']; ?></td>
! 			<td><?php echo date('r', $row['latest']); ?></td>
  		</tr>
  <?php
***************
*** 201,216 ****
  	</table>
  
! 	<div align="right">
! <?php
! 	if($full_browser_list) {
! ?>
! 		<a href="<?php echo $_SERVER['PHP_SELF']; ?>">View 10 First Entries</a>
! <?php
! 	} else {
! ?>
! 		<a href="<?php echo $_SERVER['PHP_SELF'] . '?fullbrowserlist=1'; ?>">View Full Table</a>
! <?php
! 	}
! ?>
  	</div>
  
--- 179,184 ----
  	</table>
  
! 	<p></p>
! 
  	</div>