When users enter a bad password or user name they get an error, however if an unauthorized user (in my case someone who has registered but not been approved) tries to login the page just kind of reloads, deleting what they had entered. 

Hello Amy,

There's a feature in Dynamic Login named "Restrict by IP / SQL Validation". SQL Validation will enable you to perform a search in the database, and return a message based on the conditions you've setup.

You can re-purpose the SQL Query in the following Forum:
http://www.datasprings.com/dnn-modu...h-checkbox

You can build your SQL Validation around this:

UPDATE UserPortals SET Authorised = 'False' WHERE PortalId=$(PortalID) AND UserId = $(UserID)

Of course you won't be updating, just add some logic and conditionally return true or false.

Please let me know if you have any questions.

Thanks,

Ryan

Hello Albert,

I may take a different approach:


DECLARE @IsAuthorisedUser int
SET @IsAuthorizedUser =(SELECT Authorised FROM UserPortals WHERE UserID = '$(UserID)' AND PortalID = '$(PortalID)')

IF @IsAuthorisedUser = 1
BEGIN
Select 'True' As IsValid
END
ELSE
BEGIN
Select 'False' As IsValid
END


Or you can shorten the Code:

IF (SELECT Authorised FROM UserPortals WHERE UserID = '$(UserID)' AND PortalID = '$(PortalID)') = 1 
BEGIN
Select 'True' As IsValid
END
ELSE
BEGIN
Select 'False' As IsValid
END

Try either one out and let me know if it begins working. If it doesn't, then you may be experiencing a bug.

Please let me know if you have any questions.

Thanks,

Ryan