Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Tangox*:

 

How can i enable email and check reports!_!

 

If i try to activate emails it will not set to "True"

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

How can i enable email and check reports!_!

 

If i try to activate emails it will not set to "True"

Email support is being added in version 4.0 for reports, please wait.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Logic change that you guys should know about. I am refactoring how the ban/kick reason is displayed on battelog to reflect some changes they made.

 

Currently reasons show up like this:

 

Due to the wrapping they have, it looks like the admin name is actually the reason. Some people were coming to us confused, "why was I banned for ? what is that_".

 

Old:

ColColonCleaner [8m38s] Self-Inflicted - Appeal at TESTING

New:

Self-Inflicted [8m38s][ColColonCleaner][Appeal at TESTING]

 

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

This is the beta release for AdKats 4.0.0.0 (3.9.9.0), and is intended for testing purposes only. The 4.0 release needs to be clean, so this release is dedicated to finding any errors that currently exist in it. Over 8000 lines have been changed since the previous release, so there are obviously things i've overlooked at some point.

 

For now, only test this if you can create a new database/schema to run this on. It is UNTESTED, and it would not be pretty if something happened to your existing instances.

 

The changes are as follows:

• The database structure has been completely changed, the definition is now using 11 tables (soon to be 12). I will be adding an import script for your old records to the new version soon. Once officially released you will be able to install this over your old instance and it will import/update your old records.
• New user system has been added with editable roles and commands.
  • On first enable you will need to add a user, you can have as many users as you want.
  • Note: Anywhere a setting says "delete_" to perform the delete you need to type the word delete in the box and hit enter, i did this so there are no accidental deletions of users/roles/etc.
  • When a user is added you need to assign them a role.
    • The default role is "Default Guest" and the allowed commands for that role are shown to you in the role section. The default guest role cannot be deleted, but can be edited to your heart's content.
    • You can add more roles by typing a new role name in the "add role" field. All roles that are added default to allow all commands, so you will need to edit the allowed commands for new roles.
    • When you change a user's role and they are currently in-game they will be told that their role has changed, and what it was changed to.
  • When a user is added you need to assign them soldiers.
    • Users can have multiple soldiers, so if your admins have multiple accounts you can assign all of those soldiers under their user.
    • All soldiers added need to be in your database before they can be added to a user. This system tracks user's soldiers, so if they change their soldier names they will still have powers without needing to contact admins about the change.
    • Type their soldier's name in the "new soldier" field to add them. It will error out if it cannot find the soldier in the database.
      • To add soldiers to the database quickly, have them join any server you are running this version of AdKats on and their information will be immediately added.
  • Commands now have logging options, enable options, and editable command text. These can be edited in the command list section
• AdKats can now send emails for player reports and admin calls, enable the email system and email fields will appear next to each user.
  • I've included credentials to send through the adkatsbattlefield gmail account, so you can leave that default if you want, no need for your own SMTP server.
• The internal hacker checker has been updated to work with BF3Stats and BF4Stats.
  • It is currently in debug mode for this beta release so you will be console spammed with some statistics if you enable it. Also not all weapon damages are included yet, so some weapons wont be found.
• AdKats now accepts commands sent via procon's chat tab.
  • You must prefix the command with a / for it to work through that method. The admin name for those commands is "ProconAdmin" since the real admin name is undetectable.
• Auto-Enable/KeepAlive added.
  • If you ever have issues where your layer/instance is leaving AdKats disabled on restart, enable this. To disable AdKats after this is turned on you must change the setting to false.
• All AdKats functions now run in UTC time.
• IRO punish can now be disabled/edited.
• You can now give units to temp ban times, such as @tban 10h player reason for a 10 hour ban.
  • Valid suffixes are m, h, d, w, y, for minutes, hours, days, weeks, and years respectively.
• the @tell and @ptell commands have been added.
  • These commands will perform a say and yell at the same time.
• Admin name can now be shown in global kick/ban messages per the available option.
• AdKats now implements @rules/!rules and logs when players request rules.
• Ban reasons have been updated per the previous post.
• Callable methods have been added so other plugins can call AdKats commands like punish and mute, and keep all the logging options. All commands are accessible, i'm just waiting on a plugin capable of sending AdKats the commands.
• Small bugs fixed from previous versions.

The new AdKats.cs file is here:

https://raw.github.com/ColColonClean...test/AdKats.cs

The new adkats.sql file is here:

