<meta charset="UTF-8">
if(isset($_POST['insertar'])){
$nombre = addslashes(formText($_POST['nombre']));
$nombre2 = addslashes(formText($_POST['nombre2']));
$tipo = $_POST['tipo'];
$genero = intval($_POST['genero']);
$idioma = intval($_POST['idioma']);
$anio = intval($_POST['anio']);
$duracion = intval($_POST['duracion']);
$reparto = addslashes($_POST['reparto']);
$director = addslashes($_POST['director']);
$guion = addslashes($_POST['guion']);
$productora = addslashes($_POST['productora']);
$descripcion = addslashes($_POST['descripcion']);
$estado = $_POST['estado'];
if (strlen($nombre)==0) {
$error = true;
$msg = 'Debes proporcionar un nombre.';
} else {
$sql1 = "SELECT COUNT(id) FROM shows WHERE nombre = '".$nombre."'";
$n = query_count($sql1);
if ($n>0) {
$error = true;
$msg = 'Ya has indexeado este titulo';
}
}
if (!$error) {
$db->query("INSERT INTO shows(nombre,nombre2,tipo,ano,duracion,reparto,director,guion,productora,descripcion,estado,fechaadd,uploader,puntaje) VALUES ('".$nombre."','".$nombre2."','".$tipo."','".$anio."','".$duracion."','".$reparto."','".$director."','".$guion."','".$productora."','".$descripcion."','".$estado."','".time()."','".$userid."','0')",true);
$lid = mysql_insert_id();
$db->query("INSERT INTO shows_generos (show_id,genero) VALUES ('".$lid."','".$genero."')",true);
$db->query("INSERT INTO shows_idiomas (show_id,idioma) VALUES ('".$lid."','".$idioma."')",true);
// Comprobar imagen, local o remota
if (is_uploaded_file($_FILES["imagen"]["tmp_name"])) {
$file_name = $_FILES['imagen']['name'];
$file_size = $_FILES['imagen']['size'];
$tipo = strtolower(strrchr($file_name,"."));
if($file_size > "524288"){ //Pesa mas de 0.5mb =>512kb => 524288 bytes
$error= true;
$msg = "La <strong>imagen</strong> que intentas subir es demasiado pesado.";
}
$upload_local = "1";
}else if($_POST['imagen2'] != "" && file_get_contents($_POST['imagen2'],0,null,0,1)){
$file_name = basename($_POST['imagen2']);
$file_size = strlen(file_get_contents($_POST['imagen2']));
$tipo = strtolower(strrchr($file_name,"."));
if($file_size > "524288"){ //Pesa mas de 0.5mb =>512kb => 524288 bytes
$error= true;
$msg = "La <strong>imagen</strong> que intentas subir es demasiado pesado.";
}
$upload_remote = "1";
};
//Subir Imagen
$dir = "../box/";
$dir = $dir.$lid."$tipo";
$valid_file_extensions = array(".jpg", ".jpeg", ".gif", ".png");
if(in_array($tipo, $valid_file_extensions) && $upload_local == "1" && move_uploaded_file($_FILES['imagen']['tmp_name'],$dir)){$upload_status = "1";
}else if(in_array($tipo, $valid_file_extensions) && $upload_remote == "1" && file_put_contents($dir, file_get_contents($_POST['imagen2']))){$upload_status = "1";};
if($upload_status == "1"){
$file_nuevo = "../box/".$lid."$tipo";
$resizeObj = new uploadcn($file_nuevo);
$ancho = 120;$alto = 160;$calidad = 80;
$resizeObj->cambiar_tam($ancho, $alto, 'exacto');
$resizeObj->guardar_img($file_nuevo, $calidad);
}else if($upload_remote != "1" || $upload_local != "1"){}else{
$error= true;$msg = "Error al subir imagen.";
}
$error= true;$msg = "¡Show editado correctamente!";
}
}
?>
<?php if(!empty($msg)) { ?>
<p><?php echo $msg; ?></p>
<?php } ?>
<strong>FilmAffinity URL/ID</strong> <input name="fadata" type="text" class="inputlogin2" id="fadata" size="35"><input name="obtener" type="button" onclick="getData()" class="boton1 margin_l10" id="obtener" value="Obtener" />
<br /><br />
<form action="" method="post" enctype="multipart/form-data">
<table width="1075" height="28">
<tr>
<td width="96"><div align="right">Titulo original</div></td>
<td width="967"><input name="nombre" type="text" class="inputlogin2" id="nombre" size="35"></td>
</tr>
<tr>
<td><div align="right">Titulo (Español)</div></td>
<td><input name="nombre2" type="text" class="inputlogin2" id="nombre2" size="35"></td>
</tr>
<tr>
<td><div align="right">Tipo</div></td>
<td><select name="tipo" class="inputlogin2" onChange="updateN(this)" id="tipo">
<option value="pelicula" selected>Pelicula</option>
<option value="serie">Serie</option>
</select></td>
</tr>
<tr>
<td><div align="right">Genero</div></td>
<td id="tdgenero"><select name="genero" class="inputlogin2" id="genero">
<?php
$generos = $db->query("SELECT * FROM generos",true)
or die(mysql_error());
while($row = mysql_fetch_array($generos)){?>
<option value="<?php echo $row['id'];?>"><?php echo $row['nombre'];?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td><div align="right">Idioma</div></td>
<td id="tdidioma"><select name="idioma" class="inputlogin2" id="idioma">
<?php
$idiomas = $db->query("SELECT * FROM idiomas",true)
or die(mysql_error());
while($row = mysql_fetch_array($idiomas)){?>
<option value="<?php echo $row['id'];?>"><?php echo $row['nombre'];?></option>
<?php } ?>
</select></td>
</tr>
<tr>
<td><div align="right">Año</div></td>
<td><input name="anio" type="text" class="inputlogin2" id="anio" size="4" maxlength="4"></td>
</tr>
<tr>
<td><div align="right">Reparto</div></td>
<td><input name="reparto" type="text" class="inputlogin2" id="reparto" size="35"></td>
</tr>
<tr>
<td><div align="right">Director</div></td>
<td><input name="director" type="text" class="inputlogin2" id="director" size="35"></td>
</tr>
<tr>
<td><div align="right">Guion</div></td>
<td><input name="guion" type="text" class="inputlogin2" id="guion" size="35"></td>
</tr>
<tr>
<td><div align="right">Productora</div></td>
<td><input name="productora" type="text" class="inputlogin2" id="productora" size="35"></td>
</tr>
<tr>
<td><div align="right">Duracion</div></td>
<td><input name="duracion" type="text" class="inputlogin2" id="duracion" size="3"> min</td>
</tr>
<tr>
<td><div align="right">Descripcion<br/>(Sinopsis)</div></td>
<td><textarea name="descripcion" class="textarea" id="descripcion"></textarea></td>
</tr>
<tr>
<td><div align="right">Subir imagen</div></td>
<td><input class="inputlogin2" name="imagen" type="file" id="imagen" /> o URL <input name="imagen2" type="text" class="inputlogin2" id="imagen2"></td>
</tr>
<tr>
<td><div align="right">Estado upload (opcional)</div></td>
<td><select name="estado" class="inputlogin2" id="estado">
<option value="bajando">Bajando</option>
<option value="conviritiendo">Conviritiendo</option>
<option value="subiendo">Subiendo</option>
<option value="subido" selected>Subido</option>
</select></td>
</tr>
<tr id="fuentes" style="display:show">
<td><div align="right">Stream #1</div></td>
<td><input name="megaid[]" type="text" id="megaid" class="inputlogin2" placeholder="File ID" />
<select name="def[]" id="def" class="inputlogin2">
<option value="360">360p (SD)</option>
<option value="480">480p (SD)</option>
<option value="720">720p (HD)</option>
<option value="1080">1080p (HD)</option>
</select> <select name="lang[]" class="inputlogin2" id="lang">
<?php
$idioma = $db->query("SELECT * FROM idiomas",true)
or die(mysql_error());
while($row = mysql_fetch_array($idioma)){?>
<option value="<?php echo $row['id'];?>"><?php echo $row['nombre'];?></option>
<?php } ?>
</select> <select name="host[]" id="host" class="inputlogin2">
<?php
$fuentes = $db->query("SELECT * FROM fuentes_hosts WHERE seccion <> 'download' AND (rango <> '0' AND rango <> '".$perms."') ORDER BY orden ASC",true)
or die(mysql_error());
while($row = mysql_fetch_array($fuentes)){?>
<option value="<?php echo $row['id'];?>"><?php echo ucfirst($row['host']);?></option>
<?php } ?>
</select> <select name="hidden[]" id="hidden" class="inputlogin2">
<option value="0" selected="selected">Visible</option>
<option value="1">Oculto</option>
</select></td>
</tr>
<tr>
<td></td>
<td><input class="boton1 margin_l10" id="masfuentes" type="button" value="Agregar otra fuente" /></td>
</tr>
<tr id="fuentes_d" style="display:show">
<td><div align="right">Descarga #1</div></td>
<td><select name="def_d[]" id="def" class="inputlogin2" >
<option value="360">360p (SD)</option>
<option value="480">480p (SD)</option>
<option value="720">720p (HD)</option>
<option value="1080">1080p (HD)</option>
</select><select name="calidad_d[]" id="calidad" class="inputlogin2">
<option value="1">TVRip</option>
<option value="2">SATRip</option>
<option value="3">DVDRip</option>
<option value="4">DVD5</option>
<option value="5">DVD9</option>
<option value="6">HDRip</option>
<option value="7">WEB-DL</option>
<option value="8">HDTV</option>
<option value="9">mHD</option>
<option value="10">BDRip</option>
<option value="11">BDRemux</option>
<option value="12">Blu-Ray</option>
</select>
<select name="lang_d[]" class="inputlogin2" id="lang">
<?php
$idioma = $db->query("SELECT * FROM idiomas",true)
or die(mysql_error());
while($row = mysql_fetch_array($idioma)){?>
<option value="<?php echo $row['id'];?>"><?php echo $row['nombre'];?></option>
<?php } ?>
</select>
<select name="host_d[]" id="host" class="inputlogin2" >
<?php
$fuentes = $db->query("SELECT * FROM fuentes_hosts WHERE seccion <> 'stream' AND (rango <> '0' AND rango <> '".$perms."') ORDER BY orden ASC",true)
or die(mysql_error());
while($row = mysql_fetch_array($fuentes)){?>
<option value="<?php echo $row['id'];?>"><?php echo ucfirst($row['host']);?></option>
<?php } ?>
</select>
<select name="hidden_d[]" id="hidden" class="inputlogin2" >
<option value="0" selected="selected">Visible</option>
<option value="1">Oculto</option>
</select><br />
<textarea name="nfo_d[]" class="inputlogin2" style="float:left;width: 320px;" id="megaid" cols="35" rows="6" placeholder="Links de descarga sin http"></textarea>
<textarea name="megaid_d[]" class="inputlogin2" id="nfo" cols="35" rows="2" placeholder="Subido por:"></textarea><br />
<textarea rows="2" cols="35" id="capturas" class="inputlogin2" name="capturas_d[]" placeholder="Capturas"></textarea>
</td>
</tr>
<tr>
<td></td>
<td><input class="boton1 margin_l10" id="masfuentes_d" type="button" value="Agregar otra fuente" /></td>
</tr>
<tr id="trailers" style="display:show">
<td><div align="right">Trailer #1</div></td>
<td><input name="yid[]" type="text" class="inputlogin2" id="yid" size="15" placeholder="YouTube ID"> Nombre <input name="trailer[]" type="text" class="inputlogin2" id="trailer" size="35"></td>
</tr>
<tr>
<td></td>
<td><input class="boton1 margin_l10" id="mastrailers" type="button" value="Agregar otro trailer" /></td>
</tr>
<tr>
<td><input name="insertar" type="submit" class="boton1 margin_l10" id="insertar" value="Agregar" /></td>
<td></td>
</tr>
</table>
</form>
<script type="text/javascript">
function getData(){
var url = $("#fadata").val();
$.get( "funciones/getData.php", { url: url }, function( data ) {
fa = JSON.parse(data);
$("#nombre").val(fa.titulo);
$("#nombre2").val(fa.titulo_es);
$("#anio").val(fa.ano);
$("#reparto").val(fa.reparto);
$("#director").val(fa.director);
$("#guion").val(fa.guion);
$("#productora").val(fa.productora);
$("#duracion").val(fa.duracion);
$("#descripcion").val(fa.sinopsis);
$("#imagen2").val(fa.poster);
$("#tdgenero").append("<span>("+fa.genero+")</span>");
$("#tdidioma").append("<span>("+fa.pais+")</span>");
})
}
function updateN(t) {
if (t.value=='serie') {
$('#fuentes').hide();
$('#fuentes_d').hide()
$('#trailers').hide();
} else {
$('#fuentes').show();
$('#fuentes_d').show();
$('#trailers').show();
}
$.updateShowPop()
}
jQuery.fn.agregarmasfuentes = function(etiqueta, indice){
$(this).each(function(){
elem = $(this);
elem.data("etiqueta",etiqueta);
elem.data("indice",indice);
elem.click(function(e){
e.preventDefault();
elem = $(this);
etiqueta = elem.data("etiqueta");
nombreCampo = elem.data("nombreCampo");
indice = elem.data("indice");
texto_insertar = '<tr id="fuentes" style="display:show"><td><div align="right">' + etiqueta +' #' + indice +'</div></td><td><input name="megaid[]" type="text" id="megaid" class="inputlogin2" /><select name="def[]" id="def" class="inputlogin2"><option value="360">360p (SD)</option><option value="480">480p (SD)</option><option value="720">720p (HD)</option><option value="1080">1080p (HD)</option></select><select name="lang[]" id="lang" class="inputlogin2"><?php $idioma = $db->query("SELECT * FROM idiomas",true)or die(mysql_error());while($row = mysql_fetch_array($idioma)){?><option value="<?php echo $row["id"];?>"><?php echo $row["nombre"];?></option><?php } ?></select><select name="host[]" id="host" class="inputlogin2"><?php $fuentes = $db->query("SELECT * FROM fuentes_hosts ORDER BY orden ASC",true) or die(mysql_error());while($row = mysql_fetch_array($fuentes)){?><option value="<?php echo $row['id'];?>"><?php echo ucfirst($row['host']);?></option><?php } ?></select><select name="hidden[]" id="hidden" class="inputlogin2"><option value="0" selected="selected">Visible</option><option value="1">Oculto</option></select></td></tr>';
indice ++;
elem.data("indice",indice);
nuevo_campo = $(texto_insertar);
elem.before(nuevo_campo);
});
});
return this;
}
jQuery.fn.agregarmasfuentes_d = function(etiqueta, indice){
$(this).each(function(){
elem = $(this);
elem.data("etiqueta",etiqueta);
elem.data("indice",indice);
elem.click(function(e){
e.preventDefault();
elem = $(this);
etiqueta = elem.data("etiqueta");
nombreCampo = elem.data("nombreCampo");
indice = elem.data("indice");
texto_insertar = '<tr id="fuentes_d" style="display:show"><td><div align="right">' + etiqueta +' #' + indice +'</div></td><td><select name="def_d[]" id="def" class="inputlogin2"><option value="360">360p (SD)</option><option value="480">480p (SD)</option><option value="720">720p (HD)</option><option value="1080">1080p (HD)</option></select><select name="calidad_d[]" id="calidad" class="inputlogin2"><option value="1">TVRip</option><option value="2">SATRip</option><option value="3">DVDRip</option><option value="4">HDRip</option><option value="5">WEB-DL</option><option value="6">HDTV</option><option value="7">mHD</option><option value="8">BDRip</option><option value="9">BDRemux</option><option value="10">Blu-Ray</option></select><select name="lang_d[]" id="lang" class="inputlogin2"><?php $idioma = $db->query("SELECT * FROM idiomas",true)or die(mysql_error());while($row = mysql_fetch_array($idioma)){?><option value="<?php echo $row["id"];?>"><?php echo $row["nombre"];?></option><?php } ?></select><select name="host_d[]" id="host" class="inputlogin2"><?php $fuentes = $db->query("SELECT * FROM fuentes_hosts ORDER BY orden ASC",true) or die(mysql_error());while($row = mysql_fetch_array($fuentes)){?><option value="<?php echo $row['id'];?>"><?php echo ucfirst($row['host']);?></option><?php } ?></select><select name="hidden_d[]" id="hidden" class="inputlogin2"><option value="0" selected="selected">Visible</option><option value="1">Oculto</option></select><br /><textarea name="megaid_d[]" class="inputlogin2" style="float:left;width: 320px;" id="megaid" cols="35" rows="6" placeholder="Links de descarga"></textarea><textarea name="nfo_d[]" class="inputlogin2" id="nfo" cols="35" rows="2" placeholder="Información (NFO)"></textarea><br /><textarea rows="2" cols="35" id="capturas" class="inputlogin2" name="capturas_d[]" placeholder="Capturas"></textarea></td></tr>';
indice ++;
elem.data("indice",indice);
nuevo_campo = $(texto_insertar);
elem.before(nuevo_campo);
});
});
return this;
}
$(document).ready(function(){
$("#masfuentes").agregarmasfuentes("Stream", 2);
$("#masfuentes_d").agregarmasfuentes_d("Descarga", 2);
});
jQuery.fn.agregarmastrailers = function(etiqueta, indice){
$(this).each(function(){
elem = $(this);
elem.data("etiqueta",etiqueta);
elem.data("indice",indice);
elem.click(function(e){
e.preventDefault();
elem = $(this);
etiqueta = elem.data("etiqueta");
nombreCampo = elem.data("nombreCampo");
indice = elem.data("indice");
texto_insertar = '<tr id="trailers" style="display:show"><td><div align="right">' + etiqueta +' #' + indice +'</div></td><td><input name="yid[]" type="text" class="inputlogin2" id="yid" size="20"> Nombre <input name="trailer[]" type="text" class="inputlogin2" id="trailer" size="35"></td></tr>';
indice ++;
elem.data("indice",indice);
nuevo_campo = $(texto_insertar);
elem.before(nuevo_campo);
});
});
return this;
}
$(document).ready(function(){
$("#mastrailers").agregarmastrailers("Trailer", 2);
});
</script>
</div>