Пример #1
0
                 $req2 = $db2->prepare($sql);
                 $req2->execute();
                 Header(sprintf('Location: ./forum_thread.php?id=%d', $_GET['th']));
             }
         } else {
             unset($_SESSION['user']);
             header('Location: ./index.php');
         }
     } else {
         header('Location: ./index.php');
     }
 } else {
     if ($from == "remove_thread") {
         if (isset($_SESSION['user'])) {
             if ($dev->isConnected($_SESSION['user']['username'], $_SESSION['user']['password'], $_SESSION['user']['session_id'])) {
                 if ($dev->getAdminLevel($dev->getID($_SESSION['user']['username'])) >= 6 || $dev->getThreadByIDv2($_GET['id'])['uuid_author'] == $dev->getID($_SESSION['user']['username'])) {
                     $forum = $dev->getThreadByIDv2($_GET['id'])['forum_id'];
                     $sql = "DELETE FROM `web_messages` WHERE `thread_id` = " . $_GET['id'] . ";";
                     $sql2 = "DELETE FROM `web_threads` WHERE `id` = " . $_GET['id'] . ";";
                     $db2 = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password);
                     $req2 = $db2->prepare($sql . $sql2);
                     $req2->execute();
                     //var_dump($req2->errorInfo());
                     Header(sprintf('Location: ./forum.php?id=%d', $forum));
                 }
             } else {
                 unset($_SESSION['user']);
                 header('Location: ./index.php');
             }
         } else {
             header('Location: ./index.php');
Пример #2
0
          <span id="arrow"><span></span></span>
        </span>
        <span id="crumbs">
          <a href="./forum.php?id=<?php 
echo $dev->getForumByThreadID($_GET['id']);
?>
" id="link"><?php 
echo $dev->getForumName($dev->getForumByThreadID($_GET['id']));
?>
</a>
          <span id="arrow"><span></span></span>
        </span>
      </div>
      <?php 
echo '<div style="font-size: 18pt; color: rgb(44, 44, 44); margin: 5px;">' . $dev->getThreadByID($_GET['id']) . '</div>';
echo '<div style="font-size: 8pt; color: #aaa; margin: 5px;">Crée : ' . $dev->getThreadByIDv2($_GET['id'])['date_created'] . ', Dernier Message : ' . $dev->getThreadByIDv2($_GET['id'])['date_modified'] . '</div>';
$db2 = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password);
$sql_req2 = "SELECT * FROM `web_messages` WHERE `thread_id`=" . $_GET['id'] . ";";
$req2 = $db2->prepare($sql_req2);
$req2->execute();
$req2->setFetchMode(PDO::FETCH_ASSOC);
for ($i = 0; $i < $req2->rowCount(); $i = $i + 10) {
    echo '<a href="forum_thread.php?start=' . $i . '&id=' . $_GET['id'] . '" class="number" style="float:left;margin:5px 0; margin-right:10px;">' . $i / 10 . '</a>';
}
echo '<div style="clear:both;"></div>';
$db = new PDO('mysql:host=' . $mysql_hostname . ';dbname=' . $mysql_database, $mysql_username, $mysql_password);
if (isset($_GET['start']) && is_numeric($_GET['start']) && $_GET['start'] != '0') {
    $sql_req = "SELECT * FROM `web_messages` WHERE `thread_id`='" . $_GET['id'] . "' ORDER BY `date_written` ASC LIMIT 10 OFFSET %d;";
    $sql_req = sprintf($sql_req, $_GET['start']);
} else {
    $sql_req = "SELECT * FROM `web_messages` WHERE `thread_id`='" . $_GET['id'] . "' ORDER BY `date_written` ASC LIMIT 10;";