Pagalbos del mysql užkrovimo

[Dedman]

Neužkrauna pavadinimo ir lyderio.Viskas atrodo lyg ir gerai

 

KODAS:

stock LoadGaujos(gangid)
{
	new query[256], fetch[20];
	format(query, 256, "SELECT * FROM Gaujos WHERE GangID = '%d'",gangid);
	mysql_query(query);
	mysql_store_result();
	if(mysql_num_rows() == 1)
	{
	    mysql_fetch_row(fetch);
	    mysql_fetch_field_row(fetch, "Leader"); gangDB[gangid][leader] = strval(fetch);
		mysql_fetch_field_row(fetch, "Name"); gangDB[gangid][ganame] = strval(fetch);
		gangDB[gangid][isgang]=true;
		mysql_fetch_field_row(fetch, "Nariai"); gangDB[gangid][members] = strval(fetch);
		mysql_fetch_field_row(fetch, "Pinigai"); gangDB[gangid][fondolt] = strval(fetch);
		printf("Uzkrauta gauja su ID: %i, pavadinimu %s ir vadu %s.",gangid,gangDB[gangid][ganame],gangDB[gangid][leader]);
	}
	mysql_free_result();
}
stock PrepareGangs()
{
	print("Kraunamos gaujos...");
	for(new id=0; id<MAX_GANGS+1; id++)
	{
		LoadGaujos(id);
	}
	print("Gaujos užkrautos.");
}

Ka rodo logas:

[16:32:34] Sėkmingai prisijungta prie MySQL bazės.
[16:32:34] Kraunamos gaujos...
[16:32:34] Uzkrauta gauja su ID: 0, pavadinimu  ir vadu .
[16:32:34] Uzkrauta gauja su ID: 1, pavadinimu  ir vadu .
[16:32:34] Gaujos užkrautos.

[bebras]

Viską čia užkrauna. 

 

Parodyk tą "gangDB" enum'ą....

[Dedman]

enum giitem

{

ganame[128],

leader[MAX_PLAYER_NAME],

leader2[MAX_PLAYER_NAME],

members,

fondolt,

bool:invited[MAX_PLAYERS],

bool:isgang

}

new gangDB[MAX_GANGS][giitem];

[bebras]

Tai "ganame" ir "leader" yra string? Kodėl naudoji strval kuris gražian int?

if(mysql_num_rows() == 1)
	{
	    mysql_fetch_row(fetch);
	    mysql_fetch_field_row(gangDB[gangid][leader], "Leader");
		mysql_fetch_field_row(gangDB[gangid][ganame], "Name");
		gangDB[gangid][isgang]=true;
		mysql_fetch_field_row(fetch, "Nariai"); gangDB[gangid][members] = strval(fetch);
		mysql_fetch_field_row(fetch, "Pinigai"); gangDB[gangid][fondolt] = strval(fetch);
		printf("Uzkrauta gauja su ID: %i, pavadinimu %s ir vadu %s.",gangid,gangDB[gangid][ganame],gangDB[gangid][leader]);
	}

Pažiūrėk kaip atrodys dabar, nes gali dar neveikti.

[Dedman]

jo padėjo ir dar yra problema neištrinta mysql duomenu šita komanda:

	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;
	}