About Packet Based Dupe fix

12/11/2012 12:19 guinous#1
Hi epvpers
I have fixed packet based dupe.
So players cant use the packet editor.But game service gettin stoped after 2hours.
I dont remember what kind of changes I've been made.
Can anyone tell me how can i bring to the original.(I have user data and dont want to lose it)
Thank you.
12/11/2012 12:26 nephren#2
Please post logs.

PSM_Client/BIN/Logs - Post it in here.

You also can backup your Users/items/Chars by using SQLScripter or Export/Import which is included.
12/11/2012 12:51 guinous#3
PHP Code:
2012-12-11 11:02:57 PS_GAMELOG__system log start (GameLog01)

2012-12-11 11:03:03 connect game

2012-12-11 11:09:19 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:09:19 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 654.920837,24.820000,1661.852295, '2012-12-11 11:09:19',173, 576096,1331,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:10:00 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:10:00 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 654.920837,24.820000,1661.852295, '2012-12-11 11:10:00',173, 387529,1463,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','BlueLight','Bull's Eye Lv3'

2012-12-11 11:10:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:10:17 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 654.920837,24.820000,1661.852295, '2012-12-11 11:10:17',173, 303612,1187,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:13:05 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:13:05 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1097.010742,35.430000,1044.800415, '2012-12-11 11:13:05',173, 758425,1257,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:13:26 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:13:26 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1097.010742,35.430000,1044.800415, '2012-12-11 11:13:26',173, 687553,1242,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:13:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:13:45 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1097.010742,35.430000,1044.800415, '2012-12-11 11:13:45',173, 626053,757,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:14:02 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:14:02 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1097.010742,35.430000,1044.800415, '2012-12-11 11:14:02',173, 576044,1296,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:14:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:14:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1097.010742,35.430000,1044.800415, '2012-12-11 11:14:24',173, 514529,1367,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:15:13 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:15:13 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1929.748169,29.299999,1900.530640, '2012-12-11 11:15:13',173, 143229,1213,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:17:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:17:24 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 496.826050,18.299999,766.661987, '2012-12-11 11:17:24',173, 780564,1166,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:18:15 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:18:15 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 496.826050,18.299999,766.661987, '2012-12-11 11:18:15',173, 485637,1214,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:19:10 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:19:10 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 496.826050,18.299999,766.661987, '2012-12-11 11:19:10',173, 189078,1425,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:21:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:21:45 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 140.223434,37.430000,118.385880, '2012-12-11 11:21:45',173, 695071,1401,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:22:14 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:22:14 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 140.223434,37.430000,118.385880, '2012-12-11 11:22:14',173, 534794,1220,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:22:34 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:22:34 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 140.223434,37.430000,118.385880, '2012-12-11 11:22:34',173, 437245,1156,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:23:03 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:23:03 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1107.083252,35.430000,1054.641846, '2012-12-11 11:23:03',173, 923103,746,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:23:08 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:23:08 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1107.083252,35.430000,1054.641846, '2012-12-11 11:23:08',173, 902505,1312,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','Num1Killer','Bull's Eye Lv3'

2012-12-11 11:24:29 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:24:29 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1090.604736,35.430000,1067.716797, '2012-12-11 11:24:29',173, 802870,1191,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','Num1Killer','Bull's Eye Lv3'

2012-12-11 11:24:48 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:24:48 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1090.604736,35.430000,1067.716797, '2012-12-11 11:24:48',173, 765907,1125,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','Num1Killer','Bull's Eye Lv3'

2012-12-11 11:25:11 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:25:11 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1090.604736,35.430000,1067.716797, '2012-12-11 11:25:11',173, 681473,1159,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:30:16 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:30:16 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1095.379150,35.430000,1063.097778, '2012-12-11 11:30:16',173, 207455,1234,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','..Loading..','Bull's Eye Lv3'

2012-12-11 11:30:37 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:30:37 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1095.379150,35.430000,1063.097778, '2012-12-11 11:30:37',173, 4650,1435,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','[FS]YoungCrew','Bull's Eye Lv3'

2012-12-11 11:32:45 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:32:45 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:32:45',173, 458942,1070,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:33:04 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:04 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:04',173, 346382,1183,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','Num1Killer','Bull's Eye Lv3'

2012-12-11 11:33:07 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:07 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:07',173, 323133,729,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:33:21 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:21 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:21',173, 253959,1016,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','Num1Killer','Bull's Eye Lv3'

2012-12-11 11:33:27 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:27 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:27',173, 221441,1405,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:33:44 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:44 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:44',173, 133109,1128,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','MinikHunter','Bull's Eye Lv3'

2012-12-11 11:33:54 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:54',173, 72141,1383,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','CruZoR.','Bull's Eye Lv3'

2012-12-11 11:33:57 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:57 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:57',173, 45736,1406,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'?????','damage','Num1Killer','Bull's Eye Lv3' 
12/11/2012 12:55 nephren#4
012-12-11 11:33:54 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E '',0,0,'', 0,0,0, 1602.960205,29.299999,1317.214355, '2012-12-11 11:33:54',173, 72141,1383,1019,NULL,NULL,NULL,NULL,NULL,NULL,NULL ,'?????','damage','CruZoR.','Bull's Eye Lv3'

2012-12-11 11:33:57 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 's'., SQL STATE: 42000, NATIVE ERROR: 102 (0x66)

2012-12-11 11:33:57

Please rename "Bull's eye" it should be the '
SQL does not provide that Special Character.

Restart your Server/Services after that.
12/11/2012 13:09 guinous#5
I changed the skillname Bull's eye.
I'll post the result keep in touch.I wait now to stop by yourself the game service.
Thank you.
12/11/2012 15:20 Truth1010#6
Yea as Peripher already said to answer your problem.

The ' in Bull's Eye was causing the problem. You must remember that the ' character in Database is to quote something, so it thinks it should be looking for ' data ' which it isn't finding, so whenever that skill is used, you get server DC :)

Never seen it do that with a skill, however it does it with some items if your not careful :) (usually the weapons)
12/11/2012 17:18 guinous#7
PHP Code:
2012-12-11 15:53:37 PS_DBAGENT__system log start (DBAgent01)

2012-12-11 15:53:46 connect game, Name=



2012-12-11 15:53:46 connect game, Name=



2012-12-11 15:53:47 1 1 SAgent::Disconnect: (4, 64)

2012-12-11 15:53:47 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=4,SCS=0, SB=114,SBS=0

2012-12-11 15:53:47 disconnect game, Name=Game01



2012-12-11 15:53:47 1 1 SAgent::Disconnect: (4, 64)

2012-12-11 15:53:47 1 1 T=000:00:00:000, RC=1,RCS=0, RB=37,RBS=0, SC=0,SCS=0, SB=0,SBS=0

2012-12-11 15:53:47 disconnect game, Name=Game01



2012-12-11 15:53:47 save all... wait plz... enter /uc



2012-12-11 15:53:47 save market... wait plz...



2012-12-11 15:54:03 connect game, Name=



2012-12-11 15:54:03 connect game, Name= 

What does it stand for?
12/11/2012 17:23 nephren#8
Simple Status. Not an Error.
12/12/2012 11:02 guinous#9
I just renewed the DB and all problems gone :)