$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');
<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;";