Herzlich willkommen im Archiv vom ABAKUS Online Marketing Forum
Du befindest Dich im Archiv vom ABAKUS Online Marketing Forum. Hier kannst Du Dich für das Forum mit den aktuellen Beiträgen registrieren.
Code: Alles auswählen
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include_once($phpbb_root_path . 'extension.inc');
include_once($phpbb_root_path . 'common.'.$phpEx);
$sql = "SELECT t.topic_id, t.topic_title
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f
WHERE f.forum_id = t.forum_id
AND f.auth_view=0
ORDER BY t.topic_last_post_id DESC
LIMIT 5";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query topic info', '', __LINE__, __FILE__, $sql);
}
while( $topicrow = $db->sql_fetchrow($result))
{
$URL= append_sid("viewtopic.php?t=" . $topicrow['topic_id']);
echo '<a href="'.$URL.'">' . $topicrow['topic_title'] . '</a><br>';
}
?>
Code: Alles auswählen
ORDER BY t.topic_last_post_id DESC
LIMIT 5";