<%@ page language="java" %> <%@ page import="com.xoomers.util.*" %> <%@ page import="com.xoomers.db.*" %> <% Boolean auth=(Boolean)request.getSession(true).getAttribute("authenticated"); if (auth==null ||!(auth.booleanValue())) { %> <% } %> <%! int id = 0; %> <%! int uid = 0; %> <%! int togid = 0; %> <%! int fromgid = 0; %> <%! int game = 0; %> <%! DB db = null; %> <%! Table games = null; %> <%! Table userinfo = null; %> <%! Table groups = null; %> <%! Table props = null; %> <% if( request.getParameter("id") != null ) id = Integer.parseInt(request.getParameter("id")); if( id != 0 ) { try { db = DB.openConnection(); props = db.query("select togid,game from proposals"); props.absolute(0); togid = Integer.parseInt(props.getString(0)); game = Integer.parseInt(props.getString(0)); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } } try { db = DB.openConnection(); games = db.query("select * from games"); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } try { db = DB.openConnection(); groups = db.query("select * from groups"); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } String user = (String)request.getSession(true).getAttribute("user"); try { db = DB.openConnection(); userinfo = db.query("select uid,gid from users where user=\'"+user+"\'"); userinfo.absolute(0); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } uid = Integer.parseInt(userinfo.getString(0)); fromgid = Integer.parseInt(userinfo.getString(1)); %> Post Proposal

Propose a challenge...

Message ID = <%= id %> UID = <%= uid %> GID = <%= fromgid %>

Points:
Challenge:	"); out.println("
Game:	"); out.println("