<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ include file="../con_open.jsp" %>
Traffic Pods - PodSurf V1.1
<%
String cat = request.getParameter("cat");
String surfer = request.getParameter("surfer");
String get_im = request.getParameter("im");
String get_code = request.getParameter("code");
String bp_out = request.getParameter("bp_out");
if(bp_out == null) { bp_out = "no"; }
String sp_out = request.getParameter("sp_out");
if(sp_out == null) { sp_out = "no"; }
String IP = request.getRemoteAddr();
String bonus_in = request.getParameter("bonus_in");
if(bonus_in == null) { bonus_in = "no"; }
String super_in = request.getParameter("super_in");
if(super_in == null) { super_in = "no"; }
///BLOCK SURFING
/*
rs = stmt.executeQuery("SELECT * FROM pods_page_access WHERE page_name = 'SURF' ");
if(rs.next()) {
if(rs.getInt("blocked") == 1 && !surfer.equals("NOBODY") && !surfer.equals("trafficpods") && !surfer.equals("teebone")) { //deny access
response.sendRedirect("../unavailable.jsp?note="+rs.getString("note")+"&returnPage=index.jsp");
stmt.close();
con.close();
return;
}
}
*/
if(bp_out.equals("yes")) {
//cash out and drop from bonus pod
stmt.executeUpdate("UPDATE pods_accounts SET pod_points_reserve = pod_points_reserve + bonus_reg, bonus_reg = -1 WHERE username = '"+surfer+"' ");
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?mes=cash_out&surfer="+surfer);
con.close();
return;
}
if(sp_out.equals("yes")) {
//cash out and drop from bonus pod
int sp_reg = 1;
int sp_cr = 0;
double sp_cash = 0;
double jackpot = 0;
rs = stmt.executeQuery("SELECT super_reg FROM pods_accounts WHERE username = '"+surfer+"' ");
if(rs.next()) {
sp_reg = rs.getInt("super_reg");
}
rs = stmt.executeQuery("SELECT jackpot FROM jackpot WHERE id = 1");
if(rs.next()) {
jackpot = rs.getDouble("jackpot");
}
//adjust sp_reg level to actual
//if(sp_reg > 1) sp_reg -= 1;
if(sp_reg == 1) { sp_cr = 100; sp_cash = 0; }
if(sp_reg == 2) { sp_cr = 300; sp_cash = 0; }
if(sp_reg == 3) { sp_cr = 600; sp_cash = 0; }
if(sp_reg == 4) { sp_cr = 1000; sp_cash = 0; }
if(sp_reg == 5) { sp_cr = 1500; sp_cash = 0; }
if(sp_reg == 6) { sp_cr = 2250; sp_cash = 0; }
if(sp_reg == 7) { sp_cr = 3250; sp_cash = 0; }
if(sp_reg == 8) { sp_cr = 4750; sp_cash = 0; }
if(sp_reg == 9) { sp_cr = 6750; sp_cash = 0; }
if(sp_reg == 10) { sp_cr = 9750; sp_cash = 0; }
if(sp_reg == 11) { sp_cr = 13750; sp_cash = 0; }
if(sp_reg == 12) { sp_cr = 18750; sp_cash = 0; }
if(sp_reg == 13) { sp_cr = 24750; sp_cash = 0; }
if(sp_reg == 14) { sp_cr = 31750; sp_cash = 0; }
if(sp_reg == 15) { sp_cr = 39750; sp_cash = 0; }
if(sp_reg == 16) { sp_cr = 48750; sp_cash = 0; }
if(sp_reg == 17) { sp_cr = 58750; sp_cash = 0; }
if(sp_reg == 18) { sp_cr = 78750; sp_cash = 0; }
if(sp_reg == 19) { sp_cr = 128750; sp_cash = 0; }
if(sp_reg == 20) { sp_cr = 128750; sp_cash = jackpot; }
if(sp_reg <= 19) {
//prize is all credits
stmt.executeUpdate("UPDATE pods_accounts SET pod_points_reserve = pod_points_reserve + "+sp_cr+", super_reg = -1 WHERE username = '"+surfer+"' ");
stmt.executeUpdate("INSERT INTO pods_super_pod(username,date,prize,prize_type) VALUES('"+surfer+"',NOW(),"+sp_cr+",'POD_POINTS') ");
}
else if(sp_reg > 19) {
//prize is cash
stmt.executeUpdate("UPDATE pods_accounts SET pod_points_reserve = pod_points_reserve + "+sp_cr+", super_reg = -1 WHERE username = '"+surfer+"' ");
stmt.executeUpdate("INSERT INTO pods_super_pod(username,date,prize,prize_type) VALUES('"+surfer+"',NOW(),"+sp_cash+",'CASH') ");
}
if(sp_reg == 20) {
//reset jackpot
stmt.executeUpdate("UPDATE jackpot SET jackpot = 20 WHERE id = 1");
}
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?mes=cash_out_sp&surfer="+surfer);
con.close();
return;
}
//////////////////////////////////TEMP SURF BLOCKOUT//////////////////////////////////
/*
String sendHere = "../unavailable.jsp";
String note = "Surfing will be available at 1:00PM PST - Stay Tuned!";
//check to see if access is allowed
if(!surfer.equals("nobody")) { //deny access
response.sendRedirect(sendHere+"?note="+note+"&returnPage=index.jsp");
con.close();
return;
}
*/
//////////////////////////////////////////////////////////////////////////////////////
if(cat == null ) { cat = "default"; }
String AccountStatus = "invalid";
if (surfer == null) {
response.sendRedirect(response.encodeRedirectURL("surf_error.jsp?err=who"));
con.close();
return;
}
else if(surfer.equals("null")) {
response.sendRedirect("surf_error.jsp?err=who");
con.close();
return;
}
int check_surf = 0;
if(get_code == null) {
check_surf = 0;
}
else {
check_surf = 1;
}
if(get_im == null) {
check_surf = 0;
}
else {
check_surf = 1;
}
//double personal = 0;
double today_credits = 0;
double traffic_credits = 0;
int win = 0;
int winCredits = 0;
int winSymbol = 0;
String symbol = "";
String prizeNote = "";
int ls = 0;
int lu = 0;
int lr = 0;
int lf = 0;
int li = 0;
int ln = 0;
int lg = 0;
String surfing = "";
int im = 0;
int c_im = 0;
int num = 0;
int time = 0;
int good = 0;
int code = 0;
int code2 = 0;
int free_letter = 0;
int credit_account = 1;
int membertype = 1;
int site_num = 1;
int bonus_reg = 0;
int super_reg = 0;
double pp_reserve = 0;
double pp_avail = 0;
String sponsor = "nobody";
int pod_level = 0;
int pod_num = 0;
int bonus_pod = 0;
int super_pod = 0;
String ps_msg = "";
if(check_surf == 1) {
/////////////////////////////////////////////////////////////////
//JANUARY 2006 POWER SURF
int[] ps_hour = new int[35];
String[] ps_ratio = new String[35];
/*
ps_hour[29] = 13; //saturday
ps_hour[30] = 18;
ps_hour[1] = 10;
ps_hour[2] = 5;
ps_hour[3] = 22;
ps_hour[4] = 15;
ps_hour[5] = 9;
ps_ratio[29] = "3";
ps_ratio[30] = "2";
ps_ratio[1] = "2";
ps_ratio[2] = "3";
ps_ratio[3] = "3";
ps_ratio[4] = "2";
ps_ratio[5] = "3";
rs = stmt.executeQuery("SELECT DAYOFMONTH(NOW()) AS dom, HOUR(NOW()) AS thishour");
if(rs.next()) {
if(rs.getInt("dom") < 6 || rs.getInt("dom") == 29 || rs.getInt("dom") == 30) {
if(ps_hour[rs.getInt("dom")] == rs.getInt("thishour")) {
ps_msg = ps_ratio[rs.getInt("dom")];
}
//bonus hour for Jan 4th
//if(rs.getInt("dom") == 4 && rs.getInt("thishour") == 16) {
// ps_msg = "3";
//}
}
}
*/
int mult = 1;
if(!ps_msg.equals("")) { mult = Integer.parseInt(ps_msg); }
c_im = Integer.parseInt(request.getParameter("im"));
//rs = stmt.executeQuery("SELECT letter_s,letter_u,letter_r,letter_f,letter_i,letter_n,letter_g,im,num,( (SECOND(NOW())+MINUTE(NOW())*60 + HOUR(NOW())*3600) - (SECOND(date)+MINUTE(date)*60 + HOUR(date)*3600) ) AS time, code FROM pods_surf_track WHERE surfer = '"+surfer+"' ");
rs = stmt.executeQuery("SELECT ( (SECOND(NOW())+MINUTE(NOW())*60 + HOUR(NOW())*3600) - (SECOND(date)+MINUTE(date)*60 + HOUR(date)*3600) ) AS time, im, num, code, code2 FROM pods_surf_track WHERE surfer = '"+surfer+"' ");
if(rs.next()) {
im = rs.getInt("im");
num = rs.getInt("num");
time = rs.getInt("time");
code = rs.getInt("code");
code2 = rs.getInt("code2");
}
else {
response.sendRedirect("surf_error.jsp?err=notrack&surfer="+surfer);
con.close();
return;
}
if(code == 1554421) {
//came from security page. give credit
stmt.executeUpdate("UPDATE pods_surf_track SET code = 0 WHERE surfer = '"+surfer+"' ");
credit_account = 1;
}
else if(code2 == 999999) {
//came from start page. do not give credit
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 0 WHERE surfer = '"+surfer+"' ");
credit_account = 0;
}
else {
if(code > 0) {
response.sendRedirect("surf_lock.jsp?surfer="+surfer);
con.close();
return;
}
if(time < 10) {
response.sendRedirect("surf_error.jsp?err=notime&t="+time+"&surfer="+surfer);
con.close();
return;
}
if(c_im != im) {
stmt.executeUpdate("UPDATE pods_surf_track SET im=0 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_error.jsp?err=badnum&surfer="+surfer);
con.close();
return;
}
}
//get account info
//int pod_level = 0;
rs = stmt.executeQuery("SELECT sponsor, status, membertype, site_num, today_credits, bonus_reg, super_reg, pod_points_reserve, pod_points, personal FROM pods_accounts WHERE username = '"+surfer+"' and status = 'active' ");
if(rs.next()) {
//account is valid
membertype = rs.getInt("membertype");
site_num = rs.getInt("site_num");
//pod_level = rs.getInt("pod_level");
//personal = rs.getDouble("personal");
today_credits = rs.getDouble("today_credits");
traffic_credits = rs.getDouble("personal");
sponsor = rs.getString("sponsor");
bonus_reg = rs.getInt("bonus_reg");
super_reg = rs.getInt("super_reg");
pp_reserve = rs.getDouble("pod_points_reserve");
pp_avail = rs.getDouble("pod_points");
}
else {
response.sendRedirect("surf_error.jsp?err=badaccount&surfer="+surfer);
con.close();
return;
}
///////////////////////////////////////////////////BONUS POD POINT MULTIPLIER IS HERE///////////////////////////////////////////////
//CHECK FOR PRIZES!!!
int pmult = 1;
if(membertype > 1) {
pmult = 1;
}
if( (Math.random()*100) <= 15) {
//won something
win=1;
if( (Math.random()*100) <= 66) {
//win credits
int cr_x = (int) (Math.random()*100);
if(cr_x > 0) { winCredits = 5 * pmult; }
if(cr_x > 40) { winCredits = 10 * pmult; }
if(cr_x > 70) { winCredits = 15 * pmult; }
if(cr_x > 90) { winCredits = 20 * pmult; }
if(winCredits > 0) {
prizeNote = "You found "+winCredits+" Bonus Pod Points!";
}
}
else {
//win a symbol
winSymbol = 1;
int cr_l = (int) (Math.random()*100);
//get the letter
String up_sym = "s_1";
if(cr_l > 0 && cr_l <= 40 ) { symbol = "STAR"; up_sym = "s_1";}
if(cr_l > 40 && cr_l <= 70 ) { symbol = "DIAMOND"; up_sym = "s_2";}
if(cr_l > 70 && cr_l <= 90 ) { symbol = "MOON"; up_sym = "s_3";}
if(cr_l > 90 && cr_l <= 100 ) { symbol = "BLOB"; up_sym = "s_4";}
prizeNote = "You found a "+symbol+" symbol!";
//update surf_track
stmt.executeUpdate("UPDATE pods_surf_track SET "+up_sym+" = "+up_sym+" + 1 WHERE surfer = '"+surfer+"' ");
}
}
int syndicate = 0;
//credit account
double addCredit = 1;
double addAuto = 1;
if(membertype == 2) { addCredit = 4; winCredits *= 2; }
//if(membertype == 3) { addCredit = 5; winCredits *= 3; }
if(winCredits > 0) {
prizeNote = "You found "+winCredits+" Bonus Pod Points!";
}
pod_level = (site_num / 10000) + 1;
pod_num = ((site_num % 10000) / 10) + 1;
//is this surfer in a bonus pod?
if((site_num % 100) == 0 && (site_num % 1000) != 0) {
bonus_pod = 1;
//yes, in a bonus pod, check bonus pod regulator
if(bonus_reg == -1) {
//bonus pod is done
credit_account = 1;
bonus_pod = 0;
}
//else if(bonus_reg == 0) {
// bonus_pod = 1;
// credit_account = 0;
//}
else if(bonus_reg >= 0 && bp_out.equals("no") && site_num > 1 ) {
if(bonus_reg == 0 && !bonus_in.equals("yes")) {
//redirect for bonus pod message
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?mes=bonus_enter&surfer="+surfer);
con.close();
return;
}
int marker_b = 75;
if(bonus_reg < 100) { marker_b = 90; }
if( (Math.random()*100) <= marker_b || bonus_reg == 0) {
//stay in bonus pod
bonus_pod = 1;
credit_account = 0;
//bonus pod is active
int pod_multiplier = pod_level;
if(pod_multiplier < 1) { pod_multiplier = 1; }
if(pod_multiplier > 10) { pod_multiplier = 10; }
int bp_l = (int) (Math.random()*100);
//bonus pod prize
double bp_prize = 0;
if(bp_l > 0 && bp_l <= 50 ) { bp_prize = 5;}
if(bp_l > 50 && bp_l <= 75 ) { bp_prize = 10;}
if(bp_l > 75 && bp_l <= 90 ) { bp_prize = 15;}
if(bp_l > 90 && bp_l <= 100 ) { bp_prize = 20;}
bp_prize = bp_prize * pod_multiplier;
stmt.executeUpdate("UPDATE pods_accounts SET bonus_reg = bonus_reg + "+bp_prize+" WHERE username = '"+surfer+"' ");
//get bonus_reg amount for surf bar
bonus_reg += bp_prize;
}
else {
//drop from bonus pod
stmt.executeUpdate("UPDATE pods_accounts SET bonus_reg = -1 WHERE username = '"+surfer+"' ");
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?mes=bonus_drop&surfer="+surfer);
con.close();
return;
}
}
}
//is this surfer in a super pod?
if((site_num % 1000) == 0) {
super_pod = 1;
//yes, in a super pod, check super pod regulator
if(super_reg == -1) {
//super pod is done
credit_account = 1;
super_pod = 0;
}
//else if(bonus_reg == 0) {
// bonus_pod = 1;
// credit_account = 0;
//}
else if(super_reg >= 0 && sp_out.equals("no") && site_num > 1 ) {
if(super_reg == 0 && !super_in.equals("yes")) {
//redirect for super pod message
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?mes=super_enter&surfer="+surfer);
con.close();
return;
}
int marker = 75;
if(super_reg < 6) { marker = 100; }
if(super_reg > 17) { marker = 2; }
if( (Math.random()*100) <= marker || super_reg == 0) {
//stay in bonus pod
super_pod = 1;
credit_account = 0;
stmt.executeUpdate("UPDATE pods_accounts SET super_reg = super_reg + 1 WHERE username = '"+surfer+"' ");
double sp_cash2 = 0;
int sp_prize = 100;
//get super_reg amount for surf bar
if(super_reg == 1) { sp_prize = 200; }
if(super_reg == 2) { sp_prize = 300; }
if(super_reg == 3) { sp_prize = 600; }
if(super_reg == 4) { sp_prize = 1000; }
if(super_reg == 5) { sp_prize = 1500; }
if(super_reg == 6) { sp_prize = 2250; }
if(super_reg == 7) { sp_prize = 3250; }
if(super_reg == 8) { sp_prize = 4750; }
if(super_reg == 9) { sp_prize = 6750; }
if(super_reg == 10) { sp_prize = 9750; }
if(super_reg == 11) { sp_prize = 13750; }
if(super_reg == 12) { sp_prize = 18750; }
if(super_reg == 13) { sp_prize = 26250; }
if(super_reg == 14) { sp_prize = 36250; }
if(super_reg == 15) { sp_prize = 51250; }
if(super_reg == 16) { sp_prize = 71250; }
if(super_reg == 17) { sp_prize = 101250; }
if(super_reg == 18) { sp_prize = 0; sp_cash2 = 25; }
if(super_reg == 19) { sp_prize = 0; sp_cash2 = 50; }
if(super_reg == 20) { sp_prize = 0; sp_cash2 = 75; } // need to add jackpot here
super_reg = sp_prize;
}
else {
//drop from super pod
stmt.executeUpdate("UPDATE pods_accounts SET super_reg = -1 WHERE username = '"+surfer+"' ");
stmt.executeUpdate("UPDATE pods_surf_track SET code2 = 69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?mes=super_drop&surfer="+surfer);
con.close();
return;
}
}
}
if((site_num % 100) == 99) {
//reset bonus and super pod regulators.
stmt.executeUpdate("UPDATE pods_accounts SET bonus_reg = 0, super_reg = 0 WHERE username = '"+surfer+"' ");
}
if(credit_account == 1) {
if(membertype == 1) {
stmt.executeUpdate("UPDATE pods_accounts SET personal = personal + (1.25*"+mult+"), auto_assign = auto_assign + (1.25*"+mult+"), pod_points_reserve = pod_points_reserve + "+winCredits+", site_num = site_num + 1, pod_level = "+pod_level+", pod_num = "+pod_num+", weekly_surfed = weekly_surfed + 1, personal_lock = personal_lock + 1, weekly_bonus = weekly_bonus + "+winCredits+", today_credits = today_credits + (2.5*"+mult+"), today_surfed = today_surfed + 1, cr_surfing = cr_surfing + (2.5*"+mult+") WHERE username = '"+surfer+"' ");
//update adm_stats
stmt.executeUpdate("UPDATE pods_adm_stats SET credits_earned = credits_earned + "+(addCredit*2*mult)+", credits_won = credits_won + "+winCredits+", pages_surfed = pages_surfed + 1, credits_used = credits_used + 1 WHERE date = CURRENT_DATE() ");
}
else {
stmt.executeUpdate("UPDATE pods_accounts SET personal = personal + (5*"+mult+"), pod_points_reserve = pod_points_reserve + "+winCredits+", site_num = site_num + 1, pod_level = "+pod_level+", pod_num = "+pod_num+", weekly_surfed = weekly_surfed + 1, personal_lock = personal_lock + 1, weekly_bonus = weekly_bonus + "+winCredits+", today_credits = today_credits + (5*"+mult+"), today_surfed = today_surfed + 1, cr_surfing = cr_surfing + "+(addCredit*mult)+" WHERE username = '"+surfer+"' ");
//update adm_stats
stmt.executeUpdate("UPDATE pods_adm_stats SET credits_earned = credits_earned + "+addCredit*mult+", credits_won = credits_won + "+winCredits+", pages_surfed = pages_surfed + 1, credits_used = credits_used + 1 WHERE date = CURRENT_DATE() ");
}
//give pod point bonus to sponsor
if(!surfer.equals(sponsor)) {
stmt.executeUpdate("UPDATE pods_accounts SET pod_points_reserve = pod_points_reserve + 0.5 WHERE username = '"+sponsor+"' and membertype = 1 ");
stmt.executeUpdate("UPDATE pods_accounts SET pod_points_reserve = pod_points_reserve + 1 WHERE username = '"+sponsor+"' and membertype = 2 ");
}
//credit the pod this person is surfing in
//OLD>> stmt.executeUpdate("UPDATE pods_pods SET pod_reserve = pod_reserve + pp_per_surfer, pod_bonus = pod_bonus + pp_per_surfer WHERE pod_rank = "+pod_num+" ");
stmt.executeUpdate("UPDATE pods_pods SET pod_bonus = pod_bonus + pp_per_surfer WHERE pod_rank = "+pod_num+" and pod_owned = 1 ");
stmt.executeUpdate("UPDATE pods_accounts SET pod_points_reserve = pod_points_reserve + pp_per_surfer WHERE pod_owned = "+pod_num+" and pod_owned > 0 ");
//credit pod_value if pod is owned by this surfer or their sponsor
if(membertype == 1) {
stmt.executeUpdate("UPDATE pods_pods SET pod_value = pod_value + 1 WHERE username = '"+sponsor+"' and pod_owned = 1 ");
stmt.executeUpdate("UPDATE pods_pods SET pod_value = pod_value + 2.5 WHERE username = '"+surfer+"' and pod_owned = 1 ");
}
else {
stmt.executeUpdate("UPDATE pods_pods SET pod_value = pod_value + 1 WHERE username = '"+sponsor+"' and pod_owned = 1 ");
stmt.executeUpdate("UPDATE pods_pods SET pod_value = pod_value + 5 WHERE username = '"+surfer+"' and pod_owned = 1 ");
}
}
}
else {
//rs = stmt.executeQuery("SELECT letter_s,letter_u,letter_r,letter_f,letter_i,letter_n,letter_g,im,num,( (SECOND(NOW())+MINUTE(NOW())*60 + HOUR(NOW())*3600) - (SECOND(date)+MINUTE(date)*60 + HOUR(date)*3600) ) AS time, code FROM pods_surf_track WHERE surfer = '"+surfer+"' ");
rs = stmt.executeQuery("SELECT ( (SECOND(NOW())+MINUTE(NOW())*60 + HOUR(NOW())*3600) - (SECOND(date)+MINUTE(date)*60 + HOUR(date)*3600) ) AS time, im, num, code FROM pods_surf_track WHERE surfer = '"+surfer+"' ");
if(rs.next()) {
im = rs.getInt("im");
num = rs.getInt("num");
time = rs.getInt("time");
//ls = rs.getInt("letter_s");
//lu = rs.getInt("letter_u");
//lr = rs.getInt("letter_r");
//lf = rs.getInt("letter_f");
//li = rs.getInt("letter_i");
//ln = rs.getInt("letter_n");
//lg = rs.getInt("letter_g");
code = rs.getInt("code");
}
else {
//insert into surf_track
stmt.executeUpdate("INSERT INTO pods_surf_track(date,IP,surfer,start_date) VALUES(NOW(),'"+IP+"','"+surfer+"',NOW()) ");
}
rs = stmt.executeQuery("SELECT status, membertype, pod_num, pod_level, today_credits FROM pods_accounts WHERE username = '"+surfer+"' and status = 'active' ");
if(rs.next()) {
//account is valid
//membertype = rs.getInt("membertype");
//syndicate = rs.getInt("syndicate");
//personal = rs.getDouble("personal");
today_credits = rs.getDouble("today_credits");
}
stmt.executeUpdate("UPDATE pods_surf_track SET code2=69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_start.jsp?surfer="+surfer);
con.close();
return;
}
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
////////////////////////////////////////////////////
//RANDOM SECURITY CHECK
if( (Math.random()*100) == 1) {
stmt.executeUpdate("UPDATE pods_surf_track SET code=69 WHERE surfer = '"+surfer+"' ");
response.sendRedirect("surf_lock.jsp?surfer="+surfer);
con.close();
return;
}
//////////////////////////////////////////////////////
String bonus = "no";
String userpic = "NONE";
String userpic2 = "NONE";
String url = "http://google.com";
String sql = "";
int id = 0;
rs = stmt.executeQuery("SELECT url, id, username FROM pods_campaigns WHERE status = 'Active' and creditsUsed < credits and dailyUsed < dailyLimit and username != '"+surfer+"' ORDER BY rand() LIMIT 50,1");
if(rs.next()) {
url = rs.getString("url");
id = rs.getInt("id");
userpic = rs.getString("username");
stmt.executeUpdate("UPDATE pods_campaigns SET creditsUsed = creditsUsed + 1, dailyUsed = dailyUsed + 1 WHERE id = "+id+" ");
}
else {
rs = stmt.executeQuery("SELECT url, id, username FROM pods_campaigns WHERE status = 'Active' and username != '"+surfer+"' ORDER BY rand() LIMIT 1");
if(rs.next()) {
url = rs.getString("url");
id = rs.getInt("id");
userpic = rs.getString("username");
stmt.executeUpdate("UPDATE pods_adm_stats SET credits_bonus = credits_bonus + 1 WHERE date = CURRENT_DATE() ");
}
else {
url = "http://www.google.com";
}
bonus = "yes";
}
//
rs = stmt.executeQuery("SELECT id FROM pods_surf_track WHERE surfer = '"+surfer+"' ");
if(rs.next()) {
//update surftrack & prize letters...
stmt.executeUpdate("UPDATE pods_surf_track SET pages_surfed = pages_surfed + 1, date = NOW(), im=0, camp_id_prev = camp_id_cur, camp_id_cur = "+id+" WHERE id = "+rs.getInt("id")+" ");
} else {
//insert into surftrack
stmt.executeUpdate("INSERT INTO pods_surf_track(date,IP,surfer,im,camp_id_cur,start_date) VALUES(NOW(),'"+IP+"','"+surfer+"',0,"+id+",NOW()) ");
}
////////////////////////////////////////////
site_num = (site_num % 10) + 1;
String topurl = "surf_top_1.jsp?surfer="+surfer+"&userpic="+userpic+"&url="+url+"&camp_id="+id+"&prizeNote="+prizeNote+"&tc="+today_credits+"&pod_level="+pod_level+"&site_num="+site_num+"&pod_num="+pod_num+"&pp_reserve="+pp_reserve+"&pp_avail="+pp_avail+"&traffic_credits="+traffic_credits+"&bonus_pod="+bonus_pod+"&bonus_reg="+bonus_reg+"&super_pod="+super_pod+"&super_reg="+super_reg+"&ps="+ps_msg+"";
//String topurl = "top-B.jsp?sc="+scin+"&surfer="+surfer+"&userpic="+userpic+"&usersite="+url+"&cat="+cat+"";
////////////////////////////////////////////
int fr1 = (int)(Math.random() * 100);
int fr2 = (int)(Math.random() * 100);
int fr3 = (int)(Math.random() * 100);
int bar = (int)(Math.random() * 100);
%>
<%
if(bar < 50) {
%>
<%
}
else {
%>
<%
}
%>
<%@ include file="../con_close.jsp" %>