搜索
 找回密码
 加入

請教各位有關數據庫NPC對應一事

leonjaykai 2010-1-26 19:30:07 1011
我個人是單機仿2.0版  遊戲正常 但部份npc 像轉職大商人  大商人女兒   欲望島  龍洞區  60區的傳送員  寶箱交換員等都沒有任何反應 之前爬版看到有關 EVent與NPC bytype對應的問題 我看了一下我的數據庫發現以下  請各位看看  是否可提供意見進行修正....謝謝
.
以下兩張圖  第一張圖在k_NPC裡可以看到npc所對應的bytype數值
[img]isimg=true][/url][/img]
第2張  在數據庫event裡看到的type卻都是1 ? 想請教各位這正常嗎??  或是我找尋的方向是錯的  還請請教  謝謝

[img]isimg=true][/url][/img]

5 回复

evaydd
2009-12-11 20:05:49
点击查看详情
[code]CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS
select @nRet = count(straccountid) from tb_user where straccountid = @AccountID
if @nRet = 0
begin
   RETURN
end


select @nRet = strAuthority from tb_user where straccountid = @AccountID
if @nRet = 255
begin
set @nRet=4
return
end


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

DECLARE @pwd varchar(13)
set @pwd=null
SELECT @pwd = strPasswd FROM [dbo].[TB_USER] 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


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
        END
DECLARE @premiumExpire datetime,@nDays int
DELETE FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID
SELECT @premiumExpire=premiumExpire FROM TB_USER WHERE strAccountID = @AccountID
IF @premiumExpire IS NOT NULL
BEGIN
        SET @nDays = DateDiff(d, getDate(), @premiumExpire)
        IF @nDays>0
                INSERT INTO PREMIUM_SERVICE(strAccountID,strType,nDays) VALUES(@AccountID,4,@nDays)
END
GO
leonjaykai
2009-12-11 20:26:50
楼主
請問這是什麼意思??  不懂   請指教~~
talkweb
2010-1-5 08:54:01
evt有问题,才点不开NPC
leonjaykai
2010-1-6 08:56:04
楼主
謝謝請教~~~另請教一事 如果現在npc點開了  點了任務但沒反應的話  也是evt編寫問題嗎?
zzy51521
2010-1-26 19:30:07
我的也有这个毛病...那些代码怎么用啊??
高级模式
游客