Advanced In-Game Admin and Ban Enforcer - AdKats

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Seems to be up and running, whats the best way to manage the bans etc apart from PhPmyAdmin?

 

Please don't tell me its this, as i just lost 12 hours of my life, and totally rebuilt a webserver from scratch trying to make it work.

 

http://www.adkgamers.com/topic/44514-downloadweb-admin/

There is a mini-ban-management section of the plugin settings page if you are unable to get the webadmin to work. Prophet731 is in charge of that development, so if you are having issues getting it working he can help you.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Aside from my last post that has not been answered yet I figured I would post again with this one. I keep getting crash's on the server every time it crash's I get this message.

 

Seems to happen on players using or spamming the /!admin command to call a admin on a player.

Code:

Server Crashed / Blaze Disconnected (65 Players Lost)

What exactly is going on to cause this?

Basically AdKats detected that 65 players were gone from the server without triggering their OnPlayerLeft events, and it issued an admin report automatically. It's a built in feature to notify the admins of server crashes. This happens when the battlefield server itself crashes, blaze disconnects, or in any other way loses an entire server worth of players.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Odd, as we got the same message on 1 server twice, the other remained full all morning. We also get the exact same email error too Lordicon.

 

Once more for luck, is there a working webpage to administer this?

The webadmin on that link you posted is the one. Talk with prophet if you are unable to get it working properly, he can point you in the right direction.

[ImportBot]

Originally Posted by jking54*:

 

There is a mini-ban-management section of the plugin settings page if you are unable to get the webadmin to work. Prophet731 is in charge of that development, so if you are having issues getting it working he can help you.

I'm hosting with Enjin for my web site but I do host with NFO for my server, RCOn and database and since they have phpMyAdmin, is there a way I can adapt Web Admin this way? I posted in your ADK forums on this but have received no answers yet. I'm also searching for a good host for a full php site that's easy to get started with.

 

OT but just saw a guy on your Lockers #7 server (no exps) 130-10 (so far) =:-O

[ImportBot]

Originally Posted by lordicon*:

 

The webadmin on that link you posted is the one. Talk with prophet if you are unable to get it working properly, he can point you in the right direction.

I just got the Web Admin installed and I must say, OMFG best Web Admin ever. Prophet is the man....

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I just got the Web Admin installed and I must say, OMFG best Web Admin ever. Prophet is the man....

A lot of work has gone into both sides, I don't know PHP and he doesn't know C#; Make a good duo when we aren't fighting like an old married couple, lol.

[ImportBot]

Originally Posted by Kinsman*:

 

Many thanks to prophet we got it installed too, alas installing it into the same db as XPKillers stats, and this plugin may not have been the wisest idea.

 

A server is stuck on 45 players, when in reality the only player in it is me, so it should be 1.

 

http://jw.servegame.org/bf4stats/index.php_ServerID=5

 

so basically table "Current players" is now stuck on 45, and I have no real idea how to fix it? I have restarted the server (thus both procon and mysql were rebooted), removed webadmin and all its tables, joined the server myself, nothing seems to help.

 

I'm guess I will manually need to MT the current players table, but then what to do with the sessions table?

 

I could just use an SQL backup from yesterday I guess, but that will also remove Adkats plugin itself, as I took that backup before I setup Adkats

 

Any recommendations, and even better any thoughts why killers DB is now locked up? I'm happy to use yesterdays backup and startover, but concerned I might end up right back in the same place.

[Prophet731]

Originally Posted by Prophet731*:

 

A lot of work has gone into both sides, I don't know PHP and he doesn't know C#; Make a good duo when we aren't fighting like an old married couple, lol.

Damn it colon, don't expose our secrets. They might use it against us. Lol

[ImportBot]

Originally Posted by lordicon*:

 

Damn it colon, don't expose our secrets. They might use it against us. Lol

ROFL That's right we might expose you and then bribe you into making a kick ass APP for Android phones

[ImportBot]

Originally Posted by Obl1ter*:

 

Trying to set up email notifications got this -

[AdKats] ERROR: Error while sending email: System.Net.Mail.SmtpException: The operation has timed out.

at System.Net.Mail.SmtpClient.Send(MailMessage message)

at PRoConEvents.AdKats.EmailHandler.EmailWrite(String subject, String body)

 

SSL - enabled, port is correct.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Trying to set up email notifications got this -

[AdKats] ERROR: Error while sending email: System.Net.Mail.SmtpException: The operation has timed out.

at System.Net.Mail.SmtpClient.Send(MailMessage message)

at PRoConEvents.AdKats.EmailHandler.EmailWrite(String subject, String body)

 

SSL - enabled, port is correct.

Which port are you using? Which service are you using? gmail?

[ImportBot]

Originally Posted by jking54*:

 

C3, ftr rpk-74m still showing up often along with mtar-21, how soon on these?

[ImportBot]

Originally Posted by AgentHawk*:

 

