Register for your free account! | Forgot your password?

Go Back   elitepvpers › MMORPGs › Shaiya › Shaiya Private Server › Shaiya PServer Development
Disconnect (DC) And Rollback Verison = SQL Server 2008 Disconnect (DC) And Rollback Verison = SQL Server 2008
You last visited: Today at 07:58

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

Disconnect (DC) And Rollback Verison = SQL Server 2008

Discussion on Disconnect (DC) And Rollback Verison = SQL Server 2008 within the Shaiya PServer Development forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2017
Posts: 5
Received Thanks: 0
Arrow Disconnect (DC) And Rollback Verison = SQL Server 2008

Hello,

There is no error code, and a system running smoothly.

But the game constantly to roll back.

I spent 15 minutes in the game.

But game itself rollback.

How to fix this problem?

Server Files Version: 5.4

Help me Please.
zirvesunucum is offline  
Old   #2
 
[GM]SkyLine.™'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2013
Posts: 147
Received Thanks: 174
You need check usp_Save_Char_ApplySkill_Add_E & usp_Save_Char_ApplySkill_Add_E2 procedure or please send logs here.
[GM]SkyLine.™ is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2017
Posts: 5
Received Thanks: 0
Thank you for reply.
zirvesunucum is offline  
Old   #4
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2017
Posts: 5
Received Thanks: 0
Lightbulb Procedures Here

usp_Save_Char_ApplySkill_Add_E Procedure Here:

Code:
USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E]    Script Date: 02/04/2017 23:54:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E]
 [MENTION=395373]Chari[/MENTION]D int, [MENTION=563598]Skilli[/MENTION]D smallint, [MENTION=1658622]skilll[/MENTION]evel tinyint, [MENTION=595758]left[/MENTION]ResetTime smallint

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES [MENTION=395373]Chari[/MENTION]D [MENTION=563598]Skilli[/MENTION]d [MENTION=1658622]skilll[/MENTION]evel [MENTION=595758]left[/MENTION]ResetTime)

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

SET NOCOUNT OFF
usp_Save_Char_ApplySkill_Add_E2 Procedure Here:

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2]    Script Date: 02/04/2017 23:54:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]
 [MENTION=395373]Chari[/MENTION]D int, [MENTION=563598]Skilli[/MENTION]D smallint, [MENTION=1658622]skilll[/MENTION]evel tinyint, [MENTION=595758]left[/MENTION]ResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftResetTime) VALUES [MENTION=395373]Chari[/MENTION]D [MENTION=563598]Skilli[/MENTION]d [MENTION=1658622]skilll[/MENTION]evel [MENTION=595758]left[/MENTION]ResetTime)

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

SET NOCOUNT OFF

PS_GAME LOG :

Code:
2017-02-04 21:36:53 PS_GAME__system log start (Game01) [GERMANY]

2017-02-04 21:36:53 RandomOption Error : ItemID=24070, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24111, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24112, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24118, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24119, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24125, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24126, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24154, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24240, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24249, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24250, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24251, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24252, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24253, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=24254, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39070, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39111, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39112, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39118, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39119, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39125, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39126, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39154, byServer=2, Wis=0

2017-02-04 21:36:53 RandomOption Error : ItemID=39240, byServer=2, Wis=0

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:54 error mob item drop info load error

2017-02-04 21:36:55 connect mgr 1012

2017-02-04 21:36:55 Server Version : 0

2017-02-04 21:36:55 connect dbagent 1016

2017-02-04 21:36:55 connect gamelog 1032

2017-02-04 21:36:55 Market End -----------------------

2017-02-04 21:36:56 cannot open .\Data\Lua\135.lua: No such file or directory

2017-02-04 21:36:56 cannot open .\Data\Lua\145.lua: No such file or directory

2017-02-04 21:36:56 cannot open .\Data\Lua\144.lua: No such file or directory

2017-02-04 21:36:56 cannot open .\Data\Lua\129.lua: No such file or directory

2017-02-04 21:36:56 cannot open .\Data\Lua\126.lua: No such file or directory

2017-02-04 21:36:56 cannot open .\Data\Lua\141.lua: No such file or directory

2017-02-04 21:36:56 cannot open .\Data\Lua\126.lua: No such file or directory

2017-02-04 21:36:56 Start CWorldSendThread=2252

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08

2017-02-04 21:37:07 <Console input> /nprotectoff

2017-02-04 21:37:07 <Console output> cmd NProtect off ok

2017-02-04 21:53:30 discon client: (104,  1236) T=000:12:00:000, RC=1750,RCS=2, RB=25775,RBS=33, SC=4327,SCS=5, SB=75430,SBS=98

2017-02-04 22:13:32 3 1 SERVICE_CONTROL_STOP

2017-02-04 22:13:32 Call save all waiting...

2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)

2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)

2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=45,RCS=0, RB=5506,RBS=2, SC=110,SCS=0, SB=1927,SBS=0

2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=12,RCS=0, RB=345,RBS=0, SC=20,SCS=0, SB=257,SBS=0

2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)

2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=12,SCS=0, SB=196,SBS=0

