26.08.2016, 18:21
Quote:
|
If you want to get a player's IP:
Код:
SELECT `IP` FROM `users` WHERE `Name` = '%e' If you want to get all the names that share a certain IP: Код:
SELECT `Name` FROM `users` WHERE `IP` = '%s' |
Код:
CMD:aka(playerid,params[])
{
new isim[24];
if(sscanf(params, "s[24]", isim)) return SendClientMessage(playerid, -1, "{D324FF}Kullanım: {FFFFFF}/Aka (IP)");
new query[128];
mysql_format(g_SQL, query, sizeof(query), "SELECT `Isim` FROM `oyuncudata` WHERE `IPAdress` = '%s'", isim);
mysql_tquery(g_SQL, query, "AkaCek", "ds", playerid,isim);
return 1;
}
function:AkaCek(playerid, ip_adress[])
{
new rows, fields;
cache_get_data(rows, fields);
if(rows)
{
for(new i = 0; i < rows; ++i)
{
new isim[24];
cache_get_field_content(i, "Isim", isim);
printf("%s\n",isim);
}
}
else
{
SendClientMessage(playerid, ERROR_COLOR_HD, "yok.");
}
return 1;
}


