Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Honeybadger24*:

 

new to the forums here

 

we are trying to get adkats working, but we are running into some trouble

 

we got the stat logger working with the database

we have followed the directions to the T

when we put the adkats.cs into the plugins/bf4 folder it will not show up, even after restarting

 

any ideas on why this is not showing up?

[ImportBot]

Originally Posted by Target42*:

 

I am having trouble adding a user and it only gives me this error with certain usernames.

 

Line 0: [GetDisplayPluginVariables][Error while fetching display vars.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

at System.ThrowHelper.ThrowKeyNotFoundException()

at System.Collections.Generic.Dictionary`2.get_Item(T Key key)

at PRoConEvents.AdKats.c__DisplayClasse.b__6(AdKatsPlayer aPlayer)

at System.Linq.Enumerable.WhereSelectEnumerableIterat or`2.MoveNext()

at System.Collections.Generic.List`1.InsertRange(Int3 2 index, IEnumerable`1 collection)

at PRoConEvents.AdKats.GetDisplayPluginVariables()

[00:48:07 53] [AdKats] EXCEPTION: Line 0: [GetDisplayPluginVariables][Error while fetching display vars.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

at System.ThrowHelper.ThrowKeyNotFoundException()

at System.Collections.Generic.Dictionary`2.get_Item(T Key key)

at PRoConEvents.AdKats.c__DisplayClasse.b__6(AdKatsPlayer aPlayer)

at System.Linq.Enumerable.WhereSelectEnumerableIterat or`2.MoveNext()

at System.Collections.Generic.List`1.InsertRange(Int3 2 index, IEnumerable`1 collection)

at PRoConEvents.AdKats.GetDisplayPluginVariables()

 

If I manually delete the user the plugin will work. Again, it only does it with certain usernames.

 

Any suggestions?

[ImportBot]

Originally Posted by HARDCOREBF*:

 

I already replied man. I asked what you did before this happened. Have you tried rebooting your layer?

Hi again , iam very sorry ColColonCleaner for bothering you , but i cant fix this , i really need your help , i trying restarting layer , desabled/enabled adkatz and Logger , its still spamming same msg ever 0.5 seconds . We banned/unbanned players via admin dashboard by ADK , can you guide me plz where to look or how to fix this .

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Hello, ColColonCleaner , is there a way to flash old logs from DB , we have 4 servers and DB is getting huge size , particulary this table

"adkats_records_main " , is there a way to delete old logs via plugins etttings ? or i need manually delete atleast 50% of it to more room for new logs. or how to manage DB size_. plz advise

http://gyazo.com/01fe8704056058184c624c9d01b15db4

[ATTACH=CONFIG]http://i.gyazo.com/01fe8704056058184c624c9d01b15db4.png[/ATTACH]

 

Is this record needed ? "No previous IP on record"

 

40e4e28e37bc6fe777b5e66b943a9919.png

 

Attached Files:

• 01fe8704056058184c624c9d01b15db4.png

[Prophet731]

Originally Posted by Prophet731*:

 

Hello, ColColonCleaner , is there a way to flash old logs from DB , we have 4 servers and DB is getting huge size , particulary this table

"adkats_records_main " , is there a way to delete old logs via plugins etttings ? or i need manually delete atleast 50% of it to more room for new logs. or how to manage DB size_. plz advise

Attachment 3377

Can't view the screenshot. How big is the database? Ours is 6Gb.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

http://gyazo.com/01fe8704056058184c624c9d01b15db4

Sorry , i fixed it

 

Its 1.2 G , where you guys store it ?

[Prophet731]

Originally Posted by Prophet731*:

 

We have our own dedicated box with plenty of storage. From the looks of the table it might be just stuff getting spammed creating a lot of entry's.

 

Our table isn't even close to that big. Only tables that are even close is the chatlog and player stats.

 

Can you export only your adkats_records_main table and gzip compress it and PM a link to where I can download it? Ill look it over and see what junk can be removed. Unless you still just want to remove old data.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

sent PM

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I am having trouble adding a user and it only gives me this error with certain usernames.

 

Line 0: [GetDisplayPluginVariables][Error while fetching display vars.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

at System.ThrowHelper.ThrowKeyNotFoundException()

at System.Collections.Generic.Dictionary`2.get_Item(T Key key)

at PRoConEvents.AdKats.c__DisplayClasse.b__6(AdKatsPlayer aPlayer)

at System.Linq.Enumerable.WhereSelectEnumerableIterat or`2.MoveNext()

at System.Collections.Generic.List`1.InsertRange(Int3 2 index, IEnumerable`1 collection)

at PRoConEvents.AdKats.GetDisplayPluginVariables()