https://raw.github.com/ColColonClean...est/adkats.sql

 

Good luck boys, let me know when you find issues.

[ImportBot]

Originally Posted by jking54*:

 

Created new database, enabled it then disabled it then got this error when I ran the new script:

 

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

 

ERROR: Unknown Punctuation String @ 13

STR: //

SQL:

 

DELIMITER //

 

DROP PROCEDURE IF EXISTS addLogPlayerID //

 

 

SQL query:

 

DELIMITER // DROP PROCEDURE IF EXISTS addLogPlayerID //

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

I get this error every single time I run that script, are you sure it's correct? I think there is an issue with it now as I created a whole new schema and database on a separate server which doesn't fill very often so I guinea pigged it, same error so gotta be something on that end (script etc.)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Created new database, enabled it then disabled it then got this error when I ran the new script:

 

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

 

ERROR: Unknown Punctuation String @ 13

STR: //

SQL:

 

DELIMITER //

 

DROP PROCEDURE IF EXISTS addLogPlayerID //

 

 

SQL query:

 

DELIMITER // DROP PROCEDURE IF EXISTS addLogPlayerID //

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

I get this error every single time I run that script, are you sure that script is correct?

Your client doesnt know what // means, it's just a delimiter, i'll update it to $$ and you should be fine.

 

EDIT: Updated

[ImportBot]

Originally Posted by jking54*:

 

Your client doesnt know what // means, it's just a delimiter, i'll update it to $$ and you should be fine.

 

EDIT: Updated

Ok thanks C3, will give it another go...

[ImportBot]

Originally Posted by jking54*:

 

Now I get this:

 

Error

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

I am with NFO and they currently use phpMyAdmin 4.0.7 if that matters.

[ImportBot]

Originally Posted by Jasonpb*:

 

I'll run it later on, new user (admin) management system sounds good.

[ImportBot]

Originally Posted by jking54*:

 

Oh well guess I'll just wait for release, no worky work on this end.

[Prophet731]

Originally Posted by Prophet731*:

 

Oh well guess I'll just wait for release, no worky work on this end.

I ran the SQL just fine. Re-create the new database, maybe it got corrupted somehow.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

TESTERS ONLY

 

Updated. 3.9.9.1

 

https://raw.github.com/ColColonClean...test/AdKats.cs

[ImportBot]

Originally Posted by lordicon*:

 

Did anyone make a web based Admin panel yet for this? Just wondering I could use one

[ImportBot]

Originally Posted by Berndel*:

 

yes have an look here for us it works fine with BF4 http://www.adkgamers.com/forum/265-adk-web-dev-support/

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

Hi

 

i get this error:

 

lowstack.png

 

I try to increase the stack but

 

mysqld -O thread_stack=256000

 

das not work.

 

#1064.png

 

still working on that

----------------------------------

 

Update:

Could fix that by increasing the my.ini file to 256k

 

Its running now....waiting if errors occurs

 

BTW....looks massive :-)

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

ok tables were created

 

datas are written into DB....hell ya...you heared correct....problem of me is solved i guess...you rock like hell mannnn

 

working.png

 

punish works correct

 

user are written into tables

 

just look at the pic it tells nearly everythink!!!

 

GREAT JOB SO FAR CLEANER

 

Attached Files:

• tables.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

ok tables were created

 

datas are written into DB....hell ya...you heared correct....problem of me is solved i guess...you rock like hell mannnn

 

working.png

 

punish works correct

 

user are written into tables

 

just look at the pic it tells nearly everythink!!!

 

GREAT JOB SO FAR CLEANER

Glad to see this fixed your issue. If you could test the other functions/commands changed as well that would be great, i want to make sure there are no bugs for the 4.0 release.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

yes have an look here for us it works fine with BF4 http://www.adkgamers.com/forum/265-adk-web-dev-support/

The current version there will only work with AdKats 3.7 stable release. The version functional with 4.0 will be released once testing is complete.

[ImportBot]

Originally Posted by jking54*:

 

I ran the SQL just fine. Re-create the new database, maybe it got corrupted somehow.

lol I've recreated it about a half dozen times, not working. Goes like clockwork with the release scripts, same error guys. As expected, I get the normal 15 tables form GUID Stats logger upon startup of that. Guess I'll pass for now until you get it straightened out...

 

Error

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

[ImportBot]

Originally Posted by www-battleplay4u-com*:

 

run that sql

 

mysql_upgrade

 

or

 

