function SavePlayerStats(playerid)
{
format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%d', `ppos_y` = '%d', `ppos_z` = '%d', `Level` = '%d' ` WHERE `user` = '%s'",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
mysql_query(str);
return 1;
}
[Mon Jan 10 22:47:19 2011] Function: mysql_query executed: "UPDATE `Users` SET `Money` = '0', `Gender` = '1', `ppos_x` = '0', `ppos_y` = '0', `ppos_z` = '0', `Level` = '0' ` WHERE `user` = 'Tyrone_Williamss'" with result: "1".
[Mon Jan 10 22:47:19 2011] Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '` WHERE `user` = 'Tyrone_Williamss'' at line 1.
function SavePlayerStats(playerid)
{
format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%df, `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `user` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
mysql_query(str);
return 1;
}
You are adding apostrophe's around your numerical variables (%d). You should be adding these; ` (same as the ~ key). You should also keep in mind you need to add apostrophe's around your string variables (%s); not `'s.
|
Error (0): Failed to exeute query. Unknown column 'user' in 'where clause'.
function SavePlayerStats(playerid)
{
format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%df, `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `User` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
mysql_query(str);
return 1;
}
Error (0): Failed to exeute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0.000000', `ppos_z` = '0.000000', `Level` = '0' WHERE `User` = 'Tyrone_Williamss' at line 1.
format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%f, `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `User` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid)
function SavePlayerStats(playerid)
{
format(str, sizeof(str), "UPDATE `Users` SET `Money` = '%d', `Gender` = '%d', `ppos_x` = '%f', `ppos_y` = '%f', `ppos_z` = '%f', `Level` = '%d' WHERE `User` = '%s';",UserStats[playerid][Money], UserStats[playerid][Gender],UserStats[playerid][ppos_x],UserStats[playerid][ppos_y],UserStats[playerid][ppos_z],UserStats[playerid][Level],pName(playerid));
mysql_query(str);
return 1;
}