PHP код:
stock SaveData(playerid)
{
new src[1000],query[1400];
format(query,sizeof(query),"UPDATE `acc` SET");
format(src, sizeof(src), "Member = '%d',", Player[playerid][pMember]); strcat(query, src, sizeof(query));
printf("Фракция: %d", Player[playerid][pMember]);
format(src, sizeof(src), "Rank = '%d',", Player[playerid][pRank]); strcat(query, src, sizeof(query));
printf("Ранг: %d",Player[playerid][pRank]);
format(src, sizeof(src), "Model = '%d'", Player[playerid][pModel]); strcat(query, src, sizeof(query));
printf("Скин фракции: %d",Player[playerid][pModel]);
format(src,sizeof(src)," WHERE Name = '%s'",Player[playerid][pName]); strcat(query, src, sizeof(query));
mysql_function_query(ConnectMySQL, query, false, "", "");
return true;
}
Запятые не расставил. А перед WHERE ее не надо. Но тут стоил сделать одно форматирование. Например, так.
PHP код:
stock SaveData(playerid)
{
static const fmt_str[] = "UPDATE `acc` SET Member = '%d', Rank = '%d', Model = '%d' WHERE Name = '%s'";
new str[sizeof(fmt_str) - 2*4 + 2 +2 + 3 + MAX_PLAYER_NAME];
format(str, sizeof(str), fmt_str, Player[playerid][pMember], Player[playerid][pRank], Player[playerid][pModel], Player[playerid][pName]);
mysql_function_query(ConnectMySQL, query, false, "", "");
}