<?phpphp
include ("admin/xstatistics/config.php");
// Common Variables ///////////////////////
$ip = $_SERVER['REMOTE_ADDR'];           //
										 //
if (isset ($_SERVER['HTTP_REFERER'])) {  //
										 //
	$refer = $_SERVER['HTTP_REFERER'];   //
										 //
}										 //
								         //
$browser = $_SERVER['HTTP_USER_AGENT'];  //
										 //
$date = date ("d/m/Y");                  //
$day = date ("d");                       //
$month = date ("m");                     //
$year = date ("Y");                      //
$daysinmonth = date ("t");               //
///////////////////////////////////////////

// Insert Daily Information ///////////////

//Database information it's not properly set
$getdaily = 0; //delete this
//$getdaily = mysql_fetch_array (mysql_query ("SELECT * FROM stats_daily WHERE SUBSTRING(subdate, 1, 2)='$day'"));


$dailyhits = $getdaily['hits'] + 1; // New number of hits after this visit

$checkmonth = mysql_num_rows (mysql_query ("SELECT subdate FROM stats_daily WHERE SUBSTRING(subdate, 4, 2)='$month'"));

if ($checkmonth == 0) {

	mysql_query ("TRUNCATE TABLE stats_daily"); // Delete all records in table if they do not match this month
	
	for ($i = 1; $i < ($daysinmonth + 1); $i++) {
		
		if (strlen ($i) == 1) {
		
			$subdate = "0".$i."/".$month."/".$year;
		
		} else {
		
			$subdate = $i."/".$month."/".$year;
		
		}
		
		mysql_query ("INSERT INTO stats_daily (subdate, hits, uniquehits) VALUES ('$subdate', '0', '0')"); // Insert the number of days this month into the table
		
	}
	
}

$checkday = mysql_num_rows (mysql_query ("SELECT subdate FROM stats_daily WHERE SUBSTRING(subdate, 1, 2)='$day'"));

if ($checkday == 1) { // Update the number of unique visits today
	
	$countip = mysql_num_rows (mysql_query ("SELECT ip FROM stats_visitors WHERE SUBSTRING(subdate, 1, 2)='$day' AND ip='$_SERVER[REMOTE_ADDR]'")); // Obtain the number of unique IP Addresses
	$getuniquehits = mysql_fetch_array (mysql_query ("SELECT uniquehits FROM stats_daily WHERE SUBSTRING(subdate, 1, 2)='$day'"));
	
	if ($countip == 0) {
	
		$uniquehits = $getuniquehits['uniquehits'] + 1;
		
	} else {
	
		$uniquehits = $getuniquehits['uniquehits'];
		
	}
		
	mysql_query ("UPDATE stats_daily SET hits='$dailyhits', uniquehits='$uniquehits' WHERE SUBSTRING(subdate, 1, 2)='$day'"); // Update table when visited

}

// Insert Monthly Information /////////////
$getmonthly = mysql_fetch_array (mysql_query ("SELECT * FROM stats_monthly WHERE SUBSTRING(subdate, 4, 2)='$month'"));
$monthlyhits = $getmonthly['hits'] + 1;

$checkyear = mysql_num_rows (mysql_query ("SELECT subdate FROM stats_monthly WHERE SUBSTRING(subdate, 7, 4)='$year'"));

if ($checkyear == 0) {

	mysql_query ("TRUNCATE TABLE stats_monthly"); // Delete all records in table if they do not match this month
	
	for ($i = 1; $i < 13; $i++) {
		
		if (strlen ($i) == 1) {
		
			$subdate = "01/0".$i."/".$year;
		
		} else {
		
			$subdate = "01/".$i."/".$year;
		
		}
		
		mysql_query ("INSERT INTO stats_monthly (subdate, hits, uniquehits) VALUES ('$subdate', '0', '0')"); // Insert the number of days this month into the table
		
	}

}

$checkmonth = mysql_num_rows (mysql_query ("SELECT * FROM stats_monthly WHERE SUBSTRING(subdate, 4, 2)='$month'"));

