Файл: public_html/sitestats.php
Строк: 123
<?
include('config.php');
$checkpemail = mysql_query("SELECT id FROM tb_users");
$pemail_exist = mysql_num_rows($checkpemail);
$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;
}
$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 ?> <?php include('config.php');
$sql = "SELECT * FROM tb_config WHERE item='click' and howmany='1'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$clck=$row["price"];
mysql_close($con);
echo $clck;
?></td>
</tr>
<tr>
<td>Реф. клик:</td>
<td><?=$valuta ?> <?php include('config.php');
$sql = "SELECT * FROM tb_config WHERE item='referalclick' and howmany='1'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row["price"];
mysql_close($con);?></td>
</tr>
<tr>
<td>V.I.P. Клик:</td>
<td><?=$valuta ?> <?php include('config.php');
$sql = "SELECT * FROM tb_config WHERE item='vipclick' and howmany='1'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$clck=$row["price"];
mysql_close($con);
echo $clck;
?></td>
</tr>
<tr>
<td>V.I.P. Реф. клик:</td>
<td><?=$valuta ?> <?php include('config.php');
$sql = "SELECT * FROM tb_config WHERE item='viprefclick' and howmany='1'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row["price"];
mysql_close($con);?></td>
</tr>
<tr>
<td>Мин. к выплате:</td>
<td><?=$valuta ?> <?php include('config.php');
$sql = "SELECT * FROM tb_config WHERE item='payment' and howmany='1'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row["price"];
mysql_close($con);
?></td>
</tr>
<tr>
<td>Пользователей:</td>
<td><?php echo $pemail_exist; ?></td>
</tr>
<td>Сегодня новых:</td>
<td>
<?php include('config.php');
$dc=date("d.m.Y");
$sql="select * from tb_users where joindate='$dc'";
$result=mysql_query($sql);
$nov=mysql_num_rows($result);
echo $nov;
?>
</td>
</tr>
<tr>
<td>V.I.P. пользователей:</td>
<td><?php include('config.php');
$sql = "SELECT count( * ) FROM tb_users where account='V.I.P.'";
$result = mysql_query($sql);
$tot1=mysql_result($result,0,0);
echo $tot1;
mysql_close($con);
?></td>
</tr>
<tr>
<td>Сейчас работают:</td>
<td><?php include('config.php');
$sql = "SELECT count( * ) FROM users_online where urlpage='<font color=#ff0000>Зарабатывает</font>'";
$result = mysql_query($sql);
$tot1=mysql_result($result,0,0);
echo $tot1;
mysql_close($con);
?></td>
</tr>
<tr>
<td>Онлайн:</td>
<td><?php include("onlinesql.php"); ?><a href="online.php">[?]</a>
<?
require('config.php');
$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);
}
mysql_close($con);
?>
</td>
</tr>
<tr>
<td>Выплат:</td>
<td><?php include('config.php');
$sql = "SELECT count( * ) FROM `tb_history`";
$result = mysql_query($sql);
$tot1=mysql_result($result,0,0);
echo $tot1;
mysql_close($con);
?></td>
</tr>
<tr>
<td>Выплачено:</td>
<td><?=$valuta ?> <?php echo round($totalpaid,2)?></td>
</tr>
<tr>
<td>Просмотрено:</td>
<td><?
require('config.php');
$sql="select sum(visits) from tb_users";
$res=mysql_query($sql);
$ret=mysql_result($res,0,0);
echo $ret;
mysql_close($con);
?></td>
</tr>
<tr>
<td>Сайту (дней):</td>
<td>
<?
require('config.php');
$res=mysql_query("select startdate from tb_site where id='1'");
$res=mysql_fetch_array($res);
$sd=$res["startdate"];
mysql_close($con);
?>
<?
$d0=strtotime($sd);
$d1=time();
$d=($d1-$d0)/(24*3600);
echo ceil($d);
?>
</td>
</tr>
<tr><td>Денег на счетах:</td>
<td><?=$valuta ?>
<?
require('config.php');
$sql="select sum(money) from tb_users where user_status='user'";
$pes=mysql_query($sql);
$deneg=mysql_result($pes,0,0);
mysql_close($con);
echo round($deneg,2);
?>
</td>
</tr>
<tr>
<td>Ожидают выплату:</td>
<td>
<?
require('config.php');
$sql = "SELECT count( * ) FROM `tb_payme`";
$result = mysql_query($sql);
$tot1=mysql_result($result,0,0);
echo $tot1;
mysql_close($con);
?><a href="waitpay.php">[?]</a>
</td>
</tr>
</table>
<br>
<?
require('config.php');
$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)
{
echo "<center><b>Администрация: <span style="color:#00dd00">on-line</span><br>";
}else{
echo "<center><b>Администрация: <span style="color:#ff0000">off-line</span><br>";
}
mysql_close($con);
echo "Дата и время сервера: </b><span style="color:#ff0000">".date("d.m.Y H:i:s")."</span></center>";