Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by TMiland*:

 

Okay, you removed all records from the "adkats_records_main" table on the copy didn't you? If so, you need to delete the "adkats_records" table from that copy before he can boot AdKats.

No, i used the "Copy database to:" function in phpmyadmin with structure and data.

[ImportBot]

Originally Posted by stajs*:

 

Okay, you removed all records from the "adkats_records_main" table on the copy didn't you? If so, you need to delete the "adkats_records" table from that copy before he can boot AdKats.

I do have 2 records in "adkats_records_main" from within the last hour or so, which I don't know enough about AdKats to know how they got in there. So, perhaps he did remove them and I've managed to generate them since.

 

But I do have a whole bunch of "adkats_records" dating back some time and seem to have booted AdKats okay.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I do have 2 records in "adkats_records_main" from within the last hour or so, which I don't know enough about AdKats to know how they got in there. So, perhaps he did remove them and I've managed to generate them since.

 

But I do have a whole bunch of "adkats_records" dating back some time and seem to have booted AdKats okay.

You can completely delete the "adkats_records" table. That table is from a very old version of the plugin.

 

If that old table is detected, and there aren't any records in the adkats_records_main table, it will attempt to import/update all old records and users from the old tables to the new tables. That is why you were getting that error, it couldn't find the other tables from that old version, they were since deleted.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Giving you acces is not possible, since I dont have full acces on the Fragnet panel where I have those layers, and where I upload and edit files. Idk, would screenshots help you out ? Team Viewer or something. You are probably busy for this stuff , so yea idk.

Teamviewer would work. Can probably work on this tomorrow night. You have teamspeak?

[ImportBot]

Originally Posted by 2GooDforU-FNO*:

 

Teamviewer would work. Can probably work on this tomorrow night. You have teamspeak?

Yeah sure , If you want I can write our TS adress here or write you in PM.

Thanks in advance man , I really appriciate your help

[ImportBot]

Originally Posted by TMiland*:

 

You can completely delete the "adkats_records" table. That table is from a very old version of the plugin.

 

If that old table is detected, and there aren't any records in the adkats_records_main table, it will attempt to import/update all old records and users from the old tables to the new tables. That is why you were getting that error, it couldn't find the other tables from that old version, they were since deleted.

Any other tables needs to be deleted?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yeah sure , If you want I can write our TS adress here or write you in PM.

Thanks in advance man , I really appriciate your help

The ADK TS server is ts.adkgamers.com. I'll be online between 7-11PM CST tomorrow.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Any other tables needs to be deleted?

Valid AdKats tables are:

 

 

So you can delete:

 

adkats_banlist

adkats_globalPlayerPoints

adkats_serverPlayerPoints

[ImportBot]

Originally Posted by 2GooDforU-FNO*:

 

The ADK TS server is ts.adkgamers.com. I'll be online between 7-11PM CST tomorrow.

Okay. Thank you . I will try to join you at that time, since I am in different time zone.

[ImportBot]

Originally Posted by TMiland*:

 

Valid AdKats tables are:

 

 

So you can delete:

 

adkats_banlist

adkats_globalPlayerPoints

adkats_serverPlayerPoints

Nice Thanks! All cleaned up now.

[Prophet731]

Originally Posted by Prophet731*:

 

Colon, i'll have a few more SQL queries for you to add the update script to add indexes to certain tables. Again they are date columns and it provided a significant speed boost when searching by dates.

[ImportBot]

Originally Posted by SmackDown*:

 

I need some help and I'm not sure if this is the right forum location or not, so forgive me if I'm in the wrong place.

 

Due to hardware issues, my server provider had to move my server box. I now have a new server, but my problem is that I want to transfer the old servers database (players stats and rankings for that server) to the new server. The server provider was able to move my server so the it would stay in players favorites list so I want the same database for the new server.

 

Is this possible and if so, How do I do it.

 

Again if this post is inappropriate for this location, I apologize.

[ImportBot]

Originally Posted by iraqiboy90*:

 

None of the ones you pictured would cause a role to be admin.

Well, then why does the "Automatic MULTIbalancer whitelist for Admins" puts them on the whitelist, and when I disable it, it removes everyone?

and also, I have another role, that doesnt get added with this option.

that role has the following permissions:

Confirm, Cancel, Join Player, Report Player, Call admin on player, Voip, Request rules, Request online admins, assist loosing team, request server commands, find players, and request server reputation.

 

 

another issue:

When using !pinfo

the location info:

[15:23:32] AdKats > Say > iraqiboy90 > Location: Error fetching player location

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

issue with mysql......starting to lag after exact 24 hours...till nothing works

version 5.2.2.5

 

i checked the status and saw lots of waiting for table level lock which just wont finish

any ideas?

 

mysql.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Well, then why does the "Automatic MULTIbalancer whitelist for Admins" puts them on the whitelist, and when I disable it, it removes everyone?

and also, I have another role, that doesnt get added with this option.

that role has the following permissions:

Confirm, Cancel, Join Player, Report Player, Call admin on player, Voip, Request rules, Request online admins, assist loosing team, request server commands, find players, and request server reputation.

 

 

another issue:

When using !pinfo

the location info:

[15:23:32] AdKats > Say > iraqiboy90 > Location: Error fetching player location

You can see if a role is considered admin by looking at their entries in section 4. If the role is prefixed with [A], that role is considered admin, and the command that made it an admin role has [ADMIN] appended after it.

 

