$id = Url::getURL(3);
$spoter = Url::getURL(1);
if ($id == ""){
?>
O TEU SPOT
$res=DB::Select("select * from spoters
where ((select count(*) from conteudos_informacao where conteudos_informacao_spoters_codigo = spoters_codigo and conteudos_informacao_estado = 1)>0
) order by spoters_codigo desc
");
while($spoters = mysqli_fetch_array($res, MYSQLI_ASSOC))
{
?>
}?>
}
else
{
$res30=DB::Select("
select * from spoters
where
spoters_codigo = $id
");
$sp = mysqli_fetch_array($res30, MYSQLI_ASSOC);
?>
$res=DB::Select("select * from conteudos_informacao
where conteudos_informacao_spoters_codigo = $id and conteudos_informacao_estado = 1 order by conteudos_informacao_codigo asc");
while($conteudos_informacao = mysqli_fetch_array($res, MYSQLI_ASSOC))
{
?>
}?>
}?>
}?>
}?>
}?>
}?>
$res1=DB::Select("select * from spoters where spoters_codigo > $id
and
((select count(*) from conteudos_informacao where conteudos_informacao_spoters_codigo = spoters_codigo and conteudos_informacao_estado = 1)>0)
order by spoters_codigo asc limit 1
");
$spoters_anterior = mysqli_fetch_array($res1, MYSQLI_ASSOC);
if($spoters_anterior['spoters_descritivo']==""){
$mostra_anterior="display:none;";
}
else{
$mostra_anterior="display:block;";
}
?>
$res=DB::Select("select * from spoters where spoters_codigo < $id
and
((select count(*) from conteudos_informacao where conteudos_informacao_spoters_codigo = spoters_codigo and conteudos_informacao_estado = 1)>0)
order by spoters_codigo desc limit 1
");
$spoters_seguinte = mysqli_fetch_array($res, MYSQLI_ASSOC);
if($spoters_seguinte['spoters_descritivo']==""){
$mostra_seguinte="display:none;";
}
else{
$mostra_seguinte="display:block;";
}
?>