message.php

VIP信息处理系统源码

<?
/**********************************
*	广告主留言管理
*	建立：2004-11-23　qinsy 
*	最后修改：2004-11-23　qinsy
***********************************/
include_once("../adser/top.php");

$pagesize=$cfg_adserpagesize;
$list_count="message where s_id='0' and username='$_SESSION[adser_username]' and (to_type='4' or to_type='3')";
$sql="select * from message where s_id='0' and username='$_SESSION[adser_username]' and (to_type='4' or to_type='3') order by time desc";
include("../public/pagehead.php");
$str_disp="";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs)){
	$tit=$row[tit];//主题
  	$time=$row["time"];//时间
	$to_type=$row[to_type];
	$is_view=$row[is_view];
	
	////判断是否已回复、已查阅
	$sql_board="select * from message where s_id='$row[id]' order by id desc";
	$rs_board=mysql_query($sql_board);
	$int_numrows=mysql_num_rows($rs_board);
	if($int_numrows<1){
		if($to_type==3){
			$str_viewstate="未回复";
		}else{
			$str_viewstate=($is_view==0)?"<font color=#ff6600>未查阅</font>":"<font color=999999>已查阅</font>";
			$viewstate=($is_view==0)?"1":"2";
		}
	}else{
		$row_board=mysql_fetch_array($rs_board);
		$s_totype=$row_board[to_type];
		$is_view=$row_board[is_view];
		if($s_totype==3){
			$str_viewstate="未回复";
		}else{
			$str_viewstate=($is_view==0)?"<font color=#ff6600>未查阅</font>":"<font color=999999>已查阅</font>";
			$viewstate=($is_view==0)?"1":"2";
		}	
	}
	
	$str_disp.="
		<tr align=center class=\"listbody\">
			<td align=left><a href='message_view.php?id=$row[id]&viewstate=$viewstate'>$tit</a></td>
			<td width=120>$time</td>
			<td width=50>$str_viewstate</td>
		</tr>";
}

?>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
<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="40" class="orange_text">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td height="30" align="left" valign="middle"><img src="../image/ab13.gif" width="150" 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="100%" border="0" cellpadding="0" cellspacing="0">
                            <tr align="center" valign="middle">
                              <td width="3%"><img src="../image/bot14.gif" width="16" height="16"></td>
                              <td width="19%" align="left"><a href="message_add.php?tit=留言管理"><span class="bluetext">关于本问题给我们留言</span></a></td>
                              <td width="2%"><img src="../image/bot13.gif" width="16" height="16"></td>
                              <td width="47%" align="left"><span class="orange_text">电话：<?=$cfg_phone?></span></td>
                              <td width="29%" align="right"><a href="message_add.php"><span class="bluetext">添加新留言</span></a></td>
                            </tr>
                        </table></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">
        <tr align="center" class="listbody">
			<td class="listtbhd" align="left">留言主题</td>
			<td class="listtbhd" width=120>留言时间</td>
			<td class="listtbhd" width=50>状态</td>
        </tr>
        <?=$str_disp?>
      </table>
		<table width="98%" border="0" cellpadding="0" cellspacing="0">
		  <tr>
			<td>
			<?
			  $pagestr="";
			  include("../public/pagefoot.php");
			?></td>
		  </tr>
		</table>
    <p><br>
          <br>
          <br>
          <br>
	  </p></td>
  </tr>
</table>
<?
include("foot.php");
?>