Forum AnimeSub.info

ikki

Użytkownik

Skąd: Słupsk

Dołączył: 2005-08-01

PROBLEM Z NEWSAMI NA WWW

witam mam problem ze zintegrowaniem newsow phpbb ze strona 

uzywam takiego kodu: Kod:
<?
//////////////////////USTAWIENIA FORUM I BAZY
//id_forum
$fid = "1";
//////////////////////KONIEC USTAWIEN FORUM I BAZY

//pozyczamy kilka rzeczy z phpbb do laczenia sie z baza i BBCode

define("IN_PHPBB", true);
$phpbb_root_path = $path."/forum/";
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($path."forum/language/lang_polish/lang_main.php");
$board_config['smilies_path']=$path."forum/images/smiles";
include($path."forum/includes/bbcode.php");
$template=new template();

///////////////////// NEWSY /////////////////////

//pobieranie danych
//liczba po LIMIT to ilosc newsow na stonie (reszta bedzie na forum
$sql="SELECT `topic_id`,`forum_id`, `topic_title`, `topic_poster`, `topic_time`, `topic_replies`, `topic_status`, `topic_vote`, `topic_type`,  `topic_first_post_id` FROM ".TOPICS_TABLE." WHERE `forum_id` = ".$fid." ORDER BY `topic_type` DESC , `topic_id` DESC LIMIT 3";

$result = $db->sql_query($sql);
if( !$result )die("Blad0");
while( $co = $db->sql_fetchrow($result) )
{
$user_id = $co['topic_poster'];
$post_id = $co['topic_first_post_id'];
$topic_id = $co['topic_id'];
$post_time = $co['topic_time'];
$replies = $co['topic_replies'];
$title = $co['topic_title'];
$status = $co['topic_status'];
$vote = $co['topic_vote'];
$type = $co['topic_type'];
   
    $sql1 = "SELECT `username` from ".USERS_TABLE." WHERE user_id like ".$user_id." LIMIT 1";
    $result1 = $db->sql_query($sql1);
    if( !$result1 )die("Blad1");
    $co1 = $db->sql_fetchrow($result1);
    $nick = $co1['username'];
   
  $sql2 = "SELECT `post_text`,`bbcode_uid` from ".POSTS_TEXT_TABLE." WHERE post_id = ".$post_id." LIMIT 1";
  $result2 = $db->sql_query($sql2);
  if( !$result2 )die("Blad2");
  $co2 = $db->sql_fetchrow($result2);
  $text= $co2['post_text'];
  $bbcode_uid= $co2['bbcode_uid'];
//dane pobrano
 
//data dla ludzi a nie timestamp

$data = date("d.m.Y",$post_time);

//zarejestrowany i nick linkiem do profilu albo napis Gosc
$nick=($user_id != "-1") ? "<A HREF=\"forum/profile.php?mode=viewprofile&u=".$user_id."\">$nick</A>" : "Gosc";
//temat linkiem do forum + ewentualnie ankieta/przyklejony/ogloszenie
$title="<A title=\"$title\" HREF=\"forum/viewtopic.php?p=".$post_id."#".$post_id."\"><h3>".$title."</h3></A>";
if($vote==1)$title="<b>[Ankieta]</B> $title";
if($type==1)$title="<B>[Przyklejony]</B> $title";
elseif($type==2)$title="<B>[Ogloszenie]</B> $title";
else $title="$title";

//wyswietlanie:
echo("
<table border=\"0\" width=\"450\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
<tr><td> $title </td></tr>
<tr><td valign=\"top\">
<p align=\"justify\">
napisal: $nick @ $data<br><br>
");
//zaprzegnijmy BBCode do pracy i pokazmy tresc
$text = make_clickable($text);
$text = smilies_pass($text);
$text = nl2br($text);
$text = bbencode_second_pass($text, $bbcode_uid);
echo($text);
//no i komentarze link tak jak ODpowiedz na forum (tylko przy niektórych ustawieniach forum nie dziala)
echo("<div align=\"right\"><A title=\"Dodaj lub Pokaz komentarze\" HREF=\"forum/viewtopic.php?t=".$topic_id."&view=newest\">Komentarze</A> (<B>".$replies."</B>)</DIV><BR>");
echo("<center><img SRC=\"\" border=\"0\"></CENTER><br>");
echo("</p></td></tr></table>");
}

echo("<CENTER><A title=\"Archiwum\" HREF=\"forum/viewforum.php?f=".$fid."\">Archiwum</A></CENTER>");

///////////////////// KONIEC NEWSY /////////////////////
?>

prosze o pomoc adres forum to www.onepiece.boo.pl stronki: www.onepiece.boo.pl