Problema cu Update in Baza de date.

[DonErik]

Am o problema, cu SQL-ul, am incercat sa o rezolv de multe ori dar nu am reusit si m-am gandit sa postez aici.

[RABIGKY]

Salut, inlocuiesti comanda aia cu asta daca doresti 

CMD:makeadmin(playerid, params[])
{
	if(PlayerInfo[playerid][pAdmin] == 7)
	{
	    new string[50], id, amount;
		if(sscanf(params, "ui", id, amount)) return SCM(playerid, -1, "SYNTAX:/makeadmin <ID> <1-7>");
		format(string, sizeof(string), "%s ti-a setat admin-ul la %d.", GetName(playerid), amount);
		SCM(playerid, 0x00FF66, string);
		PlayerInfo[playerid][pAdmin] = amount;
		
        gQuery[0] = EOS;
		mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `conturi` SET `Admin`='%d' WHERE `ID`='%d'", GetPlayerScore(playerid), PlayerInfo[playerid][pSQLID]);
		mysql_tquery(SQL, gQuery, "", "");
	    
	}
	else
	{
		SCM(playerid, 0xFF0000, "[SERVER]: Nu ai gradul necesar.");
	}
	return 1;
}

Daca ai vreo problema cu aceasta comanda, da-mi pm.. Sper ca te-am ajutat  

Edited July 29, 2019 by RABIGKY

[BaFFy]

On 7/27/2019 at 2:01 PM, LordHitlerAdv said:

Am o problema, cu SQL-ul, am incercat sa o rezolv de multe ori dar nu am reusit si m-am gandit sa postez aici.

Inainte de mysql_format pune PData[iD][pAdmin] = level;

Iar in mysql_format unde ai pus Pdata[playerid][pAdmin] inlocuieste cu Pdata[iD][pAdmin].

[qSorin_]

1 oră în urmă, BaFFy a spus:

Inainte de mysql_format pune PData[iD][pAdmin] = level;

Iar in mysql_format unde ai pus Pdata[playerid][pAdmin] inlocuieste cu Pdata[iD][pAdmin].

Aolo, tu esti mai noob ca el de ce sa puna P_Date[id][pAdmin] ? daca nu i-a setat o valoare anume? 

Incearca asta:

 

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", level, GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s has a level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    P_Data[id][pAdmin] = level;

    return true;
}

[BaFFyJunior]

Acum 36 minute, [El.Capo] a spus:

Aolo, tu esti mai noob ca el de ce sa puna P_Date[id][pAdmin] ? daca nu i-a setat o valoare anume? 

Incearca asta:

 

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", level, GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s has a level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    P_Data[id][pAdmin] = level;

    return true;
}

Nu am vazut ce a facut acolo cu else si else if. Dar tot am dreptate, nu e ok ce a facut in actualizarea bazei de date.

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", level, GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s has a level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    P_Data[id][pAdmin] = level;

    return true;
}

Asta e ce ai facut tu. Ma refeream sa faca la fel, dar asa:
 

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

	P_Data[id][pAdmin] = level;
    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", P_Data[id][pAdmin], GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    return 1;
}

 

[qSorin_]

Acum 1 oră, BaFFyJunior a spus:

Nu am vazut ce a facut acolo cu else si else if. Dar tot am dreptate, nu e ok ce a facut in actualizarea bazei de date.

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", level, GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s has a level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    P_Data[id][pAdmin] = level;

    return true;
}

Asta e ce ai facut tu. Ma refeream sa faca la fel, dar asa:
 

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

	P_Data[id][pAdmin] = level;
    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", P_Data[id][pAdmin], GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    return 1;
}

 

e mai ok a mea, dar ce ai facut aici ai dat copy paste de la mine si ai mutat P_Data[id[pAdmin] = level; mai sus doar atat si la salvare ai pus P_Data

Ori ca o foloseste pe asta ori ca o foloseste pe a mea tot drq ala e !

[DonErik]

La 29.07.2019 la 10:49, [El.Capo] a spus:

Aolo, tu esti mai noob ca el de ce sa puna P_Date[id][pAdmin] ? daca nu i-a setat o valoare anume? 

Incearca asta:

 

CMD:setadmin(playerid, params[]) {
    new id, gMessage[128], level;
    if(sscanf(params, "ud", id,level)) return SendClientMessage(playerid, 0xFF0000FF, "Usage: /setadmin [playerid] [level]");
    if(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, 0xFF0000FF, "That player is not online");

    mysql_format(handle, Query, sizeof(Query), "UPDATE `conturi` SET `Admin`='%d' WHERE `Nume`='%s'", level, GetName(id));
    mysql_tquery(handle, Query, "", "");

    format(gMessage, sizeof(gMessage), "* You have set %s has a level %d admin", GetName(id), level);
    SendClientMessage(playerid, 0xFFFFFFFF, gMessage);

    format(gMessage, sizeof(gMessage), "* You have been set as a level %d admin", level);
    SendClientMessage(id, 0xFFFFFFFF, gMessage);    

    P_Data[id][pAdmin] = level;

    return true;
}

 Mereu imi da eroare asta, nuj cum sa o fac am incercat multe metode.

[BaFFyJunior]

Acum 2 minute, LordHitlerAdv a spus:

 Mereu imi da eroare asta, nuj cum sa o fac am incercat multe metode.

Incearca sa pui new Query[144];

[DonErik]

Acum 1 minut, BaFFyJunior a spus:

Incearca sa pui new Query[144];

A mers, acum sa vad daca isi da update in baza.

[DonErik]

Acum 6 minute, BaFFyJunior a spus:

Incearca sa pui new Query[144];

A mers Multumesc m-ai scapat de un chin!

T/C rezolvat!