[Initng-svn] r3236 - www/users

[svn at initng.thinktux.net]

Author: jimmy
Date: Wed Mar  8 01:48:40 2006
New Revision: 3236

Modified:
   www/users/count.php
Log:
fix




Modified: www/users/count.php
==============================================================================
--- www/users/count.php	(original)
+++ www/users/count.php	Wed Mar  8 01:48:40 2006
@@ -1,9 +1,8 @@
 <?php
 $uname = strip_tags(trim($HTTP_GET_VARS[uname]));
 $distro = strip_tags(trim($HTTP_GET_VARS[distro]));
-$initng_version = strip_tags(trim($HTTP_GET_VARS[initng_version]));
 $md5mac = strip_tags(trim($HTTP_GET_VARS[md5mac]));
-
+$initng_version = strip_tags(trim($HTTP_GET_VARS[initng_version]));
 $host = getenv("REMOTE_ADDR");
 //echo "Uname: $uname\n";
 //echo "Distro: $distro\n";
@@ -22,13 +21,17 @@
 
 mysql_select_db('initng_users') or die('Could not select database');
 //echo "<! Selected the db successfully !>\n";
-$cr = mysql_query("SELECT COUNT(*) AS numrows from initng_count where md5mac='$md5mac'");
+if(strlen($md5mac)>3)
+    $cr = mysql_query("SELECT COUNT(*) AS numrows from initng_count where host='$host' OR md5mac='$md5mac'");
+else
+    $cr = mysql_query("SELECT COUNT(*) AS numrows from initng_count where host='$host'");
+
 $cro = mysql_fetch_array($cr, MYSQL_ASSOC);
 $cron = $cro['numrows'];
 if($cron>0)
 {
-    mysql_query("UPDATE initng_count SET uname='$uname', distro='$distro', initng_version='$initng_version', last_seen=now()
-	WHERE md5mac='$md5mac'");
+    mysql_query("UPDATE initng_count SET uname='$uname', distro='$distro', initng_version='$initng_version', last_seen=now(), host='$host' md5mac='$md5mac'
+	WHERE host='$host' OR md5mac='$md5mac'");
 } else {
     mysql_query("INSERT INTO `initng_count` ( `host` , `uname` , `distro`, `initng_version`, `fist_added`, `last_seen`, `md5mac`  )
  	VALUES ( '$host', '$uname', '$distro', '$initng_version', now(), now(), '$md5mac' )");