<?php
ob_start("ob_gzhandler");

$host = 'localhost';
$user = 'root';
$pass = 'root123';
$baza = 'baza';

if(mysql_connect($host, $user, $pass) and mysql_select_db($baza)) {

    $dane = mysql_query("SELECT DISTINCT `forum_id`, `forum_name` FROM `phpbb_forums`") or die('Query1');

    while($rek = mysql_fetch_array($dane)) {
        $fora[$rek['forum_id']] = $rek['forum_name'];
    }

    $dane = mysql_query("SELECT DISTINCT `topic_id`, `topic_title` FROM `phpbb_topics`") or die('Query2');

    while($rek = mysql_fetch_array($dane)) {
        $tematy[$rek['topic_id']]['topic_title'] = $rek['topic_title'];
    }

    $dane = mysql_query("SELECT DISTINCT `user_id`, `username` FROM `phpbb_users` WHERE `user_id` IN (SELECT `poster_id` FROM `phpbb_posts`)") or die('Query4');

    while($rek = mysql_fetch_array($dane)) {
        $userzy[$rek['user_id']] = $rek['username'];
    }

    $dane = mysql_query("SELECT DISTINCT `post_id`, `post_text`, `poster_id`, `post_time`, `post_username`, `topic_id`, `forum_id` FROM `phpbb_posts` ORDER BY `post_time` ASC") or die('Query3');

    while($rek = mysql_fetch_array($dane)) {
        $posty[$rek['post_id']]['topic_id'] = $rek['topic_id'];
        $posty[$rek['post_id']]['topic_title'] = $tematy[$rek['topic_id']['topic_title']];
        $posty[$rek['post_id']]['forum_name'] = $fora[$rek['forum_id']];
        $posty[$rek['post_id']]['post_text'] = $rek['post_text'];
        $posty[$rek['post_id']]['post_time'] = $rek['post_time'];
        if($rek['poster_id'] == '-1') {
            $posty[$rek['post_id']]['post_username'] = '<i>'.$rek['post_username'].'</i>';
        } else {
            $posty[$rek['post_id']]['post_username'] = $userzy[$rek['poster_id']];
        }
    }

    unset($userzy,$fora,$tematy,$dane,$rek);
    mysql_close();

    foreach($posty AS $val3 => $val4) {

        // $val1                ID posta
        // $val2['topic_id']            ID tematu
        // $val2['topic_title']         Nazwa tematu
        // $val2['post_text']           Tresc posta
        // $val2['post_time']           Czas wyslania posta
        // $val2['post_username']       Nazwa autora posta
        // $val2['forum_name']          Nazwa forum

    }

    unset($val1,$val2,$posty);

} else {
    echo 'Brak polaczenia z baza danych.';
}

?>