2017-02-04 22:13:32 discon dbagent ((3,1236, 5506,1927)

2017-02-04 22:13:32 discon userlog ((3,1236, 24,196)

2017-02-04 22:13:32 userlog Connection Lost INFO : T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=12,SCS=0, SB=196,SBS=0

2017-02-04 22:13:32 dbagent Connection Lost INFO : T=000:36:00:000, RC=45,RCS=0, RB=5506,RBS=2, SC=110,SCS=0, SB=1927,SBS=0

2017-02-04 22:13:32 userlog log server disconnection

2017-02-04 22:13:32 db agent server disconnected...

2017-02-04 22:13:32 call disconnectAll...

2017-02-04 22:13:32 1 1 SAgent::Disconnect: (3, 1236)

2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=59,SCS=0, SB=6823,SBS=3

2017-02-04 22:13:32 discon mgr ((3,1236, 345,257)

2017-02-04 22:13:32 discon gamelog ((3,1236, 24,6823)

2017-02-04 22:13:32 mgr Connection Lost INFO : T=000:36:00:000, RC=12,RCS=0, RB=345,RBS=0, SC=20,SCS=0, SB=257,SBS=0

2017-02-04 22:13:32 gamelog Connection Lost INFO : T=000:36:00:000, RC=6,RCS=0, RB=24,RBS=0, SC=59,SCS=0, SB=6823,SBS=3

2017-02-04 22:13:32 mgr server disconnection

2017-02-04 22:13:32 game log server disconnection

2017-02-04 22:13:32 server shutdown Connection INFO : T=000:36:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=3,CReq=3,CCnt=3,DCCnt=3, CTimeT=000:14:00:000,CTimeAvg=000:04:00:000, RBT=26074,RBS=11,RBSC=29,SBT=79566,SBS=36,SBSC=89

2017-02-04 22:13:32 PS_GAME__system log end (Game01)

2017-02-04 22:13:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_DBAGENT LOG:


Code:
2017-02-04 21:36:50 PS_DBAGENT__system log start (DBAgent01)

Module list:

C:\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57

2017-02-04 21:36:55 ### Connect[144] : Game[?][0x00F6EB30], Addr=127.0.0.1, DBJobEnd=1

2017-02-04 21:36:55 ### DB_SYSTEM_CONNECT[3964] :Game[1][0x00F6EB30], Name=Game01, Addr=127.0.0.1

2017-02-04 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable   [MENTION=563598]Skilli[/MENTION]d"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2017-02-04 21:53:29 ::SaveCharacter 6 Basaran ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(6,46,1,900)}

2017-02-04 21:53:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the scalar variable   [MENTION=563598]Skilli[/MENTION]d"., SQL STATE: 42000, NATIVE ERROR: 137 (0x89)

2017-02-04 21:53:29 ::SaveCharacter 6 Basaran ret=1, qerr=-1, {?=call Usp_Save_Char_ApplySkill_Add_E2(6,46,1,900)}

2017-02-04 22:13:32 1 1 SAgent::Disconnect: (4, 64)

2017-02-04 22:13:32 1 1 T=000:36:00:000, RC=110,RCS=0, RB=1927,RBS=0, SC=45,SCS=0, SB=5506,SBS=2

2017-02-04 22:13:32 ### Disconnect[3172] : Game[1][0x00F6EB30], Name=Game01, Addr=127.0.0.1, DBJobEnd=0

2017-02-04 22:13:32 ### PostDispatchDB[3172] : DB_DISPATCHER_EXIT Game[1][0x00F6EB30]

2017-02-04 22:13:32 ### OnDispatchDB[584] : => DB_DISPATCHER_EXIT Game[1][0x00F6EB30]

2017-02-04 22:13:32 3 1 SERVICE_CONTROL_STOP

2017-02-04 22:13:32 ### Save[584] : Game[1][0x00F6EB30]

2017-02-04 22:13:32 ### OnDispatchDB[584] : <= DB_DISPATCHER_EXIT Game[1][0x00F6EB30]

2017-02-04 22:13:32 PS_DBAGENT__system log end (DBAgent01)


2017-02-04 22:13:32 3 1 SService::ServiceCtrlDispatcher(): service shutdown
Please help.
zirvesunucum is offline  
Old   #5
 
[GM]SkyLine.™'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2013
Posts: 147
Received Thanks: 174
Hello,

in 2 procedure you see "Skillid" you need change to SkillID.
[GM]SkyLine.™ is offline  
Thanks
1 User
Reply

« how to use StatusDef Generator?? | [Help] OI Opens 2 times everyday »

Similar Threads Similar Threads
[Verkaufe] Windows Server 2008 / 2008 R2 Lizenzen
03/27/2012 - Off Topic - 2 Replies
Windows Server 2008 / 2008 R2 Lizenzen und falls gewüscht stelle ich auch dem Käufer das Passende Image dazu zur verfügung. Alles 100% legale Keys und auch aus 100% legalen Quellen (Microsoft Partnerprogramme) erworben. Ich kann euch von Web Server Edition bis hin zu Itanium Based alles bieten. Nur solange der Vorrat reicht. Bezahlungsmittel: Paypal (anderes nur in Einzelfällen akzeptabel) Also NUR SOLANGE DER VORRAT REICHT ^^
Rollback bei Server shutdown
06/29/2005 - World of Warcraft - 6 Replies
jeden dienstag oder mittwoch ancht werden ja server runtergefahren, geht das, dsa man maybe mit dem guide ausm hack forum so rollbacked ? also 2 spieler brauch man. spieler 1 stells shice ins AH für xxxx Gold spieler 2 kauft es ~ 10 sekunden vor server shut down und der andere spieler 1 nimmts ausm briefkasten und geht schnel lraus (maybe macht mans 20 sekunden vor shutdown damit man mehr zeit hat) spieler 2 bleibt drinnen bsi er gekcikt wird.



All times are GMT +2. The time now is 07:58.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.