Проблема Проблема с MySQL сохранение аккаунта

[Alonso 82]

[18:47:38] [ERROR] error #2013 while executing query "UPDATE `peoples` SET `Skin` = '22', `Pol` = '1', `Member` = '0', `Rang` = '0', `Admin` = '6', `Cash` = '50000000', `JSkill1` = '55'  WHERE `Name` = 'Alexey_Alonzo'": Lost connection to MySQL server during query (J:\Europe RolePlay\gamemodes\new.pwn:439 -> J:\Europe RolePlay\gamemodes\new.pwn:682)

 

Не сохраняет аккаунт, и пишет это в мьюскл логах.

[#Rips 210]

 

 

r during query (J:\Europe RolePlay\gamemodes\new.pwn:439 -> J:\Euro

неверно выполнен запрос у тебя

[Alonso 82]

publics: SavePlayer(playerid)
{
	if(PlayerInfo[playerid][pLogged] == 0) return 0;
    query_string = "UPDATE `peoples` SET";
    format(query_string, sizeof(query_string), "%s `Skin` = '%d',", query_string, PlayerInfo[playerid][pSkin]);
    format(query_string, sizeof(query_string), "%s `Pol` = '%d',", query_string, PlayerInfo[playerid][pPol]);
    format(query_string, sizeof(query_string), "%s `Member` = '%d',", query_string, PlayerInfo[playerid][pMember]);
    format(query_string, sizeof(query_string), "%s `Rang` = '%d',", query_string, PlayerInfo[playerid][pRank]);
    format(query_string, sizeof(query_string), "%s `Admin` = '%d',", query_string, PlayerInfo[playerid][pAdmin]);
    format(query_string, sizeof(query_string), "%s `Cash` = '%d',", query_string, PlayerInfo[playerid][pCash]);
    format(query_string, sizeof(query_string), "%s `JSkill1` = '%d' ", query_string, PlayerInfo[playerid][pJSkill1]);
    format(query_string, sizeof(query_string), "%s WHERE `Name` = '%s'", query_string, PlayerInfo[playerid][pName]);
    mysql_tquery(mysql_connect_ID, query_string, !"", !"");
    return 1;
}

вот весь паблик

[SCRIPTMAN 358]

 

 

%s

зачем они? убери их попробуй

[Marvellous 271]

@Alonso,Если как сказал Скриптман не поможет,то попробуй вот так еще! 

publics: SavePlayer(playerid)
{
	if(PlayerInfo[playerid][pLogged] == 0) return 0;
    query_string = "UPDATE `peoples` SET";
	format(src,sizeof(src), "%s `Skin` = '%d',", PlayerInfo[playerid][pSkin]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s `Pol` = '%d',", PlayerInfo[playerid][pPol]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s `Member` = '%d',", PlayerInfo[playerid][pMember]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s `Rang` = '%d',", PlayerInfo[playerid][pRang]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s `Admin` = '%d',", PlayerInfo[playerid][pAdmin]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s `Cash` = '%d',", PlayerInfo[playerid][pCash]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s `JSkill1` = '%d' ", PlayerInfo[playerid][pJSkill1]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "%s WHERE `Name` = '%s'", PlayerInfo[playerid][pName]);strcat(query,src,sizeof(query));
    mysql_tquery(mysql_connect_ID, query_string, !"", !"");
    return 1;
}

Или так

publics: SavePlayer(playerid)
{
	if(PlayerInfo[playerid][pLogged] == 0) return 0;
    query_string = "UPDATE `peoples` SET";
	format(src,sizeof(src), "`Skin` = '%d',", PlayerInfo[playerid][pSkin]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "`Pol` = '%d',", PlayerInfo[playerid][pPol]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "`Member` = '%d',", PlayerInfo[playerid][pMember]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "`Rang` = '%d',", PlayerInfo[playerid][pRang]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "`Admin` = '%d',", PlayerInfo[playerid][pAdmin]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "`Cash` = '%d',", PlayerInfo[playerid][pCash]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "`JSkill1` = '%d' ", PlayerInfo[playerid][pJSkill1]);strcat(query,src,sizeof(query));
	format(src,sizeof(src), "WHERE `Name` = '%s'", PlayerInfo[playerid][pName]);strcat(query,src,sizeof(query));
    mysql_tquery(mysql_connect_ID, query_string, !"", !"");
    return 1;
}

Изменено 28 сентября, 2017 пользователем Marvellous

[SCRIPTMAN 358]

А вообще, лучше сделать все в одну строку.