<%@ EnableSessionState=false Language=JavaScript %> <% check_cookie(); %> <% insert_menu(0); %>

<% title_block("my profile", "home | feedback"); %> <% conn = Server.CreateObject("ADODB.Connection"); conn.Open("DSN=admain"); rs = Server.CreateObject("ADODB.RecordSet"); sql = "select userid, firstname, month(birthdate) as mbirth, dayofmonth(birthdate) as dbirth, year(birthdate) as ybirth, "; sql = sql + "month(registered) as mreg, dayofmonth(registered) as dreg, year(registered) as yreg, "; sql = sql + "numvisits, tz, tformat, latitude, longitude, telescope, wxcode, disporder, status, method, date_format(expiration, '%e %b %y') as exp " sql = sql + "from users where username = '" + Request.Cookies("UserData")("Username") + "'"; rs.Open(sql, conn); if (rs.EOF) { // User has been deleted. Delete their cookie and bounce them to another page. rs.Close(); conn.Close(); Response.Cookies("UserData").Expires = "January 1, 1990"; Response.Redirect("nouser.html"); } else { %> <% switch (String(rs.fields.item("status"))) { case "sub_active" : sub_stat = "Subscription Active"; break; case "sub_pending" : sub_stat = "Subscription Pending"; break; case "sub_payhack" : sub_stat = "Payment Invalid"; break; case "sub_payfailed" : sub_stat = "Payment Failed"; break; case "sub_expired" : sub_stat = "Subscription Expired"; break; case "trial_active" : sub_stat = "Trial Active"; break; case "trial_pending" : sub_stat = "Trial Pending"; break; case "trial_expired" : sub_stat = "Trial Expired"; break; case "trial_bounced" : sub_stat = "Activation Email Bounced"; break; case "none" : sub_stat = "Non-Subscriber"; break; } %> <% if (Number(rs.fields.item("latitude")) > 76) mapy = 90; else mapy = ((Math.floor(Number(rs.fields.item("latitude")) / 15) + 1) * 15) + 1; mapx = ((Math.floor((Number(rs.fields.item("longitude")) - 9) / 18) ) * 18) + 9; locy = Math.round(((mapy - Number(rs.fields.item("latitude"))) / 17) * 255); locx = Math.round(((Number(rs.fields.item("longitude")) - mapx) / 20) * 300); mapimg = "../images/maps/small/" + String(mapy) + String(mapx) + ".gif"; %> <% if (Number(rs.fields.item("tz")) >= 0) { signstr = "+"; } else { signstr = ""; } %> <% rs2 = Server.CreateObject("ADODB.RecordSet"); sql = "select city from wxcity where code = '" + String(rs.fields.item("wxcode")) + "'"; rs2.Open(sql, conn); %> username change <% Response.write(Request.Cookies("UserData")("Username")); %>   status expiration <% if (String(rs.fields.item("status")) == "trial_active") { Response.write(" upgrade to subscription"); } if (String(rs.fields.item("method")) == "Free") { exp_string = "N/A (Courtesy Subscription)"; } else if (String(rs.fields.item("method")) == "School") { exp_string = "N/A (Educational Subscription)"; } else if (String(rs.fields.item("method")) == "CCPend") { exp_string = "N/A (Credit Card Pending)"; } else { exp_string = String(rs.fields.item("exp")); } %> <% Response.write(sub_stat); %> <% Response.write(exp_string); %>   firstname/nickname change <% Response.write(String(rs.fields.item("firstname"))); %>   lat long change <% Response.write(degtodmsstr(Number(rs.fields.item("latitude")))); %> <% Response.write(degtodmsstr(Number(rs.fields.item("longitude")))); %> Location depicted on map is approximate. <% Response.write(""); %> birthdate <% Response.write(String(rs.fields.item("dbirth")) + " " + monthnames[Number(rs.fields.item("mbirth"))-1] + " " + String(rs.fields.item("ybirth"))); %> date registered <% Response.write(String(rs.fields.item("dreg")) + " " + monthnames[Number(rs.fields.item("mreg"))-1] + " " + String(rs.fields.item("yreg"))); %> number of visits <% Response.write(String(rs.fields.item("numvisits"))); %> time zone change <% Response.write("UTC" + signstr + String(rs.fields.item("tz"))); %> local time format change <% if (String(rs.fields.item("tformat")) == 12) { Response.write("12 hour (i.e. 11:59:59 PM)"); } else { Response.write("24 hour (i.e. 23:59:59)"); } %>   goto telescope change <% if (String(rs.fields.item("telescope")) == 'notset') { Response.write("Not yet set-up"); } else { Response.write(String(rs.fields.item("telescope"))); } %>   home page order change <% var itemorder = String(rs.fields.item("disporder")); switch(itemorder.charAt(0)) { case "A" : Response.write("1st - In the Sky "); break; case "B" : Response.write("1st - Upcoming Events "); break; case "C" : Response.write("1st - In the News "); break; case "D" : Response.write("1st - Today in History "); break; case "E" : Response.write("1st - Recent Forum Topics "); break; break; default : Response.write("1st - Sky Events ");; } switch(itemorder.charAt(1)) { case "A" : Response.write("2nd - In the Sky "); break; case "B" : Response.write("2nd - Upcoming Events "); break; case "C" : Response.write("2nd - In the News "); break; case "D" : Response.write("2nd - Today in History "); break; case "E" : Response.write("2nd - Recent Forum Topics "); break; break; default : Response.write("2nd - Upcoming Events ");; } switch(itemorder.charAt(2)) { case "A" : Response.write("3rd - In the Sky "); break; case "B" : Response.write("3rd - Upcoming Events "); break; case "C" : Response.write("3rd - In the News "); break; case "D" : Response.write("3rd - Today in History "); break; case "E" : Response.write("3rd - Recent Forum Topics "); break; break; default : Response.write("3rd - In the News ");; } switch(itemorder.charAt(3)) { case "A" : Response.write("4th - In the Sky "); break; case "B" : Response.write("4th - Upcoming Events "); break; case "C" : Response.write("4th - In the News "); break; case "D" : Response.write("4th - Today in History "); break; case "E" : Response.write("4th - Recent Forum Topics "); break; break; default : Response.write("4th - Today in History ");; } switch(itemorder.charAt(4)) { case "A" : Response.write("5th - In the Sky "); break; case "B" : Response.write("5th - Upcoming Events "); break; case "C" : Response.write("5th - In the News "); break; case "D" : Response.write("5th - Today in History "); break; case "E" : Response.write("5th - Recent Forum Topics "); break; break; default : Response.write("5th - Recent Forum Topics ");; } %>   weather reporting station change <% if (rs2.EOF) { Response.write("None"); } else { var cityname = String(rs2.fields.item("city")); rs2.move(1) while (!rs2.eof) { cityname = cityname + "; " + String(rs2.fields.item("city")); rs2.move(1); } Response.write(cityname); } rs2.Close(); %>   <% rs.Close(); conn.Close(); } %>   Requests to be removed from the user registration database should be sent to removeme@astronomydaily.com. Be sure to include your user name and date of birth. <% insert_footer(); %>