/* Check to make sure we are connected to the database before allowing access to the home page. If not connected, go connect and initialize; otherwise, welcome the user.\ */ if(!database.connected()) redirect("init.htm"); cursor = database.cursor("select ssn, pin, name from employee where ssn = " + request.ssn); cursor.next() if (request.ssn == cursor.ssn && request.pin != cursor.pin) { // User is a member, but doesn't remember pin. if (client.loginNo > 2) { redirect("hr.htm"); } else { client.loginNo++; redirect("admlogin.htm"); } } else if (request.ssn == cursor.ssn && request.pin == cursor.pin) { // User is already a member. client.ssn = request.ssn client.pin = request.pin; redirect("admmenu.htm"); }