|
You last visited: Today at 01:06
Advertisement
Continuous Res Rune Problem (VİDEO)
Discussion on Continuous Res Rune Problem (VİDEO) within the Shaiya Private Server forum part of the Shaiya category.
02/28/2013, 23:09
|
#1
|
elite*gold: 0 
Join Date: Aug 2009
Posts: 52
Received Thanks: 2
|
Continuous Res Rune Problem (VİDEO)
Hello Friends
I installed succesfuly game smoothly but don't record when use Continuous Res Rune
What is wrong? How to fix this.?
|
|
|
|
02/28/2013, 23:18
|
#2
|
elite*gold: 5
Join Date: Mar 2012
Posts: 1,007
Received Thanks: 498
|
Please post your logs
PSM_Client/Bin/Log
|
|
|
|
|
02/28/2013, 23:27
|
#3
|
elite*gold: 0
Join Date: Aug 2009
Posts: 52
Received Thanks: 2
|
PS_DBAGENT__charsave
Code:
//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
Code:
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
Code:
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
Code:
2013-02-28 23:01:16 PS_GAMELOG__system log start (GameLog01)
2013-02-28 23:01:32 connect game
PS_LOGIN__system
Code:
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
Code:
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
Code:
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
|
|
|
|
|
02/28/2013, 23:37
|
#4
|
elite*gold: 5
Join Date: Mar 2012
Posts: 1,007
Received Thanks: 498
|
Maybe this help:
Code:
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
|
|
|
|
|
02/28/2013, 23:45
|
#5
|
elite*gold: 0
Join Date: Aug 2009
Posts: 52
Received Thanks: 2
|
İ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".
|
|
|
|
|
03/01/2013, 07:17
|
#6
|
elite*gold: 5
Join Date: Mar 2012
Posts: 1,007
Received Thanks: 498
|
Quote:
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 
|
|
|
|
|
03/01/2013, 11:15
|
#7
|
elite*gold: 0
Join Date: Aug 2009
Posts: 52
Received Thanks: 2
|
Thank you, the problem is solved.
|
|
|
|
|
03/01/2013, 19:08
|
#8
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,981
|
#Closed
|
|
|
|
 |
Similar Threads
|
Ep 6 Problem Help Deleting rune
12/02/2012 - Shaiya Private Server - 8 Replies
Hello friends, we want to build shaiya server.
We tried to establish Episode 6 alone failed to result.
We need friends to Us to Help About It
Our website is okay.
Exit and re-entered the game in-game by pressing problem rune
When the rune seems to have been deleted.
Skil at the same time
looking for friends to help us
would like to thank
|
Continuous Cyclone
12/30/2010 - CO2 Exploits, Hacks & Tools - 58 Replies
To have continuous cyclone, attack a target, activate cyclone, then open up the
"Instant Help" (located on bottom left corner, to the right of your hp bar).
*If you move, the effect will disappear.*
You may also close the instant help without terminating its effect.
This method is useful if you want to level your weapon proficiency in TG.
I haven't tested it on any other xp skills, so if it works please post reply.
|
MLE Rune Hack Problem
05/04/2009 - Grand Chase - 9 Replies
I've been doing these steps for many-many times.
Actually, I got it working on my first try. But, I forgot to save it in my MLE now, I tried a hundred times to make it work again. Actually I spend 500 aging cores already for the runes. But, I didn't get it working. What seems the problem? :confused:
|
Continuous DC on Round 4+
11/25/2008 - Dekaron - 1 Replies
I get chinese error bug alot on round 4-6 or so, and I think I have edited something wrong.
Here is a cut from ranged mobs:
2380,Horror Dead...
|
Continuous Voting
06/04/2006 - Ragnarok Online - 15 Replies
I've been wonder how do u Continuous Voting on ROtop 100s, 200s
If do u know how, reply too me either on the topic or PMing me.
In English Please
|
All times are GMT +1. The time now is 01:08.
|
|
