首页 › 1299程序专版「1299 files」 › 关于已创建角色的ＩＤ要重复选择国家的问题谁能出来给个方法？

hotpp 发表于 2008-11-5 23:03:23

跳种族选择ＡＵ＋上面存贮过程

文件名: myAujard.exe
描述: myAujard.exe
下载地址: http://www.rayfile.com/files/e2686c33-ab4a-11dd-87e7-0019d11a795f/

jiji0513 发表于 2008-11-14 08:26:09

一樣><"

只要改ACCOUNT_LOGIN...問題是出在ACCOUNT_LOGIN???

luluji 发表于 2008-11-24 08:06:32

我也是这样的情况,真是困难啊~~~

jiji0513 发表于 2008-11-25 14:07:12

有解決嗎= =?

wx4587 发表于 2008-11-25 15:09:15

给你们把CT的方法再翻上来

1、首先清空你库中所有角色和帐号（必须，如果不，那下面的做了也枉然）
涉及到以下4个表中数据，必须清掉
1.account_chart
2.userdata
3.TB_user
4.warehuse
最好看下knight表，把骑士团信息也给清掉


2、修改ACCOUNT_LOGIN存储过程为

CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
-- Myst tarafından kodlanmıştır ( burayı değiştiren toptur )
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

-- tid login method by samma 2004.02.24
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>0
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

3.修改myst_login存储过程为

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
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

jiji0513 发表于 2008-11-25 15:22:22

找不到myst_login呢???

jiji0513 发表于 2008-11-27 20:00:23

請問我的存储过程为無myst_login．．．

清空userdata出現
Another user has modifed the contents if this tabke or view the database row you are modifying no longer exists in the database
我是進去全選案刪除．．．．出現這個的

並找無warehuse表格使用的數據是2008年10月31日新增的！

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

...此种方法不适用10月31的库.

或许这个是正确的方法对于一些库,可是针对10月31的库并不是好用了.已经验证.

jiji0513 发表于 2008-11-28 08:22:18

恩恩...意思要找新方法嗎= =?

zrt419 发表于 2009-3-2 13:16:12

这个问题很严重啊
我也是啊

查看完整版本: 关于已创建角色的ＩＤ要重复选择国家的问题谁能出来给个方法？