ATTN : InstantForum.NET 3.2 Users

InstantASP Community Forums

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

ATTN : InstantForum.NET 3.2 Users

Rate Topic

Display Mode

Topic Options

Author

Message

Ryan Healey

Posted 23/01/2004 11:15:00

IF.NET 4.2 Coming Soon

Group: Administrators
Last Login: 05/01/2009 11:53:33
Posts: 1,959, Visits: 3,027

Hi,

The information in this post only applies to InstantForum.NET v3.2 users. A small bug exists within the if_sp_UserLogin stored procedure. I've provided the updated stored procedure below. v3.2 users should update the existing stored procedure with the details below. This has been resolved for the v3.3 release due soon. If customers have any questions as always please don't hesitate to contact support@instantasp.co.uk

Replace if_sp_UserLogin with code below...

CREATE Procedure if_sp_UserLogin (
@UserName varchar(100),
@Password varchar(100),
@UserID Int output
) AS

-- returns a number of possible values as the userid
-- if the member if found it returns a positive int containing the memberid
-- Other possible values are
-- UserID = -1 : Login Email Not Found
-- UserID = -2 : Password Not Found
-- UserID = -3 : Both Login Email and Password Not Found

IF EXISTS(SELECT MemberID FROM InstantForum_Members WHERE UserName = @UserName AND Password = @Password)
BEGIN
SET @UserID = (SELECT MemberID FROM InstantForum_Members WHERE UserName = @UserName AND Password = @Password)
RETURN
END

IF EXISTS(SELECT MemberID FROM InstantForum_Members WHERE UserName <> @UserName AND Password = @Password)
BEGIN
SET @UserID = -1
RETURN
END

IF EXISTS(SELECT MemberID FROM InstantForum_Members WHERE UserName = @UserName AND Password <> @Password)
BEGIN
SET @UserID = -2
RETURN
END

SET @UserID = -3

return
GO

Kindest Regards,

Ryan Healey
Director / Developer

Explore our products...
http://demos.instantasp.co.uk/

Post #1628

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 (0 guests, 0 members, 0 anonymous members)

No members currently viewing this topic.

Forum Moderators: Ryan Healey, Mark Christianson, Bare, James Trott

Permissions

All times are GMT, Time now is 12:54am