#include <amxmodx>
#include <amxmisc>
#include <fakemeta>
#include <sqlx>

#pragma semicolon 1

#define PLUGIN "SQLx Login"
#define SITE "ArenaMIXPug.net"

new Handle:g_SqlTuple;
new Query[512];

public plugin_init(){

	register_plugin(PLUGIN,AMXX_VERSION_STR,"Thales");
	register_forward(FM_ClientUserInfoChanged, "Fwd_ClientInfoChanged");


}

public plugin_cfg() g_SqlTuple = SQL_MakeStdTuple();

public client_authorized(Client)
{
	if(is_user_hltv(Client)) return PLUGIN_HANDLED;

	new SteamID[32];
	get_user_authid(Client,SteamID,charsmax(SteamID));

	new Data[1];
	Data[0] = Client;

	formatex(Query,charsmax(Query),"SELECT * FROM `arenamix_members` WHERE `gamer_steam` = '%s'",SteamID);
	SQL_ThreadQuery(g_SqlTuple,"AutenticarSteamID",Query,Data,1);

	return PLUGIN_HANDLED;
}

public AutenticarSteamID(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
	static Client;
	Client = Data[0];

	new SteamID[32];
	get_user_authid(Client,SteamID,charsmax(SteamID));

	if(FailState == TQUERY_CONNECT_FAILED)
	{
		server_print("[%s] Conexao ao mySQL falhou! (Revise os dados de Login)",PLUGIN);
		server_cmd("kick #%d ^"Erro na DB, contate: %s^"",get_user_userid(Client),SITE);
		return PLUGIN_HANDLED;
	}
	else if(FailState == TQUERY_QUERY_FAILED)
	{
		server_print("[%s] Query falhou! (Revise as tabelas do mySQL)",PLUGIN);
		server_cmd("kick #%d ^"Erro na DB, contate1: %s^"",get_user_userid(Client),SITE);
		return PLUGIN_HANDLED;
	}
	if(Errcode)
	{
		server_print("[%s] Querry falhou! (%s)",PLUGIN,Errcode);
		server_cmd("kick #%d ^"Erro na DB, contate2: %s^"",get_user_userid(Client),SITE);
		return PLUGIN_HANDLED;
	}
	if(!SQL_MoreResults(Query))
	{
		server_print("[%s] SteamID nao encontrada: (%s)",PLUGIN,SteamID);
		server_cmd("kick #%d ^"Cadastre-se: %s^"",get_user_userid(Client),SITE);
		return PLUGIN_HANDLED;
	}
	else
	{
		new RealName[36],UserName[36];
		get_user_name(Client,UserName,charsmax(UserName));

		SQL_ReadResult(Query,SQL_FieldNameToNum(Query,"real_name"),RealName,charsmax(RealName));

		if(!equal(RealName,UserName))
		{
			client_cmd(Client,"name ^"%s^"",RealName);
			return PLUGIN_HANDLED;
		}
	}
	SQL_FreeHandle(Query);
	return PLUGIN_HANDLED;
}
public Fwd_ClientInfoChanged(id, buffer)
	{
		if (!is_user_connected(id))
		return FMRES_IGNORED;
		new Realname[33][33]
		static val[32];
		static RealName[33];
		get_user_name(id, RealName, charsmax(RealName));

		engfunc(EngFunc_InfoKeyValue, buffer, "RealName", val, sizeof val - 1);

		if(equal(val, RealName))
		return FMRES_IGNORED;

		engfunc(EngFunc_SetClientKeyValue, id, buffer, "name", RealName);

		client_cmd(id, "name ^"%s^";setinfo name ^"%s^"",RealName,RealName);



		return FMRES_SUPERCEDE;
}
public plugin_end() SQL_FreeHandle(g_SqlTuple);