Get members of clan - Printable Version

Get members of clan - 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: Get members of clan (/showthread.php?tid=612580)

Get members of clan - MRM - 19.07.2016

Hello.
How i get number of one field in table ?

PHP код:



format(query, sizeof(query), "SELECT * FROM users WHERE `clanname` = '%s'",player[playerid][cClanNamePlayer]);

mysql_function_query(1, query, true, "OnClansMemberLoad", "d", playerid);

Thanks.

Re: Get members of clan - Spenker - 19.07.2016

Код HTML:

forward OnClansMemberLoad(playerid);
public OnClansMemberLoad(playerid)
{
    if(cache_num_rows())
    {
        //MySQLCon = Your MYSQL connection.
        //pInfo[playerid][pUser] = String.
        cache_get_field_content(0, "NameUser", pInfo[playerid][pUser], MySQLCon, MAX_PLAYER_NAME);
    }
    return 1;
}

Re: Get members of clan - MRM - 19.07.2016

Quote:

Originally Posted by Spenker

Код HTML:

forward OnClansMemberLoad(playerid);
public OnClansMemberLoad(playerid)
{
    if(cache_num_rows())
    {
        //MySQLCon = Your MYSQL connection.
        //pInfo[playerid][pUser] = String.
        cache_get_field_content(0, "NameUser", pInfo[playerid][pUser], MySQLCon, MAX_PLAYER_NAME);
    }
    return 1;
}

How i printf number of members?Why isn't integer?

PHP код:



printf("number of members: %s",pInfo[playerid][pUser]);

This is true?

Re: Get members of clan - FrAnKiN1 - 19.07.2016

ofc not use %i or %d

Re: Get members of clan - MRM - 19.07.2016

This is string.

Re: Get members of clan - MRM - 20.07.2016

How i can get COUNT from mysql?

PHP код:



format(query, sizeof(query), "SELECT COUNT(`id`) FROM users WHERE `clanname` = '%s'",player[playerid][cClanNamePlayer]); 
mysql_function_query(1, query, true, "OnClansMemberLoad", "d", playerid);

Re: Get members of clan - Shinja - 30.07.2016

Bumb