";
// COLUMNA IZDA
print "";
include ("bloques/navigation.php");
print " | ";
// COLUMNA CENTRAL
print "";
print "";
// --> PUBLICIDAD SUPERIOR
include ("google/publicidad2.html");
if ($busqueda==NULL) {
$busqueda = date("Ym");
}
if ($formato!='Cine') {
$test->sql = "SELECT * FROM prueba WHERE (formato$tema2 AND titulo LIKE '%$busqueda%') or (formato$tema2 AND distribuidora LIKE '%$busqueda%') or (formato$tema2 AND director LIKE '%$busqueda%') or (formato$tema2 AND interpretes LIKE '%$busqueda%') or (formato$tema2 AND fecha LIKE '%$busqueda%') and promocion='SPA' and fallo LIKE '%$fallo%' and tipo LIKE '%$tipo%' and hot LIKE '%$hot%' ORDER BY fecha, distribuidora, titulo";
} else {
$test->sql = "SELECT * FROM prueba WHERE (formato='Cine' AND titulo LIKE '%$busqueda%') or (formato='Cine' AND distribuidora LIKE '%$busqueda%') or (formato='Cine' AND director LIKE '%$busqueda%') or (formato='Cine' AND interpretes LIKE '%$busqueda%') or (formato='Cine' AND fechacine LIKE '%$busqueda%') and promocion='SPA' and fallo LIKE '%$fallo%' and tipo LIKE '%$tipo%' and hot LIKE '%$hot%' ORDER BY fechacine, distribuidora, titulo";
}
$result = $test->get_page_result(); // result set
$num_rows = $test->get_page_num_rows(); // number of records in result set
$nav_links = $test->navigation(" | ", "currentStyle"); // the navigation links (define a CSS class selector for the current link)
$nav_info = $test->page_info("to"); // information about the number of records on page ("to" is the text between the number)
$simple_nav_links = $test->back_forward_link(true); // the navigation with only the back and forward links, use true to use images
$total_recs = $test->get_total_rows(); // the total number of records
print "
";
for ($i = 0; $i < $num_rows; $i++) {
$titulo = mysql_result($result, $i, "titulo");
$id = mysql_result($result, $i, "id");
$dvdgo = mysql_result($result, $i, "dvdgo");
$imdb = mysql_result($result, $i, "imdb");
$distribuidora = mysql_result($result, $i, "distribuidora");
$hot = mysql_result($result, $i, "hot");
$ficha = mysql_result($result, $i, "ficha");
$caratuladelante = mysql_result($result, $i, "caratuladelante");
$caratuladetras = mysql_result($result, $i, "caratuladetras");
$formato = mysql_result($result, $i, "formato");
$tipo = mysql_result($result, $i, "tipo");
$corregir = mysql_result($result, $i, "corregir");
$fnac = mysql_result($result, $i, "fnac");
$fallo = mysql_result($result, $i, "fallo");
$fecha = mysql_result($result, $i, "fecha");
$dia = mysql_result($result, $i, "dia");
$mes = mysql_result($result, $i, "mes");
$alanzamiento = mysql_result($result, $i, "alanzamiento");
$fechacine = mysql_result($result, $i, "fechacine");
$diacine = mysql_result($result, $i, "diacine");
$mescine = mysql_result($result, $i, "mescine");
$alanzamientocine = mysql_result($result, $i, "alanzamientocine");
$numdiscos = mysql_result($result, $i, "numdiscos");
$urloficial = mysql_result($result, $i, "urloficial");
$allposters = mysql_result($result, $i, "allposters");
$bsofnac = mysql_result($result, $i, "bsofnac");
$foromundodvd = mysql_result($result, $i, "foromundodvd");
$forodvd = mysql_result($result, $i, "forodvd");
$trailer = mysql_result($result, $i, "trailer");
$imdb = mysql_result($result, $i, "imdb");
$calificacion = mysql_result($result, $i, "calificacion");
$idiomas = mysql_result($result, $i, "idiomas");
$director = mysql_result($result, $i, "director");
$creador = mysql_result($result, $i, "creador");
$formatocine = mysql_result($result, $i, "formatocine");
$duracion = mysql_result($result, $i, "duracion");
$color = mysql_result($result, $i, "color");
$interpretes = mysql_result($result, $i, "interpretes");
$aestreno = mysql_result($result, $i, "aestreno");
$original = mysql_result($result, $i, "original");
$genero = mysql_result($result, $i, "genero");
$comentarios = mysql_result($result, $i, "comentarios");
$imprescindible = mysql_result($result, $i, "imprescindible");
$visitas = mysql_result($result, $i, "visitas");
$visitascine = mysql_result($result, $i, "visitascine");
$screens = mysql_result($result, $i, "screens");
$moviewebtrailer = mysql_result($result, $i, "moviewebtrailer");
$allposters = mysql_result($result, $i, "allposters");
$promocion = mysql_result($result, $i, "promocion");
include("urls.php");
$fechahoy = date("Ymd");
if ($formato!='Cine') {
$cover = "carátula";
$estemes = "$alanzamiento$mes";
print "";
include ("bloques/fechanavigation.php");
include ("bloques/fecha.php");
$fechaanterior = $fecha;
} else {
$cover = "poster";
$estemes = "$alanzamientocine$mescine";
print " | ";
include ("bloques/fechanavigationcine.php");
include ("bloques/fechacine.php");
$fechaanterior = $fechacine;
}
$visitastot = $visitascine + $visitas;
print "";
// ICONO CARATULA SI/NO
print "";
if ($caratuladelante=='default') {
print "";
} else {
print "";
}
print " | ";
// ICONO FOTOGRAMAS SI/NO
print "";
if ($screens!=0) {
print "";
} else {
print "";
}
print " | ";
// LINK IMDB
print "";
if ($imdb==NULL) {
print "";
} else {
print "";
}
print " | ";
// ICO FORMATO DEL DISCO
print "";
switch ($formato) {
case "Cine": print "";
break;
case "Alquiler": print "";
break;
case "DVD Video": print "";
break;
case "Blu-Ray": print "";
break;
case "HD-DVD": print "";
break;
case NULL: print "";
break;
default: print "";
}
print " | ";
// RECOMENDADO O BODRIAZO
print "";
switch ($imprescindible) {
case "SI": print "";
break;
case "NO": print "-";
break;
case "BO": print "";
break;
default: print "";
}
print " | ";
// TITULO
switch ($formato) {
case "Cine": $fcolor = "cine";
break;
case "Alquiler": $fcolor = "alquiler";
break;
case "DVD Video": $fcolor = "dvd";
break;
case "Blu-Ray": $fcolor = "bd";
break;
}
print " ";
$ndesc_name = $titulo;
$longitud = strlen($titulo);
if ($longitud > 60) {
$ndesc_name = substr($titulo,0,60);
if ($ficha=='SI') {
if ($hot=='NO') {
print "$ndesc_name.";
} else {
print "$ndesc_name.";
}
} else {
print "$ndesc_name.";
}
} else {
if ($ficha=='SI') {
if ($hot=='NO') {
print "$titulo";
} else {
print "$titulo";
}
} else {
print "$titulo";
}
}
switch ($promocion) {
case "SPA": print "";
break;
case "USA": print " ";
break;
case "UK": print " ";
break;
case "GER": print " ";
break;
case "JAP": print " ";
break;
case "ITA": print " ";
break;
case "AUS": print " ";
break;
case "POR": print " ";
break;
case "FRA": print " ";
break;
case NULL: print "";
break;
default: print "";
}
print " | ";
// CALIFICACION MORAL
print "";
switch ($calificacion) {
case "TP": print "";
break;
case "NR7": print "";
break;
case "ERI": print "";
break;
case "NR12": print "";
break;
case "NR13": print "";
break;
case "NR16": print "";
break;
case "NR18": print "";
break;
case "XXX": print "";
break;
case NULL: print "";
break;
default: print "";
}
print " | ";
// DISTRIBUIDORA CON SENTENCIA DE BÚSQUEDA INLINE
print " ";
print "$distribuidora";
print " | ";
// BOTONES COMPRA
print "";
if ($formato=='Cine') {
include ("bloques/enlacesposter.php");
} else {
include ("bloques/enlacesmini.php");
}
print " | ";
// ENLACES OFICIALES
print "";
include ("bloques/enlacescine.php");
print " | ";
print " ";
// -> FINALIZA LA TABLA DE CALENDARIO
print " | ";
}
print " ";
// SEPARACIÓN ENTRE EL SISTEMA DE PÁGINAS Y LA TABLA DE RESULTADOS
print "";
include ("google/google_728x015f.html");
print " | ";
print "".$nav_links." | ";
print " ";
$test->free_page_result();
print " | ";
// COLUMNA DCHA
print "";
include ("bloques/navigation2.php");;
print " |