if ($checkmonth == 1) { // Update the number of unique visits today
	
	$countip = mysql_num_rows (mysql_query ("SELECT ip FROM stats_visitors WHERE SUBSTRING(subdate, 1, 2)='$day' AND ip='$_SERVER[REMOTE_ADDR]'"));
	$getuniquehits = mysql_fetch_array (mysql_query ("SELECT uniquehits FROM stats_monthly WHERE SUBSTRING(subdate, 4, 2)='$month'"));
	
	if ($countip == 0) {
	
		$uniquehits = $getuniquehits['uniquehits'] + 1;
		
	} else {
	
		$uniquehits = $getuniquehits['uniquehits'];
		
	}
		
	mysql_query ("UPDATE stats_monthly SET hits='$monthlyhits', uniquehits='$uniquehits' WHERE SUBSTRING(subdate, 4, 2)='$month'"); // Update table when visited

}

// Insert Yearly Information //////////////
$getyearly = mysql_fetch_array (mysql_query ("SELECT * FROM stats_yearly WHERE SUBSTRING(subdate, 7, 4)='$year'"));
$yearlyhits = $getyearly['hits'] + 1;

$checkyear = mysql_num_rows (mysql_query ("SELECT * FROM stats_yearly WHERE SUBSTRING(subdate, 7, 4)='$year'"));

if ($checkyear == 0) {

	mysql_query ("INSERT INTO stats_yearly (subdate, hits, uniquehits) VALUES ('$date', '1', '1')");
	
} else {

	$countip = mysql_num_rows (mysql_query ("SELECT ip FROM stats_visitors WHERE SUBSTRING(subdate, 1, 2)='$day' AND ip='$_SERVER[REMOTE_ADDR]'"));
	$getuniquehits = mysql_fetch_array (mysql_query ("SELECT uniquehits FROM stats_yearly WHERE SUBSTRING(subdate, 7, 4)='$year'"));
	
	if ($countip == 0) {
	
		$uniquehits = $getuniquehits['uniquehits'] + 1;
		
	} else {
	
		$uniquehits = $getuniquehits['uniquehits'];
		
	}
		
	mysql_query ("UPDATE stats_yearly SET hits='$yearlyhits', uniquehits='$uniquehits' WHERE SUBSTRING(subdate, 7, 4)='$year'"); // Update table when visited

}

// Insert OS Information //////////////////
if (eregi ("win", $browser)) {
	
	$os = "Windows";
	
}

if (eregi ("mac", $browser)) { // If browser header contains values which contain MAC then the OS must be a MAC
							   // Add OS' as required.
	$os = "Mac";
	
}

if (eregi ("linux", $browser)) { 
	
	$os = "Linux";
	
}

if (eregi ("OS/2", $browser)) { 
	
	$os = "OS/2";
	
}

if (eregi ("BeOS", $browser)) { 
	
	$os = "BeOS";
	
}

if (eregi ("unix", $browser) | eregi ("SunOS", $browser) | eregi ("FreeBSD", $browser) | eregi ("IRIX", $browser) | eregi ("HP-UX", $browser) | eregi ("OSF", $browser) | eregi ("AIX", $browser)) { 
	
	$os = "Unix";
	
}

if (isset ($os)) {

	$oscheck = mysql_num_rows (mysql_query ("SELECT os FROM stats_os WHERE os='$os'"));
	
	if ($oscheck == 0) {
		
		mysql_query ("INSERT INTO stats_os (os, hits) VALUES ('$os', '1')");
		
	} else { // To prevent inaccurate results only IP's which are unique update the OS hits
		
		$checkunique = mysql_num_rows (mysql_query ("SELECT ip FROM stats_visitors WHERE ip='$ip'"));
		
		if ($checkunique == 0) { // If IP is unique then update the records
		
			$hitso = mysql_fetch_array (mysql_query ("SELECT hits FROM stats_os WHERE os='$os'"));
			$oshits = $hitso['hits'] + 1;
			mysql_query ("UPDATE stats_os SET hits='$oshits' WHERE os='$os'");
			
		}
		
	}
	
}

// Insert Browser Information /////////////
if (eregi ("msie", $browser)) { 
	
	$browser = "Internet Explorer";
	
}

