If anyone responds to this thanks a lot because this is a lot to ask. I've never coded anything for a paying customer.
I'll be using Apache, MySQL and php of course. Or... how about this application already exists somewhere?? Requirements/Design ------------------- 1. Any page requiring authentication should be in a secure directory. The login for the directory will be issued behind the scenes once the user is authenticated. This prevents anyone from by passing the login. 2. Once you login once for a session all other pages requiring authentication become accessible to you (i.e record login in a cookie). 2. If you do not yet have a username/password then you can click on register, where you enter the following: Name * Title Company * Address * Tel Fax Email * LicenseId * Username * Password * Confirm Password * * = required Username must be unique. LicenseId must exist in a table of currently active licenses maintained by KINESYS. 3. If registration is successful then the account is stored in the database and the user continues to the originally requested page. 4. On the login page there should be a "Forgotten password?" link. When you click it you have to enter your email address and if it exists in the database, the username and password is emailed to you. 5. Each login with date and time should be recorded in the database linked to the Username. Ideally each download should also be recorded. 6. The pages requiring authentication should be in a secure directory. The login for the directory will be issued behind the scenes. This prevents anyone from by passing the login. 7. There must be an administration page in the secure directory that allows KINESYS to maintain the list of LicenseIds in the License table, and to view the user and event tables. Here is my take on the initial database schema. Table: License Primary Key: LicenseId Table: User Primary key: UserId (autoincrement) Required Unique Field: UserName Required Field: Password Required Field: Name Field: Title Required Field: Company Required Field: Address1 Required Field: Address2 Required Field: Address3 Required Field: Address4 Field: Tel Field: Fax Required Field: Email Required Foreign Key: LicenseId Table: Event Primary Key: EventId (autoincrement) Required Field: Timestamp Required Foreign Key: UserId Required Field: Description (e.g. "Login", "Downloaded ALPS LT 2.61.1") -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php