Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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']] = $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']];
- $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.';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement