<?php
######################################################################
# phpRS Plug-in modul: Poèítadlo pøístupù 3 v1.1.1
######################################################################
// Copyright (c) 2004 by Miroslav Svrèek ([email]mirek@svrcek.cz[/email])
// This program is free software. - Toto je bezplatny a svobodny software.
// plugin pro phpRS
// Copyright (c) 2001-2003 by Jiri Lukas ([email]jirilukas@supersvet.cz[/email])
// [
http://www.supersvet.cz/phprs/]
// vyuzivane tabulky: rs_stat_arch, rs_stat_data
function Pocitat3() {
global $rspredpona;
// vyberte jednu z nasledujicich moznosti
// visit pocita navstevniky
// pages pocita prohlizene stranky
// pages je tedy vetsi nez visit, nebot jeden navstevnik vetsinou projde vice stranek
$co_pocitat='visit';
//$co_pocitat='pages';
$dnesek=getdate();
$mesice=Array(1=>"Leden","Únor","Bøezen","Duben","Kvìten","Èerven","Èervenec","Srpen","Záøí","Øíjen","Listopad","Prosinec");
// zjisteni poctu pristupu
// celkem vsechny pristupy
$result=phprs_sql_query('SELECT SUM(' . $co_pocitat . ') AS celkem FROM ' . $rspredpona . 'stat_arch;', $GLOBALS["dbspojeni"]);
$celkem_pocet=0;
if ($line=phprs_sql_fetch_array($result)) {
if($line["celkem"]) {
$celkem_pocet=$line["celkem"];
}
}
$result=phprs_sql_query('SELECT SUM(' . $co_pocitat . ') AS celkem FROM ' . $rspredpona . 'stat_data;', $GLOBALS["dbspojeni"]);
if ($line=phprs_sql_fetch_array($result)) {
if($line["celkem"]) {
$celkem_pocet+=$line["celkem"];
}
}
// pristupy za tento mesic
$result=phprs_sql_query('SELECT SUM(' . $co_pocitat . ') AS celkem FROM ' . $rspredpona . 'stat_arch WHERE (YEAR(datum) = ' . $dnesek["year"] . ') AND (MONTH(datum) = ' . $dnesek["mon"] . ');', $GLOBALS["dbspojeni"]);
$mesic_pocet=0;
if ($line=phprs_sql_fetch_array($result)) {
if($line["celkem"]) {
$mesic_pocet=$line["celkem"];
}
}
$result=phprs_sql_query('SELECT SUM(' . $co_pocitat . ') AS celkem FROM ' . $rspredpona . 'stat_data WHERE (YEAR(datum) = ' . $dnesek["year"] . ') AND (MONTH(datum) = ' . $dnesek["mon"] . ');', $GLOBALS["dbspojeni"]);
if ($line=phprs_sql_fetch_array($result)) {
if($line["celkem"]) {
$mesic_pocet+=$line["celkem"];
}
}
// pristupy za tento den
$result=phprs_sql_query('SELECT SUM(' . $co_pocitat . ') AS celkem FROM ' . $rspredpona . 'stat_arch WHERE (datum = "' . $dnesek["year"] . '-' . $dnesek["mon"] . '-' . $dnesek["mday"] . '");', $GLOBALS["dbspojeni"]);
$den_pocet=0;
if ($line=phprs_sql_fetch_array($result)) {
if($line["celkem"]) {
$den_pocet=$line["celkem"];
}
}
$result=phprs_sql_query('SELECT SUM(' . $co_pocitat . ') AS celkem FROM ' . $rspredpona . 'stat_data WHERE (datum = "' . $dnesek["year"] . '-' . $dnesek["mon"] . '-' . $dnesek["mday"] . '");', $GLOBALS["dbspojeni"]);
if ($line=phprs_sql_fetch_array($result)) {
if($line["celkem"]) {
$den_pocet+=$line["celkem"];
}
}
$timeoutseconds = 300;
$timestamp=time();
$timeout=$timestamp-$timeoutseconds;
phprs_sql_query("INSERT INTO ".$GLOBALS["rspredpona"]."online VALUES ('".$timestamp."','".$_SERVER["REMOTE_ADDR"]."','".$_SERVER["PHP_SELF"]."')",$GLOBALS["dbspojeni"]) or die("ERROR : v zapisu do tabulky online");
phprs_sql_query("DELETE FROM ".$GLOBALS["rspredpona"]."online WHERE timestamp<".$timeout,$GLOBALS["dbspojeni"]) or die("ERROR : ve smazani TIMEOUTu v tabulce online");
//$result=mysql_query("SELECT DISTINCT ip FROM ".$GLOBALS["rspredpona"]."online WHERE file='".$_SERVER["PHP_SELF"]."'",$GLOBALS["dbspojeni"]) or die("ERROR: ve vycucnuti udaju z tabulky online");
$result=phprs_sql_query("SELECT DISTINCT ip FROM ".$GLOBALS["rspredpona"]."online",$GLOBALS["dbspojeni"]) or die("ERROR: ve vycucnuti udaju z tabulky online");
$user=phprs_sql_num_rows($result);
//$den_pocet=0;
$my_count='<table width="10%"><tr><td width="8%" class="z">Celkem</td><td width="8%" class="z">' . $celkem_pocet . '</td></tr><tr><td class="z">' . $mesice[$dnesek["mon"]] . '</td><td class="z">' . $mesic_pocet . '</td></tr><tr><td class="z">Dnes</td><td class="z">' . $den_pocet . '</td></tr><tr><td class="z">Online</td><td class="z">' . $user . '</td></tr></table>';
switch ($GLOBALS["vzhledwebu"]->AktBlokTyp()):
case 1: Blok1($GLOBALS["vzhledwebu"]->AktBlokNazev(),$my_count); break;
case 2: Blok2($GLOBALS["vzhledwebu"]->AktBlokNazev(),$my_count); break;
case 3: Blok3($GLOBALS["vzhledwebu"]->AktBlokNazev(),$my_count); break;
default: Blok1($GLOBALS["vzhledwebu"]->AktBlokNazev(),$my_count); break;
endswitch;
}
?>