Mysql selecting all players that have certain variable

Mysql selecting all players that have certain variable - 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: Mysql selecting all players that have certain variable (/showthread.php?tid=634307)

Mysql selecting all players that have certain variable - Saddin - 16.05.2017

I want to print all members from certain faction. This what I will post works but it prints only one player from database. I think callback CheckOrgPlayers isn't working properly.

PHP код:



YCMD:members(playerid, params[], help)

{

    #pragma unused help

    new string[50];


    if(PlayerInfo[playerid][pMember] < 1) return SendClientMessage(playerid, COLOR_ERROR, "You are not in faction.");


    new teamnumber;

    if(PlayerInfo[playerid][pMember] != 0) teamnumber = PlayerInfo[playerid][pMember];

    SendClientMessage(playerid, 0x00FF00FF, "List of faction members:");


    new DB_Query[250];

    mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `PLAYERS` WHERE `Member` = %d LIMIT 1", teamnumber);

    mysql_tquery(Database, DB_Query, "CheckOrgPlayers", "ii", playerid, teamnumber);

     

    return 1;

}

PHP код:



forward public CheckOrgPlayers(playerid, teamnumber);

public CheckOrgPlayers(playerid, teamnumber)

{

    if(cache_num_rows() > 0)

    {


        for(new i; i < cache_num_rows(); i++)

        {

            new string[50];

            new Nick[24], Rank, Status;

            cache_get_value(0, "Name", Nick, 24);

            cache_get_value_int(0, "Rank", Rank);

            cache_get_value_int(0, "LoggedIn", Status);


            if(Status == 0)

            {

                format(string, sizeof(string), "    %s (%d) OFFLINE", Nick, Rank);

                SendClientMessage(playerid, -1, string);

            }

            else if(Status == 1)

            {

                format(string, sizeof (string),"    %s (%d) ONLINE", Nick, Rank);

                SendClientMessage(playerid, -1, string);

            }


           

         }

  

    }    

    else

    {

        print("Couldn't find anything.");

    }

    return 1;

}

Re: Mysql selecting all players that have certain variable - Vince - 16.05.2017

Quote:

PHP код:



SELECT * FROM `PLAYERS` WHERE `Member` = %d LIMIT 1

Quote:

PHP код:



WHERE `Member` = %d LIMIT 1

Quote:

PHP код:



LIMIT 1

Yeah ...

Re: Mysql selecting all players that have certain variable - JaKe Elite - 16.05.2017

You have instructed the SQL to list one member of that faction only (LIMIT 1), Remove it.

Re: Mysql selecting all players that have certain variable - Saddin - 16.05.2017

Thanks, new to mysql so I make stupid mistakes...

Now command prints 3 times same Nick and same Rank. But I have at least 3 different player names that are in same faction.

Re: Mysql selecting all players that have certain variable - Saddin - 16.05.2017

Quote:

Originally Posted by Saddin

Thanks, new to mysql so I make stupid mistakes...

Now command prints 3 times same Nick and same Rank. But I have at least 3 different player names that are in same faction.

Fixed by putting "i" instead of "0" in :

PHP код:



            cache_get_value(0, "Name", Nick, 24); 

            cache_get_value_int(0, "Rank", Rank); 

            cache_get_value_int(0, "LoggedIn", Status);

PHP код:



            cache_get_value(i, "Name", Nick, 24); 

            cache_get_value_int(i, "Rank", Rank); 

            cache_get_value_int(i, "LoggedIn", Status);