phpBB Suomi

Koodi: Valitse kaikki

    <?php
    //-- Start the phpBB session AND include the nessacary files
    define( 'IN_PHPBB', true );
    $phpbb_root_path = './phpBB3/'; // change in your own root path.
    $phpEx = substr(strrchr(__FILE__, '.'), 1);
    include($phpbb_root_path . 'common.' . $phpEx);
    include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
    include($phpbb_root_path . 'includes/bbcode.' . $phpEx);

    $user->session_begin();
    $auth->acl( $user->data );
    $user->setup();

    //-- Fetch the data from the specified fora
    $bbcode = new bbcode();
    $news_fora_id = array( '39' ); // Change in the fora id's you need
    $output = '';
            $topic_count = '3'; // Change in the number of topics you want to show.
        $query = "
            SELECT p.topic_id, p.forum_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid,
                u.user_id, u.user_email, u.username, u.user_posts, u.user_rank, u.user_colour, u.user_allow_viewonline, u.user_allow_viewemail,
                t.topic_title,
                    (
                        SELECT COUNT( post_id )
                        FROM " . POSTS_TABLE . "
                            WHERE topic_id = p.topic_id
                    ) AS aantal_posts
            FROM " . POSTS_TABLE . " AS p, " . USERS_TABLE . " AS u, " . TOPICS_TABLE . " AS t
                WHERE " . $db->sql_in_set( 'p.forum_id', $news_fora_id ) . "
                    AND u.user_id = p.poster_id
                    AND t.topic_id = p.topic_id
            GROUP BY topic_id
            ORDER BY topic_id DESC
        LIMIT 0, {$topic_count}
        ";
    //die('<pre>' . $query );
    $result = $db->sql_query( $query );
    while( $row = $db->sql_fetchrow($result) )
    {
        // Parse the message and subject
        $message = censor_text($row['post_text']);

        // Second parse bbcode here
        if ($row['bbcode_bitfield'])
        {
            $bbcode->bbcode_second_pass($message, $row['bbcode_uid'], $row['bbcode_bitfield']);
        }

        $message = bbcode_nl2br($message);
        $message = smiley_text($message);
        
        // Send data to output var
        $output .= "<h3><a href=\"" . $phpbb_root_path . "viewtopic.php?f={$row['forum_id']}&t={$row['topic_id']}\" title=\""  . censor_text($row['post_subject']) . "\">".censor_text($row['post_subject'])."</a></h3>\n";
    }

    // print the output
    print( $output );
    ?>

Koodi: Valitse kaikki

WHERE " . $db->sql_in_set( 'p.forum_id', $news_fora_id ) . "
                    AND u.user_id = p.poster_id
                    AND t.topic_id = p.topic_id