<?php

    if(file_exists('handler/stay.php') == TRUE) {

        require('handler/stay.php');

        }else{

        echo '<p class="red_span" align="center">Error - Fehler</p>';
        exit;
        }

?>

<?php define('INCLUDE_CHECK',1); define('MYSQL_CHECK',1); ?>

<?php require('../framework/config.php'); ?>
<?php require('../framework/mysql.php'); ?>
<?php require('../framework/constants.php'); ?>
<?php require('../framework/class/cache_class.php'); no_cache(); ?>
<?php require('../framework/security.php'); ?>
<?php require('handler/language.php'); ?>

<?php require('structure/header.inc.php'); ?>

    <div class="menu">
        <div class="menu_left">
            <ul id="admin_navi">
                <li><a href="index.php"><?php echo $lang['blank_admin_area']; ?></a></li>
                <li><a href="members.php"><?php echo $lang['admin_members']; ?></a></li>
                <li><a href="discussions.php"><?php echo $lang['discussions']; ?></a></li>
                <li class="active"><a href="topics.php"><?php echo $lang['blank_topics']; ?></a></li>
                <li><a href="news.php"><?php echo $lang['news']; ?></a></li>
                <li><a href="events.php"><?php echo $lang['events']; ?></a></li>
                <li><a href="newsletter.php"><?php echo $lang['newsletter']; ?></a></li>
                <li><a href="statistic.php"><?php echo $lang['statistic']; ?></a></li>
            </ul>
        </div>
        <div class="menu_right">
            <?php

            if(isset($_SESSION['admin']) && $_SESSION['admin'] == TRUE) {

            echo '<div class="admin_settings">
            <a class="admin_account"><span>' . $lang['blank_navigation'] . '</span></a>
            <div class="admin_submenu" style="display: none;">
                <ul class="root">
                    <li><a href="' . $url . '" target="_blank">' . $lang['goto_network'] . '</a></li>
                    <li><a href="signout.php">' . $lang['signout'] . '</a></li>
                </ul>
            </div>
            </div>';
            }

            ?>
        </div>
    </div>
</div>

<div class="clear"></div>

<div id="content_wrapper">
    <div class="content">

    <?php

        echo '<h1 class="p_space">' . $lang['blank_topics'] . '</h1>';

        $count = mysql_query("SELECT id FROM topics");
        include('../framework/pagination.php');

        $query = "SELECT
                      topics.id AS topID,
                      topics.subject,
                      topics.views,
                      topics.date AS topDate,
                      topics.author,
                      members.id AS memID,
				      members.name
                  FROM
                      topics
			      LEFT JOIN
				      members
			      ON
				      topics.author = members.id
                  ORDER BY
                      topDate DESC
                  LIMIT
                      $start,$entries";

        $result = mysql_query($query) OR die(mysql_error());

        if($result) {

        echo '<table width="100%" class="tables">
        <tr>
        <td width="5%"><strong>ID</strong></td>
        <td width="45%"><strong>' . $lang['subject'] . '</strong></td>
        <td width="20%"><strong>' . $lang['date'] . '</strong></td>
        <td width="20%"><strong>' . $lang['member_id'] . '</strong></td>
        <td width="10%" align="center"><strong>' . $lang['admin_delete'] . '</strong></td>
        </tr>';

        while($row = mysql_fetch_assoc($result)) {

            echo '<tr>
            <td width="5%">' . (int)$row['topID'] . '</td>
            <td width="45%">' . htmlentities($row['subject'], ENT_QUOTES) . '</td>
            <td width="20%">' . date('d.m.Y - H:i', strtotime($row['topDate'])) . '</td>
            <td width="20%">' . htmlentities($row['name'], ENT_QUOTES) . '</td>
            <td width="10%" align="center"><a href="remove.php?id=' . (int)$row['topID'] . '"><img src="../style/icons/delete.png" alt="' . $lang['admin_delete'] . '" title="' . $lang['admin_delete'] . '" border="0"></a></td>
            </tr>';
            }

        echo '</table>
        <div class="clear_long"></div>';

        }else{

        echo '<p class="false">' . $lang['empty_topics'] . '</p>';
        }

        echo '<div id="pagi">
        <span class="pages">' . $lang['admin_page'] . ' ' . $page . ' ' . $lang['admin_by'] . ' ' . $allsites . '</span>';
        echo $link_string;
        echo '</div>';

        echo '<div class="clear"></div>';

    ?>

<?php require('structure/footer.inc.php'); ?>