Problema sistem /mdc

[Rayan]

Salut, incerc sa fac un sistem de MDC insa cand folosesc comanda /mdc nu apar crimele comise, de ce? cand folosesc /su merge se insereaza in baza de date toate datele necesare, insa nu stiu de ce NU merge sa arate mdc

 

https://pastebin.com/hKVyct7F

 

Cine stie poate posta aici, ii voi fi recunoscator!

Edited September 11, 2017 by Rayan

[matthew.]

CMD:mdc(playerid, params[])
{
	if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid, COLOR_LIGHTRED, "You need to log in first.");
	if(IsPlayerConnected(playerid))
	{
		if(IsACop(playerid))
		{
			new id;
			if(sscanf(params, "u", id)) return SCM(playerid, -1, "Syntax: /mdc [playerid]");
			if(IsPlayerConnected(id))
			{
				if(PlayerInfo[id][pWantedLevel]) {
					format(gString, sizeof(gString), "-- MDC [ID %d - %s][{FFFF00}W:%d{FFFFFF}][Chased by %d cops][Wanted expires in %d mins]",id, GetName(id), PlayerInfo[id][pWantedLevel], cased[id], wantedlost[id]/60+1);
					MDCapper(playerid, id);
				}
				else if(!PlayerInfo[id][pWantedLevel]){
					format(gString, sizeof(gString), "-- MDC [ID %d - %s][not wanted]",id, GetName(id));
				}
			}
			else return SCM(playerid, -1, "Acest jucator nu este conectat.");
		}
		else return SCM(playerid, -1, "You are not a cop!");
	}
	return 1;
}

stock MDCapper(playerid, id)
{
	new string[256], motiv[100], declare[MAX_PLAYER_NAME];
	format(gString, sizeof gString, "SELECT * FROM `crimes` WHERE `id` = '%d'", PlayerInfo[id][pSQLID]);
	new Cache: mdcc = mysql_query(SQL, gString);
	for(new x; x < cache_num_rows(); ++x)
	{
		cache_get_field_content(x, "declare", declare);
		cache_get_field_content(x, "motiv", motiv);
		format(string, sizeof(string), "%s - by %s", motiv, declare);
		SCM(playerid, -1, string);
	}
	cache_delete(mdcc);
}

stock SetPlayerCriminal(playerid, declare, motiv[])
{
    new string[256];
	if(declare != INVALID_PLAYERID)
	{
		if(IsPlayerConnected(declare) format(string, sizeof(string), "%s", GetName(declare));
	}

	mysql_format(SQL, gString, sizeof gString, "INSERT INTO `crimes` (`playerid`, `motiv`, `declare`) VALUES ('%d', '%s', '%s')", PlayerInfo[playerid][pSQLID], motiv, string);
	mysql_pquery(SQL, gString, "", "");
}

 

[Rayan]

Acum 15 minute, webby a spus:

 

E ok, merge, insa am o problema, cand dau /mdc arata doar prima crima cu ID 1. de ce nu le arata pe toate?

https://gyazo.com/3301878b7587ab9bec9c2f274e28d289

https://gyazo.com/14080cd6d0a8b9dd3f2141e73546ec47

Edited September 11, 2017 by Rayan

[matthew.]

cum este definit id-ul crimei, in gamemode?

[Rayan]

Acum 28 minute, webby a spus:

cum este definit id-ul crimei, in gamemode?

crima e 'motiv' vad ca acum se insereaza problema e ca daca dau /su [nume] [wanted] [motiv] se creeaza in baza de date daca ID e primar (cheie) si daca e primar nu merge sa inserez mai multe, adica nu se insereaza daca ii dau /su de mai multe ori la jucator. Daca nu e primar 'id' se insereaza cu acelasi id, gen inloc sa puna id la tabel 1,2,3,4 pune 0,0,0 (doar daca id nu e primar, daca e primar se insereaza doar odata 0 si atat, 1,2,3 nu se mai insereaza)

 

mysql_format(SQL, gString, sizeof gString, "INSERT INTO `crimes` (`playerid`, `motiv`, `declare`) VALUES ('%d', '%s', '%s')", PlayerInfo[playerid][pSQLID], motiv, declare);
    mysql_pquery(SQL, gString, "", "");

Edited September 11, 2017 by Rayan

[matthew.]

format(gString, sizeof gString, "SELECT * FROM `crimes` WHERE `id` = '%d'", PlayerInfo[id][pSQLID]);

Aici iti ia id-ul jucatorului, nu id-ul crimei.

[Rayan]

Acum 4 minute, webby a spus:

format(gString, sizeof gString, "SELECT * FROM `crimes` WHERE `id` = '%d'", PlayerInfo[id][pSQLID]);

Aici iti ia id-ul jucatorului, nu id-ul crimei.

done am modificat cu format(gString, sizeof gString, "SELECT * FROM `mdc` WHERE `playerid` = '%d' ORDER BY `id`", PlayerInfo[id][pSQLID]);  si la fel problema de mai sus persista.

----

crima e 'motiv' vad ca acum se insereaza problema e ca daca dau /su [nume] [wanted] [motiv] se creeaza in baza de date daca ID e primar (cheie) si daca e primar nu merge sa inserez mai multe, adica nu se insereaza daca ii dau /su de mai multe ori la jucator. Daca nu e primar 'id' se insereaza cu acelasi id, gen inloc sa puna id la tabel 1,2,3,4 pune 0,0,0 (doar daca id nu e primar, daca e primar se insereaza doar odata 0 si atat, 1,2,3 nu se mai insereaza)

 

mysql_format(SQL, gString, sizeof gString, "INSERT INTO `crimes` (`playerid`, `motiv`, `declare`) VALUES ('%d', '%s', '%s')", PlayerInfo[playerid][pSQLID], motiv, declare);
    mysql_pquery(SQL, gString, "", "");

[matthew.]

Incearca sa explici mai concis, te rog.

[AddisoN]

Acum 9 ore, Rayan a spus:

done am modificat cu format(gString, sizeof gString, "SELECT * FROM `mdc` WHERE `playerid` = '%d' ORDER BY `id`", PlayerInfo[id][pSQLID]);  si la fel problema de mai sus persista.

----

crima e 'motiv' vad ca acum se insereaza problema e ca daca dau /su [nume] [wanted] [motiv] se creeaza in baza de date daca ID e primar (cheie) si daca e primar nu merge sa inserez mai multe, adica nu se insereaza daca ii dau /su de mai multe ori la jucator. Daca nu e primar 'id' se insereaza cu acelasi id, gen inloc sa puna id la tabel 1,2,3,4 pune 0,0,0 (doar daca id nu e primar, daca e primar se insereaza doar odata 0 si atat, 1,2,3 nu se mai insereaza)

 

mysql_format(SQL, gString, sizeof gString, "INSERT INTO `crimes` (`playerid`, `motiv`, `declare`) VALUES ('%d', '%s', '%s')", PlayerInfo[playerid][pSQLID], motiv, declare);
    mysql_pquery(SQL, gString, "", "");

ai pus campul id auto-increment? daca nu punel asa si o sa puna 1,2,3,4 s.a.m.d

 

[Rayan]

Multumesc, solved