#INFO
tMI will created a db upgrade script. You have to run this script using your old db.php, then replace db.php with the modified version.
#SQL
CREATE TABLE '.PREFIX.'visits (
  VisitsID int(10) unsigned NOT NULL auto_increment,
  File tinytext NOT NULL,
  Action tinytext NOT NULL,
  Visits bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (VisitsID)
) TYPE=MyISAM;
#OPEN
db.php
#ADD

$csql = new DB_SQL;
$cquery = 'UPDATE '.PREFIX.'visits SET Visits=Visits+1 WHERE File=\''.$_SERVER['PATH_TRANSLATED'].'\' AND Action=\''.$action.'\'';
$csql->query($cquery);
if ($csql->affected_rows() == 0)
{	$cquery = 'INSERT INTO '.PREFIX.'visits (File,Action,Visits) VALUES(\''.$_SERVER['PATH_TRANSLATED'].'\',\''.$action.'\',1)';
	$csql->query($cquery);
}
unset($csql,$cquery);
#CREATE
pstats.php
<?PHP
include('db.php');
$sql = new DB_SQL;
echo '<TABLE Border=1>
	<TR>
		<TD><b>Page:</b></TD>
		<TD><b>Action:</b></TD>
		<TD><b>Visits:</b></TD>
	</TR>';
$query='SELECT FILE,ACTION,Visits FROM '.PREFIX.'visits ORDER BY Visits DESC';
$sql->query($query);
while(list($file,$action,$visits)=$sql->get_numeric())
{	echo '<TR>
			<TD>'.basename($file).'</TD>
			<TD>'.$action.'&nbsp;</TD>
			<TD>'.$visits.'</TD>
		</TR>';
}
echo '</TABLE>';
?>
#END