Quote:
Originally Posted by MadafakaPro
Cant get `players` his code
I am trying to count all members from the faction but it doesnt works
pawn Код:
new query [ 124 ];
format(query, sizeof(query), "SELECT Faction FROM players WHERE Faction = '%s'", PlayerInfo[playerid][playerteam]);
mysql_query(query);
mysql_store_result();
new rows = mysql_num_rows();
mysql_free_result();
and then iam using it like this
pawn Код:
format(iStr, sizeof(iStr), " F-Members: %d/%d", rows, dini_Int(tmpf,"fmemberslots"));
SendClientMessage(playerid, COLOR_WHITE, iStr);
But its displaying 0 while there are more then 3 members.
Whats wrong here? |
The query should be -
pawn Код:
SELECT * FROM `players` WHERE `Faction` = '%s'
As for the second problem, query size is insufficient. 47 characters for syntax plus 24 for player name and 1/2 for family ID - means, minimum size should be 73/74.
