Advanced In-Game Admin and Ban Enforcer - AdKats

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Sadly thats empty aswell

Code:

PB_SV_BanList 
PunkBuster Server: End of Ban List (0 of 0 displayed)

I do not modify PB bans in any way. After import of procon bans i call banlist.clear, which empties procon's banlist, and later saves the changes to your server's banlist.txt, but this action does not affect PB bans. Something else must have cleared your PB bans.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I may have been overlooking something here, however I have added the plugin to the BF4 folder of my procon. It does not seem to be appearing yet, and I am getting these messages. I suspect I have overlooked something simple, aha.

 

Your massive list of errors...

Which version are you attempting to install? For now install using the BF4 install instructions linked at the beginning of this thread.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I did read that it said to install like any other plugin. I'm new to this, and have only installed a couple plugins so far, most were just one or two files that went into the plugins/bf4 folder. the file with bf3 in its name is making me wonder this

 

do all of the files in the adcats zip go into that folder, or are there some that go into other areas?

 

thank you

You need to install using the BF4 install instructions linked at the beginning of this thread, the one in massive red letters. There is not an official version released for BF4 yet, so that is the beta until a stable version is released.

[ImportBot]

Originally Posted by Morgedoo*:

 

Which version are you attempting to install? For now install using the BF4 install instructions linked at the beginning of this thread.

Sorry about the errors, I thought the more that were there the more information you would get

I am trying to install version 3.5.2.0 from this page https://github.com/ColColonCleaner/AdKats

I believe I have followed the instructions correctly, even if the plugin wasn't working etc. Should it not show up in the plugin list regardless of the dependencies required?

 

Edit: If it would help, I can talk on your TeamSpeak, if you want clearer explanation etc.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Sorry about the errors, I thought the more that were there the more information you would get

I am trying to install version 3.5.2.0 from this page https://github.com/ColColonCleaner/AdKats

I believe I have followed the instructions correctly, even if the plugin wasn't working etc. Should it not show up in the plugin list regardless of the dependencies required?

 

Edit: If it would help, I can talk on your TeamSpeak, if you want clearer explanation etc.

Please use the correct link posted in the guide: myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry36517

[ImportBot]

Originally Posted by Morgedoo*:

 

Sorry for bothering you with that, I had assumed that the latest version that was edited 5 days ago would've worked.

As outlined, it is now working. Thanks ColColonCleaner

[ImportBot]

Originally Posted by jking54*:

 

How soon before compatibility with latest GUID Stats plugin C3?

[ImportBot]

Originally Posted by XpKiller*:

 

Already in progress. Not much has changed between the versions (at least for what AdKats needs), so it should be a rather painless merge.

 

However, he did not update his chatlog table to include player ID. We need this for AdKats webadmin to function, as it will be fetching chat logs by player ID (if a player changes their name you currently lose all reference to previous chat logs). So for the webadmin to function I need to add that column to his table, and use AdKats to store chat logs with player IDs, just like the beta version is right now.

 

AdKats will automatically add that column to the table on first log, and chat will be logged to the table the same way his logger does, except player IDs will be logged as well. So chat logging through his plugin will be disabled, but his tables will still be used.

damn

i forgot it.

[ImportBot]

Originally Posted by jking54*:

 

damn

i forgot it.

Ach du lieber!!!

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

damn

i forgot it.

Id rather not be using my plugin for logging...it's not what AdKats is meant for. I can do it, but since that version if your logger is still new it might be best to add a patch before a lot of people install it.

[ImportBot]

Originally Posted by kyang03*:

 

Trying this for the first time hopefully it will work

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Alright guys, test version that should work with both the BF3 and new Universal versions of XpKiller's Stat logger, on both BF3 and BF4. Let me know how it operates.

 

(Currently 3.6.9.2) https://raw.github.com/ColColonClean...test/AdKats.cs

 

Note: It will automatically disable chat logging through stat logger, and will post chatlogs using it's own internal systems per my previous comments about this issue. Player ID is needed in chat logs for the BF4 version of webadmin.

 

If you get an error about "GameID" not having a default value, I know where it's coming from. It had stopped causing issues for me, but if you get it let me know and i'll give the fix.

[ImportBot]

Originally Posted by tonnic*:

 

Alright guys, test version that should work with both the BF3 and new Universal versions of XpKiller's Stat logger, on both BF3 and BF4. Let me know how it operates.

 

(Currently 3.6.9.2) https://raw.github.com/ColColonClean...test/AdKats.cs

 

