maksgolubovskiy
Участник
- Сообщения
- 118
- Реакции
- 13
- Баллы
- 18
Так же хотелось бы узнать, можно ли отключить переменную cms_gag_time_for_info
- Исходный код
- Код:
#include <amxmodx> #include <amxmisc> #include <sqlx> #include <gamecms5> #include <time> new const PLUGIN[] = "GameCMS GagManager"; new const VERSION[] = "2.2.3"; new const AUTHOR[] = "zhorzh78"; #define REAPI #if defined REAPI #include <reapi> #define VTC_OnClientStartSpeak(iSender) VTC_OnClientStartSpeak(const iSender) #define VTC_OnClientStopSpeak(iSender) VTC_OnClientStopSpeak(const iSender) #define FMRES_IGNORED HC_CONTINUE #define FMRES_SUPERCEDE HC_SUPERCEDE #else #include <VtcApi> #include <hamsandwich> #include <fakemeta> #include <engine> new const g_szSpamEntClassname[] = "SpamEntClassname"; #endif #define GetBit(%1,%2) ((%1) & (1 << (%2 & 31))) #define SetBit(%1,%2) ((%1) |= (1 << (%2 & 31))) #define ResetBit(%1,%2) ((%1) &= ~(1 << (%2 & 31))) #define IsEnemy(%1,%2) (g_iPlayerTeam[%1] != g_iPlayerTeam[%2]) #define IsPlayerMuted(%1,%2) (GetBit(g_bitPlayerMuted[%1], %2)) #define MENU_DATA_LENGTH 8 #define MENU_ITEM_LENGTH 100 #define MAX_REASON_LENGTH 100 #define TIME_NOT_EXPIRING 0 #define TIME_MAP_END_EXPIRING -1 #define EMPTY_DATA -2 #define MENU_TIME 't' #define MENU_REASON 'r' #define MENU_REASON_SELF 's' #define MENU_TYPE 'b' #define MENU_PLAYERS 'p' #define MENU_ITEM_BLOCK_ADD 'a' #define MENU_ITEM_BLOCK_REMOVE 'd' #define MAX_CHAT_MSG_LENGTH 190 #define STATIC_ITEM_HANDLER -4 #define STATIC_ITEM_POSITION 6 #define MAX_IMMUNITY_LEVELS 5 #define MAX_IMMUNITY_LEVEL_LEN 5 #define MAX_BLOCK_TYPES 3 enum _:BlockInfo { GBid, GBlockType, GExpired, GAdminId, GCreated, GBlockTime, GAuthId[MAX_AUTHID_LENGTH], GName[MAX_NAME_LENGTH], GBlockReason[MAX_REASON_LENGTH], GAdminNick[MAX_NAME_LENGTH], GModifiedBy[MAX_NAME_LENGTH], bool:GModifiedBlocked, GTargetID }; enum _:eReasonData { REASON_TEXT[MAX_REASON_LENGTH], REASON_TIME, REASON_TYPE }; new const sqlTable[] = "comms"; new const g_szSoundFilePath[] = "../valve/sound/buttons/blip2.wav"; new Trie:g_trhWhiteListCmdArray, Trie:g_trhBlockedUsers; new Array:g_arhBlockTime, Array:g_arhBlockReasons; new Handle:g_hSqlHandle; new szQuery[MAX_QUERY_SMALL_LEN*2], plBlockInfo[MAX_PLAYERS+1][BlockInfo], g_szPlayerMuteType[MAX_PLAYERS + 1]; new g_bitPlayerMuted[MAX_PLAYERS+1], CsTeams:g_iPlayerTeam[MAX_PLAYERS+1], bool:g_isAlivePlayer[MAX_PLAYERS+1], g_iImmunLevel[MAX_PLAYERS+1]; new g_szBlockType[MAX_BLOCK_TYPES][MAX_NAME_LENGTH], g_bitAccessLvl[MAX_IMMUNITY_LEVELS]; new g_iEntSpamChecker[MAX_PLAYERS+1], Float:g_flPlayerSpamTimer[MAX_PLAYERS+1]; new g_bitBlockedVoice, g_bitBlockedChat, g_bitBlockedFully, g_bitUseTeamVoice; new g_iTimeMenu, g_iReasonMenuId, g_iTypeMenu, g_iStaticMenuCallback; new g_iAddTime, g_iAddLastId, g_iMenuAccessNull, g_iImmunLevelsNum; new g_bitApiAllow, g_iCmdGagMenu, g_iServerId, bool:g_bRoundEnd; new cpTime, cpImmunityLvl, cpWhiteCmds, cpDeadAdmTalk, cpAmxShowActivity, cpAllTalk, cpBlockVoiceSpam; new cv_iDeadAdmTalk, cv_iAllTalk, cv_iBlockSpam, cv_iMuteTypeChoose, Float:cv_flBlockSpamTimer, Float:cv_flTimeForInfo; public plugin_init() { register_plugin(PLUGIN, VERSION, AUTHOR); register_cvar("gamecms_gagmanager", VERSION, FCVAR_SERVER); register_dictionary("time.txt"); register_dictionary("common.txt"); register_dictionary("gamecms_gagmanager.txt"); register_clcmd("say /mute", "MuteMenu"); register_clcmd("say_team /mute", "MuteMenu"); register_clcmd("+teamvoice", "CmdTeamVoiceOn"); register_clcmd("-teamvoice", "CmdTeamVoiceOff"); register_clcmd("say", "HookSayChat"); register_clcmd("say_team", "HookSayChat"); #if defined _reapi_included RegisterHookChain(RG_CBasePlayer_Spawn, "CBasePlayerSpawn", true); RegisterHookChain(RG_CBasePlayer_Killed, "CBasePlayerKilled", true); RegisterHookChain(RG_CSGameRules_CanPlayerHearPlayer, "CanPlayerHearPlayer", false); RegisterHookChain(RG_CSGameRules_RestartRound, "Rlog_Round_Start", true); RegisterHookChain(RG_RoundEnd, "Rlog_Round_End", true); #else RegisterHam(Ham_Spawn, "player", "CBasePlayerSpawn", true); RegisterHam(Ham_Killed, "player", "CBasePlayerKilled", true); register_forward(FM_Voice_SetClientListening, "CanPlayerHearPlayer", false); register_logevent("Rlog_Round_End", 2, "1=Round_End"); register_logevent("Rlog_Round_Start", 2, "1=Round_Start"); #endif cpTime = register_cvar("cms_gag_time", "-1, 10, 60, 1440, 0"); cpImmunityLvl = register_cvar("cms_gag_immunity_lvl", "a, b, c, d"); cpWhiteCmds = register_cvar("cms_gag_whitecmds", ""); cpDeadAdmTalk = register_cvar("cms_gag_deadadmtalk", "0"); cpBlockVoiceSpam = register_cvar("cms_gag_block_voice_spam", "1"); new cpBlockSpamTimer = register_cvar("cms_gag_block_spam_timer", "10.0"); new cpMuteTypeChoose = register_cvar("cms_gag_mute_type_choose", "0"); cpAmxShowActivity = get_cvar_pointer("amx_show_activity"); cpAllTalk = get_cvar_pointer("sv_alltalk"); hook_cvar_change(cpAllTalk, "HookCvarChanged"); bind_pcvar_float(register_cvar("cms_gag_time_for_info", "0.0"), cv_flTimeForInfo); g_trhBlockedUsers = TrieCreate(); g_trhWhiteListCmdArray = TrieCreate(); g_arhBlockTime = ArrayCreate(); FnReasonMenuCreate(); new configsFile[MAX_NAME_LENGTH*2]; get_configsdir(configsFile, charsmax(configsFile)); format(configsFile, charsmax(configsFile), "%s/gamecms/gamecms_gagmanager.cfg", configsFile); server_cmd("exec %s", configsFile); server_exec(); cv_iMuteTypeChoose = get_pcvar_num(cpMuteTypeChoose); cv_flBlockSpamTimer = get_pcvar_float(cpBlockSpamTimer); if(cv_iMuteTypeChoose) register_message(get_user_msgid("SayText"), "MessageSayText"); new tmpCvarStr[MAX_FMT_LENGTH]; if(get_pcvar_string(cpImmunityLvl, tmpCvarStr, charsmax(tmpCvarStr))) { new tmpOut[MAX_IMMUNITY_LEVELS][MAX_IMMUNITY_LEVEL_LEN]; g_iImmunLevelsNum = explode_string(tmpCvarStr, ",", tmpOut, sizeof(tmpOut), sizeof(tmpOut[])); if(!g_iImmunLevelsNum) return; else if(g_iImmunLevelsNum > MAX_IMMUNITY_LEVELS) g_iImmunLevelsNum = MAX_IMMUNITY_LEVELS; for(new i; i < g_iImmunLevelsNum; i++) { trim(tmpOut[i]); g_bitAccessLvl[i] = read_flags(tmpOut[i]); } new iMenuFlag = g_bitAccessLvl[1]; g_iCmdGagMenu = register_clcmd("amx_gagmenu", "AdminPlayersMenu", iMenuFlag, "", 1); register_clcmd("say /gag", "AdminPlayersMenu", iMenuFlag, "", 1); } } public plugin_precache() { if(file_exists(g_szSoundFilePath)) precache_sound(g_szSoundFilePath); } public Rlog_Round_End() { g_bRoundEnd = true; } public Rlog_Round_Start() { g_bRoundEnd = false; } public OnConfigsExecuted() { new tmpCvarStr[512]; if(get_pcvar_string(cpTime, tmpCvarStr, charsmax(tmpCvarStr))) CvarsToArray(g_arhBlockTime, tmpCvarStr, ',', "t"); if(get_pcvar_string(cpWhiteCmds, tmpCvarStr, charsmax(tmpCvarStr))) CvarsToArray(g_trhWhiteListCmdArray, tmpCvarStr, ',', "c"); cv_iDeadAdmTalk = get_pcvar_num(cpDeadAdmTalk); cv_iAllTalk = get_pcvar_num(cpAllTalk); cv_iBlockSpam = get_pcvar_num(cpBlockVoiceSpam); if(cv_iBlockSpam != BLOCK_STATUS_NONE && cv_flBlockSpamTimer > 0.0) { for(new iClient = 1; iClient <= MaxClients; iClient++) { #if defined _reapi_included g_iEntSpamChecker[iClient] = rg_create_entity("info_target", true); } #else g_iEntSpamChecker[iClient] = create_entity("info_target"); if(g_iEntSpamChecker[iClient]) { entity_set_string(g_iEntSpamChecker[iClient], EV_SZ_classname, g_szSpamEntClassname); entity_set_edict(g_iEntSpamChecker[iClient], EV_ENT_owner, iClient); } } register_think(g_szSpamEntClassname, "SpamEntThinkCallback"); #endif } FnCreateStaticMenu(); } FnReasonMenuCreate() { register_concmd("cms_gag_reason", "CmdAddGagReason"); g_arhBlockReasons = ArrayCreate(eReasonData); g_iStaticMenuCallback = menu_makecallback("StaticMenuCallback"); g_iReasonMenuId = menu_create(fmt("%L", LANG_PLAYER, "CMSGAG_MENU_REASON_HEADER"), "StaticMenuHandler"); menu_additem(g_iReasonMenuId, fmt("%L", LANG_PLAYER, "CMSGAG_MENU_REASON_CUSTOM"), "rs"); menu_setprop(g_iReasonMenuId, MPROP_EXITNAME, fmt("%L", LANG_PLAYER, "EXIT")); } public HookCvarChanged(pcvar, const old_value[], const new_value[]) { if(pcvar == cpAllTalk) cv_iAllTalk = str_to_num(new_value); } public CmdAddGagReason(id, level, cid) { if(!cmd_access(id, g_bitAccessLvl[1], cid, 0)) return PLUGIN_HANDLED; new szReason[MENU_ITEM_LENGTH]; read_args(szReason, charsmax(szReason)); if(szReason[0]) { new szReasonInfo[eReasonData]; if(!id) { new iItems, szTime[MENU_DATA_LENGTH], szType[MENU_DATA_LENGTH]; iItems = parse(szReason, szReasonInfo[REASON_TEXT], charsmax(szReasonInfo), szTime, charsmax(szTime), szType, charsmax(szType)); if(iItems > 1) { szReasonInfo[REASON_TIME] = szTime[0] ? str_to_num(szTime) : EMPTY_DATA; switch(szType[0]) { case 'a': szReasonInfo[REASON_TYPE] = BLOCK_STATUS_ALL; case 'c': szReasonInfo[REASON_TYPE] = BLOCK_STATUS_CHAT; case 'v': szReasonInfo[REASON_TYPE] = BLOCK_STATUS_VOICE; default: szReasonInfo[REASON_TYPE] = EMPTY_DATA; } } else szReasonInfo[REASON_TIME] = szReasonInfo[REASON_TYPE] = EMPTY_DATA; ArrayPushArray(g_arhBlockReasons, szReasonInfo, sizeof(szReasonInfo)); } else { remove_quotes(szReason); trim(szReason); copy(plBlockInfo[id][GBlockReason], charsmax(plBlockInfo[]), szReason); return plBlockInfo[id][GCreated] ? GagInfoMenu(id) : menu_display(id, g_iTimeMenu, 0); } } else menu_display(id, g_iReasonMenuId, 0); return PLUGIN_HANDLED; } public OnAPIPluginLoaded(Handle:sqlTuple) { g_hSqlHandle = sqlTuple; g_bitApiAllow |= UseGameCms; g_iServerId = cmsapi_get_server_id(); SQL_SetCharset(g_hSqlHandle, "utf8"); if(get_playersnum()) { new szAuthid[MAX_AUTHID_LENGTH]; for(new i = 1; i <= MaxClients; i++) { if(!is_user_connected(i)) continue; get_user_authid(i, szAuthid, charsmax(szAuthid)); FnClientConnected(i, szAuthid); } } } public OnAPIAdminsLoaded() g_bitApiAllow |= UseGameCmsAdmins; public FnCreateStaticMenu() { new iSize = ArraySize(g_arhBlockReasons); new szReasonInfo[eReasonData]; for(new i; i < iSize; i++) { ArrayGetArray(g_arhBlockReasons, i, szReasonInfo, sizeof(szReasonInfo)); if(szReasonInfo[REASON_TIME] != EMPTY_DATA) format(szReasonInfo[REASON_TEXT], charsmax(szReasonInfo[REASON_TEXT]), "%s \y[%s]", szReasonInfo[REASON_TEXT], FormatBlockTime(szReasonInfo[REASON_TIME], 1, timeunit_minutes)); if(szReasonInfo[REASON_TYPE] != EMPTY_DATA) format(szReasonInfo[REASON_TEXT], charsmax(szReasonInfo[REASON_TEXT]), "%s \y[%L]", szReasonInfo[REASON_TEXT], LANG_PLAYER, fmt("CMSGAG_BLOCK_TYPE_%d", szReasonInfo[REASON_TYPE])); menu_additem(g_iReasonMenuId, szReasonInfo[REASON_TEXT], "r", 0, g_iStaticMenuCallback); } g_iTimeMenu = menu_create(fmt("%L", LANG_PLAYER, "CMSGAG_MENU_TIME_HEADER"), "StaticMenuHandler", 1); iSize = ArraySize(g_arhBlockTime); for (new i = 0; i < iSize; ++i) menu_additem(g_iTimeMenu, FormatBlockTime(ArrayGetCell(g_arhBlockTime, i), 1, timeunit_minutes), "t", 0, g_iStaticMenuCallback); menu_setprop(g_iTimeMenu, MPROP_EXITNAME, fmt("%L", LANG_PLAYER, "EXIT")); g_iTypeMenu = menu_create(fmt("%L", LANG_PLAYER, "CMSGAG_MENU_TYPE_HEADER"), "StaticMenuHandler", 1); for (new i = 0; i < MAX_BLOCK_TYPES; ++i) { formatex(g_szBlockType[i], charsmax(g_szBlockType[]), "%L", LANG_PLAYER, fmt("CMSGAG_BLOCK_TYPE_%d", i)); menu_additem(g_iTypeMenu, g_szBlockType[i], "b", 0, g_iStaticMenuCallback); } menu_setprop(g_iTypeMenu, MPROP_EXITNAME, fmt("%L", LANG_PLAYER, "EXIT")); } public StaticMenuCallback(id, menu, item) { new szData[MENU_DATA_LENGTH], szName[MENU_ITEM_LENGTH]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szData, charsmax(szData), szName, charsmax(szName)); new itemStatus; switch(szData[0]) { case MENU_TIME: { new iTime = ArrayGetCell(g_arhBlockTime, item); itemStatus = (iTime == plBlockInfo[id][GBlockTime] && plBlockInfo[id][GCreated]) || !g_bitApiAllow && (iTime > get_timeleft()/60 || iTime == TIME_NOT_EXPIRING) ? ITEM_DISABLED : ITEM_IGNORE; } case MENU_REASON: itemStatus = strcmp(szName, plBlockInfo[id][GBlockReason]) == 0 ? ITEM_DISABLED : ITEM_IGNORE; case MENU_TYPE: itemStatus = item == plBlockInfo[id][GBlockType] && plBlockInfo[id][GCreated] ? ITEM_DISABLED : ITEM_IGNORE; } return itemStatus; } public StaticMenuHandler(id, menu, item) { if(item == MENU_EXIT) { if(plBlockInfo[id][GCreated]) GagInfoMenu(id); else arrayset(plBlockInfo[id], 0, BlockInfo); return PLUGIN_HANDLED; } new szData[MENU_DATA_LENGTH], szName[MENU_ITEM_LENGTH]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szData, charsmax(szData), szName, charsmax(szName)); switch(szData[0]) { case MENU_TIME: { plBlockInfo[id][GBlockTime] = ArrayGetCell(g_arhBlockTime, item); if(plBlockInfo[id][GCreated]) { GagInfoMenu(id); return PLUGIN_HANDLED; } if(plBlockInfo[id][GBlockType] == EMPTY_DATA) menu_display(id, g_iTypeMenu, 0); else GagInfoMenu(id); } case MENU_REASON: { switch(szData[1]) { case MENU_REASON_SELF: { client_cmd(id,"messagemode cms_gag_reason"); return PLUGIN_HANDLED; } default: { new szReasonInfo[eReasonData]; ArrayGetArray(g_arhBlockReasons, item - 1, szReasonInfo, sizeof(szReasonInfo)); copy(plBlockInfo[id][GBlockReason], charsmax(plBlockInfo[]), szReasonInfo[REASON_TEXT]); if(plBlockInfo[id][GCreated]) { GagInfoMenu(id); return PLUGIN_HANDLED; } plBlockInfo[id][GBlockTime] = szReasonInfo[REASON_TIME]; plBlockInfo[id][GBlockType] = szReasonInfo[REASON_TYPE]; if(plBlockInfo[id][GBlockTime] == EMPTY_DATA) menu_display(id, g_iTimeMenu, 0); else if(plBlockInfo[id][GBlockType] == EMPTY_DATA) menu_display(id, g_iTypeMenu, 0); else GagInfoMenu(id); } } } case MENU_TYPE: { plBlockInfo[id][GBlockType] = item; GagInfoMenu(id); } } return PLUGIN_HANDLED; } public AdminPlayersMenu(id) { if(!cmd_access(id, g_bitAccessLvl[1], g_iCmdGagMenu, 0)) return PLUGIN_HANDLED; arrayset(plBlockInfo[id], 0, BlockInfo); static iAdminMenuCallback; if(!iAdminMenuCallback) iAdminMenuCallback = menu_makecallback("AdminPlayersMenuCallback"); new iPlayersMenu = menu_create(fmt("%L", LANG_PLAYER, "CMSGAG_MENU_BLOCK_HEADER"), "AdminPlayersMenuHandler"); new iTargetClient, szFmtName[MENU_ITEM_LENGTH], szPlayersIds[MAX_PLAYERS], iPlayersCount; get_players_ex(szPlayersIds, iPlayersCount, (GetPlayers_ExcludeBots | GetPlayers_ExcludeHLTV)); for (new i; i < iPlayersCount; i++) { iTargetClient = szPlayersIds[i]; if(id == iTargetClient) continue; if(cmsgag_is_user_blocked(iTargetClient) != BLOCK_STATUS_NONE) formatex(szFmtName, charsmax(szFmtName), "\w%n %L", iTargetClient, LANG_PLAYER, "CMSGAG_ITEM_PLAYER_BLOCKED"); else formatex(szFmtName, charsmax(szFmtName), "\w%n", iTargetClient); menu_additem(iPlayersMenu, szFmtName, fmt("%d", iTargetClient), 0, iAdminMenuCallback); } menu_setprop(iPlayersMenu, MPROP_BACKNAME, fmt("%L", LANG_PLAYER, "BACK")); menu_setprop(iPlayersMenu, MPROP_NEXTNAME, fmt("%L", LANG_PLAYER, "MORE")); menu_setprop(iPlayersMenu, MPROP_EXITNAME, fmt("%L", LANG_PLAYER, "EXIT")); menu_display(id, iPlayersMenu, 0); return PLUGIN_HANDLED; } public AdminPlayersMenuCallback(id, menu, item) { new szPlayerId[MENU_DATA_LENGTH]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szPlayerId, charsmax(szPlayerId)); return FnAboveImmunity(id, str_to_num(szPlayerId)) ? ITEM_ENABLED : ITEM_DISABLED; } public AdminPlayersMenuHandler(id, menu, item) { if(item == MENU_EXIT) { menu_destroy(menu); return PLUGIN_HANDLED; } new szPlayerId[MENU_DATA_LENGTH]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szPlayerId, charsmax(szPlayerId)); plBlockInfo[id][GTargetID] = str_to_num(szPlayerId); menu_destroy(menu); get_user_name(plBlockInfo[id][GTargetID], plBlockInfo[id][GName], charsmax(plBlockInfo[])); get_user_authid(plBlockInfo[id][GTargetID], plBlockInfo[id][GAuthId], charsmax(plBlockInfo[])); new iBlockOwner; if(g_bitApiAllow & UseGameCmsAdmins) iBlockOwner = cmsapi_get_admin_ident(id); if(!TrieGetArray(g_trhBlockedUsers, plBlockInfo[id][GAuthId], plBlockInfo[id], charsmax(plBlockInfo[]))) { plBlockInfo[id][GAdminId] = iBlockOwner; menu_display(id, g_iReasonMenuId, 0); return PLUGIN_HANDLED; } if(g_bitApiAllow & UseGameCmsAdmins) { #if !defined API54 new iAdminId = plBlockInfo[id][GAdminId]; if(iAdminId != iBlockOwner) { new Trie:trhAdminInfo = cmsapi_get_admin_info(iAdminId); if(trhAdminInfo) { new adminData[AdminInfo]; TrieGetArray(trhAdminInfo, fmt("%d", iAdminId), adminData, sizeof adminData); plBlockInfo[id][GModifiedBlocked] = FnAboveImmunity(get_user_flags(id), read_flags(adminData[AdminServiceFlags]), true) ? false : true; //TrieDestroy(trhAdminInfo); } } #else if(plBlockInfo[id][GAdminId] != iBlockOwner) { new adminData[AdminInfo]; if(cmsapi_get_info_by_admin_id(plBlockInfo[id][GAdminId], adminData)) plBlockInfo[id][GModifiedBlocked] = FnAboveImmunity(get_user_flags(id), read_flags(adminData[AdminServiceFlags]), true) ? false : true; } #endif } GagInfoMenu(id); return PLUGIN_HANDLED; } public GagInfoMenu(id) { new tmpName[MENU_ITEM_LENGTH]; new tmpTypeNum = plBlockInfo[id][GBlockType]; new iGagInfoMenu = menu_create(fmt("%L", LANG_PLAYER, "CMSGAG_MENU_INFO_HEADER"), "GagInfoMenuHandler"); static iGagInfoMenuCallback; if(!iGagInfoMenuCallback) iGagInfoMenuCallback = menu_makecallback("GagInfoMenuCallback"); new bool:existKey = TrieKeyExists(g_trhBlockedUsers, plBlockInfo[id][GAuthId]); /*if(!plBlockInfo[id][GCreated]) plBlockInfo[id][GCreated] = get_systime(); */ if(existKey) formatex(tmpName, charsmax(tmpName), "%L %s %L", LANG_PLAYER,"CMSGAG_ITEM_PLAYER_INFO_NAME", plBlockInfo[id][GName], LANG_PLAYER,"CMSGAG_ITEM_PLAYER_BLOCKED"); else formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER,"CMSGAG_ITEM_PLAYER_INFO_NAME", plBlockInfo[id][GName]); menu_additem(iGagInfoMenu, tmpName, "p", 0); formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_TIME", FormatBlockTime(plBlockInfo[id][GBlockTime], 1, timeunit_minutes)); menu_additem(iGagInfoMenu, tmpName, "t", 0, iGagInfoMenuCallback); formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_REASON", plBlockInfo[id][GBlockReason]); menu_additem(iGagInfoMenu, tmpName, "r", 0, iGagInfoMenuCallback); formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_TYPE", g_szBlockType[tmpTypeNum]); menu_additem(iGagInfoMenu, tmpName, "b", 0, iGagInfoMenuCallback); if(existKey) { static iTime; iTime = plBlockInfo[id][GExpired] > 0 ? (plBlockInfo[id][GExpired] - get_systime())/60 : plBlockInfo[id][GExpired]; formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_EXPIRED", FormatBlockTime(iTime, 2, timeunit_minutes)); menu_addtext(iGagInfoMenu, tmpName, 0); } if(strlen(plBlockInfo[id][GAdminNick])) { formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_ADMIN_1", plBlockInfo[id][GAdminNick]); menu_addtext(iGagInfoMenu, tmpName, 0); } if(strlen(plBlockInfo[id][GModifiedBy])) { formatex(tmpName, charsmax(tmpName), "%L %s", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_ADMIN_2", plBlockInfo[id][GModifiedBy]); menu_addtext(iGagInfoMenu, tmpName, 0); } menu_addblank2(iGagInfoMenu); menu_additem(iGagInfoMenu, fmt("%L", LANG_PLAYER, existKey ? "CMSGAG_ITEM_PLAYER_INFO_SAVE" : "CMSGAG_ITEM_PLAYER_INFO_SET"), "a", 0, iGagInfoMenuCallback); if(existKey) menu_additem(iGagInfoMenu, fmt("%L", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_REMOVE"), "d", 0, iGagInfoMenuCallback); menu_setprop(iGagInfoMenu, MPROP_EXITNAME, fmt("%L", LANG_PLAYER, "EXIT")); menu_setprop(iGagInfoMenu, MPROP_EXIT, MEXIT_ALL); menu_display(id, iGagInfoMenu, 0); return PLUGIN_HANDLED; } public GagInfoMenuCallback(id, menu, item) { return (plBlockInfo[id][GModifiedBlocked]/* || cmsgag_is_user_blocked(id) != BLOCK_STATUS_NONE*/) ? ITEM_DISABLED : ITEM_ENABLED; } public GagInfoMenuHandler(id, menu, item) { if(item == MENU_EXIT) { arrayset(plBlockInfo[id], 0, BlockInfo); } else { if(!plBlockInfo[id][GCreated]) plBlockInfo[id][GCreated] = get_systime(); new szData[MENU_DATA_LENGTH]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szData, charsmax(szData)); switch(szData[0]) { case MENU_TIME: menu_display(id, g_iTimeMenu, 0); case MENU_REASON: menu_display(id, g_iReasonMenuId, 0); case MENU_TYPE: menu_display(id, g_iTypeMenu, 0); case MENU_PLAYERS: AdminPlayersMenu(id); case MENU_ITEM_BLOCK_ADD: BlockQueryFunc(id, BLOCK_FUNC_ADD); case MENU_ITEM_BLOCK_REMOVE: BlockQueryFunc(id, BLOCK_FUNC_REMOVE); } } menu_destroy(menu); return PLUGIN_HANDLED; } public MuteMenu(id) { static g_iMuteMenuCB; if(!g_iMuteMenuCB) g_iMuteMenuCB = menu_makecallback("MuteMenuCallback"); new iMuteMenu = menu_create(fmt("%L", LANG_PLAYER, "CMSGAG_MENU_MUTE_HEADER"), "MuteMenuHandler", 1); new szPlayersIds[MAX_PLAYERS], iPlayersCount; get_players_ex(szPlayersIds, iPlayersCount, (GetPlayers_ExcludeBots | GetPlayers_ExcludeHLTV)); for(new i; i < iPlayersCount; i++) { if(cv_iMuteTypeChoose) menu_additem_static(iMuteMenu, "", fmt("%d", szPlayersIds[i]), i, iPlayersCount-1, true, 0, g_iMuteMenuCB); else menu_additem(iMuteMenu, "", fmt("%d", szPlayersIds[i]), 0, g_iMuteMenuCB); } menu_setprop(iMuteMenu, MPROP_BACKNAME, fmt("%L", LANG_PLAYER, "BACK")); menu_setprop(iMuteMenu, MPROP_NEXTNAME, fmt("%L", LANG_PLAYER, "MORE")); menu_setprop(iMuteMenu, MPROP_EXITNAME, fmt("%L", LANG_PLAYER, "EXIT")); menu_display(id, iMuteMenu, 0); return PLUGIN_HANDLED; } stock menu_additem_static(iMenu, itemName[], itemInfo[], index, lastItemPos, bool:shift = true, paccess = 0, iMenuCallback = -1) { new staticItem = index % STATIC_ITEM_POSITION; menu_additem(iMenu, itemName, itemInfo, paccess, iMenuCallback); if(index == lastItemPos) { if(shift) { new addBlank = STATIC_ITEM_POSITION - staticItem - 1; for(new i; i < addBlank; i++) menu_addblank2(iMenu); } staticItem = STATIC_ITEM_POSITION - 1; } if(staticItem == STATIC_ITEM_POSITION - 1) { if(shift) menu_addblank(iMenu, 0); menu_additem(iMenu, "", fmt("%d", STATIC_ITEM_HANDLER), paccess, iMenuCallback); } } public MuteMenuCallback(id, menu, item) { new szPlayerId[MENU_DATA_LENGTH], iTargetClient, szFmtName[MAX_NAME_LENGTH*2]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szPlayerId, charsmax(szPlayerId)); static iItemStatus; iItemStatus = ITEM_IGNORE; iTargetClient = str_to_num(szPlayerId); if(iTargetClient != STATIC_ITEM_HANDLER && is_user_connected(iTargetClient)) { formatex(szFmtName, charsmax(szFmtName), "\w%n", iTargetClient); if(iTargetClient == id) iItemStatus = ITEM_DISABLED; else if(GetBit(g_bitBlockedFully, iTargetClient)) { format(szFmtName, charsmax(szFmtName), "%s %L", szFmtName, LANG_PLAYER, "CMSGAG_ITEM_BLOCKED_BY_ADMIN"); iItemStatus = ITEM_DISABLED; } else if(IsPlayerMuted(id, iTargetClient)) format(szFmtName, charsmax(szFmtName), "%s %L", szFmtName, LANG_PLAYER, "CMSGAG_ITEM_PLAYER_MUTED"); } else { formatex(szFmtName, charsmax(szFmtName), "%L %L", LANG_PLAYER, "CMSGAG_ITEM_PLAYER_INFO_TYPE", LANG_PLAYER, fmt("CMSGAG_BLOCK_TYPE_%d", g_szPlayerMuteType[id])); } menu_item_setname(menu, item, szFmtName); return iItemStatus; } public MuteMenuHandler(id, menu, item) { if (item == MENU_EXIT) { menu_destroy(menu); return PLUGIN_HANDLED; } new szPlayerId[MENU_DATA_LENGTH]; menu_item_getinfo(menu, item, g_iMenuAccessNull, szPlayerId, charsmax(szPlayerId)); new iTargetClient = str_to_num(szPlayerId); if(iTargetClient != STATIC_ITEM_HANDLER) { if(!is_user_connected(iTargetClient)) { client_print_color(id, iTargetClient, "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_NOPLAYER"); menu_destroy(menu); return PLUGIN_HANDLED; } if(!IsPlayerMuted(id, iTargetClient)) { if(GetBit(g_bitBlockedFully, iTargetClient)) { client_print_color(id, iTargetClient, "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_ALREADY_BLOCKED"); menu_destroy(menu); return PLUGIN_HANDLED; } FnMutePlayer(id, iTargetClient, true); client_print_color(id, iTargetClient, "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_SET_MUTE", iTargetClient); } else { FnMutePlayer(id, iTargetClient, false); client_print_color(id, iTargetClient, "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_RESET_MUTE", iTargetClient); } } else { if(++g_szPlayerMuteType[id] > BLOCK_STATUS_VOICE) g_szPlayerMuteType[id] = BLOCK_STATUS_ALL; } new imenu, newmenu, menupage; player_menu_info(id, imenu, newmenu, menupage); menu_display(id, menu, menupage); return PLUGIN_HANDLED; } FnMutePlayer(id, iTargetClient, setMute) { if(setMute) SetBit(g_bitPlayerMuted[id], iTargetClient); else ResetBit(g_bitPlayerMuted[id], iTargetClient); } public client_authorized(id, const authid[]) { FnClientConnected(id, authid); } FnClientConnected(id, const authid[]) { if(is_user_bot(id) || is_user_hltv(id)) return; g_bitPlayerMuted[id] = 0; g_szPlayerMuteType[id] = 0; g_isAlivePlayer[id] = false; g_iImmunLevel[id] = FnImmunityLevel(get_user_flags(id)); FnSpamTimerReset(id); ResetBit(g_bitUseTeamVoice, id); FnCheckBlockAvailability(id, authid); } public OnAPIAdminConnected(id, const szName[], adminID, Flags) { g_iImmunLevel[id] = FnImmunityLevel(Flags); } public client_disconnected(id) { FnResetBlock(id); for(new i = 1; i < MaxClients; i++) FnMutePlayer(i, id, false); } public FnCheckBlockAvailability(id, const szAuthid[]) { if(TrieGetArray(g_trhBlockedUsers, szAuthid, plBlockInfo[id], charsmax(plBlockInfo[]))) { FnChangeBlock(id, plBlockInfo[id][GBlockType]); return; } if(!g_bitApiAllow || !g_hSqlHandle) return; formatex(szQuery, charsmax(szQuery), "SELECT * FROM `%s` WHERE `server_id` = '%d' AND `authid` = '%s'\ AND ((`expired` > UNIX_TIMESTAMP(NOW()) OR `expired` = '0' ) AND `length` != '-1' AND `expired` != '-1') LIMIT 1;", sqlTable, g_iServerId, szAuthid); static Data[2]; Data[0] = id; SQL_ThreadQuery(g_hSqlHandle, "FnCheckBlockAvailability_post", szQuery, Data, sizeof(Data)); } public FnCheckBlockAvailability_post(failstate, Handle:query, const error[], errornum, const postData[], DataSize) { if(SQL_Error(error, errornum, failstate)) return; if(!SQL_NumResults(query)) return; static id; id = postData[0]; plBlockInfo[id][GBid] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "bid")); plBlockInfo[id][GBlockType] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "type")); plBlockInfo[id][GExpired] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "expired")); //plBlockInfo[id][GCreated] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "created")); plBlockInfo[id][GBlockTime] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "length")); plBlockInfo[id][GAdminId] = SQL_ReadResult(query, SQL_FieldNameToNum(query, "admin_id")); SQL_ReadResult(query, SQL_FieldNameToNum(query, "authid"), plBlockInfo[id][GAuthId], charsmax(plBlockInfo[][GAuthId])); SQL_ReadResult(query, SQL_FieldNameToNum(query, "name"), plBlockInfo[id][GName], charsmax(plBlockInfo[][GName])); SQL_ReadResult(query, SQL_FieldNameToNum(query, "reason"), plBlockInfo[id][GBlockReason], charsmax(plBlockInfo[][GBlockReason])); SQL_ReadResult(query, SQL_FieldNameToNum(query, "admin_nick"), plBlockInfo[id][GAdminNick], charsmax(plBlockInfo[][GAdminNick])); SQL_ReadResult(query, SQL_FieldNameToNum(query, "modified_by"), plBlockInfo[id][GModifiedBy], charsmax(plBlockInfo[][GModifiedBy])); mysql_escape_string(plBlockInfo[id][GName], charsmax(plBlockInfo[][GName])*2); mysql_escape_string(plBlockInfo[id][GBlockReason], charsmax(plBlockInfo[][GBlockReason])); mysql_escape_string(plBlockInfo[id][GAdminNick], charsmax(plBlockInfo[][GAdminNick])*2); mysql_escape_string(plBlockInfo[id][GModifiedBy], charsmax(plBlockInfo[][GModifiedBy])*2); if(TrieSetArray(g_trhBlockedUsers, plBlockInfo[id][GAuthId], plBlockInfo[id], sizeof(plBlockInfo[]))) FnChangeBlock(id, plBlockInfo[id][GBlockType]); } BlockQueryFunc(id, iFuncType, iBlockType = BLOCK_STATUS_NONE, szBlockReason[] = "", iTime = 0, bool:printChat = true) { new iTargetClient = plBlockInfo[id][GTargetID]; if(!iTargetClient) iTargetClient = id; new iSystime = get_systime(), iTimeleft = get_timeleft() / 60; if(g_iAddLastId == iTargetClient && iSystime < g_iAddTime + 20) { client_print_color(id, 0, "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_EDIT_ERROR"); return PLUGIN_CONTINUE; } get_user_authid(iTargetClient, plBlockInfo[id][GAuthId], charsmax(plBlockInfo[][GAuthId])); if(!TrieKeyExists(g_trhBlockedUsers, plBlockInfo[id][GAuthId])) { if(iTargetClient == id) plBlockInfo[id][GAdminNick] = "Server"; else get_user_name(id, plBlockInfo[id][GAdminNick], charsmax(plBlockInfo[][GAdminNick])); } else { get_user_name(id, plBlockInfo[id][GModifiedBy], charsmax(plBlockInfo[][GModifiedBy])); } new iBlockTime; if(iFuncType == BLOCK_FUNC_REMOVE) { plBlockInfo[id][GExpired] = TIME_MAP_END_EXPIRING; } else { if(!strlen(plBlockInfo[id][GName])) get_user_name(iTargetClient, plBlockInfo[id][GName], charsmax(plBlockInfo[][GName])); if(!strlen(plBlockInfo[id][GBlockReason])) copy(plBlockInfo[id][GBlockReason], charsmax(plBlockInfo[][GBlockReason]), szBlockReason); if(plBlockInfo[id][GBlockType] == BLOCK_STATUS_NONE) plBlockInfo[id][GBlockType] = iBlockType; if(plBlockInfo[id][GBlockTime] == TIME_NOT_EXPIRING) plBlockInfo[id][GBlockTime] = iTime; iBlockTime = plBlockInfo[id][GBlockTime]; plBlockInfo[id][GCreated] = iSystime; if(iBlockTime <= TIME_NOT_EXPIRING) plBlockInfo[id][GExpired] = iBlockTime; else plBlockInfo[id][GExpired] = plBlockInfo[id][GCreated] + iBlockTime * 60; } if(g_bitApiAllow & (UseGameCmsAdmins | UseGameCms)) { mysql_insert_string(plBlockInfo[id][GName], charsmax(plBlockInfo[][GName])*2); mysql_insert_string(plBlockInfo[id][GBlockReason], charsmax(plBlockInfo[][GBlockReason])); mysql_insert_string(plBlockInfo[id][GAdminNick], charsmax(plBlockInfo[][GAdminNick])*2); mysql_insert_string(plBlockInfo[id][GModifiedBy], charsmax(plBlockInfo[][GModifiedBy])*2); if(plBlockInfo[id][GBid]) { if(iFuncType == BLOCK_FUNC_CHANGE) formatex(szQuery, charsmax(szQuery), "UPDATE `%s` SET expired='%d', length='%d', reason='%s', modified_by='%s',type='%d' WHERE `bid` = '%d';", sqlTable, plBlockInfo[id][GExpired], plBlockInfo[id][GBlockTime], plBlockInfo[id][GBlockReason], plBlockInfo[id][GModifiedBy], plBlockInfo[id][GBlockType], plBlockInfo[id][GBid]); else if(iFuncType == BLOCK_FUNC_REMOVE) formatex(szQuery, charsmax(szQuery), "UPDATE `%s` SET expired='%d', modified_by='%s' WHERE `bid` = '%d';", sqlTable, plBlockInfo[id][GExpired], plBlockInfo[id][GModifiedBy], plBlockInfo[id][GBid]); } else { if(iFuncType != BLOCK_FUNC_ADD || iBlockTime == TIME_MAP_END_EXPIRING) return ASD_BlockFunc(id, iFuncType, iTargetClient, printChat); if(!iTimeleft || (iTimeleft && iTimeleft < iBlockTime) || iBlockTime == TIME_NOT_EXPIRING) { formatex(szQuery, charsmax(szQuery), "INSERT INTO `%s` (bid, authId, name, created, expired, length, reason, admin_id, admin_nick, server_id, modified_by, type) \ values ('%d', '%s', '%s', '%d', '%d', '%d', '%s', '%d', '%s', '%d', '%s', '%d');", sqlTable, plBlockInfo[id][GBid], plBlockInfo[id][GAuthId], plBlockInfo[id][GName], plBlockInfo[id][GCreated], plBlockInfo[id][GExpired], plBlockInfo[id][GBlockTime], plBlockInfo[id][GBlockReason], plBlockInfo[id][GAdminId], plBlockInfo[id][GAdminNick], g_iServerId, plBlockInfo[id][GModifiedBy], plBlockInfo[id][GBlockType]); } else return ASD_BlockFunc(id, iFuncType, iTargetClient, printChat); } static Data[4]; Data[0] = id; Data[1] = iFuncType; Data[2] = iTargetClient; SQL_ThreadQuery(g_hSqlHandle, "BlockQueryFunc_post", szQuery, Data, sizeof(Data)); return PLUGIN_HANDLED; } if(plBlockInfo[id][GExpired]- iSystime < iTimeleft) plBlockInfo[id][GExpired] = TIME_MAP_END_EXPIRING; return ASD_BlockFunc(id, iFuncType, iTargetClient, printChat); } public BlockQueryFunc_post(failstate, Handle:query, const error[], errornum, const postData[], DataSize) { new id, iTargetClient, iFuncType; id = postData[0]; iFuncType = postData[1]; iTargetClient = postData[2]; if(SQL_Error(error, errornum, failstate)) plBlockInfo[id][GBlockTime] = TIME_MAP_END_EXPIRING; else if(iFuncType == BLOCK_FUNC_ADD) plBlockInfo[id][GBid] = SQL_GetInsertId(query); return ASD_BlockFunc(id, iFuncType, iTargetClient); } public CBasePlayerSpawn(id) { #if defined _reapi_included g_iPlayerTeam[id] = get_member(id, m_iTeam); #else g_iPlayerTeam[id] = CsTeams:get_user_team(id); #endif if(is_user_alive(id)) g_isAlivePlayer[id] = true; } public CBasePlayerKilled(id) { if(cv_iAllTalk == 0 || cv_iAllTalk == 4) { if(g_bRoundEnd) return; if(cv_flTimeForInfo > 0.0) set_task(cv_flTimeForInfo, "FnBlockChatForInfo", id); else FnBlockChatForInfo(id); } else g_isAlivePlayer[id] = false; } public FnBlockChatForInfo(id) { g_isAlivePlayer[id] = false; set_hudmessage(220, 160, 0, -1.0, 0.63, 0, _, 5.0); show_hudmessage(id, "%L", LANG_PLAYER, "CMSGAG_HUD_INFO_TIME"); } public CmdTeamVoiceOn(id) { SetBit(g_bitUseTeamVoice, id); client_cmd(id, "+voicerecord"); return PLUGIN_HANDLED; } public CmdTeamVoiceOff(id) { ResetBit(g_bitUseTeamVoice, id); client_cmd(id, "-voicerecord"); return PLUGIN_HANDLED; } public VTC_OnClientStartSpeak(iSender) { if(VTC_IsClientMuted(iSender)) { if(g_flPlayerSpamTimer[iSender] > cv_flBlockSpamTimer) { //log_to_file("gag.log", "VTC_OnClientStartSpeak muted %d | %n", iSender, iSender) client_print_color(iSender, 0, "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_SOON_BE_UNBLOCKED", FormatBlockTime(floatround(g_flPlayerSpamTimer[iSender] - get_gametime()), 1, timeunit_seconds)); return PLUGIN_HANDLED; } return FnCheckBlockStatus(iSender, BLOCK_STATUS_VOICE); } if(g_iEntSpamChecker[iSender]) { g_flPlayerSpamTimer[iSender] = cv_flBlockSpamTimer; #if defined _reapi_included #define MAX_ID_LEN 2 set_entvar(g_iEntSpamChecker[iSender], var_nextthink, get_gametime() + 1.0); SetThink(g_iEntSpamChecker[iSender], "SpamEntThinkCallback", fmt("%d", iSender), MAX_ID_LEN); #else entity_set_float(g_iEntSpamChecker[iSender], EV_FL_nextthink, get_gametime() + 1.0); #endif //log_to_file("gag.log", "VTC_OnClientStartSpeak start timer %d | %n", iSender, iSender) } return PLUGIN_CONTINUE; } FnSpamTimerReset(iSender) { g_flPlayerSpamTimer[iSender] = 0.0; #if defined _reapi_included set_entvar(g_iEntSpamChecker[iSender], var_nextthink, 0.0); SetThink(g_iEntSpamChecker[iSender], ""); #else entity_set_float(g_iEntSpamChecker[iSender], EV_FL_nextthink, 0.0); #endif } #if defined _reapi_included public SpamEntThinkCallback(iEntity, data[], len) #else public SpamEntThinkCallback(iEntity) #endif { static iClient, Float:flTime; #if defined _reapi_included iClient = str_to_num(data); #else iClient = entity_get_edict(iEntity, EV_ENT_owner); #endif if(iClient) { if(g_flPlayerSpamTimer[iClient] <= 0.0) { flTime = cv_flBlockSpamTimer * 30.0; g_flPlayerSpamTimer[iClient] = get_gametime() + flTime; VTC_MuteClient(iClient); client_print(iClient, print_center, "%L", LANG_PLAYER, "CMSGAG_CHAT_BLOCKED", FormatBlockTime(floatround(flTime), 1, timeunit_seconds)); //log_to_file("gag.log", "SpamEntThinkCallback blocked %d (%.0f) | %n", iClient, g_flPlayerSpamTimer[iClient], iClient) } else if(g_flPlayerSpamTimer[iClient] <= cv_flBlockSpamTimer) { flTime = 1.0; if(g_flPlayerSpamTimer[iClient] < 6.0) client_print(iClient, print_center, "%L", LANG_PLAYER, "CMSGAG_CHAT_WILL_BE_BLOCKED", g_flPlayerSpamTimer[iClient]); g_flPlayerSpamTimer[iClient]--; //log_to_file("gag.log", "SpamEntThinkCallback will be blocked %d (%.0f) | %n", iClient, g_flPlayerSpamTimer[iClient], iClient) } else { flTime = 1.0; g_flPlayerSpamTimer[iClient] = cv_flBlockSpamTimer; VTC_UnmuteClient(iClient); client_print(iClient, print_center, "%L", LANG_PLAYER, "CMSGAG_CHAT_UNBLOCKED"); //log_to_file("gag.log", "SpamEntThinkCallback unblocked %d (%.0f) | %n", iClient, g_flPlayerSpamTimer[iClient], iClient) } } //else //log_to_file("gag.log", "Not a client") #if defined _reapi_included set_entvar(iEntity, var_nextthink, get_gametime() + flTime); #else entity_set_float(iEntity, EV_FL_nextthink, get_gametime() + flTime); #endif } public VTC_OnClientStopSpeak(iSender) { if(!g_iEntSpamChecker[iSender]) return PLUGIN_CONTINUE; if(g_flPlayerSpamTimer[iSender] <= cv_flBlockSpamTimer) FnSpamTimerReset(iSender); return PLUGIN_CONTINUE; } public CanPlayerHearPlayer(Receiver, Sender, bool:Listen) { if(Receiver == Sender) return FMRES_IGNORED; if(!g_isAlivePlayer[Sender] && g_iImmunLevel[Sender] > 1 && (GetBit(g_bitUseTeamVoice, Sender) || cv_iDeadAdmTalk)) return FnCanHearSender(Receiver, Sender, true); if(IsPlayerMuted(Receiver, Sender) && g_szPlayerMuteType[Receiver] != BLOCK_STATUS_CHAT) return FnCanHearSender(Receiver, Sender, false); #if defined _reapi_included if(GetBit(g_bitUseTeamVoice, Sender)) { if(IsEnemy(Receiver, Sender)) return FnCanHearSender(Receiver, Sender, false); } if(cv_flTimeForInfo > 0.0) { if(g_isAlivePlayer[Sender] && g_isAlivePlayer[Receiver]) return FnCanHearSender(Receiver, Sender, true); } return FMRES_IGNORED; #else if(cv_iAllTalk == 1) { if(GetBit(g_bitUseTeamVoice, Sender)) { if(/*g_iPlayerTeam[Receiver] != g_iPlayerTeam[Sender]*/IsEnemy(Receiver, Sender)) return FnCanHearSender(Receiver, Sender, false); } //return FMRES_IGNORED; return FnCanHearSender(Receiver, Sender, true); } if(g_iPlayerTeam[Receiver] == CS_TEAM_SPECTATOR) { if(cv_iAllTalk == 0 || cv_iAllTalk == 2) { if(g_iPlayerTeam[Sender] != CS_TEAM_SPECTATOR) return FnCanHearSender(Receiver, Sender, false); } return FMRES_IGNORED; } if(g_isAlivePlayer[Sender]) { if(cv_iAllTalk == 4) { if(GetBit(g_bitUseTeamVoice, Sender)) { if(/*g_iPlayerTeam[Receiver] != g_iPlayerTeam[Sender]*/IsEnemy(Receiver, Sender)) return FnCanHearSender(Receiver, Sender, false); } return FMRES_IGNORED; } if(/*g_iPlayerTeam[Receiver] == g_iPlayerTeam[Sender]*/!IsEnemy(Receiver, Sender)) return FMRES_IGNORED; } else { if(!g_isAlivePlayer[Receiver]) return FMRES_IGNORED; if(/*g_iPlayerTeam[Receiver] != g_iPlayerTeam[Sender]*/IsEnemy(Receiver, Sender)) return FnCanHearSender(Receiver, Sender, false); if(cv_iAllTalk != 0 && cv_iAllTalk != 4) return FMRES_IGNORED; } return FnCanHearSender(Receiver, Sender, false); #endif } FnCanHearSender(Receiver, Sender, bool:status) { #if defined _reapi_included #pragma unused Receiver, Sender // SetHookChainReturn(ATYPE_BOOL, status); SetHookChainReturn(ATYPE_BOOL, status); #else engfunc(EngFunc_SetClientListening, Receiver, Sender, status); forward_return(FMV_CELL, status); #endif return FMRES_SUPERCEDE; } public HookSayChat(id) { new szMsg[MAX_CHAT_MSG_LENGTH]; read_args(szMsg, charsmax(szMsg)); remove_quotes(szMsg); if(TrieKeyExists(g_trhWhiteListCmdArray, szMsg)) return PLUGIN_CONTINUE; if(BLOCK_STATUS_NONE < cmsgag_is_user_blocked(id) < BLOCK_STATUS_VOICE) return FnCheckBlockStatus(id, BLOCK_STATUS_CHAT); return PLUGIN_CONTINUE; } stock FnCheckBlockStatus(id, iBlockType) { new szAuthId[MAX_AUTHID_LENGTH]; get_user_authid(id, szAuthId, charsmax(szAuthId)); if(TrieGetArray(g_trhBlockedUsers, szAuthId, plBlockInfo[id], charsmax(plBlockInfo[]))) { if(plBlockInfo[id][GExpired] > get_systime() || plBlockInfo[id][GExpired] <= TIME_NOT_EXPIRING) { client_print_color(id, 0, "%L %L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, iBlockType == BLOCK_STATUS_CHAT ? "CMSGAG_CHAT_BLOCK_VOICE" : "CMSGAG_CHAT_BLOCK_CHAT", FormatBlockTime(plBlockInfo[id][GBlockTime], 1, timeunit_minutes), LANG_PLAYER, "CMSGAG_CHAT_BLOCK_REASON", plBlockInfo[id][GBlockReason]); client_cmd(id, "play %s", g_szSoundFilePath); return PLUGIN_HANDLED; } else return FnRemoveBlockStatus(id); } return PLUGIN_CONTINUE; } public MessageSayText(MsgID, MsgDEST, MsgRecipient) { if(MsgDEST != MSG_ONE) return PLUGIN_CONTINUE; if(IsPlayerMuted(MsgRecipient, get_msg_arg_int(1)) && g_szPlayerMuteType[MsgRecipient] != BLOCK_STATUS_VOICE) //if(cmsgag_is_user_muted_by(MsgRecipient, get_msg_arg_int(1))) return PLUGIN_HANDLED; return PLUGIN_CONTINUE; } stock ASD_BlockFunc(id, iFuncType, iTargetClient, printChat = true) { if(iFuncType == BLOCK_FUNC_REMOVE) return FnRemoveBlockStatus(id, printChat); if(TrieSetArray(g_trhBlockedUsers, plBlockInfo[id][GAuthId], plBlockInfo[id], sizeof(plBlockInfo[]))) { new iBlockType = plBlockInfo[id][GBlockType]; new szTime[MAX_STRING_LEN]; copy(szTime, charsmax(szTime), FormatBlockTime(plBlockInfo[id][GBlockTime], 1, timeunit_minutes)); new szAdmName[MAX_NAME_LENGTH]; new szMessage[MAX_CHAT_MSG_LENGTH]; if(iFuncType == BLOCK_FUNC_ADD) { if(get_pcvar_num(cpAmxShowActivity) == 2) { get_user_name(id, szAdmName, charsmax(szAdmName)); formatex(szMessage, charsmax(szMessage), "%L %L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_BLOCK_ADMIN_ACT", szAdmName, g_szBlockType[iBlockType], plBlockInfo[id][GName], szTime, LANG_PLAYER, "CMSGAG_CHAT_BLOCK_REASON", plBlockInfo[id][GBlockReason]); if(printChat) client_print_color(0, 0, szMessage); FnClearText(szMessage); log_amx(szMessage); } else { formatex(szMessage, charsmax(szMessage), "%L %L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_BLOCK_ADMIN", plBlockInfo[id][GName], g_szBlockType[iBlockType], szTime, LANG_PLAYER, "CMSGAG_CHAT_BLOCK_REASON", plBlockInfo[id][GBlockReason]); if(printChat) client_print_color(0, 0, szMessage); FnClearText(szMessage); log_amx(szMessage); } } else { if(get_pcvar_num(cpAmxShowActivity) == 2) { get_user_name(id, szAdmName, charsmax(szAdmName)); formatex(szMessage, charsmax(szMessage), "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_BLOCK_EDIT_ADMIN", szAdmName, plBlockInfo[id][GName], g_szBlockType[iBlockType], szTime); if(printChat) client_print_color(0, 0, szMessage); FnClearText(szMessage); log_amx(szMessage); } else { formatex(szMessage, charsmax(szMessage), "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_BLOCK_EDIT", plBlockInfo[id][GName], g_szBlockType[iBlockType], szTime); if(printChat) client_print_color(0, 0, szMessage); FnClearText(szMessage); log_amx(szMessage); } } if(is_user_connected(iTargetClient)) FnChangeBlock(iTargetClient, iBlockType); g_iAddTime = plBlockInfo[id][GCreated]; g_iAddLastId = iTargetClient; } else log_amx("ASD_BlockFunc: Error"); arrayset(plBlockInfo[id], 0, BlockInfo); return PLUGIN_HANDLED; } stock FnResetBlock(iTargetClient) { ResetBit(g_bitBlockedFully, iTargetClient); ResetBit(g_bitBlockedChat, iTargetClient); ResetBit(g_bitBlockedVoice, iTargetClient); VTC_UnmuteClient(iTargetClient); } stock FnChangeBlock(iTargetClient, Type) { FnResetBlock(iTargetClient); switch(Type) { case 0: { SetBit(g_bitBlockedFully, iTargetClient); VTC_MuteClient(iTargetClient); } case 1: SetBit(g_bitBlockedChat, iTargetClient); case 2: { SetBit(g_bitBlockedVoice, iTargetClient); VTC_MuteClient(iTargetClient); } } } stock FnRemoveBlockStatus(id, printChat = true) { new iClient = find_player("c", plBlockInfo[id][GAuthId]); if(TrieDeleteKey(g_trhBlockedUsers, plBlockInfo[id][GAuthId])) { new type[MAX_NAME_LENGTH]; copy(type, charsmax(type), g_szBlockType[plBlockInfo[id][GBlockType]]); new szMessage[MAX_CHAT_MSG_LENGTH]; if(get_pcvar_num(cpAmxShowActivity) == 2 && (id != iClient)) { new szAdmName[MAX_NAME_LENGTH]; get_user_name(id, szAdmName, charsmax(szAdmName)); formatex(szMessage, charsmax(szMessage), "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_BLOCK_REMOVE_ADMIN", szAdmName, type, plBlockInfo[id][GName]); if(printChat) client_print_color(0, 0, szMessage); FnClearText(szMessage); log_amx(szMessage); } else { formatex(szMessage, charsmax(szMessage), "%L %L", LANG_PLAYER, "CMSGAG_CHAT_PREFIX", LANG_PLAYER, "CMSGAG_CHAT_BLOCK_REMOVE", plBlockInfo[id][GName], type); if(printChat) client_print_color(0, 0, szMessage); FnClearText(szMessage); log_amx(szMessage); } arrayset(plBlockInfo[id], 0, BlockInfo); FnResetBlock(iClient); VTC_UnmuteClient(iClient); return PLUGIN_HANDLED; } else log_amx("FnRemoveBlockStatus: Error"); return PLUGIN_CONTINUE; } stock bool:FnAboveImmunity(requester, target, bool:byFlags = false) { if(byFlags) return (FnImmunityLevel(requester) > FnImmunityLevel(target)); return (g_iImmunLevel[requester] == g_iImmunLevelsNum || g_iImmunLevel[requester] > g_iImmunLevel[target]); } stock FnImmunityLevel(flags) { static i; i = g_iImmunLevelsNum; while(i > 0) { i--; if(flags & g_bitAccessLvl[i]) break; } return i+1; } stock FormatBlockTime(iTime, type, unitType) { new szTime[MAX_STRING_LEN]; switch(iTime) { case TIME_MAP_END_EXPIRING: formatex(szTime, charsmax(szTime), "%L", LANG_PLAYER, type == 1 ? "CMSGAG_TIME_LENGTH_1" : "CMSGAG_TIME_LENGTH_2"); case TIME_NOT_EXPIRING: formatex(szTime, charsmax(szTime), "%L", LANG_PLAYER, type == 1 ? "CMSGAG_TIME_NON_EXPIRED_1" : "CMSGAG_TIME_NON_EXPIRED_2"); default: get_time_length(0, iTime, unitType, szTime, charsmax(szTime)); } return szTime; } FnClearText(langText[]) { replace_all(langText, MAX_CHAT_MSG_LENGTH, "^4", "!g"); replace_all(langText, MAX_CHAT_MSG_LENGTH, "^1", "!n"); replace_all(langText, MAX_CHAT_MSG_LENGTH, "^3", "!t"); } public plugin_end() { if(g_arhBlockTime) ArrayDestroy(g_arhBlockTime); if(g_arhBlockReasons) ArrayDestroy(g_arhBlockReasons); } public plugin_natives() { set_native_filter("native_filter"); register_native("cmsgag_is_user_blocked", "native_cmsgag_is_user_blocked"); register_native("cmsgag_is_user_muted_by", "native_cmsgag_is_user_muted_by"); register_native("cmsgag_add_user_block", "native_cmsgag_add_user_block"); } public native_filter(const GName[], index, trap) return !trap ? PLUGIN_HANDLED : PLUGIN_CONTINUE; public native_cmsgag_is_user_blocked() { new id = get_param(1); return GetBit(g_bitBlockedFully, id) ? BLOCK_STATUS_ALL : GetBit(g_bitBlockedChat, id) ? BLOCK_STATUS_CHAT : GetBit(g_bitBlockedVoice, id) ? BLOCK_STATUS_VOICE : BLOCK_STATUS_NONE; } public native_cmsgag_is_user_muted_by() { static iClient; iClient = get_param(1); if(IsPlayerMuted(iClient, get_param(2))) return g_szPlayerMuteType[iClient]; return BLOCK_STATUS_NONE; //return IsPlayerMuted(g_bitPlayerMuted[get_param(1)], get_param(2)); } public native_cmsgag_add_user_block() { new szReason[MAX_REASON_LENGTH], iTargetClient; iTargetClient = get_param(1); get_string(4, szReason, charsmax(szReason)); get_user_authid(iTargetClient, plBlockInfo[iTargetClient][GAuthId], charsmax(plBlockInfo[][GAuthId])); return BlockQueryFunc(iTargetClient, get_param(2), get_param(3), szReason, get_param(5), bool:get_param(6)); }
- Источник плагина (ссылка на сайт или тему)
- https://cs-games.club/index.php?threads/gamecms-gagmanager.8/
L 02/09/2021 - 22:48:11: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:48:11: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:48:11: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 22,`hits` = `hits` + 1,`dmg` = `dmg` + 10,`skill` = `skill` + 0.44,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 6,`roundct` = `roundct` + '1',`assists` = `assists` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 36,`hits` = `hits` + 8,`dmg` = `dmg` + 274,`skill` = `skill` + -0.44,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1',`h_7` = `h_7` + '3',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:48:52: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:48:52: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:48:52: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 10,`hits` = `hits` + 2,`dmg` = `dmg` + 16,`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 2,`shots` = `shots` + 4,`hits` = `hits` + 3,`dmg` = `dmg` + 63,`skill` = `skill` + -2.06,`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 41,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 41,`hits` = `hits` + 10,`dmg` = `dmg` + 314,`skill` = `skill` + 2.06,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '2',`h_4` = `h_4` + '5',`h_6` = `h_6` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 41,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:50:04: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:50:04: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:50:04: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 4,`hits` = `hits` + 2,`dmg` = `dmg` + 56,`skill` = `skill` + -0.75,`h_3` = `h_3` + '2',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 71,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 11,`hits` = `hits` + 2,`dmg` = `dmg` + 41,`h_6` = `h_6` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 72,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 31,`hits` = `hits` + 6,`dmg` = `dmg` + 164,`skill` = `skill` + 0.75,`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '3',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 72,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:50:30: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:50:30: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:50:30: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 6,`hits` = `hits` + 1,`dmg` = `dmg` + 33,`skill` = `skill` + 1.26,`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 26,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 15,`hits` = `hits` + 5,`dmg` = `dmg` + 99,`skill` = `skill` + -1.00,`h_2` = `h_2` + '2',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 25,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 19,`hits` = `hits` + 5,`dmg` = `dmg` + 202,`skill` = `skill` + -0.26,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 26,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:51:43: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:51:43: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:51:43: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 19,`skill` = `skill` + 0.47,`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 74,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 20,`hits` = `hits` + 3,`dmg` = `dmg` + 64,`h_2` = `h_2` + '2',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`assists` = `assists` + '1',`connection_time` = `connection_time` + 74,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 33,`hits` = `hits` + 5,`dmg` = `dmg` + 214,`bombplants` = `bombplants` + 1,`skill` = `skill` + -0.47,`h_1` = `h_1` + '1',`h_3` = `h_3` + '2',`h_4` = `h_4` + '1',`h_6` = `h_6` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 73,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:52:01: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:52:01: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:52:01: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 18,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 3,`hits` = `hits` + 2,`dmg` = `dmg` + 56,`skill` = `skill` + -0.98,`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 18,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 13,`hits` = `hits` + 4,`dmg` = `dmg` + 127,`skill` = `skill` + 0.98,`h_4` = `h_4` + '3',`h_6` = `h_6` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 18,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:53:18: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:53:18: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:53:18: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 87,`hits` = `hits` + 1,`dmg` = `dmg` + 72,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 77,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 8,`hits` = `hits` + 1,`dmg` = `dmg` + 114,`skill` = `skill` + 0.05,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 77,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 29,`hits` = `hits` + 4,`dmg` = `dmg` + 158,`skill` = `skill` + -0.05,`h_1` = `h_1` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 77,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:54:07: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:54:07: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:54:07: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 45,`hits` = `hits` + 1,`dmg` = `dmg` + 72,`skill` = `skill` + 1.24,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 48,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 8,`skill` = `skill` + -0.97,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 34,`hits` = `hits` + 7,`dmg` = `dmg` + 210,`skill` = `skill` + -0.27,`h_1` = `h_1` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '4',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:55:23: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:55:23: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:55:23: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 1,`hits` = `hits` + 1,`dmg` = `dmg` + 59,`skill` = `skill` + 0.48,`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 18,`hits` = `hits` + 4,`dmg` = `dmg` + 46,`bombdef` = `bombdef` + 1,`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 17,`hits` = `hits` + 3,`dmg` = `dmg` + 93,`bombplants` = `bombplants` + 1,`bombexplosions` = `bombexplosions` + 1,`skill` = `skill` + -0.48,`h_4` = `h_4` + '1',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:55:39: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:55:39: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:55:39: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 16,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 21,`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 16,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `shots` = `shots` + 10,`hits` = `hits` + 1,`dmg` = `dmg` + 26,`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 16,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:56:45: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:56:45: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:56:45: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 3,`skill` = `skill` + -0.78,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 51,`hits` = `hits` + 4,`dmg` = `dmg` + 145,`skill` = `skill` + 1.03,`h_1` = `h_1` + '1',`h_2` = `h_2` + '2',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 66,`hits` = `hits` + 5,`dmg` = `dmg` + 179,`skill` = `skill` + -0.25,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:57:34: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:57:34: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:57:34: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 30,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 25,`skill` = `skill` + 0.02,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 27,`hits` = `hits` + 5,`dmg` = `dmg` + 199,`skill` = `skill` + -0.02,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:58:17: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:58:17: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:58:17: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 12,`hits` = `hits` + 1,`dmg` = `dmg` + 8,`skill` = `skill` + -0.77,`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 43,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 32,`hits` = `hits` + 3,`dmg` = `dmg` + 80,`h_1` = `h_1` + '2',`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 43,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 41,`hits` = `hits` + 9,`dmg` = `dmg` + 168,`skill` = `skill` + 0.77,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '5',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 43,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:59:32: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:59:32: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:59:32: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 5,`skill` = `skill` + -0.76,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 75,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 40,`hits` = `hits` + 5,`dmg` = `dmg` + 113,`skill` = `skill` + 1.03,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 75,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 50,`hits` = `hits` + 6,`dmg` = `dmg` + 231,`skill` = `skill` + -0.26,`h_1` = `h_1` + '2',`h_4` = `h_4` + '4',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 75,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:00:14: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:00:14: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:00:14: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`skill` = `skill` + -1.94,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`shots` = `shots` + 23,`hits` = `hits` + 7,`dmg` = `dmg` + 178,`skill` = `skill` + 1.94,`h_2` = `h_2` + '1',`h_5` = `h_5` + '1',`h_6` = `h_6` + '2',`h_7` = `h_7` + '3',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:00:58: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:00:58: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:00:58: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 13,`hits` = `hits` + 2,`dmg` = `dmg` + 56,`skill` = `skill` + -0.72,`h_7` = `h_7` + '2',`roundct` = `roundct` + '2',`connection_time` = `connection_time` + 85,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 9,`hits` = `hits` + 2,`dmg` = `dmg` + 43,`skill` = `skill` + -0.92,`h_4` = `h_4` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 44,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 42,`hits` = `hits` + 10,`dmg` = `dmg` + 338,`skill` = `skill` + 1.65,`h_1` = `h_1` + '1',`h_2` = `h_2` + '3',`h_3` = `h_3` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '2',`h_7` = `h_7` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 44,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:01:34: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:01:34: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:01:34: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`skill` = `skill` + -1.39,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 37,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 7,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 36,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 25,`hits` = `hits` + 4,`dmg` = `dmg` + 184,`skill` = `skill` + 1.39,`h_1` = `h_1` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 36,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:02:12: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:02:12: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:02:12: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 14,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 38,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 9,`hits` = `hits` + 1,`dmg` = `dmg` + 51,`skill` = `skill` + -0.89,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 38,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 22,`hits` = `hits` + 2,`dmg` = `dmg` + 51,`skill` = `skill` + 0.89,`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 38,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:03:01: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:03:01: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:03:01: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 12,`hits` = `hits` + 1,`dmg` = `dmg` + 21,`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 4,`hits` = `hits` + 2,`dmg` = `dmg` + 54,`skill` = `skill` + 0.23,`h_1` = `h_1` + '2',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 20,`hits` = `hits` + 8,`dmg` = `dmg` + 178,`bombplants` = `bombplants` + 1,`skill` = `skill` + -0.23,`h_3` = `h_3` + '4',`h_4` = `h_4` + '1',`h_7` = `h_7` + '3',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:03:32: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:03:32: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:03:32: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`skill` = `skill` + -1.32,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 31,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 3,`hits` = `hits` + 1,`dmg` = `dmg` + 17,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 31,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 2,`shots` = `shots` + 29,`hits` = `hits` + 8,`dmg` = `dmg` + 415,`skill` = `skill` + 1.32,`h_1` = `h_1` + '2',`h_2` = `h_2` + '2',`h_3` = `h_3` + '2',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 30,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:04:00: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:04:00: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:04:00: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 2,`hits` = `hits` + 1,`dmg` = `dmg` + 40,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 28,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 7,`hits` = `hits` + 2,`dmg` = `dmg` + 50,`skill` = `skill` + -0.86,`h_1` = `h_1` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 28,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 25,`hits` = `hits` + 3,`dmg` = `dmg` + 95,`skill` = `skill` + 0.86,`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`h_7` = `h_7` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 28,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:04:56: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:04:56: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:04:56: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 21,`hits` = `hits` + 5,`dmg` = `dmg` + 122,`skill` = `skill` + 1.36,`h_3` = `h_3` + '2',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 55,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.85,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`assists` = `assists` + '1',`connection_time` = `connection_time` + 55,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 16,`hits` = `hits` + 1,`dmg` = `dmg` + 132,`skill` = `skill` + -0.50,`h_1` = `h_1` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 56,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:06:16: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:06:16: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:06:16: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 2,`shots` = `shots` + 29,`hits` = `hits` + 5,`dmg` = `dmg` + 139,`skill` = `skill` + 2.67,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_6` = `h_6` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 81,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.85,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 81,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 2,`hs` = `hs` + 1,`shots` = `shots` + 7,`hits` = `hits` + 2,`dmg` = `dmg` + 162,`bombplants` = `bombplants` + 1,`bombexplosions` = `bombexplosions` + 1,`skill` = `skill` + -1.82,`h_1` = `h_1` + '1',`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 81,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:07:29: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:07:29: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:07:29: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`shots` = `shots` + 1,`skill` = `skill` + -0.69,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 73,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 7,`hits` = `hits` + 3,`dmg` = `dmg` + 68,`bombdef` = `bombdef` + 1,`h_2` = `h_2` + '1',`h_3` = `h_3` + '2',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 73,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 38,`hits` = `hits` + 5,`dmg` = `dmg` + 271,`bombplants` = `bombplants` + 1,`skill` = `skill` + 0.69,`h_1` = `h_1` + '2',`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 72,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:08:19: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:08:19: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:08:19: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 1,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 18,`hits` = `hits` + 1,`dmg` = `dmg` + 4,`bombdef` = `bombdef` + 1,`bombdefused` = `bombdefused` + 1,`skill` = `skill` + -0.84,`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 35,`bombplants` = `bombplants` + 1,`skill` = `skill` + 0.84,`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:08:30: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:08:30: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:08:30: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.67,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 10,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20'
L 02/09/2021 - 23:09:06: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:09:06: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:09:06: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 26,`hits` = `hits` + 4,`dmg` = `dmg` + 189,`bombplants` = `bombplants` + 1,`skill` = `skill` + -0.51,`h_1` = `h_1` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 47,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:09:15: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:48:11: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:48:11: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 22,`hits` = `hits` + 1,`dmg` = `dmg` + 10,`skill` = `skill` + 0.44,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 6,`roundct` = `roundct` + '1',`assists` = `assists` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 36,`hits` = `hits` + 8,`dmg` = `dmg` + 274,`skill` = `skill` + -0.44,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1',`h_7` = `h_7` + '3',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:48:52: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:48:52: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:48:52: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 10,`hits` = `hits` + 2,`dmg` = `dmg` + 16,`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 2,`shots` = `shots` + 4,`hits` = `hits` + 3,`dmg` = `dmg` + 63,`skill` = `skill` + -2.06,`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 41,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 41,`hits` = `hits` + 10,`dmg` = `dmg` + 314,`skill` = `skill` + 2.06,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '2',`h_4` = `h_4` + '5',`h_6` = `h_6` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 41,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:50:04: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:50:04: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:50:04: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 4,`hits` = `hits` + 2,`dmg` = `dmg` + 56,`skill` = `skill` + -0.75,`h_3` = `h_3` + '2',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 71,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 11,`hits` = `hits` + 2,`dmg` = `dmg` + 41,`h_6` = `h_6` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 72,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 31,`hits` = `hits` + 6,`dmg` = `dmg` + 164,`skill` = `skill` + 0.75,`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '3',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 72,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:50:30: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:50:30: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:50:30: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 6,`hits` = `hits` + 1,`dmg` = `dmg` + 33,`skill` = `skill` + 1.26,`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 26,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 15,`hits` = `hits` + 5,`dmg` = `dmg` + 99,`skill` = `skill` + -1.00,`h_2` = `h_2` + '2',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 25,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 19,`hits` = `hits` + 5,`dmg` = `dmg` + 202,`skill` = `skill` + -0.26,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 26,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:51:43: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:51:43: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:51:43: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 19,`skill` = `skill` + 0.47,`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 74,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 20,`hits` = `hits` + 3,`dmg` = `dmg` + 64,`h_2` = `h_2` + '2',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`assists` = `assists` + '1',`connection_time` = `connection_time` + 74,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 33,`hits` = `hits` + 5,`dmg` = `dmg` + 214,`bombplants` = `bombplants` + 1,`skill` = `skill` + -0.47,`h_1` = `h_1` + '1',`h_3` = `h_3` + '2',`h_4` = `h_4` + '1',`h_6` = `h_6` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 73,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:52:01: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:52:01: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:52:01: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 18,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 3,`hits` = `hits` + 2,`dmg` = `dmg` + 56,`skill` = `skill` + -0.98,`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 18,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 13,`hits` = `hits` + 4,`dmg` = `dmg` + 127,`skill` = `skill` + 0.98,`h_4` = `h_4` + '3',`h_6` = `h_6` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 18,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:53:18: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:53:18: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:53:18: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 87,`hits` = `hits` + 1,`dmg` = `dmg` + 72,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 77,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 8,`hits` = `hits` + 1,`dmg` = `dmg` + 114,`skill` = `skill` + 0.05,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 77,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 29,`hits` = `hits` + 4,`dmg` = `dmg` + 158,`skill` = `skill` + -0.05,`h_1` = `h_1` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 77,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:54:07: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:54:07: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:54:07: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 45,`hits` = `hits` + 1,`dmg` = `dmg` + 72,`skill` = `skill` + 1.24,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 48,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 8,`skill` = `skill` + -0.97,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 34,`hits` = `hits` + 7,`dmg` = `dmg` + 210,`skill` = `skill` + -0.27,`h_1` = `h_1` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '4',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:55:23: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:55:23: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:55:23: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 1,`hits` = `hits` + 1,`dmg` = `dmg` + 59,`skill` = `skill` + 0.48,`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 18,`hits` = `hits` + 4,`dmg` = `dmg` + 46,`bombdef` = `bombdef` + 1,`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 17,`hits` = `hits` + 3,`dmg` = `dmg` + 93,`bombplants` = `bombplants` + 1,`bombexplosions` = `bombexplosions` + 1,`skill` = `skill` + -0.48,`h_4` = `h_4` + '1',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:55:39: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:55:39: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:55:39: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 16,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 21,`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 16,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `shots` = `shots` + 10,`hits` = `hits` + 1,`dmg` = `dmg` + 26,`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 16,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:56:45: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:56:45: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:56:45: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 3,`skill` = `skill` + -0.78,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 51,`hits` = `hits` + 4,`dmg` = `dmg` + 145,`skill` = `skill` + 1.03,`h_1` = `h_1` + '1',`h_2` = `h_2` + '2',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 66,`hits` = `hits` + 5,`dmg` = `dmg` + 179,`skill` = `skill` + -0.25,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:57:34: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:57:34: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:57:34: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 30,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 25,`skill` = `skill` + 0.02,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 27,`hits` = `hits` + 5,`dmg` = `dmg` + 199,`skill` = `skill` + -0.02,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:58:17: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:58:17: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:58:17: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 12,`hits` = `hits` + 1,`dmg` = `dmg` + 8,`skill` = `skill` + -0.77,`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 43,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 32,`hits` = `hits` + 3,`dmg` = `dmg` + 80,`h_1` = `h_1` + '2',`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 43,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 41,`hits` = `hits` + 9,`dmg` = `dmg` + 168,`skill` = `skill` + 0.77,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '5',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 43,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 22:59:32: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 22:59:32: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 22:59:32: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 5,`skill` = `skill` + -0.76,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 75,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 40,`hits` = `hits` + 5,`dmg` = `dmg` + 113,`skill` = `skill` + 1.03,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 75,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 50,`hits` = `hits` + 6,`dmg` = `dmg` + 231,`skill` = `skill` + -0.26,`h_1` = `h_1` + '2',`h_4` = `h_4` + '4',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 75,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:00:14: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:00:14: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:00:14: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`skill` = `skill` + -1.94,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`shots` = `shots` + 23,`hits` = `hits` + 7,`dmg` = `dmg` + 178,`skill` = `skill` + 1.94,`h_2` = `h_2` + '1',`h_5` = `h_5` + '1',`h_6` = `h_6` + '2',`h_7` = `h_7` + '3',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 42,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:00:58: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:00:58: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:00:58: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 13,`hits` = `hits` + 2,`dmg` = `dmg` + 56,`skill` = `skill` + -0.72,`h_7` = `h_7` + '2',`roundct` = `roundct` + '2',`connection_time` = `connection_time` + 85,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 9,`hits` = `hits` + 2,`dmg` = `dmg` + 43,`skill` = `skill` + -0.92,`h_4` = `h_4` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 44,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 42,`hits` = `hits` + 10,`dmg` = `dmg` + 338,`skill` = `skill` + 1.65,`h_1` = `h_1` + '1',`h_2` = `h_2` + '3',`h_3` = `h_3` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '2',`h_7` = `h_7` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 44,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:01:34: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:01:34: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:01:34: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`skill` = `skill` + -1.39,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 37,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 7,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 36,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 25,`hits` = `hits` + 4,`dmg` = `dmg` + 184,`skill` = `skill` + 1.39,`h_1` = `h_1` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 36,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:02:12: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:02:12: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:02:12: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 14,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 38,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 9,`hits` = `hits` + 1,`dmg` = `dmg` + 51,`skill` = `skill` + -0.89,`h_1` = `h_1` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 38,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 22,`hits` = `hits` + 2,`dmg` = `dmg` + 51,`skill` = `skill` + 0.89,`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 38,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:03:01: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:03:01: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:03:01: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 12,`hits` = `hits` + 1,`dmg` = `dmg` + 21,`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 4,`hits` = `hits` + 2,`dmg` = `dmg` + 54,`skill` = `skill` + 0.23,`h_1` = `h_1` + '2',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 49,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 20,`hits` = `hits` + 8,`dmg` = `dmg` + 178,`bombplants` = `bombplants` + 1,`skill` = `skill` + -0.23,`h_3` = `h_3` + '4',`h_4` = `h_4` + '1',`h_7` = `h_7` + '3',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:03:32: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:03:32: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:03:32: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`skill` = `skill` + -1.32,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 31,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 3,`hits` = `hits` + 1,`dmg` = `dmg` + 17,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 31,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 2,`shots` = `shots` + 29,`hits` = `hits` + 8,`dmg` = `dmg` + 415,`skill` = `skill` + 1.32,`h_1` = `h_1` + '2',`h_2` = `h_2` + '2',`h_3` = `h_3` + '2',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 30,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:04:00: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:04:00: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:04:00: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 2,`hits` = `hits` + 1,`dmg` = `dmg` + 40,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 28,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 7,`hits` = `hits` + 2,`dmg` = `dmg` + 50,`skill` = `skill` + -0.86,`h_1` = `h_1` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 28,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 25,`hits` = `hits` + 3,`dmg` = `dmg` + 95,`skill` = `skill` + 0.86,`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`h_7` = `h_7` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 28,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:04:56: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:04:56: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:04:56: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 21,`hits` = `hits` + 5,`dmg` = `dmg` + 122,`skill` = `skill` + 1.36,`h_3` = `h_3` + '2',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 55,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.85,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`assists` = `assists` + '1',`connection_time` = `connection_time` + 55,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 16,`hits` = `hits` + 1,`dmg` = `dmg` + 132,`skill` = `skill` + -0.50,`h_1` = `h_1` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 56,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:06:16: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:06:16: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:06:16: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 2,`shots` = `shots` + 29,`hits` = `hits` + 5,`dmg` = `dmg` + 139,`skill` = `skill` + 2.67,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_6` = `h_6` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 81,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.85,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 81,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 2,`hs` = `hs` + 1,`shots` = `shots` + 7,`hits` = `hits` + 2,`dmg` = `dmg` + 162,`bombplants` = `bombplants` + 1,`bombexplosions` = `bombexplosions` + 1,`skill` = `skill` + -1.82,`h_1` = `h_1` + '1',`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 81,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:07:29: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:07:29: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:07:29: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 2,`shots` = `shots` + 1,`skill` = `skill` + -0.69,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 73,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `shots` = `shots` + 7,`hits` = `hits` + 3,`dmg` = `dmg` + 68,`bombdef` = `bombdef` + 1,`h_2` = `h_2` + '1',`h_3` = `h_3` + '2',`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 73,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`hs` = `hs` + 1,`shots` = `shots` + 38,`hits` = `hits` + 5,`dmg` = `dmg` + 271,`bombplants` = `bombplants` + 1,`skill` = `skill` + 0.69,`h_1` = `h_1` + '2',`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`connection_time` = `connection_time` + 72,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:08:19: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:08:19: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:08:19: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `shots` = `shots` + 1,`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20';UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 18,`hits` = `hits` + 1,`dmg` = `dmg` + 4,`bombdef` = `bombdef` + 1,`bombdefused` = `bombdefused` + 1,`skill` = `skill` + -0.84,`h_4` = `h_4` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:15827364',`ip` = '185.239.118.79',`name` = 'влад'WHERE `id` = '19';UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 35,`bombplants` = `bombplants` + 1,`skill` = `skill` + 0.84,`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:08:30: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:08:30: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:08:30: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.67,`roundct` = `roundct` + '1',`connection_time` = `connection_time` + 10,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:537646456',`ip` = '185.239.123.65',`name` = 'Ivan_Grozniu'WHERE `id` = '20'
L 02/09/2021 - 23:09:06: [csstatsx_sql.amxx] SQL query failed
L 02/09/2021 - 23:09:06: [csstatsx_sql.amxx] [ 1048 ] Column 'session_id' cannot be null
L 02/09/2021 - 23:09:06: [csstatsx_sql.amxx] [ SQL ] UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`shots` = `shots` + 26,`hits` = `hits` + 4,`dmg` = `dmg` + 189,`bombplants` = `bombplants` + 1,`skill` = `skill` + -0.51,`h_1` = `h_1` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '2',`roundt` = `roundt` + '1',`connection_time` = `connection_time` + 47,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_0:0:2125970135',`ip` = '185.94.214.18',`name` = 'ALEKSEY HOKAGE'WHERE `id` = '21'
L 02/09/2021 - 23:09:15: [csstatsx_sql.amxx] SQL query failed
L 02/14/2021 - 14:48:56: Info (map "de_inferno") (file "addons/amxmodx/logs/error_20210214.log")
L 02/14/2021 - 14:48:56: [AMXX] Displaying debug trace (plugin "gamecms_gagmanager.amxx", version "2.2.3")
L 02/14/2021 - 14:48:56: [AMXX] Run time error 4: index out of bounds
L 02/14/2021 - 14:48:56: [AMXX] [0] gamecms_stocks.inl::CvarsToArray (line 145)
L 02/14/2021 - 14:48:56: [AMXX] [1] gamecms_gagmanager.sma::OnConfigsExecuted (line 205)
L 02/14/2021 - 14:48:56: [AMXX] Displaying debug trace (plugin "gamecms_gagmanager.amxx", version "2.2.3")
L 02/14/2021 - 14:48:56: [AMXX] Run time error 4: index out of bounds
L 02/14/2021 - 14:48:56: [AMXX] [0] gamecms_stocks.inl::CvarsToArray (line 145)
L 02/14/2021 - 14:48:56: [AMXX] [1] gamecms_gagmanager.sma::OnConfigsExecuted (line 205)
- Список плагинов (amx_plugins)
- Currently loaded plugins:
name version author file status
[ 1] GameCMS_API 5.4.9 zhorzh78 gamecms_api.amx running
[ 2] Lite Bans 2.2 neygomon lite_bans.amxx running
[ 3] GameCMS_GagManager 2.2.3 zhorzh78 gamecms_gagmana debug
[ 4] [ReAPI] Admin Loader 3.5 neygomon admin_loader.am running
[ 5] ReAimDetector API 0.2.2 ReHLDS Team reaimdetector.a running
[ 6] AuthEmu API 1.0 Dev-MS Team authemu.amxx running
[ 7] Map Manager 2.5.61 Mistrick mapmanager.amxx running
[ 8] Admin Commands 1.9.0.5271 AMXX Dev Team admincmd.amxx running
[ 9] Maps Menu 1.4.1 neugomon maps_menu.amxx running
[ 10] [ReAPI] Weapon Restric 2.1 s1lent/neugomon weaponrest.amxx running
[ 11] [ReAPI] Players Menu 1.7 neugomon players_menu.am running
[ 12] Menus Front-End 1.5 neugomon menufront_end.a running
[ 13] CSStatsX SQL 0.7.4+2 serfreeman1337 csstatsx_sql.am running
[ 14] AES: StatsX 0.5.9 serfreeman1337/s aes_statsx_cstr running
[ 15] AES: StatsX Info Rank 0.1 serfreeman1337 aes_statsx_rank running
[ 16] Advanced Kill Assists 1.3c Xelson advanced_kill_a running
[ 17] StatsX: Colored Bandar 0.1-2a Garey statsx_bandarm. running
[ 18] Stats Configuration 1.9.0.5271 AMXX Dev Team statscfg.amxx running
[ 19] [ReAPI] Say me and hp 1.4 neygomon sayme.amxx running
[ 20] [ReAPI] Random Weapons 2.4.9 neugomon/h1k3 random_weapons_ running
[ 21] GameCMS BonusSystem 1.1 DUKKHAZ0R gamecms_bonus.a running
[ 22] GameCMS Sorry Addon 1.0 neygomon gamecms_sorry.a running
[ 23] Health Grenade 1.1 ill | Radius health_grenade. running
[ 24] VIP Menu 1.4 neugomon | Radiu vip_system.amxx running
[ 25] Lite Admin ESP 1.0 neygomon admin_esp.amxx running
[ 26] Advert Messages 1.1.0 ArKaNeMaN AdvertMessages. running
[ 27] [ReAPI] AWP OFF 1.4.3 PAffAEJIkA :3 awp_off.amxx running
[ 28] [ReAPI] AFK Control 1.4.1 [Rnd neygomon afk_control.amx running
[ 29] DemoRecoder 1.1 neygomon amx_demorec.amx running
[ 30] Kills Counter 0.3 serfreeman1337 kills_counter.a running
[ 31] [ReAPI] Block Advert 1.4 neygomon block_all_avder running
[ 32] Block grande info 1.0 neygomon block_grenade_i running
[ 33] Blue Screen 1.3.4 Stimul | Radius blue_screen.amx running
[ 34] C4 Timer on roundtime 0.3.3a neygomon c4timer.amxx running
[ 35] [ReAPI] Custom Models 1.6.1 neugomon custom_models.a running
[ 36] [ReAPI] Simple Damager 2.1.0 fl0wer simple_damager. running
[ 37] [ReAPI] Silly C4 2.0 F@ntoM/Cheap_Sui sillyc4.amxx running
[ 38] FM ResetScore 0.1 neygomon fm_rs.amxx running
[ 39] [ReAPI] First Kills Sy 1.2 MakapoH. first_kills_sys running
[ 40] [ReAPI] Flash Control 1.1 neugomon flash_control.a running
[ 41] [ReAPI] GameName Chang 1.0 neugomon gamename_change running
[ 42] Kill Sound 1.0 Radius kill_sound.amxx running
[ 43] VoteBan Menu 1.1 ApXuTekToR VoteBan_Menu.am running
[ 44] [ReAPI] Parachute 1.1 ReHLDS Team parachute.amxx running
[ 45] Ping Control 1.31 neygomon ping_control.am running
[ 46] Plugins Controller 1.0 neygomon plugins_control stopped
[ 47] [ReAPI] Hint Blocker 0.1.0 F@tn0M reapi_hint_bloc running
[ 48] [ReAPI] Round Balancer 1.1 neygomon round_balancer. running
[ 49] [ReAPI] Steam Bonus 1.2 neygomon bonus_steam.amx running
[ 50] [ReAPI] Top Awards 1.0 neygomon top_awards.amxx running
[ 51] Win Messages 1.0 neygomon win_messages.am running
[ 52] Chat Manager 1.1.2-16 Mistrick chatmanager.amx running
52 plugins, 51 running
- Список модулей (meta list)
- Currently loaded plugins:
description stat pend file vers src load unload
[ 1] SafeNameAndChat RUN - SafeNameAndChat.so v1.1 ini ANY ANY
[ 2] Reunion RUN - reunion_mm_i386.so v0.1.92d ini Start Never
[ 3] ReAuthCheck RUN - reauthcheck_mm_i386.so v0.1.6 ini Start Never
[ 4] VoiceTranscoder RUN - VoiceTranscoder.so v2017RC5 ini ANY ANY
[ 5] AMX Mod X RUN - amxmodx_mm_i386.so v1.9.0.5271 ini Start ANY
[ 6] Rechecker RUN - rechecker_mm_i386.so v2.5 ini Chlvl ANY
[ 7] ReSRDetector RUN - resrdetector_mm_i386.so v0.1.0 ini Chlvl ANY
[ 8] WHBlocker RUN - whblocker_mm_i386.so v1.5.697 ini Chlvl ANY
[ 9] ReSemiclip RUN - resemiclip_mm_i386.so v2.3.9 ini Chlvl ANY
[10] AuthEmu RUN - authemu_amxx_i386.so v5.2.12.425-dev pl5 ANY Never
[11] CStrike RUN - cstrike_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
[12] Engine RUN - engine_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
[13] FakeMeta RUN - fakemeta_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
[14] Fun RUN - fun_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
[15] Ham Sandwich RUN - hamsandwich_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
[16] MySQL RUN - mysql_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
[17] ReAimDetector RUN - reaimdetector_amxx_i386.so v0.2.2 pl5 ANY Never
[18] ReAPI RUN - reapi_amxx_i386.so v5.19.0.211-dev pl5 ANY Never
[19] SQLite RUN - sqlite_amxx_i386.so v1.9.0.5271 pl5 ANY ANY
19 plugins, 19 running