Servere girlio çıkıp yenden Girince Şifre yanlıs dio Çozüm :P

[mert66]

server giriyor çıkıp yenden girince şifre yanlıs dio [email protected]
[SERVER]mertko123.no-ip.biz[/SERVER]

 

[13ogachan]

Cevap: Servere girlio çıkıp yenden Girince Şifre yanlıs dio Çozüm

ALTER PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
 
as

IF dbo.IsValidCharacters(@AccountID) = 1
BEGIN
	SET @nRet = 2 -- Hesap Bulunamadı.
	RETURN
END

IF dbo.IsValidCharacters(@Password) = 1
BEGIN
	SET @nRet = 3 -- Şifreniz Hatalıdır.
	RETURN
END

-- # Account Nation Transfers Queue # --
EXEC ACCOUNT_NATION_TRANSFER ''


select @nRet = count(straccountid) from tb_user where straccountid = @AccountID 

if @nRet = 0 
begin 
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6') 
end 

 --CurrentUserdan Silelim
delete from currentuser where straccountid = @AccountID

declare @ban  int , @ban1 int, @ban2 int
select @nRet = count(straccountid) from currentuser
select @ban = authority from userdata where struserid = (select strcharid1 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban1 = authority from userdata where struserid = (select strcharid2 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban2 = authority from userdata where struserid = (select strcharid3 from account_char where straccountid = @AccountID and strcharid1 is not null )

if @ban = 255 or @ban1 = 255 or @ban2 = 255
begin
Set @nRet = 4
	RETURN
end


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6
IF @pwd IS null
BEGIN
    SET @nRet = 0
             --SET @nRet = 4
    RETURN
END

ELSE IF @pwd <> @Password
BEGIN
    SET @nRet = 0
             --SET @nRet = 3
    RETURN
END

DECLARE @gokhantasci varchar(21)
select @gokhantasci = count(straccountid)  FROM premium_service WHERE strAccountID = @AccountID

if @gokhantasci = 0
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
    SET @nRet = 1
    RETURN
END
IF @CharNum = 0
BEGIN
    SET @nRet = 1
    RETURN
END
ELSE 
BEGIN
    SET @nRet = @Nation+1
             --SET @nRet = 1
    RETURN
END
GO

 

[13ogachan]

Cevap: Servere girlio çıkıp yenden Girince Şifre yanlıs dio Çozüm

ALTER PROCEDURE MYST_LOGIN

@AccountID	varchar(21),
@Password	varchar(13),
@nRet		smallint	OUTPUT

AS

 --CurrentUserdan Silelim
delete from currentuser where straccountid = @AccountID

IF dbo.IsValidCharacters(@AccountID) = 1
BEGIN
	SET @nRet = 2 -- Hesap Bulunamadı.
	RETURN
END

IF dbo.IsValidCharacters(@Password) = 1
BEGIN
	SET @nRet = 3 -- Şifreniz Hatalıdır.
	RETURN
END

-- # Account Nation Transfers Queue # --
EXEC ACCOUNT_NATION_TRANSFER ''



select @nRet = count(straccountid) from tb_user where straccountid = @AccountID 

if @nRet = 0 
begin 
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6') 
end 

 --CurrentUserdan Silelim
delete from currentuser where straccountid = @AccountID

declare @ban  int , @ban1 int, @ban2 int
select @nRet = count(straccountid) from currentuser
select @ban = authority from userdata where struserid = (select strcharid1 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban1 = authority from userdata where struserid = (select strcharid2 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban2 = authority from userdata where struserid = (select strcharid3 from account_char where straccountid = @AccountID and strcharid1 is not null )

if @ban = 255 or @ban1 = 255 or @ban2 = 255
begin
Set @nRet = 4
	RETURN
end



DECLARE @Nation tinyint
SET @Nation = 0
-- tid login method by samma 2004.02.24
DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END
delete from premium_service Where nDays = '0'
SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO

 

[13ogachan]

Cevap: Servere girlio çıkıp yenden Girince Şifre yanlıs dio Çozüm

CREATE PROCEDURE [dbo].[MAIN_LOGIN]
@AccountID	char(21),
@Password	char(21),
@nRet		smallint	OUTPUT
AS

delete from currentuser where straccountid = @AccountID

IF dbo.IsValidCharacters(@AccountID) = 1
BEGIN
	SET @nRet = 2 -- Hesap Bulunamadı.
	RETURN
END

IF dbo.IsValidCharacters(@Password) = 1
BEGIN
	SET @nRet = 3 -- Şifreniz Hatalıdır.
	RETURN
END


/*
Author : Bir Kusurumuz Olduysa Affola :) Edit Nurullah
Update : 30.03.2021 - 11:22
*/

-- # Login Disabled  for Banned Accounts Start # --
DECLARE @Banned1 int,@Banned2 int,@Banned3 int
SELECT @Banned1 = Authority FROM USERDATA WHERE strUserId = (SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID AND strCharID1 is not null)
SELECT @Banned2 = Authority FROM USERDATA WHERE strUserId = (SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID AND strCharID2 is not null)
SELECT @Banned3 = Authority FROM USERDATA WHERE strUserId = (SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID AND strCharID3 is not null)

IF @Banned1 = 255 OR @Banned2 = 255 OR @Banned3 = 255
BEGIN
	-- Blocked Account
	SET @nRet = 4
	RETURN
END
-- # Login Disabled  for Banned Accounts End # --

-- # Auto Account Start #
SELECT @nRet = Count(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID
IF @nRet = 0
BEGIN
	INSERT INTO TB_USER (strAccountID,strPasswd,strSocNo,idays) VALUES (@AccountID,@Password,1,6)
END
-- # Auto Account Start #

DECLARE @pwd varchar(21)

SET @pwd = null

SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
	-- Invalid Password
	SET @nRet = 3
	RETURN
END
ELSE IF @pwd <> @Password
BEGIN
	-- Invalid Password
	SET @nRet = 3
	RETURN
END
ELSE IF @pwd = @Password
BEGIN

	-- # Check Current User Start #
	SELECT @nRet = Count(strAccountId) FROM CURRENTUSER WHERE strAccountId = @AccountID
	IF @nRet <> 0
	BEGIN
		DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
	END
	-- # Check Current User End #
		
	-- Login Sucessfull
	SET @nRet = 1
	RETURN
END
GO

 

[13ogachan]

Cevap: Servere girlio çıkıp yenden Girince Şifre yanlıs dio Çozüm

Merhabalar

Bir Rep Versen Yeter Be Çılğın Benizli