View file forum_tl/forum.php

<?php $q = mysql_query("  
SELECT ft.id, ft.id_forum, ft.id_razdel, ft.name, 
(SELECT COUNT(id) FROM forum_p   
AS pk WHERE pk.id_them = ft.id) AS count,  
(SELECT (id_user) FROM  forum_p   
AS pu WHERE pu.id_them = ft.id  
ORDER BY pu.id DESC LIMIT 1) AS p_user  
FROM forum_t AS ft  
LEFT JOIN forum_f AS ff ON ff.id = ft.id_forum   
LEFT JOIN user AS tu ON tu.id = '$user[id]'  
WHERE ft.close = '0'   
AND tu.group_access >= (ff.adm - 1)  
GROUP BY ft.id ORDER BY  time_create DESC LIMIT 5"); 
?><table class='post'><?  
while ($Fin_ = mysql_fetch_assoc($q)){$FuS = new user();    
?><tr><td class='nav1'>  
<img src='/style/themes/<?=$set['set_them']?>/forum/14/them_00.png' alt='N'/></td><td class='p_t'>  
<a href='/forum/<?=$Fin_['id_forum']?>/<?=$Fin_['id_razdel']?>/<?=$Fin_['id']?>/'>  
<?= stripslashes(text($Fin_['name']))?></a>  
&#032;(<?=($Fin_['count'])?>)  
<?if ($Fin_['p_user'] !== NULL){?><?=  
$FuS->avatar($Fin_['p_user'],2).  
$FuS->nick($Fin_['p_user'],1,1,1)?><?}?>  
</td></tr><?}?></table><?