Файл: xteem.ru/system/new_tem.php
Строк: 29
<?php
if($t_f == 0) {
echo '<div class="podmenu"><center><b>Форум пока пуст!</b></center></div>';
}
$avtor = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$forum_p['us']."'"));
$forum = mysql_query("SELECT * FROM `forum_tema` ORDER BY `up` DESC LIMIT 9");
while($a = mysql_fetch_assoc($forum))
{
$forum_p = mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_tema` WHERE `id` = '".$a['id']."' ORDER BY `up` LIMIT 1"));
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$forum_p['us']."'"));
if($a['status'] == 0) {
$icon = 'tem'; } else { $icon = 'close';
}
if($a['status'] == 0) {
$icon = 'tem';
}elseif($a['status'] == 1){
$icon = 'close';
}elseif($a['status'] == 2){
$icon = 'top';
}
echo'<div class="forum_p"> <a href="/forum/tema'.$a['id'].'"><img width="16" height="16" src="/images/'.$icon.'.png" alt="*" /> '.$a['name'].' <span style="font-size: 9px;"> ('.mysql_result(mysql_query('select count(`id`) from `forum_post` WHERE `tema` = "'.$a['id'].'"'),0).')</span>
</a> ';
$post2 = mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_post` WHERE `tema` = '$a[id]' ORDER BY `time` DESC LIMIT 1"));
$ank2 = mysql_fetch_array(mysql_query("SELECT * FROM `users` WHERE `id` = '$post2[us]'"));
if (isset($post2['us'])) {
if ($ank['login'] == $ank2['login']) {
echo''.$ank2['login'].'';
} else {
echo ''.$ank2['login'].'';
}
} else {
echo' '.$ank2['login'] .'';
}
echo '
<a href="/forum/tema'.$a['id'].'?selection=top" > >> </a> </div>';
}
?>