<%@ page import="java.sql.*" %> <%@ page import="javax.sql.DataSource" %> <%@ page import="dao.DbObject" %> <%@ page import="javax.naming.InitialContext" %> <%@ page import="javax.naming.Context" %> <%@ page import="javax.naming.NamingException" %> <%@ page import="java.io.IOException" %> <%@ page import="java.io.PrintWriter" %> <%@ page import="javax.servlet.ServletException" %> <%@ page import="javax.servlet.http.HttpServlet" %> <%@ page import="javax.servlet.http.HttpServletRequest" %> <%@ page import="javax.servlet.http.HttpServletResponse" %> <%@ page import="java.util.*" %> <%@ page language="java" import="java.text.*"%> <%@ include file="/dbinit.jsp" %> <%@include file="constants.jsp"%> <%@include file="constants_plus.jsp"%> <% String name = request.getParameter("item_number"); System.out.println("\nitem_number (name) "+name+"\n"); String pwd = request.getParameter("pwd"); String email = request.getParameter("email"); String subscribed = request.getParameter("subscribed"); if(name==null) { name=(String)session.getAttribute("name"); } if(pwd==null) { pwd=(String)session.getAttribute("pwd"); } if(email==null) { email=(String)session.getAttribute("email"); } if(subscribed==null) { subscribed=(String)session.getAttribute("subscribed"); } session.removeAttribute("name"); session.removeAttribute("pwd"); //session.removeAttribute("email"); session.removeAttribute("subscribed"); String currency_code = request.getParameter("currency_code"); String membership_type = request.getParameter("membership_type"); boolean is_subscribed = subscribed!=null && name!=null && pwd != null && email != null && !name.equals("") && !pwd.equals("") && !email.equals(""); boolean is_free = is_subscribed && "free".equalsIgnoreCase(subscribed); boolean is_presubscribed = "pp_primer".equalsIgnoreCase(subscribed); %> Animine -- Get membership and create animation in few minutes online.
<% String[] user = (String[])session.getAttribute(CURR_USR); String sessionId = session.getId(); String item_number = name; boolean available = false; if(item_number!=null && item_number.trim()!="") { String query = "select count(id) from MemberTb where group_id<>9 and name=?"; try { Connection Conn = dbObject.getConnection(); Conn.setAutoCommit(false); try { PreparedStatement stmt = Conn.prepareStatement(query); stmt.setString(1,name); ResultSet rs = stmt.executeQuery(); if(rs!=null && rs.next()) { int c = rs.getInt(1); if(0==c) { available = true; } } rs.close(); stmt.close(); boolean lockedByThisUser = false; boolean lockedByOtherUser = false; if(available) { Calendar cl = Calendar.getInstance(); cl.add(cl.HOUR, -48); java.util.Date d = cl.getTime(); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String s_date_stamp = df.format(d); java.sql.Date sql_d = new java.sql.Date(d.getTime()); query = "delete from LockedNameTb where datestamp<=\""+s_date_stamp+'"'; stmt = Conn.prepareStatement(query); // stmt.setDate(1,sql_d); stmt.executeUpdate(); stmt.close(); query = "select session_id from LockedNameTb where name=?"; stmt = Conn.prepareStatement(query); stmt.setString(1,name); rs = stmt.executeQuery(); if(rs!=null && rs.next()) { String s_id = rs.getString(1); if(sessionId.equals(s_id)) { lockedByThisUser=true; }else { lockedByOtherUser=true; } }else { cl.add(cl.HOUR, 48); d = cl.getTime(); df = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); s_date_stamp = df.format(d); query="insert into LockedNameTb values(?,?,\""+s_date_stamp+"\")"; stmt = Conn.prepareStatement(query); stmt.setString(1,name); stmt.setString(2,sessionId); // stmt.setDate(3,sql_d); stmt.executeUpdate(); stmt.close(); } available=!lockedByOtherUser; rs.close(); stmt.close(); } /****************************************************************************************/ if(available && is_subscribed && !is_presubscribed) { query = "select max(id)+1 from MemberTb"; stmt = Conn.prepareStatement(query); rs = stmt.executeQuery(); System.out.println("query: "+query); if(rs!=null && rs.next()) { int id = rs.getInt(1); rs.close(); stmt.close(); /* //subscribed String membership = "0".equals(user[1])?"Administrator": "1".equals(user[1])?"Privileged": "2".equals(user[1])?"Premium": // free "3".equals(user[1])?"Silver": "4".equals(user[1])?"Gold": "5".equals(user[1])?"Platinum": "-1".equals(user[1])?"Validation": "9".euals(user[1])?"Canceled":"Guest"; */ String group_id = is_free?"2":subscribed; query = "insert into MemberTb (id,group_id,name,password,email_id,address_id,folder_location,setings_location,property_location) values("+id+","+group_id+",'"+name+"', '"+pwd+"', '"+email+"', NULL, 'member/location/"+id+"','member/settings/"+id+"', 'member/prps/"+id+"')"; // stmt.setString(1,name); stmt = Conn.prepareStatement(query); stmt.executeUpdate(); stmt.close(); query="delete from LockedNameTb where session_id=?"; stmt = Conn.prepareStatement(query); stmt.setString(1,sessionId); stmt.executeUpdate(); stmt.close(); query = "select * from MemberTb where id="+id; stmt = Conn.prepareStatement(query); rs = stmt.executeQuery(); if(rs!=null && rs.next()) { user = new String[9]; for(int i=0; i<%@include file="info/animail.jsp"%><%//send e-mail use session for parameters } }catch (Exception e) { // %>
<%e.printStackTrace(new java.io.PrintWriter(out));%>
<% //ignored } response.sendRedirect("memberWelcome.jsp?act=new&sub="+subscribed); return; } } }else if(available && is_presubscribed) { session.setAttribute("pp_name",name); session.setAttribute("pp_pwd",pwd); session.setAttribute("pp_membership_type",membership_type); session.setAttribute("pp_currency_code",currency_code); session.setAttribute("pp_custom",pwd); /***************************************************************************************/ response.sendRedirect("PPRedirect.jsp?"+System.currentTimeMillis()); return; /***************************************************************************************/ } /***************************************************************************************/ if(available) { %>
<%=item_number%> is available!
<% }else { %>
<%=item_number%> is not available!
Someone has already chosen that Login Name. Please choose another name, try adding a number, which you will remember, to the end of the name.
<% query = "select name from MemberTb where name like '"+name+"%'"; stmt = Conn.prepareStatement(query); rs = stmt.executeQuery(); java.util.Vector vv = null; if(rs!=null && rs.next()) { if(vv==null) vv = new java.util.Vector(); vv.addElement(rs.getString(1)); } String nm1 = name+1; String nm2 = name.toUpperCase(); String nm3 = name+"-animine"; String nm4 = name+"2k"; String nm5 = name+"2K"; String[] helper = {nm1,nm2,nm3,nm4,nm5}; int v_sz=vv==null?0:vv.size(); boolean header_done= false; outer: for(int i=0; iSuggestions for your Animine.com ID (still available):
<% header_done=true; } %>        <%=helper[i]%>
<% } rs.close(); stmt.close(); %>
<% } Conn.commit(); }catch(Exception se) { %><%=se%> <% Conn.rollback(); }finally { Conn.setAutoCommit(true); Conn.close(); } // System.out.println("
"+rs); }catch (Exception e) { %>
<%e.printStackTrace(new java.io.PrintWriter(out));%>
<% } } %>
<%String HEAD_1_TITLE="Animation membership";%> <%for_ad="getting membership";%> <%int AD_WIDTH=100;%> <%@include file="templates/head_1.jsp"%>
 
Select User Name: value="<%=item_number%>"<%} %> >  
Select password:   
Confirm password:  
  
 
<%@include file="info/plan_description.jsp"%>
By submitting your registration information, you indicate that you agree to the Terms of Service and have read and understand the Animine.com Privacy Policy. You also agree to receive electronically administrative and legal notices such as site and effect development news.
e-mail address:
Select Membership Type:   
Select Currency:
< Home Animation Palette List of Effects >

Terms of Service   Privacy Policy
© animine.com 2002-2011