Commit Graph

31 Commits

Author SHA1 Message Date
de66ce5b3c added indexing on IP 2024-03-30 21:16:28 +01:00
0e20106089 should be an improvement 2024-03-30 20:30:42 +01:00
155c8198a4 updated query to exclude empty fingerprints and null fingerprints 2024-02-18 11:37:43 +01:00
0165361efc fucked up the parameters 2024-02-17 20:40:35 +01:00
5f04a2f76a fixed sql syntax errors 2024-02-17 16:02:45 +01:00
92096977d9 removed inner join, instead doing subquery 2024-02-15 21:50:32 +01:00
4b01705bba not redoing getclientserial but instead just passing the parameter along the way 2024-01-28 15:34:27 +01:00
jenz
c00a625910 multiple syntax updates to adjust for 1.11.0.6946 SM build 2023-08-29 18:11:52 +02:00
jenz
487a24f278 just adding delay 2023-08-14 12:55:53 +02:00
jenz
eb0ee8dfde re simplified the python flask endpoint, remade the order so after update it dispalys motd in vgui menu invisibly, then after 5 seconds it checks the generated fingerprint for ban avoiding 2023-08-04 23:34:50 +02:00
jenz
28bb26e897 simply adding check for the convar disablehtml motd to check if webapp misses the updates sometimes 2023-08-01 23:49:29 +02:00
jenz
b54644c0ea updated several things 2023-08-01 22:15:35 +02:00
jenz
39f8e99bc8 added mini comment on sourceban about if its same IP or steam ID thats detected 2023-07-08 23:55:50 +02:00
jenz
d5b9191521 redid query so its smaller by just inner joining sourcebans 2023-06-25 17:21:34 +02:00
jenz
cc96bb56a4 replacing while loops with concatting 2023-06-20 23:47:39 +02:00
jenz
fcb88886c9 moved DB connection validity to onmapstart instead of inside timer 2023-06-18 20:34:45 +02:00
jenz
7ddd33ef0d deleting result sets, some bug fixes etc 2023-04-30 15:21:36 +02:00
jenz
334b5bbde4 delete dbresults in more cases, some printing, using getclientserial 2023-04-30 12:14:28 +02:00
jenz
eb0c8f8735 updated to permanent ban by request of ripper 2023-03-18 22:09:04 +01:00
jenz
f51c3c1e60 reducing DB queries from high priority to low or normal, also removed obsolete repository 2023-02-19 15:41:54 +01:00
jenz
94e9b7d949 adding 4 hour long ban for ban avoiding 2023-02-14 21:29:45 +01:00
jenz
595b8f54d2 shortened fingerprint down to single one 2023-02-11 12:46:30 +01:00
jenz
6ff484c3e3 reduced fingerprint cause would not detect all 2023-02-11 01:34:10 +01:00
jenz
d52a19f3d0 removed bool update in sourcemod and added threads to flask 2023-02-08 00:01:15 +01:00
jenz
c63aeb605c added systemctl setup 2023-02-07 22:24:58 +01:00
jenz
0a9c1f1394 updated db create script and updated mysql queries 2023-02-07 20:45:15 +01:00
jenz
a8fac665c9 fixed sourceban sql query 2023-02-03 12:57:30 +01:00
jenz
2d3ef46f86 added discord integration and updated create table script 2023-02-03 11:38:47 +01:00
jenz
532c3212ce added sql check on connection if the player has an active ban 2023-02-03 01:44:45 +01:00
jenz
9f60bbbaa4 updated fingerprint generation 2023-02-02 21:28:49 +01:00
jenz
b080d9cc6f initial commit of ban detection project, still missing features and have to do more in regards to js 2023-02-02 00:19:27 +01:00