首页 › 1299程序专版「1299 files」 › 有人能提供解决好的數據庫解決重复选择种族与装备仓库保存问题吗?

1300121 发表于 2008-11-6 21:13:22

你用哪個庫老外新庫嗎?

jiji0513 发表于 2008-11-6 21:31:34

對~~用了登入還是資料會消失 = =!

1300121 发表于 2008-11-6 22:34:27

就是有3.0武器的庫? 我改了可以保存物品技能 正常 中文顯示= =

jiji0513 发表于 2008-11-7 14:21:18

那種族重複選擇呢??
你是下載哪一個資料庫的押?

jiji0513 发表于 2008-11-10 21:18:54

目前已經解決物品保存的問題！

種族重複尚未解決><"有高手解決哩嗎~~

jiji0513 发表于 2008-11-11 21:59:27

目前用置頂的三個數據都會重複選擇種族....
老外的缺地圖檔.............
至頂的兩個數據也是一樣><"

[ 本帖最后由 jiji0513 于 2008-11-12 11:14 编辑 ]

jiji0513 发表于 2008-11-12 17:08:38

修改存储过程
CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM . WHERE strAccountID = @AccountID and idays=6
IF @pwd IS null
BEGIN
SET @nRet = 0
--SET @nRet = 4
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
--SET @nRet = 3
RETURN
END

DECLARE @gokhantasci varchar(21)
select @gokhantasci = count(straccountid) FROM premium_service WHERE strAccountID = @AccountID

if @gokhantasci = 0
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
--SET @nRet = 1
RETURN
END
GO


==========================

CREATE PROCEDURE MYST_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM . 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, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum >= 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO我是使用完整端-带中文补丁-登陆器-地图-基本不用修改的服務端和數據....
改完登入遊戲出現密碼不符~~由於我沒有此儲存過程MYST_LOGIN我把他用新增的....
然後修改ACCOUNT_LOGIN....AU則使用置頂的myAujard

[ 本帖最后由 jiji0513 于 2008-11-12 20:10 编辑 ]

xy305173481 发表于 2009-1-1 01:11:23

不懂`~你说的那个我跟本无法用``

ryan6755 发表于 2009-1-2 09:43:37

排序规则不知道在哪去修改，能指点下么

查看完整版本: 有人能提供解决好的數據庫解決重复选择种族与装备仓库保存问题吗?