<?


    global $link;

require("conf_global.php");

$local = $INFO['sql_host'];
$user  = $INFO['sql_user'];
$pass  = $INFO['sql_pass'];
$db    = $INFO['sql_database'];

$con  = @mysql_connect($local,$user,$pass);
        @mysql_select_db($db, $con);
echo "<div dir =\"rtl\">";
$query = mysql_query("SELECT * FROM `ibf_topics` ORDER BY `tid` DESC LIMIT 5") or die (mysql_error());
while($row = mysql_fetch_array($query)){
$title =$row['title'];
$topicid =$row['tid'];
$mid =$row['starter_id'];
$tgo =$row['posts'];
$vie =$row['views'];

$query2 = mysql_query("SELECT * FROM `ibf_members` WHERE id='{$mid}'") or die (mysql_error());
while($row2 = mysql_fetch_array($query2)){
$name =$row2['name'];
$mg =$row2['mgroup'];

$query222 = mysql_query("SELECT * FROM `ibf_groups` WHERE g_id='{$mg}'") or die (mysql_error());
while($row222 = mysql_fetch_array($query222)){
$prefix =$row222['prefix'];
$suffix =$row222['suffix'];
echo <<<EOF


<div align="right">
<font face="Tahoma" color="#A6B3C3" size="2">
<font face="Tahoma" color="#A6B3C3" size="2"> הנושא : <a href="index.php?showtopic={$topicid}">{$title}</a> </font><br>מאת<font face="Tahoma" color="#A6B3C3" size="2"> : {$prefix}</font> <a href="forum//index.php?showuser={$mid}"><font face="Tahoma" color="red" size="2">{$name}</font></a> {$suffix}</b> <font face="Tahoma" color="#A6B3C3" size="2">צפיות<font face="Tahoma" color="#A6B3C3" size="2"> : {$vie} ,תגובות<font face="Tahoma" color="#A6B3C3" size="2"> : {$tgo}</font><br>
</font>
</div>
EOF;
}
}
}
echo "</div>";



?>