if ($_SESSION["username"]!=NULL)
{
$user=$_SESSION["username"];
require('config.php');
$res=mysql_query("select account, referer from tb_users where username='$user'");
$res=mysql_fetch_array($res);
$referer=$res["referer"];
if($res["account"]=="V.I.P.")
{
$res=mysql_query("select enddate from tb_upgrade where user='$user'");
$res=mysql_result($res,0,0);
if($res!='' and $res<=time())
{
mysql_query("update tb_users set account='Базовый' where username='$user'");
mysql_query("delete from tb_upgrade where user='$user'");
}
}
$res=mysql_query("select account from tb_users where username='$referer'");
if($res)
{
$res=mysql_fetch_array($res);
if($res["account"]=="V.I.P.")
{
$res=mysql_query("select enddate from tb_upgrade where user='$referer'");
$res=mysql_result($res,0,0);
if($res!='' and $res<=time())
{
mysql_query("update tb_users set account='Базовый' where username='$referer'");
mysql_query("delete from tb_upgrade where user='$referer'");
}
}
}
$res=mysql_query("select autoref,autorefend from tb_users where username='$user'");
$res=mysql_fetch_array($res);
if($res["autoref"]!='0')
{
$t=time();
if($t>=$res["autorefend"])
{
mysql_query("update tb_users set autoref='0' where username='$user'");
}
}
mysql_close($con);
require('config.php');
$res=mysql_query("select count(id) as kolvo from tb_mail where recipient='$user' and status='0'");
$res=mysql_fetch_array($res);
$inboxcount=$res["kolvo"];
mysql_close($con);
if($inboxcount>0)
{
echo "
У Вас есть непрочитанные сообщения. Просмотреть.";
}
}
?>