Note: It will automatically disable chat logging through stat logger, and will post chatlogs using it's own internal systems per my previous comments about this issue. Player ID is needed in chat logs for the BF4 version of webadmin.

So we don't need to run the script from the beginning thread anymore? It can be run as is on the normal logger database?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So we don't need to run the script from the beginning thread anymore? It can be run as is on the normal logger database?

Just make sure the AdKats tables and stat logger tables are in your database and you're fine.

 

If you are setting up a new database:

 

Install and run the universal version of stat logger: myrcon.net/.../stats-webpage-for-xpkillers-stats-logger-plugin

Run the default AdKats SQL script: https://raw.github.com/ColColonClean...ter/adkats.sql

Install and run the test version of AdKats: https://raw.github.com/ColColonClean...test/AdKats.cs

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Test version updated to 3.6.9.3. Fixed some obscure errors.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

[ImportBot]

Originally Posted by Mavy*:

 

Getting some contradicting info in the console:

Code:

[10:19:52 41] [AdKats] Initializing AdKats 3.6.9.3 components.
[10:19:52 41] [AdKats] SUCCESS: Server IP is 85.236.109.76:19777!
[10:19:52 44] [AdKats] Attempting database connection. Attempt 1 of 5.
[10:19:52 44] [AdKats] SUCCESS: Database connection open.
[10:19:52 51] [AdKats] WARNING: Updating your records table to include source ID. This may take some time if you have many records! Be patient!
[10:19:53 59] [AdKats] ERROR: Unable to add source_id column to records table.
[10:19:53 62] [AdKats] ERROR: Database structure errors detected, not set up for AdKats use.
[10:19:53 63] [AdKats] Attempting database connection. Attempt 1 of 5.
[10:19:53 63] [AdKats] SUCCESS: Database connection open.
[10:19:53 74] [AdKats] SUCCESS: Database confirmed functional for AdKats use.
[10:19:53 90] [AdKats] SUCCESS: Database Server Info Fetched. Server ID is 1!
[10:19:55 00] [AdKats] Enabled! Version: 3.6.9.3
[10:19:55 00] [AdKats] WARNING: Preparing to queue procon bans for import. Please wait.

What table should i be looking at to pinpoint this?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Getting some contradicting info in the console:

Code:

your code

What table should i be looking at to pinpoint this?

Check the adkats_records table. The code that errored out is trying to add a "source_id" column to that table.

[ImportBot]

Originally Posted by Mavy*:

 

The column exists and is NULL for all existing records. Structure dump is below.

Code:

