📄 stats.php
字号:
<?
include_once("myconnect.php");
function main()
{
$stats=mysql_fetch_array(mysql_query("select * from sbbleads_stats"));
$config=mysql_fetch_array(mysql_query("select * from sbbleads_config"));
?>
<table width="100%" border="0" cellspacing="10" cellpadding="2" class="maintablestyle">
<tr>
<td valign="top"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" class="onepxtable">
<tr valign="top">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td height="25" colspan="2" class="titlestyle"> Site
Stats</td>
</tr>
<tr valign="top">
<td ><table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr valign="middle" class="onepxtable">
<td height="25" align="right" class="subtitle"> <div align="right">Online
Users </div></td>
<td height="25" class="innertablestyle" ><p><font class="smalltext">
<?php
$sql="Select count(*) from sbbleads_online " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
-
<?php
$sql="Select count(*) from sbbleads_online where sb_uid>0 " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
[ Members ],
<?php
$sql="Select count(*) from sbbleads_online where sb_uid<0 " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
[ Visitors ] </font><font class="normal"> </font></p></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Sell Offers </div></td>
<td height="25" class="innertablestyle" ><p><font class="smalltext">
<?php
$sql="Select count(*) from sbbleads_offers where sb_approved='yes' and DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_sell"]." MONTH) > NOW() " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
</font><font class="normal"> </font></p></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Buy Offers </div></td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$sql="select count(*) from sbbleads_offers_buy where sb_approved='yes' and DATE_ADD(sb_postedon,INTERVAL ".$config["sb_expiry_buy"]." MONTH) > NOW() " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
</font> </td>
</tr>
<tr valign="middle" class="onepxtable">
<td height="25" align="right" class="subtitle"> <div align="right">Product
Catalogs </div></td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$sql="Select count(*) from sbbleads_products where sb_approved='yes'" ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Company Profiles </div></td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$sql="Select count(*) from sbbleads_companyprofiles where sb_approved='yes' " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Registered Members </div></td>
<td height="25" class="innertablestyle"><p><font class="smalltext">
<?php
$sql="Select count(*) from sbbleads_members where sb_suspended='no'" ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
-
<?php
$sql="Select count(*) from sbbleads_members where sb_memtype=1 and sb_suspended='no'" ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
$level=mysql_fetch_array(mysql_query("select * from sbbleads_levels where sb_levelid=1"));
echo " [ ".$level["sb_levelname"]." ]";
?>
,
<?php
$sql="Select count(*) from sbbleads_members where sb_memtype=2 and sb_suspended='no'" ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
$level=mysql_fetch_array(mysql_query("select * from sbbleads_levels where sb_levelid=2"));
echo " [ ".$level["sb_levelname"]." ]";
?>
,
<?php
$sql="Select count(*) from sbbleads_members where sb_memtype=3 and sb_suspended='no'" ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
$level=mysql_fetch_array(mysql_query("select * from sbbleads_levels where sb_levelid=3"));
echo " [ ".$level["sb_levelname"]." ]";
?>
</font></p></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Hits Last Month </div></td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
echo $stats["sb_hits_lastmonth"];
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Hits in All </div></td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
echo $stats["sb_hits"];
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td width="40%" height="25" align="right" class="subtitle">
<div align="right">Messages Sent </div></td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
echo $stats["sb_msg_cnt"];
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td height="25" align="right" valign="top" class="subtitle">Top
5 Sell Categories </td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$rst_query=mysql_query("select sb_pid from sbbleads_categories" );
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["sb_pid"];}
$cnt=1;
$sql="Select * from sbbleads_categories where
sb_id NOT IN (" . $clist.") order by sb_visit_sell desc LIMIT 0,5";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
$catpath=$rs_t["sb_cat_name"];
/* $catpath="";
$cat_query=mysql_query("Select * from sbbleads_categories
where sb_id=".$rs_t["sb_id"] );
while ($rs=mysql_fetch_array($cat_query))
{
$catpath =" > <a href=\"cat_sell.php?cid=" . $rs["sb_id"] . "\">
" .$rs["sb_cat_name"]."</a>".$catpath;
$cat_query=mysql_query("Select * from sbbleads_categories
where sb_id=" . $rs["sb_pid"] );
}*/
echo "<a href='cat_sell.php?cid=".$rs_t["sb_id"]."'>
".$catpath."</a><br>";
}
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td height="25" align="right" valign="top" class="subtitle">Top
5 Buy Categories</td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$rst_query=mysql_query("select sb_pid from sbbleads_categories" );
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["sb_pid"];}
$cnt=1;
$sql="Select * from sbbleads_categories where
sb_id NOT IN (" . $clist.") order by sb_visit_buy desc LIMIT 0,5";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
$catpath=$rs_t["sb_cat_name"];
/* $catpath="";
$cat_query=mysql_query("Select * from sbbleads_categories
where sb_id=".$rs_t["sb_id"] );
while ($rs=mysql_fetch_array($cat_query))
{
$catpath =" > <a href=\"cat_sell.php?cid=" . $rs["sb_id"] . "\">
" .$rs["sb_cat_name"]."</a>".$catpath;
$cat_query=mysql_query("Select * from sbbleads_categories
where sb_id=" . $rs["sb_pid"] );
}*/
echo "<a href='cat_buy.php?cid=".$rs_t["sb_id"]."'>
".$catpath."</a><br>";
}
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td height="25" align="right" valign="top" class="subtitle">Top
5 Product Categories</td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$rst_query=mysql_query("select sb_pid from sbbleads_categories" );
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["sb_pid"];}
$cnt=1;
$sql="Select * from sbbleads_categories where
sb_id NOT IN (" . $clist.") order by sb_visit_product desc LIMIT 0,5";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
$catpath=$rs_t["sb_cat_name"];
/* $catpath="";
$cat_query=mysql_query("Select * from sbbleads_categories
where sb_id=".$rs_t["sb_id"] );
while ($rs=mysql_fetch_array($cat_query))
{
$catpath =" > <a href=\"cat_sell.php?cid=" . $rs["sb_id"] . "\">
" .$rs["sb_cat_name"]."</a>".$catpath;
$cat_query=mysql_query("Select * from sbbleads_categories
where sb_id=" . $rs["sb_pid"] );
}*/
echo "<a href='cat_products.php?cid=".$rs_t["sb_id"]."'>
".$catpath."</a><br>";
}
?>
</font></td>
</tr>
<tr valign="middle" class="onepxtable">
<td height="25" align="right" valign="top" class="subtitle">Top
5 Profile Categories</td>
<td height="25" class="innertablestyle"><font class="smalltext">
<?php
$rst_query=mysql_query("select sb_pid from sbbleads_categories" );
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["sb_pid"];}
$cnt=1;
$sql="Select * from sbbleads_categories where
sb_id NOT IN (" . $clist.") order by sb_visit_profile desc LIMIT 0,5";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
$catpath=$rs_t["sb_cat_name"];
/* $catpath="";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -