⭐Player Stats

⭐ This plugin is private! Can be purchased on our Discord Marketplace.

It is used to display player statistics from any CSS or Metamod plugin that stores player stats in a MySQL database (Players do not need to be connected on the CS2 server). You can view these statistics on the Discord server using the Slash command or by clicking the button under Server Status / Server Status Plus / Reports. You can fetch statistics from all your servers, so if you have multiple servers with stats stored in different databases, you can choose which server's stats to display when using the Slash Command.

The plugin includes extensive configuration options where you can adjust and set which database tables to pull data from, which columns to store, search by player Names or SteamIDs, customize response messages, and much more.

⚠️You only need to have this plugin installed on one server! Do not upload this plugin to multiple servers if you use the same BOT on each server!

Config Preview

{
  "Discord Command Data": {
    "Command Name": "stats",
    "Command Description": "Display player statistics",
    "Server Option Name": "server",
    "Server Option Description": "Which server to take statistics from",
    "Search By Name Option": {
      "Enabled": true,
      "PlayerName Option Name": "name",
      "PlayerName Option Description": "Player\u0027s name"
    },
    "Search By SteamID Option": {
      "Enabled": true,
      "PlayerSteamID Option Name": "steamid",
      "PlayerSteamID Option Description": "Player\u0027s SteamID"
    },
    "Search By Discord User Option": {
      "Enabled": true,
      "DiscordUser Option Name": "user",
      "DiscordUser Option Description": "Player\u0027s Discord Name"
    }
  },
  "Servers List": {
    "Public": {
      "Database": {
        "Host": "",
        "Port": 3306,
        "User": "",
        "Database": "",
        "Password": ""
      },
      "Tables": {
        "zenith_player_storage": {
          "SteamIdColumn": "steam_id",
          "NameColumn": "name",
          "StoredData": [
            "steam_id",
            "name",
            "last_online"
          ],
          "StoredDataJSON": {
            "K4-Zenith-Ranks.storage": [
              "Rank",
              "Points"
            ],
            "K4-Zenith-Stats.storage": [
              "Kills",
              "Deaths",
              "Assists",
              "MVP",
              "Headshots",
              "Shoots",
              "HitsGiven",
              "HitsTaken",
              "HeadHits",
              "NeckHits",
              "ChestHits",
              "LeftArmHits",
              "LeftLegHits",
              "StomachHits",
              "RightArmHits",
              "RightLegHits"
            ]
          },
          "StoredDataMultipleLines": {}
        },
        "zenith_weapon_stats": {
          "SteamIdColumn": "steam_id",
          "NameColumn": "",
          "StoredData": [],
          "StoredDataJSON": {},
          "StoredDataMultipleLines": {
            "weapon": {
              "ak47": [
                "kills",
                "headshots",
                "shots"
              ],
              "awp": [
                "kills",
                "headshots",
                "shots"
              ],
              "deagle": [
                "kills",
                "headshots",
                "shots"
              ],
              "m4a1": [
                "kills",
                "headshots",
                "shots"
              ],
              "m4a1_silencer": [
                "kills",
                "headshots",
                "shots"
              ],
              "m4a1-s": [
                "kills",
                "headshots",
                "shots"
              ]
            }
          }
        }
      }
    },
    "Only Mirage": {
      "Database": {
        "Host": "",
        "Port": 3306,
        "User": "",
        "Database": "",
        "Password": ""
      },
      "Tables": {
        "zenith_player_storage": {
          "SteamIdColumn": "steam_id",
          "NameColumn": "name",
          "StoredData": [
            "steam_id",
            "name",
            "last_online"
          ],
          "StoredDataJSON": {
            "K4-Zenith-Ranks.storage": [
              "Rank",
              "Points"
            ],
            "K4-Zenith-Stats.storage": [
              "Kills",
              "Deaths",
              "Assists",
              "MVP",
              "Headshots",
              "Shoots",
              "HitsGiven",
              "HitsTaken",
              "HeadHits",
              "NeckHits",
              "ChestHits",
              "LeftArmHits",
              "LeftLegHits",
              "StomachHits",
              "RightArmHits",
              "RightLegHits"
            ]
          },
          "StoredDataMultipleLines": {}
        },
        "zenith_weapon_stats": {
          "SteamIdColumn": "steam_id",
          "NameColumn": "",
          "StoredData": [],
          "StoredDataJSON": {},
          "StoredDataMultipleLines": {
            "weapon": {
              "ak47": [
                "kills",
                "headshots",
                "shots"
              ],
              "awp": [
                "kills",
                "headshots",
                "shots"
              ],
              "deagle": [
                "kills",
                "headshots",
                "shots"
              ],
              "m4a1": [
                "kills",
                "headshots",
                "shots"
              ],
              "m4a1_silencer": [
                "kills",
                "headshots",
                "shots"
              ],
              "m4a1-s": [
                "kills",
                "headshots",
                "shots"
              ]
            }
          }
        }
      }
    }
  },
  "Response Embeds": {
    "Stats Found": {
      "Silent Response": true,
      "Content": "",
      "Title": "Statistics of player {name}",
      "Description": "\u003E \uD83C\uDF96\uFE0F Rank: \u0060{JSON_Rank}\u0060 (\u0060{JSON_Points}\u0060 Points)\n\u003E \uD83D\uDCC5 Last connection: \u0060{last_online}\u0060\n\n ",
      "Fields": "\u003E \uD83C\uDFAE Game Stats;-# Total Kills: \u0060{JSON_Kills}\u0060\n-# Total Deaths: \u0060{JSON_Deaths}\u0060\n-# Total Headshots: \u0060{JSON_Headshots}\u0060\n-# Total Assists: \u0060{JSON_Assists}\u0060\n-# Total Shoots: \u0060{JSON_Shoots}\u0060;true|\u003E \uD83D\uDD2B Weapon Stats;**AK47** - \u0060{ak47_kills}\u0060 Kills (\u0060{ak47_headshots}\u0060 HS)\n**M4A4** -\u0060{m4a1_kills}\u0060 Kills (\u0060{m4a1_headshots}\u0060 HS);true|\u003E \uD83C\uDFAF Hits (Given: {JSON_HitsGiven} / Taken: {JSON_HitsTaken});-# Head: \u0060{JSON_HeadHits}\u0060\n-# Neck: \u0060{JSON_NeckHits}\u0060\n-# Chest: \u0060{JSON_ChestHits}\u0060\n-# Stomach: \u0060{JSON_StomachHits}\u0060\n-# Left Arm: \u0060{JSON_LeftArmHits}\u0060\n-# Right Arm: \u0060{JSON_RightArmHits}\u0060\n-# Left Leg: \u0060{JSON_LeftLegHits}\u0060\n-# Right Leg: \u0060{JSON_RightLegHits}\u0060;false",
      "Thumbnail": "",
      "Image": "",
      "HEX Color": "#00ccff",
      "Footer": "",
      "Footer Timestamp": false
    },
    "Multiple Matches Found": {
      "Silent Response": true,
      "Content": "",
      "Title": "",
      "Description": "\u003E More results were found for \u0060{VALUE}\u0060 value on server \u0060{SERVER}\u0060!\n\n\u003E \u2B07\uFE0F Select a player from the list below \u2B07\uFE0F",
      "Fields": "",
      "Thumbnail": "",
      "Image": "",
      "HEX Color": "#ff9933",
      "Footer": "",
      "Footer Timestamp": false,
      "Stats Found": {
        "Select Menu Name": "Select a player",
        "Select Menu Format": "{name}",
        "Select Menu Description Format": "{steam_id}",
        "Select Menu Emoji": ""
      }
    },
    "Stats Not Found": {
      "Silent Response": true,
      "Content": "",
      "Title": "",
      "Description": "\u003E No results were found for the specified value \u0060{VALUE}\u0060!",
      "Fields": "",
      "Thumbnail": "",
      "Image": "",
      "HEX Color": "#ff8000",
      "Footer": "",
      "Footer Timestamp": false
    },
    "Invalid Search Format": {
      "Silent Response": true,
      "Content": "",
      "Title": "",
      "Description": "\u003E The entered value \u0060{VALUE}\u0060 is not in a valid format!",
      "Fields": "",
      "Thumbnail": "",
      "Image": "",
      "HEX Color": "#ff3333",
      "Footer": "",
      "Footer Timestamp": false
    },
    "Player Is Not Linked": {
      "Content": "",
      "Title": "",
      "Description": "\u003E User \u003C@{DiscordUser.ID}\u003E does not have an account linked to steam!",
      "Fields": "",
      "Thumbnail": "",
      "Image": "",
      "HEX Color": "#ff6666",
      "Footer": "",
      "Footer Timestamp": false
    },
    "Invalid Format": {
      "Content": "",
      "Title": "",
      "Description": "\u003E Invalid Format! You must complete one of the options!",
      "Fields": "",
      "Thumbnail": "",
      "Image": "",
      "HEX Color": "#ff6666",
      "Footer": "",
      "Footer Timestamp": false
    }
  },
  "Search Player Modal": {
    "Modal Name": "Search Player Stats",
    "Value Label": "Insert player name",
    "Value Min Length": 3,
    "Value Max Length": 32
  },
  "ConfigVersion": 1
}

Configuration

Since the setup is very complicated to explain, so if you want to edit or create a config for your stats create a ticket on our Discord server.

To edit the embeds, follow the instructions: Custom Embeds Format

Available Variables for Stats Found

• Names of all columns in StoredData So for example, if you have stored name, kills, deaths in StoredData you can use {name} , {kills} and {deaths} as variables. • {VALUE} > The value that was searched for • {SERVER} > The name of the selected server

Available Variables for Multiple Matches Found / Stats Not Found and Invalid Search Format

• {VALUE} > The value that was searched for • {SERVER} > The name of the selected server