mysql_upgrade.exe -uroot -p --force

 

tell me if it helped you

 

DONT FORGET: GOOGLE IS YOUR FRIEND

[ImportBot]

Originally Posted by jking54*:

 

run that sql

 

mysql_upgrade

 

or

 

mysql_upgrade.exe -uroot -p --force

 

tell me if it helped you

 

DONT FORGET: GOOGLE IS YOUR FRIEND

Run this where, on the database? BTW FYI, I'm with NFO, the MySQL stuff is on them, all the release AdKats stuff has worked without issue up until this point so with respect please no Google is your friend stuff....

 

#1064 - 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 'mysql_upgrade.exe -uroot -p --force' at line 1

 

FYI, NFO is running the most current MySQL...

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

lol I've recreated it about a half dozen times, not working. Goes like clockwork with the release scripts, same error guys. As expected, I get the normal 15 tables form GUID Stats logger upon startup of that. Guess I'll pass for now until you get it straightened out...

 

Error

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

King, did you try running the previous script i posted? The one that checked if people could create procedures? The error is not with the current SQL script posted, all of the syntax is correct. Your SQL server seems to have an issue creating procedures. I'll look into it further later.

 

https://raw.github.com/ColColonClean...siontester.sql

[ImportBot]

Originally Posted by jking54*:

 

King, did you try running the previous script i posted? The one that checked if people could create procedures? The error is not with the current SQL script posted, all of the syntax is correct. Your SQL server seems to have an issue creating procedures. I'll look into it further later.

 

https://raw.github.com/ColColonClean...siontester.sql

Error

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

I'm working with NFO also on this

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Error

SQL query:

 

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

 

MySQL said: Documentation

 

#1548 - Cannot load from mysql.proc. The table is probably corrupted

 

I'm working with NFO also on this

Yeah it appears to be a problem with NFO and procedures, all of the syntax is correct. Let me know what happens.

[ImportBot]

Originally Posted by jking54*:

 

Yeah it appears to be a problem with NFO and procedures, all of the syntax is correct. Let me know what happens.

Ok, I just didn't foresee this as a problem, having to have an updated MySQL when all the other scripts work fine, was this planned or due your revamping everything?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Ok, I just didn't foresee this as a problem, having to have an updated MySQL when all the other scripts work fine, was this planned or due your revamping everything?

I have never had a procedure in the sql scripts before, that is what is causing the issue for you specifically, some part of your mysql config is not allowing it. AdKats and the webadmin need player IDs in chat logs, so that procedure adds a column to your chatlog table for player ID. The trigger below it automatically adds the IDs when stat logger inserts new messages.

 

In 3.7 i had AdKats take over chat logging directly, but that caused far too many user based problems for it to continue.

[ImportBot]

Originally Posted by jking54*:

 

I have never had a procedure in the sql scripts before, that is what is causing the issue for you specifically, some part of your mysql config is not allowing it. AdKats and the webadmin need player IDs in chat logs, so that procedure adds a column to your chatlog table for player ID. The trigger below it automatically adds the IDs when stat logger inserts new messages.

 

In 3.7 i had AdKats take over chat logging directly, but that caused far too many user based problems for it to continue.

Great, John at NFO says:

 

We run mysql_upgrade after every update, but I can run it again. Which website is this in reference to?

 

Also, I don't believe that we allow the use of stored procedures here, due to their global nature. You can try it, but I don't think that this will work.

 

Any way to have a version without the web admin stuff, frankly I can live without that since I consider it redundant for my needs.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Great, John at NFO says:

 

We run mysql_upgrade after every update, but I can run it again. Which website is this in reference to?

 

Also, I don't believe that we allow the use of stored procedures here, due to their global nature. You can try it, but I don't think that this will work.

Ugh, that's what i was afraid of. They are off limits in NFO. The problem was nobody confirmed it when i asked before. I'll put it into the AdKats source and run the contents of the procedure from there.

[ImportBot]

Originally Posted by jking54*:

 

Ugh, that's what i was afraid of. They are off limits in NFO. The problem was nobody confirmed it when i asked before. I'll put it into the AdKats source and run the contents of the procedure from there.

Your patience is appreciated, can't say that enough.

[Prophet731]

Originally Posted by Prophet731*:

 

Any way to have a version without the web admin stuff, frankly I can live without that since I consider it redundant for my needs.

You can run it without the web admin, you just wont have the easy ability to edit bans and view a player history.