session_name( "SYNCRO" );
$v1="user_id";
$v2="user_name";
$v3="user_auth";
session_register($v1,$v2,$v3);
session_start();
require ("common/config.inc.php");
require ("common/dbnav_bar.php");
if ( !isset( $offset ) ) $offset = 0;
$sql_orden = "";
$MWhere = "";
$parse_options = "";
if ( isset( $orden ) )
{
$parse_options .= "&orden=$orden";
if ( strcmp( $orden, "g" ) == 0 )
$sql_orden = " ORDER BY Genero, Titulo ";
if ( strcmp( $orden, "t" ) == 0 )
$sql_orden = " ORDER BY Titulo ";
}
if ( isset( $status ) )
{
switch( $status )
{
case "-= CUALQUIERA =-":
break;
case "No la tengo";
$MWhere = "WHERE pu.status IS NULL";
$parse_options .="&status=$status";
break;
default:
$MWhere = "WHERE p.status = '$status'";
$parse_options .="&status=$status";
break;
}
}
if ( isset( $genero ) )
{
if ( empty( $MWhere ) ) { $MWhere = "WHERE "; $And = ""; } else { $And =" AND "; }
switch( $genero )
{
case "-= CUALQUIERA =-";
break;
default:
$MWhere .= $And ." p.Genero='$genero'";
$parse_options .="&genero=$genero";
break;
}
}
// Segun TIPO selecionamos las pelis
$conexion = mysql_connect( 'localhost', 'syncro_users', '29dic2001' ) OR die("No puedo conectar");
$id = mysql_select_db( 'SYNCRO', $conexion ) OR die("No puedo abrir Base de Datos");
$sdown = false;
if ( $user_auth )
{
$qFROM = "pelis AS p LEFT JOIN pelis_user AS pu ON (pu.user=$user_id AND p.id=pu.peli) $MWhere";
$consulta = "SELECT DISTINCT p.id, p.Genero, p.Status, p.Titulo, p.Duracion, p.NumCDs, pu.status FROM $qFROM $sql_orden LIMIT $offset, $limit";
$sdown = true;
} else {
$qFROM = "pelis p";
$consulta = "SELECT p.id, p.Genero, p.Status, p.Titulo, p.Duracion, p.NumCDs, p.owner, u.Apodo FROM $qFROM, users u WHERE u.id = p.owner $sql_orden LIMIT $offset, $limit";
}
if ( isset( $q ) )
{
if ( strcmp( $q, "mias" )==0 && $user_auth )
{
// $qFROM = "pelis p, pelis_user pu WHERE pu.user = $user_id AND p.id = pu.peli";
// $consulta = "SELECT DISTINCT p.id, p.Genero, p.Status, p.Titulo, p.Duracion, p.NumCDs, pu.status FROM $qFROM $sql_orden LIMIT $offset, $limit";
$qFROM = "pelis p, pelis_user pu LEFT JOIN pelis_user pup ON (pup.status='PEDIR' AND pu.status='OK' AND p.id=pup.peli) WHERE pu.user=$user_id AND p.id=pu.peli";
$consulta = "SELECT DISTINCT p.id, p.Genero, p.Status, p.Titulo, p.Duracion, p.NumCDs, pu.status, pup.peli FROM $qFROM $sql_orden LIMIT $offset, $limit";
$sdown = true;
$slapiden = true;
$parse_options .= "&q=mias";
}
if ( strcmp( $q, "en_curso" )==0 && $user_auth )
{
$qFROM = "pelis p WHERE p.Status != 'OK'";
$consulta = "SELECT p.id, p.Genero, p.Status, p.Titulo, p.Duracion, p.NumCDs FROM $qFROM $sql_orden LIMIT $offset, $limit";
$sdown = false;
$parse_options .= "&q=en_curso";
}
}
CreateDBnav( $qFROM );
$res = mysql_query( $consulta, $conexion ) OR die("No puedo realizar la consulta
$consulta
".mysql_error($conexion));
?>
|