<?

$host		=	"localhost";
$database	=	"u712991328_db_8J9B0jlw"; 
$login_db	=	"u712991328_usr_8J9B0jlw"; 
$senha_db	=	"Netplace@1995";

$db			=	mysql_connect ($host, $login_db, $senha_db);
$basedados	=	mysql_select_db($database);

?><? if( session_id() == '' ) {  session_start();   }

//require_once ("../init/config_db.php"); 

function getIp() {
 
 if ( !empty($_SERVER['REMOTE_ADDR']) ) {
 $ip = $_SERVER['REMOTE_ADDR'];
 }
 elseif( !empty($_SERVER['HTTP_CLIENT_IP']) ) {
 $ip = $_SERVER['HTTP_CLIENT_IP'];
 }
 elseif ( !empty($_SERVER['HTTP_X_FORWARDED_FOR']) ) {
 $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
 }
 elseif ( !empty($_SERVER['HTTP_X_FORWARDED']) ) {
 $ip = $_SERVER['HTTP_X_FORWARDED'];
 }
 elseif ( !empty($_SERVER['HTTP_FORWARDED']) ) {
 $ip = $_SERVER['HTTP_FORWARDED'];
 }
 elseif ( !empty($_SERVER['HTTP_X_COMING_FROM']) ) {
 $ip = $_SERVER['HTTP_X_COMING_FROM'];
 }
 elseif ( !empty($_SERVER['HTTP_COMING_FROM']) ) {
 $ip = $_SERVER['HTTP_COMING_FROM'];
 }
 else
 {
 $ip = NULL;
 }
 return $ip;
 }
	$arralang = explode(',',@$_SERVER['HTTP_ACCEPT_LANGUAGE']);
	$langcountry = explode('-',$arralang[0]);
	$lang = $langcountry[0];
	$country = $langcountry[1];
	if($country == "BR"){$sql = "BR = BR+1";}
	elseif($country == "US"){$sql = "US = US+1";}
	elseif($country == "AR"){$sql = "AR = AR+1";}
	elseif($country == "BO"){$sql = "BO = BO+1";}
	elseif($country == "CL"){$sql = "CL = CL+1";}
	elseif($country == "MX"){$sql = "MX = MX+1";}
	elseif($country == "PY"){$sql = "PY = PY+1";}
	elseif($country == "PT"){$sql = "PT = PT+1";}
	elseif($country == "UY"){$sql = "UY = UY+1";}
	else {$sql = "NA = NA+1";}
 
//$ip = getIp();

$seleciona_visitas = mysql_query("SELECT visitas FROM x_contador") or die(mysql_error());
	while($res_visitas = mysql_fetch_array($seleciona_visitas)){

 	$visitas = $res_visitas['visitas'];
 	$visitas_mais = $visitas +1;

	$hoje = date("Y-m-d");

 	//session_start();
 	$sessao = session_id();
 	$tempo_on = time();
 	$tempo_fim = time() - 400;
 	$ip = getIp(); //$_SERVER['REMOTE_ADDR'];


 		$termina_sessao = mysql_query("DELETE FROM x_online WHERE tempo < '$tempo_fim'") or die(mysql_error());
 		//$otimize = mysql_query("OPTIMIZE TABLE x_online ");

 		$pega_sessao = mysql_query("SELECT sessao, tempo, ip FROM x_online WHERE sessao = '$sessao' OR ip = '$ip'") or die(mysql_error());
 		$contar_sessao = mysql_num_rows($pega_sessao);
 		
 		$pega_dia = mysql_query("SELECT * FROM x_visita_dia WHERE data = '$hoje'") or die(mysql_error());
		$contar_dia = mysql_num_rows($pega_dia);
		$max_dia = mysql_fetch_array($pega_dia);
		
		$visitUnic = mysql_query("SELECT * FROM x_visitante_unico WHERE ip = '$ip'") or die(mysql_error());
		$contar_unico = mysql_num_rows($visitUnic);
	if($contar_unico <= 0){
		$visitUnic = mysql_query("INSERT INTO x_visitante_unico (data, ip, visita) VALUES ('$hoje','$ip','1')") or die(mysql_error());
		$visitUnic = mysql_query("UPDATE x_contador SET visita_unica = visita_unica +'1'") or die(mysql_error());
		$visitUnic = mysql_query("UPDATE x_visita_dia SET visita_unica = visita_unica +'1' WHERE data = '$hoje'") or die(mysql_error());
	}else{
		$visitUnic = mysql_query("UPDATE x_visitante_unico SET data = '$hoje', visita = visita +'1' WHERE ip = '$ip'") or die(mysql_error());
		
	}	
	
 	if($contar_sessao <= 0){
		
	
		If($contar_dia <= 0){
			$dia = mysql_query("INSERT INTO x_visita_dia (data, visitas, visita_unica, pageviews) VALUES ('$hoje','1','1','1')") or die(mysql_error());	
		}else{
			$atualiza_dia = mysql_query("UPDATE x_visita_dia SET visitas = visitas +'1', pageviews = pageviews +'1' WHERE data = '$hoje'") or die(mysql_error());	
		}
		
 		$nova_sessao = mysql_query("INSERT INTO x_online (sessao, tempo, ip) VALUES ('$sessao','$tempo_on','$ip')") or die(mysql_error());
 		$contryMai = mysql_query("UPDATE x_country SET $sql WHERE id = '1'") or die(mysql_error());
 		$contar = mysql_query("UPDATE x_contador SET visitas = '$visitas_mais'") or die(mysql_error());

 	}else{
		$contar = mysql_query("UPDATE x_contador SET pageviews = pageviews + '1'") or die(mysql_error());
		$atualiza_dia = mysql_query("UPDATE x_visita_dia SET pageviews = pageviews + '1' WHERE data = '$hoje'") or die(mysql_error());
 		$atualiza_sessao = mysql_query("UPDATE x_online SET tempo = '$tempo_on' WHERE sessao = '".@$sessao."' OR ip = '$ip'") or die(mysql_error());

 	}
}
	if(@$action == "pagina"){
		$atualizaPage = mysql_query("UPDATE pagina SET visitas = visitas + '1' WHERE id = '".@$_GET['id']."'") or die(mysql_error());
		$atualizaPage = mysql_query("UPDATE termo SET views = views + '1' WHERE id = '".@$_GET['id']."' AND tipo ='page'") or die(mysql_error());
	}
	if(@$action == "produto"){
		$atualizaPage = mysql_query("UPDATE produto SET views = views + '1' WHERE id = '".@$_GET['id']."'") or die(mysql_error());
		$atualizaPage = mysql_query("UPDATE termo SET views = views + '1' WHERE id_s = '".@$_GET['id']."' AND tipo ='prod'") or die(mysql_error());
	}
	
