lz2006 发表于 2008-12-9 18:46:35

1299求帮

1、谁发个完整的maps ,以往的都下不了啊，我论坛又没钱啊，，
2、如何调过种族选择？

WZQ911 发表于 2008-12-9 19:19:07

修改存储过程
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
这是你的第2个问题

lz2006 发表于 2008-12-9 19:27:05

具体怎么操作哦？
我没看见这个表啊？

WZQ911 发表于 2008-12-9 19:27:31

多回答点帖子就有钱了...

WZQ911 发表于 2008-12-9 19:31:29

http://www.kofans.cn/bbs/thread-7218-1-1.html

lz2006 发表于 2008-12-9 19:32:33

我复制下来全市乱码啊？
朋友你能提供1个好点的库和端吗？》

lz2006 发表于 2008-12-9 19:37:26

有语法错误！1

yang123456 发表于 2008-12-21 03:22:07

gfgdfg

我找大半天

28085279 发表于 2008-12-25 13:08:35

种族重复选择你光改存储过程是没用的，你还要有配套的伺服务器程序，不然再好的库也是一样过不了

gjbation1 发表于 2009-10-9 17:31:14

我也有这个问题！
页: [1] 2
查看完整版本: 1299求帮