ep 6 error.

03/10/2016 01:13 GMCronus#1
well server runs and then it stops. ep 6 .

ps_game.log:*


Quote:
2016-03-09 23:46:21 PS_GAME__system log start (Game01) [GERMANY]

2016-03-09 23:46:21 Cannot Load String DB File

2016-03-09 23:46:24 connect mgr 1488

2016-03-09 23:46:24 Server Version : 0

2016-03-09 23:46:24 connect dbagent 1492

2016-03-09 23:46:24 connect gamelog 1504

2016-03-09 23:46:26 Market End -----------------------

2016-03-09 23:46:27 Start CWorldSendThread=5684

Module list:

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

2016-03-09 23:46:42 <Console input> /nprotectoff

2016-03-09 23:46:42 <Console output> cmd NProtect off ok

2016-03-09 23:46:50 <Console input> /exp2xenable 200

2016-03-09 23:46:50 <Console output> cmd exp2x enable ok(byadmin=1,bysys=0,current ExpX=200.000)

2016-03-10 00:10:48 1 1 SWorker::Run():m_iocp.GetStatus() 121 (912)

2016-03-10 00:10:48 discon client: ( 5, 121) T=000:19:00:000, RC=334,RCS=0, RB=5298,RBS=4, SC=3451,SCS=3, SB=250621,SBS=217





================================================== ==============

2016-03-10 00:52:25 Exception !!!, code=0xC000001D, address=0x004270ED

Minidump write end.....................

0x004270ED ps_game.exe: <unknown symbol>

Stack trace end.....................



Stack trace(all thread) begin.....................



Module list:

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

WARNING: ps_game.exe is not accessible
Symbol search path is: ps_game.pdb
WARNING: ps_game.pdb is not accessible
WARNING: ps_game.pdb is not accessible

Microsoft (R) Windows Debugger Version 6.3.0017.0
Copyright (c) Microsoft Corporation. All rights reserved.


Loading Dump File [C:\ShaiyaServer\PSM_Client\Bin\Log\20160309_234621 _ps_game.dmp]
User Mini Dump File: Only registers, stack and portions of memory are available

Windows Longhorn Version 9200 MP (16 procs) Free x86 compatible
Product: Server, suite: TerminalServer SingleUserTS
Debug session time: Thu Mar 10 00:52:26 2016
System Uptime: not available
Process Uptime: 0 days 1:06:05.000
Symbol search path is: ps_game.pdb
Executable search path is: ps_game.exe
.................................................. ....................................
The call to LoadLibrary(ext) failed, Win32 error 2
"The system cannot find the file specified."
Please check your debugger configuration and/or network access.
The call to LoadLibrary(exts) failed, Win32 error 2
"The system cannot find the file specified."
Please check your debugger configuration and/or network access.
The call to LoadLibrary(uext) failed, Win32 error 2
"The system cannot find the file specified."
Please check your debugger configuration and/or network access.
The call to LoadLibrary(ntsdexts) failed, Win32 error 2
"The system cannot find the file specified."
Please check your debugger configuration and/or network access.
(1698.152c): Illegal instruction - code c000001d (!!! second chance !!!)

thread count = 52
thread 0(6244)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x7690FC3A sechost.dll: GetIdentityProviderInfoByGUID + 1338

0x7690F974 sechost.dll: GetIdentityProviderInfoByGUID + 628

0x7691EDC7 sechost.dll: StartServiceCtrlDispatcherA + 87

0x004FC01B ps_game.exe: <unknown symbol>


thread 1(3920)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x735B33A9 RarePokemon.dll: Start + 1321

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90


thread 2(6696)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x730CA5BD nub.dll: <unknown symbol>

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90


thread 3(3540)

0x770AC7EC ntdll.dll: NtWaitForMultipleObjects + 12

0x72BFC2D9 comsvcs.dll: <unknown symbol>

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90


thread 4(6068)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x5AB0B332 sqlncli11.dll: DllMain + 983

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90


thread 5(6660)

0x770AC7EC ntdll.dll: NtWaitForMultipleObjects + 12

0x767D7B89 KERNEL32.DLL: WaitForMultipleObjects + 25

0x004FA938 ps_game.exe: <unknown symbol>

0xCCCC7684 <unknown module>: <unknown symbol>


thread 6(760)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x004F5A78 ps_game.exe: <unknown symbol>

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90


thread 7(6880)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x004E941B ps_game.exe: <unknown symbol>

0xCCCC7684 <unknown module>: <unknown symbol>


thread 8(5908)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x004E941B ps_game.exe: <unknown symbol>

0xCCCC7684 <unknown module>: <unknown symbol>


thread 9(6964)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x746DC9C6 MSWSOCK.dll: sethostname + 10214

0x76C7E0A9 WS2_32.dll: WSAAccept + 153

0x004E9B6E ps_game.exe: <unknown symbol>


thread 10(3136)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x004E941B ps_game.exe: <unknown symbol>

0xCCCC7684 <unknown module>: <unknown symbol>


thread 11(3160)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x004E941B ps_game.exe: <unknown symbol>

0xCCCC7684 <unknown module>: <unknown symbol>


thread 12(7536)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x004E941B ps_game.exe: <unknown symbol>

0xCCCC7684 <unknown module>: <unknown symbol>


thread 13(2024)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 14(3268)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 15(7528)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 16(6572)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 17(7576)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 18(6116)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 19(5536)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 20(2008)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 21(7976)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 22(6388)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 23(8024)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 24(3944)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 25(4456)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 26(7176)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 27(7532)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 28(2524)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 29(5732)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 30(3716)

0x770AC2CC ntdll.dll: ZwRemoveIoCompletion + 12

0x004F2492 ps_game.exe: <unknown symbol>


thread 31(6028)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x7708DC3B ntdll.dll: RtlInterlockedPushEntrySList + 811

0x7708DC65 ntdll.dll: RtlInterlockedPushEntrySList + 853

0x00428394 ps_game.exe: <unknown symbol>

0x084D8BEC <unknown module>: <unknown symbol>


thread 32(6932)

0x76E4A28A USER32.dll: PeekMessageW + 474

0x7634CBBB combase.dll: StringFromCLSID + 7627

0x76373A8A combase.dll: CoGetCurrentLogicalThreadId + 4650