[00:48:07 53] [AdKats] EXCEPTION: Line 0: [GetDisplayPluginVariables][Error while fetching display vars.]: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

at System.ThrowHelper.ThrowKeyNotFoundException()

at System.Collections.Generic.Dictionary`2.get_Item(T Key key)

at PRoConEvents.AdKats.c__DisplayClasse.b__6(AdKatsPlayer aPlayer)

at System.Linq.Enumerable.WhereSelectEnumerableIterat or`2.MoveNext()

at System.Collections.Generic.List`1.InsertRange(Int3 2 index, IEnumerable`1 collection)

at PRoConEvents.AdKats.GetDisplayPluginVariables()

 

If I manually delete the user the plugin will work. Again, it only does it with certain usernames.

 

Any suggestions?

On mobile so can't link right now, but someone recently had the same issue. You have an invalid soldier in your db. Look back a couple pages in here, I posted a version of AdKats that will show you the invalid soldier.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi again , iam very sorry ColColonCleaner for bothering you , but i cant fix this , i really need your help , i trying restarting layer , desabled/enabled adkatz and Logger , its still spamming same msg ever 0.5 seconds . We banned/unbanned players via admin dashboard by ADK , can you guide me plz where to look or how to fix this .

Are there any records in your records table that has adkats_read = N ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

new to the forums here

 

we are trying to get adkats working, but we are running into some trouble

 

we got the stat logger working with the database

we have followed the directions to the T

when we put the adkats.cs into the plugins/bf4 folder it will not show up, even after restarting

 

any ideas on why this is not showing up?

I would suggest checking your download, it might be invalid, this has happened before. Try downloading again, and if that still doesn't fix it, go to the AdKats github and download the .cs from the TEST branch. Once again, on mobile so can't link directly.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Are there any records in your records table that has adkats_read = N ?

1. none of them with = N

2. How can i clean tables to make it lower size , plz help

 

Thnk you in advace

 

EDIT : There was 2 bans that shows DISABLED in adkats_bans , i deleted them , and restarted plugin , and layer , and looks like its not spamming anymore , iam not sure what caused it stop , but works for now ...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

1. none of them with = N

2. How can i clean tables to make it lower size , plz help

 

Thnk you in advace

 

EDIT : There was 2 bans that shows DISABLED in adkats_bans , i deleted them , and restarted plugin , and layer , and looks like its not spamming anymore , iam not sure what caused it stop , but works for now ...

Strange. Disabled bans shouldn't cause that. Might be an edge case of some sort.

 

You can delete any records that are not for bans. Changeip and changename can be the first to go if you want to reduce size.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

can you please tell me what raws number not needed , as like you sad Changeip and changename"

i think there 50 on them . i guess i need this numebr " command_type or command_action"

as you can see om screenshot its 1.2 gb in 1 table , what can cause that ?

 

4b8b852f2e803fb2d2d3e2128acabb7e.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

can you please tell me what raws number not needed , as like you sad Changeip and changename"

i think there 50 on them . i guess i need this numebr " command_type or command_action"

as you can see om screenshot its 1.2 gb in 1 table , what can cause that ?

 

4b8b852f2e803fb2d2d3e2128acabb7e.png

WOW, how the hell do you have 5 million records in there? Ok, delete all records with command_actions 36, 37, 48, 49.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

WOW, how the hell do you have 5 million records in there? Ok, delete all records with command_actions 36, 37, 48, 49.

Eah i know , i have no idea man , ill delete those now

 

Deleted

Now it much better , thnx allot .

c73ac3e4746ad380430e17a0eeab5952.png

[ImportBot]

Originally Posted by ScottSmudger*:

 

I have tried to import the adkats.sql file, also tried to copy and paste, but I kept getting the following error:

 

SQL query: Documentation

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$ CREATE PROCEDURE addLogPlayerID( ) BEGIN -- add logPlayerID column safely

IF NOT EXISTS (

(

SELECT *

FROM information_schema.COLUMNS

WHERE TABLE_SCHEMA = DATABASE( )

AND COLUMN_NAME = 'logPlayerID'

AND TABLE_NAME = 'tbl_chatlog'

)

)

THEN

ALTER TABLE `tbl_chatlog` ADD COLUMN `logPlayerID` INT( 10 ) UNSIGNED DEFAULT NULL ;

 

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$

 

DROP PROCEDURE IF EXISTS addLogPlayerID $$

CREATE PROCEDURE addLog' at line 1

Other than this error, been a flawless install so far.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have tried to import the adkats.sql file, also tried to copy and paste, but I kept getting the following error:

 

 

 

