MySQL query fails to set an int (+REP)
#9

First of all, if you escape playernames in the disconnect part, than also change this:

PHP код:
UPDATE `playerinfoSET `Online` = 1 WHERE `PlayerName` = '%s' 
To this:

PHP код:
UPDATE `playerinfoSET `Online` = 1 WHERE `PlayerName` = '%e' 
I saw the problem you have before in another topic, but don't know where is was unfortunately. Kind of weird since MySQL normally doesn't cut strings unless there are certain characters in there that are not compatible with the database charset.
Reply


Messages In This Thread
MySQL query fails to set an int (+REP) - by Amit1998 - 24.05.2016, 16:25
Re: MySQL query fails to set an int (+REP) - by ilijap - 24.05.2016, 16:34
Re: MySQL query fails to set an int (+REP) - by Amit1998 - 24.05.2016, 16:34
Re: MySQL query fails to set an int (+REP) - by ilijap - 24.05.2016, 16:36
Re: MySQL query fails to set an int (+REP) - by JasperM - 24.05.2016, 16:39
Re: MySQL query fails to set an int (+REP) - by ilijap - 24.05.2016, 16:43
Re: MySQL query fails to set an int (+REP) - by JasperM - 24.05.2016, 16:45
Re: MySQL query fails to set an int (+REP) - by Amit1998 - 24.05.2016, 16:46
Re: MySQL query fails to set an int (+REP) - by JasperM - 24.05.2016, 16:58
Re: MySQL query fails to set an int (+REP) - by Amit1998 - 24.05.2016, 16:58

Forum Jump:


Users browsing this thread: 3 Guest(s)