<?php

function guardaHit( $code )
{
	global $link;
	
	$query= mysql_query("SELECT M.CODE,S.ISUPDATE 
							FROM web_minerals AS M, web_groups AS G, web_sections AS S 
							WHERE 	GROUP_CODE=G.CODE 
								AND SECTION_CODE=S.CODE
								AND M.CODE='$code'", $link);
	if( $query == 0 )
	{
		echo "$PHP_SELF ERR1: La sentencia es incorrecta. Error: " . mysql_error( $link ) ."\n"; 
	}else{
		$min = mysql_fetch_array($query);
	}
	if( $min["ISUPDATE"] == "No" )
	{
		mysql_query("INSERT IGNORE INTO web_minerals_hit VALUES('$code',0,0,0,0,0)", $link);
		mysql_query("UPDATE web_minerals_hit SET HIT_TODAY=HIT_TODAY+1, HIT_TOTAL=HIT_TOTAL+1, HIT_THIS_WEEK=HIT_THIS_WEEK+1 where CODE='$code'");
	}
}

	require_once($_SERVER["DOCUMENT_ROOT"]."/phpinc/config.inc");
	require_once($_SERVER["DOCUMENT_ROOT"]."/phpinc/utils.inc" );
	require_once($_SERVER["DOCUMENT_ROOT"]."/phpinc/fmIndexPage.inc");
	$link = DBConnect();
	if( $_GET[LANG] == "ES" )
	{
		$lang="ES";
	}else{
		$lang="EN";
	}

	$HeadHtml='
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!-- Mineral specimens, Fabre Minerals (c) Fabre Minerals 1996 - 2007 -->
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <meta http-equiv="Content-Language" content="es-ES" />
  <meta name="Keywords" content="minerales, mineral, mina, Fluorita, Cuarzo, Calcita, mineralogia, Fabre, Tsumeb, Tucson, Panasqueira, Espaņa, Marruecos, Portugal" />
	<meta name="description" content="Minerales / Fabre Minerals: Minerales y Mineralogia. Especialistas en minerales de alta calidad de todo el mundo." />
<meta name="RATING" content="General" />
<meta name="AUTHOR" content="Fabre Minerals" />
<meta name="COPYRIGHT" content="Fabre Minerals" /> 
<meta http-equiv="robots" content="index" /> 
<meta http-equiv="revisit-after" content="2 days" />
<!-- Estils -->
<link href="/css/fabreminerals.css" rel="stylesheet" type="text/css" />
<link href="/css/fm_database.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="/js/gradualHighlight.js"></script>
';
	$HeadHtml.="<title>$_GET[NAME] Mineral Specimen - Large Photo - Fabre Minerals</title></head>";
	$BodyHtml1='<body bgcolor="#dedeff"><center><h2>';
	$_GET[NAME]=stripcslashes($_GET[NAME]);
	
	if( $_GET[CODE] > "" )
	{
		guardaHit( $_GET[CODE] );
		$BodyHtml1 = $BodyHtml1 .'<font color="#0000FF" face="Arial, Helvetica, sans-serif">';
		$BodyHtml1 = $BodyHtml1 . "$_GET[CODE]:</font> ";
	}

	$BodyHtml1 = $BodyHtml1 . '<font color="#af0000" face="Arial, Helvetica, sans-serif">'. $_GET[NAME].'</font>';

	$BodyHtml1 = $BodyHtml1 . "</h2><h3>";

	$photo=$_GET[FILE];
	if( file_exists($_SERVER['DOCUMENT_ROOT']."/".$photo) )
	{
		echo $HeadHtml;
//		if( $_GET[BUTTONS]!="NO" ) echo fmShowHeaderMenuStr( "HOME,ABOUT_US,FORUM,FEEDBACK,SEARCH", $lang );
		echo $BodyHtml1;
		if( $photo[0] != '/' ) 
		{
			$photo='/'.$photo;
		}
		$size=getimagesize( $_SERVER['DOCUMENT_ROOT']."/".$_GET[FILE] );
		echo '<img src="'.$photo."\" $size[3]";
 		echo ' align="bottom" border="0" alt="'.$_GET[NAME].'"/>';
		if( $_GET[BUTTONS]!="NO" )
		{
			echo '</h3><h6>Photo: Fabre Minerals</h6><h3>';
		}
	}else{
		// Retornem capįalera error per que els cercadors 
		// estiguin informats de que la pagina ja no existeix
		header("HTTP/1.0 404 Not Found");

		echo $HeadHtml;
//		if( $_GET[BUTTONS]!="NO" ) echo fmShowHeaderMenuStr( "HOME,ABOUT_US,FORUM,FEEDBACK,SEARCH", $lang );
		echo $BodyHtml1;

		// Ara mirem si el referer ens indica que el error prove d'una pagina de
		// fabreminerals, en aquest cas, mostrem missatge i enviem mail....
		$PosFabre=strpos($_SERVER[HTTP_REFERER],"http://www.fabreminerals.com");
		$PosMinInf=strpos($_SERVER[HTTP_REFERER],"http://www.minerales.info");
		// si strpos = false es que no hi es, si es = 0 vol dir que esta
		// al principi de la URL que es on el busquem.	
		if( $_SERVER[HTTP_REFERER] > "" &&
		  ( ( $PosFabre !==  FALSE && $PosFabre  == 0 ) ||
		    ( $PosMinInf !== FALSE && $PosMinInf == 0 ) ) )
		{
			$size=getimagesize( $_SERVER['DOCUMENT_ROOT']."/gen_imag/err_large_photo.jpg" );
			echo '<center><img srv="/gen_imag/err_large_photo.jpg"'.$size[3];
 			echo ' align="bottom" border="0"/></center>';

			$txt="Missatge automatic\n-------------------\nError a LargePhoto.php, no existeix foto gran visualitzada per usuari [$_SERVER[SERVER_ADDR]].\nNom del fitxer:$photo\nOrigen: {$_SERVER[HTTP_REFERER]}\nHora (USA):".date("F j, Y, g:i a")."\n\n\n------------------\nVariables del Servidor:\n";

			foreach($_SERVER as $variable => $value) {
   				$txt = $txt .$variable . " = [$value]\n";
			}
			// enviem e-mail si no es tracta de la pagina de manteniment
			if( strpos($_SERVER[HTTP_REFERER],"ENV=TEST") === FALSE &&
			 	strpos($_SERVER[HTTP_REFERER],"_new.") === FALSE &&
				strpos($_SERVER[HTTP_REFERER],"http://www.fabreminerals.com/gestio") === FALSE )
			{
				SendMail2("joan.fabre@gmail.com","ERROR-FabreMinerals: Foto gran no existeix", $txt, "no-responguis@fabreminerals.com","Missatge Automatic");
				SendMail2("mineral@fabreminerals.com","ERROR-FabreMinerals: Foto gran no existeix", $txt, "no-responguis@fabreminerals.com","Missatge Automatic");
				SendMail2("francesc@fabreminerals.com","ERROR-FabreMinerals: Foto gran no existeix", $txt, "no-responguis@fabreminerals.com","Missatge Automatic");
			}
		}else{		
			echo '<center><font face="Arial, Helvetica, sans-serif">';
			echo '<p><br/><br/><br/><br/>The photo you are looking for is not available on our server. <br/>You can however visit <a href="http://www.fabreminerals.com">our web site</a> to search for other similar specimens.';

			echo '</p><p></p><p>Esta fotograf&iacute;a ya no se encuentra en nuestro servidor.<br/>Puede visitar <a href="http://www.fabreminerals.com">nuestra web</a> para buscar otros ejemplares similares.</p>';
			echo "<br/><br/><br/><br/></font></center>";
		}
	}
?>

<?php
if( $_GET[BUTTONS]!="NO" )
{
	echo fmBottomIconsStr("HOME,ABOUT_US,CLIENT_COMMENTS,FORUM,ORDER_FORM,FEEDBACK,SEARCH", $lang);
}
?> 


