Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by xloneshadowx*:

 

sounds great 7.5.17 seems to be working so far.. and yes i did check that it did not matter if it was using underslung rails or not it did not count

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

sounds great 7.5.17 seems to be working so far.. and yes i did check that it did not matter if it was using underslung rails or not it did not count

Hmm, alright, if I have extra time i'll look into that launcher issue.

[ImportBot]

Originally Posted by spatieman*:

 

question.

as a experiment i am revamping my proconrulz admin command script for our bf3 server

to do so i had to disable some admin commands for admins, like kill,ban and tban

 

now if i use !kill i get this > Your role Full Admin (Power Level 162) cannot use Kill Player.

not that i mind on the !killme i dont get it at all anymore

bcouse i already disabled !killme (what for some reason does not show up in the role seting either anymore)

entry RLE1 CDE17 it is

 

my question is, is there a way to surpress the messages at all ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

question.

as a experiment i am revamping my proconrulz admin command script for our bf3 server

to do so i had to disable some admin commands for admins, like kill,ban and tban

 

now if i use !kill i get this > Your role Full Admin (Power Level 162) cannot use Kill Player.

not that i mind on the !killme i dont get it at all anymore

bcouse i already disabled !killme (what for some reason does not show up in the role seting either anymore)

entry RLE1 CDE17 it is

 

my question is, is there a way to surpress the messages at all ?

In the command list you can straight up disable a command, or change the text needed to use it. Changing either should fix your issue.

[ImportBot]

Originally Posted by sixpax12*:

 

Is anyone else experiencing issues with AdKats restarting constantly ?

 

Restarts after this:

 

16:36:33 82] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[16:36:33 82] Message: 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 '( 10, 'fsu99phd','', 'EA_DF942E6C236F52065AE2502F0C0AE35A', '32992835a7d632abcb6' at line 1

[16:36:33 82] Native: -2147467259

[16:36:33 82] Source: MySql.Data

[16:36:33 82] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Is anyone else experiencing issues with AdKats restarting constantly ?

 

Restarts after this:

 

16:36:33 82] [statslogger]Error: Error in UpdateCurrentPlayerTable:

[16:36:33 82] Message: 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 '( 10, 'fsu99phd','', 'EA_DF942E6C236F52065AE2502F0C0AE35A', '32992835a7d632abcb6' at line 1

[16:36:33 82] Native: -2147467259

[16:36:33 82] Source: MySql.Data

[16:36:33 82] StackTrace: at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int3 2& affectedRow, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()

at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPla yerTable(List`1 lstPlayers)

Does the restart still happen if you disable the stat logger plugin temporarily?

[ImportBot]

Originally Posted by sixpax12*:

 

Yes. Restarts with TIMEOUT OR DEADLOCK warning ...

[ImportBot]

Originally Posted by sixpax12*:

 

also getting this ... not sure if helps just sharing.

 

 

[17:20:26 41] [AdKats] (SELECT

`record_id`,

`server_id`,

`command_type`,

`command_action`,

`command_numeric`,

`target_name`,

`target_id`,

`source_name`,

`source_id`,

`record_message`,

`record_time`

FROM

`adkats_records_main`

WHERE

`record_id` = `record_id`

AND

(

`command_type` = "9"

OR

`command_action` = "9"

)

AND

(

`target_id` = "4139"

 

)

AND

(

DATE_ADD(`record_time`, INTERVAL "1000" DAY) > UTC_TIMESTAMP()

)

ORDER BY

`record_id` DESC

LIMIT

"1")

ORDER BY `record_id` ASC

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yes. Restarts with TIMEOUT OR DEADLOCK warning ...

Try shutting down the stat logger plugin, then rebooting your procon layer. I have not seen an issue where AdKats crashes layers for a few years now, but i have seen a couple where stat logger can cause issues.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

also getting this ... not sure if helps just sharing.

 

 

[17:20:26 41] [AdKats] (SELECT

`record_id`,

`server_id`,

`command_type`,

`command_action`,

`command_numeric`,

`target_name`,

`target_id`,

`source_name`,

`source_id`,

`record_message`,

`record_time`

FROM

`adkats_records_main`

WHERE

`record_id` = `record_id`

AND

(

`command_type` = "9"

OR

`command_action` = "9"

)

AND

(

`target_id` = "4139"

 

)

AND

(

DATE_ADD(`record_time`, INTERVAL "1000" DAY) > UTC_TIMESTAMP()

)

ORDER BY

`record_id` DESC

LIMIT

"1")

ORDER BY `record_id` ASC

AdKats will retry selecting from the database if you hit a 'deadlock' issue.

 

It will print the failing query in the following cases:

Unable to connect to any of the specified MySQL hosts

Reading from the stream has failed.

Too many connections

Timeout expired

An existing connection was forcibly closed by the remote host

Unable to read data

Lock wait timeout exceeded

 

All of these are issues between the procon layer and the database or the database itself.

[ImportBot]

Originally Posted by sixpax12*:

 

OK will try that ... I sense I have messed something up in the database perhaps though not sure what that could be have not been in there for awhile.

[ImportBot]

Originally Posted by sixpax12*:

 

Is it required to leave the stats logger login enabled after initial database setup is complete ? Or should it typically be enabled all the time.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Is it required to leave the stats logger login enabled after initial database setup is complete ? Or should it typically be enabled all the time.

You only need to keep stat logger running if you (1) want players to use the !stats !rank etc commands in that plugin or (2) have some other system that uses the map/player stats from that plugin's tables. For AdKats to run it just needs the server entry in tbl_server, which only takes 1 round of stat logger to be added, and can be disabled after that.

[ImportBot]

Originally Posted by spatieman*:

 

In the command list you can straight up disable a command, or change the text needed to use it. Changing either should fix your issue.

thank u !!!

 

* Update *

My litle experiment did exactly what it needs to do

admins cant kill,kick,ban tban or rban fellow admins any more ^^

[ImportBot]

Originally Posted by sixpax12*:

 

I created a brand new test database, ... created a new virgin procon layer server and installed the two plugins via ftp ... connected stats logger, waited a round, ran the adkats setup script, connected adkats, ran the bfacp setup script, connected bfacp. all appears well for a few minutes then stats logger dies and adkats keep displaying various SELECT scripts ... at a loss on what is happening.

.

Disabled stats logger, restarted layer and adkats loads, then starts printing random SELECT ... read earlier the reasons for that but not sure how anything can be wrong with a small test database freshly corrected ... could be our provider needs to install the updated version of Procon you posted in another thread ?

 

Here is the statlogger error:

Code:

[09:16:15 77] [Statslogger]Error: Error in UpdateCurrentPlayerTable: 
[09:16:15 77] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[09:16:15 77] Native: -2147467259
[09:16:15 80] Source: MySql.Data
[09:16:15 80] StackTrace:    at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
   at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
   at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPlayerTable(List`1 lstPlayers)
