Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by MadSochi*:

 

Try this version of the setup script: https://raw.githubusercontent.com/Co...ter/adkats.sql

This script was imported to AdKats database without errors. Thanks.

 

P.S. Fix please the sql script in zip archive.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

This script was imported to AdKats database without errors. Thanks.

 

P.S. Fix please the sql script in zip archive.

That will be fixed when the next patch happens. Most likely tomorrow.

[ImportBot]

Originally Posted by MadSochi*:

 

[11:46:34 95] [AdKats] SUCCESS: Database confirmed functional for AdKats use.

[11:46:35 14] [AdKats] ERROR: Unable to confirm timing controls. Global UTC Timestamp could not be fetched.

[11:46:35 15] [AdKats] SUCCESS: Database timing confirmed.

[11:46:35 51] [AdKats] SUCCESS: Database server info fetched. Server ID is 1.

 

11 57 33_4ea968cb.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

There was a suggestion someone made a while back about excluding kills from the ticket rate calculations, but that idea was shot down as it would not work for every mode, and is inaccurate due to revives. However, modifying it, i'm attempting to work from a spawn standpoint instead of a kill standpoint for conquest, domination, and chainlink, all of which have flags and spawns affecting ticket count the same way. I do not remember who made the original suggestion.

 

The goal of this is to create a more accurate ticket rate for flag positions, regardless of the amount players in the server, and as a result, the number of kills happening on the server. This modified rate will not be calculated unless the following two cases are met:

 

1. Both teams start with the same ticket count (Excludes rush)

2. Team ticket rates are negative or zero (Excludes TDM)

 

This is a secondary ticket rate, with the original intact, and will work as follows.

 

Every time a server info tick happens the ticket difference is calculated, that number being less than or equal to 0. The number of linked spawns (spawns that are uniquely associated with the player dying) that happened since the previous server info tick are added back to the negative ticket count difference, lessening the impact of kills.

 

Testing will be done early tomorrow.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

[11:46:34 95] [AdKats] SUCCESS: Database confirmed functional for AdKats use.

[11:46:35 14] [AdKats] ERROR: Unable to confirm timing controls. Global UTC Timestamp could not be fetched.

[11:46:35 15] [AdKats] SUCCESS: Database timing confirmed.

[11:46:35 51] [AdKats] SUCCESS: Database server info fetched. Server ID is 1.

 

11 57 33_4ea968cb.png

Those two things are not linked. That is the correct date for expiration. The messages are being made more readable in the next patch. Thanks.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Is there a way to disabled "kicked Player rejoined the server" ? its really spaming chatbox , lots of complaint from admins. thnk you in advance

screenshot

http://gyazo.com/c9a145ca72d0ab58a4e379002b8953d4

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Is there a way to disabled "kicked Player rejoined the server" ? its really spaming chatbox , lots of complaint from admins. thnk you in advance

screenshot

http://gyazo.com/c9a145ca72d0ab58a4e379002b8953d4

You had 6 players who were kicked in the last 10 minutes rejoin your server at the same time?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Those of you running auto-surrender on conquest metro, using the optimal setting, try this version:

 

https://raw.githubusercontent.com/Co...test/AdKats.cs

 

I'm able to detect how many flags are capped now without error, and it will only trigger when all 3 are capped by one team.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

You had 6 players who were kicked in the last 10 minutes rejoin your server at the same time?

Well , idk man , but its spamming hard . Idk why its like that .

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Gettign this msg

[19:29:07 24] [AdKats] EXCEPTION: Line Unknown: [CommandParsingThreadLoop][Error occured in Command thread. Skipping current loop.]: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.AdKats.FinalizeRecord(AdKatsRecord record)

at PRoConEvents.AdKats.CompleteRecordInformation(AdKa tsRecord record, String message)

at PRoConEvents.AdKats.CommandParsingThreadLoop()

