#include <amxmodx>
#include <sqlx>
new Handle:g_sql_tuple;
public plugin_init()
{
register_plugin("test", "1", "RiviT")
set_task(1.0, "SQLverify")
}
public SQLverify()
{
if(!g_sql_tuple)
g_sql_tuple = SQL_MakeDbTuple("127.0.0.1", "root", "", "table_name");
new ip[32];
get_user_ip(0, ip, charsmax(ip), 0);
new query[128];
formatex(query, charsmax(query), "SELECT * FROM `verify` WHERE `ip_port` = '%s';", ip);
SQL_ThreadQuery(g_sql_tuple, "QueryAsk", query);
}
public QueryAsk(failstate, Handle:query, error[])
{
static er = 0;
if( failstate == TQUERY_CONNECT_FAILED || failstate == TQUERY_QUERY_FAILED )
{
if(++er <= 3)
{
set_task(3.0, "SQLverify")
log_amx("Count error: %i | %s", er, error);
return;
}
}
else
{
if(SQL_NumResults(query))
{
log_amx("prawidlowe ip")
SQL_FreeHandle(g_sql_tuple);
return;
}
}
set_fail_state("PLUGIN NIE DZIALA NA TYM SERWERZE")
SQL_FreeHandle(g_sql_tuple);
}