CREATE TABLE IF NOT EXISTS `adkats_records` (
  `record_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `server_id` smallint(5) unsigned NOT NULL,
  `command_type` varchar(45) NOT NULL DEFAULT 'DefaultCommand',
  `command_action` varchar(45) NOT NULL DEFAULT 'DefaultAction',
  `command_numeric` int(11) NOT NULL DEFAULT '0',
  `target_name` varchar(45) NOT NULL DEFAULT 'NoTarget',
  `target_id` int(11) unsigned DEFAULT NULL,
  `source_name` varchar(45) NOT NULL DEFAULT 'NoNameAdmin',
  `source_id` int(11) unsigned DEFAULT NULL,
  `record_message` varchar(100) NOT NULL DEFAULT 'NoMessage',
  `record_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `adkats_read` enum('Y','N') NOT NULL DEFAULT 'N',
  `adkats_web` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`record_id`),
  KEY `source_id` (`source_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='AdKats Records' AUTO_INCREMENT=1138 ;

[ImportBot]

Originally Posted by jking54*:

 

Test version updated to 3.6.9.3. Fixed some obscure errors.

 

https://raw.github.com/ColColonClean...test/AdKats.cs

Is AdKats working now with the updated ...* plugin?

 

nvm, I see the post above, so business as usual with the myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry36517?

 

I'm still showing 3.5.1.3 is this normal?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

The column exists and is NULL for all existing records. Structure dump is below.

Code:

CREATE TABLE IF NOT EXISTS `adkats_records` (
  `record_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `server_id` smallint(5) unsigned NOT NULL,
  `command_type` varchar(45) NOT NULL DEFAULT 'DefaultCommand',
  `command_action` varchar(45) NOT NULL DEFAULT 'DefaultAction',
  `command_numeric` int(11) NOT NULL DEFAULT '0',
  `target_name` varchar(45) NOT NULL DEFAULT 'NoTarget',
  `target_id` int(11) unsigned DEFAULT NULL,
  `source_name` varchar(45) NOT NULL DEFAULT 'NoNameAdmin',
  `source_id` int(11) unsigned DEFAULT NULL,
  `record_message` varchar(100) NOT NULL DEFAULT 'NoMessage',
  `record_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `adkats_read` enum('Y','N') NOT NULL DEFAULT 'N',
  `adkats_web` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`record_id`),
  KEY `source_id` (`source_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='AdKats Records' AUTO_INCREMENT=1138 ;

It appears that it successfully added in the column, but the foreign key and assignment wasn't done. I'll add double checks for those.

 

For now you can run this to get all of your previous source IDs populated:

Code:

UPDATE 
	`adkats_records`
INNER JOIN 
	`tbl_playerdata`
ON 
	`adkats_records`.`source_name` = `tbl_playerdata`.`SoldierName` 
SET 
	`adkats_records`.`source_id` = `tbl_playerdata`.`PlayerID`
WHERE 
	`tbl_playerdata`.`SoldierName` <> 'AutoAdmin' 
AND 
	`tbl_playerdata`.`SoldierName` <> 'AdKats' 
AND 
	`tbl_playerdata`.`SoldierName` <> 'Server' 
AND 
	`tbl_playerdata`.`SoldierName` <> 'BanEnforcer'
AND 
	`adkats_records`.`source_id` IS NULL;

[ImportBot]

Originally Posted by jking54*:

 

Just ran the updated script and now have 21 tables, AdKats adding 7 is this correct?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Just ran the updated script and now have 21 tables, AdKats adding 7 is this correct?

Yes, AdKats adds 6 tables and 1 view.

[ImportBot]

Originally Posted by jking54*:

 

Yes, AdKats adds 6 tables and 1 view.

Ok C3, enabled and seems to be running fine atm

[ImportBot]

Originally Posted by tonnic*:

 

Not sure what to do here:

 

[18:20:56 57] [AdKats] Attempting database connection. Attempt 1 of 5.

[18:20:56 57] [AdKats] SUCCESS: Database connection open.

[18:20:56 58] [AdKats] WARNING: Updating your records table to include source ID. This may take some time if you have many records! Be patient!

[18:20:56 58] [AdKats] ERROR: Unable to add source_id column to records table.

[18:20:56 59] [AdKats] ERROR: Database structure errors detected, not set up for AdKats use.

 

I ran the script and followed your instructions, but I'm sure that based on this, I'm missing something.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Not sure what to do here:

 

[18:20:56 57] [AdKats] Attempting database connection. Attempt 1 of 5.

[18:20:56 57] [AdKats] SUCCESS: Database connection open.

[18:20:56 58] [AdKats] WARNING: Updating your records table to include source ID. This may take some time if you have many records! Be patient!

[18:20:56 58] [AdKats] ERROR: Unable to add source_id column to records table.

[18:20:56 59] [AdKats] ERROR: Database structure errors detected, not set up for AdKats use.

 

I ran the script and followed your instructions, but I'm sure that based on this, I'm missing something.

One other person had this issue so i'm looking into it. Did it shut down AdKats after this? It should have.

[ImportBot]

Originally Posted by tonnic*:

 

One other person had this issue so i'm looking into it. Did it shut down AdKats after this? It should have.

No I had to turn off Adkats manually.

[ImportBot]

Originally Posted by Taverner*:

 

Same issue with stats logger 1.0.0.0 and adkats 3.6.9.3

[ImportBot]

Originally Posted by Mavy*:

 

It appears that it successfully added in the column, but the foreign key and assignment wasn't done. I'll add double checks for those.

 

For now you can run this to get all of your previous source IDs populated:

Ran that and it updated 170 records out of 1500. Keep in mind that i am not seeing any errors in the plugin logs.

The plugin also seems to work ok. If you want/prefer i can start on a new database to see the effects on that.

 

EDIT: Had a coffee and realized the query did work ok. Most of the records are whitelistings so the are supposed to be NULL.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ran that and it updated 170 records out of 1500. Keep in mind that i am not seeing any errors in the plugin logs.

The plugin also seems to work ok. If you want/prefer i can start on a new database to see the effects on that.

Aha! My logic is detecting errors when there aren't any. Fixing and uploading.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

3.6.9.4: Fixed logic in error checking, a couple other obscure errors, and decreased startup time. Let me know.

 

https://raw.github.com/ColColonClean...test/AdKats.cs