<?php
if(!defined('InEmpireCMS'))
{
exit();
}
?>
<?php
$public_diyr['pagetitle']='消息列表';
$url="<a href=../../../>首页</a> > <a href=../cp/>会员中心</a> > 消息列表 (<a href='AddMsg/?enews=AddMsg'>发送消息</a>)";
require(ECMS_PATH.'e/template/incfile/header.php');
?>
<script>
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'chkall')
e.checked = form.chkall.checked;
}
}
</script>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<tr>
<td width="50%" height="30" bgcolor="#FFFFFF"> </td>
<td width="50%" bgcolor="#FFFFFF"><div align="right">[<a href="AddMsg/?enews=AddMsg">发送消息</a>] </div></td>
</tr>
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder">
<form name="listmsg" method="post" action="../doaction.php" onsubmit="return confirm('确认要删除?');">
<tr class="header">
<td width="4%" height="23"> <div align="center"></div></td>
<td width="45%"><div align="center">标题</div></td>
<td width="18%"><div align="center">发送者</div></td>
<td width="23%"><div align="center">发送时间</div></td>
<td width="10%"><div align="center">操作</div></td>
</tr>
<?php
while($r=$empire->fetch($sql))
{
$img="haveread";
if(!$r[haveread])
{$img="nohaveread";}
//后台管理员
if($r['isadmin'])
{
$from_username="<a title='后台管理员'><b>".$r[from_username]."</b></a>";
}
else
{
$from_username="<a href='../ShowInfo/?userid=".$r[from_userid]."' target='_blank'>".$r[from_username]."</a>";
}
//系统信息
if($r['issys'])
{
$from_username="<b>系统消息</b>";
$r[title]="<b>".$r[title]."</b>";
}
?>
<tr bgcolor="#FFFFFF">
<td height="25"> <div align="center">
<input name="mid[]" type="checkbox" id="mid[]2" value="<?=$r[mid]?>">
</div></td>
<td> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="9%"><div align="center"><img src="../../data/images/<?=$img?>.gif" border=0></div></td>
<td width="91%"><a href="ViewMsg/?mid=<?=$r[mid]?>">
<?=stripSlashes($r[title])?>
</a></td>
</tr>
</table></td>
<td><div align="center">
<?=$from_username?>
</div></td>
<td><div align="center">
<?=$r[msgtime]?>
</div></td>
<td> <div align="center"> [<a href="../doaction.php?enews=DelMsg&mid=<?=$r[mid]?>" onclick="return confirm('确认要删除?');">删除</a>]</div></td>
</tr>
<?php
}
?>
<tr bgcolor="#FFFFFF">
<td><div align="center">
<input type=checkbox name=chkall value=on onclick=CheckAll(this.form)>
</div></td>
<td colspan="4"><input type="submit" name="Submit2" value="删除选中">
<input name="enews" type="hidden" value="DelMsg_all"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td><div align="center"></div></td>
<td colspan="4">
<?=$returnpage?> </td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="23" colspan="5"><div align="center">说明：<img src="../../data/images/nohaveread.gif" width="14" height="11">
代表未阅读消息，<img src="../../data/images/haveread.gif" width="15" height="12">
代表已阅读消息.</div></td>
</tr>
</form>
</table>
<?php
require(ECMS_PATH.'e/template/incfile/footer.php');
?>再看就更加明白了：
<?php
require("../../class/connect.php");
require("../../class/q_functions.php");
require("../../class/db_sql.php");
require("../class/user.php");
require "../".LoadLang("pub/fun.php");
$link=db_connect();
$empire=new mysqlquery();
$editor=1;
eCheckCloseMods('member');//关闭模块
$user=islogin();
$start=0;
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$add='';
$search='';
$line=20;//每行显示
$page_line=10;
$offset=$page*$line;
$totalquery="select count(*) as total from {$dbtbpre}enewsqmsg where to_username='$user[username]'";
$query="select mid,title,haveread,from_userid,from_username,isadmin,msgtime,issys from {$dbtbpre}enewsqmsg where to_username='$user[username]'";
$num=$empire->gettotal($totalquery);
$query.=" order by mid desc limit $offset,$line";
$sql=$empire->query($query);
$returnpage=page1($num,$line,$page_line,$start,$page,$search);
//导入模板
require(ECMS_PATH.'e/template/member/msg.php');
db_close();
$empire=null;
?>
|