[09:16:15 80] InnerException: System.TimeoutException: 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 ---> System.IO.IOException: Unable to read data from the transport connection: 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. ---> 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
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
[09:16:51 57] [Statslogger]Error: SQLQuery:
[09:16:51 57] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[09:16:51 57] Native: -2147467259
[09:16:51 59] Source: MySql.Data
[09:16:51 59] StackTrace:    at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
   at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
   at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[09:16:51 59] InnerException: System.TimeoutException: 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 ---> System.IO.IOException: Unable to read data from the transport connection: 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. ---> 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
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

thank u !!!

 

* Update *

My litle experiment did exactly what it needs to do

admins cant kill,kick,ban tban or rban fellow admins any more ^^

There was already a solution to this. Power level. Power level is calculated by the number of commands/admincommands you have access to. You can't kill/kick/ban/etc someone who has a higher power level than you.

 

Do you just want me to mod the script so you also can't act against someone with the SAME power level as you?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I created a brand new test database, ... created a new virgin procon layer server and installed the two plugins via ftp ... connected stats logger, waited a round, ran the adkats setup script, connected adkats, ran the bfacp setup script, connected bfacp. all appears well for a few minutes then stats logger dies and adkats keep displaying various SELECT scripts ... at a loss on what is happening.

.

Disabled stats logger, restarted layer and adkats loads, then starts printing random SELECT ... read earlier the reasons for that but not sure how anything can be wrong with a small test database freshly corrected ... could be our provider needs to install the updated version of Procon you posted in another thread ?

 

Here is the statlogger error:

Code:

