- Joined
- Aug 16, 2012
- Messages
- 41
- Reaction score
- 2
Hello, I have been using a good hackshield that prevent other hack such as server crasher, fly hack, aspd hack, blinkers, etc.. but for dupe items it needs further investigation..
I have actually found 1 way that people keeps doing to dupe in my server, first of all try to check my db error log here:
after been researching some website, the Y=-1 error in tbl.general is the one duping in my server.. so i would like to request a trigger query that will monitor the tbl.general
so if someone change their Y value to -1, they will be autobanned by that trigger query
can someone make that trigger query, it will contribute much for all of us in 2.1.6 server
I have actually found 1 way that people keeps doing to dupe in my server, first of all try to check my db error log here:
742 10/13/12 11:50:50 : Query : UPDATE tbl_general SET X=-5942.208008,Y=-1.#QNAN0,Z=-5657.539063,TotalPlayMin=3 WHERE Serial = 566528
743 10/13/12 11:50:50 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
744 10/13/12 11:50:50 : SQLExecDirectA Returns : SQL_ERROR
745 10/13/12 11:53:57 : Query : UPDATE tbl_general SET HP=2202,FP=1542,SP=938,X=-4486.239258,Y=-1.#QNAN0,Z=-2462.383057,TotalPlayMin=11 WHERE Serial = 566523
746 10/13/12 11:53:57 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
747 10/13/12 11:53:57 : SQLExecDirectA Returns : SQL_ERROR
748 10/13/12 11:56:39 : Query : UPDATE tbl_general SET HP=2202,FP=1499,SP=938,Y=-1.#QNAN0,TotalPlayMin=9 WHERE Serial = 566523
749 10/13/12 11:56:39 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
750 10/13/12 11:56:39 : SQLExecDirectA Returns : SQL_ERROR
751 10/13/12 11:59:22 : Query : UPDATE tbl_general SET FP=1535,SP=938,Y=-1.#QNAN0,TotalPlayMin=9 WHERE Serial = 566523
752 10/13/12 11:59:22 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
753 10/13/12 11:59:22 : SQLExecDirectA Returns : SQL_ERROR
754 10/13/12 12:02:49 : Query : UPDATE tbl_general SET FP=1542,SP=938,Y=-1.#QNAN0,TotalPlayMin=10 WHERE Serial = 566523
755 10/13/12 12:02:49 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
756 10/13/12 12:02:49 : SQLExecDirectA Returns : SQL_ERROR
757 10/13/12 12:05:17 : Query : UPDATE tbl_general SET FP=1542,SP=934,Y=-1.#QNAN0,TotalPlayMin=9 WHERE Serial = 566523
758 10/13/12 12:05:17 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
759 10/13/12 12:05:17 : SQLExecDirectA Returns : SQL_ERROR
760 10/13/12 12:06:47 : Query : UPDATE tbl_general SET FP=1542,SP=930,Y=-1.#QNAN0,TotalPlayMin=9 WHERE Serial = 566523
761 10/13/12 12:06:47 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
762 10/13/12 12:06:47 : SQLExecDirectA Returns : SQL_ERROR
763 10/13/12 12:08:20 : Query : UPDATE tbl_general SET FP=1542,SP=934,Y=-1.#QNAN0,TotalPlayMin=9 WHERE Serial = 566523
764 10/13/12 12:08:20 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
765 10/13/12 12:08:20 : SQLExecDirectA Returns : SQL_ERROR
766 10/13/12 12:10:15 : Query : UPDATE tbl_general SET FP=1542,SP=936,Y=-1.#QNAN0,TotalPlayMin=9 WHERE Serial = 566523
767 10/13/12 12:10:15 : SqlState:42000, NativeError:102 Msg:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.
768 10/13/12 12:10:15 : SQLExecDirectA Returns : SQL_ERROR
after been researching some website, the Y=-1 error in tbl.general is the one duping in my server.. so i would like to request a trigger query that will monitor the tbl.general
so if someone change their Y value to -1, they will be autobanned by that trigger query
can someone make that trigger query, it will contribute much for all of us in 2.1.6 server

