CREATE PROCEDURE [dbo].[ACCOUNT_PASSWORD_CHANGE]
@strUserId varchar(30),
@NewPassword varchar(30)
AS
/*
Author : Ceribrio
*/

DECLARE @strAccountID varchar(30),@RecordCount int
SELECT @RecordCount = Count(bCharNum) FROM ACCOUNT_CHAR WHERE strCharID1 = @strUserID OR strCharID2 = @strUserID OR strCharID3 = @strUserID
IF @RecordCount = 0
BEGIN
PRINT 'Veritabanında ' + @strAccountID + ' Adında Karakter Bulunamadı.'
END
ELSE
BEGIN
SELECT @strAccountID = strAccountId FROM ACCOUNT_CHAR WHERE strCharID1 = @strUserID OR strCharID2 = @strUserID OR strCharID3 = @strUserID
UPDATE TB_USER SET strPasswd = @NewPassword WHERE strAccountID = @strAccountID
PRINT @strUserId + 'Karakterinin Bağlı Bulunduğu ' + @strAccountId + ' Hesabının Şifresi Başarıyla Değiştirilmiştir.'
END
GO

EXEC ACCOUNT_PASSWORD_CHANGE 'CHARISMİ','ŞİFRESİ'

DECLARE @Authority tinyint
DECLARE @Authority2 tinyint
DECLARE @Authority3 tinyint
DECLARE @Currentuser int
delete from currentuser where straccountid = @AccountID
select @Currentuser = count(straccountid) from Currentuser
select @Authority = Authority from [dbo].[userdata] where struserid = (select strcharid1 from Account_Char where strAccountID = @AccountID)
select @Authority2 = Authority from [dbo].[userdata] where struserid = (select strcharid2 from Account_Char where strAccountID = @AccountID)
select @Authority3 = Authority from [dbo].[userdata] where struserid = (select strcharid3 from Account_Char where strAccountID = @AccountID)
if @Authority > 0 or @Authority2 > 0 or @Authority3 > 0 and @Currentuser > 39
Begin
Set @nRet = 0
End