if (eregi ("konqueror", $browser)) { 
	
	$browser = "Konqueror";
	
}

if (eregi ("icab", $browser)) { 
	
	$browser = "iCab";
	
}

if (eregi ("Firefox", $browser)) { // If the browser header contains FIREFOX then the browser must be FIREFOX
								   // Add browser's as needed
	$browser = "Firefox";
	
}

if (eregi ("mozilla", $browser)) { 
	
	$browser = "Mozilla";
	
}

if (eregi ("libwww", $browser)) { 
	
	$browser = "Lynx";
	
}

if (eregi ("netscape", $browser)) { 
	
	$browser = "Netscape";
	
}

if (eregi ("safari", $browser)) { 
	
	$browser = "Safari";
	
}

if (eregi ("AOL", $browser)) { 
	
	$browser = "AOL";
	
}

if (isset ($browser)) {

	$browsercheck = mysql_num_rows (mysql_query ("SELECT browser FROM stats_browser WHERE browser='$browser'"));
	
	if ($browsercheck == 0) {
		
		mysql_query ("INSERT INTO stats_browser (browser, hits) VALUES ('$browser', '1')");
		
	} else { // To prevent inaccurate results only IP's which are unique update the browser hits
	
		$checkunique = mysql_num_rows (mysql_query ("SELECT ip FROM stats_visitors WHERE ip='$ip'"));
		
		if ($checkunique == 0) { // If IP is unique then update the records
		
			$hitsb = mysql_fetch_array (mysql_query ("SELECT hits FROM stats_browser WHERE browser='$browser'"));
			$browserhits = $hitsb['hits'] + 1;
			mysql_query ("UPDATE stats_browser SET hits='$browserhits' WHERE browser='$browser'");
			
		}
		
	}
	
}

// Insert Visitor Information /////////////
$visitorcheck = mysql_num_rows (mysql_query ("SELECT subdate FROM stats_visitors WHERE SUBSTRING(subdate, 1, 2)='$day'")); // Check if visitor has visited today

if ($visitorcheck == 0) {

	mysql_query ("TRUNCATE TABLE stats_visitors"); // Empty table if more than a day old
	
}

$checkip = mysql_num_rows (mysql_query ("SELECT ip FROM stats_visitors WHERE ip='$ip'")); // Check if visitor is present in table

if ($checkip == 0) {

	mysql_query ("INSERT INTO stats_visitors (subdate, ip) VALUES ('$date', '$ip')"); // Insert visitor information

}

// Insert Referer Information /////////////
if (isset ($refer)) {

	$referercheck = mysql_num_rows (mysql_query ("SELECT * FROM stats_referer WHERE referer='$refer'"));
	
	if ($referercheck == 0) {
	
		mysql_query ("INSERT INTO stats_referer (referer, hits) VALUES ('$refer', '1')");
		
	} else {
	
		$getrefererhits = mysql_fetch_array (mysql_query ("SELECT * FROM stats_referer WHERE referer='$refer'"));
		
		$refererhits = $getrefererhits['hits'] + 1;
	
		mysql_query ("UPDATE stats_referer SET hits='$refererhits' WHERE referer='$refer'");
		
	}
	
}
?>
<!--<p align="center">Statistical Data Added - View it <a href="analysis/summary.php">here</a> - And remember to delete this message later!</p>-->
<?
/*
//for local host
//define("MYSQL_HOST","localhost");
//define("MYSQL_USERNAME","root");
//define("MYSQL_PASSWORD","");
//define("MYSQL_DB_NAME","iberol");
//$DB_Connect = mysql_connect(MYSQL_HOST, MYSQL_USERNAME, MYSQL_PASSWORD);
//mysql_select_db(MYSQL_DB_NAME,$DB_Connect);*/

//for web server
define("MYSQL_HOST","mysql.host-services.com:3306");
define("MYSQL_USERNAME","acustod_admin");
define("MYSQL_PASSWORD","IBEROL1245");
define("MYSQL_DB_NAME","acustod_iberol");
$DB_Connect = mysql_connect(MYSQL_HOST, MYSQL_USERNAME, MYSQL_PASSWORD);
mysql_select_db(MYSQL_DB_NAME,$DB_Connect);

