<%@ include file="includes/common_mail.jsp" %>
<%@ page import="javax.mail.*, javax.mail.internet.*" %>
<%
String returnPath = request.getParameter("returnPath");
if(returnPath == null) { returnPath = "members/main.jsp"; }
String action = request.getParameter("action");
if(action == null) { action = "nothing"; }
String error_message = "";
String username = ""; //Required
String password = ""; //Required
int num_err = 0;
if(action.equals("submit")) {
try {
//check ip from central monitor
URL u = new URL("http://www.trafficpods.com/central_monitor/ip.php");
URLConnection uc = u.openConnection();
uc.setDoOutput(true);
uc.setRequestProperty("Content-Type","application/x-www-form-urlencoded");
PrintWriter pw = new PrintWriter(uc.getOutputStream());
//pw.println("key=12345&a=checkip&ip=222.222.333.444"); //testing
pw.println("key=12345&a=checkip&ip="+request.getRemoteAddr()+"");
pw.close();
BufferedReader in = new BufferedReader(
new InputStreamReader(uc.getInputStream()));
String res = in.readLine();
in.close();
//out.print(res);
if(res.equals("ip=bad")) {
num_err++;
error_message = "Access Denied: "+request.getRemoteAddr();
}
} catch(Exception URLerror) {
}
//GET VARIABLES
username = request.getParameter("username"); //Required
password = request.getParameter("password"); //Required
if(returnPath.equals("/surf/surf_start.jsp")) {
returnPath += "?surfer="+username+"";
}
username = username.replaceAll(" ","");
username = username.replaceAll("'","");
username = username.replaceAll("%","");
password = password.replaceAll(" ","");
password = password.replaceAll("'","");
password = password.replaceAll("%","");
rs = stmt.executeQuery("SELECT pods_profiles.suspendNote, pods_profiles.deleteNote, pods_profiles.username, pods_profiles.password, pods_accounts.status, pods_accounts.membertype FROM pods_accounts, pods_profiles WHERE pods_profiles.username = '"+username+"' and pods_profiles.password = '"+password+"' and pods_profiles.username = pods_accounts.username ");
if(rs.next()) {
//account exists, username and password valid
//check account status
String aStatus = rs.getString("status");
String suspendNote = rs.getString("suspendNote");
String deleteNote = rs.getString("deleteNote");
if(!aStatus.equals("active") || num_err > 0) {
num_err++;
if(aStatus.equals("inactive")) {
error_message = "Account has not yet been activated. An activation link was emailed to you when you registered. Click Here to have the activation link resent for username: "+username+". ";
response.sendRedirect("login.php?loginerror=3");
}
else if(aStatus.equals("deleted")) {
error_message = "Account has been deleted by Traffic Pods administration.
REASON: "+deleteNote+"
";
response.sendRedirect("login.php?loginerror=4");
}
else if(aStatus.equals("removed")) {
error_message = "Account has been removed by the account holder.";
response.sendRedirect("login.php?loginerror=5");
}
else if(aStatus.equals("suspended")) {
error_message = "Account has been suspended by Traffic Pods administration.
REASON: "+suspendNote+"
This issue can be resolved by submitting a support ticket.";
response.sendRedirect("login.php?loginerror=6");
}
else if(!aStatus.equals("active")) {
error_message = "Account is not valid. Please submit a support ticket if you have any questions or concerns with this issue.";
response.sendRedirect("login.php?loginerror=7");
}
}
else {
//successful login
session.setMaxInactiveInterval(7200);
session.setAttribute("pods_username", username);
session.setAttribute("pods_password", password);
session.setAttribute("IsLoggedIn", "yes");
returnPath = "surf/surf_login.jsp?username=" + username + "&password=" + password;
//NO ERRORS, PROCEED WITH LOGIN
stmt.executeUpdate("UPDATE pods_profiles SET last_login = NOW(), login_IP = '"+request.getRemoteAddr()+"' WHERE username = '"+username+"' ");
//logipromos bonus
/*
if(session.getAttribute("lpb") != null) {
try {
//check ip from central monitor
URL u = new URL("http://logipromos.com/bonus.php");
URLConnection uc = u.openConnection();
uc.setDoOutput(true);
uc.setRequestProperty("Content-Type","application/x-www-form-urlencoded");
PrintWriter pw = new PrintWriter(uc.getOutputStream());
pw.println("site=pods&lpb="+session.getAttribute("lpb"));
pw.close();
BufferedReader in = new BufferedReader(
new InputStreamReader(uc.getInputStream()));
String res = in.readLine();
in.close();
//out.print(res);
//return;
if(res.equals("0")) {
//out.print(session.getAttribute("lpb"));
//return;
//stmt.executeUpdate("UPDATE pods_accounts SET personal = personal + 100, logibonus = 1 WHERE logibonus = 0 and username = '"+username+"' ");
} else {
stmt.executeUpdate("UPDATE pods_accounts SET personal = personal + "+res+", logibonus = 1 WHERE logibonus = 0 and username = '"+username+"' ");
}
} catch(Exception URLerror) {
}
}
*/
//ADMIN STATS
rs = stmt.executeQuery("SELECT * FROM pods_adm_stats WHERE date = CURRENT_DATE()");
if (rs.next()) {
stmt.executeUpdate("UPDATE pods_adm_stats SET logins = logins + 1 WHERE date = CURRENT_DATE()");
}
else {
stmt.executeUpdate("INSERT INTO pods_adm_stats(date,logins) VALUES (CURRENT_DATE(),"+1+")");
}
response.sendRedirect(returnPath);
}
}
else {
error_message = "Username/Password combination invalid";
num_err++;
}
}
if(action.equals("sent")) {
num_err = 0;
String GETusername = request.getParameter("username");
String GETpassword = "";
String GETemail = "";
rs = stmt.executeQuery("SELECT password,email FROM pods_profiles WHERE username = '"+GETusername+"' ");
if(rs.next()) {
//username exists
GETpassword = rs.getString("password");
GETemail = rs.getString("email");
}
else {
//account does not exist, throw error
error_message = "Account is not valid";
num_err++;
action = "retrieve";
}
if(num_err == 0) {
String emailBody = "Traffic Pods Account Information\n\n";
emailBody += "Username: "+GETusername+"\n";
emailBody += "Password: "+GETpassword+"\n\n";
emailBody += "Login Here:\n";
emailBody += "http://www.trafficpods.com/login.jsp\n\n";
emailBody += "Traffic Pods Support Center:\n";
emailBody += "http://www.logiscape.com/esupport/?group=TRAFFICPODS\n\n";
mail(GETemail,"\"Traffic Pods\" ","Account Information Retrieval",emailBody);
}
}
if(num_err > 0) { //form has errors
error_message = "
Error:
"+error_message+"
";
}
else {
}
//HAS SESSION EXPIRED?
String sess = request.getParameter("sess");
if(sess == null) { sess = "good"; }
if(sess.equals("expired")) {
error_message = "
Please log in.
";
}
if(sess.equals("rem")) {
session.invalidate();
error_message = "
Your account has been removed.
";
}
if(sess.equals("lpb")) {
error_message = "
Please login to claim your bonus
";
}
if(sess.equals("logout")) {
session.invalidate();
error_message = "
You have logged out.
";
}
// INSERT NEW DAY (TOMORROW) INTO adm_stats
rs = stmt.executeQuery("SELECT * FROM pods_adm_stats WHERE date = FROM_DAYS( TO_DAYS( NOW() ) + 1 )");
if (rs.next()) {}
else {
stmt.executeUpdate("INSERT INTO pods_adm_stats(date) VALUES ( FROM_DAYS( TO_DAYS( NOW() ) + 1 ) )");
}
%>
<% if(action.equals("sent")) { %>
<%} else if(action.equals("retrieve")) { %>
<% } else { %>
<% } %>
|
|
|
|
<%@ include file="includes/right_column.jsp"%> |
