[Webnotes-cvs] webnotes admin_manage_notes.php,1.20,1.21

[<vb...@us...>]

Update of /cvsroot/webnotes/webnotes
In directory sc8-pr-cvs1:/tmp/cvs-serv22181

Modified Files:
	admin_manage_notes.php 
Log Message:
- Added the "visits" field to the pages table.
- Added support for tracking the page visits.
- Display the page visits in the manage notes page.

Index: admin_manage_notes.php
===================================================================
RCS file: /cvsroot/webnotes/webnotes/admin_manage_notes.php,v
retrieving revision 1.20
retrieving revision 1.21
diff -u -d -r1.20 -r1.21
--- admin_manage_notes.php	19 Aug 2003 23:19:58 -0000	1.20
+++ admin_manage_notes.php	20 Aug 2003 08:46:35 -0000	1.21
@@ -55,22 +55,19 @@
 	<p><strong>Following are all the pages that use phpWebNotes:</strong></p>
 	<p>Time now is $t_now</p>
 	<table class="box" summary="">
-		<tr><th>Page</th><th># of Notes</th><th>Last Updated</td><th>URL</th></tr>\n
+		<tr><th>Page</th><th># of Notes</th><th># of hits</th><th>Last Updated</td><th>URL</th></tr>\n
 EOT;
 
 	$count = 0;
 	$pages = page_get_array ( page_where_url_exists(), 'last_updated DESC' );
 	foreach( $pages as $page ) {
 		extract( $page, EXTR_PREFIX_ALL, 'v' );
-                $v_id = (integer)$v_id;
-                $query = "SELECT COUNT(*) FROM " . config_get( 'phpWN_note_table' ) . ' ' .
-                        "WHERE (page_id = $v_id )";
-		$result = db_query( $query );
-		$t_number = db_result( $result );
+		$t_number = page_notes_count( $v_id );
+		$t_visits = page_visits_count( $v_id );
                 $t_last_updated = date( config_get( 'date_format' ), $v_last_updated );
 
 		$color =  util_alternate_colors( $count++ );
-		echo "<tr bgcolor=\"$color\"><td><a href=\"$v_url\">$v_page</a></td><td>$t_number</td><td>$t_last_updated</td><td>$v_url</td></tr>\n";
+		echo "<tr bgcolor=\"$color\"><td><a href=\"$v_url\">$v_page</a></td><td>$t_number</td><td>$t_visits</td><td>$t_last_updated</td><td>$v_url</td></tr>\n";
 	}
 
 	echo <<<EOT