počitadlo

<? 
$spojeni=mysql_connect ("mm", "xxx", "heslo") or
die ("Nepodarilo sa vytvoriť počítadlo.");
mysql_select_db ("xxx") or
die ("Databáze pravděpodobně neexistuje.");
$sql="create table celkem_$tmpname(id integer primary key auto_increment,celkem int)";
mysql_query ($sql);
echo mysql_error()."<br />";
$sql="create table den_$tmpname(id integer primary key auto_increment,ip varchar(15),doba int)";
mysql_query ($sql);
echo mysql_error()."<br />";
$sql="create table mesic_$tmpname(id integer primary key auto_increment,ip varchar(15),doba int)";
mysql_query ($sql);
echo mysql_error()."<br />";
$sql="create table online_$tmpname(id integer primary key auto_increment,ip varchar(15),doba int)";
mysql_query ($sql);
echo mysql_error()."<br />";
$sql="insert into celkem (celkem) values ('0');";
mysql_query ($sql);
echo mysql_error();
?>

$spojeni=mysql_connect ("mm", "xxx", "heslo") or
die ("Nepodařilo se připojit k DB.");
mysql_select_db ("xxx") or
die ("Databáze pravděpodobně neexistuje.");
 
//deklarace funkci

        function spocti_lidi ($tabulka){
                $sql="select count(*) from $tabulka";
                @$r=mysql_query ($sql);
                if (@mysql_num_rows($r)){
                        $zaznam=mysql_fetch_row($r);
                        $pocet_lidi=$zaznam[0];
                }
                return $pocet_lidi;
        }
        function zapis_lidi ($tabulka, $cas, $limit, $ip){
                $sql="select ip from $tabulka where doba=($cas-$limit) or doba>$cas";
                @$r=mysql_query ($sql);
                if (mysql_num_rows($r)){
                        $sql="delete from $tabulka";
                        mysql_query ($sql);
                }
                $cas_dny=date ("j");
                $sql="select id from den where ip like '$ip' AND doba=$cas_dny";
                @$r=mysql_query ($sql);
                if (!mysql_num_rows($r)){
 
                                $sql2="insert into $tabulka (ip, doba) values ('$ip', '$cas')";
                                mysql_query ($sql2);
                }
 
        }
//celkem lidi

        $ip=$REMOTE_ADDR;
        $cas_dny=date ("j");
        $sql="select celkem from celkem";
        @$r=mysql_query ($sql);
        if (@mysql_num_rows($r)){
                $zaznam=mysql_fetch_row($r);
                $celkem=$zaznam[0];
        }
$sql="select id from den where ip like '$ip' AND doba=$cas_dny";
                @$r=mysql_query ($sql);
                if (!mysql_num_rows($r)){
                                $celkem++;
                                $sql2="update celkem set celkem=$celkem_$soubor[0] where id=1";
                                mysql_query ($sql2);
                }
//lidi online
        $cas_minuty=date ("i");
        $limit=10; //minut
        $sql="delete from online where doba<($cas_minuty-$limit) OR doba>$cas_minuty";
        mysql_query ($sql);
        $sql="select ip from online where ip like '$ip'";
        @$r=mysql_query ($sql);
        if (@mysql_num_rows($r)){
                $sql1="update online set doba='$cas_minuty' where ip like '$ip'";
                mysql_query ($sql1);
        }else{
                $sql2="insert into online (ip, doba) values ('$ip','$cas_minuty')";
                mysql_query ($sql2);
        }
      

//volani funkci pro zapsani novych navstev do databaze
        $cas_mesic=date ("n");
        $limit=1;//mesic
        zapis_lidi ("mesic", $cas_mesic, $limit, $ip);
        $cas_dny=date ("j");
        $limit=1;//den
        zapis_lidi ("den", $cas_dny, $limit, $ip);
//vypis lidi
        $den=spocti_lidi ("den");
        $online=spocti_lidi ("online");
        $mesic=spocti_lidi ("mesic");
 ?>

//celkem lidi
 $ip=$REMOTE_ADDR;
        $cas_dny=date ("j");
        $sql="select celkem_$tmpname from celkem";
        @$r=mysql_query ($sql);
        if (@mysql_num_rows($r)){
                $zaznam=mysql_fetch_row($r);
                $celkem=$zaznam[0];
        }
$sql="select id from den_$tmpname where ip like '$ip' AND doba=$cas_dny";
                @$r=mysql_query ($sql);
                if (!mysql_num_rows($r)){
                                $celkem++;
                                $sql2="update celkem_$tmpname set celkem=$celkem_$tmpname where id=1";
                                mysql_query ($sql2);
                }