Lefounard

CREATE TABLE `site_nb_online` (

  `id_connexion` int(8) NOT NULL auto_increment,

  `time` bigint(16) NOT NULL default '0',

  `id_membre` int(8) NOT NULL default '0',

  PRIMARY KEY  (`id_connexion`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=77094034 ;

<?php

$tps_max_connex = 180;

$temps_actuel = date("U");



if(!isset($_SESSION['id_connexion'])) {

	$_SESSION['id_connexion'] = rand(1,99999999);

	$sql = 'INSERT INTO site_nb_online VALUES("'.$_SESSION['id_connexion']. '", "'.$temps_actuel.'",';

	  if(!isset($_SESSION['pseudo'])) $sql.='"0")';

	 else  $sql.='"'.$_SESSION['id'].'")';

	$req = mysql_query($sql) or die ('Erreur SQL !'.$sql.''.mysql_error());

	}

else {

	 $sql = 'UPDATE site_nb_online SET time = "'.$temps_actuel.'" WHERE id_connexion= "'.$_SESSION['id_connexion'].'"';

        $req = mysql_query($sql) or die ('Erreur SQL !'.$sql.''.mysql_error());

	}



$heure_max = $temps_actuel - $tps_max_connex;



$sql2 = 'DELETE FROM site_nb_online where time < "'.$heure_max.'"';

$req2 = mysql_query($sql2) or die ('Erreur SQL !'.$sql2.''.mysql_error());



?>

<?php

session_start();

//votre connexion mysql



$sql = 'SELECT count(*) FROM site_nb_online';

$req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());



$data = mysql_fetch_array($req);

mysql_free_result($req);



echo 'Il y a actuellement ' , $data[0] , ' internaute(s) surfant sur ce site.';



$sql = 'SELECT id_membre FROM site_nb_online WHERE id_membre!="0"';



$req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error());

$i=0;





echo 'Membres connecté(s) :';

 while ($data2 = mysql_fetch_array($req))

  {

	echo whoishe($data2['id_membre']).' , ';

	$i++;

  }

echo '('.$i.' membre(s)).';



mysql_free_result($req);?>