[AndreOliveira]

pawn Код:

public OnPlayerDisconnect(playerid)
{
    PlayerData[playerid][skin] = GetPlayerSkin(playerid);
    PlayerData[playerid][dinheiro] = GetPlayerMoney(playerid);

    new salvarPlayerQuery[500];
    mysql_format(conn, salvarPlayerQuery, sizeof(salvarPlayerQuery), "UPDATE players SET usuario='%e', senha='%e', skin=%i, dinheiro=%i, admin_level=%i WHERE id_player=%i",
                    PlayerData[playerid][usuario],
                    PlayerData[playerid][senha],
                    PlayerData[playerid][skin],
                    PlayerData[playerid][dinheiro],
                    PlayerData[playerid][admin_level],
                    PlayerData[playerid][id_player]);
    mysql_query(conn, salvarPlayerQuery, false);
    
    if(mysql_errno() != 0) print("Error!!!");
    return 1;
}

This code is printing Error(mysql_errno) and it's not saving the db. Help me pls. sry my english

[Konstantinos]

Post your mysql logs.

[AndreOliveira]

Код:

[12:55:23] [ERROR] CMySQLQuery::Execute - (error #1062) Duplicate entry '' for key 'usuario'

wtf :C

[AndreOliveira]

id_player was PRIMARY KEY, so i changed it, now works, but it happens:

[AndreOliveira]

When i try to print in server_log my PlayerData[playerid][usuario] (usuario = username), it prints null, why?

It saves the int but not the string

My cache:

Код:

cache_get_field_content(0, "usuario", PlayerData[playerid][usuario]);
cache_get_field_content(0, "senha", PlayerData[playerid][senha]);

[Konstantinos]

About loading:

pawn Код:

cache_get_field_content(0, "usuario", PlayerData[playerid][usuario], 21);

and make sure "usuario" has datatype VARCHAR.

[AndreOliveira]

usuario is varchar...

Код:

enum pInfo
{
	id_player,
	usuario[MAX_PLAYER_NAME],
	senha[32],
	skin,
	dinheiro,
	admin_level
}