Continuous Res Rune Problem (VİDEO)

[karakas1997]

Hello Friends
I installed succesfuly game smoothly but don't record when use Continuous Res Rune

What is wrong? How to fix this.?

[Sh1nra]

Please post your logs

PSM_Client/Bin/Log

[karakas1997]

PS_DBAGENT__charsave

//PS_DBAGENT__charsave log start (DBAgent01)

--<begin>2013-02-28 23:07:54,admin,1,Lark,10

{?=call usp_Save_Char_Info_E(10,1, 0,5, 16,12,11,8,7,11, 372,110,247, 2,52, 52,0, 1820.758423,123.049629,483.167633, 0,200,0,0,0, 120000,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,1,1954217984

{?=call Usp_Save_Char_ApplySkill_Del_E(10,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(10,286,3,2591954)}

EXEC usp_Save_Char_QuickSlot_Del_E 10

--<end>2013-02-28 23:07:54,admin,1,Lark,10


--<begin>2013-02-28 23:41:51,admin,1,Lark,10

{?=call usp_Save_Char_Info_E(10,1, 0,5, 16,12,11,8,7,11, 372,110,247, 2,100, 31,0, 1819.522583,124.473579,475.653870, 0,200,0,0,0, 120000,0,0,0)}

EXEC usp_Save_User_StoredMoney_E 1,1,1954217984

{?=call Usp_Save_Char_ApplySkill_Del_E(10,0,0,1)}

{?=call Usp_Save_Char_ApplySkill_Add_E2(10,286,3,2591965)}

EXEC usp_Save_Char_QuickSlot_Del_E 10

--<end>2013-02-28 23:41:51,admin,1,Lark,10

PS_DBAGENT__system

2013-02-28 23:01:18 PS_DBAGENT__system log start (DBAgent01)

2013-02-28 23:01:32 connect game, Name=



2013-02-28 23:01:32 connect game, Name=



2013-02-28 23:07:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2013-02-28 23:07:54 ::SaveCharacter 10 Lark ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(10,286,3,2591954)}

2013-02-28 23:07:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2013-02-28 23:07:54 ::SaveCharacter 10 Lark ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(10,286,3,2591954)}

2013-02-28 23:41:51 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2013-02-28 23:41:51 ::SaveCharacter 10 Lark ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(10,286,3,2591965)}

2013-02-28 23:41:51 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable "@Skillid"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2013-02-28 23:41:51 ::SaveCharacter 10 Lark ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(10,286,3,2591965)}

PS_GAME__system

2013-02-28 23:01:21 PS_GAME__system log start (Game01) [KR]

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/sorp1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/croco1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/croco2

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Troll1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Spink1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/GoldenPig

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Sorp3

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/SorpNamed1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/SorpNamed2

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Sorp2

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/CrocoNamed1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/CrocoNamed2

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/CrocoNamed3

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/OrcNamed1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/OrcNamed2

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/OrcNamed3

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/TrollNamed1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Deinos

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Parridalis

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Alcarian

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/ZinAlcaria

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Belizabeth

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Kirhiross

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/CrypticOne

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Haruhion

2013-02-28 23:01:21 Loaded Behavior In Factory : data/ai/Freezing

2013-02-28 23:01:32 connect mgr 664

2013-02-28 23:01:32 connect dbagent 676

2013-02-28 23:01:32 connect dbagent2 688

2013-02-28 23:01:32 connect gamelog 720

2013-02-28 23:01:33 Market End -----------------------

2013-02-28 23:01:43 <Console input> /nprotectoff

2013-02-28 23:01:43 <Console output> cmd NProtect off ok

2013-02-28 23:07:55 discon client: (104,    64) T=000:03:00:000, RC=134,RCS=0, RB=1323,RBS=6, SC=663,SCS=3, SB=11655,SBS=53

2013-02-28 23:41:51 discon client: (104,    64) T=000:09:00:000, RC=91,RCS=0, RB=922,RBS=1, SC=829,SCS=1, SB=14382,SBS=25

2013-03-01 00:01:44 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

PS_GAMELOG__system

2013-02-28 23:01:16 PS_GAMELOG__system log start (GameLog01)

2013-02-28 23:01:32 connect game

PS_LOGIN__system

2013-02-28 23:01:23 PS_LOGIN__system log start (Login01)

2013-02-28 23:01:35 <Console input> /vchkoff

2013-02-28 23:01:35 <Console output> cmd version chk off ok

2013-03-01 00:01:35 cmd_auto server info log

 user = 0 (0/5000)

2013-03-01 00:01:35 T=001:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=3,CReq=3,CCnt=3,DCCnt=3, CTimeT=000:02:00:000,CTimeAvg=000:00:00:000, RBT=582,RBS=0,RBSC=3,SBT=831,SBS=0,SBSC=5

2013-03-01 00:01:35 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

PS_SESSION__system

2013-02-28 23:01:14 PS_SESSION__system log start (Session)

2013-02-28 23:01:25 connect login

2013-02-28 23:01:33 connect game

2013-02-28 23:04:26 [Alpha] NewUser Enter : Char=Dark, Lv=60, Map=2, X=1837.6, Z=533.7

2013-02-28 23:05:42 [Alpha] NewUser Leave : Char=Dark, Lv=60, Map=2, X=1838.6, Z=533.2

2013-02-28 23:06:23 [Alpha] NewUser Enter : Char=Lark, Lv=1, Map=2, X=1838.9, Z=443.4

2013-02-28 23:07:54 [Alpha] NewUser Leave : Char=Lark, Lv=1, Map=2, X=1820.8, Z=483.2

PS_USERLOG__system

2013-02-28 23:01:12 PS_USERLOG__system log start (UserLog)

2013-02-28 23:01:14 connect

2013-02-28 23:01:24 connect

2013-02-28 23:01:32 connect

[Sh1nra]

Maybe this help:

USE [PS_GameData]
GO
DROP Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2]    Script Date: 02/28/2013 23:35:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





CREATE Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]

@CharID int,
@SkillID smallint,
@SkillLevel tinyint,
@LeftResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES(@CharID,@Skillid,@SkillLevel,@LeftResetTime)

IF(@@ERROR = 0)
BEGIN
	RETURN 1
END
ELSE
BEGIN
	RETURN -1
END

SET NOCOUNT OFF

[karakas1997]

İts Created Error When I İnstalled SQL

Error code :

Msg 137, Level 15, State 2, Procedure usp_Save_Char_ApplySkill_Add_E2, Line 17
Must declare the scalar variable "@Skillid".

[Sh1nra]

Originally Posted by RebeccaBlack

Go to your database that contains "CharApplySkills", verify the column is "Skillid" and not "SkillID".
In your SP, you have "@Skillid", but it's not declared anywhere. However you also have "@SkillID" declared as a parameter. Seems like a typo to me, change "@Skillid" to "@SkillID" to match the parameter variable.

Try this

[karakas1997]

Thank you, the problem is solved.

[JohnHeatz]

#Closed