MySQL Aka System
#5

Quote:
Originally Posted by Stinged
Посмотреть сообщение
If you want to get a player's IP:

Код:
SELECT `IP` FROM `users` WHERE `Name` = '%e'
NOTE: Everything in red can be different (depending on your table)

If you want to get all the names that share a certain IP:

Код:
SELECT `Name` FROM `users` WHERE `IP` = '%s'
All the names of the user, How do I withdraw ?

Код:
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;
}
Reply


Messages In This Thread
MySQL Aka System - by sampkinq - 26.08.2016, 17:42
Re: MySQL Aka System - by justjamie - 26.08.2016, 17:48
Re: MySQL Aka System - by DarkSkull - 26.08.2016, 17:51
Re: MySQL Aka System - by Stinged - 26.08.2016, 17:54
Re: MySQL Aka System - by sampkinq - 26.08.2016, 18:21
Re: MySQL Aka System - by Gammix - 26.08.2016, 19:06
Re: MySQL Aka System - by Stinged - 26.08.2016, 19:31
Re: MySQL Aka System - by Gammix - 26.08.2016, 19:33

Forum Jump:


Users browsing this thread: 1 Guest(s)