02.06.2012, 20:15
PHP Code:
stock SaveMail(playerid)
{
if(PlayerInfo[playerid][pLogged] == true)
{
if(regSave[playerid] == true)
{
new sqlmail[64], sqldrug[24], string[100], query[100];
mysql_real_escape_string(PlayerInfo[playerid][pEmail], sqlmail);
mysql_real_escape_string(PlayerInfo[playerid][pDrug], sqldrug);
strcat(string,"UPDATE `Accounts` SET `Mail` = '%s', `Drug` = '%s' WHERE `ID` = '%i'",sizeof(string));
format(query, sizeof(query),sqlmail,sqldrug,PlayerInfo[playerid][pID]);
mysql_debug(1);
mysql_query(query);
}
}
return 1;
}
Quote:
|
[23:21:13] CMySQLHandler::Query(nugmanov7@mail.ru) - An error has occured. (Error ID: 1064, 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 'nugmanov7@mail.ru' at line 1) |