<?
include('config.php');
$checkpemail = mysql_query("SELECT id FROM tb_users");
$pemail_exist = mysql_num_rows($checkpemail);

    $sql = "SELECT * FROM tb_config WHERE item='click' and howmany='1'";
    $result = mysql_query($sql);        
    $row = mysql_fetch_array($result);
    $clck=$row["price"]; 

    $sql = "SELECT * FROM tb_config WHERE item='referalclick' and howmany='1'";
    $result = mysql_query($sql);        
    $row = mysql_fetch_array($result);
    $refclck=$row["price"]; 

        $sql = "SELECT * FROM tb_config WHERE item='payment' and howmany='1'";
        $result = mysql_query($sql);        
        $row = mysql_fetch_array($result);
        $minimalka=$row["price"];

$dc=date("d.m.Y");
$sql="select * from tb_users where joindate='$dc'";
$result=mysql_query($sql);
$nov=mysql_num_rows($result);

	$sql = "SELECT count( * ) FROM users_online where urlpage='<font color=#ff0000>Зарабатывает</font>'";
	$result = mysql_query($sql);
        $tot1=mysql_result($result,0,0);

$sql="select * from tb_config where item='recordonline'";
$res1=mysql_query($sql);
$rowq=mysql_fetch_array($res1);
$recon=$rowq["howmany"];

$sql="select count(*) from users_online";
$res1=mysql_query($sql);
$qwr=mysql_result($res1,0,0);

if ($qwr>$recon)
{
	$sql="update tb_config set howmany='$qwr' where item='recordonline'";
	mysql_query($sql);
}

$sql = "SELECT count( * ) FROM `tb_history`";
        $result = mysql_query($sql);
            	$viplat=mysql_result($result,0,0);

    	

$res=mysql_query("select startdate from tb_site where id='1'");
$res=mysql_fetch_array($res);
$sd=$res["startdate"];
$d0=strtotime($sd);
$d1=time();
$d=($d1-$d0)/(24*3600);
$vozrast=ceil($d);
$sql="select sum(visits) from tb_users";
$res=mysql_query($sql);
$prosmotreno=mysql_result($res,0,0);
$sql="select sum(money) from tb_users where user_status='user'";
$pes=mysql_query($sql);
$deneg=mysql_result($pes,0,0);
$denegna=round($deneg,2);

	$sql = "SELECT count( * ) FROM `tb_payme`";
	$result = mysql_query($sql);
        $zdut=mysql_result($result,0,0);

$res=mysql_query("select username from tb_users where user_status='admin' order by id asc");
$res=mysql_fetch_array($res);
$admin=$res["username"];

$res=mysql_query("select count(*) as kolvo from users_online where user='$admin'");
$res=mysql_fetch_array($res);
if($res["kolvo"]>0)
{
$adminonline="<center><b>Администрация: <span style=\"color:#00dd00\">on-line</span><br>";
}else{
$adminonline="<center><b>Администрация: <span style=\"color:#ff0000\">off-line</span><br>";
}

	
$sqryvar="Select sum(amount) from tb_history";
$iqryvar=mysql_query($sqryvar);
$tot1=mysql_result($iqryvar,0,0);
$totals=$tot1;
if ($totals==''){
	$totalpaid='0.00';
} else{
	$totalpaid=$tot1;
}
$viplacheno=round($totalpaid,2);

$sqryvar="Select sum(visits) from tb_users";
$iqryvar=mysql_query($sqryvar);
$tot1=mysql_result($iqryvar,0,0);
$clickserved=$tot1;

$res=mysql_query("select valuta from tb_site where id='1'");
$valuta=mysql_result($res,0,0);

mysql_close($con);
?>

<table width="100%" style="border-bottom: 2px #000 solid">

<tr>
<td>Клик:</td>
<td><?=$valuta ?>&nbsp;<?=$clck ?></td>
</tr>
<tr>
<td>Реф. клик:</td>
<td><?=$valuta ?>&nbsp;<?=$refclck?></td>
</tr>
<tr>
<td>Мин. к выплате:</td>
<td><?=$valuta ?>&nbsp;<?=$minimalka?></td>
</tr>
<tr>
<td>Пользователей:</td>
<td><?php echo $pemail_exist; ?></td>
</tr>
<td>Сегодня новых:</td>
<td>
<?=$nov?>
</td>
</tr>
<tr>
<td>Сейчас работают:</td>
<td><?=$tot1?></td>
</tr>
<tr>
<td><div id="ahref"><a href="online.php">Онлайн:</a></div></td>
<td><?php include("onlinesql.php"); ?>
</td>
</tr>

<tr>
<td>Выплат:</td>
<td><?=$viplat ?></td>
</tr>
<tr>
<td>Выплачено:</td>
<td><?=$valuta ?>&nbsp;<?=$viplacheno ?></td>
</tr>
<tr>
<td>Просмотрено:</td>
<td><?=$prosmotreno ?></td>
</tr>
<tr>
<td>Сайту (дней):</td>
<td>
<?=$vozrast ?>
</td>
</tr>
<tr><td>Денег на счетах:</td>
<td><?=$valuta ?>&nbsp;
<?=$denegna ?>
</td>
</tr>
<tr>
<td><div id="ahref"><a href="waitpay.php">Ожидают выплату:</a></div></td>
<td>
<?=$zdut?>
</td>
</tr>
</table>
<br>
<?=$adminonline ?>