[09:16:15 77] [Statslogger]Error: Error in UpdateCurrentPlayerTable: 
[09:16:15 77] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[09:16:15 77] Native: -2147467259
[09:16:15 80] Source: MySql.Data
[09:16:15 80] StackTrace:    at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
   at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
   at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at PRoConEvents.CChatGUIDStatsLogger.UpdateCurrentPlayerTable(List`1 lstPlayers)
[09:16:15 80] InnerException: System.TimeoutException: 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 ---> System.IO.IOException: Unable to read data from the transport connection: 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. ---> 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
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
[09:16:51 57] [Statslogger]Error: SQLQuery:
[09:16:51 57] Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[09:16:51 57] Native: -2147467259
[09:16:51 59] Source: MySql.Data
[09:16:51 59] StackTrace:    at MySql.Data.MySqlClient.ExceptionInterceptor.Throw(Exception exception)
   at MySql.Data.MySqlClient.MySqlConnection.Throw(Exception ex)
   at MySql.Data.MySqlClient.MySqlConnection.HandleTimeoutOrThreadAbort(Exception ex)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at PRoConEvents.CChatGUIDStatsLogger.SQLquery(MySqlCommand selectQuery)
[09:16:51 59] InnerException: System.TimeoutException: 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 ---> System.IO.IOException: Unable to read data from the transport connection: 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. ---> 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
   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   --- End of inner exception stack trace ---
   at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

Looks like something is screwy between your layer and your database, if you're able to run the setup script locally without problems. Try setting up a local instance of procon with the same plugins, connect it directly to the game server, and point it at the same database. If your local instance works on your normal computer, but not from the layer, you're closer to finding the problem.

[ImportBot]

Originally Posted by spatieman*:

 

There was already a solution to this. Power level. Power level is calculated by the number of commands/admincommands you have access to. You can't kill/kick/ban/etc someone who has a higher power level than you.

 

Do you just want me to mod the script so you also can't act against someone with the SAME power level as you?

nah, this is fine and perfect.

as sayd ,it was a experiment to see how far i could push adkats in combo with my lame proconrulz coding skills.

[ImportBot]

Originally Posted by sixpax12*:

 

Looks like something is screwy between your layer and your database, if you're able to run the setup script locally without problems. Try setting up a local instance of procon with the same plugins, connect it directly to the game server, and point it at the same database. If your local instance works on your normal computer, but not from the layer, you're closer to finding the problem.

this sounds above my skill level at the moment but will try ...

[ImportBot]

Originally Posted by sixpax12*:

 

Looks like something is screwy between your layer and your database, if you're able to run the setup script locally without problems. Try setting up a local instance of procon with the same plugins, connect it directly to the game server, and point it at the same database. If your local instance works on your normal computer, but not from the layer, you're closer to finding the problem.

setup local conx and have adkats and stats logger running and connected to the database for about 20 minutes ... no stats logger errors but still some occasional adkats messages printingsome SELECT queries to insert stuff ...

[ImportBot]

Originally Posted by HARAFAT69*:

 

hi, i try to add script but get thisq error

9 erreurs trouvées lors de l'analyse.

 

Caractère inattendu. (near "$" at position 41)

Caractère inattendu. (near "$" at position 43)

Une expression était attendue. (near "IN" at position 16)

Mot clé non reconnu. (near "IN" at position 16)

Mot clé non reconnu. (near "EXISTS" at position 19)

Jeton inattendu. (near "addLogPlayerID" at position 26)

Jeton inattendu. (near "$" at position 41)

Jeton inattendu. (near "$" at position 43)

Un nouvel énoncé a été trouvé, mais il n'y a aucun délimiteur entre celui-ci et le précédent. (near "CREATE" at position 46)

Requête SQL : Documentation

 

DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajouter la colonne logPlayerID en toute sécurité IF NOT EXISTS( ( SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND COLUMN_NAME = ' logPlayerID ' ET TABLE_NAME = ' tbl_chatlog ') ) ALORS ALTER TABLE ` tbl_chatlog ` ADD COLUMN ` logPlayerID ` INT(10) DEFAULT UNSIGNED NULL

 

MySQL a répondu : Documentation

 

#1064 - Erreur de syntaxe près de 'IN EXISTS addLogPlayerID $ $

CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajou' à la ligne 2

[ImportBot]

Originally Posted by xloneshadowx*:

 

Translation:

9 errors found during the analysis.

 

Unexpected character (near "$" at position 41)

Unexpected character (near "$" at position 43)

An expression was expected. (near "IN" at position 16)

Unrecognized keyword. (near "IN" at position 16)

Unrecognized keyword. (near "EXISTS" at position 19)

Unexpected token (near "addLogPlayerID" at position 26)

Unexpected token (near "$" at position 41)

Unexpected token (near "$" at position 43)

A new statement has been found, but there is no delimiter between it and the previous one. (near "CREATE" at position 46)

SQL query: Documentation

 

DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID () BEGIN - Add column logPlayerID safely IF NOT EXISTS ((SELECT * FROM info_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) DEFAULT UNSIGNED NULL

 

MySQL replied: Documentation

 

# 1064 - Syntax error near 'IN EXISTS addLogPlayerID $ $

CREATE PROCEDURE addLogPlayerID () START - Add 'to line 2

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hi, i try to add script but get thisq error

9 erreurs trouvées lors de l'analyse.

 

Caractère inattendu. (near "$" at position 41)

Caractère inattendu. (near "$" at position 43)

Une expression était attendue. (near "IN" at position 16)

Mot clé non reconnu. (near "IN" at position 16)

Mot clé non reconnu. (near "EXISTS" at position 19)

Jeton inattendu. (near "addLogPlayerID" at position 26)

Jeton inattendu. (near "$" at position 41)

Jeton inattendu. (near "$" at position 43)

Un nouvel énoncé a été trouvé, mais il n'y a aucun délimiteur entre celui-ci et le précédent. (near "CREATE" at position 46)

Requête SQL : Documentation

 

DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajouter la colonne logPlayerID en toute sécurité IF NOT EXISTS( ( SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND COLUMN_NAME = ' logPlayerID ' ET TABLE_NAME = ' tbl_chatlog ') ) ALORS ALTER TABLE ` tbl_chatlog ` ADD COLUMN ` logPlayerID ` INT(10) DEFAULT UNSIGNED NULL

 

MySQL a répondu : Documentation

 

#1064 - Erreur de syntaxe près de 'IN EXISTS addLogPlayerID $ $

CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajou' à la ligne 2

"IN EXISTS" is incorrect syntax. Something translated this code into an invalid state. Please run the script exactly as-is without any changes.

[ImportBot]

Originally Posted by HARAFAT69*:

 

thanks, i didn't see chrome traduct pages and code in this case so it's fixed

[ImportBot]

Originally Posted by sixpax12*:

 

what can cause tbl_extendedroundstats to be empty ? have adkats feeding the statlogger and table was created but nothing is ever written to it.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

what can cause tbl_extendedroundstats to be empty ? have adkats feeding the statlogger and table was created but nothing is ever written to it.

extended round stats is actually an AdKats table. AdKats creates it and fills it. It was probably dumb to create it with the stat logger prefix tbl though.

 

There were some issues with roundID not being incremented so that could be the reason. You'll know you have the issue if the 'Server Round (Display)' setting in the server setting section always shows 1. That issue was patched so update to the latest test version and wait for a few rounds.

[ImportBot]

Originally Posted by sixpax12*:

 

extended round stats is actually an AdKats table. AdKats creates it and fills it. It was probably dumb to create it with the stat logger prefix tbl though.

 

There were some issues with roundID not being incremented so that could be the reason. You'll know you have the issue if the 'Server Round (Display)' setting in the server setting section always shows 1. That issue was patched so update to the latest test version and wait for a few rounds.

thank you colcolon have updated all servers so will wait for some rounds to complete ... i noticed the server round setting was set to zero instead of 1 after layer reboot ...

 

Edit: The table is populating with data across all servers !

[ImportBot]

Originally Posted by sixpax12*:

 

i have searched for this query and have not been able to locate it anywhere.

 

'Post Map Benefit/Detriment Statistics' - Whether to post statistics on which maps are most beneficial/detrimental to the population of the server. Queries to extract meaning from this information can be acquired in the main AdKats forum thread.

[ImportBot]

Originally Posted by sixpax12*:

 

i have searched for this query and have not been able to locate it anywhere.

 

'Post Map Benefit/Detriment Statistics' - Whether to post statistics on which maps are most beneficial/detrimental to the population of the server. Queries to extract meaning from this information can be acquired in the main AdKats forum thread.

checking in on where I can find said query from above.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

i have searched for this query and have not been able to locate it anywhere.

 

'Post Map Benefit/Detriment Statistics' - Whether to post statistics on which maps are most beneficial/detrimental to the population of the server. Queries to extract meaning from this information can be acquired in the main AdKats forum thread.

myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry39160

 

Code:

SELECT 
    `InnerResults`.*,
    ROUND((`map_benefit` - `map_detriment`)/`map_rounds`, 2) AS `map_benefit_numeric`
FROM
(
SELECT
    `server_id` AS `server`,
    `tbl_server`.`ServerName` AS `server_name`,
    `target_name` AS `map_code`,
    (
        SELECT 
            count(`stat_id`)
        FROM 
            `adkats_statistics`
        WHERE
            `server_id` = `server`
        AND
            `target_name` = `map_code`
        AND
            `stat_type` = 'map_benefit'
    ) AS `map_rounds`,
    (
        SELECT 
            SUM(`stat_value`)
        FROM 
            `adkats_statistics`
        WHERE
            `server_id` = `server`
        AND
            `target_name` = `map_code`
        AND
            `stat_type` = 'map_benefit'
    ) AS `map_benefit`,
    (
        SELECT 
            SUM(`stat_value`)
        FROM 
            `adkats_statistics`
        WHERE
            `server_id` = `server`
        AND
            `target_name` = `map_code`
        AND
            `stat_type` = 'map_detriment'
    ) AS `map_detriment`
FROM
    `adkats_statistics`
INNER JOIN
    `tbl_server`
ON
    `server_id` = `tbl_server`.`ServerID`
WHERE
    `stat_type` = 'map_benefit'
    OR
    `stat_type` = 'map_detriment'
GROUP BY
    `server_id`, `target_name`
) AS `InnerResults`
ORDER BY
    `InnerResults`.`server` ASC, `map_benefit_numeric` DESC;

Another query: myrcon.net/...advanced-in-game-admin-and-ban-enforcer-adkats#entry39176

 

Looks like i never actually added that section to the manual with these queries.