%@ 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"%>
Terms of Service Privacy Policy
© animine.com 2002-2011