qqun sait il comment on fait ca ? j'en ai aucune idée
j'ai un serveur apache/php
j'ai un serveur apache/php
<?php
/*********************************************************************/
/* DVconnectés - Script qui compte le nombre de connectés */
/* © Suprem ( suprem@free.fr ) - 2001 */
/*********************************************************************/
$db = mysql_connect("***** HOST *****", "***** LOGIN *****", "***** PASS *****") or die("Connexion impossible");
mysql_select_db("***** BASE *****",$db);
$ipAppelant = $REMOTE_ADDR;
$heureAppelant = time();
$query = "SELECT * FROM dvconnectes";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
if ($row[dateFin] < $heureAppelant) {
$query_plus_la = "DELETE FROM dvconnectes WHERE ip='$row[ip]'";
$result_plus_la = mysql_query($query_plus_la);
}
}
$query_appelant = "SELECT * FROM dvconnectes where ip='$ipAppelant'";
$result_appelant = mysql_query($query_appelant);
$nb3 = mysql_num_rows($result_appelant);
if ($nb3 != 0) {}
else {
$dateDebut = time();
$dateFin = time()+300;
$query_inc = "INSERT INTO dvconnectes VALUES('$dateDebut','$dateFin','$ipAppelant')";
$result_inc = mysql_query($query_inc) or die ("");
}
$query_connectes = "SELECT * FROM dvconnectes";
$result_connectes = mysql_query($query_connectes);
$count = mysql_num_rows($result_connectes);
if ($count == 1) $txt = "connecté";
else $txt = "connectés";
echo $count." ".$txt."\n";
mysql_close($db);
?>
CREATE TABLE dvconnectes (
dateDebut int(11) NOT NULL default '0',
dateFin int(11) NOT NULL default '0',
ip varchar(100) NOT NULL default '0',
PRIMARY KEY (dateDebut)
)