<%@page import="java.util.Arrays"%>
<%@page import="RGTEC.Definitions"%>
<%@page import="javax.swing.JOptionPane"%>
<%@page import="java.net.URLEncoder"%>
<%@page import="java.net.URLDecoder"%>
<%@page import="br.com.rgtec.bd.Base"%>
<%
response.setContentType("text/html;charset=UTF-8");
Definitions def = new Definitions();
Base bsm = def.OpenMaster();
if (request.getParameter("pg") == null) {
%>
<%
String list[][] = bsm.busca("home", new String[]{"*"}, " IdEmpresa like '1' and Ativo like '1' and Referencia like 'home' order by Titulo ASC");
if (list[0].length > 1) {
for (int i = 0; i <= list.length - 1; i++) {
%>
<%
} else {
String list[][] = bsm.busca("page", new String[]{"*"}, " IdEmpresa like '1' and UrlPage like '" + new String(request.getParameter("pg").getBytes(), "UTF-8") + "'");
for (int i = 0; i <= list.length - 1; i++) {
if (list[i].length > 1) {
%>
<% out.print("
" + list[i][3] + "
");
out.print("
");
out.print(list[i][2]);
out.print("
");
%>
<%
}
}
}
%>
<%
String album[][] = bsm.busca("album", new String[]{"*"}, "IdEmpresa like '1' and NomeAlbum like 'Parceiros'");
String fotos[][] = bsm.busca("midia", new String[]{"*"}, "IdAlbum like '" + album[0][0] + "' order by DescricaoMidia");
if (fotos[0].length > 1) {
for (int i = 0; i <= fotos.length - 1; i++) {
out.println("