[Swankeh]

Hello, I have been testing to see if everything is going well, but at the moment of disconnecting I do not update the data of the player in the database. To see that the variables are fine I print them and for example I print them in one but when updating the table I do not update it stays in zero.

PHP Code:

    new DB_Query[256];
    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]); 


[BreakStore]

Hello try this,

PHP Code:

new DB_Query[256]; 
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: You don't forget the function mysql_tquery to save the data of player ?

[whadez]

Make sure you dont clear the InfoU array before saving the data.

[Swankeh]

Quote:

Originally Posted by BreakStore Hello try this, PHP Code: new DB_Query[256];  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: You don't forget the function mysql_tquery to save the data of player ?

Hello thanks for replying, if I have mysql_tquery I forgot to post it here, I tried it as you did the code and keep going with the same review the table and has it in 0, but when printing the value I print it in 1, I have it trying in several ways and not being updated.

PHP Code:

    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);
    printf("%d", InfoU[playerid][pNivel]); 


I give you the create table.

PHP Code:

mysql_tquery(Database, "CREATE TABLE IF NOT EXISTS `USUARIOS` (`ID` int(11) NOT NULL AUTO_INCREMENT,`NOMBRE` varchar(24) NOT NULL,`CLAVE` char(65) NOT NULL,`SALT` char(11) NOT NULL,`NIVEL` mediumint(7), `ASESINATOS` mediumint(7), `DINERO` mediumint(7) NOT NULL DEFAULT '0',`MUERTES` mediumint(7) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`), UNIQUE KEY `NOMBRE` (`NOMBRE`))"); 


The table if it is created, until the account of the player but what happens is that when disconnecting is not updated

I have tried since yesterday but I do not update anything.

[whadez]

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, "", "");

Send me the output message.

[Swankeh]

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.

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, "", ""); 


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.

[Swankeh]

Quote:

Originally Posted by whadez 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, "", ""); Send me the output message.

Thanks to you I noticed the problem, in my table of users when you register you create the table with the unique ID, in the printf it gives me in 0 when it would have to be in 1.

[whadez]

Yes the ID column should be auto increment, no problem.