format(query, sizeof(query), \"SELECT * FROM \'Players\' INNER JOIN \'Players2\' ON (\'Players\'.\'Name\' = \'Players2\'.\'Name\') WHERE \'Players\'.\'Name\' LIKE \'%s\' AND \'Players\'.\'IP\' LIKE \'%s\'\", Name(playerid), IP);

//a lekérdezés
mysql_function_query(1, query, true, \"THREAD_pelda\", \"SELECT `Adat1` FROM `Tabla1` WHERE `valami` = \'1\' UNION SELECT `Adat2` FROM `Tabla2` WHERE `valami` = \'2\'\");
//a visszatérés
forward THREAD_pelda();
public THREAD_pelda()
{
new string[128];
cache_get_row(0,0,string);
printf(\"Adat1: %s\",string);
cache_get_row(1,0,string);
printf(\"Adat2: %s\",string);
}

#include <a_samp>
#define MAX_CONNECTIONS_FROM_IP     3
stock GetNumberOfPlayersOnThisIP(test_ip[])
{
new against_ip[32+1];
new x = -1; // Javítva 0 playerid érték is vizsgálatra kerüljön.
new ip_count = 0;
for(; x++ < MAX_PLAYERS  {
if(IsPlayerConnected(x)) {
    GetPlayerIp(x,against_ip,32);
    if(!strcmp(against_ip,test_ip)) ip_count++;
}
}
return ip_count;
}
public OnPlayerConnect(playerid)
{
new connecting_ip[32+1];
GetPlayerIp(playerid,connecting_ip,32);
new num_players_on_ip = GetNumberOfPlayersOnThisIP(connecting_ip);
if(num_players_on_ip > MAX_CONNECTIONS_FROM_IP)
{
printf(\"MAXIPs: Connecting player(%d) exceeded %d IP connections from %s.\", playerid, MAX_CONNECTIONS_FROM_IP, connecting_ip);
    BanEx(playerid, \"BOT attack!\");
    new against_ip[32+1],test_ip[32+1];
    GetPlayerIp(playerid,test_ip,32);
new x = -1; // Javítva 0 playerid érték is vizsgálatra kerüljön.
for(; x++ < MAX_PLAYERS 
{
   if(IsPlayerConnected(x))
   {
       GetPlayerIp(x,against_ip,32);
       if(!strcmp(against_ip,test_ip)) Kick(x);
   }
}
 
     return 1;
}
return 0;
}