Advanced In-Game Admin and Ban Enforcer - AdKats

[ImportBot]

Originally Posted by Hutchew*:

 

For testers, this is the only sql you will need to run for the full 4.0 release. It's just to access the unban command.

 

INSERT INTO `adkats_commands` VALUES(37, 'Active', 'player_unban', 'Log', 'Unban Player', 'unban', TRUE);

IMPORTANT!!!!!!!!!!!!!!!!!!!!!!

 

IF you are already running a beta with a database you want to keep, DO NOT run the full 4.0 sql query on your database, YOU WILL LOSE ALL YOUR INFO, INCLUDING BANS AND USERS.

 

Ask me how I know..............

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

IMPORTANT!!!!!!!!!!!!!!!!!!!!!!

 

IF you are already running a beta with a database you want to keep, DO NOT run the full 4.0 sql query on your database, YOU WILL LOSE ALL YOUR INFO, INCLUDING BANS AND USERS.

 

Ask me how I know..............

Dang hutchew . Usually the testers read my posts before they just run things... The script is only meant to be run fully once, and is set up to reset everything. Sorry for your loss man.

[ImportBot]

Originally Posted by AgentHawk*:

 

I don't have a limit on temp ban time yet.

but will be awesome

 

we got to many 9999999999999999999999 tbans

[Prophet731]

Originally Posted by Prophet731*:

 

For those waiting for the updated web admin, i've ran into a bit of a problem which might delay the release of it. It's kind of a very important one too. You can read the reason here.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

ok thanks man. I was trying out the tban in my server, i tried !tban 20y ixnorp askdasklda

 

it tells me invalid time given. i tried with 2w also it tells me the same thing.

 

it works with days and weeks.

 

or am i typing it wrongly? (tried searching before i post this)

 

There might be a limit on temp ban time in future?

I just checked the code...I only implemented m, h, d, and w. Not y. 1 bug added to the list.

[ImportBot]

Originally Posted by Hutchew*:

 

Lol.......yeah, my bad.......I didn't read through the posts prior to the release post, and there was no warning on that post.

 

Might want to add one, just so everybody is aware, though.

 

Setting up 70+ users all over again.....that brings the suck.

 

Thanks for the update, though.

 

Hutchew

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Lol.......yeah, my bad.......I didn't read through the posts prior to the release post, and there was no warning on that post.

 

Might want to add one, just so everybody is aware, though.

 

Setting up 70+ users all over again.....that brings the suck.

 

Thanks for the update, though.

 

Hutchew

If you still have your 3.7 database just run it on there. It will auto-import all of your users, bans, and records.

[ImportBot]

Originally Posted by Talzac*:

 

I just confirmed it works on the latest code.

 

Were you trying to test it on yourself? Admins cannot be muted, so if you tried talking in caps yourself to activate it then it would have cancelled the mute command. Switch your user role in AdKats to default guest to test it.

I was using it in "code" not I have set return True; in code and using it on action instead with log to procon chat enabled,

then it is working.

2013-12-21_135539.png

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I was using it in "code" not I have set return True; in code and using it on action instead with log to procon chat enabled,

then it is working.

Ah alright i'll remember that, glad it's working for you. This concept also applies to all AdKats commands, not just mute.

[ImportBot]

Originally Posted by ixnorp*:

 

[04:52:39 58] [AdKats] WARNING: Could not find l85a2 in BF4 library of 59 weapons.

 

[04:53:53 23] [AdKats] WARNING: Could not find rpk-74m in BF4 library of 59 weapons.

 

[07:00:31 14] [AdKats] WARNING: Could not find mtar-21 in BF4 library of 59 weapons.

 

[07:39:02 02] [AdKats] WARNING: Could not find mp7 in BF4 library of 59 weapons.

 

[08:00:46 60] [AdKats] WARNING: Could not find shorty-12g in BF4 library of 59 weapons.

 

just saw it on the console, will update more if i see more.

[ImportBot]

Originally Posted by AgentHawk*:

 

got a Bug since 4.0 with Procon....when I click on the Plugin I get sometimes an error message with

 

System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

bei PRoCon.uscPluginPanel.RefreshSelectedPlugin() in f:\Programming\Revision Control\Git\Myrcon Pty Ltd\Procon 1\Procon-1\src\PRoCon\Controls\uscPluginPanel.cs:Zeile 587.

bei PRoCon.uscPluginPanel.lsvLoadedPlugins_SelectedInd exChanged(Object sender, EventArgs e) in f:\Programming\Revision Control\Git\Myrcon Pty Ltd\Procon 1\Procon-1\src\PRoCon\Controls\uscPluginPanel.cs:Zeile 632.

