Thread: MyDynaWeb CVS: htdocs sukria (Page 6)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

MyDynaWeb CVS committal

Author  : sukria
Project : mydynaweb
Module  : htdocs

Dir     : mydynaweb/htdocs


Modified Files:
	count.php 


Log Message:
OK,

now count.php does just one thing : it saves the HTTP_REFERES.
look inside your DATABASE at the two tables called :
- REFERES 
- REF_DAY





===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/count.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -3 -r1.1 -r1.2

--- count.php	2001/11/23 10:48:12	1.1
+++ count.php	2001/11/23 11:49:47	1.2
@@ -1,87 +1,87 @@
 <?PHP
 
+
 include('./include/mydynaweb.init.php');
 include(DYNA_ROOT . '/include/mydynaweb.libs.php');
 
 $DBH=new db();
 $DBH->open($dbName, $dbServer, $dbUser, $dbPass);
-
-
-$rqt = new query($DBH);
-$rqt->query($DBH, $sql);
-
-
-
-$sql = "";
-$rqt = new query($DBH);
-$rqt->query($DBH, $sql);
 
-header ("Status: 302\nLocation: images/mydynawebpowered.gif\n\n");
+referer_exists($HTTP_REFERER, $DBH);
 
 $DBH->close();
 
+header ("Location: images/poweredbymydynaweb.gif");
 
+die();
 
 function get_stats_vals($HTTP_REFERER, $REMOTE_ADDR) {
 
-	$today = date ("Y-m-d");
-	$DYNAVISIT = DVISIT;
-	$sql = "select PAGEVIEWS, VISITS, PEOPLE 
-		from STATS
-		where DAY=$today";
-	$rqt = new query($DBH);
-	$rqt->query($DBH, $sql);
-	$old_stats = $rqt->getrow();
-
-	// if the ip is unknown, +1 in all
-	if (!referer_exists($HTTP_REFERER), $DBH) {
-	  
-	    setcookie('DYNAVISIT', '1', (time() + 30 * 60));
-	    $sql = "INSERT INTO hit_$mon 
-		        (day, ip, nb_hit, nb_visit, referer) 
-			VALUES ($day, '$IP', 1, 1, '$REFER')";
-	    $rqt = new query($DBH);
-	    $rqt->query($DBH, $sql) or print $rqt->error();
-	    return(1);
-	
-	}
-	//elsif there is no visit cookie, +1 in visit & hit
-	else {
-		if (! isset($DYNAVISIT)) {
-			setcookie('DYNAVISIT', '1', (time() + 30 * 60));
-			$new_nb_hit = NB_HIT+1;
-			$new_nb_visit = NB_VIS+1;
-			$sql = "UPDATE hit_$mon set nb_hit=$new_nb_hit, nb_visit=$new_nb_visit, referer='$REFER' 
-			        WHERE ip='$IP' and day=$day";
-			$rqt = new query($DBH);
-			$rqt->query($DBH, $sql) or print $rqt->error();
-			return(1);
-		}
-		else {
-		// else +1 in hit
-			$new_nb_hit = NB_HIT+1;
-			$sql = "UPDATE hit_$mon set nb_hit=$new_nb_hit, referer='$REFER'
-			        WHERE ip='$IP' and day=$day";
-			$rqt = new query($DBH);
-			$rqt->query($DBH, $sql) or print $rqt->error();
-			return(1);
+	return 1;
 
-		}
-
 }
 
 
 function referer_exists($REF, $DBH) {
-/* Check if the referer is known 
+/* Boolean
+   -> Check if the referer is known 
    If not, we add it in the referer DB
 */
+	$today = date("Y-m-d");
 
-	$sql = "select REF_ID, NB
+	$sql = "select REFERERS.REF_ID, NB
 		from REF_DAY, REFERERS
 		where REF_DAY.DAY = '$today'
 		and REF_DAY.REF_ID = REFERERS.REF_ID
 		and REFERERS.REF_URL = '$REF'";
-	
+	$rqt = new query($DBH);
+	$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
+	$row = $rqt->getrow();
+
+
+	if (!$row[1]) // there is no entry for that referer today, send FALSE
+	{
+		// referer exists in the referer DB ?	
+		$sql = "select REF_ID
+			from REFERERS
+			where REF_URL='$REF'";
+		$rqt = new query($DBH);
+		$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
+		$refrow = $rqt->getrow();
+		$REFID = 0;
+		
+		if ($refrow[0]) { // yes, it is known
+			$REFID = $refrow[0];
+		}
+		else // no, first time we see that referer !
+		{
+			$sql = "insert into REFERERS
+				(REF_URL) values ('$REF')";
+			$rqt = new query($DBH);
+			$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
+			$REFID = $DBH->lastid();
+		}
+		
+		// we have the referer ID, we can add that ref in the ref table for today
+		$sql = "insert into REF_DAY
+			(REF_ID, DAY, NB)
+			values ($REFID, '$today', 1)";
+		$rqt = new query($DBH);
+		$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
+
+		return (0);
+	}
+	else // referer exists, increment NB and send TRUE
+	{
+		$nb = $row[1] + 1;
+		$sql = "update REF_DAY 
+			set NB=$nb
+			where REF_ID=".$row[0];
+		$rqt = new query($DBH);
+		$rqt->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
+		
+		return(1);
+	}
 
 }
 






Thread: MyDynaWeb CVS: htdocs sukria (Page 6)

mydynaweb-cvs-commits