<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<meta name="KEYWORDS" VALUE=" espor, praca, kuchar, casnik">
<html>
<head>
<title>espor-personnel consulting</title>
<style>
BODY {background:#F8EE7C url(gifka/pozadie2.jpg) no-repeat;
      font-family: Tahoma}
span {width=100%}
A:link {color="#CFCFCF"; TEXT-DECORATION: none}
A:visited {color="#9CABA3"; TEXT-DECORATION: none}
A:active {color="#CFCFCF"; TEXT-DECORATION: none}
A:hover {COLOR: #FF9900; TEXT-DECORATION: none}
</style>
</head>
<body  language="JavaScript">
<? 
	$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'");
	 }
	}
?>
<table border=0 width="950" height="545">
	<tr><td align="center" valign="top">
		<table border="0" width="500" cellspacing="5">
			<tr><td colspan="2" align="center" height="130">
				<font color="maroon" size="5">Vítame Vás na stránke personálnej agentúry</font>
			</td></tr>
			<tr><td colspan="2" height="180">&nbsp;
				
			</td></tr>
			<tr><td colspan="2" align="center" height="145"><font color="maroon" size=2>Ing. Silvia Kánová - ESPOR</font><br>
				<font color="maroon" size=2>Kalinčiakova 1, 974 05 Banská Bystrica</font><br>
				<font color="maroon" size=2>tel./fax: 048-414 6230; mobil: 0905 834 796, 0911 834 796 <br>( 8.30 do 19.00 hod.)</font><br>
				<font color="maroon" size=2>e-mail: </font><A href="mailto:espor@espor.sk"><font color=maroon size=2>espor@espor.sk</font></a><br>
				<font color="maroon" size=2>web: </font><A href="http://www.espor.sk"><font color=maroon size=2>www.espor.sk</font></a>
			</td></tr>
			<tr><td align="center" bgcolor="maroon"><a href="slov/oagenture.php"><font color="#FFFF99" size=2><b>ZÁUJEMCOVIA O PRÁCU</b></font><br>
					<font color="#FFFF99" size=2><b>BEWERBER</b></font></a>
				</td>
				<td align="center" bgcolor="maroon"><a href="datenbank/index.php"><font color="#FFFF99" size=2><b>ZAMESTNÁVATELIA</b></font><br>
					<font color="#FFFF99" size=2><b>ARBEITSGEBER</b></font></a>
				</td>
			</tr>
		</table>
	</td></tr>	
</table>
</body>
</html>