Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

Code:

[01:09:25 69] [AdKats] EXCEPTION-6900-RunAction-ActionHandling61: [Command Previous Temp Ban not found in runAction. Record ID 473628]
[01:09:38 83] [AdKats] EXCEPTION-6900-RunAction-ActionHandling61: [Command Previous Temp Ban not found in runAction. Record ID 473628]
[01:09:51 31] [AdKats] EXCEPTION-6900-RunAction-ActionHandling61: [Command Previous Temp Ban not found in runAction. Record ID 473628]

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@hodor you still haven't updated to the latest version.

 

Sent from my SM-G920P using Tapatalk

[ImportBot]

Originally Posted by Hodor*:

 

update adkats_bans

set ban_status = 'Disabled'

where latest_record_id in

(select latest_record_id

from adkats_records_main

where adkats_records_main.record_message not like '%Hack%' and

adkats_records_main.record_message not like '%Cheat%' and

adkats_records_main.record_message not like '%WH%' and

adkats_records_main.record_message not like '%AIM%' and

adkats_records_main.record_message not like '%Aimbot%' and

adkats_records_main.record_message not like '%Walling%' and

adkats_records_main.record_message not like '%ESP%' and

adkats_records_main.record_message not like '%Linked%')

This code Disabled all my bans, thanks good that i made backup

 

@hodor you still haven't updated to the latest version.

But I read that many people had some problems with the new version of AdKats. I do not want to install the update yet.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

This code Disabled all my bans, thanks good that i made backup

 

 

But I read that many people had some problems with the new version of AdKats. I do not want to install the update yet.

It's good to keep backups. That query i posted was completely untested.

 

As for issues, they exist everywhere, in your version, the latest one, and every version before that. It's a choice on your part either to wait and stick with the issues you're seeing now or upgrade, get a bunch of new features, and help with that development.

 

EDIT: Right now there is a stability issue on the latest version. Some people are fine with it, others are having issues needing to reboot procon. That's my current priority. It appears to be a thread locking issue, but i'm not sure at this point.

[ImportBot]

Originally Posted by Hodor*:

 

It's good to keep backups. That query i posted was completely untested.

 

As for issues, they exist everywhere, in your version, the latest one, and every version before that. It's a choice on your part either to wait and stick with the issues you're seeing now or upgrade, get a bunch of new features, and help with that development.

 

EDIT: Right now there is a stability issue on the latest version. Some people are fine with it, others are having issues needing to reboot procon. That's my current priority. It appears to be a thread locking issue, but i'm not sure at this point.

Okay, i will look at newest version of adkats tomorrow

[ImportBot]

Originally Posted by )RAG()N*:

 

What do you mean the text is missing or 'pick the line'?

 

 

 

 

Also, run this on your database, what gets returned?

select * from adkats_commands where command_id in (65, 99)

[ImportBot]

Originally Posted by )RAG()N*:

 

My account is one of the ones affected, we have 3 players in the house on the same IP.

 

I just had a look at my account in users and I have another players name in "Soldiers" (the one is within the household)

So I just tried to add my Soldiers name to my account and it just put the same account in again

 

[ImportBot]

Originally Posted by spatieman*:

 

Strange, i didn't know it was able to do that either, and i built the plugin. How are you doing this? Do you have a script that imports them to the database?

didnt do anything.

it does import the bans, on the condition it was set manualy ,in this case with my in game name.

but.....

it look like this : http://bfadmincp.xs4non.nl:85/players/3972 ,it imports, yes, but not with the name.

still funny, so i posted it, could be a thing from rconnet that it pushes ban to serverban list, and procon did the import.

i also notice, and that is a interesting thing, that some bans set by hand (on name), dont apair in the ban list in a few seconds.

but that adkatz does a checkup for the EA/PB guid !, imho a usefull options.

 

as sayd,we use rconnet only for Rban, i am a procon addict my self.

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

Can AdKats cause this behavior on the server? What does it even look like, is there a consideration?

 

 

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@ColColonCleaner

Can AdKats cause this behavior on the server? What does it even look like, is there a consideration?

