SA-MP Forums Archive
Why i get this error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Why i get this error (/showthread.php?tid=635064)


Why i get this error - StR_MaRy - 31.05.2017

Hey guys i try to make my faction sistem dynamic but i have a problem when i open the server

Pic's with my `factions` Structure: https://postimg.org/image/w75arx04x/

Error from mysql_log:
Код HTML:
[23:33:13 05/31/17] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('1') (Query: "SELECT * FROM `factions`")
Dynamicfactions:
Код HTML:
new factionss = 0;
enum Factions
{
	fID,
	fName[128],
	Float:fcX,
	Float:fcY,
	Float:fcZ,
	Float:fceX,
	Float:fceY,
	Float:fceZ,
	Float:fSafePos[3],
	fSafePickupID,
	Text3D:fSafeLabelID,
	fMats,
	fDrugs,
	fBank,
	fAnn[128],
	fWin,
	fLost,
	fMembers,
	fMaxMembers,
	fMinLevel,
	fApplication,
	fInterior,
	fVirtual,
	fMapIcon,
	fLocked,
	fPickupID,
	fPickupIDD,
	Text3D:fLabelID,
	fRankName1[64],
	fRankName2[64],
	fRankName3[64],
	fRankName4[64],
	fRankName5[64],
	fRankName6[64],
	fRankName7[64]
};
new DynamicFactions[100][Factions];
Load the `factions`:
Код HTML:
gQuery[0] = (EOS);
    mysql_format(handle, gQuery, sizeof(gQuery), "SELECT * FROM `factions`");
	mysql_tquery(handle, gQuery, "LoadDynamicFactions", "");