There is an error with parsing player locations currently, yes.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

issue with mysql......starting to lag after exact 24 hours...till nothing works

version 5.2.2.5

 

i checked the status and saw lots of waiting for table level lock which just wont finish

any ideas?

 

mysql.png

Hmm. What was changed when this started happening? There were no database interaction changes in 5.2.2.5.

[Prophet731]

Originally Posted by Prophet731*:

 

Hmm. What was changed when this started happening? There were no database interaction changes in 5.2.2.5.

I tried to fix his install, but was so messed up, my.cnf funky. So i'm helping him set up an actual linux server that will run correctly and wont screw up on him anymore. He just needs to stop randomly clicking links all the time.

 

Should be a fun day.

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

I tried to fix his install, but was so messed up, my.cnf funky.

Should be a fun day.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I tried to fix his install, but was so messed up, my.cnf funky. So i'm helping him set up an actual linux server that will run correctly and wont screw up on him anymore. He just needs to stop randomly clicking links all the time.

 

Should be a fun day.

Ok, glad to know it wasn't caused by AdKats.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

@dyn Had some spare time this afternoon.

 

Automatic tracking of server populators. After successful population, players are thanked in game, and given 10 reputation.

 

5.2.3.8+ | https://raw.githubusercontent.com/Co...test/AdKats.cs

 

Settings:

Section 1: Low Population Value

Section 1: High Population Value

 

Uptime command now shows percentages for low, medium, and high population.

 

Player name and population count for the past week:

Code:

SELECT     
    `target_name` AS `player`, 
    COUNT(`record_id`) AS `populations_pastweek` 
FROM 
    `adkats_records_main` 
WHERE 
    `command_type` = 88
AND 
    DATE_ADD(`record_time`, INTERVAL 7 DAY) > UTC_TIMESTAMP()
GROUP BY
    `target_id`
ORDER BY
    `populations_pastweek` DESC, `target_name` ASC;

[ImportBot]

Originally Posted by AgentHawk*:

 

issue with mysql......starting to lag after exact 24 hours...till nothing works

version 5.2.2.5

 

i checked the status and saw lots of waiting for table level lock which just wont finish

any ideas?

 

mysql.png

same issue... procon layer dosent work with ADKast on...if the plugin Off is everything fine.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

same issue... procon layer dosent work with ADKast on...if the plugin Off is everything fine.

You had the same problem with a linux server causing database issues?

[ImportBot]

Originally Posted by AgentHawk*:

 

its a procon layer from Branzone... and a sql linux server.

 

the error message says:

Not DB connection capable yet, complete SQL connection variables.

 

 

Its only on 1 Server (the first updated Server) all the others work. And Procon chat guid etc work also on the broken layer...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

its a procon layer from Branzone... and a sql linux server.

 

the error message says:

Not DB connection capable yet, complete SQL connection variables.

 

Its only on 1 Server (the first updated Server)

Then complete your connection variables?

 

[ImportBot]

Originally Posted by AgentHawk*:

 

Then complete your connection variables?

 

looooooooooooooooooooool

 

okay the problem was pretty funny. The plugin runs since month - and today was the SQL setup empty :/

 

My Procon host disable all plugins for me and after that was it possible to change the SQL setup. And it works now...rly strange bug

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

looooooooooooooooooooool

 

okay the problem was pretty funny. The plugin runs since month - and today was the SQL setup empty :/

 

My Procon host disable all plugins for me and after that was it possible to change the SQL setup. And it works now...rly strange bug

The error messages aren't lying to you about what is wrong

 

Glad it's working for you again.

[ImportBot]

Originally Posted by AgentHawk*:

 

The error messages aren't lying to you about what is wrong

 

Glad it's working for you again.

yea but I was not able to see the message. The whole Procon client crashed after 2 sec

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

yea but I was not able to see the message. The whole Procon client crashed after 2 sec

If you're using branzone you have access to plugin logs outside the procon instance on their control panel. If you still have those from when the error was happening, please send them to me privately. I want to know what was happening.

 

Also, you have access to live logs as the procon layer is starting up, so you can see exactly what is happening.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Query for 5.2.3.9+

 

Selects ADMIN and user soldiers who have populated servers in the past week.

 

Code:

SELECT 
    `target_name` AS `player`, 
    COUNT(`record_id`) AS `populations_pastweek` 
FROM 
    `adkats_records_main` 
WHERE 
    `command_type` = 88
AND 
    DATE_ADD(`record_time`, INTERVAL 7 DAY) > UTC_TIMESTAMP()
AND
    `target_id` IN (SELECT `player_id` FROM `adkats_usersoldiers`)
GROUP BY
    `target_id`
ORDER BY
    `populations_pastweek` DESC, `target_name` ASC;

[ImportBot]

Originally Posted by AgentHawk*:

 

okay..im not able to open the plugin error file. Its a little bit to big

 

all the other error logs are 600kb or something like this and the file from yesterday is 39.51 GB

(plugin.log)

 

I think the layer crashed yesterday through the plugin spam^^

 

Edit:

lol I had the issue on 2 days. The first was 43GB big and the second 39GB

 

 

I was able to visit the file (not complete) and look at this^^

 

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

[13:22:03] [AdKats] ERROR: Not DB connection capable yet, complete SQL connection variables.

 

All the time.