#native_company# #native_desc#
#native_cta#

WHOS ONLINE?

By Ridwan Karsadarma
on July 9, 2003

Version: 1

Type: Full Script

Category: Algorithms

License: GNU General Public License

Description: This script is for tracking online user by IP/Host. its very simple, no cookies or session need.

<!--

Please dump these MySQL query into your PHPadmin:
-------------------------------------------------

CREATE TABLE online (
  id int(11) NOT NULL auto_increment,
  visitor varchar(100) default NULL,
  timevisit int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

-->
    
<! -- DATABASE CONNECTION -->
<?
     $conn=mysql_connect("localhost","myuser","12345") or die ("can't connect to server");
     @mysql_select_db("mydata") or die ("can't select database");
?>

<! -- UPDATING ONLINE USER DATABASE (add these line below on top of your webpage) -->
<?

$uvisitor=$REMOTE_ADDR;
$uvisitor.="|".gethostbyaddr($uvisitor);
$utime=time();
$exptime=$utime-600; // (in seconds)

@mysql_query("delete from online where timevisit<$exptime");
[email protected]_num_rows(@mysql_query("select id from online where visitor='$uvisitor'"));

if ($uexists>0){
   @mysql_query("update online set timevisit='$utime' where visitor='$uvisitor'");
} else {
   @mysql_query("insert into online (visitor,timevisit) values ('$uvisitor','$utime')");
}

?>

<!-- DISPLAYING ONLINE USER DATABASE -->
<?
[email protected]_query("select * from online");
echo "<style><!--n";
echo "body {font-family:verdana;font-size:10pt}n";
echo "td {font-family:verdana;font-size:10pt}n";
echo "--></style>n";
echo "<div align=center><table><tr bgcolor=#CCCCCC><td><b>Visitor IP/Host<td><b>Last visit</tr>";
while ([email protected]_fetch_array($rs)){
   echo "<tr><td>".$ro[visitor]."<td>".date('j M Y - H:i',$ro[timevisit])."</tr>";
}
echo "</table></div>";
[email protected]_num_rows(@mysql_query("select id from online"));
echo "<div align=center><b>There are $jmlonline user online</b></div>";
?>