Eski Kodu Silip Bu Kodu Ekleyiniz Yani
ACCOUNT_LOGIN Ve myst_login Siliniz
Kod:
CREATE PROCEDURE ACCOUNT_LOGIN
-- Edit Voix
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
select @nRet=count(*) from tb_user where [email protected]
if @nRet=0
begin
insert into tb_user values (@AccountID , @Password , 1 , 6 , 1 ,1)
set @nRet=1
RETURN
end
DECLARE @tahsin tinyint, @myko smallint, @account int, @login int , @procedure int
SET @tahsin = 0
SET @myko = 0
DECLARE @pwd varchar(13)
SET @pwd = null
IF @pwd @Password
BEGIN
SET @nRet = 3
RETURN
END
IF @login=0
begin
set @nRet=11
RETURN
end
IF @account = 0
begin
set @nRet=12
RETURN
end
IF @procedure=0
begin
set @nRet=4
RETURN
end
select @nRet=count(*) from currentuser where [email protected]
IF @nRet>0
begin
set @nRet=5
RETURN
end
SELECT @tahsin = bNation, @myko = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @myko = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END
GO
Kod:
CREATE PROCEDURE myst_login
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
delete from currentuser where straccountid = @AccountID
---Coded By ShellX---
declare @cnt BigInt
declare @nDays smallint
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
select @cnt = count(straccountid) from currentuser
select @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountID
if @cnt > 40 and @nDays = '0'
begin
set @nRet = 0
end
if @cnt > 40 and @nDays = null
begin
set @nRet = 0
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
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
ACCOUNT_LOGIN Ve myst_login Siliniz
Kod:
CREATE PROCEDURE ACCOUNT_LOGIN
-- Edit Voix
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
select @nRet=count(*) from tb_user where [email protected]
if @nRet=0
begin
insert into tb_user values (@AccountID , @Password , 1 , 6 , 1 ,1)
set @nRet=1
RETURN
end
DECLARE @tahsin tinyint, @myko smallint, @account int, @login int , @procedure int
SET @tahsin = 0
SET @myko = 0
DECLARE @pwd varchar(13)
SET @pwd = null
IF @pwd @Password
BEGIN
SET @nRet = 3
RETURN
END
IF @login=0
begin
set @nRet=11
RETURN
end
IF @account = 0
begin
set @nRet=12
RETURN
end
IF @procedure=0
begin
set @nRet=4
RETURN
end
select @nRet=count(*) from currentuser where [email protected]
IF @nRet>0
begin
set @nRet=5
RETURN
end
SELECT @tahsin = bNation, @myko = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @myko = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = 1
RETURN
END
GO
Kod:
CREATE PROCEDURE myst_login
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
delete from currentuser where straccountid = @AccountID
---Coded By ShellX---
declare @cnt BigInt
declare @nDays smallint
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
select @cnt = count(straccountid) from currentuser
select @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountID
if @cnt > 40 and @nDays = '0'
begin
set @nRet = 0
end
if @cnt > 40 and @nDays = null
begin
set @nRet = 0
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
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