?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: I B E R O L ::</title>
<meta name="description" content="">
<meta name="keywords" content="">
<link href="includes/stylesheet.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="admin/includes/pop_up.js"></script>
<script>
function popUpBlog(URL) {
day = new Date();
id = day.getTime();
var width=400;
var height=375;
var prop= 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width='+width+',height='+height+',left=20,top=10';
window.open(URL, id , prop);
}
</script>
</head>
<body>
<table width="1003" border="0" align="center" cellpadding="0" cellspacing="0">
  <form name="frm1" action="" method="post"></form>
  <tr>
    <td><table width="1003" border="0" cellspacing="0" cellpadding="0">
      <tr>
      <td class="topbg"><table width="110" border="0" align="right" cellpadding="0" cellspacing="0">
  <tr>
	<td width="61" align="right"><a href="set_language.php?lang=pt" class="moreState">Portugu&ecircs</a></td>
	<td width="13" align="center"><span class="bodyText">|</span></td>
	<td width="36" align="right"><a href="set_language.php?lang=en" class="more">English</a>&nbsp;</td>
  </tr>
</table></td>
      </tr>
      <tr>
        <td><table width="1003" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="327"><img src="images/flash_img8_01.jpg" alt="" width="327" height="331" /></td>
    <td width="202"><img src="images/flash_img8_02.jpg" alt="" width="202" height="331" /></td>
    <td width="212"><img src="images/flash_img8_03.jpg" alt="" width="212" height="331" border="0" usemap="#Map2" /></td>
    <td width="262"><img src="images/flash_img8_04.jpg" alt="" width="262" height="331" border="0" usemap="#Map3" /></td>
  </tr>
</table></td>
      </tr>
      <tr>
        <td><table width="1003" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td valign="top" class="bggalleryleft2"><table width="329" border="0" cellpadding="0" cellspacing="0" class="bggalleryleft">
              <tr>
                <td valign="top"><script language="JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<table border="0" cellpadding="0" cellspacing="0" width="276">
<!-- fwtable fwsrc="left_menu1.png" fwbase="left_menu_inner.jpg" fwstyle="Dreamweaver" fwdocid = "1812347580" fwnested="0" -->
  <tr>
   <td><img src="images/spacer.gif" width="276" height="1" border="0" alt=""></td>
   <td><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td>
  </tr>

  <tr>
   <td><a href="index_home.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r1_c1','','images/pt/left_menu_inner_r1_c1_f2.jpg',1)"><img name="left_menu_inner_r1_c1" src="images/pt/left_menu_inner_r1_c1.jpg" width="276" height="33" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="33" border="0" alt=""></td>
  </tr>
  <tr>
   <td><a href="origem.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r2_c1','','images/pt/left_menu_inner_r2_c1_f2.jpg',1)"><img name="left_menu_inner_r2_c1" src="images/pt/left_menu_inner_r2_c1.jpg" width="276" height="36" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="36" border="0" alt=""></td>
  </tr>
  <tr>
   <td><a href="organizacao.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r3_c1','','images/pt/left_menu_inner_r3_c1_f2.jpg',1)"><img name="left_menu_inner_r3_c1" src="images/pt/left_menu_inner_r3_c1.jpg" width="276" height="34" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="34" border="0" alt=""></td>
  </tr>
  <tr>
   <td><a href="qualidade.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r4_c1','','images/pt/left_menu_inner_r4_c1_f2.jpg',1)"><img name="left_menu_inner_r4_c1" src="images/pt/left_menu_inner_r4_c1.jpg" width="276" height="35" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="35" border="0" alt=""></td>
  </tr>
  <tr>
   <td><a href="imagens.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r5_c1','','images/pt/left_menu_inner_r5_c1_f2.jpg',1)"><img name="left_menu_inner_r5_c1" src="images/pt/left_menu_inner_r5_c1.jpg" width="276" height="36" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="36" border="0" alt=""></td>
  </tr>
  <tr>
   <td><a href="links.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r6_c1','','images/pt/left_menu_inner_r6_c1_f2.jpg',1)"><img name="left_menu_inner_r6_c1" src="images/pt/left_menu_inner_r6_c1.jpg" width="276" height="35" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="35" border="0" alt=""></td>
  </tr>
  <tr>
   <td><a href="blog.php" onMouseOut="MM_swapImgRestore();" onMouseOver="MM_swapImage('left_menu_inner_r7_c1','','images/pt/left_menu_inner_r7_c1_f2.jpg',1)"><img name="left_menu_inner_r7_c1" src="images/pt/left_menu_inner_r7_c1_f2.jpg" width="276" height="36" border="0" alt=""></a></td>
   <td><img src="images/spacer.gif" width="1" height="36" border="0" alt=""></td>
  </tr>
