Файл: style/web/index.php
Строк: 90
<?
echo "<div class='titles'>n";
echo "<a href="/online.php">Онлайн: ".mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `date_last` > ".(time()-600).""), 0)."</a> ";
echo "(+".mysql_result(mysql_query("SELECT COUNT(*) FROM `guests` WHERE `date_last` > ".(time()-600)." AND `pereh` > '0'"), 0)." гостей)n";
echo "</div>n";
$s1 = mysql_query("SELECT * FROM `gallery_foto` WHERE `avatar` = '1' ORDER BY `rating` DESC LIMIT 17");
?>
<div style="display: block; text-align: center; padding: 3px; padding-bottom: 10px; max-width: 700px; margin: auto; position: relative;"><?
while ($photo = mysql_fetch_assoc($s1))
{
$num++;
?><div style="display: inline-block; position: relative; top: <?=($num % 2 ? 0 : 15)?>px; margin-left: -15px;"><img style="border: 3px solid #f7f7f7;" src="/foto/foto50/<?=$photo['id']?>.jpg" /></div><?
}
?>
</div>
<?
echo '</span> <div class="hhhhh">Новое в дневниках</div>
';
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes` "),0);
$q=mysql_query("SELECT * FROM `notes` ORDER BY `id` DESC LIMIT 4");
if ($k_post==0)
{
echo " <div class='mess'>n";
echo "Никто не создавал дневникn";
echo " </div>n";
}
while ($post = mysql_fetch_assoc($q))
{
if ($num==0)
{
$num=1;
}elseif ($num==1)
{
$num=0;}
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `notes` WHERE `id` = $post[id] AND `time` > '$ftime'",$db), 0);
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1"));
echo '<div class="nav1 ">';
echo " <b><a href='info.php?id=" . $ank['id'] . "'> ". group($ank['id']) ." " . $ank['nick'] . "</a></b> >>> <a href='plugins/notes/list.php?id=$post[id]'>" . text($post['name']) . "</a><br/> <div align='right'><sup> (".vremja($post['time']).") </snup></div> ";
echo '</div>';
}
echo '<div class="hhhhh">Новое в форуме</div>
';
$adm_add=NULL;
$adm_add2=NULL;
if (!isset($user) || $user['level']==0){
$q222=mysql_query("SELECT * FROM `forum_f` WHERE `adm` = '1'");
while ($adm_f = mysql_fetch_assoc($q222))
{
$adm_add[]="`id_forum` <> '$adm_f[id]'";
}
if (sizeof($adm_add)!=0)
$adm_add2=' WHERE'.implode(' AND ', $adm_add);
}
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t`$adm_add2"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$q=mysql_query("SELECT * FROM `forum_t`$adm_add2 ORDER BY `time_create` DESC LIMIT 4");
if (mysql_num_rows($q)==0) {
echo " <div class='mess '>n";
echo "Нет темn";
echo " </div>n";
}
while ($them = mysql_fetch_assoc($q))
{
echo '<div class="nav1 ">';
$forum=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_f` WHERE `id` = '$them[id_forum]' LIMIT 1"));
$razdel=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_r` WHERE `id` = '$them[id_razdel]' LIMIT 1"));
//$them=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_t` WHERE `id` = '$post[id_them]' LIMIT 1"));
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1"));
if ($set['set_show_icon']==2){
echo "<img src='/style/themes/default/forum/48/them_$them[up]$them[close].png' />";
}
elseif ($set['set_show_icon']==1)
{
echo "<img src='/style/themes/default/forum/14/them_$them[up]$them[close].png' alt='' />";
}
echo "<a href='/forum/$forum[id]/$razdel[id]/$them[id]/'>$them[name]</a> <a href='/forum/$forum[id]/$razdel[id]/$them[id]/?page=end'>(".mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_p` WHERE `id_forum` = '$forum[id]' AND `id_razdel` = '$razdel[id]' AND `id_them` = '$them[id]'"),0).")</a>n";
echo "<br><a href='/forum/$forum[id]/'>$forum[name]</a> > <a href='/forum/$forum[id]/$razdel[id]/'>$razdel[name]</a><br />n";
$ank=mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $them[id_user] LIMIT 1"));
echo "Автор: <a href='/info.php?id=$ank[id]' title='Анкета "$ank[nick]"'>$ank[nick]</a> (".vremja($them['time_create']).")<br />n";
$post=mysql_fetch_assoc(mysql_query("SELECT * FROM `forum_p` WHERE `id_them` = '$them[id]' AND `id_razdel` = '$razdel[id]' AND `id_forum` = '$forum[id]' ORDER BY `time` DESC LIMIT 1"));
$ank2=get_user($post['id_user']);
if ($ank2['id'])echo "Посл.: <a href='/info.php?id=$ank2[id]' title='Анкета "$ank2[nick]"'>$ank2[nick]</a> (".vremja($post['time']).")<br />n";
echo " </div>n";
}
?>
<div class="nav1 ">
<center>
<a href='/flashgame/index1.php'><img src='http://upsa.us/style/themes/web/1php.PNG' alt='' /></a>
<a href='/flashgame/index2.php'><img src='http://upsa.us/style/themes/web/2php.PNG' alt='' /></a>
<a href='/flashgame/index3.php'><img src='http://upsa.us/style/themes/web/3php.PNG' alt='' /></a>
<a href='/flashgame/index5.php'><img src='http://upsa.us/style/themes/web/5php.PNG' alt='' /></a>
<a href='/flashgame/index6.php'><img src='http://upsa.us/style/themes/web/6php.PNG' alt='' /></a>
<a href='/flashgame/index7.php'><img src='http://upsa.us/style/themes/web/7php.PNG' alt='' /></a>
<a href='/flashgame/index8.php'><img src='http://upsa.us/style/themes/web/8php.PNG' alt='' /></a>
<a href='/flashgame/index9.php'><img src='http://upsa.us/style/themes/web/9php.PNG' alt='' /></a><br/><font color='red'>New</font> Игры
</center></div>