Polskie forum wsparcia dla phpBB

Kod: Zaznacz cały

<style>
   a.Latp2:link,a.Latp2:active,a.Latp2:visited {font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;color:#0F0F0F; font-weight: bold; text-decoration:none; line-height: 14px;}
   a.Latp2:hover {font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;color:#B90000; font-weight: bold; text-decoration:none}
   .Latp {font-family: verdana, arial, helvetica, sans-serif; font-size: 11px;color:#AFAFAF; font-weight: bold; text-decoration:none}
</style>
<TABLE width='200' cellpadding=2 cellspacing=0 border=0 align=center>
<?
        /*** phpBB3 - Last Active Topics System ***/

        //Author: Ioan Filipov

        //Email: jonidev@gmail.com

        //Date: 04.06.2007

        //------------------------------

        //Edit these parameters:

        //MySQL server adress
        $host="localhost";

        //Username
        $user="";

        //Password
        $pass="";

        //Database
        $db="";

        //Table prefix
        $table="phpbb_";

        //Show last x topics
        $laforums="10";
      

   //Topic name length
        $tl="24";

        $link=mysql_connect($host, $user, $pass);
        $db=mysql_select_db($db);
        $query="select * from $table".topics."  WHERE topic_approved = '1' order by topic_last_post_time desc limit 0,$laforums";
        $query2="select config_name,config_value from $table".config." where config_name = 'server_name' limit 0,1";
        $result2=mysql_query($query2);
        $row2 = mysql_fetch_array($result2);
        extract($row2);
   $posts_per_page = $r3[1];
        $result=mysql_query($query);
        while ($row=mysql_fetch_array($result)) {
        extract($row);
        $date = date("F j, Y, g:i a", $topic_last_post_time );
       $query3="select forum_name from $table".forums." WHERE forum_id = ".$forum_id."";
       $result3=mysql_query($query3);
       $row2 = mysql_fetch_array($result3);
      if(strlen($topic_title) > $tl)
      {
      $topic_title = mb_substr($topic_title,0,$tl, 'UTF-8').'...';
      }
      echo "<TR><TD class=Latp><a class=Latp2 href='http://".$config_value."/forum/viewtopic.php?f=".$forum_id."&t=".$topic_id."&p=".$topic_last_post_id."#p".$topic_last_post_id."'>".$topic_title."</a></TD></TR><TR><TD class=Latp>Last post: ".$topic_last_poster_name." on ".$date."<br /></TD></TR>\n";
      }
        //-------------------------- END
        ?>
</TABLE>