<?php
if(!$_SESSION['useraccepted']) {
echo "fejl";
}
else {
if (isset ($_COOKIE["topicstatus"])) {
$k = 0;
while (list ($name, $value) = each ($_COOKIE["topicstatus"])) {
$cookid[$k] = $name;
$cooktimestamp[$k] = $value;
$k++;
}
$skip = false;
}
else {
$skip = true;
}
require "modules/mysqlfunctions.php";
$connection = openMysql("localhost", "encory", "ghost21", "encdab");
if($_SESSION['userlevel'] == "Guest") {
$sqltopics = "SELECT t.ID, t.TopicName, u.Name, t.TimeStamp FROM topics t, forumusers u WHERE t.UserID = u.ID AND Privacy = 'public' ORDER BY t.ID DESC";
$newpostssql = "SELECT p.TimeStamp, p.TopicID, u.Name, FROM posts p, forumusers u WHERE u.ID = p.UserID ORDER BY TimeStamp DESC";
$countsql = "SELECT p.TopicID, COUNT(p.TopicID) AS count FROM posts p, topics t WHERE t.ID = p.TopicID GROUP BY t.ID ORDER BY t.ID DESC";
}
else {
$sqltopics = "SELECT t.ID, t.TopicName, u.Name, t.TimeStamp, t.Privacy FROM topics t, forumusers u WHERE t.UserID = u.ID ORDER BY t.ID DESC";
$newpostssql = "SELECT p.TimeStamp, p.TopicID, u.Name, p.ID FROM posts p, forumusers u WHERE u.ID = p.UserID ORDER BY TimeStamp DESC";
$countsql = "SELECT p.TopicID, COUNT(p.TopicID) AS count FROM posts p, topics t WHERE t.ID = p.TopicID GROUP BY t.ID ORDER BY t.ID DESC";
}
$topics = mysql_query($sqltopics) or die(mysql_error( ));
?>
<br />
<table style="width:100%" class="forumtopics" cellspacing="0" cellpadding="0">
<tr>
<td style="width:100%">
<br />
<div class="middletextheader">Encory Web Community</div><br />
<div class="middletextheader">Velkommen: <?php echo $_SESSION['forumuser']; ?></div><br />
<?php
echo "<div class='smalltextgray'>";
if($_SESSION['userlevel'] != "Guest") {
echo "<a href='index.phtml?subpage=addtopic'>Tilføj emne</a> | "; }?><a href='index.phtml?subpage=userlist'>Brugerliste</a> | <a href="index.phtml?subpage=forumhelp">Hjælp</a> | <a href="subpages/logoff.php">Log af</a></div>
<hr style="width: 100%" />
</td>
</tr>
<tr>
<td align="center">
<div class="smalltextblackbold" style="padding-left:8px">Emner:</div><br />
<table cellspacing="1" cellpadding="0" class="topics" style="width: 95%">
<tr>
<td class="smalltextblackbold" style="background-color:#000000; color:#FFFFFF; padding-left: 2px">Titel</td>
<td class="smalltextblackbold" style="text-align: center; background-color:#000000; color:#FFFFFF">Startet af</td>
<td class="smalltextblackbold" style="text-align: center; background-color:#000000; color:#FFFFFF">Indlæg ialt </td>
<td class="smalltextblackbold" style="text-align: center; background-color:#000000; color:#FFFFFF">Status</td>
<td class="smalltextblackbold" style="text-align: center; background-color:#000000; color:#FFFFFF">Sidste indlæg af</td>
<?php
if($_SESSION['userlevel'] != "Guest") {
?>
<td class="smalltextblackbold" style="text-align: center; background-color:#000000; color:#FFFFFF; padding-left: 2px; padding-right: 2px"><img src="pics/key.gif" style="width: 11px; height: 11px" /></td>
<?php
}
?>
</tr>
<?php
for($i = 1; $row = mysql_fetch_row ($topics); ++$i) {
if($skip == false) {
$timestamp = 999999999999;
for($j = 0; $j <= count($cookid); $j++) {
if($cookid[$j] == $row[0]) {
$timestamp = $cooktimestamp[$j];
}
}
}
$antal = 0;
$nypost = "Ingen nye ";
$found = false;
$lastpost = "";
$count = mysql_query($countsql) or die(mysql_error( ));
$newposts = mysql_query($newpostssql) or die(mysql_error( ));
$y = 0;
while($result = mysql_fetch_row($newposts)){
if($skip == false) {
if($result[1] == $row[0]) {
if($result[0] > $timestamp) {
//echo (strtotime(prepdate($result[0]))) - (strtotime(prepdate($timestamp)))."<br />";
//echo strtotime(prepdate($result[0]))." > ".strtotime(prepdate($timestamp))."<br />";
if($y > 1) {
$nypost = ++$y." nye!!";
}
else {
$nypost = ++$y." ny!!";
}
}
}
}
else {
$nypost = "";
}
if($result[1] == $row[0] && $found == false) {
$found = true;
$lastpost = $result[2];
}
$k++;
}
while($result = mysql_fetch_row($count)) {
if($result[0] == $row[0]) {
$antal = $result[1];
}
}
if (mod(2, $i) == 0) {
echo "<tr>";
echo "<td width='50%' class='lightline'><a href='index.phtml?subpage=showtopic&id=".$row[0]."&next=0&setcookie=true'>".$row[1]."</a></td>";
echo "<td class='lightline' style='text-align: left; padding-left: 6px'>".$row[2]."</td><td class='lightline' style='text-align: left; padding-left: 6px'>".$antal."</td><td class='lightline' style='text-align: left; padding-left: 6px'>".$nypost." </td><td class='lightline' style='text-align: left; padding-left: 6px'>".$lastpost."</td>";
if($_SESSION['userlevel'] != "Guest") {
if($row[4] == "public") {
echo "<td class='lightline' style='padding-left: 3px'><img src='pics/unlockedwhite.gif' alt='unlocked' /></td>";
}
else {
echo "<td class='lightline' style='padding-left: 3px'><img src='pics/lockedwhite.gif' alt='locked'/></td>";
}
}
echo "</tr>";
}
else {
echo "<tr>";
echo "<td width='50%'class='darkline'><a href='index.phtml?subpage=showtopic&id=".$row[0]."&next=0&setcookie=true'> ".$row[1]."</a></td>";
echo "<td class='darkline' style='text-align: left; padding-left: 6px'>".$row[2]." </td><td class='darkline' style='text-align: left; padding-left: 6px'>".$antal."</td><td class='darkline' style='text-align: left; padding-left: 6px'>".$nypost." </td><td class='darkline' style='text-align: left; padding-left: 6px'>".$lastpost." </td>";
if($_SESSION['userlevel'] != "Guest") {
if($row[4] == "public") {
echo "<td class='darkline' style='padding-left: 3px'><img src='pics/unlockedgray.gif' alt='unlocked' /></td>";
}
else {
echo "<td class='darkline' style='padding-left: 3px'><img src='pics/lockedgray.gif' alt='locked' /></td>";
}
}
echo "</tr>";
}
}
closeMysql($connection);
?>
</table>
<br />
</td>
</tr>
<?php
if($_SESSION['userlevel'] != "Guest") {
echo "<tr>";
echo "<td colspan='4' class='smalltextgray' style='padding-right: 27px; text-align: right'><img src='pics/unlockedwhite.gif' alt='unlocked' /> - Offentligt emne | <img src='pics/lockedwhite.gif' alt='locked' /> - Privat emne</td>";
echo "</tr>";
if($skip == true) {
echo "<tr><td colspan='4' class='smalltextgray' style='padding-right: 27px; text-align: right'>* <a href='index.phtml?subpage=cookiesetup'>Ret dine cookieindstillinger</a></td></tr>";
}
}
?>
</table>
<?php
}
?>