Other than this error, been a flawless install so far.

What program are you trying to use for running the script? I get the same error when trying to run things like this inside AdKats itself, it can't use delimiter changes. Try using MySQL Workbench, or PHPMyAdmin would be my suggestions.

[ImportBot]

Originally Posted by ScottSmudger*:

 

What program are you trying to use for running the script? I get the same error when trying to run things like this inside AdKats itself, it can't use delimiter changes. Try using MySQL Workbench, or PHPMyAdmin would be my suggestions.

I am trying to run the script through PHPMyAdmin. By injecting it and copy/paste.

 

I will give WorkBench a go

[ImportBot]

Originally Posted by ScottSmudger*:

 

What program are you trying to use for running the script? I get the same error when trying to run things like this inside AdKats itself, it can't use delimiter changes. Try using MySQL Workbench, or PHPMyAdmin would be my suggestions.

Workbench had an error too :

 

22:54:23 Restoring C:\Users\Scott\Desktop\adkats.sql

Running: mysql.exe --defaults-file="c:\users\scott\appdata\local\temp\tmp7jn6ga. cnf" --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=bf4

ERROR 1146 (42S02) at line 42: Table 'bf4.tbl_chatlog' doesn't exist

 

Operation failed with exitcode 1

22:54:24 Import of C:\Users\Scott\Desktop\adkats.sql has finished with 1 errors

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Workbench had an error too :

So you haven't installed the stat logger plugin yet?

[ImportBot]

Originally Posted by ScottSmudger*:

 

So you haven't installed the stat logger plugin yet?

Yup, that's installed and working

 

Assuming it giving out 0 errors means its working?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yup, that's installed and working

 

Assuming it giving out 0 errors means its working?

Hmm. If that is working alright then that means you attempted to run the adkats.sql on the wrong database.

 

Table "tbl_chatlog" doesn't exist. It can't find that table to modify. Can you confirm that table exists?

[ImportBot]

Originally Posted by ScottSmudger*:

 

Hmm. If that is working alright then that means you attempted to run the adkats.sql on the wrong database.

 

Table "tbl_chatlog" doesn't exist. It can't find that table to modify. Can you confirm that table exists?

http://puu.sh/8XxIJ.png

 

The database is called "bf4", the I have tried renaming that table, but it still didn't work

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

http://puu.sh/8XxIJ.png

 

The database is called "bf4", the I have tried renaming that table, but it still didn't work

Oh, you added a table suffix option in the stat logger plugin. That needs to be blank. Almost there man!

[ImportBot]

Originally Posted by ScottSmudger*:

 

Oh, you added a table suffix option in the stat logger plugin. That needs to be blank. Almost there man!

Maybe mention that somewhere?

 

Same error :

 

SQL query: Documentation

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$ CREATE PROCEDURE addLogPlayerID( ) BEGIN -- add logPlayerID column safely

IF NOT EXISTS (

(

SELECT *

FROM information_schema.COLUMNS

WHERE TABLE_SCHEMA = DATABASE( )

AND COLUMN_NAME = 'logPlayerID'

AND TABLE_NAME = 'tbl_chatlog'

)

)

THEN

ALTER TABLE `tbl_chatlog` ADD COLUMN `logPlayerID` INT( 10 ) UNSIGNED DEFAULT NULL ;

 

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$

 

DROP PROCEDURE IF EXISTS addLogPlayerID $$

CREATE PROCEDURE add' at line 1

Does there have to be any data in the tables before importing ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Maybe mention that somewhere?

 

Same error :

 

 

 

Does there have to be any data in the tables before importing ?

Almost nobody does that so I never even thought about adding it to the instructions, lol. I'll add that.

 

Ok, since this still isn't working, pm me edit credentials for that schema and I'll set everything up. You won't need to use the delimiter after initial set up, so you'll be golden.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

emails wont be sent...pls have a look here

 

showthread....ent-by-Procon-*!

[ImportBot]

Originally Posted by virusdead*:

 

hello I'm getting errors with Adkats

a thank you help

 

[20:09:40 06] [AdKats] SUCCESS: Populated reputation dictionaries

[20:09:40 06] [AdKats] SUCCESS: Server IP is 94.250.194.179:47200!

[20:09:40 56] [AdKats] ERROR: Database Server info could not be fetched! Make sure XpKiller's Stat Logger is running on this server!

[20:09:40 56] [AdKats] WARNING: Shutting down AdKats.

[20:09:41 96] [AdKats] AdKats 4.2.1.0 Disabled!

[ImportBot]

Originally Posted by TMiland*:

 

Is it possible to add the reported players last chat, like 5 lines or so to the report mail?