<%@ page language="java" %> <%@ page import="com.xoomers.util.*" %> <%@ page import="com.xoomers.db.*" %> <%@ page import="java.util.*" %> <% Boolean auth=(Boolean)request.getSession(true).getAttribute("authenticated"); if (auth==null ||!(auth.booleanValue())) { %> <% } %> <% int msgid = Integer.parseInt(request.getParameter("msgid")); DB db = null; Table msginfo = null; Table userinfo = null; try { db = DB.openConnection(); msginfo = db.query("select uid,postdate,subject,body from messages "+ "where id = "+msgid); } catch( Exception e ) { System.out.println(e.toString()+"Error querying message"); e.printStackTrace(); } int userid = 0; String date = ""; String subject = ""; String body = ""; if( msginfo.next() ) { userid = Integer.parseInt(msginfo.getString(0)); date= new Date(Long.parseLong(msginfo.getString(1))).toString(); subject = msginfo.getString(2); body = msginfo.getString(3); } try { userinfo = db.query("select fname,lname,user from users "+ "where uid = "+userid); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } String fname = ""; String lname = ""; String user = ""; if(userinfo.next()) { fname = userinfo.getString(0); lname = userinfo.getString(1); user = userinfo.getString(2); } %> Message

From:<%= fname %> <%= lname %> (<%= user %>)
Date:<%= date %>
Subject:<%= subject %>
<%= body %>
[Post Reply] [Back]