Вниманию участников! Данный форум теперь является архивом и вскором времени здесь нельзя будет создавать новых тем! Просьба всем для общения и создания новых тем перейти на наш новый форум: http://amxmodx.su/

#include <amxmodx>  
#include <dbi>  

new Sql:dbc  
new Result:result // Start of plugin  

public plugin_init()  
{      

   register_plugin("gg","1.0","asdf")      
   register_cvar("amx_aca_host","127.0.0.1")      
   register_cvar("amx_aca_user","root")      
   register_cvar("amx_aca_pass","")      
   register_cvar("amx_aca_db","")      
   set_task(1.0,"start_sql")  

} //Create a connection  

public start_sql()  
{     
    new host[32], username[32], password[32], dbname[32], error[32]      
    get_cvar_string("amx_aca_host",host,32)      
    get_cvar_string("amx_aca_user",username,32)     
    get_cvar_string("amx_aca_pass",password,32)      
    get_cvar_string("amx_aca_db",dbname,32)      
    dbc = dbi_connect(host,username,password,dbname,error,32)      
    if (dbc == SQL_FAILED)      
    {          
          server_print("[ACA] Disconnected")      
    }      
    else      
    {         
          server_print("[ACA] Connected")      
    }      
    return PLUGIN_HANDLED;  
}

  //10 seconds after a user connnects send to look up IP  
public client_putinserver(id)  
{      
    set_task(10.0 , "LookUp" , id);  
}  

//Lookup user IP  

public LookUp(id)  
{      
       if(dbc <= SQL_FAILED)          
           return PLUGIN_HANDLED;      
       new player_ip[36]      
       get_user_ip(id, player_ip, 35)      
       dbi_query(dbc,"SELECT * FROM anticheat WHERE player_ip = '%s'", player_ip)      

       if(result >= RESULT_OK)     
       {         
            client_print(id,print_chat,"The IP are registered in DATA BASE")
     
       }     
       else      
       {          
            client_print(id,print_chat,"The IP are not registered in DATA BASE")     
       }      
       return PLUGIN_HANDLED;  
}  

//Close connection on end of map  
public plugin_end()  
{     if(dbc == SQL_OK)          
           dbi_close(dbc)  
}