Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Obl1ter*:

 

You mean something like kill and kick?

Yeah, kill, kick, ban, etc

[ImportBot]

Originally Posted by Lucky567*:

 

With AdKats you have a really extensive plugin.

A function I miss though. Is it possible to functionally similar to the / lead command, a /private to lock a Squad.

There is indeed a command squad.private [TeamID] [squadID] [0 or 1]

 

The second thing I miss are the flags for the MULTIbalancer whitelist.

How do I use Whitelist option codes_*

 

mfg Lucky

[ImportBot]

Originally Posted by TheMrApostel*:

 

Yeah, kill, kick, ban, etc

i dont think theres a whitelist for that, yet.

You could lock a specific player from admin action using the !lock command.

 

[squadID] [0 or 1]

You could set this up with proconrulz using the exec command.

[ImportBot]

Originally Posted by naurel*:

 

Hi !

 

I'm using a framework for my website and in order to make it easyer I was trying to merge both database. So after the merge both database (basically I just merge the procon_database into my website database). I created a user and I granted him all permissions on : mydatabase.adkats_* && mydatabase.ses_1_tbl && mydatabase.tbl_*

(I didn't listed everything but I did it for all tables). When granted the user I specified the procon IP for the remote connection. Sadly I'm getting this error :

 

(nb : my user isn't root at all) why does it need my home IP ?

 

[19:30:13 45] [AdKats] EXCEPTION: Line Unknown-6001: [uploadInnerRecord][unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('root'@'myhomeip') does not exist

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.UploadInnerRecord(AdKatsRecord record)

[19:30:15 53] [AdKats] EXCEPTION: Line Unknown-6001: [uploadInnerRecord][unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: The user specified as a definer ('root'@'myhomeip') does not exist

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.UploadInnerRecord(AdKatsRecord record)

[19:30:16 34] [statslogger]Error: LogChat:

[19:30:16 34] Message: The user specified as a definer ('root'@'myhomeip') does not exist

[19:30:16 34] Native: -2147467259

[19:30:16 34] Source: MySql.Data

[19:30:16 35] 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.LogChat(String strSpeaker, String strMessage, String strType)

[19:30:16 35] [statslogger]Error: LogChat_2: System.NullReferenceException: Object reference not set to an instance of an object.

at PRoConEvents.CChatGUIDStatsLogger.DisplayMySqlErro rCollection(MySqlException myException)

at PRoConEvents.CChatGUIDStatsLogger.LogChat(String strSpeaker, String strMessage, String strType)

[ImportBot]

Originally Posted by CEBEP78*:

 

ColColonCleaner hello

I apologize for an anxiety, yet question. When does VOTEBAN, start that admin can not give to the ban player, priority of Votebana turns out higher what priority of admin?

 

I don't understand your question.

AdKats doesn't support the voteban function, yet.

I talked exactly about that in BF3, for me strange Voteban, stands and when he works (voting is started), using a command Adkats, it is impossible to give ban to that voting, of command AdKats goes a that man malfunction.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hi !

 

I'm using a framework for my website and in order to make it easyer I was trying to merge both database. So after the merge both database (basically I just merge the procon_database into my website database). I created a user and I granted him all permissions on : mydatabase.adkats_* && mydatabase.ses_1_tbl && mydatabase.tbl_*

(I didn't listed everything but I did it for all tables). When granted the user I specified the procon IP for the remote connection. Sadly I'm getting this error :

 

(nb : my user isn't root at all) why does it need my home IP ?

Your users were not carried over. The user who originally created the proceedure has been deleted. If you recreate that user, it should address your error.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

ColColonCleaner hello

I apologize for an anxiety, yet question. When does VOTEBAN, start that admin can not give to the ban player, priority of Votebana turns out higher what priority of admin?

 

 

 

I talked exactly about that in BF3, for me strange Voteban, stands and when he works (voting is started), using a command Adkats, it is impossible to give ban to that voting, of command AdKats goes a that man malfunction.

I'm sorry, I simply do not understand what you are asking. Votekick/Voteban is not and will not be a feature of AdKats.

[ImportBot]

Originally Posted by naurel*:

 

Problem solved thank you. I still don't understand why he neededs this user but it's fine now.

[ImportBot]

Originally Posted by toxicman2002*:

 

Hello,

 

since a lot of weeks i've a problem with my chat-loger. The chat will be logged with the ID, logDate, ServerID, logSunset, logSoldierName and logMessage. But the logPlayerID is always NULL. And thats a problem with the live-Chat in Adkats-Onlineadmintool. Livechat doesnt work with the onlinetool.

 

Strange: When i send a Message directly in the Admintool with my Account, my ID has been written correctly. When i write a Chatmessage ingame, the logPlayerID is again NULL.

 

Can someone help me? Adkats runs with the latest testversion on both layers, version 6.0 have the same Problem.

 

Thanks toxic

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello,

 

since a lot of weeks i've a problem with my chat-loger. The chat will be logged with the ID, logDate, ServerID, logSunset, logSoldierName and logMessage. But the logPlayerID is always NULL. And thats a problem with the live-Chat in Adkats-Onlineadmintool. Livechat doesnt work with the onlinetool.

 

Strange: When i send a Message directly in the Admintool with my Account, my ID has been written correctly. When i write a Chatmessage ingame, the logPlayerID is again NULL.

 

Can someone help me? Adkats runs with the latest testversion on both layers, version 6.0 have the same Problem.

 

Thanks toxic

What is your setting 'A16. Orchestration Settings | Post Stat Logger Chat Manually' set to?

[ImportBot]

Originally Posted by toxicman2002*:

 

Hello!

 

"Post Stat Logger Chat Manually" is set to "False".

"Feed Stat Logger Settings" is set to "True"

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Hello!

 

"Post Stat Logger Chat Manually" is set to "False".

"Feed Stat Logger Settings" is set to "True"

What happens if you enable the first one? Does it fix the issue?

[ImportBot]

Originally Posted by toxicman2002*:

 

You're great! Now, it works

 

Thanks for your help!

 

toxic

[ImportBot]

Originally Posted by 2GooDforU-FNO*:

 

Hey there.

I have 1 question.

Is it possible that bans that are being stored into MySQL Database are somehow showed on the website/forums ?

[ImportBot]

Originally Posted by TMiland*:

 

Hey there.

I have 1 question.

Is it possible that bans that are being stored into MySQL Database are somehow showed on the website/forums ?

You could try this: myrcon.net/.../latest-ban-and-report-rss-feed-v11

[Striker77733]

Originally Posted by Striker77733*:

 

is there a function to reset the Scoreleaderboard or do i have to clean the DB?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

is there a function to reset the Scoreleaderboard or do i have to clean the DB?

That would be a question for the stat logger thread. Not AdKats.

[ImportBot]

Originally Posted by MrLawbreaker*:

 

Any way to disable the messages in the procon chat window? Like when someone asks for rules and all rules will be shown in procon chat

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Any way to disable the messages in the procon chat window? Like when someone asks for rules and all rules will be shown in procon chat

Every message sent by AdKats to a player/server/team/etc is shown in the procon chat window. There is not currently a way to disable that.

[ImportBot]

Originally Posted by markrlomas*:

 

Using Test Branch 6.0.5.3 and under A19 (Server rule settings) The Yell Server Rules doesn't' seem to work when set to true, just displays in chat window only.

[ImportBot]

Originally Posted by wdfstryfe*:

 

Small request. When the teams are about to be nuked instead of displaying to admins only can it be set to display server wide?

[ImportBot]

Originally Posted by TheMrApostel*:

 

Using Test Branch 6.0.5.3 and under A19 (Server rule settings) The Yell Server Rules doesn't' seem to work when set to true, just displays in chat window only.

It's PlayerYell only.

[ImportBot]

Originally Posted by MRniceGuy*:

 

hey there

I have 2 servers

one of them have stats logger and adkats is installed

now i want to use stats logger and adkats on my second server

 

so i want to use same database for stats logger on my second server i will just merge second server i have no problem with that,

but the problem is i dont know about adkats and how is it going to be in one DB! is all the adkats settings gonna be the same on both servers if i use same database for second server adkats!...

 

what i'm asking is how to use one db for 2 servers installed stats logger and adkats

and i want settings for adkats to be different form second server. is it possible + how to do that please do i just need to set the same db info on second adkats plugin !

[ImportBot]

Originally Posted by markrlomas*:

 

Just updated to 6.0.6.6 test branch, did something break/change with the handling of external plugins, specifically Insane Limits?

 

Been previously Calling Adakts from Insane Limits to issue punish player without any problems, after updating to 6.0.6.6 the Limit triggers, but No punish takes place and the console throws up the following error:

 

Code:

[AdKats] EXCEPTION: Line Unknown-6066: [ParseExternalCommand][Unable to process external command.]: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.AdKats.ParseExternalCommand(Object commandParams)

Using the same hastable and call method that i've been using previously without issue:

 

Code:

Hashtable command = new Hashtable();
command.Add("caller_identity", "InsaneLimits");
command.Add("response_requested", false);
command.Add("command_type", "player_punish");
command.Add("source_name", "AutoAdmin");
command.Add("target_name", player.Name);
command.Add("target_guid", player.EAGuid);
command.Add("record_message", "Using Explosives (" + kill.Weapon + ")");
plugin.CallOtherPlugin("AdKats", "IssueCommand", command);

Only difference is our Clan Purchased the LRT plugin from you today which I have since installed, but even with LRT disabled I still get the error in the console. (I'm still using IL to call punishes for certain weapons such as M67 Frag as denying that weapon in loadout means players who don't have any other grenades unlocked are unable to spawn)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Using Test Branch 6.0.5.3 and under A19 (Server rule settings) The Yell Server Rules doesn't' seem to work when set to true, just displays in chat window only.

It uses yell, are you sure you don't have yells disabled on your game client?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Small request. When the teams are about to be nuked instead of displaying to admins only can it be set to display server wide?

That sounds like a good idea for nukes, not a good idea for surrender, so i'll make that change for nuke mode only.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

hey there

I have 2 servers

one of them have stats logger and adkats is installed

now i want to use stats logger and adkats on my second server

 

so i want to use same database for stats logger on my second server i will just merge second server i have no problem with that,

but the problem is i dont know about adkats and how is it going to be in one DB! is all the adkats settings gonna be the same on both servers if i use same database for second server adkats!...

 

what i'm asking is how to use one db for 2 servers installed stats logger and adkats

and i want settings for adkats to be different form second server. is it possible + how to do that please do i just need to set the same db info on second adkats plugin !

No, AdKats is designed to work on multiple servers using the same database. Set up stat logger and AdKats with the same connection settings for both servers. Settings are stored separately.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Just updated to 6.0.6.6 test branch, did something break/change with the handling of external plugins, specifically Insane Limits?

 

Been previously Calling Adakts from Insane Limits to issue punish player without any problems, after updating to 6.0.6.6 the Limit triggers, but No punish takes place and the console throws up the following error:

 

Code:

[AdKats] EXCEPTION: Line Unknown-6066: [ParseExternalCommand][Unable to process external command.]: System.NullReferenceException: Object reference not set to an instance of an object.
   at PRoConEvents.AdKats.ParseExternalCommand(Object commandParams)

Using the same hastable and call method that i've been using previously without issue:

 

Code:

Hashtable command = new Hashtable();
command.Add("caller_identity", "InsaneLimits");
command.Add("response_requested", false);
command.Add("command_type", "player_punish");
command.Add("source_name", "AutoAdmin");
command.Add("target_name", player.Name);
command.Add("target_guid", player.EAGuid);
command.Add("record_message", "Using Explosives (" + kill.Weapon + ")");
plugin.CallOtherPlugin("AdKats", "IssueCommand", command);

Only difference is our Clan Purchased the LRT plugin from you today which I have since installed, but even with LRT disabled I still get the error in the console. (I'm still using IL to call punishes for certain weapons such as M67 Frag as denying that weapon in loadout means players who don't have any other grenades unlocked are unable to spawn)

Try updating to version 6.0.6.7.

 

/pupdate then reboot your layer.

[ImportBot]

Originally Posted by 2GooDforU-FNO*:

 

You could try this: myrcon.net/.../latest-ban-and-report-rss-feed-v11

That is perfect for me thank you very much for this

[ImportBot]

Originally Posted by sitekeeper*:

 

Try to set AdKats to work over 2 servers it seemed to work for a while but now I am getting this in procon: I did addAdKatsLRT yesterday to one server. Any ideas?

 

[14:41:22 42] [AdKats] EXCEPTION: Line Unknown-6000: [uploadInnerRecord][unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`bfplayfo_procon`.`adkats_records_debug`, CONSTRAINT `adkats_records_debug_fk_server_id` FOREIGN KEY (`server_id`) REFERENCES `tbl_server` (`ServerID`) ON DELETE CASCADE ON UPDATE CASCADE)

at PRoConEvents.AdKats.SafeExecuteNonQuery(MySqlComma nd command)

at PRoConEvents.AdKats.UploadInnerRecord(AdKatsRecord record)

EDIT (I got this fix) EDIT

 

Thanks

Bob