#include <amxmodx>
#include <sqlx>

#define PLUGIN "Connect to database"
#define VERSION "1.0"
#define AUTHOR "CocaCola"

//new bool:grenade_launcher[33];
new Handle:g_SqlTuple;
new g_Cache[512];

new tc_sql_host
new tc_sql_user
new tc_sql_pass
new tc_sql_db

public plugin_init() {
	register_plugin(PLUGIN, VERSION, AUTHOR)
	// Start of database Stuff
	tc_sql_host = register_cvar("tc_sql_host", "64.182.255.3");
	tc_sql_user = register_cvar("tc_sql_user", "schnups_test");
	tc_sql_pass = register_cvar("tc_sql_pass", "nopwforyoupurple)");
	tc_sql_db = register_cvar("tc_sql_db", "schnups_testing");
	// End of database Stuff
}

public plugin_cfg(){
	new host[52]
	get_pcvar_string(tc_sql_host,host,51)
	new user[52]
	get_pcvar_string(tc_sql_user,user,51)
	new pass[52]
	get_pcvar_string(tc_sql_pass,pass,51)
	new db[52]
	get_pcvar_string(tc_sql_db,db,51)


	g_SqlTuple = SQL_MakeDbTuple(host,user,pass,db)
	copy(g_Cache,511,"CREATE TABLE IF NOT EXISTS weapons (steamid var(33),knife INT(11),hegrenade INT(11))")
	SQL_ThreadQuery(g_SqlTuple,"TableHandle",g_Cache)
}

public TableHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize){
	// lots of error checking
	if(FailState == TQUERY_CONNECT_FAILED)
		return set_fail_state("Could not connect to SQL database.")
	else if(FailState == TQUERY_QUERY_FAILED)
		return set_fail_state("Query failed.")
	if(Errcode)
		return log_amx("Error on query: %s",Error)
	SQL_ThreadQuery(g_SqlTuple,"QueryHandle","INSERT INTO zomg VALUES('1','2','3','4')")
	SQL_ThreadQuery(g_SqlTuple,"QueryHandle","INSERT INTO zomg VALUES('4','3','2','1')")
	return PLUGIN_CONTINUE
}

public client_authorized(iClient)
{


}