📄 stats.php
字号:
$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_profiles.php?cid=".$rs_t["sb_id"]."'>
".$catpath."</a><br>";
}
?>
</font></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr valign="top">
<td> </td>
<td>
<table class="tdorange" width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" bgcolor="#f5f5f5" class="tdorange">
<div align="center"><strong><font color="#ff6600" size="2" face="Verdana, Arial, Helvetica, sans-serif">Sell
Section </font></strong></div></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><TABLE cellSpacing=2 cellPadding=0
align=center border=0>
<TBODY>
<TR>
<TD height="15"><font color="#FF6600" size="2" face="Verdana, Arial, Helvetica, sans-serif">Total<strong>
<?php
$sql="Select count(*) from sbbleads_selloffers " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
</strong>offers.</font></TD>
</TR>
<TR>
<TD height="15"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><strong><font color="#1F88BA" size="2" face="Arial, Helvetica, sans-serif">Top
Categories</font></strong></td>
</tr>
<tr>
<td>
<?php
//////////////////////////////////////////// Parent cats
$rst_query=mysql_query("select pid from sbbleads_categories" );
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["pid"];}
/* $sql="Select * from sbbleads_categories As R1 where id NOT IN (" . $clist.") ";
$rst_query=mysql_query($sql);
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["id"];}
*/
//////////////////////////////////////////////////////////
$cnt=1;
$sql="Select * from sbbleads_categories where id NOT IN (" . $clist.") order by visits_sell desc LIMIT 0,5";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="173"><font size="2" face="Arial, Helvetica, sans-serif">
<a href="categories_sell.php?cid=<?php echo $rs_t["id"] ;?>"><?php echo $rs_t["catname"] ;?></a>
<?php
///////////////////////////////////////////////
///////////////////////////////////////////////
///////////////////////////////////////////////
$rst_query=mysql_query("Select * from sbbleads_categories where pid=" . $rs_t["id"] );
$clist=$rs_t["id"];
while ( $rst=mysql_fetch_array($rst_query) )
{
$clist.="," . $rst["id"];
$thislist="-1";
while ( $rst=mysql_fetch_array($rst_query) ){ $clist.="," . $rst["id"];$thislist.="," . $rst["id"];}
$rst_query=mysql_query("Select * from sbbleads_categories where pid IN (" . $thislist . ")" );
}
//echo "[" . $clist . "]";
$rst1_query=mysql_query("Select count(*) from sbbleads_members,sbbleads_selloffers where sbbleads_members.id=sbbleads_selloffers.mid and sbbleads_members.suspended<>'Yes' and DATE_ADD(postedon,INTERVAL 60 DAY)>=now() and ( sbbleads_selloffers.cat1 IN (" . $clist . ")or sbbleads_selloffers.cat2 IN (" . $clist . ")or sbbleads_selloffers.cat3 IN (" . $clist . ")or sbbleads_selloffers.cat4 IN (" . $clist . ")or sbbleads_selloffers.cat5 IN (" . $clist . ")or sbbleads_selloffers.cat6 IN (" . $clist . ")or sbbleads_selloffers.cat7 IN (" . $clist . ")or sbbleads_selloffers.cat8 IN (" . $clist . ")or sbbleads_selloffers.cat9 IN (" . $clist . ")or sbbleads_selloffers.cat10 IN (" . $clist . "))" );
$rst1=mysql_fetch_array($rst1_query);
$selloffers=$rst1[0] ;
$rst1_query=mysql_query("Select count(*) from sbbleads_members,sbbleads_selloffers where sbbleads_members.id=sbbleads_selloffers.mid and sbbleads_members.suspended<>'Yes' and DATE_ADD(postedon,INTERVAL 5 DAY)>=now() and ( sbbleads_selloffers.cat1 IN (" . $clist . ")or sbbleads_selloffers.cat2 IN (" . $clist . ")or sbbleads_selloffers.cat3 IN (" . $clist . ")or sbbleads_selloffers.cat4 IN (" . $clist . ")or sbbleads_selloffers.cat5 IN (" . $clist . ")or sbbleads_selloffers.cat6 IN (" . $clist . ")or sbbleads_selloffers.cat7 IN (" . $clist . ")or sbbleads_selloffers.cat8 IN (" . $clist . ")or sbbleads_selloffers.cat9 IN (" . $clist . ")or sbbleads_selloffers.cat10 IN (" . $clist . "))" );
$rst1=mysql_fetch_array($rst1_query);
$sellnew=$rst1[0] ;
$rst1_query=mysql_query("Select count(*) from sbbleads_members,sbbleads_buyoffers where sbbleads_members.id=sbbleads_buyoffers.mid and sbbleads_members.suspended<>'Yes' and DATE_ADD(postedon,INTERVAL 60 DAY)>=now() and sbbleads_buyoffers.cat1 IN (" . $clist . ")");
$rst1=mysql_fetch_array($rst1_query);
$buyoffers=$rst1[0] ;
$sql="Select count(*) from sbbleads_members where profileposted='Yes' and showprofile='Yes' and suspended='No' and ( cat1 IN (" . $clist . ") or cat2 IN (" . $clist . ") or cat3 IN (" . $clist . ") or cat4 IN (" . $clist . ") or cat5 IN (" . $clist . ") or cat6 IN (" . $clist . ") or cat7 IN (" . $clist . ") or cat8 IN (" . $clist . ") or cat9 IN (" . $clist . ") or cat10 IN (" . $clist . ") )";
$rst1_query=mysql_query( $sql );
$rst1=mysql_fetch_array($rst1_query);
$companyprofiles=$rst1[0] ;
$tot=$selloffers + $buyoffers + $companyprofiles;
//echo "(" . $selloffers . "," . $buyoffers . "," . $companyprofiles .")";
echo "(" . $selloffers . " Offers )";
?>
<?
if ($sellnew!=0)
{
?>
<font color="#FF6600" size="1">New</font>
<?
}
////////////////////////////////////////////
////////////////////////////////////////////
////////////////////////////////////////////
?>
</font></td>
<td width="63"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $rs_t["visits_sell"] ;?>
Visits </font></td>
</tr>
</table>
<?php
$cnt++;
}
?>
</td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><TABLE cellSpacing=2 cellPadding=0 width=100%
align=center border=0>
<TBODY>
<TR>
<TD height="15"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><strong><font color="#1F88BA" size="2" face="Arial, Helvetica, sans-serif">Top
Keywords</font></strong></td>
</tr>
<tr>
<td>
<?php
$cnt=1;
$sql="Select keyword,count(*) as t from sbbleads_keywords where typeid=2 group by keyword having keyword<>'' order by t desc LIMIT 0,10 ";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="172"><font size="2" face="Arial, Helvetica, sans-serif">
<?php echo $rs_t["keyword"] ;?>
</font></td>
<td width="64"><font size="2" face="Arial, Helvetica, sans-serif"><?php echo $rs_t["t"] ;?>
Times</font></td>
</tr>
</table>
<?php
$cnt++;
}
?>
</td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
</tr>
<tr valign="top">
<td>
<table class="tdorange" width="240" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="tdorange" height="25" bgcolor="#f5f5f5">
<div align="center"><strong><font color="#ff6600" size="2" face="Verdana, Arial, Helvetica, sans-serif">Buy
Section </font></strong></div></td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td><TABLE cellSpacing=2 cellPadding=0
align=center border=0>
<TBODY>
<TR>
<TD height="15"><font color="#FF6600" size="2" face="Verdana, Arial, Helvetica, sans-serif">Total<strong>
<?php
$sql="Select count(*) from sbbleads_buyoffers " ;
$rs0_query=mysql_query($sql);
$rs0=mysql_fetch_array($rs0_query);
echo $rs0[0];
?>
</strong>offers.</font></TD>
</TR>
<TR>
<TD height="15"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><strong><font color="#ff6600" size="2" face="Arial, Helvetica, sans-serif">Top
Categories</font></strong></td>
</tr>
<tr>
<td>
<?php
//////////////////////////////////////////// Parent cats
$rst_query=mysql_query("select pid from sbbleads_categories" );
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["pid"];}
/* $sql="Select * from sbbleads_categories As R1 where id NOT IN (" . $clist.") ";
$rst_query=mysql_query($sql);
$clist="-1";
while ( $rst=mysql_fetch_array($rst_query) )
{ $clist.="," . $rst["id"];}
*/
//////////////////////////////////////////////////////////
$cnt=1;
$sql="Select * from sbbleads_categories where id NOT IN (" . $clist.") order by visits_buy desc LIMIT 0,5";
$rs_query_t=mysql_query($sql);
while($rs_t=mysql_fetch_array($rs_query_t))
{
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="173"><font size="2" face="Arial, Helvetica, sans-serif">
<a href="categories_buy.php?cid=<?php echo $rs_t["id"] ;?>"><?php echo $rs_t["catname"] ;?></a>
<?php
///////////////////////////////////////////////
///////////////////////////////////////////////
///////////////////////////////////////////////
$rst_query=mysql_query("Select * from sbbleads_categories where pid=" . $rs_t["id"] );
$clist=$rs_t["id"];
while ( $rst=mysql_fetch_array($rst_query) )
{
$clist.="," . $rst["id"];
$thislist="-1";
while ( $rst=mysql_fetch_array($rst_query) ){ $clist.="," . $rst["id"];$thislist.="," . $rst["id"];}
$rst_query=mysql_query("Select * from sbbleads_categories where pid IN (" . $thislist . ")" );
}
//echo "[" . $clist . "]";
$rst1_query=mysql_query("Select count(*) from sbbleads_members,sbbleads_selloffers where sbbleads_members.id=sbbleads_selloffers.mid and sbbleads_members.suspended<>'Yes' and DATE_ADD(postedon,INTERVAL 60 DAY)>=now() and ( sbbleads_selloffers.cat1 IN (" . $clist . ")or sbbleads_selloffers.cat2 IN (" . $clist . ")or sbbleads_selloffers.cat3 IN (" . $clist . ")or sbbleads_selloffers.cat4 IN (" . $clist . ")or sbbleads_selloffers.cat5 IN (" . $clist . ")or sbbleads_selloffers.cat6 IN (" . $clist . ")or sbbleads_selloffers.cat7 IN (" . $clist . ")or sbbleads_selloffers.cat8 IN (" . $clist . ")or sbbleads_selloffers.cat9 IN (" . $clist . ")or sbbleads_selloffers.cat10 IN (" . $clist . "))" );
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -