308 lines
14 KiB
PHP
308 lines
14 KiB
PHP
<?
|
|
session_name( "SYNCRO" );
|
|
$v1="user_id";
|
|
$v2="user_name";
|
|
$v3="user_auth";
|
|
session_register($v1,$v2,$v3);
|
|
session_start();
|
|
|
|
$mostrar_enviar = false;
|
|
$mostrar_borrar = false;
|
|
|
|
// Si nos dan un número de referencia, mostramos la peli
|
|
if ( isset($peli_id) )
|
|
{
|
|
// Quizas sea para eliminarla...
|
|
if ( isset( $accion ) )
|
|
{
|
|
if ( strcmp( $accion, "borrar" ) == 0 )
|
|
{
|
|
$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");
|
|
|
|
$borr = "DELETE FROM pelis_user WHERE user = $user_id AND peli = $peli_id";
|
|
$res = mysql_query( $borr, $conexion ) OR die("No puedo eliminar esta peli de mi lista<br>$sql_upd<br>".mysql_error($conexion));
|
|
$consulta = "SELECT * FROM pelis_user WHERE peli = $peli_id";
|
|
$res = mysql_query( $consulta, $conexion ) OR die("No puedo consultar que usuarios tienen esta peli");
|
|
$nres = mysql_num_rows($res);
|
|
mysql_free_result($res);
|
|
if ( $nres == 0 )
|
|
{
|
|
// Como nadie mas tiene esta peli, la eliminamos completamente
|
|
$borr = "DELETE FROM pelis WHERE id = $peli_id";
|
|
$res = mysql_query( $borr, $conexion ) OR die("No puedo eliminar esta peli de la lista<br>$sql_upd<br>".mysql_error($conexion));
|
|
}
|
|
mysql_close($conexion);
|
|
}
|
|
|
|
if ( isset( $p_id ) )
|
|
{
|
|
if ( strcmp( $accion, "editar" ) == 0 && $user_auth )
|
|
{
|
|
$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");
|
|
|
|
$modf = "UPDATE pelis SET ";
|
|
// Solo el que la creo, puede modificar su estado...
|
|
if ( $user_id == $p_uid )
|
|
{
|
|
$modf = $modf . " Genero = '$p_genero'";
|
|
$modf = $modf . ", Status = '$p_status'";
|
|
$modf = $modf . ", titulo = '$p_titulo'";
|
|
$modf = $modf . ", FechaRip = '$p_frip'";
|
|
$modf = $modf . ", Duracion = '$p_dur'";
|
|
$modf = $modf . ", NumCDs = '$p_cds'";
|
|
$modf = $modf . ", Comentarios = '$p_comm'";
|
|
if ( !empty($imgData_name) && $imgData_size > 0 )
|
|
{
|
|
$img_prop = GetImageSize($imgData);
|
|
$imgW = $img_prop[0]; $p_imgW = $imgW;
|
|
$imgH = $img_prop[1]; $p_imgH = $imgH;
|
|
$data = addslashes(fread(fopen($imgData,"rb"), filesize($imgData)));
|
|
$modf = $modf . ", Imagen = '$data', filetype='$imgData_type', imgW='$imgW', imgH='$imgH'";
|
|
}
|
|
} else {
|
|
$modf = $modf . " Comentarios = '$p_comm'";
|
|
}
|
|
$modf = $modf . " WHERE id = ".$p_id;
|
|
}
|
|
$res = mysql_query( $modf, $conexion ) OR die("No puedo modificar esta peli<br>$sql_upd<br>".mysql_error($conexion));
|
|
mysql_close($conexion);
|
|
}
|
|
} else {
|
|
// La visionamos...
|
|
$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");
|
|
|
|
$consulta = "SELECT ";
|
|
$consulta = $consulta . "p.owner, p.Genero, p.Status, p.Titulo, p.FechaRip, p.Duracion, p.NumCDs, p.Comentarios, p.imgH, p.imgW";
|
|
$consulta = $consulta . ", u.Apodo";
|
|
$consulta = $consulta . " FROM pelis p, users u WHERE p.id = $peli_id AND p.owner = u.id";
|
|
$res = mysql_query( $consulta, $conexion ) OR die("No puedo realizar la consulta");
|
|
if ( mysql_num_rows($res) > 0 )
|
|
{
|
|
$p_uid = mysql_result( $res, 0, 'owner' );
|
|
$p_user = mysql_result( $res, 0, 'Apodo' );
|
|
$p_genero= mysql_result( $res, 0, 'Genero' );
|
|
$p_status= mysql_result( $res, 0, 'Status' );
|
|
$p_titulo= mysql_result( $res, 0, 'Titulo' );
|
|
$p_frip = mysql_result( $res, 0, 'FechaRip' );
|
|
$p_cds = mysql_result( $res, 0, 'NumCDs' );
|
|
$p_dur = mysql_result( $res, 0, 'Duracion' );
|
|
$p_comm = mysql_result( $res, 0, 'Comentarios' );
|
|
$p_imgH = mysql_result( $res, 0, 'imgH' );
|
|
$p_imgW = mysql_result( $res, 0, 'imgW' );
|
|
}
|
|
mysql_free_result($res);
|
|
mysql_close($conexion);
|
|
|
|
if ( $user_auth )
|
|
{
|
|
$mostrar_enviar = true;
|
|
$mostrar_borrar = true;
|
|
}
|
|
}
|
|
} else {
|
|
// Modo Insertar PELI
|
|
// Si el usuario esta 'authenticate'
|
|
if ( user_auth )
|
|
{
|
|
$ins_ok = isset( $p_titulo ) && !empty( $p_titulo );
|
|
if ( $ins_ok )
|
|
{
|
|
if ( empty( $p_titulo ) )
|
|
die( "Es imprescindible introducir el Titulo" );
|
|
// Procedemos a la insercion:
|
|
// 1º insertamos la peli en la base de datos...
|
|
// 2º insertamos la peli en la lista personal...
|
|
if ( !empty($imgData_name) && $imgData_size > 0 )
|
|
{
|
|
$img_prop = GetImageSize($imgData);
|
|
$imgW = $img_prop[0]; $p_imgW = $imgW;
|
|
$imgH = $img_prop[1]; $p_imgH = $imgH;
|
|
$data = addslashes(fread(fopen($imgData,"rb"), filesize($imgData)));
|
|
$sql_upd = "INSERT INTO pelis (owner, Genero, Status, Titulo, FechaRip, Duracion, NumCDs, Comentarios, Imagen, filetype, imgW, imgH) VALUES";
|
|
$sql_upd = $sql_upd . "($user_id, '$p_genero', '$p_status', '$p_titulo', '$p_frip', '$p_dur', '$p_cds', '$p_comm', '$data', '$imgData_type', '$imgW', '$imgH')";
|
|
} else {
|
|
$sql_upd = "INSERT INTO pelis (owner, Genero, Status, Titulo, FechaRip, Duracion, NumCDs, Comentarios) VALUES";
|
|
$sql_upd = $sql_upd . "($user_id, '$p_genero', '$p_status', '$p_titulo', '$p_frip', '$p_dur', '$p_cds', '$p_comm')";
|
|
}
|
|
$mostrar_enviar = false;
|
|
$mostrar_borrar = false;
|
|
} else {
|
|
$p_uid = $user_id;
|
|
$p_user = $user_name;
|
|
$mostrar_enviar = true;
|
|
$mostrar_borrar = false;
|
|
}
|
|
|
|
if ( $ins_ok )
|
|
{
|
|
$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");
|
|
$res = mysql_query( $sql_upd, $conexion ) OR die("No puedo realizar las Inserciones<br>$sql_upd<br>".mysql_error($conexion));
|
|
$sql_upd = "INSERT INTO pelis_user (user, peli) VALUES($user_id,LAST_INSERT_ID())";
|
|
$res = mysql_query( $sql_upd, $conexion ) OR die("No puedo realizar las Inserciones Personales<br>$sql_upd<br>".mysql_error($conexion));
|
|
mysql_close($conexion);
|
|
}
|
|
}
|
|
}
|
|
|
|
|
|
$image_prop = "";
|
|
if ( $p_imgW > 0 )
|
|
{
|
|
if ( $p_imgW > $p_imgH )
|
|
{
|
|
$imgH = intval(($p_imgH/$p_imgW)*180); $imgW = 180;
|
|
$image_prop = " width=\"180\" height=\"".$imgH."\"";
|
|
} else {
|
|
$imgW = intval(($p_imgW/$p_imgH)*150); $imgH = 150;
|
|
$image_prop = " height=\"150\" width=\"".$imgW."\"";
|
|
}
|
|
}
|
|
?>
|
|
<html>
|
|
|
|
<head>
|
|
<title>-= SYNCRO =-</title>
|
|
<link href="syncro.ico" rel="SHORTCUT ICON">
|
|
<link rel="stylesheet" type="text/css" href="syncro.css"
|
|
body="syncro.css">
|
|
</head>
|
|
|
|
<body bgcolor="#57A44D">
|
|
<?
|
|
if ( $user_auth )
|
|
{
|
|
if ( !isset( $peli_id ) )
|
|
echo "<form action=\"$PHP_SELF\" method=\"POST\" enctype=\"multipart/form-data\">";
|
|
else
|
|
echo "<form action=\"$PHP_SELF?peli_id=$peli_id&accion=editar\" method=\"POST\" enctype=\"multipart/form-data\">";
|
|
} else {
|
|
echo '<form>';
|
|
}
|
|
?>
|
|
<div align="center"><center><table border="1" cellpadding="0"
|
|
cellspacing="0" width="600" bgcolor="#427B42"
|
|
bordercolor="#000000" bordercolordark="#000000"
|
|
bordercolorlight="#000000">
|
|
<tr>
|
|
<td><table border="0" cellpadding="0" cellspacing="0"
|
|
width="100%">
|
|
<tr>
|
|
<td width="200"><center><a href="gestion-fotop.php?idf=<?echo $peli_id?>" target="_blank"><img src="gestion-fotop.php?idf=<?echo $peli_id?>" border="0" <?echo $image_prop ?> ></a></center>
|
|
</td>
|
|
<td><table border="0" cellpadding="0"
|
|
cellspacing="0" width="100%">
|
|
<tr>
|
|
<td><table border="0" cellpadding="0"
|
|
cellspacing="0" width="100%">
|
|
<tr>
|
|
<td>Ripeador:</td>
|
|
<td><a href="miFicha.php?info_user=<? echo $p_uid ?>"><? echo $p_user ?></a></td>
|
|
<td>Estado Actual:</td>
|
|
<td><select name="p_status"
|
|
size="1">
|
|
<option <? if ( strcmp($p_status,"OK")==0 ) echo " SELECTED "; ?> >OK</option>
|
|
<option <? if ( strcmp($p_status,"Para Alquilar")==0 ) echo " SELECTED "; ?> >Para Alquilar</option>
|
|
<option <? if ( strcmp($p_status,"Ripeando")==0 ) echo " SELECTED "; ?> >Ripeando</option>
|
|
<option <? if ( strcmp($p_status,"Por llegar")==0 ) echo " SELECTED "; ?> >Por llegar</option>
|
|
</select></td>
|
|
</tr>
|
|
<tr>
|
|
<td>Num.CD's:</td>
|
|
<td><input type="text"
|
|
size="15" name="p_cds" value="<? echo $p_cds ?>" ></td>
|
|
<td>Género:</td>
|
|
<td><select name="p_genero"
|
|
size="1">
|
|
<option <? if ( strcmp($p_genero,"SIN CLASIFICAR")==0 ) echo " SELECTED "; ?> >SIN CLASIFICAR</option>
|
|
<option <? if ( strcmp($p_genero,"Acción")==0 ) echo " SELECTED "; ?> >Acción</option>
|
|
<option <? if ( strcmp($p_genero,"Animación")==0 ) echo " SELECTED "; ?> >Animación</option>
|
|
<option <? if ( strcmp($p_genero,"Aventuras")==0 ) echo " SELECTED "; ?> >Aventuras</option>
|
|
<option <? if ( strcmp($p_genero,"Bélica")==0 ) echo " SELECTED "; ?> >Bélica</option>
|
|
<option <? if ( strcmp($p_genero,"Biografía")==0 ) echo " SELECTED "; ?> >Biografía</option>
|
|
<option <? if ( strcmp($p_genero,"Catástrofe")==0 ) echo " SELECTED "; ?> >Catástrofe</option>
|
|
<option <? if ( strcmp($p_genero,"C.Ficción")==0 ) echo " SELECTED "; ?> >C.Ficción</option>
|
|
<option <? if ( strcmp($p_genero,"Fantástico")==0 ) echo " SELECTED "; ?> >Fantástico</option>
|
|
<option <? if ( strcmp($p_genero,"Cine Negro")==0 ) echo " SELECTED "; ?> >Cine Negro</option>
|
|
<option <? if ( strcmp($p_genero,"Comedia")==0 ) echo " SELECTED "; ?> >Comedia</option>
|
|
<option <? if ( strcmp($p_genero,"Dib.Animado")==0 ) echo " SELECTED "; ?> >Dib.Animado</option>
|
|
<option <? if ( strcmp($p_genero,"Documental")==0 ) echo " SELECTED "; ?> >Documental</option>
|
|
<option <? if ( strcmp($p_genero,"Drama")==0 ) echo " SELECTED "; ?> >Drama</option>
|
|
<option <? if ( strcmp($p_genero,"Histórica")==0 ) echo " SELECTED "; ?> >Histórica</option>
|
|
<option <? if ( strcmp($p_genero,"Intriga")==0 ) echo " SELECTED "; ?> >Intriga</option>
|
|
<option <? if ( strcmp($p_genero,"Musical")==0 ) echo " SELECTED "; ?> >Musical</option>
|
|
<option <? if ( strcmp($p_genero,"Melodrama")==0 ) echo " SELECTED "; ?> >Melodrama</option>
|
|
<option <? if ( strcmp($p_genero,"Oeste")==0 ) echo " SELECTED "; ?> >Oeste</option>
|
|
<option <? if ( strcmp($p_genero,"Terror")==0 ) echo " SELECTED "; ?> >Terror</option>
|
|
<option <? if ( strcmp($p_genero,"Picantes")==0 ) echo " SELECTED "; ?> >Picantes</option>
|
|
</select></td>
|
|
</tr>
|
|
</table>
|
|
<table border="0" cellpadding="0"
|
|
cellspacing="0" width="100%">
|
|
<tr>
|
|
<td>Fecha Rip.</td>
|
|
<td>Titulo</td>
|
|
<td>Duración</td>
|
|
</tr>
|
|
<tr>
|
|
<td><input type="text"
|
|
size="15" name="p_frip" value="<? echo $p_frip ?>" ></td>
|
|
<td><input type="text"
|
|
size="30" name="p_titulo" value="<? echo $p_titulo ?>" ></td>
|
|
<td><input type="text"
|
|
size="7" name="p_dur" value="<? echo $p_dur ?>" ></td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
<tr>
|
|
<td><table border="0" cellpadding="0"
|
|
cellspacing="0" width="100%">
|
|
<tr>
|
|
<td><textarea name="p_comm"
|
|
rows="5" cols="40" ><? echo $p_comm ?></textarea></td>
|
|
<td>
|
|
<input type=hidden name="p_uid" value="<? echo $p_uid ?>">
|
|
<input type=hidden name="p_id" value="<? echo $peli_id ?>">
|
|
<?
|
|
if ( $mostrar_borrar )
|
|
echo '<a href="gestion-pelisp.php?peli_id='.$peli_id.'&accion=borrar"><img src="images/borrar.gif" alt="ELIMINAR" align="bottom" border="0" width="20" height="71"></a>';
|
|
if ( $mostrar_enviar )
|
|
echo '<input type="image" name="I2" src="images/enviar.gif" alt="ENVIAR" align="bottom" border="0" width="20" height="71">';
|
|
?>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<?
|
|
if ( $user_id == $p_uid ) {
|
|
?>
|
|
<table border="0">
|
|
<tr>
|
|
<td><INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="300000">
|
|
<input type="file" size="40" name="imgData"></td>
|
|
</tr>
|
|
</table>
|
|
<?
|
|
}
|
|
?>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</center></div>
|
|
<INPUT TYPE="hidden" name="p_imgH" value="<? echo $imgH ?>">
|
|
<INPUT TYPE="hidden" name="p_imgW" value="<? echo $imgW ?>">
|
|
</form>
|
|
</body>
|
|
</html>
|
|
|