hits script

[anayemil]

am urmatorul script in hits.php:

<?php

require ('config.php')
$con = @mysql_connect ($db_host, $db_user, $db_pass) or die ("eroare");
mysql_select_db($db_name, $con);

$page1 = $_SERVER["PHP_SELF"];
$ip = $_SERVER["REMOTE_ADDR"];
$datee = time();

$query = "INSERT INTO hits (page, ip, datee) VALUES ('$page1', '$ip', '$datee')";
mysql_query($query, $con);

$query = "SELECT * FROM hits GROUP BY ip";
$result = mysql_query($query, $con);
$views = mysql_num_rows($result);
echo $views." vizitatori unici";

?>

Asta imi afiseaza nr de vizitatori unici. Numai ca daca cineva intra de la o sala ii ramane ip`ul iar daca maine intra altcineva de pe acelasi IP nr de vizitatori nu va creste. Stie cineva cum pot face sa se stearga automat dupa un anumit timp dat de mine IP`urile din tabel astfel maine daca se intra de la acelasi ip de la care s`a intrat azi nr de vizitatori sa creasca....??

[necenzurat]

incearca cu [php]
$timeoutseconds = timpul care il vrei;
$timestamp=time();
$timeout=$timestamp-$timeoutseconds;
mysql_db_query($database, "DELETE FROM tabel WHERE timestamp<$timeout") or die("eroare");

[/php]

ma rog il adaptezi si tu

[Pirahna]

necenzurel , iar inveti lumea la prostii ?

[php]<?php

require ('config.php')
$con = @mysql_connect ($db_host, $db_user, $db_pass) or die ("eroare");
mysql_select_db($db_name, $con);

$page1 = $_SERVER["PHP_SELF"];
$ip = $_SERVER["REMOTE_ADDR"];
$datee = time();

$query = "INSERT INTO hits (page, ip, datee) VALUES ('$page1', '$ip', '$datee')";
mysql_query($query, $con);

$data_care_o_vrei_tu = $datee-43200 ; //12 ore
//sau
//$data_care_o_vrei_tu = $datee-86400 ; //24 ore
//nu stiu daca am calculat bine nr de secunde

$query = "SELECT * FROM hits WHERE datee>".$data_care_o_vrei_tu." GROUP BY ip";
$result = mysql_query($query, $con);
$views = mysql_num_rows($result);
echo $views." vizitatori unici";

?> [/php]

[necenzurat]

era o idee

[Pirahna]

era o prostie

[necenzurat]

ok era o proste :-$ ssssshttttt sa nu mai zici la nimeni

[ctmxxl]

[Pirahna]

[necenzurat]

[whooper]