[snippet] Popular Pages

$username="YOUR-USER-NAME";
$password="YOUR-PASSWORD";
$database="YOUR-DATABASE";
$numPages = (isset($numPages))? $numPages : 5;
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$sql = "SELECT modx_site_content.pagetitle, count(modx_log_access.document), modx_log_access.document FROM modx_log_access INNER JOIN modx_site_content ON modx_log_access.document=modx_site_content.id GROUP BY modx_log_access.document order by count(modx_log_access.document) desc limit $numPages;";
$result = mysql_query($sql);
echo "<ul>";
while($row = mysql_fetch_array($result)) {
  $apage = $row['document'];
  $atitle = $row['pagetitle'];
  echo "<li><a href=\"index.php?id=$apage\">$atitle</a></li>";
}
echo "</ul>";
mysql_close();

global $modx;


//how many item would you like to display
$numPages = (isset($numPages))? $numPages : 5;


$sql = "SELECT modx_site_content.pagetitle, count(modx_log_access.document) AS totalView, modx_log_access.document "
."FROM modx_log_access INNER JOIN modx_site_content ON modx_log_access.document=modx_site_content.id "
."GROUP BY modx_log_access.document order by totalView desc limit $numPages;";


if ($rs= $modx->db->query($sql)) {
$listPopular = "<ul>";
$listPopularItem = '';
    //fetch the results

	while ($row= $this->db->getRow($rs)) {		
	  $apage = $row['document'];
    $atitle = $row['pagetitle'];
    $listPopularItem .= "<li><a href=\"[~".$apage."~]\">$atitle</a></li>";
	}
$listPopular .= $listPopularItem."</ul>";

}

return $listPopular;