Последно от форума в саит

<? 

$user="user на базата данни"; 
$pass="pass на базата данни"; 
$db="име на базата данни"; 
$broi_temi="10";// Колко последни теми да показва 
$broi_bukvi="35";//До колко букви от заглавието на темата да показва 
mysql_connect(localhost,$user,$pass); 
mysql_select_db($db) or die( "Unable to select database"); 
$query="SELECT topic_time , topic_title,forum_id,topic_id, topic_replies,topic_type from phpbb_topics ORDER BY topic_time "; 
$result=mysql_query($query); 
$num=mysql_num_rows($result); 
mysql_close(); 

$ii=$num-$broi_temi; 
for ($i=$num-1; $i>$ii;$i--) 
{ 
$tema=mysql_result($result,$i,"topic_title"); 
$id=mysql_result($result,$i,"forum_id"); 
$topic_broi=mysql_result($result,$i,"topic_replies"); 
$topic_id=mysql_result($result,$i,"topic_id"); 
$topic=mysql_result($result,$i,"topic_type"); 

if($topic=="1") 
{$vazna='Важна:';} 
elseif($topic=="2") 
{$vazna='Съобщение:';} 
elseif($topic_status=="1") 
{$vazna='Заключена:';} 
else 
{$vazna='';} 

if (strlen($tema)>$broi_bukvi) 
{$totchki='...';} 
else 
{$totchki='';} 

$tema=substr($tema,0 , $broi_bukvi); 
echo" $vazna<a href='Пътя до папката на форума/viewtopic.php?t=$topic_id' >$tema$totchki ($topic_broi)</a><br/>"; 
} 


?>

<?php

// Freeware by Scriptol.com

// User configuration: update these data according to your own website

$site = "http:/";
$forumdir = "phpBB3/";
$formatflag = false;

// End of user configuration

$cvt = array( 
   "(´)"=>"'",
   "(à)"=>"à",
   "(â)"=>"â",
   "(ä)"=>"ä",
   "(ç)"=>"ç",
   "(è)"=>"è",
   "(é)"=>"é",
   "(ê)"=>"ê",
   "(ë)"=>"ë",
   "(î)"=>"î",
   "(ï)"=>"ï",
   "(ô)"=>"ô",
   "(ö)"=>"ö",
   "(ù)"=>"ù",
   "(ü)"=>"ü",
   "(û)"=>"û",
   "(«)"=>"«",
   "(»)"=>"»",
   "(©)"=>"©",
   "(§)"=>"¶",
);   
   

// Use this function only if the format differs

function convert($content)
{
    $len = count($cvt);
    while($htmlchar = current($cvt))
    {
      $letter = key($cvt);
      preg_replace($letter, $htmlchar, $content);
      next($cvt);
    }
    return $content;
}  

// Use  to convert to UTF-8

function makeUTF($desc)
{  
  $desc = UTF8_encode($desc);
  $desc = stripslashes($desc);
  return($desc);
}  



function display($host, $dbname, $dbuser, $password, $size)
{
    global $site;
    global $phpBB3;
    global $topiclist;
    global $table_prefix;     

    $db = @mysql_connect($host, $dbuser,$password);
    mysql_select_db($dbname);
 
    $posts = $table_prefix."posts";
    $users = $table_prefix."users"; 
    $top = $table_prefix."topics";
  
/*    
    $sql = "SELECT REF.post_id, TOP.topic_id, TXT.post_subject, REF.post_time, USER.username, TOP.topic_first_post_id
     FROM $posts REF, $texts TXT, $users USER, $top TOP
     WHERE REF.post_id = TOP.topic_first_post_id
     AND REF.post_id = TXT.post_id
     AND USER.user_id = TOP.topic_poster 
     ORDER BY post_time DESC LIMIT $size";
*/     
  
      $sql = "SELECT TOP.topic_id, TOP.topic_title, TOP.topic_time, USER.username 
     FROM $posts REF, $users USER, $top TOP
     WHERE REF.post_id = TOP.topic_first_post_id     
     AND TOP.topic_poster = USER.user_id
     ORDER BY REF.post_time DESC LIMIT $size";
   
     // optionally:  AND TOP.forum_id IN (1,2,4,5, ...)  
     
    $results = mysql_query($sql) or die(mysql_error());
     
    // Extracting and displaying titles
      
    while($line = mysql_fetch_assoc($results)) 
    {
       $title = $line['topic_title'];
       //$title = $line['post_subject'];
       $url = $phpBB3 . "viewtopic.php?t=" . $line['topic_id'];
       
       if($formatflag) $title = convert($title);

       $username = $line['username'];
       $date = strftime("%A %B %e, %Y %H:%M", $line['topic_time']+(0));
     
       echo "<a href='$url'>$title</a> by <span class='cssuser'>$username</span>  <span class='cssdate'>$date</span><br>\n";
    }
     
}

if(substr($site, -1, 1) != "/") $site = $site. "/";
$phpBB3 = $site . $forumdir;
if(substr($phpBB3,-1, 1) != "/") $phpBB3 = $phpBB3. "/";

include("conf.php");

if (! PHPBB_INSTALLED) die("phpBB not installed in $forumdir");

display($dbhost, $dbname , $dbuser, $dbpasswd , 10);     

?>