源文地址:http://forum.ragezone.com/f107/knight-online-emulator-rofd-378330/
下载的文件=> Loginserver 和 ebenezer++++==>
http://rapidshare.com/files/103649625/emulator.rar.html
或http://pickup.mofile.com/1539956797848787
和USKO国际客户端,请自已找,到处都有
TB_USER要重设置表...-
- Kod:
- strAccountID varchar 21
- strPasswd varchar 13
- strSocNo char 15
- accountban int
- ppcard int
- ppbittimi int
复制代码 Kod:
--早前matrix1536上传此文件于土尔其论坛,这里感谢他的分享...以下为ACCOUNT_LOGIN存储过程-
- CREATE PROCEDURE ACCOUNT_LOGIN
- @AccountID varchar(21),
- @Password varchar(13),
- @nRet smallint OUTPUT
- AS
- select @nRet=count(*) from tb_user where straccountid=@AccountID
- if @nRet=0
- begin
- insert into tb_user values (@AccountID , @Password , 1 , 1 , 1 ,1)
- set @nRet=1
- RETURN
- end
- DECLARE @Nero tinyint, @PlayerTurk smallint, @Lethe int, @Vipspawn int , @matrix1536 int
- SET @Nero = 0
- SET @PlayerTurk = 0
- DECLARE @pwd varchar(13)
- SET @pwd = null
- SELECT @matrix1536=accountban,@Vipspawn=ppcard,@Lethe=ppb ittimi,@pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
- IF @pwd IS null
- BEGIN
- SET @nRet = 2
- RETURN
- END
- ELSE IF @pwd <> @Password
- BEGIN
- SET @nRet = 3
- RETURN
- END
- IF @Vipspawn=0
- begin
- set @nRet=11
- RETURN
- end
- IF @Lethe = 0 :
- begin
- set @nRet=12
- RETURN
- end
- IF @matrix1536=0
- begin
- set @nRet=4
- RETURN
- end
- select @nRet=count(*) from currentuser where straccountid=@AccountID
- IF @nRet>0
- begin
- set @nRet=5
- RETURN
- end
- SELECT @Nero = bNation, @PlayerTurk = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
- IF @@ROWCOUNT = 0
- BEGIN
- SET @nRet = 1
- RETURN
- END
- IF @PlayerTurk = 0
- BEGIN
- SET @nRet = 1
- RETURN
- END
- ELSE
- BEGIN
- SET @nRet = 1
- RETURN
- END
复制代码 ((((((to make this work you need sql 2000))))))) |