GasteizkoMargolariak
/
GMWeb


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185
							<?php
    include("../functions.php");
    $http_host = $_SERVER["HTTP_HOST"];
    $proto = getProtocol();
    $default_host = substr($http_host, 0, strpos($http_host, ":"));
    $server = "$proto$http_host";
    $default_server = "$proto$default_host";
    $con = startdb();
    if (!checkSession($con)){
        header("Location: /index.php");
        exit (-1);
    }
    else{
?>
<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>Actividades - Administracion</title>
        <!-- CSS files -->
        <link rel='stylesheet' type='text/css' href='/css/ui.css'/>
        <link rel='stylesheet' type='text/css' href='/css/actividades.css'/>
        <!-- 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/activiadades.css'/>
        <!-- Script files -->
        <script type='text/javascript' src='/script/ui.js'></script>
    </head>
    <body>
<?php
        include("../toolbar.php");
?>
        <div id='content'>
            <div class='section'>
                <h3 class='section_title'>Actividades - <a href='/actividades/add/'>Anadir nueva</a></h3>
                <div class='entry'>
                    <table id='activity_list'>
                        <tr>
                            <th>Titulo / Fecha</th>
                            <th>Texto</th>
                            <th>Detalles</th>
                            <th>Traducciones</th>
                            <th>Accion</th>
                        </tr>
<?php
                        $q = mysqli_query($con, "SELECT id, DATE_FORMAT(date, '%b %d, %Y') AS dat, title_es, title_eu, title_en, text_es, text_eu, text_en, user, visible, comments, DATE_FORMAT(dtime, '%b %d, %Y %H:%i:%s') AS ptime FROM activity ORDER BY date DESC;");
                        while ($r = mysqli_fetch_array($q)){
?>
                            <tr>
                                <td class='activity_column_title'>
                                    <?=cutText($r['title_es'], 35, '', '')?>
                                    <br/><?=$r["dat"]?>
                                </td>
                                <td class='activity_column_text'><?=str_replace('<br/>', ' ', cutText($r["text_es"], 60, "", ""))?>
<?php
                                    //Images
                                    $q_image = mysqli_query($con, "SELECT image FROM activity_image WHERE activity = $r[id] ORDER BY idx;");
                                    if (mysqli_num_rows($q_image) > 0){
?>
                                        <br/>
<?php
                                        while ($r_image = mysqli_fetch_array($q_image)){
?>
                                            <img src='<?=$default_server?>/img/actividades/miniature/<?=$r_image["image"]?>'\>
<?php
                                        }
                                    }

                                    //Itinerary
                                    $q_itinerary = mysqli_query($con, "SELECT count(id) AS count FROM activity_itinerary WHERE activity = $r[id]");
                                    $r_itinerary = mysqli_fetch_array($q_itinerary);
                                    if ($r_itinerary["count"] == 0){
?>
                                        <ul>
                                            <li>Sin itinerario.</li>
                                        </ul>
<?php
                                    }
                                    elseif ($r_itinerary["count"] == 1){
?>
                                        <ul>
                                            <li>1 entrada de itinerario.</li>
                                        </ul>
<?php
                                    }
                                    else{
?>
                                        <ul>
                                            <li><?=$r_itinerary["count"]?> entradas de itinerario.</li>
                                        </ul>
<?php
                                    }
?>
                                </td>
<?php
                                $q_user = mysqli_query($con, "SELECT username FROM user WHERE id = $r[user];");
                                $r_user = mysqli_fetch_array($q_user);
?>
                                <td class='activity_column_details'>
                                    <?=$r["ptime"]?>
                                    <br/>
                                    Por <?=$r_user["username"]?>
                                    <br/>
                                    Comentarios:
<?php
                                    if ($r["comments"] == 1){
                                        $q_comments = mysqli_query($con, "SELECT id FROM activity_comment WHERE activity = $r[id];");
?>
                                        S&iacute; (<?=mysqli_num_rows($q_comments)?>)
<?php
                                    }
                                    else{
?>
                                        No
<?php
                                    }
?>
                                    <br/>
                                    Visible:
<?php
                                    if ($r["visible"] == 1){
?>
                                        S&iacute;
<?php                               }
                                    else{
?>
                                        No
<?php
                                    }
?>
                                </td>
                                <td class='activity_column_translations'>
                                    Euskera:
<?php
                                    if (strlen($r["text_eu"]) == 0 || $r["text_eu"] == $r["text_es"]){
?>
                                        No
<?php
                                    }
                                    else{
?>
                                        S&iacute;
<?php
                                    }
?>
                                    <br/>
                                    Ingl&eacute;s:
<?php
                                    if (strlen($r["text_en"]) == 0 || $r["text_en"] == $r["text_es"]){
?>
                                        No
<?php
                                    }
                                    else{
?>
                                        S&iacute;
<?php
                                    }
?>
                                </td>
                                <td class='activity_column_action'>
                                    <form method='get' action='/actividades/edit.php'>
                                        <input type='hidden' name='id' value='<?=$r["id"]?>'/>
                                        <input type='submit' value='Editar / Traducir'/>
                                    </form>
                                    <input type='button' onClick='delete_activity(<?=$r["id"]?>, "<?=$r["title_es"]?>");' value='Borrar'/>
                                    <!-- TODO: Uncomment when activity comments are implemented.
                                    <form action='/actividades/moderate/moderate.php?p<?=$r["id"]?>'>
                                        <input type='submit' value='Moderar comentarios'/>
                                    </form>
                                    -->
                                </td>
                            </tr>
<?php
                        }
?>
                    </table>
                </div>
            </div>
        </div>
    </body>
</html>
<?php
    }
?>