/* Plugin generated by AMXX-Studio */
//29.05.2008 v0.7 add batch process.
//28.05.2008 v0.6 any fix.
//25.04.2008 v0.5 fix connecting bug for windows.
//23.04.2008 v0.4 add cvar and errcode.
//22.04.2008 v0.3 cut some "public"
//20.04.2008 v0.2 single quotation in name no write bug fix.
//19.04.2008 v0.1 first release
#include <amxmodx>
#include <amxmisc>
#include <csx>
#include <sqlx>




new kills[32]

#define MAX_NAME_LENGTH 31
#define MAX_ERR_LENGTH 128
#define MAX_QUERY_LENGTH 1024
//Database setting pointers
new g_dbhost,g_dbuser,g_dbpass,g_dbname,g_tbname

//Database Handles
new Handle:g_dbt,Handle:g_dbc


public plugin_init() {
	register_plugin(PLUGIN, VERSION, AUTHOR)

	// Add your code here...
	new basedir[32]
	g_dbhost = register_cvar("amx_sql_host","127.0.0.1")
	g_dbuser = register_cvar("amx_sql_user","root")
	g_dbpass = register_cvar("amx_sql_pass","")
	g_dbname = register_cvar("amx_sql_db","cstrike")
	register_cvar("amx_sql_type","mysql")

  	get_configsdir(basedir, 31)
	formatex(basedir,31,"%s/sql.cfg",basedir)
  	server_cmd("exec %s",basedir)
	set_task(1.0,"plugin_core",0,"",0,"",0)
	return PLUGIN_HANDLED_MAIN
}

public plugin_core()
{
	new host[64],user[32],pass[32],db[32],error[MAX_ERR_LENGTH+1],ercode
 	get_pcvar_string(g_dbhost, host, 63)
  	get_pcvar_string(g_dbuser, user, 31)
  	get_pcvar_string(g_dbpass, pass, 31)
  	get_pcvar_string(g_dbname, db, 31)
	get_pcvar_string(g_tbname, g_ptbname,31)

	g_dbt = SQL_MakeDbTuple(host,user,pass,db)
	g_dbc = SQL_Connect(g_dbt,ercode,error,127)

	if(g_dbc == Empty_Handle)
	{
	    	server_print("[KNOXSTATS] Error No.%d: %s", ercode,error)
  	}else
	{
	  	server_print("[KNOXSTATS] Connecting successful.")
	  	init_database()
		//init_insert()
		//sql_disconnect()
  	}
	return PLUGIN_CONTINUE
}

public plugin_end()
{
	sql_disconnect()
}

public plugin_modules()
{
	require_module("mysql")}

sql_disconnect()
{
	SQL_FreeHandle(g_dbc)
	SQL_FreeHandle(g_dbt)
	server_print("[PSD] Closing connection...")
	return PLUGIN_CONTINUE
}



public client_disconnect(id)
{
	if(is_user_connected(id)) insert_data(id)
}
client_death(killer)
{

	kills + 1
}
insert_data(id)
{

	get_user_authid(id,authid,31)
	new Handle:result
	result = SQL_PrepareQuery(g_dbc, "INSERT INTO `%s` WHERE steamid = '%s'  (steamid,kills) values('%s' 't)", g_ptbname,authid,)
	if(!SQL_Execute(result))
	{
		result = SQL_PrepareQuery(g_dbc, "UPDATE `%s` SET name='%s',date=NOW(),score=%i,kills=%i,teamkills=%i,deaths=%i,hits=%i,shots=%i,headshots=%i,efficiency=%1.2f,accuracy=%1.2f, accuracyHS=%1.2f, kdrate=%1.2f WHERE authid='%s'", g_ptbname, sName, iScore, iKills, iTK, iDeaths, iHits, iShots, iHS, iEff, iAcc, iAccHS, iKdRate,sAuthid)
		SQL_Execute(result)
	}
	SQL_FreeHandle(result)
d}