0x76373ADD combase.dll: CoGetCurrentLogicalThreadId + 4733

0x76359EC9 combase.dll: CoGetProcessIdentifier + 3001

0x7634D7F6 combase.dll: CleanupOleStateInAllTls + 1350

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90


thread 33(5684)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x0040374D ps_game.exe: <unknown symbol>


thread 34(6580)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 35(6772)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 36(4680)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 37(7376)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 38(6944)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 39(8128)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 40(5128)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 41(3216)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 42(3788)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 43(2212)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 44(3660)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 45(3508)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 46(3848)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 47(6112)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 48(6016)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 49(5380)

0x770AC27C ntdll.dll: ZwWaitForSingleObject + 12

0x74882C02 KERNELBASE.dll: WaitForSingleObject + 18

0x00403ADB ps_game.exe: <unknown symbol>


thread 50(5420)

0x770AD04C ntdll.dll: ZwGetContextThread + 12

0x00320190 dbghelp.dll: SymFunctionTableAccess

0x52990C45 <unknown module>: <unknown symbol>


thread 51(7608)

0x770ADD2C ntdll.dll: ZwWaitForWorkViaWorkerFactory + 12

0x767D7C04 KERNEL32.DLL: BaseThreadInitThunk + 36

0x770CAB8F ntdll.dll: RtlInitializeExceptionChain + 143

0x770CAB5A ntdll.dll: RtlInitializeExceptionChain + 90



Stack trace(all thread) end.....................

================================================== ==============

ps userlog is full of:

Quote:
2016-03-10 01:01:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:01:24 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 46080,4671376559079161857,4,'64'

2016-03-10 01:01:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:01:24 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 46080,4671376559079161857,4,'64'

2016-03-10 01:01:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:01:59 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436205,4671375180394659841,4,'64'

2016-03-10 01:01:59 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:01:59 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436205,4671375180394659841,4,'64'

2016-03-10 01:03:18 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:03:18 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436205,4671376962806087681,4,'64'

2016-03-10 01:03:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:03:19 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436205,4671376962806087681,4,'64'

2016-03-10 01:07:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:07:19 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436527,4671373415163101186,9,'0'

2016-03-10 01:07:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'name here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 01:07:19 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436527,4671373415163101186,9,'0'
like hundreds

ps_db-agent:

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

2016-03-09 23:46:24 ### Connect[2560] : Game[?][0x00D98C58], Addr=127.0.0.1, DBJobEnd=1

2016-03-09 23:46:24 ### DB_SYSTEM_CONNECT[5792] :Game[1][0x00D98C58], Name=Game01, Addr=127.0.0.1

2016-03-10 00:52:26 1 1 SAgent::Disconnect: (4, 64)

2016-03-10 00:52:26 1 1 T=001:06:00:000, RC=8429,RCS=2, RB=167015,RBS=42, SC=3025,SCS=0, SB=1897111,SBS=478

2016-03-10 00:52:26 ### Disconnect[5792] : Game[1][0x00D98C58], Name=Game01, Addr=127.0.0.1, DBJobEnd=0

2016-03-10 00:52:26 ### PostDispatchDB[5792] : DB_DISPATCHER_EXIT Game[1][0x00D98C58]

2016-03-10 00:52:26 ### OnDispatchDB[3188] : => DB_DISPATCHER_EXIT Game[1][0x00D98C58]

2016-03-10 00:52:26 ### Save[3188] : Game[1][0x00D98C58]

2016-03-10 00:52:26 ### OnDispatchDB[3188] : <= DB_DISPATCHER_EXIT Game[1][0x00D98C58]

2016-03-10 00:58:53 ### Connect[2560] : Game[?][0x00D98C58], Addr=127.0.0.1, DBJobEnd=1

2016-03-10 00:58:53 ### DB_SYSTEM_CONNECT[5792] :Game[1][0x00D98C58], Name=Game01, Addr=127.0.0.1
03/10/2016 12:56 SempeR93#2
Quote:
Originally Posted by GMCronus View Post
well server runs and then it stops. ep 6 .

ps_game.log:*





ps userlog is full of:


like hundreds

ps_db-agent:
try this one
USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogout_R] Script Date: 03/10/2016 12:54:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Object: Stored Procedure dbo.usp_Try_GameLogout_R Script Date: 2008-6-7 18:34:05 ******/
ALTER Proc [dbo].[usp_Try_GameLogout_R]

/*
Created by humanws, 2005-10-18
???? ?? ??
*/

@[Only registered and activated users can see links. Click Here To Register...]ID int,
@[Only registered and activated users can see links. Click Here To Register...]ID bigint, @[Only registered and activated users can see links. Click Here To Register...]Type smallint = 0, @[Only registered and activated users can see links. Click Here To Register...]ype int = 0

AS

SET NOCOUNT ON

DECLARE @[Only registered and activated users can see links. Click Here To Register...]ime datetime
DECLARE @[Only registered and activated users can see links. Click Here To Register...] nvarchar(4000)
DECLARE @[Only registered and activated users can see links. Click Here To Register...] varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ype bit -- Login:0, Logout:1

SET @[Only registered and activated users can see links. Click Here To Register...]ype = 1
SET @[Only registered and activated users can see links. Click Here To Register...]ime = GETDATE()
SET @[Only registered and activated users can see links. Click Here To Register...] = DATEPART(yyyy, @[Only registered and activated users can see links. Click Here To Register...]ime)
SET @mm = DATEPART(mm, @[Only registered and activated users can see links. Click Here To Register...]ime)
SET @dd = DATEPART(dd, @[Only registered and activated users can see links. Click Here To Register...]ime)

IF( LEN(@mm) = 1 )
BEGIN
SET @mm = '0' + @mm
END

IF( LEN(@dd) = 1 )
BEGIN
SET @dd = '0' + @dd
END

UPDATE Users_Master SET Leave = 0, LeaveDate = GETDATE() WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID
UPDATE PS_GameData.dbo.Chars SET LoginStatus = 0 WHERE UserUID = @[Only registered and activated users can see links. Click Here To Register...]ID

SET @[Only registered and activated users can see links. Click Here To Register...] = N'
INSERT INTO PS_GameLog.dbo.UserLog
(SessionID, UserUID, LogType, LogTime, LogoutType, ErrType)
VALUES @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]ype, @[Only registered and activated users can see links. Click Here To Register...]ime, @[Only registered and activated users can see links. Click Here To Register...]Type, @[Only registered and activated users can see links. Click Here To Register...]ype)'

EXEC sp_executesql @[Only registered and activated users can see links. Click Here To Register...],
N @[Only registered and activated users can see links. Click Here To Register...]ID bigint, @[Only registered and activated users can see links. Click Here To Register...]ID int, @[Only registered and activated users can see links. Click Here To Register...]ype bit, @[Only registered and activated users can see links. Click Here To Register...]ime datetime, @[Only registered and activated users can see links. Click Here To Register...]Type smallint, @[Only registered and activated users can see links. Click Here To Register...]ype int',
@[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]ID, @[Only registered and activated users can see links. Click Here To Register...]ype, @[Only registered and activated users can see links. Click Here To Register...]ime, @[Only registered and activated users can see links. Click Here To Register...]Type, @[Only registered and activated users can see links. Click Here To Register...]ype
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,LogoutTime @[Only registered and activated users can see links. Click Here To Register...]ime,LogoutSession @[Only registered and activated users can see links. Click Here To Register...]ID,LastPlayTime=datediff(minute,LoginTime @[Only registered and activated users can see links. Click Here To Register...]ime)
where useruid @[Only registered and activated users can see links. Click Here To Register...]id

DECLARE @[Only registered and activated users can see links. Click Here To Register...]Time datetime
DECLARE @[Only registered and activated users can see links. Click Here To Register...]PlayTime int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]oint int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ession bigint
SET @[Only registered and activated users can see links. Click Here To Register...]ession=(select LoginSession from PS_userdata.dbo.UserLoginStatus where useruid @[Only registered and activated users can see links. Click Here To Register...]id)
SET @[Only registered and activated users can see links. Click Here To Register...]PlayTime=(select LastPlayTime from PS_userdata.dbo.UserLoginStatus where useruid @[Only registered and activated users can see links. Click Here To Register...]id)
SET @[Only registered and activated users can see links. Click Here To Register...]Time=(select LoginTime from PS_userdata.dbo.UserLoginStatus where useruid @[Only registered and activated users can see links. Click Here To Register...]id)
SET @[Only registered and activated users can see links. Click Here To Register...]oint=(select Point from PS_userdata.dbo.Users_Master where useruid @[Only registered and activated users can see links. Click Here To Register...]id)
IF @[Only registered and activated users can see links. Click Here To Register...]ID @[Only registered and activated users can see links. Click Here To Register...]ession)
BEGIN
INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint ,Addpoint,LoginTime,LogoutTime,SessionID)
values @[Only registered and activated users can see links. Click Here To Register...]id @[Only registered and activated users can see links. Click Here To Register...]oint @[Only registered and activated users can see links. Click Here To Register...]PlayTime @[Only registered and activated users can see links. Click Here To Register...]Time @[Only registered and activated users can see links. Click Here To Register...]ime @[Only registered and activated users can see links. Click Here To Register...]ID)
end

SET NOCOUNT OFF

your error coming from usp_Try_GameLogout_R
03/10/2016 14:27 GMCronus#3
thanks but running that give me this

Quote:
Msg 102, Level 15, State 1, Procedure usp_Try_GameLogout_R, Line 50
Incorrect syntax near '@sEsSiOnID'.
Msg 105, Level 15, State 1, Procedure usp_Try_GameLogout_R, Line 50
Unclosed quotation mark after the character string ',
@sEsSiOnID, @UserUID, @LogType, @LogTime, @LogoutType, @errtype
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,LogoutTime @LogTime,LogoutSession @sEsSiOnID,LastPlayTime=datediff(minute,LoginTime @LogTime)
where useruid @UserUid

DECLARE @LoginTime datetime
DECLARE @LastPlayTime int
DECLARE @oldpoint int
DECLARE @Loginsession bigint
SET @Loginsession=(select LoginSession from PS_userdata.dbo.UserLoginStatus where useruid @UserUid)
SET @LastPlayTime=(select LastPlayTime from PS_userdata.dbo.UserLoginStatus where useruid @UserUid)
SET @LoginTime=(select LoginTime from PS_userdata.dbo.UserLoginStatus where useruid @UserUid)
SET @oldpoint=(select Point from PS_userdata.dbo.Users_Master where useruid @UserUid)
IF @sEsSiOnID @Loginsession)
BEGIN
INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint ,Addpoint,LoginTime,LogoutTime,SessionID)
values @UserUid @oldpoint @LastPlayTime @LoginTime @LogTime @sEsSiOnID)
end

SET NOCOUNT OFF
'.
and i think i found out the dc of ps_game.exe, it's a script. but was so strange at times servr lasted hours with just a few ppl online as this been tested before for weeks. but just a few test ppl
03/10/2016 18:40 SempeR93#4
Quote:
Originally Posted by GMCronus View Post
thanks but running that give me this



and i think i found out the dc of ps_game.exe, it's a script. but was so strange at times servr lasted hours with just a few ppl online as this been tested before for weeks. but just a few test ppl
change @[Only registered and activated users can see links. Click Here To Register...]ID'. to SeseionID it work for me i get same isusess as you if want pm me whit @ SeseionID btw i dont read it Cannot Load String DB File try cn_string file
03/10/2016 18:48 GMCronus#5
i'll test it thanks
03/14/2016 02:13 GMCronus#6
nowi keep getting this alot

Quote:
2016-03-12 16:15:23 ## CheckRecv 125, 390258, 4, 70

2016-03-12 16:15:23 discon client: ( 16, 1236) T=001:06:00:000, RC=46415,RCS=11, RB=414265,RBS=103, SC=59116,SCS=14, SB=543651,SBS=136

2016-03-12 16:20:08 ## CheckRecv 125, 390340, 4, 60

2016-03-12 16:20:08 discon client: ( 16, 1236) T=001:05:00:000, RC=13182,RCS=3, RB=174585,RBS=44, SC=42434,SCS=10, SB=748678,SBS=190

2016-03-12 16:22:44 InsZone Count : CurAll(2), GuildHouse(cur=2,max=4), GuildRank(cur=0,max=0), Party(cur=0,max=1)

2016-03-12 16:26:17 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3492)

2016-03-13 14:42:51 discon client: ( 5, 121) T=002:08:00:000, RC=8634,RCS=1, RB=117185,RBS=15, SC=427007,SCS=55, SB=8155205,SBS=1059

2016-03-13 14:44:00 ## CheckRecv 102, 390258, 4, 90

2016-03-13 14:44:00 discon client: ( 16, 1236) T=000:18:00:000, RC=9503,RCS=8, RB=86826,RBS=79, SC=13920,SCS=12, SB=164509,SBS=150

2016-03-13 14:50:23 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2864)

2016-03-13 14:50:23 discon client: ( 5, 121) T=000:03:00:000, RC=8,RCS=0, RB=232,RBS=1, SC=91,SCS=0, SB=31943,SBS=162

2016-03-13 15:04:36 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3808)

2016-03-13 15:04:36 discon client: ( 5, 121) T=001:59:00:000, RC=4637,RCS=0, RB=60874,RBS=8, SC=271098,SCS=37, SB=5214582,SBS=725

2016-03-13 15:08:49 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3808)

2016-03-13 15:08:49 discon client: ( 5, 121) T=000:03:00:000, RC=18,RCS=0, RB=409,RBS=1, SC=142,SCS=0, SB=32940,SBS=151

2016-03-13 15:16:42 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3136)

2016-03-13 15:16:42 discon client: ( 5, 121) T=000:16:00:000, RC=1136,RCS=1, RB=14091,RBS=13, SC=7262,SCS=7, SB=183775,SBS=180

2016-03-13 15:33:33 ## CheckRecv 170, 371998, 4, 30

2016-03-13 15:33:33 discon client: ( 16, 1236) T=000:20:00:000, RC=4898,RCS=3, RB=50980,RBS=40, SC=8402,SCS=6, SB=170064,SBS=135

2016-03-13 15:37:17 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3576)

2016-03-13 15:37:17 discon client: ( 5, 121) T=000:11:00:000, RC=4,RCS=0, RB=40,RBS=0, SC=68,SCS=0, SB=50366,SBS=74

2016-03-13 16:23:31 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3944)

2016-03-13 16:23:31 discon client: ( 5, 121) T=000:04:00:000, RC=266,RCS=1, RB=3505,RBS=13, SC=1391,SCS=5, SB=69241,SBS=263

2016-03-13 16:24:49 ## CheckRecv 101, 390258, 4, 90

2016-03-13 16:24:49 discon client: ( 16, 1236) T=001:39:00:000, RC=2864,RCS=0, RB=30620,RBS=5, SC=10421,SCS=1, SB=220044,SBS=36

2016-03-13 16:29:40 ## CheckRecv 102, 390258, 4, 90

2016-03-13 16:29:40 discon client: ( 16, 1236) T=000:04:00:000, RC=3077,RCS=12, RB=27477,RBS=108, SC=3914,SCS=15, SB=60987,SBS=241

2016-03-13 16:29:50 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2808)

2016-03-13 16:29:50 discon client: ( 5, 121) T=000:52:00:000, RC=226,RCS=0, RB=1706,RBS=0, SC=7247,SCS=2, SB=194391,SBS=61

2016-03-13 16:31:04 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3780)

2016-03-13 16:31:18 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3436)

2016-03-13 16:31:39 ## CheckRecv 177, 390258, 4, 90

2016-03-13 16:31:39 discon client: ( 16, 1236) T=000:01:00:000, RC=1023,RCS=14, RB=8680,RBS=125, SC=1113,SCS=16, SB=36024,SBS=522

2016-03-13 16:35:25 ## CheckRecv 139, 390258, 4, 90

2016-03-13 16:35:25 discon client: ( 16, 1236) T=000:03:00:000, RC=449,RCS=2, RB=5370,RBS=28, SC=1126,SCS=5, SB=46800,SBS=248

2016-03-13 16:36:47 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3444)

2016-03-13 16:36:47 discon client: ( 5, 121) T=000:43:00:000, RC=5638,RCS=2, RB=68615,RBS=26, SC=25099,SCS=9, SB=485844,SBS=185

2016-03-13 16:39:45 ## CheckRecv 182, 390258, 4, 90

2016-03-13 16:39:45 discon client: ( 16, 1236) T=000:02:00:000, RC=574,RCS=3, RB=4859,RBS=31, SC=667,SCS=4, SB=33999,SBS=219

2016-03-13 16:40:48 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3892)

2016-03-13 16:40:48 discon client: ( 5, 121) T=000:48:00:000, RC=191,RCS=0, RB=1534,RBS=0, SC=8822,SCS=3, SB=222917,SBS=76

2016-03-13 16:41:07 ## CheckRecv 201, 368091, 4, 90

2016-03-13 16:41:07 discon client: ( 16, 1236) T=002:42:00:000, RC=49085,RCS=5, RB=530113,RBS=54, SC=86778,SCS=8, SB=1099586,SBS=112

2016-03-13 16:43:29 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3400)

2016-03-13 16:43:29 discon client: ( 5, 121) T=002:17:00:000, RC=23485,RCS=2, RB=311942,RBS=37, SC=97663,SCS=11, SB=1821179,SBS=220

2016-03-13 16:43:30 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3804)

2016-03-13 16:43:30 discon client: ( 5, 121) T=003:47:00:000, RC=24928,RCS=1, RB=336224,RBS=24, SC=385829,SCS=28, SB=7150974,SBS=524

2016-03-13 16:43:32 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3468)

2016-03-13 16:43:32 discon client: ( 5, 121) T=002:13:00:000, RC=595,RCS=0, RB=6097,RBS=0, SC=24738,SCS=3, SB=543280,SBS=68

2016-03-13 16:46:00 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3332)

2016-03-13 16:46:00 discon client: ( 5, 121) T=000:46:00:000, RC=4467,RCS=1, RB=65703,RBS=23, SC=18100,SCS=6, SB=371473,SBS=132

2016-03-13 16:52:13 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3416)

2016-03-13 16:52:13 discon client: ( 5, 121) T=000:08:00:000, RC=632,RCS=1, RB=7679,RBS=15, SC=4639,SCS=9, SB=127329,SBS=261

2016-03-13 16:52:14 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4060)

2016-03-13 16:52:14 discon client: ( 5, 121) T=000:08:00:000, RC=320,RCS=0, RB=4785,RBS=9, SC=3070,SCS=6, SB=106206,SBS=207

2016-03-13 16:54:48 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4088)

2016-03-13 16:54:48 discon client: ( 5, 121) T=001:35:00:000, RC=17448,RCS=3, RB=167443,RBS=29, SC=50652,SCS=8, SB=837991,SBS=146

2016-03-13 17:01:17 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3416)

2016-03-13 17:01:17 discon client: ( 5, 121) T=000:08:00:000, RC=385,RCS=0, RB=3390,RBS=6, SC=2913,SCS=5, SB=99587,SBS=197

2016-03-13 17:01:25 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3332)

2016-03-13 17:01:25 discon client: ( 5, 121) T=000:08:00:000, RC=1804,RCS=3, RB=20256,RBS=37, SC=3684,SCS=6, SB=90628,SBS=169

2016-03-13 17:09:39 ## CheckRecv 181, 365216, 4, 90

2016-03-13 17:09:39 discon client: ( 16, 1236) T=000:21:00:000, RC=1992,RCS=1, RB=26426,RBS=20, SC=7878,SCS=6, SB=184512,SBS=141

2016-03-13 17:11:00 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3952)

2016-03-13 17:11:00 discon client: ( 5, 121) T=008:16:00:000, RC=7973,RCS=0, RB=110661,RBS=3, SC=322029,SCS=10, SB=6239022,SBS=209

2016-03-13 17:13:31 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3568)

2016-03-13 17:13:31 discon client: ( 5, 121) T=000:01:00:000, RC=3,RCS=0, RB=40,RBS=0, SC=41,SCS=0, SB=20660,SBS=299

2016-03-13 17:15:54 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3136)

2016-03-13 17:15:54 discon client: ( 5, 121) T=000:13:00:000, RC=452,RCS=0, RB=3940,RBS=4, SC=4476,SCS=5, SB=135023,SBS=169

2016-03-13 17:17:09 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3436)

2016-03-13 17:17:09 discon client: ( 5, 121) T=000:44:00:000, RC=232,RCS=0, RB=1718,RBS=0, SC=14079,SCS=5, SB=340246,SBS=126

2016-03-13 17:23:47 InsZone Count : CurAll(1), GuildHouse(cur=1,max=4), GuildRank(cur=0,max=0), Party(cur=0,max=1)

2016-03-13 17:37:00 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2808)

2016-03-13 17:37:00 discon client: ( 5, 121) T=000:24:00:000, RC=257,RCS=0, RB=2891,RBS=1, SC=5064,SCS=3, SB=182041,SBS=125

2016-03-13 17:54:23 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3900)

2016-03-13 17:54:23 discon client: ( 5, 121) T=001:37:00:000, RC=7965,RCS=1, RB=108994,RBS=18, SC=54313,SCS=9, SB=991981,SBS=169

2016-03-13 17:54:30 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4036)

2016-03-13 17:54:30 discon client: ( 5, 121) T=007:47:00:000, RC=46277,RCS=1, RB=492461,RBS=17, SC=179020,SCS=6, SB=2937671,SBS=104

2016-03-13 17:54:30 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3996)

2016-03-13 17:54:30 discon client: ( 5, 121) T=000:56:00:000, RC=114,RCS=0, RB=826,RBS=0, SC=17631,SCS=5, SB=394008,SBS=115

2016-03-13 17:56:24 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4068)

2016-03-13 17:56:24 discon client: ( 5, 121) T=001:34:00:000, RC=2980,RCS=0, RB=44014,RBS=7, SC=27585,SCS=4, SB=675763,SBS=119

2016-03-13 18:04:37 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4120)

2016-03-13 18:04:37 discon client: ( 5, 121) T=000:20:00:000, RC=1717,RCS=1, RB=26485,RBS=21, SC=6805,SCS=5, SB=201743,SBS=160

2016-03-13 18:17:44 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4116)

2016-03-13 18:23:50 InsZone Count : CurAll(5), GuildHouse(cur=5,max=6), GuildRank(cur=0,max=0), Party(cur=0,max=1)

2016-03-13 18:25:23 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4252)

2016-03-13 18:25:23 discon client: ( 5, 121) T=000:20:00:000, RC=1074,RCS=0, RB=15474,RBS=12, SC=11163,SCS=9, SB=360258,SBS=293

2016-03-13 18:33:09 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4364)

2016-03-13 18:33:09 discon client: ( 5, 121) T=000:04:00:000, RC=102,RCS=0, RB=1055,RBS=3, SC=910,SCS=3, SB=60556,SBS=205

2016-03-13 18:41:26 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4460)

2016-03-13 18:41:26 discon client: ( 5, 121) T=000:02:00:000, RC=101,RCS=0, RB=1176,RBS=8, SC=648,SCS=4, SB=54724,SBS=399

2016-03-13 18:55:36 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4380)

2016-03-13 18:55:36 discon client: ( 5, 121) T=000:24:00:000, RC=1558,RCS=1, RB=19425,RBS=13, SC=9665,SCS=6, SB=233934,SBS=156

2016-03-13 19:11:48 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2956)

2016-03-13 19:11:48 discon client: ( 5, 121) T=002:30:00:000, RC=24813,RCS=2, RB=240413,RBS=26, SC=78919,SCS=8, SB=1455178,SBS=161

2016-03-13 19:18:08 ## CheckRecv 159, 386444, 4, 60

2016-03-13 19:18:08 discon client: ( 16, 1236) T=000:17:00:000, RC=4608,RCS=4, RB=55754,RBS=54, SC=13025,SCS=12, SB=280542,SBS=274

2016-03-13 19:21:06 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4116)

2016-03-13 19:21:06 discon client: ( 5, 121) T=000:43:00:000, RC=277,RCS=0, RB=2832,RBS=1, SC=8221,SCS=3, SB=207458,SBS=78

2016-03-13 19:23:53 InsZone Count : CurAll(14), GuildHouse(cur=3,max=8), GuildRank(cur=11,max=12), Party(cur=0,max=1)

2016-03-13 19:30:44 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4376)

2016-03-13 19:30:44 discon client: ( 5, 121) T=001:00:00:000, RC=1654,RCS=0, RB=24851,RBS=6, SC=11779,SCS=3, SB=286594,SBS=78

2016-03-13 19:33:49 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4660)

2016-03-13 19:33:49 discon client: ( 5, 121) T=000:02:00:000, RC=3,RCS=0, RB=36,RBS=0, SC=51,SCS=0, SB=33117,SBS=258

2016-03-13 19:33:54 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4656)

2016-03-13 19:33:54 discon client: ( 5, 121) T=000:02:00:000, RC=3,RCS=0, RB=36,RBS=0, SC=53,SCS=0, SB=28900,SBS=202

2016-03-13 19:34:39 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4184)

2016-03-13 19:34:39 discon client: ( 5, 121) T=000:14:00:000, RC=3170,RCS=3, RB=46458,RBS=54, SC=9450,SCS=11, SB=238985,SBS=279

2016-03-13 19:38:26 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4524)

2016-03-13 19:38:26 discon client: ( 5, 121) T=000:47:00:000, RC=9561,RCS=3, RB=122781,RBS=42, SC=34630,SCS=12, SB=675978,SBS=235

2016-03-13 19:38:32 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4116)

2016-03-13 19:38:32 discon client: ( 5, 121) T=000:05:00:000, RC=41,RCS=0, RB=317,RBS=0, SC=435,SCS=1, SB=51364,SBS=148

2016-03-13 19:44:06 ## CheckRecv 109, 181611, 4, 90

2016-03-13 19:44:06 discon client: ( 16, 1236) T=000:41:00:000, RC=3606,RCS=1, RB=42814,RBS=17, SC=9863,SCS=3, SB=207410,SBS=83

2016-03-13 19:46:16 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3764)

2016-03-13 19:46:16 discon client: ( 5, 121) T=002:26:00:000, RC=12359,RCS=1, RB=147996,RBS=16, SC=75311,SCS=8, SB=1443399,SBS=163

2016-03-13 19:46:20 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4432)

2016-03-13 19:46:20 discon client: ( 5, 121) T=001:08:00:000, RC=4216,RCS=1, RB=51572,RBS=12, SC=38290,SCS=9, SB=804095,SBS=196

2016-03-13 19:46:25 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4000)

2016-03-13 19:46:25 discon client: ( 5, 121) T=002:28:00:000, RC=6800,RCS=0, RB=94879,RBS=10, SC=70133,SCS=7, SB=1444245,SBS=161

2016-03-13 19:46:26 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4240)

2016-03-13 19:46:26 discon client: ( 5, 121) T=001:42:00:000, RC=16808,RCS=2, RB=197046,RBS=32, SC=64478,SCS=10, SB=1198311,SBS=195

2016-03-13 19:46:39 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4132)

2016-03-13 19:46:39 discon client: ( 5, 121) T=001:59:00:000, RC=18209,RCS=2, RB=232955,RBS=32, SC=76537,SCS=10, SB=1692814,SBS=236

2016-03-13 19:48:00 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4720)

2016-03-13 19:48:00 discon client: ( 5, 121) T=000:02:00:000, RC=5,RCS=0, RB=52,RBS=0, SC=62,SCS=0, SB=21009,SBS=149

2016-03-13 20:13:25 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3932)

2016-03-13 20:13:31 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3768)

2016-03-13 20:23:55 InsZone Count : CurAll(4), GuildHouse(cur=4,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=1)

2016-03-13 20:29:27 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4708)

2016-03-13 20:29:27 discon client: ( 5, 121) T=000:50:00:000, RC=225,RCS=0, RB=1630,RBS=0, SC=9809,SCS=3, SB=243616,SBS=80

2016-03-13 20:32:29 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4836)

2016-03-13 20:32:29 discon client: ( 5, 121) T=000:06:00:000, RC=22,RCS=0, RB=373,RBS=0, SC=1782,SCS=4, SB=66178,SBS=171

2016-03-13 20:36:56 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4404)

2016-03-13 20:36:56 discon client: ( 5, 121) T=002:01:00:000, RC=2152,RCS=0, RB=28684,RBS=3, SC=24932,SCS=3, SB=535833,SBS=73

2016-03-13 20:41:34 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4940)

2016-03-13 20:41:34 discon client: ( 5, 121) T=000:04:00:000, RC=15,RCS=0, RB=139,RBS=0, SC=1605,SCS=5, SB=64244,SBS=220

2016-03-13 20:58:51 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4872)

2016-03-13 21:02:59 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4512)

2016-03-13 21:02:59 discon client: ( 5, 121) T=000:26:00:000, RC=213,RCS=0, RB=1711,RBS=1, SC=9594,SCS=5, SB=249637,SBS=155

2016-03-13 21:15:03 1 1 SWorker::Run():m_iocp.GetStatus() 121 (5072)

2016-03-13 21:15:03 discon client: ( 5, 121) T=000:07:00:000, RC=204,RCS=0, RB=2596,RBS=5, SC=1440,SCS=3, SB=68851,SBS=146

2016-03-13 21:16:30 1 1 SWorker::Run():m_iocp.GetStatus() 121 (5068)

2016-03-13 21:16:30 discon client: ( 5, 121) T=000:09:00:000, RC=264,RCS=0, RB=3877,RBS=6, SC=3101,SCS=5, SB=101910,SBS=172

2016-03-13 21:23:58 InsZone Count : CurAll(7), GuildHouse(cur=2,max=8), GuildRank(cur=0,max=13), Party(cur=5,max=5)

2016-03-13 21:58:29 1 1 SWorker::Run():m_iocp.GetStatus() 121 (5100)

2016-03-13 22:21:36 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4608)

2016-03-13 22:21:36 discon client: ( 5, 121) T=000:03:00:000, RC=18,RCS=0, RB=204,RBS=1, SC=605,SCS=3, SB=38876,SBS=209

2016-03-13 22:24:00 InsZone Count : CurAll(1), GuildHouse(cur=1,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=5)

2016-03-13 22:35:46 1 1 SWorker::Run():m_iocp.GetStatus() 121 (2644)

2016-03-13 22:35:46 discon client: ( 5, 121) T=014:26:00:000, RC=25070,RCS=0, RB=284213,RBS=5, SC=110338,SCS=2, SB=2192636,SBS=42

2016-03-13 23:24:03 InsZone Count : CurAll(1), GuildHouse(cur=1,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=5)

2016-03-14 00:12:18 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4936)

2016-03-14 00:12:18 discon client: ( 5, 121) T=000:17:00:000, RC=5203,RCS=4, RB=50480,RBS=48, SC=7908,SCS=7, SB=110646,SBS=106

2016-03-14 00:17:37 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4556)

2016-03-14 00:17:37 discon client: ( 5, 121) T=005:24:00:000, RC=21216,RCS=1, RB=299793,RBS=15, SC=103984,SCS=5, SB=1972275,SBS=101

2016-03-14 00:24:05 InsZone Count : CurAll(2), GuildHouse(cur=2,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=5)

2016-03-14 01:18:21 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4916)

2016-03-14 01:18:21 discon client: ( 5, 121) T=000:02:00:000, RC=16,RCS=0, RB=273,RBS=2, SC=319,SCS=2, SB=32007,SBS=240

2016-03-14 01:20:43 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3764)

2016-03-14 01:20:43 discon client: ( 5, 121) T=000:39:00:000, RC=10827,RCS=4, RB=120860,RBS=50, SC=16798,SCS=7, SB=269745,SBS=113

2016-03-14 01:24:08 InsZone Count : CurAll(2), GuildHouse(cur=2,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=5)

2016-03-14 01:27:15 ## CheckRecv 234, 240825, 4, 15

2016-03-14 01:27:15 discon client: ( 16, 1236) T=000:20:00:000, RC=1750,RCS=1, RB=19817,RBS=16, SC=7016,SCS=5, SB=164251,SBS=133

2016-03-14 01:37:28 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4816)

2016-03-14 01:37:28 discon client: ( 5, 121) T=005:26:00:000, RC=3211,RCS=0, RB=42202,RBS=2, SC=123375,SCS=6, SB=2475834,SBS=126

2016-03-14 01:38:56 1 1 SWorker::Run():m_iocp.GetStatus() 121 (3844)

2016-03-14 01:38:56 discon client: ( 5, 121) T=000:03:00:000, RC=235,RCS=1, RB=2700,RBS=13, SC=1209,SCS=6, SB=50121,SBS=254
PS_GAME__system.log

game still up 5 121 idk 1 account have that item but not been in use for a year LOL, just no can't be the item.

it's many like this i just copied some of them
03/14/2016 02:38 SempeR93#7
Your jungle bosses is the problem, don't have skills you have to add manually on PS_GameDefs.dbo.Mobs , sometimes is when a player click a boss got dc.
03/14/2016 02:42 GMCronus#8
thanks going to check that..


but things like this

Quote:
2016-03-13 20:23:55 InsZone Count : CurAll(4), GuildHouse(cur=4,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=1)

2016-03-13 20:29:27 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4708)

2016-03-13 20:29:27 discon client: ( 5, 121) T=000:50:00:000, RC=225,RCS=0, RB=1630,RBS=0, SC=9809,SCS=3, SB=243616,SBS=80

2016-03-13 20:32:29 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4836)

2016-03-13 20:32:29 discon client: ( 5, 121) T=000:06:00:000, RC=22,RCS=0, RB=373,RBS=0, SC=1782,SCS=4, SB=66178,SBS=171

2016-03-13 20:36:56 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4404)

2016-03-13 20:36:56 discon client: ( 5, 121) T=002:01:00:000, RC=2152,RCS=0, RB=28684,RBS=3, SC=24932,SCS=3, SB=535833,SBS=73

2016-03-13 20:41:34 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4940)

2016-03-13 20:41:34 discon client: ( 5, 121) T=000:04:00:000, RC=15,RCS=0, RB=139,RBS=0, SC=1605,SCS=5, SB=64244,SBS=220

2016-03-13 20:58:51 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4872)

2016-03-13 21:02:59 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4512)

2016-03-13 21:02:59 discon client: ( 5, 121) T=000:26:00:000, RC=213,RCS=0, RB=1711,RBS=1, SC=9594,SCS=5, SB=249637,SBS=155

2016-03-13 21:15:03 1 1 SWorker::Run():m_iocp.GetStatus() 121 (5072)

2016-03-13 21:15:03 discon client: ( 5, 121) T=000:07:00:000, RC=204,RCS=0, RB=2596,RBS=5, SC=1440,SCS=3, SB=68851,SBS=146

2016-03-13 21:16:30 1 1 SWorker::Run():m_iocp.GetStatus() 121 (5068)

2016-03-13 21:16:30 discon client: ( 5, 121) T=000:09:00:000, RC=264,RCS=0, RB=3877,RBS=6, SC=3101,SCS=5, SB=101910,SBS=172

2016-03-13 21:23:58 InsZone Count : CurAll(7), GuildHouse(cur=2,max=8), GuildRank(cur=0,max=13), Party(cur=5,max=5)

2016-03-13 21:58:29 1 1 SWorker::Run():m_iocp.GetStatus() 121 (5100)

2016-03-13 22:21:36 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4608)

2016-03-13 22:21:36 discon client: ( 5, 121) T=000:03:00:000, RC=18,RCS=0, RB=204,RBS=1, SC=605,SCS=3, SB=38876,SBS=209

2016-03-13 22:24:00 InsZone Count : CurAll(1), GuildHouse(cur=1,max=8), GuildRank(cur=0,max=13), Party(cur=0,max=5)

don't realy look like monster thing. and i checked jungel mobs, all have there skills in db for what i see


Quote:
2016-03-13 10:20:43 ## CheckRecv 102, 240101, 4, 90

2016-03-13 10:20:43 discon client: ( 16, 1236) T=000:19:00:000, RC=2825,RCS=2, RB=26131,RBS=22, SC=6292,SCS=5, SB=159942,SBS=136

2016-03-13 10:22:05 ## CheckRecv 149, 390098, 4, 15

2016-03-13 10:22:05 discon client: ( 16, 1236) T=002:13:00:000, RC=24921,RCS=3, RB=259234,RBS=32, SC=74660,SCS=9, SB=1160596,SBS=145

2016-03-13 10:27:44 1 1 SWorker::Run():m_iocp.GetStatus() 121 (4024)

2016-03-13 10:27:44 discon client: ( 5, 121) T=000:43:00:000, RC=4560,RCS=1, RB=58629,RBS=22, SC=25508,SCS=9, SB=491611,SBS=189

2016-03-13 10:30:29 ## CheckRecv 107, 386444, 4, 60

2016-03-13 10:30:29 discon client: ( 16, 1236) T=000:53:00:000, RC=6699,RCS=2, RB=74246,RBS=23, SC=19267,SCS=6, SB=370399,SBS=115

2016-03-13 10:31:49 ## CheckRecv 163, 240101, 4, 90

2016-03-13 10:31:49 discon client: ( 16, 1236) T=000:10:00:000, RC=3446,RCS=5, RB=30324,RBS=50, SC=5401,SCS=9, SB=91432,SBS=152

2016-03-13 10:33:40 ## CheckRecv 197, 390258, 4, 90

2016-03-13 10:33:40 discon client: ( 16, 1236) T=000:17:00:000, RC=249,RCS=0, RB=2248,RBS=2, SC=434,SCS=0, SB=35525,SBS=34

2016-03-13 10:34:26 ## CheckRecv 145, 365694, 4, 30
some more. it all look's like codes. even the (in number) i checked for mobs, wasent even in the game
03/14/2016 03:20 SempeR93#9
hmm its happen on maps dd1 jungle or dd2? people got dc on this map?

if yes find this boss in dd1 jungle and dd2 and change their AI to 1 default is somthing like this 20 21 etc change it in db and monster.sdata and restart server your error is discon client
03/14/2016 04:10 GMCronus#10
none said what map they dc on actualy. i have to ask i guess.. as of now i have no idea where ppl dc.. but thanks

got this:

grr error 10053
and dc

from someon, but that was in ah

and i have this in PS_USERLOG__system.log

Quote:
2016-03-10 19:27:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'a password here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 19:27:11 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436518,4671698956504268801,4,'64'

2016-03-10 19:27:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'password here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 19:27:11 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436518,4671698956504268801,4,'64'

2016-03-10 19:32:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'password here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 19:32:41 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436071,4671699308691587073,1,'64'

2016-03-10 19:32:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'password here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 19:32:42 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 436071,4671699308691587073,1,'64'

2016-03-10 19:34:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'password here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 19:34:35 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 41085,4671700820520075265,1,'64'

2016-03-10 19:34:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value 'password here' to data type int., SQL STATE: 22018, NATIVE ERROR: 245 (0xF5)

2016-03-10 19:34:35 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 41085,4671700820520075265,1,'64'
password here means actualy a pasword, but don't want to show ppl's passwords LOL


and this in PS_GAMELOG__system.log

Quote:
2016-03-13 21:49:09 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',73209,108728,'character name here', 90,32207720,46, 723.874512,38.993053,335.402588, '2016-03-13 21:48:58' ,103, 390138,51640,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'ZeroTix','kill=440022, death=8386, win=48, lose=17',NULL,NULL

2016-03-13 21:49:09 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2016-03-13 21:49:09 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',96052,132564,'character name here', 90,32207720,46, 721.241089,39.605995,321.582764, '2016-03-13 21:48:58' ,103, 390138,51640,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'ZeroTix','kill=107795, death=860, win=15, lose=33',NULL,NULL

2016-03-13 21:49:26 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2016-03-13 21:49:26 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',115203,158483,'character name here', 90,32207721,46, 716.074524,36.383614,429.707794, '2016-03-13 21:49:20' ,103, 382826,19832,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'Magini','kill=183002, death=748, win=5, lose=6',NULL,NULL

2016-03-13 21:49:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 106) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2016-03-13 21:49:31 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',424932,379257,'character name here', 90,32207720,46, 715.198914,42.631874,404.959808, '2016-03-13 21:49:20' ,103, 382826,19832,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'Magini','kill=26711, death=101, win=0, lose=0',NULL,NULL

2016-03-13 21:49:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 195) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2016-03-13 21:49:33 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',162331,355896,'character name here', 90,32207721,46, 719.777893,46.299725,407.177643, '2016-03-13 21:49:20' ,103, 382826,19832,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'Magini','kill=20146, death=172, win=5, lose=3',NULL,NULL

2016-03-13 21:49:34 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 123) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2016-03-13 21:49:34 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',174016,205978,'character name here', 90,32207720,46, 721.786743,38.269653,428.358887, '2016-03-13 21:49:20' ,103, 382826,19832,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'Magini','kill=85462, death=364, win=13, lose=4',NULL,NULL

2016-03-13 21:49:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 129) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)

2016-03-13 21:49:35 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'UserID here',96052,132564,'character name herel', 90,32207720,46, 728.990112,36.876747,439.054901, '2016-03-13 21:49:20' ,103, 382826,19832,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,'Magini','kill=107797, death=860, win=15, lose=33',NULL,NULL

2016-03-13 21:49:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction., SQL STATE: 40001, NATIVE ERROR: 1205 (0x4B5)
this have to do with kills but omg how many errors comming from ep 5 - ep 6 changes LOL
03/15/2016 10:02 ShaiyaDead#11
Quote:
Originally Posted by GMCronus View Post
none said what map they dc on actualy. i have to ask i guess.. as of now i have no idea where ppl dc.. but thanks

got this:

grr error 10053
and dc

from someon, but that was in ah

and i have this in PS_USERLOG__system.log



password here means actualy a pasword, but don't want to show ppl's passwords LOL


and this in PS_GAMELOG__system.log



this have to do with kills but omg how many errors comming from ep 5 - ep 6 changes LOL

GL on Making Patching from EP5 client to full EP6 client if you want use all the release for the EP6 .dll and everything and it will work fine query all the script that is needed then change your ps_game.exe or its easy for you if you use the free release by Juuf on the release section and that will help you but if you wanted to make your work easy then contact both Juuf and Shen to reduce your problem and you can start working on your EP6 but i will just say its better if you just let your players re download a new EP6 client than making alot of Patches just to let your old client runs with the full EP6 one
03/15/2016 13:54 GMCronus#12
i have juuf'spublic server.that'sthe files i have. and i am working with juuf, but there is stuff from ep 5 (my db have 5 years work) that have to join this server.

i will make it some time LOL..

then i can say yes there is a way to transfer ep 5 to ep 6 :-P