<%@ 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 i = 0; %> <% String user = (String)request.getSession(true).getAttribute("user"); DB db = null; Table r = null; try { db = DB.openConnection(); r = db.query("select uid,gid,fname,lname,points from users "+ "where user = \'"+user+"\'"); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } int uid = 0; int gid = 0; int points = 0; String fname = ""; String lname = ""; if(r.next()) { uid = Integer.parseInt(r.getString(0)); gid = Integer.parseInt(r.getString(1)); fname = r.getString(2); lname = r.getString(3); points = Integer.parseInt(r.getString(4)); } try { r = db.query("select gname from groups where gid = "+gid); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } String group = ""; if(r.next()) { group = r.getString(0); } request.getSession(true).putValue("uid",new Integer(uid)); request.getSession(true).putValue("gid",new Integer(gid)); %> Main Page

<%= fname %> <%= lname %>

[Log Out]

User Information
Username: <%= user %>
Group: <%= group %>
Points: <%= points %>

Contests [Propose Contest]
<% r = null; try { r = db.query( "select contests.id,games.name"+ " from contests,games"+ " where contests.type = 3 and"+ " (contests.togid ="+gid+ " or contests.fromgid ="+gid+ ") and games.id = contests.game" ); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } %> <% i = 0; while(r.next()) { Table temp = db.query("select count(*) from scores "+ "where uid="+uid+" and "+ "id="+Integer.parseInt(r.getString(0))); temp.absolute(0); int scored = Integer.parseInt(temp.getString(0)); if((i++%2) == 0) { out.println(""); if( scored > 0 ) out.println(""); else out.println(""); } else { out.println(""); if( scored > 0 ) out.println(""); else out.println(""); } } %>
"+r.getString(1)+"[Scored]
[Post Score]
"+r.getString(1)+"[Scored]
[Post Score]

Challenges
<% r = null; try { r = db.query( "select contests.id,games.name,contests.fromgid"+ " from contests,games"+ " where contests.type = 2 and "+ " togid ="+gid+ " and games.id = contests.game" ); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } %> <% i = 0; while(r.next()) { Table temp = db.query("select count(*) from votes "+ "where uid="+uid+" and "+ "id="+Integer.parseInt(r.getString(0))); temp.absolute(0); int voted = Integer.parseInt(temp.getString(0)); if((i++%2) == 0) { out.println(""); if( voted > 0 ) out.println(""); else out.println(""); } else { out.println(""); if( voted > 0 ) out.println(""); else out.println(""); } } %>
"+r.getString(1)+"Voted
[Vote]
"+r.getString(1)+"Voted
[Vote]

Proposals
<% r = null; try { r = db.query( "select contests.id,games.name,contests.togid"+ " from contests,games"+ " where contests.type = 1 and "+ " fromgid ="+gid+ " and games.id = contests.game" ); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } %> <% i = 0; while(r.next()) { System.out.println(r); Table temp = db.query("select count(*) from votes "+ "where uid="+uid+" and "+ "id="+Integer.parseInt(r.getString(0))); temp.absolute(0); int voted = Integer.parseInt(temp.getString(0)); if((i++%2) == 0) { out.println(""); if( voted > 0 ) out.println(""); else out.println(""); } else { out.println(""); if( voted > 0 ) out.println(""); else out.println(""); } } %>
"+r.getString(1)+"Voted
[Vote]
"+r.getString(1)+"Voted
[Vote]

Messages [Post Message]
<% r = null; try { r = db.query("select id,postdate,subject from messages where gid ="+gid); } catch( Exception e ) { System.out.println(e); e.printStackTrace(); } %> <% i = 0; while(r.next()) { String d = new java.util.Date(Long.parseLong(r.getString(1))).toString(); if((i++%2) == 0) { out.println(""+ ""); } else { out.println(""+ ""); } } %>
SubjectDate
"+ ""+ r.getString(2)+""+d+"
"+ ""+ r.getString(2)+""+d+"