No, that's not possible, especially so at low population. The only thing that can affect performance of the game server is excessive calls to the server/player lists. Procon by default does this every 30 seconds, AdKats does this every 5 seconds, and even on full 64 man servers that's still not enough to cause any lag issues. Other than that there is nothing that a procon plugin or procon itself can do to cause server lag.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

My account is one of the ones affected, we have 3 players in the house on the same IP.

 

I just had a look at my account in users and I have another players name in "Soldiers" (the one is within the household)

So I just tried to add my Soldiers name to my account and it just put the same account in again

 

That's very odd...everything is connected by ID at that point, not by name or IP. I'll look into it. You're not just using the -4K- part right? You're using the full name?

[ImportBot]

Originally Posted by )RAG()N*:

 

That's very odd...everything is connected by ID at that point, not by name or IP. I'll look into it. You're not just using the -4K- part right? You're using the full name?

Yeah using the full name.

I have not had any problem with it for a long time its probably been running on our server for a year or more without any problems until now.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yeah using the full name.

I have not had any problem with it for a long time its probably been running on our server for a year or more without any problems until now.

This is very strange. Please PM me credentials to your layer so I can take a look at this in real time. Thank you.

[ImportBot]

Originally Posted by Hodor*:

 

@ColColonCleaner

After disabled bans and cleared adkats_infractions_global and adkats_infractions_server my punishment system stopped working..

All the time i see 0pts 0pts 0pts: You KILLED BlahBlah for blahblah [0pts]

 

Is that fixable?

[Prophet731]

Originally Posted by Prophet731*:

 

@ColColonCleaner

After disabled bans and cleared adkats_infractions_global and adkats_infractions_server my punishment system stopped working..

All the time i see 0pts 0pts 0pts: You KILLED BlahBlah for blahblah [0pts]

 

Is that fixable?

Sounds right to me, the person doesn't have any points set when you killed him. The triggers for the infraction points do exist still right? If those are missing then that would explain why no infraction point was made.

 

Sent from my ONEPLUS A3000 using Tapatalk

[ImportBot]

Originally Posted by )RAG()N*:

 

@ColColonCleaner

 

pm'ed

[ImportBot]

Originally Posted by Hodor*:

 

Sounds right to me, the person doesn't have any points set when you killed him. The triggers for the infraction points do exist still right? If those are missing then that would explain why no infraction point was made.

 

Sent from my ONEPLUS A3000 using Tapatalk

/punish [nick] [reason]

Player will get 0pts all the time... So infraction point stopped working.

Code:

kill
kick
tban60
tban120
tbanday
tban2days
tbanweek
tban2weeks
tbanmonth
ban

When you release new version of BFAdminCP?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

/punish [nick] [reason]

Player will get 0pts all the time... So infraction point stopped working.

Code:

kill
kick
tban60
tban120
tbanday
tban2days
tbanweek
tban2weeks
tbanmonth
ban

When you release new version of BFAdminCP?

Prophet is not releasing a new version of the BFAdminCP.

 

What did you change before that happened?

[ImportBot]

Originally Posted by Hodor*:

 

Prophet is not releasing a new version of the BFAdminCP.

 

What did you change before that happened?

Not much.

Just disabled some bans:

Code:

update adkats_bans set ban_status = 'Disabled' where latest_record_id in (select record_id from adkats_records_main where record_message not like '%Hack%' and
record_message not like '%Cheat%' and
record_message not like '%HSK%' and
record_message not like '%DPS%' and
record_message not like '%KPM%' and
record_message not like '%Lang%' and
record_message not like '%Insult%' and
record_message not like '%Racism%' and
record_message not like '%Nazi%' and
record_message not like '%Suspect%' and
record_message not like '%WH%' and
record_message not like '%AIM%' and
record_message not like '%ESP%' and
record_message not like '%Aimbot%' and
record_message not like '%Walling%' and
record_message not like '%pbbans%' and
record_message not like '%ggc%' and
record_message not like '%aci%' and
record_message not like '%impossible%' and
record_message not like '%Glitch%' and
record_message not like '%Linked%');

