<?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>