$contagem = mysql_query("SELECT * FROM x_online ") or die(mysql_error());
$conta_on = mysql_num_rows($contagem);
$max = mysql_query("SELECT max FROM x_max_online WHERE id='1'") or die(mysql_error());
$conta_max = mysql_fetch_array($max);
if ($conta_on > $conta_max['max']){
	$up = mysql_query("UPDATE x_max_online SET data = '$hoje', max = $conta_on WHERE id = '1'") or die(mysql_error());
	
}
if ($conta_on > $max_dia['max']){
	$up = mysql_query("UPDATE x_visita_dia SET max_on = $conta_on WHERE data = '$hoje'") or die(mysql_error());
	
}
//mysql_free_result();
//mysql_close();
//echo $tempo_on;
//http://goupdigital.com.br/rank2/api.php?task=getranking&keyword=semaforo%20para%20doca&url=nivelartec.com.br
?><?
/*
Functions Name: Basic functions geral

Version: 1.0
Author: Wagner Medina
Website: www.destaquedigital.com.br
 */
 
function config_site(){
	$SQL = mysql_query("SELECT * FROM config_base WHERE id = '1' ");
		$DS = @mysql_fetch_array($SQL);
		if(!isset($metakey)){
			$metakey = $DS['metakey'];
		}
		if(!isset($descript)){
			$descript = $DS['metadescr'];
		}
		
		return array ($DS['titulo'], $DS['subtitulo'], $DS['metadescr'], $DS['metakey'], $DS['topo'], $DS['endereco'], $DS['cid_uf'], $DS['cep'], $DS['telefone'], $DS['email'], $DS['atendimento'], $DS['horario'], $DS['facebook'], $DS['twitter'], $DS['plus'], $DS['youtube'], $DS['instagran'], $DS['base'], $DS['analytics'], $DS['mapa']);
} 
 
function sessoes($str){
	$SQL = mysql_query("SELECT * FROM sessions_bloco WHERE posicao = '".$str."' ");
		$CH = mysql_fetch_array($SQL);
		if($CH["ativo"] == 1){
			return array ($CH["caminho"], $CH["tipo"]);
		}else{
			return array("N","0");
		}
//INSERT INTO sessions_bloco(nome, caminho, extra) VALUES ('Barra topo', 'topo.php','nada')	
//INSERT INTO sessions_position(posicao, caminho,tipo, ativo, extra) VALUES ('4','steps.php','1','1','nada')	
}
function calls($str){
	$SQL = mysql_query("SELECT * FROM config_calls WHERE nome = '".$str."' ");
		$CH = mysql_fetch_array($SQL);
			return array ($CH["tipo"], $CH["dados"], $CH["ativo"]);
}

function tipo($posic){
	$SQL = mysql_query("SELECT tipo FROM sessions_position WHERE posicao = '".$posic."' ");
		$CH = mysql_fetch_array($SQL);
		return $CH["tipo"];	
}

function sessoes2($str){
	$SQL = mysql_query("SELECT ".$str." FROM sessions WHERE id = '1' ");
		$CH = mysql_fetch_array($SQL);
		return $CH[$str];
}
function sel_cor($str){
	$SQL = mysql_query("SELECT ".$str." FROM cores_site WHERE id = '1' ");
		$CH = mysql_fetch_array($SQL);
		return $CH[$str];
}

function select_tema(){
	$SQL = mysql_query("SELECT caminho FROM temes WHERE ativo = '1' ");
		$CH = mysql_fetch_array($SQL);
		return $CH['caminho'];
}

?>
<? $SQL = mysql_query("SELECT * FROM destaque WHERE id = '1' "); $DES = @mysql_fetch_array($SQL); ?>
<? $SQL = mysql_query("SELECT * FROM chamadas WHERE id = '1' "); $CH = @mysql_fetch_array($SQL);  ?>