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

Hey guys,
I've been trying to use the following queries when a player logs in / out from the server:

OnPlayerDisconnect()
PHP код:
     new iQuery[1700];
       
mysql_format(MySQLPipelineiQuerysizeof(iQuery), "UPDATE `playerinfo` SET `Online` = 1 WHERE `PlayerName` = '%s'"PlayerName(playerid));
    
mysql_tquery(MySQLPipelineiQuery); 
OnPlayerConnect()
PHP код:
{
    new 
iQuery[1700];
       
mysql_format(MySQLPipelineiQuerysizeof(iQuery), "UPDATE `playerinfo` SET `Online` = 0 WHERE `PlayerName` = '%e'"PlayerName(playerid));
    
mysql_tquery(MySQLPipelineiQuery);

Anywho, it doesn't set the value of Online to 0 when a player connects, tho working fine on a player disconnect.
What's the bug? Please help me <:

+REPing the helper
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: 1 Guest(s)