Raised This Month: $77 Target: $400
 19% 

UTF8 Problem with serverside bans.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Karower
Junior Member
Join Date: Aug 2012
Old 02-08-2013 , 11:45   UTF8 Problem with serverside bans.
Reply With Quote #1

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
Karower is offline
Faks
Junior Member
Join Date: Feb 2009
Old 02-09-2013 , 03:48   Re: UTF8 Problem with serverside bans.
Reply With Quote #2

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

Track Me
From Other Country's
From Latvia
Faks is offline
Karower
Junior Member
Join Date: Aug 2012
Old 02-11-2013 , 05:28   Re: UTF8 Problem with serverside bans.
Reply With Quote #3

Here are 2 screenshots.





The mySQL-DB is on a shared webhosting server. I'm very limited on what i can change.
Karower is offline
ppalex
Senior Member
Join Date: Nov 2012
Location: Russia, near the Moscow
Old 02-11-2013 , 07:54   Re: UTF8 Problem with serverside bans.
Reply With Quote #4

Did you banned player with this problem from console command or admin menu?
ppalex is offline
Karower
Junior Member
Join Date: Aug 2012
Old 02-11-2013 , 09:07   Re: UTF8 Problem with serverside bans.
Reply With Quote #5

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
Karower is offline
hasta
Senior Member
Join Date: Aug 2004
Location: Ukraine, Kiev
Old 02-12-2013 , 11:40   Re: UTF8 Problem with serverside bans.
Reply With Quote #6

i have another problem witn Length (Banlength)



MySQL charset: UTF-8 Unicode (utf
__________________
hasta is offline
Send a message via ICQ to hasta
Rytis
Veteran Member
Join Date: Feb 2012
Location: Germany
Old 02-12-2013 , 15:37   Re: UTF8 Problem with serverside bans.
Reply With Quote #7

Could you please send me your SourceBans URL?
Rytis is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 17:02.


Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Theme made by Freecode