Problema cu Update in Baza de date.

DonErik · July 27, 2019

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 · July 29, 2019

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 · July 29, 2019

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_ · July 29, 2019

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 · July 29, 2019

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_ · July 29, 2019

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 · July 30, 2019

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 · July 30, 2019

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 · July 30, 2019

Acum 1 minut, BaFFyJunior a spus:

Incearca sa pui new Query[144];

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

DonErik · July 30, 2019

Acum 6 minute, BaFFyJunior a spus:

Incearca sa pui new Query[144];

A mers Multumesc m-ai scapat de un chin!

T/C rezolvat!

Sign In

Problema cu Update in Baza de date.

Recommended Posts

DonErik

RABIGKY

BaFFy

qSorin_

BaFFyJunior

qSorin_

DonErik

BaFFyJunior

DonErik

DonErik

Similar Content

Actualizare textdraw (speedometer) la secunda (problema)

Problema /vehicles

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Problema clan members: Nu afiseaza membrii.

Problema dialog dealership (nu afiseaza ID-ul masinii)

Recently Browsing 0 members

Browse

Activity

Important Information