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));
?>
  | 
    |||||||||||||||||||||||||||||||