GasteizkoMargolariak
/
GMWeb


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184
							<?php
	$http_host = $_SERVER['HTTP_HOST'];
	$default_host = substr($http_host, 0, strpos($http_host, ':'));
	include("../../functions.php");
	$con = startdb();
	if (!checkSession($con)){
		header("Location: /index.php");
		exit (-1);
	}
	else{
		$id = mysqli_real_escape_string($con, $_GET['p']);
		$q = mysqli_query($con, "SELECT * FROM post WHERE id = $id;");
		if (mysqli_num_rows($q) == 0){
			header("Location: /blog/");
			exit (-1);
		}
		else{
			$r = mysqli_fetch_array($q);
			$title_es = $r["title_es"];
			$title_eu = $r["title_eu"];
			if ($title_eu == $title_es)
				$title_eu = "";
			$title_en = $r["title_en"];
			if ($title_en == $title_es)
				$title_en = "";
			$text_es = $r["text_es"];
			$text_eu = $r["text_eu"];
			if ($text_eu == $text_es)
				$text_eu = "";
			$text_en = $r["text_en"];
			if ($text_en == $text_es)
				$text_en = "";
			$visible = $r["visible"];
			$comments = $r["comments"];
?>

<html>
	<head>
		<meta content="text/html; charset=windows-1252" http-equiv="content-type"/>
		<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, minimum-scale=1">
		<title>Editar post - Administracion</title>
		<!-- CSS files -->
		<link rel="stylesheet" type="text/css" href="/css/ui.css"/>
		<link rel="stylesheet" type="text/css" href="/css/blog.css"/>
		<!-- Script files -->
		<script type="text/javascript" src="script.js"></script>
		<!-- CSS for mobile version -->
		<link rel="stylesheet" type="text/css" media="(max-width : 990px)" href="/css/m/ui.css"/>
		<link rel="stylesheet" type="text/css" media="(max-width : 990px)" href="/css/m/blog.css"/>
		<!-- Script files -->
		<script type="text/javascript" src="script.js"></script>
		<script type="text/javascript" src="/script/ui.js"></script>
		<script src="../../ckeditor/ckeditor.js"></script>
	</head>
	<body>
		<?php include('../../toolbar.php'); ?>
		<div id='content'>
			<div class="section">
				<h3>Editar post</h3>
				<form action="edit.php" maxlength="120" method="post" enctype="multipart/form-data" onsubmit="return validate_post();">
					<?php
						echo "<input type='hidden' name='id' value='$id'/>\n";
					?>
					<div class="entry blog_add_language">
						<h4>Castellano (obligatorio)</h4>
						<input type="text" id="title_es" name="title_es" placeholder="Titulo" value="<?php echo $title_es;?>"/><br/><br/>
						<textarea name="text_es" id="text_es" placeholder="Texto"><?php echo $text_es;?></textarea>
						<script>
							CKEDITOR.replace('text_es');
						</script>
					</div>
					<div class="entry blog_add_language">
						<h4>Euskera (opcional)</h4>
						<input type="text" name="title_eu" id="title_eu" placeholder="Titulo" value="<?php echo $title_eu;?>"/><br/><br/>
						<textarea name="text_eu" id="text_eu" placeholder="Texto"><?php echo $text_eu;?></textarea>
						<script>
							CKEDITOR.replace('text_eu');
						</script>
					</div>
					<div class="entry blog_add_language">
						<h4>Ingles (opcional)</h4>
						<input type="text" name="title_en" id="title_en" placeholder="Titulo" value="<?php echo $title_en;?>"/><br><br/>
						<textarea name="text_en" id="text_en" placeholder="Texto"><?php echo $text_en;?></textarea>
						<script>
							CKEDITOR.replace('text_es');
						</script>
					</div>
					<div class="entry" id="images">
						<h4>Imagenes</h4>
						<ul>
							<li>
								Principal (Aparecera sobre el texto y en las previsualizaciones)<br/>
								<div class="image_upload_container">
									<?php
										$q_img = mysqli_query($con, "SELECT image FROM post_image WHERE post = $id AND idx = 0");
										if (mysqli_num_rows($q_img) == 0){
											echo "<img class='image_upload_preview' id='image_preview_0' src='/img/misc/alpha.png'/>\n";
											echo "<input type='button' style='diplay:none;' onClick='delete_image(0, image_preview_0, this);' value='Eliminar'";
										}
										else{
											$r_img = mysqli_fetch_array($q_img);
											echo "<img class='image_upload_preview' style='display:block;' id='image_preview_0' src='http://$default_host/img/blog/miniature/$r_img[image]'/>\n";
											echo "<input type='button' style='diplay:block;' onClick='delete_image(0, image_preview_0, this);' value='Eliminar'";
										}
									?>
									<br/><br/>
									<input type="hidden" name="delete_image_0" id="delete_image_0" value="no"/>
									<input id="image_0" onchange="preview_image(0, this, image_preview_0);" type="file" name="image_0" accept="image/x-png, image/gif, image/jpeg"/>
								</div>
							</li>
							<li>
								Secundarias (Bajo el texto)<br/>
								<div class="image_upload_container">
									<?php
										$q_img = mysqli_query($con, "SELECT image FROM post_image WHERE post = $id AND idx = 1");
										if (mysqli_num_rows($q_img) == 0){
											echo "<img class='image_upload_preview' id='image_preview_1' src='/img/misc/alpha.png'/>\n";
											echo "<input type='button' style='diplay:none;' onClick='delete_image(1, image_preview_1, this);' value='Eliminar'";
										}
										else{
											$r_img = mysqli_fetch_array($q_img);
											echo "<img class='image_upload_preview' style='display:block;' id='image_preview_1' src='http://$default_host/img/blog/miniature/$r_img[image]'/>\n";
											echo "<input type='button' style='diplay:block;' onClick='delete_image(1, image_preview_1, this);' value='Eliminar'";
										}
									?>
									<br/><br/>
									<input type="hidden" name="delete_image_1" id="delete_image_1" value="no"/>
									<input id="image_1" onchange="preview_image(1, this, image_preview_1);" type="file" name="image_1" accept="image/x-png, image/gif, image/jpeg"/>
								</div>
								<div class="image_upload_container">
									<?php
										$q_img = mysqli_query($con, "SELECT image FROM post_image WHERE post = $id AND idx = 2");
										if (mysqli_num_rows($q_img) == 0){
											echo "<img class='image_upload_preview' id='image_preview_2' src='/img/misc/alpha.png'/>\n";
											echo "<input type='button' style='diplay:none;' onClick='delete_image(2, image_preview_2, this);' value='Eliminar'";
										}
										else{
											$r_img = mysqli_fetch_array($q_img);
											echo "<img class='image_upload_preview' style='display:block;' id='image_preview_2' src='http://$default_host/img/blog/miniature/$r_img[image]'/>\n";
											echo "<input type='button' style='diplay:block;' onClick='delete_image(2, image_preview_2, this);' value='Eliminar'";
										}
									?>
									<br/><br/>
									<input type="hidden" name="delete_image_2" id="delete_image_2" value="no"/>
									<input id="image_2" onchange="preview_image(2, this, image_preview_0);" type="file" name="image_2" accept="image/x-png, image/gif, image/jpeg"/>
								</div>
								<div class="image_upload_container">
									<?php
										$q_img = mysqli_query($con, "SELECT image FROM post_image WHERE post = $id AND idx = 3");
										if (mysqli_num_rows($q_img) == 0){
											echo "<img class='image_upload_preview' id='image_preview_3' src='/img/misc/alpha.png'/>\n";
											echo "<input type='button' style='diplay:none;' onClick='delete_image(3, image_preview_3, this);' value='Eliminar'";
										}
										else{
											$r_img = mysqli_fetch_array($q_img);
											echo "<img class='image_upload_preview' style='display:block;' id='image_preview_3' src='http://$default_host/img/blog/miniature/$r_img[image]'/>\n";
											echo "<input type='button' style='diplay:block;' onClick='delete_image(3, image_preview_3, this);' value='Eliminar'";
										}
									?>
									<br/><br/>
									<input type="hidden" name="delete_image_3" id="delete_image_3" value="no"/>
									<input id="image_3" onchange="preview_image(3, this, image_preview_0);" type="file" name="image_3" accept="image/x-png, image/gif, image/jpeg"/>
								</div>
							</li>
						</ul>
					</div>
					<div class="entry" id="settings">
						<h4>Ajustes</h4>
						<label><input type="checkbox" name="visible" <?php if ($r['visible'] == 1) echo 'checked'; ?>/>Post visible</label><br/><br/>
						<label><input type="checkbox" name="comments" <?php if ($r['comments'] == 1) echo 'checked'; ?>/>Permitir comentarios</label><br/><br/>
						<br/><br/><br/><br/>
						<input type="button" value="Previsualizar" onClick="alert(validate_post());"/> <!--TODO-->
						<input type="submit" value="Publicar"/>
					</div>
				</form>
			</div>
		</div>
	</body>
</html>

<?php
		}
	}
?>