Счетчик посещений

<?php
if(!isset($_SESSION['usertype'])) { $_SESSION['usertype'] = ''; }
if($modx->documentObject['donthit'] != 1 && $_SESSION['usertype'] != 'manager') {
$id = $modx->documentIdentifier;
$query = "UPDATE modx_site_tmplvar_contentvalues SET value=value+1 WHERE tmplvarid =27 AND contentid=".$id;
mysql_query($query);
}
return;
?>

if(!isset( $_SESSION['usertype'] )) { $_SESSION['usertype'] = ''; }
if( ( $modx->documentObject['donthit'] != 1 ) && ( $_SESSION['usertype'] != 'manager' ) ) {

	$id = $modx->documentIdentifier;
	$query = "SELECT id FROM modx_site_tmplvar_contentvalues WHERE tmplvarid =27 AND contentid=".$id;
	$result = $modx->db->query( $query );
	$total_rows = $modx->db->getRecordCount( $result );
	if($total_rows!=0) {
		$row = $modx->db->getRow( $result );
		$value = $row['value']+1;
		
		$query = "UPDATE modx_site_tmplvar_contentvalues SET $value WHERE tmplvarid =27 AND contentid=$id";
		$modx->db->query( $query );
		} else {
		
		$fields = array('tmplvarid'	=> 27,
			'contentid'	=> $id,
			'value'	=>1,
			);
	
		$modx->db->insert( $fields, "modx_site_tmplvar_contentvalues");
		
		}
	
}
return 1;