Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Change the Session Variable Output
- <cfif IsDefined("FORM.username")>
- <cfset MM_redirectLoginSuccess="members_page.cfm">
- <cfset MM_redirectLoginFailed="sorry.cfm">
- <cfquery name="MM_rsUser" datasource="Access">
- SELECT FullName, Username,Password,AccessLevels FROM Logininfo WHERE Username=<cfqueryparam value="#FORM.username#" cfsqltype="cf_sql_clob" maxlength="50"> AND Password=<cfqueryparam value="#FORM.password#" cfsqltype="cf_sql_clob" maxlength="50">
- </cfquery>
- <cfif MM_rsUser.RecordCount NEQ 0>
- <cftry>
- <cflock scope="Session" timeout="30" type="Exclusive">
- <cfset Session.MM_Username=FORM.username>
- <cfset Session.MM_UserAuthorization=MM_rsUser.AccessLevels[1]>
- </cflock>
- <cfif IsDefined("URL.accessdenied") AND false>
- <cfset MM_redirectLoginSuccess=URL.accessdenied>
- </cfif>
- <cflocation url="#MM_redirectLoginSuccess#" addtoken="no">
- <cfcatch type="Lock">
- <!--- code for handling timeout of cflock --->
- </cfcatch>
- </cftry>
- </cfif>
- <cflocation url="#MM_redirectLoginFailed#" addtoken="no">
- <cfelse>
- <cfset MM_LoginAction=CGI.SCRIPT_NAME>
- <cfif CGI.QUERY_STRING NEQ "">
- <cfset MM_LoginAction=MM_LoginAction & "?" & XMLFormat(CGI.QUERY_STRING)>
- </cfif>
- </cfif>
- <cflock scope="Session" timeout="30" type="Exclusive">
- <cfset Session.MM_Username=FORM.username>
- <cfset Session.MM_UserAuthorization=MM_rsUser.AccessLevels[1]>
- <cfset Session.FullName=MM_rsUser.FullName[1]>
- </cflock>
Add Comment
Please, Sign In to add comment