GasteizkoMargolariak
/
GMWeb


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201
							<?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 class="section_title">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">
                        <div id="lang_tabs">
                            <table>
                                <tr>
                                    <td class="pointer lang_tabs_active" id="lang_tab_es" onclick="showLanguage('es');">
                                        Castellano
                                    </td>
                                    <td class="pointer" id="lang_tab_eu" onclick="showLanguage('eu');">
                                        Euskera
                                    </td>
                                    <td class="pointer" id="lang_tab_en" onclick="showLanguage('en');">
                                        Ingl&eacute;s
                                    </td>
                                </tr>
                            </table>
                        </div>
                        <div id="content_lang_es" class="blog_add_language">
                            <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 id="content_lang_eu" class="blog_add_language" style="display:none;">
                            <input type="text" name="title_eu" id="title_eu" placeholder="Titulu" value="<?php echo $title_eu;?>"/><br/><br/>
                            <textarea name="text_eu" id="text_eu" placeholder="Textua"><?php echo $text_eu;?></textarea>
                            <script>
                                CKEDITOR.replace('text_eu');
                            </script>
                        </div>
                        <div id="content_lang_en" class="blog_add_language" style="display:none;">
                            <input type="text" name="title_en" id="title_en" placeholder="Title" value="<?php echo $title_en;?>"/><br><br/>
                            <textarea name="text_en" id="text_en" placeholder="Content"><?php echo $text_en;?></textarea>
                            <script>
                                CKEDITOR.replace('text_es');
                            </script>
                        </div>
                    </div> <!--Entry-->
                    <div class="entry" id="images">
                        <h4>Im&aacute;genes</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='display: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='display: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='display: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='display: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='display: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='display: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='display: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='display: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/>
                        <div id="add_button_container">
                            <input type="button" value="Previsualizar" onClick="alert(validate_post());"/> <!--TODO-->
                            <br/>
                            <input type="submit" value="Publicar"/>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </body>
</html>

<?php
        }
    }
?>