Features and Purpose

Manage user registration, logins, password lookup, and user reports.
• custom user registration, login, password lookup
  
• add, edit, delete users from administration page
  
  
To demonstrate the user administration areas, click here, and then the administration menu should appear above.

• i_utils.asp
  This page included in all other pages to connect to the database. This page also includes a function library of routines that are used by other pages.
  
• login.asp
  Use this page to prompt for username and password and validate user in database. This page calls the do_login() function in 'i_utils.asp'.
  
• register.asp
  Use this page to register new users.
  
• upd_user.asp
  This page that can be used to allow the user to update their information.
  
• user_public.asp
  This page that can be used to view information about the given user (user_id).
  
• admin_users.asp
  This page is used to administer all records in the users database table. To enable security on this page the check_security() function in 'i_utils.asp' is called. A user accesslevel of 2 is required to access this page.
  
• i_header.asp, i_footer.asp, default.css
  These pages control the look and style of all other pages.
• i_menu.asp
  This page is "included" in all other pages to display the top navigation links.
• i_privacystatement.asp
  A generic privacy statement that can be modified to suit your needs.
  

In the included Access (.mdb) database, located in the '/data' folder, you'll find several tables:
• Users table
  This table stores all user basic information when a user registers. The accesslevel field work with the check_security() function in 'i_utils.asp' to validate the users permissions for any given page.
  
• luMetro, luStates, luRegions tables
  These are lookup tables that can be used to create a regional heirarchy, and relate users to regional areas (city, state, region, etc..).
  
• luIndustry tables
  This is an additional lookup table that can be used to related a user to an industry.
  
• Stats and Newsletter tables
  These are reserved for future functionality.

If you are using SQL 2000 just execute the included .sql script file on your SQL server to create the necessary database tables.

Note that there are 3 records in the users table, to allow testing for 3 different levels of users..
-- admin, pwd: admin (accesslevel=3)
-- vip, pwd: vip (accesslevel=2)
-- guest, pwd: guest (accesslevel=1)

To use the user management features on your existing .asp pages, just include the 'i_utils.asp' file at the beginning of any page that requires 'users' to be authenticated (logged in).

Before all other code:
<!--#include file='i_utils.asp'-->

To set permission level (where n is the value(1,2,3..) of the accesslevel field in the users table):
<% check_security(n) %>

The fonts and colors used throughout are based on standard .css style sheets. The entire design is easily changed by modifying HTML code in the i_header.asp and i_footer.asp pages. The pages are "included" by all other pages to create a wrapper around the content of each page.