prepare('SELECT Membership, isAdmin FROM users WHERE UserId = :userId LIMIT 1'); $stmt->bindParam(':userId', $userId, PDO::PARAM_INT); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); $adminLevel = (int)($row['isAdmin'] ?? 0); $isAdmin = in_array($adminLevel, [2, 3, 4, 5]) ? 1 : 0; } else { $isAdmin = 0; } $currentForumId = null; $forumName = null; $postId = (int)($_GET['PostID'] ?? 0); $stmt = $pdo->prepare("SELECT f.*, u.Username, u.JoinData, u.isAdmin, u.Membership FROM forums AS f LEFT JOIN users AS u ON f.UserId = u.UserId WHERE f.id = :postId LIMIT 1"); $stmt->execute([':postId' => $postId]); $post = $stmt->fetch(PDO::FETCH_ASSOC); if (!$post) { die("Post not found."); } $currentForumId = (int)$post['ForumId']; $forumGroups = [ 1 => [46 => 'All Things Afterworld', 14 => 'Help (Technical Support and Account Issues)', 21 => 'Suggestions & Ideas', 54 => 'Game Nights & Afterworld events'], 2 => [13 => 'Afterworld Talk', 18 => 'Off Topic', 32 => 'Clans & Guilds', 35 => "Let's Make a Deal"], 9 => [62 => 'Game Marketing', 40 => 'Game Design', 33 => 'Scripters'], 6 => [42 => 'Video Game Central', 52 => 'Video Creation with Afterworld', 26 => 'Ro-Sports', 24 => 'Pop-Culture (Music/Books/Movies/TV)', 23 => 'Role-Playing'], ]; foreach ($forumGroups as $group => $forums) { if (isset($forums[$currentForumId])) { $forumName = $forums[$currentForumId]; break; } } $replyStmt = $pdo->prepare("SELECT r.*, u.Username, u.JoinData, u.isAdmin, u.Membership FROM forum_replies AS r LEFT JOIN users AS u ON r.UserId = u.UserId WHERE r.PostId = :postId ORDER BY r.PostedAt ASC"); $replyStmt->execute([':postId' => $postId]); $replies = $replyStmt->fetchAll(PDO::FETCH_ASSOC); ?> Afterworld - Forum
   
Home Search MyForums"; } ?> prepare("SELECT f.id AS PostID, f.Message AS PostContent, f.PostedAt AS PostDate, f.Subject AS Subject, u.UserId, u.Username, u.Membership, u.isAdmin, u.JoinData FROM forums AS f LEFT JOIN users AS u ON f.UserId = u.UserId WHERE f.id = :postId"); $stmt->execute([':postId' => $_GET['PostID']]); $post = $stmt->fetch(PDO::FETCH_ASSOC); ?>
 

Sort:
Previous Thread :: Next Thread 
<?= htmlspecialchars($post['Username']) ?> is online.  
'; } elseif ($membership == 2) { echo 'TBC'; } elseif ($membership == 3) { echo 'OBC'; } ?>
Forum Moderator
Joined:
Total Posts: WIP
Edit Delete
Report Abuse
<?= htmlspecialchars($reply['Username']) ?> is online.  
'; } elseif ($membership === 2) { echo 'TBC'; } elseif ($membership === 3) { echo 'OBC'; } ?>
Forum Moderator
Joined:
Edit Reply Delete Reply
Report Abuse
Previous Thread :: Next Thread 
Page 1 of 1
 
   
 
Advertisement Report