msgread.jsp

BBS系统

<%
/*##################################################################**
**#  LyBBS ver 1.2.b2 (1.2.beta-2版) / 凌云论坛 ver 1.2.b2         #**
**#                                                                #**
**#  版权所有: 凌云工作室 (原流星电脑工作室)                       #**
**#                                                                #**
**#  制作人  : 星语凌 『teddy (Yongshan Ye)』                      #**
**#                                                                #**
**#  主页地址: http://www.unix-now.com/lybbs   凌云论坛主页        #**
**#            http://www.ierp.info/lybbs      凌云论坛镜像站      #**
**#            http://[e-mail]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<%
tempSTR=request.getParameter("msgid");
if(tempSTR!=null && !tempSTR.equals(""))
  msgid=Integer.parseInt(tempSTR);
rs=connect.executeQuery("select fromname,title,message,date_format(sendat,'%Y年%m月%d日 %H:%i') as sendat,toname from webqq where id="+msgid);
if(rs.next()) {
  msgfromname=rs.getString(1);
  msgtitle=rs.getString(2);
  msgmessage=rs.getString(3);
  msgsendat=rs.getString(4);
  msgtoname=rs.getString(5);
}
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
 <tr>
  <td>
   <table cellpadding=3 cellspacing=1 border=0 width=100%>
    <tr>
     <td bgcolor=<%=miscbacktwo%> align=center>
       <font color=<%=fontcolormisc%>><b>欢迎使用您的收件箱，<%=cookiename%></b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> align=center>
<%
if(msgtoname.equals(cookiename) || msgfromname.equals(cookiename)) {
   connect.executeUpdate("update webqq set viewed='1' where id="+msgid+" and viewed='0'");
%>
      <a href="messanger.jsp?action=inbox&submit=delete&msgid=<%=msgid%>"><img src=images/deletepm.gif border=0 alt="删除消息" class="gray" width=45 height=40></a>
<%
}
%>
      <a href=messanger.jsp?action=inbox><img src=images/inboxpm.gif border=0 alt="收件箱" class="gray" width=50 height=40></a>
      <a href=messanger.jsp?action=outbox><img src=images/outboxpm.gif border=0 alt="发件箱" class="gray" width=50 height=40></a>
      <a href=messanger.jsp?action=msgsend&method=new><img src=images/newpm.gif border=0 alt="发送消息" class="gray" width=50 height=40></a>
<%
if(msgtoname.equals(cookiename)) {
%>
      <a href="messanger.jsp?action=msgsend&method=reply&msgid=<%=msgid%>"><img src=images/replypm.gif border=0 alt="回复消息" class="gray" width=50 height=40></a>
      <a href="messanger.jsp?action=msgsend&method=feedback&msgid=<%=msgid%>"><img src=images/fwpm.gif border=0 alt="转发消息" class="gray" width=50 height=40></a>
<%
}
%>
      <a href="javascript:openscript2('friendlist.jsp',420,320)"><img src=images/friendpm.gif border=0 alt="打开好友录" class="gray" width=45 height=40></a>
     </td>
    </tr>
<%
if(msgtoname.equals(cookiename) || msgfromname.equals(cookiename)) {
%>
    <tr>
     <td bgcolor=<%=miscbacktwo%> align=center>
       <font color=<%=fontcolormisc%>>消息来自<b><%=msgfromname%></b>，发送给您的时间：<b><%=msgsendat%></b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=top>
       <font color=<%=fontcolormisc%>><b>消息标题：<%=msgtitle%></b>
        <p><%=msgmessage%>
        <br>
       </font>
     </td>
    </tr>
<%
}
else {
%>
    <tr>
     <td bgcolor=<%=miscbackone%> valign=middle align=center>
      <font face=宋体 color=<%=fontcolormisc%>><b>错误： 打开消息</b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbacktwo%> valign=middle>
      <font face=宋体 color=<%=fontcolormisc%>>
       <b>关于 阅读消息 的详细错误原因</b>
       <ul>
        <li><b>您打开了不属于您的短消息！</b>
        <li>你是否仔细阅读了<a href="help.jsp">帮助文件</a>？
       </ul>
       <br><br>
       <center><a href="javascript:history.go(-1)"> &lt;&lt; 返回上一页</a></center>
      </font>
     </td>
    </tr>
<%
}
%>
   </table>
  </td>
 </tr>
</table>