Mysql not saving
#1

forward GuardarCuenta(playerid);
public GuardarCuenta(playerid)
{
if(IsPlayerConnected(playerid))
{
new string[1024];

format(string, sizeof(string), "UPDATE `usuarios` SET `password`='%s', `Correo`='%s', `Sexo`=%d, `Admin`=%d, `Faccion`=%d, `Rango`=%d, `Radio`=%d, `MP3`=%d, `PoliceDuty`=%d, `LR`='%d' WHERE `username`='%s'", \
Pass[playerid], Correo[playerid], Sexo[playerid], Admin[playerid], Faccion[playerid], Rango[playerid], Radio[playerid], MP3[playerid], PoliceDuty[playerid], LR[playerid], nombre(playerid));
mysql_query(mysql, string);
mysql_free_result();
}
return 1;
}
Reply
#2

Delete:
Код:
mysql_free_result();
And show mysql logs.
Reply
#3

pawn Код:
format(string, sizeof(string), "UPDATE `usuarios` SET `password` = '%s', `Correo` = '%s', `Sexo` = '%d', `Admin` = '%d`, `Faccion` = '%d', `Rango` = '%d', `Radio` = '%d', `MP3` = '%d', `PoliceDuty` = '%d', `LR` = '%d' WHERE `username` = '%s'", definitions here);
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)