<%@page contentType="text/html; charset=iso-8859-1" session="true" language="java" %> <%@ page import="java.sql.*" %> <%@ page import="com.connection.*" %> <%@ page import="java.util.Date" %> <%@ page import="java.text.SimpleDateFormat" %> .:www.riveredace.com:.Home <% HttpSession sesion = request.getSession(true); Object playerId = session.getAttribute("playerId"); Object playerNick = session.getAttribute("playerNick"); Object email = session.getAttribute("email"); Object avatarUrl = session.getAttribute("avatarUrl"); if(session == null || session.getAttribute("playerId") == null){%> <%} int pId = ((Integer)playerId).intValue(); boolean isCompleted = false; boolean isActive = false; boolean isDisabled = false; boolean chatDisabled = false; boolean tournyPoints = false; String firstName = ""; String lastName = ""; String phone = ""; String zip = ""; String country = ""; String state = ""; String city = ""; String aUrl = ""; Connection c = null; AbstractConnector conn = new QogsDbConnector(); try{ c = conn.getConnection(); PreparedStatement ps = c.prepareStatement("SELECT isActive, isDisabled, chatDisabled, tournyPoints FROM Player WHERE playerId = ?"); ps.setInt(1, pId); ResultSet rs = ps.executeQuery(); if(rs.next()){ isActive = rs.getBoolean(1); isDisabled = rs.getBoolean(2); chatDisabled = rs.getBoolean(3); tournyPoints = rs.getBoolean(4); } rs.close(); ps.close(); ps = c.prepareStatement("SELECT firstName, lastName, phone, pcc, country, avatarPathFull, state, city FROM PlayerInfo WHERE playerId = ?"); ps.setInt(1, pId); rs = ps.executeQuery(); if(rs.next()){ firstName = rs.getString(1); lastName = rs.getString(2); phone = rs.getString(3); zip = rs.getString(4); country = rs.getString(5); String avatarUrlPart = rs.getString(6); if(avatarUrlPart == null){ aUrl = "http://www.riveredacepoker.com//Images/Avatars/default.jpg"; }else{ aUrl = "http://www.riveredacepoker.com/" + avatarUrlPart; } state = rs.getString(7); city = rs.getString(8); } rs.close(); ps.close(); } catch(Exception e){ System.out.println(e.getMessage()); out.println("Database problems, contact tecnichal support."); } finally{ try { if(c != null){ c.close(); } } catch (SQLException e) { System.err.println(e.getMessage()); } } %>

Personal Information

Update your information




<%out.print("\"avatar\""); %>





Your Account

<%if(isActive){ %> <%} else {%> <%}%> <%if(isDisabled){ %> <%} else {%> <%}%> <%if(chatDisabled){ %> <%} else {%> <%}%> <%if(tournyPoints){ %> <%} else {%> <%}%>