adser_viewall.php

VIP信息处理系统源码

<?
include_once("../adser/top.php");

/* 取得账户余额 */
$rowu=mysql_fetch_array(mysql_query("select balance,admin_stat from advertizer where username='$_SESSION[adser_username]'"));
$balance=$rowu["balance"];
$admin_stat=$rowu["admin_stat"];

/* 取得广告数量 */
$sqla="select count(id) as total from ads where username='$_SESSION[adser_username]' and own_type='1' and ads_stat='2'";
$rsa=mysql_query($sqla);
$rowa=mysql_fetch_array($rsa);

$sqls="select sum(open_num) as opentot, sum(click_num) as clicktot, sum(tot_o_num) as opentt,  sum(tot_c_num) as clicktt  from ads where username='$_SESSION[adser_username]' and own_type='1'";
$rss=mysql_query($sqls);
$rows=mysql_fetch_array($rss);

$sqll="select max(last_o_time) as lot,max(last_c_time) as lct from ads where username='$_SESSION[adser_username]' and own_type='1' and ads_stat='2'";
$rsl=mysql_query($sqll);
$rowl=mysql_fetch_array($rsl);

?>
<table width="1001" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#f7f7f7">
  <tr>
    <td width="200" height="323" valign="top" bgcolor="#E8EEF4">
    <?
	include("menu.php");
	?></td>
    <td align="center" valign="top" class="bgconn">
	<table width="98%" border="0" cellpadding="0" cellspacing="0" >
          <tr>
            <td height="40" class="orange_text"> 
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  
                <td height="30" align="left" valign="middle"><img src="../image/ab3.gif" width="121" height="20"></td>
                </tr>
                <tr>
                  <td align="center" valign="middle"> 
                    <table width="99%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td height="20" align="left" valign="middle">&nbsp;&nbsp;&nbsp;&nbsp;您当前的有关帐户信息，包括用户状态、帐户余额、有关广告信息等。</td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <tr>
                  <td height="25" align="left" valign="middle"> 
                    <table width="50%" border="0" cellpadding="0" cellspacing="0">
                      <tr align="center" valign="middle">
                        <td width="5%"><img src="../image/bot14.gif" width="16" height="16"></td>
                        <td width="52%" align="left"><a href="message_add.php?tit=当前帐户信息"><span class="bluetext">关于本问题给我们留言</span></a></td>
                        <td width="6%"><img src="../image/bot13.gif" width="16" height="16"></td>
                        <td width="37%" align="left"><span class="orange_text">电话：<?=$cfg_phone?></span></td>
                      </tr>
                    </table></td>
                </tr>
              </table></td>
          </tr>
		  <tr>
            <td height="4" bgcolor="#556D85" ></td>
          </tr>
		  <tr><td height="3"></td></tr>
        </table>
	<table width="98%" border="0" cellspacing="1" cellpadding="6" class="listtable">
     <form name="form1" method="post">
      <tr align="center" class="listbody">
              <td colspan="2" class="listtbhd"><div align="center" >当前帐户信息</div></td>
            </tr>
			<tr class="listbody"> 
			  <td width="26%"><div align="right">用　户　名 :</div></td>
			  <td width="74%"><?=$_SESSION["adser_username"]?></td>
			</tr>
			<tr class="listbody"> 
			  <td width="26%"><div align="right">当 前 状 态:</div></td>
			  <td width="74%"><?=$cfg_memberstat[$admin_stat]?></td>
			</tr>
			<tr class="listbody"> 
			  <td><div align="right">帐 户 余 额:</div></td>
			  <td><?=$balance?> 元</td>
          </tr>
			<tr class="listbody">
			  <td><div align="right">广 告 数 量:</div></td>
			  <td><?=$rowa["total"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">本日弹出次数: </div></td>
			  <td><?=$rows["opentot"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">本日点击次数:</div></td>
			  <td><?=$rows["clicktot"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">总共弹出次数: </div></td>
			  <td><?=$rows["opentt"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">总共点击次数:</div></td>
			  <td><?=$rows["clicktt"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">最后弹出时间:</div></td>
			  <td><?=$rowl["lot"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">最后点击时间:</div></td>
			  <td><?=$rowl["lct"]?></td>
		    </tr>
			<tr class="listbody">
			  <td><div align="right">操　　　　作:</div></td>
			  <td><input type="button" name="Submit" value="帐户充值" class="subbt" onClick="location='adser_pay.php'">
		      <input type="button" name="Submit2" value="申请支付余额" class="subbt" onClick="location='adser_apply.php'"></td>
		    </tr>
          </form>
        </table>
        <p><br>
		<br>
		<br>
		<br>
		</p></td>
    </tr>
  </table>
<?
include("foot.php");
?>