<?php
$query = "SELECT * FROM " . __PREFIX__ . "forum";
$res = mysql_query($query) or _err(mysql_error());
while ($row = mysql_fetch_row($res)) {
?>
<p><b>Titolo: </b><?php
print $row[1];
?>
<br />
<i><?php
print $row[2];
?>
</i><br />
<i>Access: <?php
if (!empty($row[3])) {
print check_graphic_access_forum($row[0]);
} else {
print 'FULL ACCESS';
}
?>
</i><br />
<a href = 'admin.php?mode=1&action=2&id=<?php
print $row[0];
?>
'>Elimina</a>
<a href = 'admin.php?mode=1&action=3&id=<?php
print $row[0];
?>
'>Edita</a><p>
<hr />
<?php
while ($row3 = mysql_fetch_row($res3)) {
$posts++;
}
//last topic
$query = "SELECT id, title \n\t\t\t\t\t FROM " . __PREFIX__ . "topic \n\t\t\t\t\tWHERE f_id = '" . $row[0] . "' \n\t\t\t\t\t AND replyof < 0 \n\t\t\t\t\tORDER BY last DESC";
$last_topic = mysql_fetch_row(mysql_query($query));
//controllo se esistono messaggi oppure no
if ($last_topic[0] == NULL) {
$last_topic = "Nessun Messaggio.";
} else {
$last_topic = "@ <a href=\"viewtopic.php?id=" . $last_topic[0] . "\">" . $last_topic[1] . "</a>";
}
?>
<tr class="forums">
<td class="forums"><a href = 'viewforum.php?id=<?php
print $row[0] . "'>./ " . $row[1] . "</a> " . check_graphic_access_forum($row[0]) . "<br /><font color=\"grey\"><i>" . $row[2] . "</i></font>";
?>
</td>
<td class="forums"><?php
print $last_topic;
?>
</td>
<td class="forums"><?php
print $topics;
?>
</td>
<td class="forums"><?php
print $posts;
?>
</td>
</tr>
