search

pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
196 stars 80 forks source link

don't save, help! #211

Closed loneliplay closed 5 years ago

loneliplay commented 5 years ago

I am using 39-6 version.

format(qString, sizeof(qString), "UPDATEplayersSETname= '%s',password= '%s',money= '%d',admin= '%d',gruz= '%d' WHEREid` = '%d'", Player[playerid][pName], Player[playerid][pPassword], Player[playerid][pMoney], Player[playerid][pAdmin], Player[playerid][pGruz], Player[playerid][pID]);

mysql_function_query(DBconnectID, qString, false, "", "");`

SysadminJeroen commented 5 years ago

Hey, can you put your code in triple backticks?

If you don't know how please read this: https://help.github.com/en/articles/basic-writing-and-formatting-syntax#quoting-code

On Sun, Apr 14, 2019 at 12:54 PM loneliplay notifications@github.com wrote:

I am using 39-6 version.

format(qString, sizeof(qString), "UPDATEplayersSETname= '%s',password= '%s',money= '%d',admin= '%d',gruz= '%d' WHEREid` = '%d'", Player[playerid][pName], Player[playerid][pPassword], Player[playerid][pMoney], Player[playerid][pAdmin], Player[playerid][pGruz], Player[playerid][pID]);

mysql_function_query(DBconnectID, qString, false, "", "");`

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/pBlueG/SA-MP-MySQL/issues/211, or mute the thread https://github.com/notifications/unsubscribe-auth/ACx8xm4VtkgRfgsmoP2YNhUELFR17Q-6ks5vgwjQgaJpZM4cujAs .

SysadminJeroen commented 5 years ago

Hey, can you put your code in triple backticks?

If you don't know how please read this: https://help.github.com/en/articles/basic-writing-and-formatting-syntax#quoting-code

On Sun, Apr 14, 2019 at 2:57 PM Jeroen de Neef jeroen52@gmail.com wrote:

Hey, can you put your code in triple backticks?

If you don't know how please read this: https://help.github.com/en/articles/basic-writing-and-formatting-syntax#quoting-code

On Sun, Apr 14, 2019 at 12:54 PM loneliplay notifications@github.com wrote:

I am using 39-6 version.

format(qString, sizeof(qString), "UPDATEplayersSETname= '%s',password= '%s',money= '%d',admin= '%d',gruz= '%d' WHEREid` = '%d'", Player[playerid][pName], Player[playerid][pPassword], Player[playerid][pMoney], Player[playerid][pAdmin], Player[playerid][pGruz], Player[playerid][pID]);

mysql_function_query(DBconnectID, qString, false, "", "");`

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/pBlueG/SA-MP-MySQL/issues/211, or mute the thread https://github.com/notifications/unsubscribe-auth/ACx8xm4VtkgRfgsmoP2YNhUELFR17Q-6ks5vgwjQgaJpZM4cujAs .

loneliplay commented 5 years ago 
 format(qString, sizeof(qString), "UPDATE `players` SET `name` = '%s', `password` = '%s', `money` =  '%d', `admin` = '%d', `gruz` = '%d' WHERE `id` = '%d'", Player[playerid][pName], Player[playerid][pPassword], Player[playerid][pMoney], Player[playerid][pAdmin], Player[playerid][pGruz], Player[playerid][pID]);

mysql_function_query(DBconnectID, qString, false, "", "");
    return 1;
loneliplay commented 5 years ago

Hey, can you put your code in triple backticks? If you don't know how please read this: https://help.github.com/en/articles/basic-writing-and-formatting-syntax#quoting-code … On Sun, Apr 14, 2019 at 12:54 PM loneliplay @.***> wrote: I am using 39-6 version. format(qString, sizeof(qString), "UPDATEplayersSETname= '%s',password= '%s',money= '%d',admin= '%d',gruz= '%d' WHEREid= '%d'", Player[playerid][pName], Player[playerid][pPassword], Player[playerid][pMoney], Player[playerid][pAdmin], Player[playerid][pGruz], Player[playerid][pID]); mysql_function_query(DBconnectID, qString, false, "", ""); — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#211>, or mute the thread https://github.com/notifications/unsubscribe-auth/ACx8xm4VtkgRfgsmoP2YNhUELFR17Q-6ks5vgwjQgaJpZM4cujAs . up

FedeArre commented 5 years ago

This is not an error of the plugin, is an error in your query syntax.

UPDATE players SET name= '%s',password= '%s',money= %d, admin= %d, gruz= %d WHERE id = %d

Next time you can check the mysql_log file.

loneliplay commented 5 years ago

This is not an error of the plugin, is an error in your query syntax.

UPDATE players SET name= '%s',password= '%s',money= %d, admin= %d, gruz= %d WHERE id = %d

Next time you can check the mysql_log file.

Don't help

maddinat0r commented 5 years ago

Check the MySQL plugin log file for any errors or warnings.