And cleared two infraction tables:

64fa3b8119.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Not much.

Just disabled some bans:

Code:

update adkats_bans set ban_status = 'Disabled' where latest_record_id in (select record_id from adkats_records_main where record_message not like '%Hack%' and
record_message not like '%Cheat%' and
record_message not like '%HSK%' and
record_message not like '%DPS%' and
record_message not like '%KPM%' and
record_message not like '%Lang%' and
record_message not like '%Insult%' and
record_message not like '%Racism%' and
record_message not like '%Nazi%' and
record_message not like '%Suspect%' and
record_message not like '%WH%' and
record_message not like '%AIM%' and
record_message not like '%ESP%' and
record_message not like '%Aimbot%' and
record_message not like '%Walling%' and
record_message not like '%pbbans%' and
record_message not like '%ggc%' and
record_message not like '%aci%' and
record_message not like '%impossible%' and
record_message not like '%Glitch%' and
record_message not like '%Linked%');

And cleared two infraction tables:

64fa3b8119.png

Oh dear....why.

 

delete from adkats_records_main where command_type in (9, 10) or command_action in (9, 10);

 

THEN, you can clear those tables.

 

EDIT: Also make sure you did what prophet said and make sure you didn't also delete the infraction triggers on the adkats_records_main table.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@ColColonCleaner

 

pm'ed

Something was screwed up with those users, i'm not sure what it was. I've deleted them and added them back and everything seems to be working normally now.

 

Also, you have people kill trading in your server at the moment.

[ImportBot]

Originally Posted by )RAG()N*:

 

Something was screwed up with those users, i'm not sure what it was. I've deleted them and added them back and everything seems to be working normally now.

I just loaded in to the server and My soldier name has changed again and its the same with the other players also

 

 

 

Also, you have people kill trading in your server at the moment.

if you remember who they are pm me there name?

[ImportBot]

Originally Posted by )RAG()N*:

 

 

I also noticed that the player names that are affected have all the user number as in the pic.

1 should be me and 2 should be Gstring

 

and down the list there is other users affected and there user numbers and the same also.

 

Do you think this could be a database problem ?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

 

I also noticed that the player names that are affected have all the user number as in the pic.

1 should be me and 2 should be Gstring

 

and down the list there is other users affected and there user numbers and the same also.

 

Do you think this could be a database problem ?

Those were referencing the proper players until you logged into the server. I'm not sure why it's modifying the user list because you joined the server.

 

I don't see any other users that are having this issue. which one did you see?

[ImportBot]

Originally Posted by )RAG()N*:

 

Those were referencing the proper players until you logged into the server. I'm not sure why it's modifying the user list because you joined the server.

 

I don't see any other users that are having this issue. which one did you see?

spewdog and spewpup

battleundies and yeager

 

there the only other users that have there kids playing on the same IP address

[ImportBot]

Originally Posted by Hodor*:

 

Oh dear....why.

 

delete from adkats_records_main where command_type in (9, 10) or command_action in (9, 10);

 

THEN, you can clear those tables.

 

EDIT: Also make sure you did what prophet said and make sure you didn't also delete the infraction triggers on the adkats_records_main table.

"Also make sure you did what prophet said and make sure you didn't also delete the infraction triggers on the adkats_records_main table" how?

Still 0pts

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

"Also make sure you did what prophet said and make sure you didn't also delete the infraction triggers on the adkats_records_main table" how?

Still 0pts

Look at the triggers on the adkats_records_main table. Are there still two triggers on that table?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

spewdog and spewpup

battleundies and yeager

 

there the only other users that have there kids playing on the same IP address

I believe i've found the offending code and patched it. I already uploaded the changes to your layer and rebooted it. Let me know if all is good now.

[ImportBot]

Originally Posted by Hodor*:

 

Look at the triggers on the adkats_records_main table. Are there still two triggers on that table?

bd55f9c1df.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

bd55f9c1df.png

I don't know what that program is. Please google how to look at triggers on that table or ask your host about it.