[rautamiekka]

Originally Posted by Jakeey802 It's just a warning you don't need to change it

You should, the plugin won't work when deprecations are removed.

[juss]

Originally Posted by rautamiekka You should, the plugin won't work when deprecations are removed.

i compile with this error: warning 234: symbol "GetClientAuthString" is marked as deprecated: Use GetClientAuthId"

and it didnt worked too =) ... the original one seems working , but after a change default to mysqlbans.. it give me another error (sorry i cant provide now that error) ,cant because i replace it wit h original one and servers are field with players now.. maybe at some point later i post the other errro here,, so far original one working without errors, altough i didnt ban anyone yet =) everyone seems so innocent =)

[Nerus]

Fixed: compiling warnings removed.

[Effeff]

I wanted to try making a new syntax version. As I was working on it, I realized someone named ShadowMen already did it 6 years ago here: https://github.com/Zipcore/Threaded-MySQL-Bans

I did it anyway and added translations and more features.

1. Separate table for IP bans
2. Separate table for logging bans (disabled by default, enable in AutoExecConfig)
3. Separate table for logging unbans (disabled by default, enable in AutoExecConfig)

I've tested it on server for a bit, everything seems to work without problems.

If someone has ideas for better implementation, let me know I guess. For example, the words "minutes" and "permanent" are hardcoded into the ban reason. I don't know of a better way to do it.
Also, I wanted to use regex for detecting if the IP you enter is valid, but I couldn't figure out how to make it work so I just made a function and used ExplodeString + some comparisons instead.

edit: forgot to get rid of a printtochat.
edit2: replaced two instances of Format that were supposed to be Database.Format

[ZeNite]

If i ban a steamid through console or the anti cheat bans someone it doesnt get registered in mysql

[Effeff]

Today I noticed that this plugin had been calculating the "time remaining" for non-permanent bans incorrectly.
Turns out, the person who made the one on the zipcore github from 6 years ago also noticed and fixed it. Maybe I should've just added functionality to that one after all, instead of editing from the original. Oh well.

The original uses: (now()-timestamp)/60

The version in the zipcore github link uses: TIMESTAMPDIFF(SQL_TSI_MINUTE, timestamp, CURRENT_TIMESTAMP)

The one I am using: TIMESTAMPDIFF(MINUTE, timestamp, now())

I believe there is no difference between the zipcore one and mine.

Re-posting the plugin and translation, although translation has not changed:

[klikk]

Originally Posted by Adjo It doesn't provide support for that by default, I've quickly written a PHP script that should do this for you, and anyone else. Should work, haven't got an install of this plugin though to test it. Spoiler PHP Code: <?php          $config    =    array(                  'db_prefix'    =>    'my',    //default prefix is my, so this shouldn't need to be changed.         'host'        =>    'locahost',    //your database host, probably 127.0.0.1, or something         'user'        =>    'myuseruser',    //your database username         'pass'        =>    'mypassword',    //your database password         'db'        =>    'mydatabase_name',    //and your database name              );          $db    =    mysqli_connect($config['host'], $config['user'], $config['pass'], $config['db']);     if(!$db)die('There was an error connecting to the database.');          $file = file('banned_user.cfg', FILE_SKIP_EMPTY_LINES);     $query = array();          foreach($file as $ban){         $ban = explode(' ', substr($ban, 6));                  $query[] = 'INSERT INTO `'.$config['db_prefix'].'_bans`             (steam_id, player_name, ban_length, ban_reason, banned_by, timestamp) VALUES             (\''.mysqli_real_escape_string($db, $ban[1]).'\', \'Imported Ban\', '.((int)$ban[0]).', \'Imported Ban\', \'Console\', CURRENT_TIMESTAMP())';                  }          $res = mysqli_multi_query($db, implode('; ', $query);     if(!$res)die('One or more queries failed when importing the bans.');      ?> You'll need to have the banned_user.cfg file in the same directory as the php script. You don't need to remove anything from the banned_user file (such as the banid text), the script automatically does this.

How can i use this code? sry am newbie

[Nightmare Pyro]

I notice that this doesn't support the command by sm_addban to add offline steamid...