users online

<?php
/*
sql tabel:
-----------------
CREATE TABLE `users_online` (
  `id` bigint(18) unsigned NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL default '',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
)AUTO_INCREMENT=1 ;
*/
$minutes = 5;//aantal minuten dat gebruikers online blijven staan
function encode_ip($dotquad_ip)
{
	$ip_sep = explode('.', $dotquad_ip);
	return sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
}

function decode_ip($int_ip)
{
	$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
	return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
}
$ip = (isset($_SERVER)) ? $_SERVER['REMOTE_ADDR'] : $REMOTE_ADDR;
$ip = encode_ip($ip);
mysql_query("INSERT INTO users_online (ip,date) VALUES ('".$ip."','NOW()');") or die(mysql_error());
mysql_query("DELETE FROM users_online WHERE date < '".$minutes*60."';"); or die(mysql_error());

function aantal_online()
{
  return mysql_result(mysql_query("SELECT DISTINCT count(0) FROM users_online"),0);
}
?>

<?php
/*
sql tabel:
-----------------
CREATE TABLE `users_online` (
  `id` bigint(18) unsigned NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL default '',
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
)AUTO_INCREMENT=1 ;
*/
$minutes = 5;//aantal minuten dat gebruikers online blijven staan
function encode_ip($dotquad_ip)
{
	$ip_sep = explode('.', $dotquad_ip);
	return sprintf('%02x%02x%02x%02x', $ip_sep[0], $ip_sep[1], $ip_sep[2], $ip_sep[3]);
}
 
function decode_ip($int_ip)
{
	$hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
	return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
}
$ip = (isset($_SERVER)) ? $_SERVER['REMOTE_ADDR'] : $REMOTE_ADDR;
$ip = encode_ip($ip);
mysql_query("INSERT INTO users_online (ip,date) VALUES ('".$ip."','NOW()');") or die(mysql_error());
mysql_query("DELETE FROM users_online WHERE date < '".$minutes*60."';"); or die(mysql_error());
 
function aantal_online()
{
  return mysql_result(mysql_query("SELECT DISTINCT count(0) FROM users_online"),0);
}
?>

<?
require_once('online.php'); //teller includen
print("Er zijn ".aantal_online()." mensen op de site");
?>

<?
require_once('online.php'); //teller includen
print("Er zijn ".aantal_online()." mensen op de site");
?>