UTF8 Problem with serverside bans.
 

Hello,

when my servers ban players with utf8-names (like the tm character) they show up as some strange characters on the website. It happens with all automated bans that get handled by sourcebans. When i ban players manually on the website they show up properly. They show up properly when i connect to the database with my own php scripts aswell (i use the set names utf8 command here).

how can i fix that with sourcebans 1.4.10?

kind regards

Re: UTF8 Problem with serverside bans.
 

sourcebans mysql UTF-8 set it manually ... in datbase tables ...
http://stackoverflow.com/questions/2...utf-8-properly

Re: UTF8 Problem with serverside bans.
 

Here are 2 screenshots.

http://www.pixelstube.com/sourcemod/blocked.jpg

http://www.pixelstube.com/sourcemod/mysql.jpg

The mySQL-DB is on a shared webhosting server. I'm very limited on what i can change.

Re: UTF8 Problem with serverside bans.
 

Did you banned player with this problem from console command or admin menu?

Re: UTF8 Problem with serverside bans.
 

The bans with the wrong encoding are done automatically by the server. No admin involved. Last few bans i checked where Team Killing time bans by SimpleTk or Eventscripts which use the sm_ban console commands.

The scripts use the command:
sm_ban userid time reason

Re: UTF8 Problem with serverside bans.
 

i have another problem witn Length (Banlength)

http://i.imgur.com/Mcdjfkr.png

MySQL charset: UTF-8 Unicode (utf8)

Re: UTF8 Problem with serverside bans.
 

Could you please send me your SourceBans URL?