is something with DB?

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Also , can you tell me Tables in DB that needed to be transfer to keep :

..

Logged Players

Players stats

Roles

Users in Adkats list (roles)

..

 

reason , we moving DB to Ded server and for some reason we cant import successfully DB , tryed several times , but adkats and logger spitting errors (but connecting)

So we want connect to fresh DB and move needed Tables manually

thnx...

 

Another thing about Mute , it seas "they" see screenshot

 

28c2626b5e600177ab463c13d08f3f27.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Gettign this msg

 

 

is something with DB?

Enable plugin debugging on your layer and post the new exception.

[ImportBot]

Originally Posted by HARDCOREBF*:

 

Enable plugin debugging on your layer and post the new exception.

[22:45:51 20] InnerException: System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond xxx.154.44.91:3306

at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)

at MySql.Data.Common.StreamCreator.CreateSocketStream (IPAddress ip, Boolean unix)

at MySql.Data.Common.StreamCreator.GetStreamFromHost( String pipeName, String hostName, UInt32 timeout)

at MySql.Data.Common.StreamCreator.GetStream(UInt32 timeout)

at MySql.Data.MySqlClient.NativeDriver.Open()

i guess DB failing to respond for some reason. CHecked on Hosting backend , there is no outages .hhmmm

 

...

can you tell plz Tables in DB that needed to be transfer to keep :

..

Logged Players

Players stats

Roles

Users in Adkats list (roles)

 

we gonna try fresh Db on dedicated server and will transfer tables...

thnx

[Prophet731]

Originally Posted by Prophet731*:

 

i guess DB failing to respond for some reason. CHecked on Hosting backend , there is no outages .hhmmm

 

...

can you tell plz Tables in DB that needed to be transfer to keep :

..

Logged Players

Players stats

Roles

Users in Adkats list (roles)

 

we gonna try fresh Db on dedicated server and will transfer tables...

thnx

You would need to backup everything that begins with adkats? and tbl_. If you are using the BFAdminCP you will need to backup the bfadmincp? tables as well.

 

It could be also a firewall blocking the connection.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

This is great, i can detect with near perfect accuracy how many flags are currently captured by each team. In fact it's remarkably consistent between maps, the logic is the following, modified slightly from my previous post.

 

For conquest, tickets are reduced based on two factors, # of flags captured over the opposing team and kill/spawn pairs. For each kill/spawn matching pair the adjusted ticket count is refunded a ticket, so the adjusted ticket count is based completely on flags. Using this adjusted ticket value, the flag ticket loss rate is calculated.

 

For conquest in BF4, using default ticket rates, if you hold 1 more flag than the opposing team they lose 30-31 tickets per minute. Holding 2 flags more they lose 40-41 tickets per minute, 3 flags more they lose 50-51 tickets per minute, etc, etc...

 

In the latest patch you will be able to opt for using the new adjusted rates vs real rates for auto-surrender, and you will be able to see the adjusted rates in procon chat when displaying ticket rates using the setting in section A12.

[ImportBot]

Originally Posted by Jasonpb*:

 

I thought our users would like the auto surrender feature but apparently they don't, so I've reverted back to manual.... some people seem to enjoy the base rape, although I doubt many enjoy taking it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I thought our users would like the auto surrender feature but apparently they don't, so I've reverted back to manual.... some people seem to enjoy the base rape, although I doubt many enjoy taking it.

Of course people like dishing out the baserape, lol. At least if they have manual surrender that's alright.

 

Every server has a different crowd.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Version 5.2.2.5 (3-NOV-2014)

Changes

 

• Global and database timestamp mismatch allowed now. Internal calculations modified to account for any mismatch.
• SQL setup script modified to reset all AdKats tables to their default state. If the setup script is run on an existing install it will erase all non-default information.
• Auto-surrender optimal values for metro modified to use adjusted ticket rates.
• AdKats will not boot if required database tables are not under the InnoDB engine.
• AdKats will not boot if required definition files cannot be loaded. Backup fetch location added for non SSL compatible systems.
• Automatic reserved slot for user cache modified to be admin only. !reserved can be used to add users as reserved slot instead.

