 |
|
Senior Member
|

11-10-2020
, 15:10
Re: MySQL not updating
|
#9
|
Quote:
Originally Posted by r0ma
PHP Code:
formatex( g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Candy` = '%d', `LevelS` = '%d', `LevelG` = '%d', `LevelH` = '%d' WHERE `%s`,`IP` = '%s'", SQL_TABNAME, Candies[id], Level[id][0], Level[id][1], Level[id][2], SQL_TABNAME, szIP );
formatex( g_szQuery, charsmax( g_szQuery ), "SELECT * FROM `%s` WHERE ( `%s`.`IP` = '%i' )", SQL_TABNAME, SQL_TABNAME, szIP);
to:
PHP Code:
formatex( g_szQuery, charsmax( g_szQuery ), "UPDATE `%s` SET `Candy` = '%d', `LevelS` = '%d', `LevelG` = '%d', `LevelH` = '%d' WHERE `IP` = '%s'", SQL_TABNAME, Candies[id], Level[id][0], Level[id][1], Level[id][2], szIP );
formatex( g_szQuery, charsmax( g_szQuery ), "SELECT * FROM `%s` WHERE ( `%s`.`IP` = '%s' )", SQL_TABNAME, SQL_TABNAME, szIP);
the ip is a string.
change all new szIp[10] to new szIp[23];
|
Thanks, that should work, i will go test it later since i am going to sleep, thx for helping
|
|
|
|