You last visited: Today at 13:46
Advertisement
Weird Errors in my logs
Discussion on Weird Errors in my logs within the Shaiya PServer Development forum part of the Shaiya Private Server category.
11/08/2016, 14:04
#1
elite*gold: 0
Join Date: May 2012
Posts: 18
Received Thanks: 21
Weird Errors in my logs
Hello,
Since I edited my usp_Try_GameLogin_Taiwan and usp_Try_GameLogout_R procedures, I have been receiving such strange errors. Does anybody know what they mean and how to fix them?
Thank you in advance for any help you can provide.
PS_LOGIN__system.log__20161106_125522.log
Code:
2016-11-06 12:55:22 PS_LOGIN__system log start (Login01)
2016-11-06 14:15:07 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1100)
2016-11-06 14:47:40 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1148)
2016-11-06 15:09:28 cmd_auto server info log
user = 8 (0/5000)
2016-11-06 15:09:28 T=001:00:00:000, NumC=8,CMin=0,CMax=12,CAvg=3.00, CAva=175,CReq=175,CCnt=175,DCCnt=167, CTimeT=003:40:00:000,CTimeAvg=000:01:00:000, RBT=35656,RBS=9,RBSC=2,SBT=48024,SBS=13,SBSC=3
2016-11-06 15:09:28 SContext=10(1014/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=10(1014/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 16:09:28 cmd_auto server info log
user = 7 (0/5000)
2016-11-06 16:09:28 T=002:00:00:000, NumC=7,CMin=0,CMax=12,CAvg=3.00, CAva=288,CReq=288,CCnt=288,DCCnt=281, CTimeT=006:55:00:000,CTimeAvg=000:01:00:000, RBT=58833,RBS=8,RBSC=2,SBT=78276,SBS=10,SBSC=3
2016-11-06 16:09:28 SContext=9(1015/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=9(1015/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 17:09:28 cmd_auto server info log
user = 4 (0/5000)
2016-11-06 17:09:28 T=003:00:00:000, NumC=4,CMin=0,CMax=12,CAvg=3.00, CAva=395,CReq=395,CCnt=395,DCCnt=391, CTimeT=010:18:00:000,CTimeAvg=000:01:00:000, RBT=82524,RBS=7,RBSC=2,SBT=108032,SBS=9,SBSC=2
2016-11-06 17:09:28 SContext=6(1018/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=6(1018/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 17:55:16 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 17:55:16 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_122', 4813536308674691073,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 17:56:04 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 17:56:04 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813536514833121281,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 17:56:20 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 17:56:20 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813536600732467201,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 17:57:21 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 17:57:21 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813536884200308737,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 17:58:06 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 17:58:06 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'chaos','serseri_12', 4813537077473837057,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:00:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:00:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silent','serseri_12', 4813538898539970561,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:01:39 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:01:39 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813539160532975617,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:05:32 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:05:32 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813540225684865025,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:06:47 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:06:47 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813540569282248705,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:08:30 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:08:30 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813541046023618561,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:09:29 cmd_auto server info log
user = 12 (0/5000)
2016-11-06 18:09:29 T=004:00:00:000, NumC=12,CMin=0,CMax=15,CAvg=3.00, CAva=547,CReq=547,CCnt=547,DCCnt=535, CTimeT=014:56:00:000,CTimeAvg=000:01:00:000, RBT=114945,RBS=7,RBSC=2,SBT=149373,SBS=10,SBSC=2
2016-11-06 18:09:29 SContext=14(1010/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=14(1010/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 18:11:33 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:11:33 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813541879247273985,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:13:22 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:13:22 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813542381758447617,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:14:18 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:14:18 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813542643751452673,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:14:52 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:14:52 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'chaos','ser', 4813542785485373441,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:15:07 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:15:07 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'chaos','serseri_12', 4813542854204850177,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:19:21 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:19:21 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amantes34','zeugma1979', 4813544031025889281,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:19:38 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:19:38 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amantes34','zeugma1978', 4813544099745366017,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:20:00 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:20:00 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amantes35','zeugma1978', 4813544198529613825,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:20:24 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:20:24 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813544318788698113,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:20:45 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:20:45 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813544408983011329,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:21:28 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:21:28 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813544610846474241,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:21:47 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:21:47 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813544692450852865,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:22:14 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:22:14 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'chaos','serseri_12', 4813544825594839041,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:22:34 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:22:34 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silent','serseri_12', 4813544911494184961,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:24:57 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:24:57 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813545560034246657,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:26:01 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:26:01 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813545847797055489,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:26:21 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:26:21 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1978', 4813545950876270593,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:29:09 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:29:09 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'silentstorm','serseri_12', 4813546706790514689,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:31:40 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:31:40 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813547406870183937,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:32:42 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:32:42 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'salvator','f15157541f42', 4813547690338025473,'94.121.242.53', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 18:40:56 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 18:40:56 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'amante35','zeugma1979', 4813549953785790465,'94.123.205.215', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:06:52 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:06:52 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'alpayco','1', 4813558178648162305,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:09:29 cmd_auto server info log
user = 13 (0/5000)
2016-11-06 19:09:29 T=005:00:00:000, NumC=13,CMin=0,CMax=15,CAvg=3.00, CAva=677,CReq=677,CCnt=677,DCCnt=664, CTimeT=019:39:00:000,CTimeAvg=000:01:00:000, RBT=142804,RBS=7,RBSC=2,SBT=184187,SBS=10,SBSC=2
2016-11-06 19:09:29 SContext=15(1009/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=15(1009/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 19:17:49 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:17:49 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'enginco','151246', 4813561189420236801,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:19:41 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:19:41 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'enginco','151246', 4813561709111279617,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:22:26 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:22:26 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'enginco','151246', 4813562469320491009,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:26:03 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:26:03 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'alpayco','151246', 4813563448573034497,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:26:22 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:26:22 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'enginco','151246', 4813563551652249601,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 19:28:26 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 19:28:26 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'enginco','151246', 4813564118587932673,'213.167.30.48', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:09:29 cmd_auto server info log
user = 5 (1/5000)
2016-11-06 20:09:29 T=006:00:00:000, NumC=5,CMin=0,CMax=15,CAvg=4.00, CAva=764,CReq=764,CCnt=764,DCCnt=759, CTimeT=024:08:00:000,CTimeAvg=000:01:00:000, RBT=161475,RBS=7,RBSC=1,SBT=208841,SBS=9,SBSC=2
2016-11-06 20:09:29 SContext=7(1017/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=7(1017/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 20:47:20 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:47:20 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813586907684405249,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:47:38 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:47:38 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813586980698849281,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:48:18 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:48:18 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813587173972377601,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:49:12 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:49:12 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813587418785513473,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:50:17 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:50:17 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813587715138256897,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:53:09 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:53:09 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813588488232370177,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:53:26 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:53:26 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813588582721650689,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:54:20 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:54:20 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813588827534786561,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 20:54:58 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 20:54:58 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813588990743543809,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:09:29 cmd_auto server info log
user = 3 (0/5000)
2016-11-06 21:09:29 T=007:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=4.00, CAva=868,CReq=868,CCnt=868,DCCnt=865, CTimeT=030:03:00:000,CTimeAvg=000:02:00:000, RBT=184955,RBS=7,RBSC=1,SBT=238217,SBS=9,SBSC=2
2016-11-06 21:09:29 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 21:12:09 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:12:09 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813594810424229889,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:12:48 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:12:48 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813594995107823617,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:15:41 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:15:41 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813595793971740673,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:17:17 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:17:17 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813596236353372161,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:17:44 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:17:44 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813596356612456449,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:18:07 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:18:07 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','babalik', 4813596451101736961,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:40:05 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:40:05 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'babalik','BABALİK', 4813602489825755137,'85.101.105.3', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:48:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:48:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'dsfadfds','fdsfsd', 4813604873532604417,'81.215.140.80', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 21:50:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 21:50:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'kia14','hayat1234', 4813605418993451009,'81.215.140.80', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 22:09:30 cmd_auto server info log
user = 3 (0/5000)
2016-11-06 22:09:30 T=008:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=4.00, CAva=946,CReq=946,CCnt=946,DCCnt=943, CTimeT=036:23:00:000,CTimeAvg=000:02:00:000, RBT=202427,RBS=7,RBSC=1,SBT=259930,SBS=9,SBSC=1
2016-11-06 22:09:30 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 23:09:09 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:09:09 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'muco','112358', 4813629170162597889,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:09:30 cmd_auto server info log
user = 1 (0/5000)
2016-11-06 23:09:30 T=009:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=4.00, CAva=1018,CReq=1018,CCnt=1018,DCCnt=1017, CTimeT=038:58:00:000,CTimeAvg=000:02:00:000, RBT=217959,RBS=6,RBSC=1,SBT=279867,SBS=8,SBSC=1
2016-11-06 23:09:30 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-06 23:09:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:09:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'muco','112358', 4813629333371355137,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:10:05 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:10:05 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'yeshasan1','a', 4813629432155602945,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:10:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:10:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'yahya1','1593574682', 4813629612544229377,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:11:11 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:11:11 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'leon','onurelo12332', 4813629749983182849,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:11:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:11:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'ahmetmustik','ahmetmustik', 4813629887422136321,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:12:06 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:12:06 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'werblade','kalemler0', 4813629986206384129,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:12:46 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:12:46 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'afyokbabo001','Zalimkurt001', 4813630170889977857,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:13:05 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:13:05 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'deniz317','denber123', 4813630252494356481,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:13:50 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:13:50 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'ozaman','kalemler0', 4813630467242721281,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-06 23:14:11 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-06 23:14:11 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'ozaman','kalemler0', 4813630574616903681,'95.13.146.33', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 00:09:30 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 00:09:30 T=010:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=3.00, CAva=1069,CReq=1069,CCnt=1069,DCCnt=1069, CTimeT=039:46:00:000,CTimeAvg=000:02:00:000, RBT=228629,RBS=6,RBSC=1,SBT=294202,SBS=8,SBSC=2
2016-11-07 00:09:30 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 01:09:30 cmd_auto server info log
user = 3 (0/5000)
2016-11-07 01:09:30 T=011:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=3.00, CAva=1109,CReq=1109,CCnt=1109,DCCnt=1106, CTimeT=040:10:00:000,CTimeAvg=000:02:00:000, RBT=236291,RBS=5,RBSC=1,SBT=304771,SBS=7,SBSC=2
2016-11-07 01:09:30 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 02:09:31 cmd_auto server info log
user = 1 (0/5000)
2016-11-07 02:09:31 T=012:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=3.00, CAva=1134,CReq=1134,CCnt=1134,DCCnt=1133, CTimeT=040:55:00:000,CTimeAvg=000:02:00:000, RBT=241532,RBS=5,RBSC=1,SBT=311619,SBS=7,SBSC=2
2016-11-07 02:09:31 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 03:09:31 cmd_auto server info log
user = 2 (0/5000)
2016-11-07 03:09:31 T=013:00:00:000, NumC=2,CMin=0,CMax=15,CAvg=3.00, CAva=1153,CReq=1153,CCnt=1153,DCCnt=1151, CTimeT=041:12:00:000,CTimeAvg=000:02:00:000, RBT=245445,RBS=5,RBSC=1,SBT=316882,SBS=6,SBSC=2
2016-11-07 03:09:31 SContext=4(1020/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=4(1020/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 04:09:31 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 04:09:31 T=014:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=3.00, CAva=1164,CReq=1164,CCnt=1164,DCCnt=1164, CTimeT=042:44:00:000,CTimeAvg=000:02:00:000, RBT=247851,RBS=4,RBSC=1,SBT=320033,SBS=6,SBSC=2
2016-11-07 04:09:31 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 05:09:31 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 05:09:31 T=015:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=2.00, CAva=1169,CReq=1169,CCnt=1169,DCCnt=1169, CTimeT=042:48:00:000,CTimeAvg=000:02:00:000, RBT=248873,RBS=4,RBSC=1,SBT=321444,SBS=5,SBSC=2
2016-11-07 05:09:31 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 06:09:32 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 06:09:32 T=016:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=2.00, CAva=1171,CReq=1171,CCnt=1171,DCCnt=1171, CTimeT=042:48:00:000,CTimeAvg=000:02:00:000, RBT=249261,RBS=4,RBSC=1,SBT=321998,SBS=5,SBSC=2
2016-11-07 06:09:32 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 07:09:32 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 07:09:32 T=017:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=2.00, CAva=1180,CReq=1180,CCnt=1180,DCCnt=1180, CTimeT=042:55:00:000,CTimeAvg=000:02:00:000, RBT=251060,RBS=4,RBSC=1,SBT=324465,SBS=5,SBSC=2
2016-11-07 07:09:32 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 08:09:32 cmd_auto server info log
user = 1 (0/5000)
2016-11-07 08:09:32 T=018:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=2.00, CAva=1197,CReq=1197,CCnt=1197,DCCnt=1196, CTimeT=043:04:00:000,CTimeAvg=000:02:00:000, RBT=254165,RBS=3,RBSC=1,SBT=329044,SBS=5,SBSC=2
2016-11-07 08:09:32 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 09:09:32 cmd_auto server info log
user = 1 (0/5000)
2016-11-07 09:09:32 T=019:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=2.00, CAva=1211,CReq=1211,CCnt=1211,DCCnt=1210, CTimeT=043:11:00:000,CTimeAvg=000:02:00:000, RBT=256882,RBS=3,RBSC=1,SBT=332913,SBS=4,SBSC=2
2016-11-07 09:09:32 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 10:09:33 cmd_auto server info log
user = 1 (0/5000)
2016-11-07 10:09:33 T=020:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=2.00, CAva=1235,CReq=1235,CCnt=1235,DCCnt=1234, CTimeT=043:31:00:000,CTimeAvg=000:02:00:000, RBT=261709,RBS=3,RBSC=1,SBT=339483,SBS=4,SBSC=2
2016-11-07 10:09:33 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 10:44:31 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 10:44:31 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'melek1130440','melek13', 4813973154093334529,'212.252.97.184', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 10:45:05 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 10:45:05 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'melek13','melek1130440', 4813973300122222593,'212.252.97.184', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 10:48:44 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 10:48:44 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'melek13','melek1130440', 4813974309439537153,'212.252.97.184', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 10:49:12 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 10:49:12 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'kubra66','delikız', 4813974446878490625,'212.252.97.184', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 10:49:42 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 10:49:42 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'yozgatlı66','saitnazli', 4813974580022476801,'212.252.97.184', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 11:09:33 cmd_auto server info log
user = 3 (0/5000)
2016-11-07 11:09:33 T=021:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=2.00, CAva=1266,CReq=1266,CCnt=1266,DCCnt=1263, CTimeT=044:18:00:000,CTimeAvg=000:02:00:000, RBT=268352,RBS=3,RBSC=1,SBT=348157,SBS=4,SBSC=2
2016-11-07 11:09:33 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 12:07:34 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 12:07:34 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'cvbnm16','123456789ppP', 4813998185162735617,'31.155.99.6', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 12:07:52 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 12:07:52 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'cvbnm16','123456789ppP', 4813998262472146945,'31.155.99.6', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 12:09:33 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 12:09:33 T=022:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=2.00, CAva=1295,CReq=1295,CCnt=1295,DCCnt=1295, CTimeT=045:03:00:000,CTimeAvg=000:02:00:000, RBT=274975,RBS=3,RBSC=1,SBT=356710,SBS=4,SBSC=2
2016-11-07 12:09:33 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 12:10:22 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 12:10:22 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'cvbnm16','123456789ppP', 4813998958256848897,'31.155.99.6', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 12:12:31 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 12:12:31 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'cvbnm16','123456789ppP', 4813999542372401153,'31.155.99.6', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 12:19:29 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 12:19:29 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'cvbnm16','123456789ppP', 4814001462222782465,'31.155.99.6', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 12:30:28 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 12:30:28 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'cvbnm16','123456789ppp', 4814004481584791553,'31.155.99.6', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 13:09:33 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 13:09:33 T=023:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=1337,CReq=1337,CCnt=1337,DCCnt=1337, CTimeT=045:32:00:000,CTimeAvg=000:02:00:000, RBT=283355,RBS=3,RBSC=1,SBT=368225,SBS=4,SBSC=2
2016-11-07 13:09:33 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 13:40:07 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 13:40:07 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'hsyn33q','q123123123', 4814024710880755713,'85.106.66.138', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 13:40:36 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 13:40:36 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'hsyn33qq','Q123123123q', 4814024852614676481,'85.106.66.138', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 13:40:53 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 13:40:53 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'hsyn33qq','Q123123123q', 4814024925629120513,'85.106.66.138', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 13:43:00 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-07 13:43:00 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'huseyinyildiz33','Q123123123q', 4814025505449705473,'85.106.66.138', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-07 14:09:33 cmd_auto server info log
user = 0 (0/5000)
2016-11-07 14:09:33 T=024:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=1371,CReq=1371,CCnt=1371,DCCnt=1371, CTimeT=046:13:00:000,CTimeAvg=000:02:00:000, RBT=290120,RBS=3,RBSC=1,SBT=377149,SBS=4,SBSC=2
2016-11-07 14:09:33 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 14:51:37 <Console input> /vchkon
2016-11-07 14:51:37 <Console output> cmd version chk on ok
2016-11-07 14:51:52 <Console input> /vchg 12053100
2016-11-07 14:51:52 <Console output> version change ok( 0x12091700 -> 0x12053100 )
2016-11-07 15:09:34 cmd_auto server info log
user = 1 (0/5000)
2016-11-07 15:09:34 T=025:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=1412,CReq=1412,CCnt=1412,DCCnt=1411, CTimeT=046:43:00:000,CTimeAvg=000:01:00:000, RBT=298256,RBS=3,RBSC=1,SBT=388419,SBS=4,SBSC=2
2016-11-07 15:09:34 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 16:09:34 cmd_auto server info log
user = 3 (0/5000)
2016-11-07 16:09:34 T=026:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=1.00, CAva=1460,CReq=1460,CCnt=1460,DCCnt=1457, CTimeT=048:03:00:000,CTimeAvg=000:01:00:000, RBT=308482,RBS=3,RBSC=1,SBT=401793,SBS=4,SBSC=2
2016-11-07 16:09:34 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 16:15:24 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1000)
2016-11-07 16:40:59 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1160)
2016-11-07 17:09:34 cmd_auto server info log
user = 2 (0/5000)
2016-11-07 17:09:34 T=027:00:00:000, NumC=2,CMin=0,CMax=15,CAvg=1.00, CAva=1543,CReq=1543,CCnt=1543,DCCnt=1541, CTimeT=050:18:00:000,CTimeAvg=000:01:00:000, RBT=325395,RBS=3,RBSC=1,SBT=424853,SBS=4,SBSC=2
2016-11-07 17:09:34 SContext=4(1020/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=4(1020/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 18:09:34 cmd_auto server info log
user = 2 (0/5000)
2016-11-07 18:09:34 T=028:00:00:000, NumC=2,CMin=0,CMax=15,CAvg=1.00, CAva=1629,CReq=1629,CCnt=1629,DCCnt=1627, CTimeT=052:20:00:000,CTimeAvg=000:01:00:000, RBT=343338,RBS=3,RBSC=1,SBT=448989,SBS=4,SBSC=2
2016-11-07 18:09:34 SContext=4(1020/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=4(1020/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 19:09:35 cmd_auto server info log
user = 4 (0/5000)
2016-11-07 19:09:35 T=029:00:00:000, NumC=4,CMin=0,CMax=15,CAvg=1.00, CAva=1724,CReq=1724,CCnt=1724,DCCnt=1720, CTimeT=055:11:00:000,CTimeAvg=000:01:00:000, RBT=363038,RBS=3,RBSC=1,SBT=474778,SBS=4,SBSC=2
2016-11-07 19:09:35 SContext=6(1018/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=6(1018/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 20:09:35 cmd_auto server info log
user = 3 (0/5000)
2016-11-07 20:09:35 T=030:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=1.00, CAva=1821,CReq=1821,CCnt=1821,DCCnt=1818, CTimeT=058:42:00:000,CTimeAvg=000:01:00:000, RBT=384885,RBS=3,RBSC=1,SBT=502167,SBS=4,SBSC=2
2016-11-07 20:09:35 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 21:09:35 cmd_auto server info log
user = 4 (0/5000)
2016-11-07 21:09:35 T=031:00:00:000, NumC=4,CMin=0,CMax=15,CAvg=1.00, CAva=1924,CReq=1924,CCnt=1924,DCCnt=1920, CTimeT=061:33:00:000,CTimeAvg=000:01:00:000, RBT=406412,RBS=3,RBSC=1,SBT=530706,SBS=4,SBSC=2
2016-11-07 21:09:35 SContext=6(1018/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=6(1018/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 21:29:08 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1076)
2016-11-07 21:37:10 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1076)
2016-11-07 22:09:36 cmd_auto server info log
user = 3 (0/5000)
2016-11-07 22:09:36 T=032:00:00:000, NumC=3,CMin=0,CMax=15,CAvg=2.00, CAva=2010,CReq=2010,CCnt=2010,DCCnt=2007, CTimeT=064:40:00:000,CTimeAvg=000:01:00:000, RBT=424904,RBS=3,RBSC=1,SBT=554717,SBS=4,SBSC=2
2016-11-07 22:09:36 SContext=5(1019/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=5(1019/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-07 23:09:36 cmd_auto server info log
user = 2 (0/5000)
2016-11-07 23:09:36 T=033:00:00:000, NumC=2,CMin=0,CMax=15,CAvg=2.00, CAva=2078,CReq=2078,CCnt=2078,DCCnt=2076, CTimeT=067:01:00:000,CTimeAvg=000:01:00:000, RBT=439223,RBS=3,RBSC=1,SBT=573658,SBS=4,SBSC=2
2016-11-07 23:09:36 SContext=4(1020/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=4(1020/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 00:09:37 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 00:09:37 T=034:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=2.00, CAva=2132,CReq=2132,CCnt=2132,DCCnt=2132, CTimeT=068:01:00:000,CTimeAvg=000:01:00:000, RBT=450590,RBS=3,RBSC=1,SBT=589084,SBS=4,SBSC=2
2016-11-08 00:09:37 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 01:09:38 cmd_auto server info log
user = 1 (0/5000)
2016-11-08 01:09:38 T=035:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=2179,CReq=2179,CCnt=2179,DCCnt=2178, CTimeT=068:51:00:000,CTimeAvg=000:01:00:000, RBT=459726,RBS=3,RBSC=1,SBT=601696,SBS=4,SBSC=2
2016-11-08 01:09:38 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 02:09:39 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 02:09:39 T=036:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2195,CReq=2195,CCnt=2195,DCCnt=2195, CTimeT=069:03:00:000,CTimeAvg=000:01:00:000, RBT=462934,RBS=3,RBSC=1,SBT=606180,SBS=4,SBSC=2
2016-11-08 02:09:39 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 03:09:39 cmd_auto server info log
user = 1 (0/5000)
2016-11-08 03:09:39 T=037:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=2205,CReq=2205,CCnt=2205,DCCnt=2204, CTimeT=069:16:00:000,CTimeAvg=000:01:00:000, RBT=464881,RBS=3,RBSC=1,SBT=608898,SBS=4,SBSC=2
2016-11-08 03:09:39 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 04:09:39 cmd_auto server info log
user = 1 (0/5000)
2016-11-08 04:09:39 T=038:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=2222,CReq=2222,CCnt=2222,DCCnt=2221, CTimeT=069:29:00:000,CTimeAvg=000:01:00:000, RBT=468465,RBS=3,RBSC=1,SBT=613694,SBS=4,SBSC=2
2016-11-08 04:09:39 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 05:06:31 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:06:31 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Z', 4814437697756069889,'78.178.175.34', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:06:46 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:06:46 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','A', 4814437766475546625,'78.178.175.34', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:07:11 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:07:11 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814437886734630913,'78.178.175.34', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:07:49 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:07:49 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814438054238355457,'78.178.175.34', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:08:23 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:08:23 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814438217447112705,'78.178.175.34', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:09:39 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 05:09:39 T=039:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2225,CReq=2225,CCnt=2225,DCCnt=2225, CTimeT=069:54:00:000,CTimeAvg=000:01:00:000, RBT=469761,RBS=3,RBSC=1,SBT=614733,SBS=4,SBSC=2
2016-11-08 05:09:39 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 05:11:46 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:11:46 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814439136570114049,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:12:10 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:12:10 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'Reis21','q', 4814439239649329153,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:12:45 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:12:45 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814439407153053697,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:13:04 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:13:04 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814439493052399617,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:17:57 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:17:57 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814440833082195969,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:29:43 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:29:43 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814444071487537153,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:30:31 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:30:31 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814444294825836545,'81.214.238.98', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:41:51 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:41:51 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814447408677126145,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:42:36 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:42:36 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814447619130523649,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:46:16 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:46:16 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814448632742805505,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 05:50:12 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 05:50:12 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814449710779596801,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 06:02:01 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 06:02:01 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814454044401598465,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 06:02:28 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 06:02:28 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'reis21','Zcabpehu2117', 4814454181840551937,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 06:02:47 err=-1, [Microsoft][ODBC SQL Server Driver]Query timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)
2016-11-08 06:02:47 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'Reis21','Zcabpehu2117', 4814454263444930561,'78.178.129.140', , SQL STATE: 00000, NATIVE ERROR: 0 (0x0)
2016-11-08 06:09:39 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 06:09:39 T=040:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2236,CReq=2236,CCnt=2236,DCCnt=2236, CTimeT=070:42:00:000,CTimeAvg=000:01:00:000, RBT=472517,RBS=3,RBSC=1,SBT=617858,SBS=4,SBSC=2
2016-11-08 06:09:39 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 07:09:40 cmd_auto server info log
user = 1 (0/5000)
2016-11-08 07:09:40 T=041:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=2246,CReq=2246,CCnt=2246,DCCnt=2245, CTimeT=070:47:00:000,CTimeAvg=000:01:00:000, RBT=474414,RBS=3,RBSC=1,SBT=620568,SBS=4,SBSC=2
2016-11-08 07:09:40 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 08:09:40 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 08:09:40 T=042:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2260,CReq=2260,CCnt=2260,DCCnt=2260, CTimeT=071:00:00:000,CTimeAvg=000:01:00:000, RBT=477264,RBS=3,RBSC=1,SBT=624559,SBS=4,SBSC=2
2016-11-08 08:09:40 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 08:53:48 1 1 SWorker::Run():m_iocp.GetStatus() 121 (1240)
2016-11-08 09:09:40 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 09:09:40 T=043:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2283,CReq=2283,CCnt=2283,DCCnt=2283, CTimeT=071:43:00:000,CTimeAvg=000:01:00:000, RBT=482147,RBS=3,RBSC=1,SBT=631060,SBS=4,SBSC=2
2016-11-08 09:09:40 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 10:09:40 cmd_auto server info log
user = 1 (0/5000)
2016-11-08 10:09:40 T=044:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=2310,CReq=2310,CCnt=2310,DCCnt=2309, CTimeT=072:26:00:000,CTimeAvg=000:01:00:000, RBT=487998,RBS=3,RBSC=1,SBT=638643,SBS=4,SBSC=2
2016-11-08 10:09:40 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 11:09:41 cmd_auto server info log
user = 2 (0/5000)
2016-11-08 11:09:41 T=045:00:00:000, NumC=2,CMin=0,CMax=15,CAvg=1.00, CAva=2333,CReq=2333,CCnt=2333,DCCnt=2331, CTimeT=072:49:00:000,CTimeAvg=000:01:00:000, RBT=493059,RBS=3,RBSC=1,SBT=645155,SBS=3,SBSC=2
2016-11-08 11:09:41 SContext=4(1020/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=4(1020/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 12:09:41 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 12:09:41 T=046:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2365,CReq=2365,CCnt=2365,DCCnt=2365, CTimeT=076:16:00:000,CTimeAvg=000:01:00:000, RBT=499913,RBS=3,RBSC=1,SBT=654357,SBS=3,SBSC=2
2016-11-08 12:09:41 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 13:09:41 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 13:09:41 T=047:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2396,CReq=2396,CCnt=2396,DCCnt=2396, CTimeT=076:55:00:000,CTimeAvg=000:01:00:000, RBT=506421,RBS=2,RBSC=1,SBT=663084,SBS=3,SBSC=2
2016-11-08 13:09:41 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 14:09:42 cmd_auto server info log
user = 1 (0/5000)
2016-11-08 14:09:42 T=048:00:00:000, NumC=1,CMin=0,CMax=15,CAvg=1.00, CAva=2449,CReq=2449,CCnt=2449,DCCnt=2448, CTimeT=077:35:00:000,CTimeAvg=000:01:00:000, RBT=517382,RBS=2,RBSC=1,SBT=677924,SBS=3,SBSC=2
2016-11-08 14:09:42 SContext=3(1021/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=3(1021/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
2016-11-08 15:09:42 cmd_auto server info log
user = 0 (0/5000)
2016-11-08 15:09:42 T=049:00:00:000, NumC=0,CMin=0,CMax=15,CAvg=1.00, CAva=2470,CReq=2470,CCnt=2470,DCCnt=2470, CTimeT=078:28:00:000,CTimeAvg=000:01:00:000, RBT=521908,RBS=2,RBSC=1,SBT=683776,SBS=3,SBSC=2
2016-11-08 15:09:42 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0)
SSyncQueueStatus::SQueueStatusNode=0(1024/1024)
PS_USERLOG__system.log__20161106_125512.log
Code:
2016-11-06 12:55:12 PS_USERLOG__system log start (UserLog)
2016-11-06 12:55:14 connect
2016-11-06 12:55:22 connect
2016-11-06 12:55:24 connect
2016-11-06 23:35:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 85) 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-11-06 23:35:13 DBWrite::LogLogin: err=-1, query=EXEC usp_Try_GameLogout_R 5693,4813525914853834753,4,'64'
Procedures :
usp_Try_GameLogin_Taiwan
USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogin_Taiwan] Script Date: 8.11.2016 20:43:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
-- ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]
ALTER Proc [dbo].[usp_Try_GameLogin_Taiwan]
@
varchar(18),
@InPassword varchar(32),
@
ID bigint,
@
varchar(15),
@
ID int = 0,
@
Type smallint = 1,
@
Time datetime = NULL
AS
SET NOCOUNT ON
DECLARE
@
smallint = null, -- processing result value, use as a flag to follow the login sequence
@
tinyint, -- user Leave state
@
smallint, -- user Status
@
varchar(32), -- plain password (may not exist)
@
_pass binary(32), -- digest of password (may not exist)
@
bit = 0, -- does static IP used?
@
IP varchar(15) = NULL, -- optional unique IP allowed to log-in
@
IP varchar(15), -- optional checking of the IP of users-with-rights
@
Date datetime = NULL, -- possible date of end of ban for UserID or IP
@
ounter smallint = NULL, -- number of consecutive login attempts for a given IP
@
smallint = 0, -- number of consecutive login attempts for a given account
@
Ctr smallint, -- the maximal allowed consecutive login attempts (to be tuned acc. yours needs/wishs)
@
P varchar(15),
@
int,
@
Queue int,
@
leased datetime,
@
Date datetime,
@
INT,
@
tatus INT,
@
ID INT,
@
INT,
@
INT
set @
= ltrim(rtrim @
))
set @
Time = GetDate()
--------------------------------------------------
-- SETUP PARAMETERS
-- set the class C address (the 3 first digit of an IPv4 address) that admins shall use
-- set @
IP = '127.0.0'
-- set @
IP = '192.168.0'
-- or set it to NULL to disable the test
set @
IP = NULL
-- maximal allowed consecutive login attempts failures (to be tuned acc. yours needs/wishs)
set @
Ctr = 5
--------------------------------------------------
-- check whether the IP is already banned
-- * BlockEndDate is not null if IP was banned, and null otherwise
-- * ipCounter is read for later use
select @
Date=BlockEndDate @
ounter=TryCounter from IP_Block where UserIP @
-- does IP currently banned?
if @
Date is not null
begin
-- check whether ban is still running (not expired)
if @
Date > @
Time
begin
-- set result to 'Account (actually IP) blocked'
set @
= -9
-- suspend this thread/request for 5mn to avoid DoS attacks
waitfor delay '00:05'
end
else
-- ban is expired, unblock the IP, reset its try counter
update IP_Block set TryCounter=0,BlockEndDate=NULL where UserIP @
end
if @
is null
begin
-- try to select a record with given UserID (= account name)
select @
ID=UserUID @
=Pw @
_pass=HashPw @
=Status @
=Leave,
@
=StaticIP @
IP=UserIp @
Date=BlockEndDate @
=TryCounter
from Users_Master where UserID @
-- does record found?
if @
ID = 0
begin
-- no account exist for the given name (UserID)
-- could be an alias mistyping or an attack to discover a valid UserID
if @
ounter is null
-- first invalid login attempt from that IP, create a new entry
insert into IP_Block (UserIP,TryCounter,BlockEndDate) values @
, 1, NULL)
else
begin
-- increase try counter
set @
ounter = @
ounter + 1
-- does maximal number of consecutive login failures reached?
if @
ounter >= @
Ctr
-- ban this IP for one hour (to be tuned acc. yours needs/wishs)
update IP_Block set TryCounter @
ounter,BlockEndDate=DateAdd(hour, 1, @
Time) where UserIP @
else
update IP_Block set TryCounter @
ounter where UserIP @
end
-- store 'account doesn't exist' info
set @
= -3
end
else -- UserUID is valid, so UserID was a valid user account name
begin
-- does account currently banned?
if @
Date is not null
begin
-- check whether ban is still running (not expired)
if @
Date > @
Time
begin
-- set result to 'Account blocked'
set @
= -9
-- suspend this thread/request for 3mn to avoid DoS attacks
waitfor delay '00:03'
end
else
-- ban is expired, unblock the account, reset its try counter
update Users_Master set TryCounter=0,BlockEndDate=NULL where UserID @
end
-- does account closed?
if @
is null and @
= 1
begin
set @
= -3 -- account doesn't exist
end
-- does static IP to be used?
if @
is null and @
=1
begin
-- check used IP against allowed one
if @
IP <> @
set @
= -10 -- account restricted
end
-- optional IP tests on admin. accounts (don't use it if your admins can log from any IP)
if @
is null and @
IP is not null and @
& 0x70) <> 0
begin
-- extract the 3 first decimal numbers of the given IP
declare @
alIP varchar(15)
set @
alIP = reverse @
)
set @
alIP = reverse(SubString @
alIP, CharIndex('.', @
alIP) + 1, 32))
-- compare the class C addresses
if @
alIP <> @
IP
set @
= -11 -- account restricted
end
-- do all tests passed?
if @
is null
begin
-- verify password, or hash of password
declare @
Result bit = 0
if @
_pass is not null
begin
-- verify hash of password
if HashBytes('SHA1', @InPassword) = @
_pass
set @
Result = 1
end
else
begin
-- verify plain password
if @InPassword = @
and @
is not null
set @
Result = 1
end
-- update try counter of account, and opt. date of ban, if verification failed
if @
Result = 0
begin
-- increase account try counter
set @
= @
+ 1
-- block account if nbr of consecutive login failure reached the limit
if @
>= @
Ctr
begin
-- block account for 1hr (or whatever delay you want)
set @
Date = DateAdd(hour, 1, @
Time)
set @
= -5 -- account blocked
end
else
begin
set @
Date = NULL
set @
= -15 -- account restricted
end
end
else
begin
-- password verification was successful, reset the account try counter
set @
= 0
set @
Date = NULL
set @
= 0
end
-- update account details, block it if required
update Users_Master set TryCounter @
,BlockEndDate @
Date where UserID @
end
end
end
-- log the login details @
ype = 0 for login (1 for logout))
exec usp_Insert_LoginLog_E @
ID, @
ID, @
, @
Time, 0, @
-- for all errors return 'account restricted' msg
-- (don't give accurate answers regarding validity of UserID to not help hackers)
if @
< 0
set @
= 2
-- check Multi Login Account
SELECT @
=Exception FROM dbo.Users_Master WHERE UserUID = @
ID
if @
= 0
begin
select @
tatus =loginstatus from PS_userdata.dbo.UserLoginStatus where UserIP = @
AND LoginStatus = 1
if @
tatus = 1
begin
select @
ID =UserUID from PS_userdata.dbo.UserLoginStatus where UserIP = @
and LoginStatus = 1
SELECT @
=Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID = @
ID
SELECT @
=Country FROM PS_GameData.dbo.UserMaxGrow WHERE UserUID = @
ID
if @
!= @
begin
SET @
= 81
end
end
end
-- Select
SELECT @
AS Status, @
ID AS UserUID
-- Log Insert
IF( @
= 0 OR @
= 16 OR @
= 32 OR @
= 48 OR @
= 64 OR @
= 80 )
BEGIN
EXEC usp_Insert_LoginLog_E @
ID @
ID, @
ID @
ID, @
@
, @
ype=0, @
ime @
Time, @
Type @
Type
if @
ID=(select UserUID from PS_userdata.dbo.UserLoginStatus where UserUID = @
ID)
update PS_userdata.dbo.UserLoginStatus
set loginstatus=1,UserIP @
,LoginTime @
Time, LogoutTime @
Time,loginSession @
ID,lastplaytime=0
where UserUID @
ID
else
insert into PS_userdata.dbo.UserLoginStatus(UserUID,UserIP,log instatus,logintime,logouttime,loginsession,lastpla ytime) values @
ID @
,1 @
Time @
Time @
ID,0)
end
-- select expected response fields
select @
as Status, @
ID as UserUID
--Check for IP ban, if so set the status of the user to banned.
IF(SELECT COUNT(*) FROM [GM_Stuff].[dbo].[BannedIP] where [IP1] = @
) > 0
BEGIN
SELECT @
ID=UserUID FROM Users_Master WHERE UserID = @
SET @
= -2
UPDATE PS_UserData.dbo.Users_Master SET [Status] = @
WHERE UserID = @
END
IF(SELECT COUNT(*) FROM PS_UserData.dbo.Users_Master where [UserIp] = @
and [Status] = '-2') > 0
BEGIN
-- if previous section returns results witch means the ip is attatched to an account previously ip banned
IF(SELECT COUNT(*) FROM [GM_Stuff].[dbo].[BannedIP] where [UserID] = @
) > 0
UPDATE [GM_Stuff].[dbo].[BannedIP] SET [LogAtempt] = 'TRUE' WHERE UserID = @
Else INSERT INTO [GM_Stuff].[dbo].[BannedIP] (UserID,BanDate,IP1,StaffID,StaffIP,[LogAtempt],UserUID,DaysBan)
Values @
,GETDATE() @
,'OtoBan','127.0.0.1','TRUE' @
ID,'permabann')
END
--Check if 3day and 14day banments are ready for release then do so if ready
SELECT @
leased = TimeReleased From GM_Stuff.dbo.BannedAccounts Where UserID = @
IF ( @
leased < GETDATE())
BEGIN
UPDATE PS_UserData.dbo.Users_Master SET [Status] = 0 WHERE UserID @
DELETE FROM GM_Stuff.dbo.BannedAccounts WHERE UserID @
END
SELECT @
ID=UserUID, @
=Status @
Queue=UseQueue, @
=Leave FROM Users_Master WHERE UserID = @
-- NotExist User OR Leave User
IF( @
ID = 0)
BEGIN
SET @
= -3
END
-- Dupe fix section
ELSE IF @
= 1) --This blocks a logged in account from being kicked
BEGIN
SET @
= 15
END
ELSE IF (DATEDIFF(SECOND, @
Date, GETDATE()) < 6)--This is the time delay
BEGIN
SET @
= -7
END
-- verified email at regestration check
--ELSE IF @
Queue='0')
--BEGIN
--SET @
= -7
--END
ELSE
BEGIN
-- Check Password
EXEC dbo.sp_LoginSuccessCheck @
, @InPassword, @
output
IF ( @
OR = 0 )
BEGIN
IF( @
<> 1 )
BEGIN
SET @
= -1
END
END
ELSE
BEGIN
SET @
= -1
END
END
SET NOCOUNT OFF
usp_Try_GameLogout_R
USE [PS_UserData]
GO
/****** Object: StoredProcedure [dbo].[usp_Try_GameLogout_R] Script Date: 8.11.2016 20:41:34 ******/
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]
@
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_GameLog.dbo.UserLog
SET LogTime @
ime, LogoutType @
Type, ErrType @
ype
WHERE UserUID @
ID AND SessionID @
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,loginSession @
ID,lastplaytime=0 where useruid @
ID
SET NOCOUNT OFF
11/10/2016, 11:14
#2
elite*gold: 0
Join Date: Oct 2012
Posts: 175
Received Thanks: 28
Obviously, the query took too much time, led to deadlock. I think that you missed some conditions in where clause, please re-check.
[Help] 2 very weird/unexpected errors.
12/07/2011 - CO2 Private Server - 3 Replies
EDIT:
This is the Error(s) I'm getting when I try to launch the Elite-CoEmu world server.
== Welcome to Elite-CoEmu v5095 ==
== This Program is for Non Profitable and Entertainment Purposes Only ==
Starting to Initialize
MySql.Data.MySqlClient.MySqlException: Host 'Computer-PC' is not allowed to connect to this MySQL server
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.Open()
Weird.... Just weird ( inside )
08/05/2011 - Shaiya Private Server - 14 Replies
Windows 2008 webserver S2 , service pack 4 , 64 bit Os. when i go to install Sql 2005 it does its little pre install check list, well i get a warning on asp.net , it tells me that 64 bit is installed and mysql report services require 32 bit.. So i sorta stumble around a bit, well i ran across Banes tut on sql 2008 , so i thought allright lets try it. as i click on the installserver.bat for the client,, the cmd prompt comes up, goes thew it steps, then tells me that Shaiya is not...
[Guide] 2 Fixes on Sro-Errors (no bot-errors)
03/04/2011 - SRO Guides & Templates - 5 Replies
Hey guys,
here are 2 fixes for silkroad-errors (not bot-errors!). I know they dont appear for many people but some guys have problems with it.
1st Fix: "Server is undergoing inspection..."
Why does this error appear?
Because Joymax has some problems with the Login-Servers.
Fix:
Step1): Click on "Start" then on "Run"
[iBot]Weird Errors.
11/07/2010 - Silkroad Online - 2 Replies
Hello guys I have got an problem after I had clientless on when I try to start SRO again its giving me weird errors such as:Net Error(Fatal Error),Signature Error
ThanQ
Luclevon
hmm weird
02/18/2010 - Dekaron - 6 Replies
i got a little problem... since about 2 weeks i always dc in crespo dungeon when i go in there alone. is there a problem with my internet speed or something? what could i do against it? (except for getting better internet... i dont need ironic answers like this :P )
All times are GMT +2. The time now is 13:46 .
![[ADM]KEFARET's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar4449596_1.gif){kind=avatar}
Weird Errors in my logs
varchar(18),![[ADM]KEFARET is offline](images/elitepvpers/statusicon/user_offline.gif){kind=small}
