Gİr İÇerİ server kurulumundan İyİ anlayanlar

[kaan16000]

SERVER actımda Hersey Normal 1 Giren bir daha giremiyor xD Şifre yanl$ diyor nedeni ne olabilir [email protected] ekLeyin..

 

[Audreys]

Cevap: Gİr İÇerİ server kurulumundan İyİ anlayanlar

ACCOUNT_LOGIN'de sorun olabilir ;

CREATE PROCEDURE ACCOUNT_LOGIN
 @AccountID varchar(21),
 @Password varchar(13),
 @nRet smallint OUTPUT
 AS
 delete from currentuser where straccountid = @AccountID
 ---Coded By unstoppables---
 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