$ip = $REMOTE_ADDR; $akttime = Time(); $aktdate = Date("D. d. M. Y - H:i:s"); $first_time = Date("H:i"); $mes= substr($aktdate,9,3); $rok= substr($aktdate,14,4); $rok_mes= $rok.$mes; /* tu si nadefinujeme premenne pre pristup k MySQL */ include("privat/databaza.php"); if( ($link = @mysql_connect($server, $login, $pass))) { $podstr="uvodna"; mysql_select_db($database); //pocitanie pristupov podla podstranok $vysledek = mysql_query("select pocet_podstr from poc_podstr_esp where podstr='$podstr'"); $zaznam = MySQL_Fetch_Row($vysledek); $pocet_podstr = $zaznam[0]; if ($pocet_podstr){$pocet_podstr++; mysql_query("update poc_podstr_esp set pocet_podstr='$pocet_podstr' where podstr='$podstr'"); } else { mysql_query("insert into poc_podstr_esp set podstr='$podstr', pocet_podstr='1', id='2'"); } mysql_select_db($database); //pocitanie pristupov celkovo $vysledek = mysql_query("select poc_prist from access"); $zaznam = MySQL_Fetch_Row($vysledek); $pristup = $zaznam[0]; $vysledek1 = mysql_query("select * from addr"); while ( $zaznam1 = MySQL_Fetch_Row($vysledek1)): $ipaddress = $zaznam1[0]; $acctime = $zaznam1[1]; $accdate = $zaznam1[2]; $accid = $zaznam1[3]; $first_date = $zaznam1[4]; if ($akttime - 900 <= $acctime) { if ($ipaddress == $ip) { $count=1; } } else { mysql_query("delete from addr where id='$accid'"); } endwhile; if (!$count) { if (!$pristup) { mysql_query("insert into access set poc_prist='1'"); } else { $pristup++; mysql_query("update access set poc_prist='$pristup' where id='1'"); } mysql_query("insert into addr set ipaddr='$ip', time='$akttime', first_date='$first_time', date='$aktdate'"); $first_date=$first_time; mysql_select_db($database); //pocitanie pristupov podla mesiacov $vysledek = mysql_query("select pocet from poc_mes_esp where rok_mes= '$rok_mes'"); $zaznam = MySQL_Fetch_Row($vysledek); $pocet = $zaznam[0]; if ($pocet) {$pocet++; mysql_query("update poc_mes_esp set pocet='$pocet' where rok_mes= '$rok_mes'"); } else { mysql_query("insert into poc_mes_esp set rok_mes='$rok_mes', time='$akttime', pocet='1'"); } } else { mysql_query("update addr set time='$akttime', date='$aktdate' where ipaddr='$ip'"); } } ?>
Vítame Vás na stránke personálnej agentúry
Ing. Silvia Kánová - ESPOR
Kalinčiakova 1, 974 05 Banská Bystrica
tel./fax: 048-414 6230; mobil: 0905 834 796, 0911 834 796
( 8.30 do 19.00 hod.)
e-mail:
espor@espor.sk
web:
www.espor.sk
ZÁUJEMCOVIA O PRÁCU
BEWERBER
ZAMESTNÁVATELIA
ARBEITSGEBER