SA-MP Forums Archive
[Ajuda] UPDATE Mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] UPDATE Mysql (/showthread.php?tid=636312)


[Resolvido] Mysql - VinicioN - 25.06.2017

Resolvido

Re: UPDATE Mysql - RodrigoMSR - 25.06.2017

Estava faltando o acento grave no inнcio da primeira coluna nas 2 querys:
Код:
    format(query, sizeof(query), "UPDATE `contas` SET `Policial` = '%d',`Celular` = '%d',`Profissao` = '%d',`Reportes` = '%d',`Logou` = '%d',`Morreu` = '%d' WHERE `usuario` = '%s'", 
    PlayerInfo[a][Policial],PlayerInfo[a][Celular],PlayerInfo[a][Profissao],PlayerInfo[a][Reportes], PlayerInfo[a][Logou], PlayerInfo[a][Morreu], PlayerName(a)); 
    mysql_function_query(mysql, query, false, "", ""); 

    format(query, sizeof(query), "UPDATE `contas` SET `Vida` = '%f',`Colete` = '%f',`Dinheiro` = '%d'  WHERE `usuario` = '%s'", 
    PlayerInfo[a][Vida],PlayerInfo[a][Colete],PlayerInfo[a][Dinheiro], PlayerName(a)); 
    mysql_function_query(mysql, query, false, "", "");


Re: UPDATE Mysql - VinicioN - 25.06.2017

Quote:
Originally Posted by RodrigoMSR
Посмотреть сообщение
Estava faltando o acento grave no inнcio da primeira coluna nas 2 querys:
Код:
    format(query, sizeof(query), "UPDATE `contas` SET `Policial` = '%d',`Celular` = '%d',`Profissao` = '%d',`Reportes` = '%d',`Logou` = '%d',`Morreu` = '%d' WHERE `usuario` = '%s'", 
    PlayerInfo[a][Policial],PlayerInfo[a][Celular],PlayerInfo[a][Profissao],PlayerInfo[a][Reportes], PlayerInfo[a][Logou], PlayerInfo[a][Morreu], PlayerName(a)); 
    mysql_function_query(mysql, query, false, "", ""); 

    format(query, sizeof(query), "UPDATE `contas` SET `Vida` = '%f',`Colete` = '%f',`Dinheiro` = '%d'  WHERE `usuario` = '%s'", 
    PlayerInfo[a][Vida],PlayerInfo[a][Colete],PlayerInfo[a][Dinheiro], PlayerName(a)); 
    mysql_function_query(mysql, query, false, "", "");
Obrigado mano, era esse o problema mesmo +rep