";
//
// Личное сообщение
//
if($login_id!=$id)
{
echo '
';
NewPrivMsgForm($id,1);
echo '
';
}
//
// Бан
//
if($login_level>4)
{
echo '
';
// старые форумы
$r=my_mysql_query('SELECT * FROM forums_ban WHERE date2>"'.date('Y-m-d').'" AND xnick="'.xNick($nickinfo).'"');
if($fetch=mysql_fetch_object($r))
{
echo "
Забанен на форумах ".FullDate($fetch->date1)." до ".FullDate($fetch->date2)."";
// if($login_level>4)
// echo " ";
echo "
";
}
// новые форумы
$r=my_mysql_query('SELECT * FROM comments_ban WHERE date2>"'.date('Y-m-d').'" AND nick_id='.$id);
if($fetch=mysql_fetch_object($r))
{
echo "
Забанен на новом сайте ".FullDate($fetch->date1)." до ".FullDate($fetch->date2)." by ".getNicki($fetch->admin_id)->nick;
if($login_level>4)
echo ' ';
echo "
";
}
//echo '
';
echo '
Забанить до: Сейчас: '.date("Y-m-d H:i:s").'
';
}
echo "
";
//
// Фотоальбом
//
/*
if($login_id==$nickfetch->id)
upload_form(rec_type('users'),$nickfetch->id);
else
uphotos_view(rec_type('users'),$nickfetch->id);
*/
$r2 = my_mysql_query("SELECT * FROM photos WHERE rec_type=12 AND rec_id=".$id." ORDER BY time");
if(mysql_numrows($r2)>0)
{
echo '
";
$r=my_mysql_query("SELECT COUNT(*) AS cnt FROM forbase WHERE author='".sql($nickinfo)."' AND forumid");
$fetch=mysql_fetch_object($r);
if($fetch->cnt==0)
{
echo "
От ".my_htmlspecialchars($nickinfo)." не было сообщений в форумах.
";
else
{
$r=my_mysql_query("SELECT MIN(time) AS m1, MAX(time) AS m2 FROM forbase WHERE author='".my_htmlspecialchars($nickinfo)."' AND forumid");
$fetch=mysql_fetch_array($r);
$r=my_mysql_query("SELECT TO_DAYS('$fetch[m2]')-TO_DAYS('$fetch[m1]') AS mdays");
$f2=mysql_fetch_array($r);
echo "
Первое сообщение:
".FullDate($fetch[m1])."
";
echo "
Последнее сообщение:
".FullDate($fetch[m2])."
";
echo "
Всего дней:
$f2[mdays]
";
$titles=array("За все время:","За последний месяц (май)","За последнюю неделю (20 сентября - 20 сентября)");
$conds=array(""," AND (YEAR(time)=2002 AND MONTH(time)=5)"," AND (TO_DAYS(time)>=TO_DAYS('2002-06-01') AND TO_DAYS(time)<=TO_DAYS('2002-06-10'))");
// За месяц
$y=intval(date("Y"));
$m=intval(date("m"))-1;
if($m==0)
{ $y--; $m=12; }
$titles[1]="За последний месяц (".CMonth($m)." ".$y."):";
$conds[1]=" AND (YEAR(time)=$y AND MONTH(time)=$m)";
// За неделю
$n=intval(strftime("%W"));
$firstday=mktime(0,0,0,1,1,$y);
$firstday+=60*60*24*(7*($n-1)+1-date("w",$firstday));
$first=date("Y-m-d",$firstday);
$last=date("Y-m-d",$firstday+60*60*24*6);
$titles[2]="За последнюю неделю (".DoubleDate($first,$last,"-")."):";
$conds[2]=" AND (TO_DAYS(time)>=TO_DAYS('$first') AND TO_DAYS(time)<=TO_DAYS('$last'))";
for($i=2;$i>=0;$i--)
{
$r=my_mysql_query("SELECT COUNT(*) AS cnt FROM forbase".(!empty($conds[$i])?" WHERE forumid $conds[$i]":""));
$fetch_glb=mysql_fetch_array($r);
$r=my_mysql_query("SELECT MIN(time) AS m1, MAX(time) AS m2, COUNT(*) AS cnt FROM forbase WHERE author='".sql($nickinfo)."' AND forumid $conds[$i]");
$fetch=mysql_fetch_array($r);
$r=my_mysql_query("SELECT TO_DAYS('$fetch[m2]')-TO_DAYS('$fetch[m1]') AS mdays");
$f2=mysql_fetch_array($r);
echo "
";
$r=my_mysql_query("SELECT COUNT(*) AS cnt FROM forbase WHERE (grandid=0 OR grandid=id) $conds[$i]");
$fetch_glb=mysql_fetch_array($r);
$r=my_mysql_query("SELECT COUNT(*) AS cnt FROM forbase WHERE author='".sql($nickinfo)."' AND forumid AND (grandid=0 OR grandid=id) $conds[$i]");
$fetch=mysql_fetch_array($r);
echo "
";
//
// Сообщения в форумах
//
$r=my_mysql_query("SELECT forums.id AS forumid, forums.name AS forumname, COUNT(forbase.id) AS cnt FROM forums,forbase WHERE forums.id=forbase.forumid AND author='".sql($nickinfo)."' GROUP BY forums.id ORDER BY cnt DESC");
echo "
";
$r=my_mysql_query("SELECT grandid,MAX(time) AS time FROM forbase WHERE author='".sql($nickinfo)."' AND forumid GROUP BY grandid ORDER BY time DESC LIMIT 12");
while($fetch=mysql_fetch_array($r))
{
$r2=my_mysql_query("SELECT forumid, grandid, subject, grand_count FROM forbase WHERE id=$fetch[grandid]");
$fetch2=mysql_fetch_array($r2);
echo "
";
*/
}
//
// Анкета ника
//
elseif(!empty($nickinfo))
{
if(empty($c_l))
{
// echo " Вы должны ввести свой ник и пароль, если хотите просматривать анкеты других посетителей
Статус ника:
![](/img/".($sort==11?"iconardn":"iconarup").".gif){kind=small}
":"")."![](/img/".($sort==21?"iconardn":"iconarup").".gif){kind=small}
":"")."![](/img/".($sort==41?"iconardn":"iconarup").".gif){kind=small}
":"")."![](/img/".($sort==51?"iconardn":"iconarup").".gif){kind=small}
":"")."
");
else
echo " ";
*/
echo "