Well the NoCheat+ Log isn't in MySQL it's in a .log file and it would have to read an parse all the users actions and import them into the database.
Code:
root@server1 [/home/minecraft/plugins/NoCheatPlus]# cat nocheatplus.log | grep "USER"
12.05.26 02:27:06 [INFO] USER failed moving.nofall: tried to avoid fall damage for ~3.32 blocks. VL 3.
12.05.26 02:28:55 [INFO] USER failed moving.waterwalk. VL 133.
12.05.26 02:28:56 [INFO] USER in survival at -40.45,69.85,152.51 moving to -40.49,69.77,152.47 over distance -0.04,-0.08,-0.04 failed check moving.waterwalk. Total violation level so far 511.
12.05.26 02:29:02 [INFO] USER failed moving.waterwalk. VL 30.
12.05.26 02:29:03 [INFO] USER failed moving.waterwalk. VL 105.
12.05.26 02:29:04 [INFO] USER in survival at -50.44,51.63,142.46 moving to -50.48,51.55,142.42 over distance -0.04,-0.08,-0.04 failed check moving.waterwalk. Total violation level so far 515.
12.05.26 02:29:09 [INFO] USER failed moving.waterwalk. VL 65.
12.05.26 02:29:09 [INFO] USER failed moving.waterwalk. VL 114.
12.05.26 02:29:15 [INFO] USER failed moving.waterwalk. VL 21.
12.05.26 02:29:15 [INFO] USER failed moving.waterwalk. VL 152.
12.05.26 02:29:16 [INFO] USER in survival at -58.43,14.80,134.87 moving to -58.47,14.73,134.84 over distance -0.04,-0.08,-0.04 failed check moving.waterwalk. Total violation level so far 478.
To understand what I just did:
cat opens the file and reads the hold thing.
Using a delimiter | and grep "username" I can get the user I'm looking for.
Than I can take this data and import into the database for easier reading.
(DATA ABOVE IS REAL DATA FROM A USER NOT ASSOCIATED WITH MCSG, EXAMPLE SHOWN IS THE IDEAL WAY I WAS GIVING YOU HOW TO DO IT.)
Now the issue at hand, Couldn't someone just "Abuse the /report" command? Well, yes - but the only "Economy System" we have is the "Point System" and I think charging 3 to 5 points per Report would stop that abuse.
What if someone doesn't care about the points and so many he just spams anyway?
Well I'd put it on a weighted system and more than 2-3 times of the "Same Report" the points start to increase or just bans it automatically from using the command or the plugin can set a time limit anyone who sends in false reports should probably be temp banned for a few days for abusing it.
I think when submitting a report the command should go something like this:
/report [type] [user] [video_id]
Example:
/report Hacking USER je7kYJk
The video_id is for YouTube Link and just grab the id and there you go and Mods can review the video, nocheat data from a Web Interface and even click a "Ban" option globally is what I would do.
Regards,
Cory