outbox.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]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<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 colspan=3>
       <font color=<%=fontcolormisc%>><b>欢迎使用您的短消息发送，<%=cookiename%></b></font>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> align=center colspan=3>
      <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>
    　<a href="javascript:openscript2('friendlist.jsp',420,320)"><img src=images/friendpm.gif border=0 alt="打开好友录" class="gray" width=50 height=40></a>
     </td>
    </tr>
    <tr>
     <td bgcolor=<%=miscbackone%> align=center><font color=<%=fontcolormisc%>><b>收件人</b></td>
     <td bgcolor=<%=miscbackone%> align=center><font color=<%=fontcolormisc%>><b>主题</b></td>
     <td bgcolor=<%=miscbackone%> align=center><font color=<%=fontcolormisc%>><b>删除</b></td>
    </tr>
<%
if(submit.equals("delete")) {
  tempSTR=request.getParameter("msgid");
  if(tempSTR!=null && !tempSTR.equals(""))
     msgid=Integer.parseInt(tempSTR);
  if(msgid!=0) {
     deleteok=connect.executeUpdate("delete from webqq where id="+msgid);
     if(deleteok)
       deleteinfo="已经成功删除了您选中的短消息！";
     else
       deleteinfo="删除出错！请联系管理员！";
  }
}
else if(submit.equals("deleteall")) {
  deleteok=connect.executeUpdate("delete from webqq where fromname='"+cookiename+"' and operation='send'");
  if(deleteok)
     deleteinfo="您已经成功删除了您的发件箱中的所有消息！";
  else
     deleteinfo="删除出错！请联系管理员！";
}
if(!submit.equals("")) {
%>
    <tr>
     <td bgcolor=<%=miscbackone%> align=center colspan=3>
       <font color=<%=fontcolormisc%>><b><%=deleteinfo%></b></font>
     </td>
    </tr>
<%
}
rs=connect.executeQuery("select id,toname,title from webqq where fromname='"+cookiename+"' and operation='send' order by sendat desc");
while(rs.next()) {
  msgid=rs.getInt(1);
  msgtoname=rs.getString(2);
  msgtitle=rs.getString(3);
%>
    <tr>
     <td bgcolor=<%=miscbackone%> align=center><font color=<%=fontcolormisc%>><%=msgtoname%></td>
     <td bgcolor=<%=miscbackone%>><font color=<%=fontcolormisc%>><a href=messanger.jsp?action=msgread&msgid=<%=msgid%>><%=msgtitle%></a></td>
     <td bgcolor=<%=miscbackone%> align=center><font color=<%=fontcolormisc%>><input type=button value='删' onClick="location.href='messanger.jsp?action=<%=action%>&submit=delete&msgid=<%=msgid%>'" style="BORDER-RIGHT: #ff9933 1px solid; BORDER-TOP: #ff9933 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #ff9933 1px solid; COLOR: #ff6633; BORDER-BOTTOM: #ff9933 1px solid; FONT-FAMILY: 宋体; HEIGHT: 18px; BACKGROUND-COLOR: #ffffff; CURSOR:hand"></td>
    </tr>
<%
}
%>
    <tr>
     <td bgcolor=<%=miscbacktwo%> align=center colspan=3>
       <font color=<%=fontcolormisc%>>
       <a href=messanger.jsp?action=<%=action%>&submit=deleteall>[删除所有]</a>
     </td>
    </tr>
   </table>
  </td>
 </tr>
</table>