#include <amxmodx>
#include <amxmisc>
#include <hamsandwich>
#include <sqlx>
#include <cstrike>
#include <fun>
new Handle:info, bool:connected;
new nazwa_gracza[33];
enum CVARS
{
host,
user,
pass,
db
};
new g_pCvars[CVARS];
new liczba[33];
public plugin_init()
{
register_plugin("TEST", "0.0.1", "Bl@ck");
g_pCvars[host] = register_cvar("host_sql", "xxx");
g_pCvars[user] = register_cvar("user_sql", "xxx", FCVAR_PROTECTED);
g_pCvars[pass] = register_cvar("password_sql", "xxx", FCVAR_PROTECTED);
g_pCvars[db] = register_cvar("database_sql", "xxx");
register_clcmd("say /test", "test");
}
public test(id) liczba[id]++
public client_putinserver(id){
get_user_name(id, nazwa_gracza, 32)
}
public plugin_cfg()
{
new szHost[64], szUser[64], szPass[64], szDB[64];
get_pcvar_string(g_pCvars[host], szHost, charsmax(szHost));
get_pcvar_string(g_pCvars[user], szUser, charsmax(szUser));
get_pcvar_string(g_pCvars[pass], szPass, charsmax(szPass));
get_pcvar_string(g_pCvars[db], szDB, charsmax(szDB));
info = SQL_MakeDbTuple(szHost, szUser, szPass, szDB);
new len_full, temp_full[2024];
len_full += formatex(temp_full[len_full], charsmax(temp_full)-len_full, "CREATE TABLE IF NOT EXISTS `TESTOWE` (`name` VARCHAR(48), `liczba` INT(10)");
SQL_ThreadQuery(info, "ConnectSql_Handler", temp_full);
}
public ConnectSql_Handler(failstate, Handle:query, error[], errnum, data[], size)
{
if(failstate != TQUERY_SUCCESS)
{
connected = false;
return PLUGIN_CONTINUE;
}
connected = true;
return PLUGIN_CONTINUE;
}