Enhancements

 

• Add adjusted ticket count and rates for conquest/chainlink/domination.
• Added auto-surrender option for optimal operation locker values.

Bugs Fixed

 

• AdKats SQL setup script contained an error that caused a foreign key exception during first setup.
• Settings for command 71, ping whitelist, were not visible in the command settings section.
• Reporting yourself from spectator increased reputation.
• Exception 1081 GetDisplayPluginVariables #563
• Setting sections B23 and B24 were both marked B23, and B25 marked as B24.

Upgrade SQL from 4.0.0.0 - Current

 

No manual upgrade SQL required.

 

If you are running 5.2.0.0+, your layer will automatically update and only require a reboot to run this version.

If not, update one layer, run it to complete startup, then repeat on your other layers.

 

https://sourceforge.net/projects/adk...atest/download

[ImportBot]

Originally Posted by TMiland*:

 

Huh?

[AdKats] ERROR: AdKats tables not present or valid in the database. For this release the adkats database setup script must be run manually. Run the script then restart AdKats.

[11:49:23 74] [AdKats] INFO: Shutting down AdKats.

Edit:

Reverted to 5.2.0.9

 

edit2:

Still the same error...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Huh?

 

Edit:

Reverted to 5.2.0.9

 

edit2:

Still the same error...

Your tables are not InnoDB?

[ImportBot]

Originally Posted by TMiland*:

 

Your tables are not InnoDB?

Yes they are... hmm

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yes they are... hmm

Code:

SELECT     `TABLE_NAME` AS `table_name` 
FROM 
    `INFORMATION_SCHEMA`.`TABLES` 
WHERE 
    `TABLE_NAME` LIKE 'adkats_%' 
AND 
    ENGINE <> 'InnoDB';

Is the query that changed.

 

If that returns rows, it wont allow AdKats to boot.

[ImportBot]

Originally Posted by TMiland*:

 

Code:

SELECT     `TABLE_NAME` AS `table_name` 
FROM 
    `INFORMATION_SCHEMA`.`TABLES` 
WHERE 
    `TABLE_NAME` LIKE 'adkats_%' 
AND 
    ENGINE <> 'InnoDB';

Is the query that changed.

 

If that returns rows, it wont allow AdKats to boot.

Well, would you look at that! Code:

ALTER TABLE `adkats_totalcmdissued` ENGINE = InnoDB;

Works now! Thanks!

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Well, would you look at that! Code:

ALTER TABLE `adkats_totalcmdissued` ENGINE = InnoDB;

Works now! Thanks!

What is the reason for that extra table? If it's useful I could incorporate it into the master release.

[ImportBot]

Originally Posted by TMiland*:

 

What is the reason for that extra table? If it's useful I could incorporate it into the master release.

I am not really sure i understand your question? Do you mean that adkats_totalcmdissued is an extra table?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I am not really sure i understand your question? Do you mean that adkats_totalcmdissued is an extra table?

Yeah, that table is not in the AdKats release, who made it?

[ImportBot]

Originally Posted by TMiland*:

 

Yeah, that table is not in the AdKats release, who made it?

You did!

[Prophet731]

Originally Posted by Prophet731*:

 

Yeah, that table is not in the AdKats release, who made it?

I think I remember seeing that table. It might have been in one of the earlier releases.

 

TMiland any chance you can show use the table schema of that?

[ImportBot]

Originally Posted by TMiland*:

 

I think I remember seeing that table. It might have been in one of the earlier releases.

 

TMiland any chance you can show use the table schema of that?

Here you go:

[Prophet731]

Originally Posted by Prophet731*:

 

Here you go:

Oh wait, I think I remember what this is. When you click browse what does it bring up?