<% var cookieTest = Request.Cookies("GFPUser")("ID") if (cookieTest != null){ var con = Server.CreateObject("ADODB.Connection"); var rsCookieDetails = Server.CreateObject("ADODB.Recordset"); con.Open(zmConn); var zmSQL = "SELECT EmailAddress, Password FROM tblStandardUser WHERE StandardUserID = " + cookieTest rsCookieDetails.Open(zmSQL, con, adOpenKeyset, adLockOptimistic); var cookieUsername = rsCookieDetails("EmailAddress").value; var cookiePassword = rsCookieDetails("Password").value; var cookieRemember = "True" rsCookieDetails.Close() con.Close() }else{ var cookieUsername = "" var cookiePassword = "" var cookieRemember = "False" } if(Request("formLogin") == 1){ var con = Server.CreateObject("ADODB.Connection"); var rsLogin = Server.CreateObject("ADODB.Recordset"); con.Open(zmConn); // SQL Query var zmSQL = "SELECT StandardUserID FROM tblStandardUser" + " WHERE EmailAddress ='" + Request("EmailAddress") +"'" + " AND Password ='" + Request("Password") +"'" rsLogin.Open(zmSQL, con, adOpenKeyset, adLockOptimistic); if(rsLogin.EOF) { rsLogin.Close(); con.Close(); Response.Redirect("index.asp?Login=False"); }else { if (Request("Remember") == "check"){ Response.Cookies("GFPUser")("ID")= rsLogin("StandardUserID").value; Response.Cookies("GFPUser").Expires = "08-08-2010"; }else{ Response.Cookies("GFPUser").Expires = "12-12-2000"; } Session("GFPUser") = rsLogin("StandardUserID").value; rsLogin.Close(); con.Close(); if (Request.QueryString("Checkout") == "True"){ Response.Redirect("../shoppingCart/checkout.asp"); }else{ Response.Redirect("/memberLogin/index2.asp"); } } } %> <%var opDate = new Date(); //Converts Date Object To String function getDate(dat, time){ var day = dat.getDate(); if(day < 10) day = "0" + day; var month = parseInt(dat.getMonth()) + 1; if(month < 10) month = "0" + month; var year = dat.getYear(); var retDat = day + "/" + month + "/" + year; if(time){ var hours = dat.getHours(); if(hours < 10) hours = "0" + hours; var mins = dat.getMinutes(); if(mins < 10) mins = "0" + mins; var secs = dat.getSeconds(); if(secs < 10) secs = "0" + secs; retDat += " " + hours + ":" + mins + ":" + secs; } return retDat; } var ServerDate = getDate(opDate, false); %>