";
print "";
switch ($tema) {
case NULL: $tema2 = "!='Cine'"; $sufijo = "todo";
break;
case "bd": $tema2 = "='Blu-Ray'"; $tema3 = "Blu-Ray"; $sufijo = "bd";
break;
case "hd": $tema2 = "='HD-DVD'"; $tema3 = "HD-DVD"; $sufijo = "hd";
break;
case "dvd": $tema2 = "='DVD Video'"; $tema3 = "DVD"; $sufijo = "dvd";
break;
case "alquiler": $tema2 = "='Alquiler'"; $tema3 = "DVD alquiler"; $sufijo = "alquiler";
break;
case "cine": $tema2 = "='Cine'"; $tema3 = "Cine"; $formato = "Cine"; $sufijo = "cine";
break;
default: $tema2 = "!='Cine'"; $sufijo = "todo";
}
include ("bloques/navigation.php");
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");
include("urls.php");
$fechahoy = date("Ymd");
if ($formato!='Cine') {
$estemes = "$alanzamiento$mes";
print "";
include ("bloques/fechanavigationbb.php");
} else {
$estemes = "$alanzamientocine$mescine";
print " | ";
include ("bloques/fechanavigationcinebb.php");
}
if ($formato!='Cine') {
include ("bloques/fechabb.php");
$fechaanterior = $fecha;
} else {
include ("bloques/fechacinebb.php");
$fechaanterior = $fechacine;
}
if ($dvdgo==NULL) {
print ":dvdgo_b ";
} else {
print "" . chr(91) . "b" . chr(93) . chr(91) . "url=http://www.index-dvd.com/dvdgo-$titulo2-$dvdgo.html" . chr(93) . ":dvdgo_a" . chr(91) . "/url" . chr(93) . chr(91) . "/b" . chr(93) . " ";
}
if ($fnac==NULL) {
print ":fnac_b ";
} else {
print "" . chr(91) . "b" . chr(93) . chr(91) . "url=http://www.index-dvd.com/fnac-$titulo2-$fnac.html" . chr(93) . ":fnac_a" . chr(91) . "/url" . chr(93) . chr(91) . "/b" . chr(93) . " ";
}
if ($ficha=='SI') {
print "" . chr(91) . "url=http://www.index-dvd.com/$friendly-$titulo2-$id.html" . chr(93) . "$titulo" . chr(91) . "/url" . chr(93) . "";
} else {
print "$titulo";
}
if ($distribuidora==NULL) {
print "";
} else {
print ", ". chr(91) . "color=gray" . chr(93) . "$distribuidora" . chr(91) . "/color" . chr(93) . "";
}
print " ";
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 " |