alex600
Умник
Выручайте [09:04:59] [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 '' at line 1
PHP:
publics SaveHouse(i)
{
new scr[128];
new string[900];
new h = GetPVarInt(i, "PlayerHouse");
format(string, sizeof(string),"UPDATE `house` SET");
format(scr, sizeof(scr), "`hID` = %d,", House[h][hID]);
strcat(string, scr);
format(scr, sizeof(scr), "`hEntrx` = %f,", House[h][hEntrx]);
strcat(string, scr);
format(scr, sizeof(scr), "`hEntry` = %f,", House[h][hEntry]);
strcat(string, scr);
format(scr, sizeof(scr), "`hEntrz` = %f,", House[h][hEntrz]);
strcat(string, scr);
format(scr, sizeof(scr), "`hExitx` = %f,", House[h][hExitx]);
strcat(string, scr);
format(scr, sizeof(scr), "`hExity` = %f,", House[h][hExity]);
strcat(string, scr);
format(scr, sizeof(scr), "`hExitz` = %f,", House[h][hExitz]);
strcat(string, scr);
format(scr, sizeof(scr), "`hPrice` = %d,", House[h][hPrice]);
strcat(string, scr);
format(scr, sizeof(scr), "`hBuyPrice` = %d,", House[h][hBuyPrice]);
strcat(string, scr);
format(scr, sizeof(scr), "`hInt` = %d,", House[h][hInt]);
strcat(string, scr);
format(scr, sizeof(scr), "`hVirtual` = %d,", House[h][hVirtual]);
strcat(string, scr);
format(scr, sizeof(scr), "`hLock` = %d,", House[h][hLock]);
strcat(string, scr);
format(scr, sizeof(scr), "`hMIcon` = %d,", House[h][hMIcon]);
strcat(string, scr);
format(scr, sizeof(scr), "`hPickup` = %d,", House[h][hPickup]);
strcat(string, scr);
format(scr, sizeof(scr), "`hDiscript` = '%s',", House[h][hDiscript]);
strcat(string, scr);
format(scr, sizeof(scr), "`hGarage` = %d,", House[h][hGarage]);
strcat(string, scr);
/*format(scr, sizeof(scr), "WHERE `hOwner` = '%s'", House[h][hOwner]);
strcat(string, scr, sizeof(string));
format(scr, sizeof(scr), " WHERE `hOwner` = '%s' LIMIT 1", House[h][hOwner]);
strcat(string, scr);*/
mysql_function_query(MysqlConnect, string, false, "", "");
}
