In this tutorial we will show you how to setup User Registration System in ASPMaker. We will use the demo database for demonstration.
We want to set up the "Employees" table for Registration System.
Fields in the User Table, "Employees":
Steps to Setup Registration System
1. Loading ASPMaker
Open ASPMaker and connect to the demo database.
2. Enabling Security and Setting up User Table
Advanced Security has to be enabled first. Click the [Security] tab, check [User Existing Table], select the [Table], the [Login Name Field] and the [Password Field]. The [Advanced] button will be enabled.
3. Setting up Registration System
Click the [Advanced] button, the Advanced Security window will appear. Click [User Login Options] node in the left pane.
In this example, we use the following options:
|User Registration Page||
Generate user registration page and add a link in login page.
Enabled - Enable registration page
|Change Password Page||
Enabled - Enable change password page
|Password Recovery Page||Enabled - Generate password recovery page (forgot password page) and add a link in login page. User name and password will be sent to the user's email address.|
|Email Field||User Email Address Field in user table used for sending email|
User Activated Field in user table used for storing the status of user. A boolean field is recommended, although an integer field or a string field will also work.
Note To enable user account activation, the Requires activation and Send email options under User Registration Page must be checked. The user needs to click an activation link in the email sent after registration to activate the user account.
See Security Settings for complete description of the options.
For user registration page, you can select which fields to be included in the page. Click the [...] button in the [Fields] row.
Click [>] to select the field or [>>] to select all fields to be included in registration page. Note that the password field is mandatory. Since we have chosen options that will send emails, the Email field must be included also.
If you use User Level Security also, you should not include the User Level field because a new user is not supposed to choose his/her own User Level. If the User Level field is not included, the default User Level for new user will be 0 (Anonymous). You can assign a suitable User Level to the user later by logging in as an administrator. Alternatively, you can also set a default value for the User Level field in your database or in ASPMaker. Then the new user will get the default User Level immediately after registration.
Click [OK] to finish.
Note: If you have enabled any of the email sending features, you must enter the SMTP server information in the [ASP]->[Email Settings] tab:
See Email Settings in ASP Setup for details.
4. ASP Script Generation
Click the [Generate] button and ASPMaker will generate the required ASP scripts automatically.
5. Running the ASP Application
Run the generated scripts. In login page, the "Register" link and "Forgot Password" link are displayed.
Click the "Forget Password" link, you will be redirected to the request password page.
If the email address entered by the user can be found in the user table, the password will be sent to the email address.
After login, a "Change Password" link is added in the menu before "Logout". Click it and you'll be redirect to the change password page.
The contents of the email contents can also be modified in the template. The files are register.txt, changepwd.txt and forgotpwd.txt.
For example, the forgot password email content template (forgotpwd.txt) is like the follows. The format is self-explanatory.
Subject: Password Request
Please see below for the requested information:
User Name: <!--$UserName-->
Please feel free to contact us in case of further queries.
The following special tags are used in the email templates:
<!--$From--> is sender email address
<!--$To--> is user email address
<!--$UserName--> is user login name (for forgotpwd.txt only)
<!--$Password--> is user password (for forgotpwd.txt and changepwd.txt only)
<!--FieldName--> (without the $ symbol) is the field value. (for register.txt only) e.g. <!--LastName--> is the field value of the field "LastName".
As for the email format, you can use either "TEXT" or "HTML". If you use HTML, change the line Format: TEXT to Format: HTML and enter HTML content below it. Make sure you keep a blank line after Format: TEXT/HTML to separate the settings and the email content.
You can also dynamically change the email by code using Email_Sending event before the email is sent. (See Server Events and Client Scripts)