Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

MS SQL PHP Generator online Help

Prev Return to chapter overview Next

Email-based features

Some security-related features provided by MS SQL PHP Generator like self-registration and password recovering are based on sending email messages to users of generated sites. This chapter explains how these features work and what is required from the site developer for their support.

 

Users table extension

To support email-based features, user table must contain the following columns (besides columns for storing user names, passwords, and IDs that are required to support table-based authentication basically):

 

Default name

Data type

Description

user_email

character varying(255)

Email address of the user

user_token

character varying(255)

Internal data for verification and password recovering

user_status

integer

Status of the user. Possible values are as follows:

0 - registered user

1 - user awaiting verification

2 - user requested password reset

 

 

Enable self-registration

If this option is turned ON, users can register in the generated application.

 

Enable password recovering

If this option is turned ON, users are allowed to reset their passwords.

 

Customizing email messages

Email messages to be sent to the user on the registration and password recovering can be customized with the OnGetCustomTemplate event.

 

Outgoing mail settings

A set of settings to be used to send emails from the generated website. These settings can be also specified in the Project Options dialog. See also Setting up common SMTP servers.

 

 

Events

A number of events help you to control user registration and password recovering processes in the most flexible way possible. The following events are currently available:

 

 



Prev Return to chapter overview Next