</table>
</td>
              </tr>
            </table></td>
            <td valign="top" class="bggallerycenternew"><table width="674" border="0" cellpadding="0" cellspacing="0" class="bggalleryleftnew">
              <tr>
                <td valign="top" ><table width="645" border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="22"><img src="images/white_left_top.gif" width="22" height="20" /></td>
                    <td background="images/white_top.gif">&nbsp;</td>
                    <td width="20"><img src="images/white_right_top.gif" width="20" height="20" /></td>
                  </tr>
                  <tr>
                    <td background="images/white_left.gif">&nbsp;</td>
                    <td valign="top"><table width="600" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="414" height="25" class="aboutpadding"><span class="titleText">Blog</span></td>
                        <td width="186" align="right" valign="top">&nbsp;</td>
                      </tr>
                      <tr>
                        <td colspan="2" class="aboutpadding"><table width="100%" border="0">
                   <form name="form1" method="post" action="blog.php"><tr>
				    <td colspan="2" class="bodyText">Pesquisa 
				        &nbsp;&nbsp;&nbsp;<input name="txtsearch" type="text" class="textBox" id="txtsearch" value="">
                        <input type="hidden" name="hiddenField">
                        &nbsp;&nbsp;
<input type="submit" name="btnsubmit" value="Go" class="but"></td>
				    </tr>
				  </form>
				  <tr>
				    <td>&nbsp;</td>
				    <td>&nbsp;</td>
				    </tr>
				  				  <tr height="30">
				    <td>&nbsp;</td>
				    <td>&nbsp;</td>
				    </tr>
				                </table></td>
                        </tr>
                      
                    </table></td>
                    <td background="images/white_right.gif">&nbsp;</td>
                  </tr>
                  <tr>
                    <td><img src="images/white_left_bottom.gif" width="22" height="20" /></td>
                    <td background="images/white_bottom.gif">&nbsp;</td>
                    <td><img src="images/white_right_bottom.gif" width="20" height="20" /></td>
                  </tr>
                </table>
                  </td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td valign="top" class="bg_bottom">&nbsp;</td>
            <td class="bg_bottom1" valign="bottom"><table width="655" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td width="460" align="right"><span class="bodyTextBlack">Copyright &copy; IBEROL- 2007</span></td>
                <td width="190" align="right"><span class="bodyTextBlack">&nbsp;Powered by <a href="http://www.shloklabs.com" target="_blank" class="more">SHLOK</a></span></td>
              </tr>
              <tr>
                <td align="right">&nbsp;</td>
                <td align="right">&nbsp;</td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<map name="Map" id="Map">
<area shape="rect" coords="585,298,635,321" href="iberol.php" />
<area shape="rect" coords="666,294,718,316" href="noticias.php" />
<area shape="rect" coords="751,288,812,312" href="mercoda.php" />
<area shape="rect" coords="838,279,909,304" href="contactos.php" />
</map>

<map name="Map2"><area shape="rect" coords="58,302,109,317" href="iberol.php">
<area shape="rect" coords="139,299,189,313" href="noticias.php">
</map>
<map name="Map3"><area shape="rect" coords="14,292,68,307" href="mercoda.php">
<area shape="rect" coords="105,284,163,299" href="contactos.php">
</map></body>
</html>