<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%
String activecode="";
String username="";
String outresult="
Kích hoạt không thành công. Vui lòng sử dụng mục liên hệ để yêu cầu hổ trợ. Xin cảm ơn. ";
int denyFlood=0;
HttpSession denyFloodSession=denyFloodSession=request.getSession(true);
try{
activecode=request.getParameterValues("activecode")[0];
username=request.getParameterValues("username")[0];
}catch(Exception ee){activecode="";username="";}
try{denyFlood=Integer.parseInt((String)denyFloodSession.getAttribute("denyFlood"));}
catch(Exception ee){}
//if(denyFloodSession.getAttribute("denyFlood")==null){
try{
String DBUrl = "jdbc:mysql://localhost/tuvigl2_profile";
String DBUserName = "tuvigl2_profile";
String DBPassword = "tU2kAi91mz";
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection(DBUrl, DBUserName, DBPassword);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT user_id FROM user WHERE user_id ='"+username+"' AND activecode='"+activecode+"' AND activecode is not null AND activecode<>''");
if(rs.next()){
PreparedStatement st=con.prepareStatement("UPDATE user SET activecode='' WHERE user_id='"+username+"'");
st.executeUpdate();
outresult="
Quá trình kích hoặt đã hoàn tất. Mời bạn sử dụng các dịch vụ của tuviglobal.com ";
}
//else{
// }
}
catch(Exception ee){}
denyFloodSession.setAttribute("denyFlood","1");
//}else{
// denyFlood++;
// denyFloodSession.setAttribute("denyFlood",String.valueOf(denyFlood));
//}
out.write(outresult);
%>