And the function:
Код HTML:
function LoadDynamicFactions()
{
	factionss = cache_num_rows();
	new id, string[30];
    for(new i = 0; i <= factionss; i++)
    {
		//new f = i - 1;
		cache_get_field_content(i, "ID", string);				DynamicFactions[id][fID] = strval(string);
		cache_get_field_content(i, "Name", string);				strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "X", string);				DynamicFactions[id][fcX] = strval(string);
		cache_get_field_content(i, "Y", string);				DynamicFactions[id][fcY] = strval(string);
		cache_get_field_content(i, "Z", string);				DynamicFactions[id][fcZ] = strval(string);
		cache_get_field_content(i, "eX", string);				DynamicFactions[id][fceX] = strval(string);
		cache_get_field_content(i, "eX", string);				DynamicFactions[id][fceY] = strval(string);
		cache_get_field_content(i, "eX", string);				DynamicFactions[id][fceZ] = strval(string);
		cache_get_field_content(i, "SafePos1", string);			DynamicFactions[id][fSafePos][0] = strval(string);
		cache_get_field_content(i, "SafePos2", string);			DynamicFactions[id][fSafePos][1] = strval(string);
		cache_get_field_content(i, "SafePos3", string);			DynamicFactions[id][fSafePos][2] = strval(string);
		cache_get_field_content(i, "Mats", string);				DynamicFactions[id][fMats] = strval(string);
		cache_get_field_content(i, "Interior", string);			DynamicFactions[id][fInterior] = strval(string);
		cache_get_field_content(i, "Virtual", string);			DynamicFactions[id][fVirtual] = strval(string);
		cache_get_field_content(i, "MapIcon", string);			DynamicFactions[id][fMapIcon] = strval(string);
		cache_get_field_content(i, "Locked", string);			DynamicFactions[id][fLocked] = strval(string);
		cache_get_field_content(i, "Drugs", string);			DynamicFactions[id][fDrugs] = strval(string);
		cache_get_field_content(i, "Bank", string);				DynamicFactions[id][fBank] = strval(string);
		cache_get_field_content(i, "PickupID", string);			DynamicFactions[id][fPickupID] = strval(string);
		cache_get_field_content(i, "Anunt", string);			DynamicFactions[id][fAnn] = strval(string);
		cache_get_field_content(i, "Win", string);				DynamicFactions[id][fWin] = strval(string);
		cache_get_field_content(i, "Lost", string);				DynamicFactions[id][fLost] = strval(string);
		cache_get_field_content(i, "MaxMembers", string);		DynamicFactions[id][fMaxMembers] = strval(string);
		cache_get_field_content(i, "MinLevel", string);			DynamicFactions[id][fMinLevel] = strval(string);
		cache_get_field_content(i, "Application", string);		DynamicFactions[id][fApplication] = strval(string);
		cache_get_field_content(i, "Rank1", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "Rank2", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "Rank3", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "Rank4", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "Rank5", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "Rank6", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
		cache_get_field_content(i, "Rank7", string);			strmid(DynamicFactions[id][fName], string, false, strlen(string), 32);
	return 1;
}
Any idea why? i get that error ?

Re: Why i get this error - NewFreeroamStunt - 31.05.2017

try this

PHP код:

stock LoadFaction()
{
mysql_function_query(handle, "SELECT ID,Name,X,Y,Z,eX,eX,eX,SafePos1,and etc FROM factions ORDER BY ID", true, "LoadDynamicFactions", "");
} 


Re: Why i get this error - Jefff - 31.05.2017

<= to <

Re: Why i get this error - StR_MaRy - 31.05.2017

Quote:
Originally Posted by Jefff
Посмотреть сообщение
<= to <
it worked but the problem is now when i use /factions i have 0 factions but i added 1 and it gives me like [0/0] instead of [0/0] Las Venturas PD

PIC: http://imgur.com/a/8n7B4

CMD:factions
Код HTML:
stock ShowFactions(playerid)
{
	new stringz2[160];
 	if(DynamicFactions[1][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", GetFactionMembers(1), DynamicFactions[1][fMaxMembers], DynamicFactions[1][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"{FFFFFF}[%d/%d] %s\n", GetFactionMembers(1), DynamicFactions[1][fMaxMembers], DynamicFactions[1][fName]);
	}
 	if(DynamicFactions[2][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(2), DynamicFactions[2][fMaxMembers], DynamicFactions[2][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(2), DynamicFactions[2][fMaxMembers], DynamicFactions[2][fName]);
	}
	if(DynamicFactions[3][fApplication] > 0)
	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(3), DynamicFactions[3][fMaxMembers], DynamicFactions[3][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(3), DynamicFactions[3][fMaxMembers], DynamicFactions[3][fName]);
	}
 	if(DynamicFactions[4][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(4), DynamicFactions[4][fMaxMembers], DynamicFactions[4][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(4), DynamicFactions[4][fMaxMembers], DynamicFactions[4][fName]);
	}
 	if(DynamicFactions[5][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(5), DynamicFactions[5][fMaxMembers], DynamicFactions[5][fName]);
	}
	else
	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(5), DynamicFactions[5][fMaxMembers], DynamicFactions[5][fName]);
	}
 	if(DynamicFactions[6][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(6), DynamicFactions[6][fMaxMembers], DynamicFactions[6][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(6), DynamicFactions[6][fMaxMembers], DynamicFactions[6][fName]);
	}
 	if(DynamicFactions[8][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(8), DynamicFactions[8][fMaxMembers], DynamicFactions[8][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(8), DynamicFactions[8][fMaxMembers], DynamicFactions[8][fName]);
	}
 	if(DynamicFactions[9][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(9), DynamicFactions[9][fMaxMembers], DynamicFactions[9][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(9), DynamicFactions[9][fMaxMembers], DynamicFactions[9][fName]);
	}
 	if(DynamicFactions[10][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(10), DynamicFactions[10][fMaxMembers], DynamicFactions[10][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(10), DynamicFactions[10][fMaxMembers], DynamicFactions[10][fName]);
	}
 	if(DynamicFactions[11][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(11), DynamicFactions[11][fMaxMembers], DynamicFactions[11][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(11), DynamicFactions[11][fMaxMembers], DynamicFactions[11][fName]);
	}
 	if(DynamicFactions[12][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(12), DynamicFactions[12][fMaxMembers], DynamicFactions[12][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(12), DynamicFactions[12][fMaxMembers], DynamicFactions[12][fName]);
	}
 	if(DynamicFactions[13][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]\n", stringz2, GetFactionMembers(13), DynamicFactions[13][fMaxMembers], DynamicFactions[13][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s\n", stringz2, GetFactionMembers(13), DynamicFactions[13][fMaxMembers], DynamicFactions[13][fName]);
	}
 	if(DynamicFactions[14][fApplication] > 0)
  	{
		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s {00FF00}[aplicatii deschise]", stringz2, GetFactionMembers(14), DynamicFactions[14][fMaxMembers], DynamicFactions[14][fName]);
	}
	else
	{
 		format(stringz2, sizeof(stringz2),"%s{FFFFFF}[%d/%d] %s", stringz2, GetFactionMembers(14), DynamicFactions[14][fMaxMembers], DynamicFactions[14][fName]);
	}
	ShowPlayerDialog(playerid, DIALOG_FACTIONS, DIALOG_STYLE_LIST,"Factions", stringz2, "Select", "Cancel");
	return 1;
}


Re: Why i get this error - Jefff - 01.06.2017

You need increase faction id in load, this variable new id, because now all is id 0

Re: Why i get this error - StR_MaRy - 01.06.2017

Quote:
Originally Posted by Jefff
Посмотреть сообщение
You need increase faction id in load, this variable new id, because now all is id 0
i changed from function loaddynamicfaction the string to 250 and for(new i = 1; i < factionss; i++) from 0 to 1 but still nothing and i deleted the new ad; and i added with i from for(new i = 1; i < factionss; i++)

i did something wrong ?

Re: Why i get this error - Vince - 01.06.2017

Row indices start at 0, just like arrays. If you have three rows then you have rows 0,1 and 2.

Re: Why i get this error - StR_MaRy - 01.06.2017

Quote:
Originally Posted by Vince
Посмотреть сообщение
Row indices start at 0, just like arrays. If you have three rows then you have rows 0,1 and 2.
i changed

Код HTML:
for(new i = 0; i < factionss; i++)
0 to 1 still nothing

Re: Why i get this error - JasonRiggs - 01.06.2017

Uhm, Can you show us how do you load the faction members number and setting the Max Members of the faction?

Re: Why i get this error - StR_MaRy - 01.06.2017

Quote:
Originally Posted by JasonRiggs
Посмотреть сообщение
Uhm, Can you show us how do you load the faction members number and setting the Max Members of the faction?
yea
Код HTML:
function GetFactionMembers(faction)
{
    gQuery[0] = (EOS);
	mysql_format(handle, gQuery, sizeof(gQuery), "SELECT `ID` FROM `players` WHERE `Member` = %d", faction);
 	new Cache:result = mysql_query(handle, gQuery);
	new number = cache_num_rows();
	cache_delete(result);
	return number;
}