Im trying to install the new version on our new Database...but I get an error

 

SQL-Befehl: Dokumentation

 

CREATE PROCEDURE addLogPlayerID() BEGIN -- add logPlayerID column safely IF NOT EXISTS( (SELECT * FROM information_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) UNSIGNED DEFAULT NULL; ALTER TABLE `tbl_chatlog` ADD INDEX (`logPlayerID`); ALTER TABLE `tbl_chatlog` ADD CONSTRAINT `tbl_chatlog_ibfk_player_id` FOREIGN KEY (`logPlayerID`) REFERENCES `tbl_playerdata` (`PlayerID`) ON DELETE CASCADE ON UPDATE CASCADE; UPDATE `tbl_chatlog` INNER JOIN `tbl_playerdata` ON `tbl_chatlog`.`logSoldierName` = `tbl_playerdata`.`SoldierName` SET `tbl_chatlog`.`logPlayerID` = `tbl_playerdata`.`PlayerID` WHERE `tbl_playerdata`.`SoldierName` 'AutoAdmin' AND `tbl_playerdata`.`SoldierName` 'AdKats' AND `tbl_playerdata`.`SoldierName` 'Server' AND `tbl_playerdata`.`SoldierName` 'BanEnforcer' AND [...]

 

MySQL meldet: Dokumentation

 

#1044 - Access denied for user 'web75'@'localhost' to database 'usr_web75_1'

[ImportBot]

Originally Posted by lordicon*:

 

Trying to set up email notifications got this -

[AdKats] ERROR: Error while sending email: System.Net.Mail.SmtpException: The operation has timed out.

at System.Net.Mail.SmtpClient.Send(MailMessage message)

at PRoConEvents.AdKats.EmailHandler.EmailWrite(String subject, String body)

 

SSL - enabled, port is correct.

YES!!!, Shit sorry Obl1ter its just that after you posted that it proves to me i'm not the only one with the same Email problems....

[ImportBot]

Originally Posted by p19blo*:

 

If that's the case and you don't have direct access to mysql command line tools, you're going to need to create a dump of the database and manually edit each definer line in the sql dump. You will need to specify a user which exists and will access to the db.

 

For example, change:

 

 

 

to

 

 

 

Make sure you change every line in the sql dump which references DEFINER= and then re-import it.

 

Make sure you keep a backup of the original dump just in case you screw it up.

i have a VPS, would this make it easier to do that the above solution. Also thanks for your rpely

[ImportBot]

Originally Posted by Kinsman*:

 

it would seem doubtful that anyone has email working? I'm using a known gmail account that works fine from my server, and get the exact same errors that everyone else has.

 

I have just noticed ssl was set to true, so have set it to false in the hope that means it will use TLS_?

 

basically SSL uses port 465 and will not work, we need to be using TLS which uses port 587 for gmail

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

it would seem doubtful that anyone has email working? I'm using a known gmail account that works fine from my server, and get the exact same errors that everyone else has.

 

I have just noticed ssl was set to true, so have set it to false in the hope that means it will use TLS_?

 

basically SSL uses port 465 and will not work, we need to be using TLS which uses port 587 for gmail

That's exactly why i asked if you were using gmail, it requires 587 not 465 as the port and will give that error, which i described to someone earlier in the thread. Not to mention the default email settings which use a gmail account is set to use port 587.

[ImportBot]

Originally Posted by lordicon*:

 

That's exactly why i asked if you were using gmail, it requires 587 not 465 as the port and will give that error, which i described to someone earlier in the thread. Not to mention the default email settings which use a gmail account is set to use port 587.

However I don't use Gmail I use my own mail server and it uses port 50 which gives me the same error.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

However I don't use Gmail I use my own mail server and it uses port 50 which gives me the same error.

"Emailer: Weird thing, I changed the host IP and all of a sudden the Email section started to work correctly. Don't know what happen but it works now."

 

What changed? i might be able to track it down.

[ImportBot]

Originally Posted by AgentHawk*:

 

Any Ideas how I can run this_!

 

SQL-Befehl: Dokumentation

 

CREATE PROCEDURE addLogPlayerID() BEGIN -- add logPlayerID column safely IF NOT EXISTS( (SELECT * FROM information_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) UNSIGNED DEFAULT NULL; ALTER TABLE `tbl_chatlog` ADD INDEX (`logPlayerID`); ALTER TABLE `tbl_chatlog` ADD CONSTRAINT `tbl_chatlog_ibfk_player_id` FOREIGN KEY (`logPlayerID`) REFERENCES `tbl_playerdata` (`PlayerID`) ON DELETE CASCADE ON UPDATE CASCADE; UPDATE `tbl_chatlog` INNER JOIN `tbl_playerdata` ON `tbl_chatlog`.`logSoldierName` = `tbl_playerdata`.`SoldierName` SET `tbl_chatlog`.`logPlayerID` = `tbl_playerdata`.`PlayerID` WHERE `tbl_playerdata`.`SoldierName` 'AutoAdmin' AND `tbl_playerdata`.`SoldierName` 'AdKats' AND `tbl_playerdata`.`SoldierName` 'Server' AND `tbl_playerdata`.`SoldierName` 'BanEnforcer' AND [...]

 

MySQL meldet: Dokumentation

 

#1044 - Access denied for user 'web75'@'localhost' to database 'usr_web75_1'

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Any Ideas how I can run this_!

You don't have access to create procedures. Is your database hosted by someone else?

[ImportBot]

Originally Posted by AgentHawk*:

 

Yes. Netcup.de

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Yes. Netcup.de

See if you can get access to create procedures. If you can't, let me know and i'll work on a workaround.

[ImportBot]

Originally Posted by AgentHawk*:

 

I use a second one for a while and write a Ticket to my host....

 

 

But I have some troubble with the second aswell :/

 

got now this:

: Line 0: [uploadRecord][unexpected error uploading Record.]: MySql.Data.MySqlClient.MySqlException: Cannot add or update a child row: a foreign key constraint fails (`asyadmin_1`.`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 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.AdKats.UploadRecord(AdKatsRecord record)

[ImportBot]

Originally Posted by lordicon*:

 

"Emailer: Weird thing, I changed the host IP and all of a sudden the Email section started to work correctly. Don't know what happen but it works now."

 

What changed? i might be able to track it down.

Ok I am still using the same host and the only thing that changed that I know of is the IP address the setup and everything is exactly the same thing. Why did I change IP from my host? Well thats because of the PhP version they had installed, It was easier for them to move me to one of the newer servers then update the old server with a new php. So they moved me to a new server setup exactly the same way but the php version is diffrent and the IP address. Same mail setup and all, UNLESS... I didn't look to see if the Mysql was a newer or older version on the newer server so not sure about that one. Don't think that would change the way the mail system works though because it should work the same no matter the version of mysql.

 

If one of my servers were empty right now I would be able to test a few things with it. I will go ahead and test anyway and see what I get. ColColonCleaner I can also give you layer access if you need to so you can see for yourself the stuff. Just let me know.

[ImportBot]

Originally Posted by Kinsman*:

 

Heres a thought regarding email, did anyone upgrade php to 5.4 to support webadmin? If so, did you remember to add the open ssl module?

 

extension=php_openssl.dll

 

 

[ImportBot]

Originally Posted by lordicon*:

 

Heres a thought regarding email, did anyone upgrade php to 5.4 to support webadmin? If so, did you remember to add the open ssl module?

 

extension=php_openssl.dll

 

 

The email feature we are talking about is for Procon => Adkats not for WebAdmin they are two diffrent but the same things,

 

WebAdmin uses PhP + Mysql

Adkats uses C# + Mysql

 

extension=php_openssl.dll is for PhP which is not how Adkats is written.

 

The only thing I can think of it being is Mysql issues. If ColColonCleaner used the same method and code as the ProCon Email Notifier then everything should be working good. However Adkats does something a bit different then the Procon Email Notifier, It pulls information from the database such as the other admins emails if I am not mistaken. as where the Procon Email Notifier does everything from within Procon itself. So only that's the only thing i can think of being messed up. Lets look at the error people are getting again.

 

Code:

[AdKats] ERROR: Error while sending email: System.Net.Mail.SmtpException: The operation has timed out. at System.Net.Mail.SmtpClient.Send(MailMessage message) at PRoConEvents.AdKats.EmailHandler.EmailWrite(String subject, String body)

The only things I found about this error on the net are below that could be the issue but I am not sure.

 

http://blogs.msdn.com/b/webdav_101/a...-port-465.aspx

 

Could also try adding a timeout if there is not one already Code:

smtpClient.Timeout = 10000;

[ImportBot]

Originally Posted by Kinsman*:

 

Thanks for the clarification!

 

How can I manually remove 3 bans from adkats? Webadmin refuses to modify them, just gives a 404 error, and we seem to have 3 dodgy bans, possibly from a server crash that I need to remove. Can I just delete them using phpmyadmin for now?

 

Attached Files:

• banlist.jpg

[ImportBot]

Originally Posted by Causality85*:

 

HEEELLLPPP!!!

 

When i import the SQL script into my Database it returns this

 

Code:

Fehler

SQL-Befehl:

DELIMITER $$ DROP PROCEDURE IF EXISTS addLogPlayerID $$

MySQL meldet: Dokumentation
#1370 - alter routine command denied to user 'sid97307_1'@'%' for routine 'sid97307_1.addLogPlayerID'

How can I bring the script to work? Asking my GSP granting full access to DB failed!

[ImportBot]

Originally Posted by Kinsman*:

 

Seriously? its your DB, your the one paying for it. If your host won't allow "alter" you may as well go find a better one.