BanSync

sqroot submitted a new resource:

BanSync - Syncs bans across multiple servers.

Read more about this resource...

 

sqroot updated BanSync with a new update entry:

1.0.1

 

sqroot updated BanSync with a new update entry:

1.0.2

 

I'd like to post as an upvote and as a thanks. I asked for this a while ago and the developer was happy to create it. We've had no issues so far and currently sync 300+ bans across all of our servers with no issues. It might be worth linking an actual tutorial for people who aren't good with mySQL but other than that it's effective and easy to implement!

 

Is there anyway to make this Universal to sync Hurtworld and Rust bans ?

 

Code:

[Oxide] 3:23 PM [Debug]   at MySql.Data.MySqlClient.NativeDriver.Open () [0x0000
0] in <filename unknown>:0
  at MySql.Data.MySqlClient.Driver.Open () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectio
nStringBuilder settings) [0x00000] in <filename unknown>:0

 

@sqroot

Yep. Needs a step by step guide. The setup doesn't seem hard, but a better overview guide would attract more server owners.

Sounds like a great idea.

 

Using it for my servers works great.

EDIT: How does bansync handle players with Cyrillic characters?

Getting this error message when banning Russian players

Code:

10:13 PM [Error] MySql handle raised an exception (MySqlException: Incorrect string value: '\xD0\xA1\xD1\x82\xD0\xB8...' for column 'name' at row 1)
10:13 PM [Debug]   at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
  at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00000] in <filename unknown>:0
22:13 [Info] [BanSync] Unbanned user 'Стинк' with ID 7656

Should i change the MySQL table collation to UTF-8, will this fix the problem? Thanks

 

Hey, this is currently erroring.

[10/07/2016 02:36:58] [Oxide] 2:36 AM [Debug] at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.Driver.Open () [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0

 

Sorry for replying so late.

Would require me to rewrite some stuff (from Python to C#) and break the existing API (the common property of these games is the steam id - reason and name would be dropped).

Which version of MySQL are you using? MySQL 4.1 or better support UTF-8 by default, which is what this plugin expects. Just tried the plugin with that name and I can't reproduce the issue. The only other issue I can think of is the name not being valid UTF-8, but that issue should get caught by Steam itself.

You have to set up the plugin with your database, as described in the overview page.

 

Is there a way to change the ban reason on all servers? Example: I made a typo and want to change the reason on all servers. Now i have to unban that guy, and ban him again. Would be nice if there was a way to change it in the MySQL db.

 

We're seeing that the sync'd database clears itself after around 400-500 entries. It's happened twice - this also clears the ban list on each server.

It seems that adding servers sometimes clears the ban list sync.

 

I'll have a look at it when I get the time to, pretty busy right now.

 

To the people still using this plugin: Do you ever ban people by adding them to bans.cfg? Is it a frequent use case?

 

No.

Is there a way to change the ban reason across all servers without having to unban first?

 

What do I need to download to get python plugins to work? Specifically this one.