Problema update mysql

[DeLeT.]

Am incercat sa fac o comanda pe dosar sa se faca update dar imi da mie in loc sa dea respectivului.

 

CMD:mobil(playerid, params[])
{
    if(P_Data[playerid][pAdminLevel] < 1) return SendClientMessage(playerid, -1, "[*] You're not a level 1+ admin!");
    new str[128],id,pname[MAX_PLAYER_NAME];
    new query[200];
    P_Data[playerid][pmobil] += 1;
    if(sscanf(params, "us", id, params)) SendClientMessage(playerid, 0xFF0000FF, "Usage: /mobil<id> <pentu>");
    else if(id == INVALID_PLAYER_ID) SendClientMessage(playerid, 0xFF0000FF, "ERROR: Player not connected");
       mysql_format(handle, query, sizeof(query), "UPDATE `account` SET `mobil`='%d' WHERE `ID`='%e'",P_Data[playerid][pDosar], playerid);// se face update la baza de date a playerului
    mysql_query(handle, query);// se trimite mesajul catre baza de date.
    if(playerid == id) SendClientMessage(playerid, 0xFF0000FF, "ERROR: You cannot pm yourself!");
    else
    {
        format(str, sizeof(str), "{FFFF00}Ai primit dosar {FFFFFF} %s {FFFF00}mobil: [%s].", pname, params);
        GetPlayerName(id, pname, sizeof(pname));
        format(str, sizeof(str), "{FFFF00}I-ai dat lui {FFFFFF} %s {FFFF00} ", pname, params);
        SendClientMessage(playerid, 0xFF0000FF, str);
        GetPlayerName(playerid, pname, sizeof(pname));
        SendClientMessage(id, 0xFF0000FF, str);
    }
    return 1;
}

[KruZZ]

CMD:mobil(playerid, params[])
{
    if(P_Data[playerid][pAdminLevel] < 1) return SendClientMessage(playerid, -1, "[*] You're not a level 1+ admin!");
    new str[128],id,pname[MAX_PLAYER_NAME];
    new query[200];
    P_Data[playerid][pmobil] += 1;
    if(sscanf(params, "us", id, params)) SendClientMessage(playerid, 0xFF0000FF, "Usage: /mobil<id> <pentu>");
    else if(id == INVALID_PLAYER_ID) SendClientMessage(playerid, 0xFF0000FF, "ERROR: Player not connected");
       GetPlayerName(playerid, pname, sizeof(pname));
       mysql_format(handle, query, sizeof(query), "UPDATE `account` SET `mobil`='%d' WHERE `username`='%e'",P_Data[playerid][pDosar], pname);// se face update la baza de date a playerului
    mysql_query(handle, query);// se trimite mesajul catre baza de date.
    if(playerid == id) SendClientMessage(playerid, 0xFF0000FF, "ERROR: You cannot pm yourself!");
    else
    {
        GetPlayerName(playerid, pname, sizeof(pname));
        format(str, sizeof(str), "{FFFF00}Ai primit dosar {FFFFFF} %s {FFFF00}mobil: [%s].", pname, params);
        SendClientMessage(id, 0xFF0000FF, str);
        GetPlayerName(id, pname, sizeof(pname));
        format(str, sizeof(str), "{FFFF00}I-ai dat lui {FFFFFF} %s {FFFF00} ", pname, params);
        SendClientMessage(playerid, 0xFF0000FF, str);
    }
    return 1;
}

Încearcă așa.

// edit: s-ar putea să îți dea erori în baza de date de la acel „username” pus de mine, modifici cu ce ai tu în baza de date

 

Edited October 11, 2015 by KruZZ

[DeLeT.]

Imi da mie +1 in loc sa dea player-uli respectiv.

Edited October 11, 2015 by DeLeT.