<?
function connecte() {
    global $base, $host, $login, $pass;
    
    $conn = mysql_connect($host, $login, $pass);
    mysql_select_db($base);
    return $conn;
}

// --------------------------------

function deconnecte($conn) {
    mysql_close($conn);
}

// --------------------------------

function updateCompteurs($cle) {
    $result = mysql_query("select * from compteurs where cle = '$cle'");
    $row = mysql_fetch_object($result);
    if ($row) {
        $cpt = $row->nbHit + 1;
        mysql_query("update compteurs set nbHit = $cpt where cle = '$cle'");
    }
    mysql_free_result($result); 
}

// --------------------------------

function getCompteurs($cle) {
    $result = mysql_query("select * from compteurs where cle = '$cle'");
    $row = mysql_fetch_object($result);
    if ($row) 
        $cpt = $row->nbHit;
    else 
        $cpt = 0;
    mysql_free_result($result); 
    
    return $cpt;
}

// --------------------------------

function getNom($cle) {
    $result = mysql_query("select * from compteurs where cle = '$cle'");
    $row = mysql_fetch_object($result);
    if ($row) 
        $res = $row->nomComplet;
    else 
        $res = "";
    mysql_free_result($result); 
    
    return $res;
}

// --------------------------------

function getTotalHitsCompteurs() {
    $result = mysql_query("select sum(nbHit) as total from compteurs");
    $row = mysql_fetch_object($result);
    if ($row)
        $total = $row->total;
    else
        $total = 0;
    mysql_free_result($result); 
    
    return $total;
}

// --------------------------------

function getNbVisiteurs() {
    $result = mysql_query("select count(*) as res from visiteurs");
    $row = mysql_fetch_object($result);
    if ($row) {
        $res = $row->res;
        if ($res == 0) $res = 1;
    } else {
        $res = 1;
    }
    mysql_free_result($result);
	
    return $res;
}
// ------------------------------------

function updateNbVisiteurs() {
    $ip = getenv("REMOTE_HOST");
    if (!$ip) {
        $ip = getenv("REMOTE_ADDR");
    }
    mysql_query("delete from visiteurs where limite < now()");
    $result = mysql_query("select * from visiteurs where ip = '$ip'");
    $row = mysql_fetch_object($result);
    if ($row) {
        $query = "update visiteurs set limite = now() + 300 where ip = '$ip'";
        mysql_query($query);
    } else {
        $query = "insert into visiteurs (ip, limite) values ('$ip', now() + 300)";
        mysql_query($query);
    }
    mysql_free_result($result); 
}  
?>