19.01.2019, 11:37
Change the following:
to:
-------
to:
-------
to:
-------
to:
-------
to:
-------
And make sure that "email" is defined as VARCHAR with LENGTH 64 in MySQL Database.
Code:
pEmail,
Code:
pEmail[64],
Code:
PlayerInfo[playerid][pEmail] = 0;
Code:
PlayerInfo[playerid][pEmail] = "";
Code:
cache_get_value_name(0, "email", PlayerInfo[playerid][pEmail]);
Code:
cache_get_value_name(0, "email", PlayerInfo[playerid][pEmail],64);
Code:
new playeremail = PlayerInfo[playerid][pEmail];
Code:
new playeremail[64]; format(playeremail, 64, PlayerInfo[playerid][pEmail]);
Code:
mysql_format(handle, query, sizeof(query), "UPDATE users SET email = '%d', level = '%d', admin = '%d', money = '%d', kills = '%d', deaths = '%d' WHERE id = '%d'", playeremail, livello, adminl, soldi, uccisioni, morti, idgiocatore);
Code:
mysql_format(handle, query, sizeof(query), "UPDATE users SET email = '%s', level = '%d', admin = '%d', money = '%d', kills = '%d', deaths = '%d' WHERE id = '%d'", playeremail, livello, adminl, soldi, uccisioni, morti, idgiocatore);
And make sure that "email" is defined as VARCHAR with LENGTH 64 in MySQL Database.