EditörAvcısı Süper Mod
Başarı Puanı Canlılık: (125/125) Deneyim: (127/127) Tecrübe: (126/126)
| Konu: Query Analyzer Oto üyelik Salı 16 Haz. 2009, 11:12 pm | |
| Query Analyzer Oto üyelik kod'u.. - Kod:
-
CREATE PROCEDURE ACCOUNT_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
| |
|