function threadList($boardid, $page) { global $db; $tbl_thread = MYSQL_TABLE_PREFIX . 'thread'; $tbl_users = MYSQL_TABLE_PREFIX . 'users'; global $config; global $lang; if ($page == 0) { $page = 1; } $tpp = $config->get('board', 'threads-per-page'); $ppp = $config->get('board', 'posts-per-page'); $limit = ($page - 1) * $tpp; $sql = "SELECT * FROM `" . $tbl_thread . "`, `" . $tbl_users . "` WHERE `" . $tbl_thread . "`.`boardid`=" . (int) $boardid . " AND `" . $tbl_thread . "`.`userid`=`" . $tbl_users . "`.`userid` ORDER BY `" . $tbl_thread . "`.`sticky` DESC, `" . $tbl_thread . "`.`lastpost` DESC LIMIT " . $limit . ", " . $tpp . ";"; $result = $db->query($sql); while ($row = mysql_fetch_assoc($result)) { if ($row['sticky'] == 1) { $row['thread'] = makeHTMLBold($lang->get('sticky') . ":") . " " . $row['thread']; } $post = $db->selectOneRow('post', 'postid', "`threadid`=" . $row['threadid'], "`postid` DESC", "1"); $row['last_post'] = makeLastPost($boardid, $row['threadid'], $post['postid'], $ppp); $row['thread'] = stripslashes($row['thread']); $row['answers'] = numPostsInThread($row['threadid']) - 1; $row['url'] = makeURL('board', array('boardid' => $_GET['boardid'], 'threadid' => $row['threadid'])); $row['newposts'] = makeNewPostsIcon(threadNewPosts($row['threadid']), userPosts($row['threadid'])); $list[] = $row; } return $list; }
<?php include 'include.php'; isAllowed(); if (isset($_GET['id'])) { $user = getUser($_GET['id']); } else { $user = $_SESSION['profil']; } $pages = userPages($user['id']); if ($pages > 0) { if (isset($_GET['page'])) { $content = userPosts($user['id'], $_GET['page']); } else { $content = userPosts($user['id']); } $content = $content->posts; } if ($user['id'] !== $_SESSION['profil']['id']) { $follow = alreadyFollow($_SESSION['profil']['id'], $user['id']); $friend = alreadyAsked($_SESSION['profil']['id'], $user['id']); } getHeader(); ?> <article> <!-- Contenu de la page --> <div class="contenu"> <div class="contenu_static"> <?php if ($user['id'] !== $_SESSION['profil']['id']) {