Stored Procedure Properties

Name	Value
Owner	dbo
Created	2004-05-31
Startup	False
Encrypted	False

Creation Options

Name	Value
QUOTED_IDENTIFIER	OFF
ANSI_NULLS	OFF

Parameters

Name	DataType	Length	Type
@UserName	nvarchar	100	INPUT
@Email	nvarchar	150	INPUT
@FakeEmail	nvarchar	150	INPUT
@URL	nvarchar	200	INPUT
@Signature	nvarchar	510	INPUT
@ForumView	int	4	INPUT
@ThreadTracking	bit	1	INPUT
@Timezone	int	4	INPUT
@Password	nvarchar	40	INPUT
@Occupation	nvarchar	200	INPUT
@Location	nvarchar	200	INPUT
@Interests	nvarchar	400	INPUT
@MsnIm	nvarchar	100	INPUT
@AolIm	nvarchar	100	INPUT
@YahooIm	nvarchar	100	INPUT
@IcqIm	nvarchar	100	INPUT
@ShowUnreadTopicsOnly	bit	1	INPUT
@SiteStyle	nvarchar	40	INPUT
@AvatarType	nvarchar	6	INPUT
@HasAvatar	bit	1	INPUT
@ShowAvatar	bit	1	INPUT
@DateFormat	nvarchar	20	INPUT
@PostViewOrder	bit	1	INPUT

Total: 23 parameter(s)

SQL

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO




CREATE        PROCEDURE forums_UpdateUserInfo
(
	@UserName	nvarchar(50),
	@Email		nvarchar(75),
	@FakeEmail	nvarchar(75),
	@URL		nvarchar(100),
	@Signature	nvarchar(255),
	@ForumView	int,
	@ThreadTracking bit,
	@Timezone 	int,
	@Password	nvarchar(20),
	@Occupation nvarchar(100),
	@Location nvarchar(100),
	@Interests nvarchar(200),
	@MsnIm nvarchar(50),
	@AolIm nvarchar(50),
	@YahooIm nvarchar(50),
	@IcqIm nvarchar(50),
	@ShowUnreadTopicsOnly bit,
	@SiteStyle nvarchar(20),
	@AvatarType nvarchar(3),
	@HasAvatar bit,
	@ShowAvatar bit,
	@DateFormat nvarchar(10),
	@PostViewOrder bit
)
 AS
	-- update the user's info ONLY IF we have a valid password
	IF EXISTS(SELECT UserName FROM Users WHERE UserName = @UserName AND Password = @Password)
	BEGIN
		SET NOCOUNT ON
		-- ok, we have a valid user
		UPDATE 
			Users SET
			Email = @Email,
			FakeEmail = @FakeEmail,
			URL = @URL,
			Signature = @Signature,
			ForumView = @ForumView,
			TrackYourPosts = @ThreadTracking,
			Timezone = @Timezone,
                        Occupation = @Occupation,
			Location = @Location,
			Interests = @Interests,
			MSN = @MsnIm,
			Yahoo = @YahooIm,
			AIM = @AolIm,
			ICQ = @IcqIm,
			ShowUnreadTopicsOnly = @ShowUnreadTopicsOnly,
			Approved = 1,
			Style = @SiteStyle,
			AvatarType = @AvatarType,
			HasAvatar = @HasAvatar,
			ShowAvatar = @ShowAvatar,
			DateFormat = @DateFormat,
			PostViewOrder = @PostViewOrder
		WHERE 
			UserName = @UserName AND
			Password = @Password
		SET NOCOUNT OFF
		SELECT 1
	END
	ELSE
		-- cripes, the password doesn't match up!
		SELECT 0





















GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO