|
You last visited: Today at 06:45
Advertisement
ep 6 error.
Discussion on ep 6 error. within the Shaiya PServer Development forum part of the Shaiya Private Server category.
03/10/2016, 01:13
|
#1
|
elite*gold: 0 
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
ep 6 error.
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: isconnect: (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
|
#2
|
elite*gold: 0
Join Date: Jul 2012
Posts: 29
Received Thanks: 15
|
Quote:
Originally Posted by GMCronus
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
???? ?? ??
*/
@  ID int, @ ID bigint, @ Type smallint = 0, @ ype int = 0
AS
SET NOCOUNT ON
DECLARE @ ime datetime DECLARE @ nvarchar(4000)
DECLARE @ varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @ ype bit -- Login:0, Logout:1
SET @ ype = 1 SET @ ime = GETDATE()
SET @ = DATEPART(yyyy, @ ime) SET @mm = DATEPART(mm, @ ime)
SET @dd = DATEPART(dd, @ 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 = @ ID UPDATE PS_GameData.dbo.Chars SET LoginStatus = 0 WHERE UserUID = @ ID
SET @ = N'
INSERT INTO PS_GameLog.dbo.UserLog
(SessionID, UserUID, LogType, LogTime, LogoutType, ErrType)
VALUES @ ID, @ ID, @ ype, @ ime, @ Type, @ ype)'
EXEC sp_executesql @ , N @ ID bigint, @ ID int, @ ype bit, @ ime datetime, @ Type smallint, @ ype int', @ ID, @ ID, @ ype, @ ime, @ Type, @ ype
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,LogoutTime @ ime,LogoutSession @ ID,LastPlayTime=datediff(minute,LoginTime @ ime) where useruid @ id
DECLARE @ Time datetime DECLARE @ PlayTime int
DECLARE @ oint int DECLARE @ ession bigint
SET @ ession=(select LoginSession from PS_userdata.dbo.UserLoginStatus where useruid @ id) SET @ PlayTime=(select LastPlayTime from PS_userdata.dbo.UserLoginStatus where useruid @ id) SET @ Time=(select LoginTime from PS_userdata.dbo.UserLoginStatus where useruid @ id) SET @ oint=(select Point from PS_userdata.dbo.Users_Master where useruid @ id) IF @ ID @ ession)
BEGIN
INSERT INTO PS_userdata.dbo.UserOnlineTimeLog(UserUid,OldPoint ,Addpoint,LoginTime,LogoutTime,SessionID)
values @ id @ oint @ PlayTime @ Time @ ime @ ID)
end
SET NOCOUNT OFF
your error coming from usp_Try_GameLogout_R
|
|
|
|
|
03/10/2016, 14:27
|
#3
|
elite*gold: 0
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
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
|
#4
|
elite*gold: 0
Join Date: Jul 2012
Posts: 29
Received Thanks: 15
|
Quote:
Originally Posted by GMCronus
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 @ 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
|
#5
|
elite*gold: 0
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
i'll test it thanks
|
|
|
|
|
03/14/2016, 02:13
|
#6
|
elite*gold: 0
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
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
|
#7
|
elite*gold: 0
Join Date: Jul 2012
Posts: 29
Received Thanks: 15
|
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
|
#8
|
elite*gold: 0
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
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
|
#9
|
elite*gold: 0
Join Date: Jul 2012
Posts: 29
Received Thanks: 15
|
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
|
#10
|
elite*gold: 0
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
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
|
#11
|
elite*gold: 0
Join Date: Oct 2014
Posts: 233
Received Thanks: 127
|
Quote:
Originally Posted by GMCronus
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
|
#12
|
elite*gold: 0
Join Date: Nov 2012
Posts: 352
Received Thanks: 150
|
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
|
|
|
|
 |
Similar Threads
|
[ENG] Error: Error 1 error C2601: 'HackMain' local function definitions are illegal
08/20/2013 - C/C++ - 1 Replies
So, as the title says I've been encountering an error
Error 1 error C2601: 'HackMain' local function definitions are illegal
I'm running on VC++ (Visual C++)
This is my code:
void HackMain()
{
for (;; )
{
HackThread();
}
|
İbot Error-Error Video- Error İmages-HELP
04/10/2012 - DarkOrbit - 11 Replies
SORRY, MY ENGLİSH VERY BAD.I USE TO GOOGLE TRANSLATE :)
Most people trying to ibot but in my computer İbot not working.
Declared out this error everywhere but I do not get answers
Here's the error Video
http://youtu.be/q0fK09v-K3c
|
API Error Code: 100 API Error Description: Invalid parameter Error Message: redirect_
04/08/2012 - elite*gold Trading - 2 Replies
API Error Code: 100
API Error Description: Invalid parameter
Error Message: redirect_uri URL is not properly formatted
Das bekomme ich wenn ich ne App installiere... ich habe schon 3 Apps richtig installiert, danach kam immer das bei anderen Apps die ich installiert habe..
was heisst das? redirect_uri URL is not properly formatted
|
All times are GMT +1. The time now is 06:46.
|
|
