PHP Code:
#include <amxmodx>
#include <sqlx>
new Handle:g_sql;
new const restrict_msg[] = "Desculpe, mas voce deve estar registrado para entrar no servidor!";
public plugin_init()
{
register_plugin("kick_unreg", "1.0", "Radiance");
}
public plugin_cfg()
{
new host[32];
new user[32];
new pass[32];
new dtbe[32];
new error[128];
new errcode;
get_cvar_string("amx_sql_host", host, sizeof (host));
get_cvar_string("amx_sql_user", user, sizeof (user));
get_cvar_string("amx_sql_pass", pass, sizeof (pass));
get_cvar_string("amx_sql_db", dtbe, sizeof (dtbe));
new Handle:tpl = SQL_MakeDbTuple(host, user, pass, dtbe);
g_sql = SQL_Connect(tpl, errcode, error, sizeof (error));
if (g_sql == Empty_Handle)
{
pause("a");
}
else
{
server_print("[kick_unreg.amxx] Plugin successfully connected.");
}
}
public client_authorized(id)
{
new auth[32];
get_user_authid(id, auth, sizeof (auth));
new Handle:query = SQL_PrepareQuery(g_sql, "SELECT `yourcolumn` FROM `yourtable` WHERE `yourcolum` = '%s'", auth);
SQL_Execute(query);
new res[32];
if (SQL_MoreResults(query))
{
SQL_ReadResult(query, 0, res, sizeof (res));
SQL_FreeHandle(query);
}
if (!strlen(res))
{
server_cmd("kick #%i %s", get_user_userid(id), restrict_msg);
}
}