bei System.Windows.Forms.ListView.OnSelectedIndexChang ed(EventArgs e)

bei System.Windows.Forms.ListView.WmReflectNotify(Mess age& m)

bei System.Windows.Forms.ListView.WndProc(Message& m)

bei System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)

bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

[ImportBot]

Originally Posted by Hutchew*:

 

New issue on github.

 

Server settings import does not appear to work at this time.

 

EDIT: After settings import, disable then re-enable adkats and it appears to properly work.

 

Hutchew

[ImportBot]

Originally Posted by Ralphvd*:

 

So before i lose everything in my database. Im from the 3.7.x.x version.

I just run the new .sql file? and replace the .cs file and i will be alright?

[ImportBot]

Originally Posted by jking54*:

 

Thanks C3, question on muting can we unmute?

 

for weps, rpk-74m, mp7, mtar-21 missing

[ImportBot]

Originally Posted by TMiland*:

 

My question now is: How will i go about migrating the reserved players now?

[ImportBot]

Originally Posted by jking54*:

 

My question now is: How will i go about migrating the reserved players now?

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

New issue on github.

 

Server settings import does not appear to work at this time.

 

EDIT: After settings import, disable then re-enable adkats and it appears to properly work.

 

Hutchew

Checked.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

got a Bug since 4.0 with Procon....when I click on the Plugin I get sometimes an error message with

I have no idea what that is. I'll need another dev to tell me.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

So before i lose everything in my database. Im from the 3.7.x.x version.

I just run the new .sql file? and replace the .cs file and i will be alright?

Correct, the danger was only there for testers who already had the new tables in their database. Just run the new .sql file, and replace the .cs file. When you start up AdKats the import process from 3.7 to 4.0 will start, do not stop it until it is finished.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

Thanks C3, question on muting can we unmute?

 

for weps, rpk-74m, mp7, mtar-21 missing

Unmute is not an option per the docs. Mute expires on round end.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

My question now is: How will i go about migrating the reserved players now?

I have not added your special table yet man. Will have to wait a little bit on that.

[ImportBot]

Originally Posted by jking54*:

 

Unmute is not an option per the docs. Mute expires on round end.

gotcha ty

[ImportBot]

Originally Posted by jking54*:

 

On my other server I forgot to run that small script for testers on the database and enabled AdKats on it by accident, then disabled it and ran the script, what are the implications? I was running 3.9.9.8 at the time

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

On my other server I forgot to run that small script for testers on the database and enabled AdKats on it by accident, then disabled it and ran the script, what are the implications? I was running 3.9.9.8 at the time

Nothing, you just can't use the unban command before running that insert.

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

l85a2, mp7, and shorty added.

[ImportBot]

Originally Posted by jking54*:

 

Nothing, you just can't use the unban command before running that insert.

Ok, I then disabled and ran that script is that ok? I don't see the unban command in either of my databases any longer...er check that, now I see them.

[ImportBot]

Originally Posted by Xjmhd*:

 

I have moved domain from a sub domain to an actual domain which means our Database got reset however I have a backup, but when I try to run the backup it gives me the error

 

Code:

Fejl
SQL-forespørgsel: Dokumentation

-- -- Database: `streamer_bf4` -- DELIMITER $$ -- -- Procedurer -- CREATE DEFINER=`streamer`@`localhost` 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_player[...]

MySQL returnerede: Dokumentation

#1304 - PROCEDURE addLogPlayerID already exists

Heres the .sql I'm trying to import dropbox link (File was to large for attachment)

[ColColonCleaner]

Originally Posted by ColColonCleaner*:

 

I have moved domain from a sub domain to an actual domain which means our Database got reset however I have a backup, but when I try to run the backup it gives me the error

 

Code:

Fejl
SQL-forespørgsel: Dokumentation

-- -- Database: `streamer_bf4` -- DELIMITER $$ -- -- Procedurer -- CREATE DEFINER=`streamer`@`localhost` 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_player[...]

MySQL returnerede: Dokumentation

#1304 - PROCEDURE addLogPlayerID already exists

Heres the .sql I'm trying to import dropbox link (File was to large for attachment)

DROP PROCEDURE IF EXISTS addLogPlayerID;

 

Then try again.

[ImportBot]

Originally Posted by Xjmhd*:

 

DROP PROCEDURE IF EXISTS addLogPlayerID;

 

Then try again.

Yep that worked, thank you!

[ImportBot]

Originally Posted by reutnitzer*:

 

Hey Colcolon

 

I use the Version 4.0 and if i insert a recip email they will deletet it by his self after a few seconds in the beta it wasent so, know you why it happens?