Problema setadmin

1Shot · February 7, 2019

Salut. Am si eu o problema, nu se salveaza adminul dupa ce dau /setadmin... Adica daca jucatorul iese de pe server ii dispare adminul...

Aceasta este comanda:

YCMD:setadmin(playerid, params[], help) {

	new id, adminlevel, gString[120];

	if(PlayerInfo[playerid][pAdmin] < 6)
		return SCM(playerid, COLOR_WHITE, AdminOnly);

	if(sscanf(params, "ui", id, adminlevel))
		return SCM(playerid, COLOR_GREY, "USAGE: {FFFFFF}/setadmin <playerid/name> <Admin Level>");

	if(!IsPlayerConnected(id) || id == INVALID_PLAYER_ID)
		return SCM(playerid, COLOR_GREY, "Acel player nu este conectat.");

	if(PlayerInfo[id][pAdmin] > PlayerInfo[playerid][pAdmin])
		return SCM(playerid, COLOR_GREY, "Nu poti folosi aceasta comanda pe acel player. Are admin level mai mare.");

	format(gString, 80, "Ai fost promovat la admin %d de %s", adminlevel, GetName(playerid));
	SCM(id, COLOR_LIGHTBLUE, gString);

	format(gString, 100, "AdmCmd: %s i-a setat lui %s admin level %d.", GetName(playerid), GetName(id), adminlevel);
	SendAdminHelperMessage(COLOR_LOGS, gString);

	if(adminlevel == 0)
	{
		PlayerInfo[id][pAW] = 0;
		UpdateVar(id, "AW", 0);
		SpecFaction[id] = 0;
		StopFly(playerid);
		UsedFly[playerid] = 0;
		SetPlayerHealthEx(playerid, 100);

		Iter_Remove(PlayerAdmins, id);
	}

	Iter_Add(PlayerAdmins, id);

	finishAchievement(id, 27);
	PlayerInfo[id][pAdmin] = adminlevel;

	new gQuery[180];

	if(adminlevel >= 1) // Aici
	{
		format(gQuery, sizeof(gQuery), "UPDATE users SET `Admin`='%d', `Security`='pass', `HelpedPlayers`='0' WHERE `ID`='%d'", PlayerInfo[id][pAdmin], PlayerInfo[id][pSQLID]);
		UpdateVar(id, "Admin", PlayerInfo[id][pAdmin]);
		mysql_tquery(SQL, gQuery, "", "");
		SetPVarInt(id, "SecurityPlayer", 0);
	}

	return true;
}

Multumesc.

Edited February 7, 2019 by 1Shot

Banditul · February 7, 2019

Nu vad nici o problema. Poti sa verifici mysql log?

Tot ce pot sugera este asta:

if(adminlevel >= 1) // Aici
{
    format(gQuery, sizeof(gQuery), "UPDATE users SET `Admin`= %d, `Security`='pass', `HelpedPlayers`= 0 WHERE `ID`= %d", PlayerInfo[id][pAdmin], PlayerInfo[id][pSQLID]);
    UpdateVar(id, "Admin", PlayerInfo[id][pAdmin]);
    mysql_tquery(SQL, gQuery, "", "");
    SetPVarInt(id, "SecurityPlayer", 0);
}

Numerele nu trebuie sa aibe ' mai ales ID-u pentru ca nu va folosi indexu si va lua mai mult sa caute respectivul id

SherKan · February 7, 2019

daca ai burned e posibil sa fie de la securitate, incerca sa o scoti de tot

1Shot · February 8, 2019

Gata, am rezolvat.

Dar acum imi apare alta eroare in mysql log:

[04:12:11] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

Cum o pot rezolva?...

Edited February 8, 2019 by 1Shot

Banditul · February 8, 2019

Aia poate sa fie oriunde in gm. Deobicei e din cauza faptului ca nu e un cache activ

cache_get_content_int(0, "Coloana", Test);

Asta produce acea eroare

mysql_query(SQL, "SELECT Coloana FROM tabel WHERE 1 = 1");
mysql_store_result();
cache_get_content_int(0, "Coloana", Test);
mysql_free_result();

In schimb asta e valid pentru ca are cache activ, cu cel putin 1 rezultat

(Evident tu ai alta functie de luat datele din cache, din pacate nu am lucrat niciodata cu mysql vechi asa ca nu stiu functiile dar princpiu e acelasi)

DroKeN · February 8, 2019

Pune functile astea in comanda /setadmin

   else format(query,sizeof(query),"UPDATE users SET `Admin`='%d' WHERE `ID`='%d'",PlayerInfo[id][pAdmin],PlayerInfo[id][pSQLID]);
   mysql_query(SQL,query);
   UpdateVar(id, "Admin", PlayerInfo[id][pAdmin]);

Banditul · February 8, 2019

Acum 3 minute, DroKeN a spus:

Pune functile astea in comanda /setadmin

   else format(query,sizeof(query),"UPDATE users SET `Admin`='%d' WHERE `ID`='%d'",PlayerInfo[id][pAdmin],PlayerInfo[id][pSQLID]);
   mysql_query(SQL,query);
   UpdateVar(id, "Admin", PlayerInfo[id][pAdmin]);

A zis ca a rezolvat cu setadmin

1Shot · February 8, 2019

2 hours ago, Banditul said:
Aia poate sa fie oriunde in gm. Deobicei e din cauza faptului ca nu e un cache activ
cache_get_content_int(0, "Coloana", Test);
Asta produce acea eroare
mysql_query(SQL, "SELECT Coloana FROM tabel WHERE 1 = 1");
mysql_store_result();
cache_get_content_int(0, "Coloana", Test);
mysql_free_result();
In schimb asta e valid pentru ca are cache activ, cu cel putin 1 rezultat

(Evident tu ai alta functie de luat datele din cache, din pacate nu am lucrat niciodata cu mysql vechi asa ca nu stiu functiile dar princpiu e acelasi)

Aa, am inteles gata, am mai avut asemenea linii intr-un gm vechi si nu functionau pt. ca nu aveau un cache activ. Deci va trebui sa caut eu linia care este gresita, sper s-o gasesc, mersi.

Banditul · February 8, 2019

Acum 4 minute, 1Shot a spus:

Aa, am inteles gata, am mai avut asemenea linii intr-un gm vechi si nu functionau pt. ca nu aveau un cache activ. Deci va trebui sa caut eu linia care este gresita, sper s-o gasesc, mersi.

O metoda ar fi sa vezi unde se activeaza. Golesti log si te loghezi, verifici log si vezi daca apare, daca apare verifici tot ce tine de login etc. Cu case si restu la fel, stai cu ochii si vezi dupa ce anume apare

Edited February 8, 2019 by Banditul

czm · February 8, 2019

YCMD:setadmin(playerid, params[], help) {

new id, adminlevel, gString[120];

if(PlayerInfo[playerid][pAdmin] < 6)
return SCM(playerid, COLOR_WHITE, AdminOnly);

if(sscanf(params, "ui", id, adminlevel))
return SCM(playerid, COLOR_GREY, "USAGE: {FFFFFF}/setadmin <playerid/name> <Admin Level>");

if(!IsPlayerConnected(id) || id == INVALID_PLAYER_ID)
return SCM(playerid, COLOR_GREY, "Acel player nu este conectat.");

if(adminlevel < 0 || adminlevel > 6)
return SCM(playerid, COLOR_GREY, "Invalid admin level. 0-6");

if(PlayerInfo[id][pAdmin] > PlayerInfo[playerid][pAdmin])
return SCM(playerid, COLOR_GREY, "Nu poti folosi aceasta comanda pe acel player. Are admin level mai mare.");

format(gString, 80, "Ai fost promovat la admin %d de %s", adminlevel, GetName(playerid));
SCM(id, COLOR_LIGHTBLUE, gString);

format(gString, 100, "AdmCmd: %s i-a setat lui %s admin level %d.", GetName(playerid), GetName(id), adminlevel);
SendAdminHelperMessage(COLOR_LOGS, gString);

   if(adminlevel == 0) {
       PlayerInfo[id][pAW] = 0;
       UpdateVar(id, "AW", 0);
       SpecFaction[id] = 0;
       StopFly(playerid);
       UsedFly[playerid] = 0;
       SetPlayerHealthEx(playerid, 100);

Iter_Remove(PlayerAdmins, id);
}

Iter_Add(PlayerAdmins, id);

finishAchievement(id, 27);
PlayerInfo[id][pAdmin] = adminlevel;

new gQuery[180];

   if(adminlevel >= 1)
       format(gQuery, sizeof(gQuery), "UPDATE users SET `Admin`='%d', `HelpedPlayers`='0' WHERE `ID`='%d'", PlayerInfo[id][pAdmin]/*, MD5_Hash(DEFAULT_PASSWORD)*/, PlayerInfo[id][pSQLID]);
   else
       UpdateVar(id, "Admin", PlayerInfo[id][pAdmin]);
   mysql_tquery(SQL, gQuery, "", "");

return true;
}

1Shot · February 8, 2019

@Banditul

19:41:58] VIPHitman has logged in with IP 109.91.45.27 - Aici apare eroare aia cu getrowdatabyname()

Banditul · February 8, 2019

@1Shot Inseamna ca are legatura cu partea de login/incarcare a datelor referitoare la playeri

1Shot · February 9, 2019

12 hours ago, Banditul said:

@1Shot Inseamna ca are legatura cu partea de login/incarcare a datelor referitoare la playeri

@Banditul Ma poti ajuta cumva sa gasesc linia gresita te rog? Nu pot sa-mi dau seama...

buNNy · February 9, 2019

pune sus de tot sub

Spoiler

#define SERVER_VERSION "XXXXXXXX"

pune asta

Spoiler

#define SERVER_PASSWORD "01110010011ss001"

Si la comanda sa pui