query($q);
if ($result)
{
if ($result->num_rows == 1)
{
$regControle = $result->fetch_assoc();
$result->free();
$qtd = $regControle ['qtdAcessos'] + 1;
$sql = "UPDATE controleAcessosIP SET qtdAcessos = " . $qtd . " WHERE ipAddress = '" . $ipAddress . "' AND data = CURDATE()";
}
else
{
$qtd = 1;
$result->free();
$sql = "INSERT INTO controleAcessosIP (ipAddress, data) VALUES ('" . $ipAddress . "', CURDATE())";
}
$result = $db->query($sql);
if ($qtd > 5 AND $bot === FALSE)
{
$db->close();
exit;
}
}
if ($bot === FALSE)
{
$filename = sprintf ("logFiles/accessLog%s.dat", date("Ymd"));
if ($handle = fopen($filename, 'a'))
{
if (flock($handle, LOCK_EX))
{
$record = "(" . $qtd . ");" . $fileContent;
fwrite ($handle, $record);
flock ($handle, LOCK_UN);
fclose ($handle);
}
}
}
include 'responsiveGenerationFunctions.php';
$currentURL = 'https://' . $_SERVER ['HTTP_HOST'] . $_SERVER ['PHP_SELF'];
$idRamo = getidRamoFromURL ($currentURL);
if (!isset ($_GET['idBairro']))
{
// echo "\n\n";
if (!strcmp ($dominioBase, 'sampaonline')) $idBairro = 'ALL';
else
{
$idBairro = obterIdBairroFromURL ($db, $dominioBase);
// Só por via das dúvidas !!!
if (!strcmp ($idBairro, 'sampaonline')) $idBairro = 'ALL';
}
}
else
{
$idBairro = $_GET['idBairro'];
$idBairro = filter_var ($idBairro, FILTER_SANITIZE_STRING);
}
$query = "SELECT tituloRamo, descricaoRamo, porBairro FROM ramos WHERE idRamo = '$idRamo'";
$result = $db->query($query);
if (!$result)
{
echo "DB Error (" . $db->errno . ") " . $db->error . "\n";
$db->close();
exit;
}
$ramo = $result->fetch_assoc();
$result->free();
if (!strcmp ($idBairro, 'ALL'))
{
printf ("%s em São Paulo - SP\n", $ramo['tituloRamo']);
printf ("\n", $ramo['descricaoRamo']);
$preposicaoDoBairro = NULL;
$nomeDoBairro = NULL;
}
else
{
if (($pos = stripos ($idBairro, 'concat')) === FALSE)
if ($pos === FALSE) $pos = stripos ($idBairro, 'union');
if ($pos !== FALSE)
{
$db->close();
die ();
}
$query = "SELECT complementoTitulo, complementoDescricao, preposicao, nomeDoBairro, zona from bairros WHERE idBairro = '" . $db->real_escape_string ($idBairro) . "'";
$result = $db->query($query);
if (!$result)
{
echo "DB Error\n";
$db->close();
exit;
}
if ($result->num_rows > 1)
{
echo "[" . __LINE__. "] Erro de request. Contate o Sampa Online";
$result->free();
$db->close();
exit;
}
if ($result->num_rows == 0)
{
echo "[" . __LINE__. "] Erro de request. Contate o Sampa Online";
$result->free();
$db->close();
exit;
}
$bairro = $result->fetch_assoc();
$result->free();
$preposicaoDoBairro = $bairro ['preposicao'];
$nomeDoBairro = $bairro ['nomeDoBairro'];
printf ("%s %s %s\n", $ramo['tituloRamo'], $bairro ['preposicao'], $bairro ['nomeDoBairro']);
if (empty ($bairro ['complementoDescricao'])) printf ("\n", $ramo['descricaoRamo'], $bairro ['complementoTitulo']);
else printf ("\n", $ramo['descricaoRamo'], $bairro ['complementoTitulo'], $bairro ['complementoDescricao']);
}
if (!empty ($ramo['keywords'])) echo "\n";
echo "\n";
?>
close();
?>