<%@page errorPage="errorPage.jsp" %> <%@page import="net.app.db.forum.DBBean"%> <%@page import="java.util.Vector"%> <%@page import="java.util.Iterator"%> <%@page import="net.app.db.forum.ForumMember"%> <%@page import="net.app.db.forum.ForumBean" %> <%@page import="net.app.db.forum.TableMappingFactory"%> <%@page import="net.app.db.forum.Pager"%> <%@page import="net.app.db.forum.initConfig"%> <%@page import="net.app.db.forum.AuthenBean" %> <% String forumImage="images/wyb.jpg"; String forumMenuTitle="n3Media - WHAT'S YOUR BEEF"; HttpSession mySession = request.getSession(true) ; String SQLStr=""; String username= (request.getParameter("username")==null) ? "": request.getParameter("username").trim(); String txtusername= (mySession.getAttribute("authUID")==null) ? "" : "Login as : " + (String) mySession.getAttribute("authUID"); String password= (request.getParameter("password")==null)? null: request.getParameter("password").trim(); String errmsg=""; String isValid=""; // register String strMode= (request.getParameter("ac")==null) ? "": request.getParameter("ac").trim(); String err=""; Vector vec=null; String rerrmsg=""; String rusername= (request.getParameter("rusername")==null) ? null: request.getParameter("rusername").trim(); String rpassword= (request.getParameter("rpassword")==null)? null: request.getParameter("rpassword").trim(); String rrpassword= (request.getParameter("rrpassword")==null)? null: request.getParameter("rrpassword").trim(); String fullname= (request.getParameter("fullname")==null)? null: request.getParameter("fullname").trim(); String email= (request.getParameter("email")==null)?null: request.getParameter("email").trim(); String occupation= (request.getParameter("occupation")==null)? null: request.getParameter("occupation").trim() ; String country= (request.getParameter("country")==null)? null: request.getParameter("country").trim(); String host= (request.getRemoteHost()==null) ? request.getRemoteAddr() : request.getRemoteHost(); String formstate=(String) mySession.getAttribute("formstate"); formstate = ((formstate==null || formstate.length()==0) ? "new" : formstate); ForumBean Forum= new ForumBean(); if (!username.equals("")) { DBBean db = new DBBean(); AuthenBean Authen= new AuthenBean(); isValid = Authen.isValidUser(db,username,net.app.db.forum.MD5.getMD5(password)); if (isValid=="1") { mySession.setAttribute("authUID",username); response.sendRedirect(response.encodeRedirectURL("forum.jsp")); } if (isValid=="0") errmsg="Invalid login, please try again."; } else //register { if (strMode.equals("new")) { //add new /* Setting session variables */ mySession.setAttribute("formstate","started"); formstate = "started"; if(rusername !=null ) mySession.setAttribute("rusername",rusername); if(rpassword !=null ) mySession.setAttribute("rpassword",rpassword); if(rrpassword !=null ) mySession.setAttribute("rrpassword",rrpassword); if(fullname !=null ) mySession.setAttribute("fullname",fullname); if(email !=null ) mySession.setAttribute("email",email); if(occupation !=null ) mySession.setAttribute("occupation",occupation); if(country !=null ) mySession.setAttribute("country",country); if(!rpassword.equals(rpassword)) err = err+"pw"; if(!Forum.hasValidLength(rusername)) err = err+"un"; if(!Forum.hasValidLength(rpassword)) err = err+"pw"; if(!Forum.hasValidLength(fullname)) err = err+"nm"; if(fullname==null) err = err+"nm"; if(!Forum.isValidEmail(email)) err = err+"em"; DBBean db = new DBBean(); //Check username is duplicate ? SQLStr="SELECT * FROM forumMember WHERE MemberUsername='" + rusername + "'"; vec= db.getGBEntries(SQLStr); ForumMember en= (ForumMember)vec.elementAt(0); if(!en.getMemberUsername().equals("none")) { err = err+"un"; rerrmsg="Username already taken, please try again !"; } //Check email is duplicate ? SQLStr="SELECT * FROM forumMember WHERE MemberEmail='" + email + "'"; vec= db.getGBEntries(SQLStr); en= (ForumMember)vec.elementAt(0); if(!en.getMemberEmail().equals("none")) { err = err+"em"; rerrmsg="Email address already taken, please try again !"; } SQLStr="SELECT * FROM forumMember WHERE MemberEmail='" + email + "'"; vec= db.getGBEntries(SQLStr); if(!en.getMemberEmail().equals("none")) err = err+"em"; if (err ==null || err.equals("")) { initConfig conf = new initConfig(); String userdate=new java.util.Date().toString(); String userstatus="1"; String tableDef="forumMember(MemberUsername, MemberPassword, MemberName, MemberEmail, MemberOccupation, MemberCountry, MemberStatus, MemberCreationDate)"; String[] values={rusername, net.app.db.forum.MD5.getMD5(rpassword), fullname, email, occupation, country, userstatus, userdate}; db.addEntry(tableDef,values); mySession.setAttribute("formstate","new"); mySession.invalidate(); response.sendRedirect(response.encodeRedirectURL("join-forum.jsp?ac=suc")) ; } } strMode = ((strMode==null || strMode.length()==0) ? "new" : strMode); String strTitle = strMode.equals("suc") ? "CONGRATULATIONS":"MEMBERSHIP DETAILS"; } String dusername= (mySession.getAttribute("authUID")==null) ? "" : "Login as : " + (String) mySession.getAttribute("authUID"); %> <%@ include file="incforummainheader.jsp" %>

WHAT'S YOUR BEEF MEMBER LOGIN If you are already a N3Media forum member please enter your username and password below to login.<%if (!errmsg.equals("")) out.println(" "+errmsg);%> USERNAME : PASSWORD : NOTE N3MEDIA retains the right, which it may or may not exercise in its sole discretion, to review, edit, or delete content which N3MEDIA deems to be illegal, offensive, or otherwise inappropriate. Messages that contain political content, that harass, abuse or threaten other members; have obscene or otherwise objectionable content; have spam, commercial or advertising content or links may be removed and may result in the loss of your Login ID (including e-mail). Please do not post any private information unless you want it to be available publicly. Never assume that you are completely anonymous.

USER REGISTRATION N3Media forum provides a very diverse and lively messaging system for people from the media, advertising, marketing and management field to exchange ideas, questions and success stories. To participate in the N3Media Forum, we need a little information about you. Please take a little time to fill out this electronic form. MEMBERSHIP DETAILS <%if (!rerrmsg.equals("")) out.println(rerrmsg);%> USERNAME : ><%=Forum.warning(err,"un")%> PASSWORD : <%=Forum.warning(err,"pw")%> RETYPE PASSWORD : <%=Forum.warning(err,"pw")%> EMAIL ADDRESS : ><%=Forum.warning(err,"em")%> PERSONAL DETAILS NAME : ><%=Forum.warning(err,"nm")%> OCCUPATION : COUNTRY :

		SUBMIT

<%@ include file="incrightnav.jsp" %>