MyDynaWeb CVS: htdocs sukria

[mdw c. <myd...@li...>]

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : htdocs

Dir     : mydynaweb/htdocs/tools/events


Modified Files:
	stats.php 


Log Message:
Much more stuff...
not finished yet..




===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/tools/events/stats.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -3 -r1.6 -r1.7
--- stats.php	2001/09/03 12:54:44	1.6
+++ stats.php	2001/09/03 13:31:21	1.7
@@ -159,7 +159,7 @@
 /*
 This function returns a box with number of 
 elements in the site :
-- nr of piece of news recorded
+- nr of news recorded
 - nr of comments recorded
 - nr of pages recorded
 - nr of users
@@ -167,6 +167,43 @@
 */
 {
 	$BOX = '';
+
+	// nr of news
+	$sql = "select count(*)
+	        from news
+		where lang = '".USER_LANG."'";
+	$rqt = new query($DBH);
+	$rqt->query($DBH, $sql);
+	$row = $rqt->get_row();
+	$STATS["NEWS"] = $row[0];
+	
+	// comments recorded
+	$sql = "select count(*)
+		from comments, news
+		where news.num_news = comments._num_news
+		and news.lang = '".USER_LANG."'";
+	$rqt = new query($DBH);
+	$rqt->query($DBH, $sql);
+	$row = $rqt->get_row();
+	$STATS["COMMENTS"] = $row[0];
+	
+	// pages recorded
+	$sql = "select count(*)
+		from page
+		where lang = '".USER_LANG."'";
+	$rqt = new query($DBH);
+	$rqt->query($DBH, $sql);
+	$row = $rqt->get_row();
+	$STATS["PAGES"] = $row[0];
+
+	// pages viewed 
+	$sql = "select count(*)
+		from page
+		where lang = '".USER_LANG."'";
+	$rqt = new query($DBH);
+	$rqt->query($DBH, $sql);
+	$row = $rqt->get_row();
+	$STATS["PAGES"] = $row[0];
 
 	return ($BOX);
 }