Setup and activate Multi-User Login.
Obj.dbLogin="(;,)Type | Dsn | SQL | PassList | PassFile | TitleTxt | RejectTxt | FromAddr | EmailSubject | EmailBody | ChangePasswrodURL| SMTPserver| HelpButton| ForgotPasswordButton| ChangePasswordButton| LogoutButton"
| Keyword | Description |
|---|---|
| Type | Poorman(Def) or DB type user datasource. |
| Dsn | DSN source for DB type. DB holding user id and password. |
| SQL | SQL=SELECT MyPassword, MyEmail FROM TABLE WHERE MyID = '[[ID]]' e.g. MyPassword is the fieldname for Password and MyEmail is the fieldname for Email. and MyID is the fieldname for ID. This is the SQL macro used to retrieve the password from the DB for login validation. You must have MyID, MyPassword and MyEmail fields in the login DB. |
| PassList | List of id,password,email. Passlist=frank,kwong,frank@aspdb.com; John,Crombe,john@aspdb.com; ...repeat. Delimier is the field delimiter. |
| PassFile | Passfile=filename,<block>id,password,email list in a file within a block. You can assign different block/group od users for different application. Filename is physical filename. The reason is that you should place this password ascii file outside of the web environment for security purpose. |
| TitleTxt | Title text for the login box. Defaults to "Login" |
| RejectTxt | Custom error message for login when name+pass is not valid. This message is sensitive enough that needs customization. |
| FromAddr | In order to implement Forgot Password, the is the "from" address of the dbMail. e.g. FromAddr=frank@aspdb.com |
| EmailSubject | Email Subject text. EmailBody=Your Forgotten Password |
| EmailBody | Email Body Text. EmailBody=Your password for [[LoginID]] is [[password]] This text must contain the two [[macro tags]] |
| ChangePasswrodURL | Redirect URL address. Change password involves local DB and policy management and is not covered by dbLogin. However, a Change Password button is furnished with couple with this redirect URL, you have enough to implement this task. |
| SMTPserver | When you are developing in loaclhost mode, SemdMail will use your local SMTP server. You must specify the mail server when you deploy. |
| HelpButton | (T/F) Default is True. When set to false, this button will not be displayed. |
| ForgotPasswordButton | (T/F) Default is True. When set to false, this button will not be displayed. Note: ForgetPasswordButton is not implemented. Images for this button is available. Use (add) this button to customize your own ForgetPassword. |
| ChangePasswordButton | (T/F) Default is True. When set to false, this button will not be displayed. Note: ChangePasswordButton is not implemented. Images for this button is available. Use (add) this button to customize your own ChangePassword. |
| LogoutButton | (T/F) Default is True. When set to false, the Logout button will not be displayed. This is the case for a stand alone login in which the page security is not required. |
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim GD As New Tornado.GetData
Dim LOG1 As New Tornado.z
With LOG1
.dbQP = "U=50| S=gold| M=g!sys=t| Xf=0,1| D=Nwind.mdb| Q=Orders| Gdf=0,1,2,3|" & _
" Th=tit=Single Access Login!Sub=Use asp/db; hello/world; John/Doe; Mary/Jane to login"
Dim Li As String = "type=PoorMan|passfile=/bin/pass.txt,application1| titletxt=Tornado Login|"
Li &= " FromAddr=frank@aspdb.com| EmailSubject=Your Password| Email Body=Your password for "
Li &= "[[LoginID]] is [[password]]| SMTPServer=Your_SMTP_Server"
.dbLogin = Li
.ASPdbNET()
End With
End Sub
</script>
z Class | Tornado Namespace | dbLoginTemplate | ASPdbLogin | ASPdbClearLogin | Special Topic - Login