#include <amxmodx>
#include <geoip>
#include <sqlx>
#define g_isPlugin "Custom Player Informer"
#define g_isVersion "1.2 Pre-release"
#define g_isAuthors "kreedzru"
new Handle:g_SqlTuple;
new g_SqlHost[64], g_SqlUser[32], g_SqlPassword[32], g_SqlDatabase[64];
new g_SqlErrors[512];
new g_CPIEnabled,
g_CPILogConsole,
g_CPILogFile,
g_CPIShowIpAdress,
g_CPIShowSteamId,
g_CPIClientCountry;
public plugin_init()
{
register_plugin(g_isPlugin, g_isVersion, g_isAuthors);
register_dictionary("custom_player_informer.txt");
register_cvar("cpi_enabled", "1", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_log_console", "1", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_log_file", "1", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_show_ip", "1", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_show_steamid", "1", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_show_country", "1", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_sqlhost", "localhost", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_sqluser", "username", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_sqlpass", "password", FCVAR_SPONLY | FCVAR_UNLOGGED);
register_cvar("cpi_dbname", "dbname", FCVAR_SPONLY | FCVAR_UNLOGGED);
AutoExecConfig(true, "custom_player_informer");
log_amx("[Custom Player Informer] Plugin is initialized // kreedzru");
}
public plugin_cfg()
{
LoadSettings();
LoadMySQLSettings();
ConnectToMySQL(g_SqlHost, g_SqlUser, g_SqlPassword, g_SqlDatabase);
dbTableCreate();
}
LoadSettings()
{
g_CPIEnabled = get_cvar_num("cpi_enabled");
g_CPILogConsole = get_cvar_num("cpi_log_console");
g_CPILogFile = get_cvar_num("cpi_log_file");
g_CPIShowIpAdress = get_cvar_num("cpi_show_ip");
g_CPIShowSteamId = get_cvar_num("cpi_show_steamid");
g_CPIClientCountry = get_cvar_num("cpi_show_country");
log_amx("[Custom Player Informer] Настройки плагина загружены.");
}
LoadMySQLSettings() {
get_cvar_string("cpi_sqlhost", g_SqlHost, charsmax(g_SqlHost));
get_cvar_string("cpi_sqluser", g_SqlUser, charsmax(g_SqlUser));
get_cvar_string("cpi_sqlpass", g_SqlPassword, charsmax(g_SqlPassword));
get_cvar_string("cpi_dbname", g_SqlDatabase, charsmax(g_SqlDatabase));
}
ConnectToMySQL(const g_SqlHost[], const g_SqlUser[], const g_SqlPassword[], const g_SqlDatabase[], timeout = 0) {
g_SqlTuple = SQL_MakeDbTuple(g_SqlHost, g_SqlUser, g_SqlPassword, g_SqlDatabase, timeout);
new errcode;
new Handle:SqlConnection = SQL_Connect(g_SqlTuple, errcode, g_SqlErrors, charsmax(g_SqlErrors));
if (SqlConnection == Empty_Handle) {
log_amx("[Custom Player Informer] Ошибка при подключении к MySQL: %s", g_SqlErrors);
return;
}
log_amx("[Custom Player Informer] Успешное подключение к MySQL.");
SQL_FreeHandle(SqlConnection);
}
public client_putinserver(id)
{
if(!g_CPIEnabled) {
return;
}
new szName[32], szIp[16], szSteamId[35], szCountry[3], iUserid;
new szTime[16];
get_user_name(id, szName, charsmax(szName));
get_user_ip(id, szIp, charsmax(szIp), 1);
iUserid = get_user_userid(id);
get_user_authid(id, szSteamId, charsmax(szSteamId));
geoip_code2_ex(szIp, szCountry);
get_time("%H:%M:%S", szTime, charsmax(szTime));
new szLogMsg[256], iLen;
iLen = formatex(szLogMsg, charsmax(szLogMsg), "[Custom Player Informer] Player: %s, Time: %s", szName, szTime);
if(g_CPIShowIpAdress) {
iLen += formatex(szLogMsg[iLen], charsmax(szLogMsg) - iLen, " || IP: %s", szIp);
}
if(g_CPIShowSteamId) {
iLen += formatex(szLogMsg[iLen], charsmax(szLogMsg) - iLen, " || SteamID: %s", szSteamId);
}
if(g_CPIClientCountry) {
iLen += formatex(szLogMsg[iLen], charsmax(szLogMsg) - iLen, " || Country: %s", szCountry);
}
formatex(szLogMsg[iLen], charsmax(szLogMsg) - iLen, " || UserID: %d", iUserid);
if(g_CPILogConsole && !g_CPILogFile)
log_amx(szLogMsg);
if(g_CPILogFile)
{
new szFileName[64];
get_time("CustomPlayerInformer_%Y-%m-%d.log", szFileName, charsmax(szFileName));
log_to_file(szFileName, szLogMsg);
}
client_print(0, print_chat, "%L", LANG_PLAYER, "CPI_CONNECT", szName, szTime, szIp, szSteamId, szCountry, iUserid);
iSaveDataPlayer(id);
}
public Empty_Handler(FailState, Handle:Query, Error[], ErrCode, Data[], DataSize)
{
if (FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
{
log_amx("[Custom Player Informer] SQL Error: %s", Error);
}
}
dbTableCreate() {
new errcode;
new Handle:SqlConnection = SQL_Connect(g_SqlTuple, errcode, g_SqlErrors, charsmax(g_SqlErrors));
if (SqlConnection == Empty_Handle) {
log_amx("[Custom Player Informer] Ошибка подключения к MySQL: %s", g_SqlErrors);
return;
}
new iQuery[512];
formatex(iQuery, charsmax(iQuery),
"CREATE TABLE IF NOT EXISTS `cpi_players` ( \
`id` INT AUTO_INCREMENT PRIMARY KEY, \
`name` VARCHAR(64) NOT NULL, \
`ip` VARCHAR(16) NOT NULL, \
`steamid` VARCHAR(35) NOT NULL, \
`country` VARCHAR(3) NOT NULL, \
`userid` INT NOT NULL, \
`connect_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP \
);")
if (!SQL_ThreadQuery(g_SqlTuple, "Empty_Handler", iQuery)) {
SQL_QueryError(SqlConnection, g_SqlErrors, charsmax(g_SqlErrors));
log_amx("[Custom Player Informer] Ошибка при создании таблицы: %s", g_SqlErrors);
}
SQL_FreeHandle(SqlConnection);
}
iSaveDataPlayer(id) {
new szName[32], szIp[16], szSteamId[35], szCountry[3], iUserid;
get_user_name(id, szName, charsmax(szName));
get_user_ip(id, szIp, charsmax(szIp), 1);
iUserid = get_user_userid(id);
get_user_authid(id, szSteamId, charsmax(szSteamId));
geoip_code2_ex(szIp, szCountry);
new iQuery[512];
formatex(iQuery, charsmax(iQuery),
"INSERT INTO `cpi_players` (`name`, `ip`, `steamid`, `country`, `userid`) \
VALUES ('%s', '%s', '%s', '%s', '%d');",
szName, szIp, szSteamId, szCountry, iUserid);
SQL_ThreadQuery(g_SqlTuple, "Empty_Handler", iQuery);
}
