Dėl mysql DELETE

[Dedman]

Taigi esu padares komanda kai ją parašai ištrina gaują, bet ji neveikai gauja mysqle vistiek lieka

 

Visas KODAS:

	CMD::guzdaryti(playerid)
	{
		//if(gplayerDB[playerid][islead]) return 0;
		if(gplayerDB[playerid][islead] == false) return SendClientMessage(playerid, RED, "* Jūs ne gaujos lyderis!");
		new msg[128];
		format(msg,sizeof(msg),"Gauja \"%s\" uzdaryta.",gangDB[gplayerDB[playerid][pgang]][ganame]);
		SendClientMessage(playerid,RED,msg);
		gangDB[gplayerDB[playerid][pgang]][isgang]=false;
		new query[256];
		format(query,256,"SELECT * FROM Gaujos WHERE GangID = '%i'",gplayerDB[playerid][pgang]);
		mysql_query(query);
		mysql_store_result();
		if(mysql_num_rows() == 1)
		{
			format(query,256,"DELETE FROM Gaujos WHERE GangID = '%i'",gplayerDB[playerid][pgang]);
			mysql_query(query);
		}
		mysql_free_result();

		for(new player=0;player<MAX_PLAYERS; player++)
		{
			if(IsPlayerConnected(player) && gplayerDB[player][pgang] == gplayerDB[playerid][pgang] && player != playerid)
			{
				gplayerDB[player][pgang]=-1;
				SendClientMessage(playerid,RED,"* Jusu gauja buvo uzdaryta. Dabar jus nepriklausote jokiai gaujai.");
			}
		}
		format(query,256,"SELECT * FROM players WHERE Gang = '%i'",gplayerDB[playerid][pgang]);
		mysql_query(query);
		mysql_store_result();

		if(mysql_num_rows() >= 1)
		{
			format(query,256,"UPDATE players SET `Gang` = '%i' WHERE (`Gang` = '%i')",-1,gplayerDB[playerid][pgang]);
			mysql_query(query);
		}
		mysql_free_result();
		gplayerDB[playerid][pgang]=-1;
		gplayerDB[playerid][islead]=false;
		return 1;
	}

Sukonkretinus koda tai šita vieta:

		if(mysql_num_rows() == 1)
		{
			format(query,256,"DELETE FROM Gaujos WHERE GangID = '%i'",gplayerDB[playerid][pgang]);
			mysql_query(query);
		}
		mysql_free_result();

[bebras]

mysql log?

 

Būčiau kada nors atsakęs ir praeitoje temoje...

Redaguota Birželio 1, 2014, nario Justas Š.