SA-MP Forums Archive
MySQL R38 Update - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL R38 Update (/showthread.php?tid=509373)


MySQL R38 Update - AndreOliveira - 26.04.2014

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

Re: MySQL R38 Update - Konstantinos - 26.04.2014

Post your mysql logs.

Re: MySQL R38 Update - AndreOliveira - 26.04.2014

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

Respuesta: MySQL R38 Update - AndreOliveira - 26.04.2014

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


Respuesta: MySQL R38 Update - AndreOliveira - 26.04.2014

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]);


Re: MySQL R38 Update - Konstantinos - 26.04.2014

About loading:
pawn Код:
cache_get_field_content(0, "usuario", PlayerData[playerid][usuario], 21);
and make sure "usuario" has datatype VARCHAR.

Re: MySQL R38 Update - AndreOliveira - 26.04.2014

usuario is varchar...

Код:
enum pInfo
{
	id_player,
	usuario[MAX_PLAYER_NAME],
	senha[32],
	skin,
	dinheiro,
	admin_level
}