alex600
Умник
помогите решить 08:44:21] [ERROR] CMySQLQuery::Execute[] - (error #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 '`Password` = 'asfasfsfafsfafsaf',`Email` = 'safasfasfas@yandex.ru'WHERE `Name` =' at line 1
PHP:
stock SavePlayer(i)
{
new scr[128];
new string[900];
format(string, sizeof(string),"UPDATE `accounts` SET");
format(scr, sizeof(scr), "`Skin` = %d,", Player[i][pSkin]);
strcat(string, scr);
format(scr, sizeof(scr), "`Money` = %d,", Player[i][pMoney]);
strcat(string, scr);
format(scr, sizeof(scr), "`Level` = %d,", Player[i][pLevel]);
strcat(string, scr);
format(scr, sizeof(scr), "`Admin` = %d,", Player[i][pAdmin]);
strcat(string, scr);
format(scr, sizeof(scr), "`Helper` = %d,", Player[i][pHelper]);
strcat(string, scr);
format(scr, sizeof(scr), "`Exp` = %d,", Player[i][pExp]);
strcat(string, scr);
format(scr, sizeof(scr), "`Health` = %f,", Player[i][pHealth]);
strcat(string, scr);
format(scr, sizeof(scr), "`Akey` = %d,", Player[i][pAkey]);
strcat(string, scr);
format(scr, sizeof(scr), "`ReferalCheck` = %d,", Player[i][pReferalCheck]);
strcat(string, scr);
format(scr, sizeof(scr), "`Sex` = %d,", Player[i][pSex]);
strcat(string, scr);
format(scr, sizeof(scr), "`Referal` = '%s'", Player[i][pReferal]);
strcat(string, scr);
format(scr, sizeof(scr), "`Password` = '%s',", Player[i][pPassword]);
strcat(string, scr);
format(scr, sizeof(scr), "`Email` = '%s'", Player[i][pEmail]);
strcat(string, scr);
format(scr, sizeof(scr), "WHERE `Name` = '%s'", Player[i][pName]);
strcat(string, scr, sizeof(string));
mysql_function_query(MysqlConnect, string, false, "", "");
}
