[Webnotes-cvs] webnotes/core page_api.php,1.19,1.20 pwn_api.php,1.7,1.8

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

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

Modified Files:
	page_api.php pwn_api.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: page_api.php
===================================================================
RCS file: /cvsroot/webnotes/webnotes/core/page_api.php,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -d -r1.19 -r1.20
--- page_api.php	1 Oct 2002 06:51:45 -0000	1.19
+++ page_api.php	20 Aug 2003 08:46:35 -0000	1.20
@@ -360,4 +360,30 @@
 		return( $t_page_data );
 	}
 	### --------------------
+	function page_visit( $p_page_id ) {
+		$c_page_id = db_prepare_int( $p_page_id );
+		$query ='UPDATE ' . config_get( 'phpWN_page_table') . ' ' .
+				"SET visits=visits+1 " .
+				"WHERE id=$c_page_id " .
+				"LIMIT 1";
+		return ( false !== db_query( $query ) );
+	}
+	### --------------------
+	function page_visits_count( $p_page_id ) {
+		$c_page_id = db_prepare_int( $p_page_id );
+
+		$query = "SELECT visits
+				FROM " . config_get( 'phpWN_page_table' ) . "
+				WHERE id=$c_page_id
+				LIMIT 1";
+
+		$result = db_query( $query );
+		if ( db_num_rows( $result) > 0 ) {
+			return db_result( $result, 0, 0 );
+		}
+
+		return false;
+	}
+	### --------------------
+
 ?>

Index: pwn_api.php
===================================================================
RCS file: /cvsroot/webnotes/webnotes/core/pwn_api.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -u -d -r1.7 -r1.8
--- pwn_api.php	1 Oct 2002 12:51:42 -0000	1.7
+++ pwn_api.php	20 Aug 2003 08:46:35 -0000	1.8
@@ -31,6 +31,7 @@
 			page_update_neighbours( $t_page_id, $p_prev_page, $p_next_page, $p_parent_page );
 			$page_data = page_prepare_theme_data( $t_page_id );
 			theme_body ( $page_data );
+			page_visit( $t_page_id );
 		}
 	}
 	### --------------------