23.09.2017, 17:16
Ready I made it here is the message.
UPDATE `USUARIOS` SET `NIVEL` = '1', `DINERO` = '0', `ASESINATOS` = '0', `MUERTES` = '1' WHERE `ID` = '0' LIMIT 1
What you notice is that if you save the variable with the correct value in 1.
I put the code that you passed me.
maybe it's problem with mysql_tquery? Or why do not you update it?
EDIT: If you need an image of my table, I'll give it to you.
UPDATE `USUARIOS` SET `NIVEL` = '1', `DINERO` = '0', `ASESINATOS` = '0', `MUERTES` = '1' WHERE `ID` = '0' LIMIT 1
What you notice is that if you save the variable with the correct value in 1.
I put the code that you passed me.
PHP Code:
printf("UPDATE `USUARIOS` SET `NIVEL` = '%d', `DINERO` = '%d', `ASESINATOS` = '%d', `MUERTES` = '%d' WHERE `ID` = '%d' LIMIT 1", InfoU[playerid][pNivel], InfoU[playerid][pDinero], InfoU[playerid][pAsesinatos], InfoU[playerid][pMuertes], InfoU[playerid][ID]);
mysql_format(Database, DB_Query, sizeof(DB_Query), "UPDATE `USUARIOS` SET `NIVEL` = '%d', `DINERO` = '%d', `ASESINATOS` = '%d', `MUERTES` = '%d' WHERE `ID` = '%d' LIMIT 1",
InfoU[playerid][pNivel], InfoU[playerid][pDinero], InfoU[playerid][pAsesinatos], InfoU[playerid][pMuertes], InfoU[playerid][ID]);
mysql_tquery(Database, DB_Query, "", "");
EDIT: If you need an image of my table, I'll give it to you.