<?php include 'models/database.php'; include 'models/posts.php'; $topics = GetTopics(); //count the number of posts inside a topic $numberofreplies = array(); $metritis = 0; foreach ($topics as $topic) { $posts = GetPosts($topic[4]); foreach ($posts as $post) { $metritis += 1; } $numberofreplies[$topic[4]][0] = $metritis; $metritis = 0; } //Get Last Post's Author $lastposts = array(); $author = array(); foreach ($topics as $topic) { $lastposts = GetLastPost($topic[4]); foreach ($lastposts as $lastpost) { $author[$topic[4]][0] = $lastpost[0]; } } include 'views/topiclist.php'; ?>
<?php session_start(); header('Content-Type: text/html; charset=utf-8'); include 'models/database.php'; include 'models/posts.php'; $posts = GetPosts(); if (isset($_SESSION['userid'])) { $username = $_SESSION['username']; } include 'views/home.php';
<form action=""> <table id="page"> <tr> <th><a id="toggle-all" ></a> </th> <th><a href="">Ticket Subject</a> </th> <th><a href="">Posted</a></th> <th><a href="">Answers</a></th> <th><a href="">Status</a> </tr> <?php for($i = 0;$i<$num;$i++) { $subject = mysql_result($sql,$i,"subject"); $posted = mysql_result($sql,$i,"posted"); $id = mysql_result($sql,$i,"id"); $answers = GetPosts($id); $opened = mysql_result($sql,$i,"opened"); if($opened == 1) { $open = "<b>Open</b>"; } else { $open = "<b>Closed</b>"; } ?> <tr> <td><input type="checkbox"/></td> <td><a href="index.php?page=viewticket&id=<?echo $id; ?>"><? echo $subject;?></a></td> <td><? echo $posted;?></td> <td><? echo $answers;?></td>
<?php include 'models/database.php'; include 'models/posts.php'; include 'views/header.php'; $topicid = $_GET['topicid']; $topicname = GetTopicName($topicid); $posts = GetPosts($topicid); include 'views/postlist.php'; include 'printfooter.php'; ?>