[wallen]

Well, i was wondering i know that to check the player's aka with his ip i should type on mysql query something like that

PHP код:

"SELECT * FROM `PLAYERS` WHERE `IP` = '%s'" 


but i don't actually understand how do i make it inside a command, do i need to make an enum? do i need to make a forward/public functions or whatever ? lol

[solstice_]

PHP код:

//R41
new query[256];
mysql_format(Database, query, sizeof(query), "SELECT * FROM `PLAYERS` WHERE `IP` = '%s'"
mysql_tquery(Database, query); 


[wallen]

Quote:

Originally Posted by willbedie PHP код: //R41 new query[256]; mysql_format(Database, query, sizeof(query), "SELECT * FROM `PLAYERS` WHERE `IP` = '%s'"

Exactly, i've already made if it was that easy look at that command

PHP код:

CMD:whois(playerid, params[])
{
    if(connected[playerid] == true) return GameTextForPlayer(playerid, "~r~Spawn First", 5000, 5);
    if(pInfo[playerid][Admin] < 3) return SendClientMessage(playerid, -1, "{C3C3C3}(INFO) You don't have the priviliges to use this command.");
    {
            new str[500], target, ip[16], country[32], isp[32], city[32];
            if(sscanf(params, "u", target)) return SendClientMessage(playerid, -1, "{c3c3c3}(INFO) /whois [id]");
            GetPlayerIp(target, ip, 16);
            GetIPCountry(ip, country, sizeof country);
            GetIPISP(ip, isp, sizeof isp);
            GetIPCity(ip, city, sizeof city);
            GetPlayerIp(target,ip,sizeof(ip));
            format(str, sizeof(str), "{EFB509}(INFO) %s's ip is ''%s'' connected from ''%s''", PlayerName[target], ip[target], country[target]);
               SendClientMessage(playerid, -1, str);
             mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM `PLAYERS` WHERE `IP` = '%s'", bla bla what to put);
              format(str, sizeof(str), "{EFB509}(INFO) %s is also known as: %s", blabla what to put);
    }
    return 1;
} 


Just to understand better what do you put after ", ??

[solstice_]

PHP код:

new query[256], IPAddress[60];
GetPlayerIp(playerid, IPAddress, sizeof(IPAddress));
mysql_format(Database, query, sizeof(query), "SELECT * FROM `PLAYERS` WHERE (`IP` = '%s')", IPAddress);
mysql_tquery(Database, query); 


[wallen]

Oh lol, i'll try

edit: and what do you should put on sendclientmessage ?

[solstice_]

Quote:

Originally Posted by wallen Oh lol, i'll try edit: and what do you should put on sendclientmessage ?

Do you want to send the ip as a message to a player?

[wallen]

Quote:

Originally Posted by willbedie Do you want to send the ip as a message to a player?

I only want to show all the nickname's used by a certain player

[solstice_]

Quote:

Originally Posted by wallen I only want to show all the nickname's used by a certain player

PHP код:

format(string, sizeof(string), "%s", pIpAddress);
SendClientMessage(playerid, -1, string); 


You can simply use string for that

[wallen]

Quote:

Originally Posted by willbedie PHP код: format(string, sizeof(string), "%s", pIpAddress); SendClientMessage(playerid, -1, string);  You can simply use string for that

But from what i read it's supposed to view only IP numbers, while i want the nickname or just i dont understand?

[solstice_]

@wallen, you can try the code below, it's untested though.

PHP код:

stock GetIP(playerid)
{
    new allplayerip[33],
    playerip[33],
    count = 0;
    GetPlayerIp(playerid, playersip, sizeof(playersip));
    for(new i=0; i<MAX_PLAYERS; i++)
    {
        if(IsPlayerConnected(i) && !IsPlayerNPC(i) && i != playerid)
        {
            GetPlayerIp(i, allplayerip, playersip, true) == 0) count++;
        }
    }
    return count;
}