MySQL Ban System Help - Printable Version

MySQL Ban System Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Ban System Help (/showthread.php?tid=591207)

MySQL Ban System Help - Sensation - 09.10.2015

Hi!

I'm using Mysql ban system on my server.

My problem: When I ban a person name of Sensation, and login someone with name of SensaTioN then second person has been banned. How can i fix this problem? Please Help me..

Re: MySQL Ban System Help - Lordzy - 09.10.2015

Use BINARY clause along with WHERE while selecting banned name value. Below is just an example query, you can do it according to your ban table structure.

Код:

SELECT * FROM `ban_data` WHERE BINARY `bannedname`='name'

Though, I suggest you to avoid having case-sensitive names.

Re: MySQL Ban System Help - Sensation - 09.10.2015

I fixed the problem. Thanks for your help