mysql aka stuff - Printable Version

mysql aka stuff - 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 aka stuff (/showthread.php?tid=649995)

mysql aka stuff - wallen - 18.02.2018

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

Re: mysql aka stuff - solstice_ - 18.02.2018

PHP код:



//R41


new query[256];

mysql_format(Database, query, sizeof(query), "SELECT * FROM `PLAYERS` WHERE `IP` = '%s'"

mysql_tquery(Database, query);

Re: mysql aka stuff - wallen - 18.02.2018

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 ", ??

Re: mysql aka stuff - solstice_ - 18.02.2018

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);

Re: mysql aka stuff - wallen - 18.02.2018

Oh lol, i'll try

edit: and what do you should put on sendclientmessage ?

Re: mysql aka stuff - solstice_ - 18.02.2018

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?

Re: mysql aka stuff - wallen - 18.02.2018

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

Re: mysql aka stuff - solstice_ - 18.02.2018

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

Re: mysql aka stuff - wallen - 18.02.2018

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?

Re: mysql aka stuff - solstice_ - 18.02.2018

@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;

}