Çok eski bir web tarayıcısı kullanıyorsunuz. Bu veya diğer siteleri görüntülemekte sorunlar yaşayabilirsiniz..
Tarayıcınızı güncellemeli veya alternatif bir tarayıcı kullanmalısınız.
Tarayıcınızı güncellemeli veya alternatif bir tarayıcı kullanmalısınız.
QA Kodları [ Query Analyzer ]
- Konbuyu başlatan DAVUTBEY
- Başlangıç tarihi
Cevap: QA Kodları [ Query Analyzer ]
CREATE PROCEDURE dbo.ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(50),
@nRet smallint OUTPUT
AS
/*
Author: Nero
*/
DECLARE @AccountID2 varchar(50), @Password2 varchar(50), @Authority smallint, @Char1 smallint, @Char2 smallint, @Char3 smallint
SELECT @Char1 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID1 IS NOT NULL)
SELECT @Char2 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID2 IS NOT NULL)
SELECT @Char3 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID3 IS NOT NULL)
IF @Char1 = 255 or @Char2 = 255 or @Char3 = 255
BEGIN
UPDATE TB_USER SET strAuthority = 255 where strAccountID = @AccountID
END
ELSE
BEGIN
UPDATE TB_USER SET strAuthority = 0 where strAccountID = @AccountID
END
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays) VALUES (@AccountID, @Password, 1, '6')
END
/*
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
SET @nRet = 2 -- Account doesnt exist.
RETURN
END
*/
SELECT @Password2 = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @Password2 IS null or @Password2 != @Password
BEGIN
SET @nRet = 3 -- Invalid password.
RETURN
END
ELSE
IF @Authority = 255
BEGIN
SET @nRet = 4 -- Account is banned.
RETURN
END
ELSE
BEGIN
DELETE CURRENTUSER WHERE strAccountID = @AccountID
SET @nRet = 1
RETURN
END
GO
CREATE PROCEDURE dbo.ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(50),
@nRet smallint OUTPUT
AS
/*
Author: Nero
*/
DECLARE @AccountID2 varchar(50), @Password2 varchar(50), @Authority smallint, @Char1 smallint, @Char2 smallint, @Char3 smallint
SELECT @Char1 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID1 IS NOT NULL)
SELECT @Char2 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID2 IS NOT NULL)
SELECT @Char3 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID3 IS NOT NULL)
IF @Char1 = 255 or @Char2 = 255 or @Char3 = 255
BEGIN
UPDATE TB_USER SET strAuthority = 255 where strAccountID = @AccountID
END
ELSE
BEGIN
UPDATE TB_USER SET strAuthority = 0 where strAccountID = @AccountID
END
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays) VALUES (@AccountID, @Password, 1, '6')
END
/*
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
SET @nRet = 2 -- Account doesnt exist.
RETURN
END
*/
SELECT @Password2 = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @Password2 IS null or @Password2 != @Password
BEGIN
SET @nRet = 3 -- Invalid password.
RETURN
END
ELSE
IF @Authority = 255
BEGIN
SET @nRet = 4 -- Account is banned.
RETURN
END
ELSE
BEGIN
DELETE CURRENTUSER WHERE strAccountID = @AccountID
SET @nRet = 1
RETURN
END
GO
CREATE PROCEDURE dbo.ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(50),
@nRet smallint OUTPUT
AS
/*
Author: Nero
*/
DECLARE @AccountID2 varchar(50), @Password2 varchar(50), @Authority smallint, @Char1 smallint, @Char2 smallint, @Char3 smallint
SELECT @Char1 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID1 IS NOT NULL)
SELECT @Char2 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID2 IS NOT NULL)
SELECT @Char3 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID3 IS NOT NULL)
IF @Char1 = 255 or @Char2 = 255 or @Char3 = 255
BEGIN
UPDATE TB_USER SET strAuthority = 255 where strAccountID = @AccountID
END
ELSE
BEGIN
UPDATE TB_USER SET strAuthority = 0 where strAccountID = @AccountID
END
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays) VALUES (@AccountID, @Password, 1, '6')
END
/*
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
SET @nRet = 2 -- Account doesnt exist.
RETURN
END
*/
SELECT @Password2 = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @Password2 IS null or @Password2 != @Password
BEGIN
SET @nRet = 3 -- Invalid password.
RETURN
END
ELSE
IF @Authority = 255
BEGIN
SET @nRet = 4 -- Account is banned.
RETURN
END
ELSE
BEGIN
DELETE CURRENTUSER WHERE strAccountID = @AccountID
SET @nRet = 1
RETURN
END
GO
CREATE PROCEDURE dbo.ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(50),
@nRet smallint OUTPUT
AS
/*
Author: Nero
*/
DECLARE @AccountID2 varchar(50), @Password2 varchar(50), @Authority smallint, @Char1 smallint, @Char2 smallint, @Char3 smallint
SELECT @Char1 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID1 IS NOT NULL)
SELECT @Char2 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID2 IS NOT NULL)
SELECT @Char3 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID3 IS NOT NULL)
IF @Char1 = 255 or @Char2 = 255 or @Char3 = 255
BEGIN
UPDATE TB_USER SET strAuthority = 255 where strAccountID = @AccountID
END
ELSE
BEGIN
UPDATE TB_USER SET strAuthority = 0 where strAccountID = @AccountID
END
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays) VALUES (@AccountID, @Password, 1, '6')
END
/*
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
SET @nRet = 2 -- Account doesnt exist.
RETURN
END
*/
SELECT @Password2 = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @Password2 IS null or @Password2 != @Password
BEGIN
SET @nRet = 3 -- Invalid password.
RETURN
END
ELSE
IF @Authority = 255
BEGIN
SET @nRet = 4 -- Account is banned.
RETURN
END
ELSE
BEGIN
DELETE CURRENTUSER WHERE strAccountID = @AccountID
SET @nRet = 1
RETURN
END
GO
waytoolifebad
Kayıtlı Üye
- Katılım
- 16 Mayıs 2015
- Mesajlar
- 115
Cevap: QA Kodları [ Query Analyzer ]
++++++++++++++++++++++++++++++++++++++++++
++++++++++++++++++++++++++++++++++++++++++
leventaydin
Kayıtlı Üye
- Katılım
- 5 Haziran 2015
- Mesajlar
- 99
Cevap: QA Kodları [ Query Analyzer ]
te kardesim
te kardesim
magnagizmo
Kayıtlı Üye
- Katılım
- 1 Aralık 2012
- Mesajlar
- 50
Cevap: QA Kodları [ Query Analyzer ]
+++++++++++++++++++++
+++++++++++++++++++++
Cevap: QA Kodları [ Query Analyzer ]
tesekkurler
QA Kodları
***Hidden content cannot be quoted.***
Yeni kodlar elime ulaştıgında yenilecektir.
tesekkurler
Online istatistikleri
- Çevrimiçi kullanıcılar
- 454
- Çevrimiçi ziyaretçiler
- 2,624
- Toplam ziyaretçi
- 3,078
Toplamlar, gizli ziyaretçiler içerebilir.