Extended Stats 0.1.4

A plugin for collecting game statistics with database support, compatible with both SQL and web API methods.

This functionality empowers website owners to display the desired statistics from the database on their sites. Moreover, it offers the capability to send data via API, which proves highly beneficial in scenarios where your gaming server and database reside on separate machines and the database restricts connections beyond localhost.

Please note that an instruction manual will be included in the downloaded file and it is imperative for users to read it thoroughly.

• Collecting(The full list is available below in the section Collected Data) :
  • Server information;
  • Team information;
  • Clan information(in future);
  • Feedback(F7) information;
  • Report(F7) information;
  • Player information.
• Sending data through:
  • direct MySQL;
  • via API(POST query) to MySQL.

{
  "Unique ID of the current server": 0,
  "Database upload method. 0 - disabled, 1 - via API, 2 - via MySQL": 1,
  "Interval in seconds at which an attempt to load changes into the database will occur": 300.0,
  "Is it worth logging messages to the console when uploading to the database?": true,
  "API - Service URL": "https://site.com/ExtendedStats/index.php",
  "API - Service access key": "GlBRw-elM6v-gjko3-cxSDk-Tsy7B",
  "MySQL - Host": "localhost",
  "MySQL - Port": 3306,
  "MySQL - Database name": "db_playrust",
  "MySQL - Username": "root",
  "MySQL - Password": "root",
  "Database table name - Servers": "db_servers",
  "Database table name - Teams": "db_teams",
  "Database table name - Clans": "db_clans",
  "Database table name - Feedbacks": "db_feedbacks",
  "Database table name - Reports": "db_reports",
  "Database table name - Players": "db_players",
  "Database table name - Players Balances": "db_players_balances",
  "Database table name - Players Stats": "db_players_stats",
  "Database table name - Players Farms": "db_players_farms",
  "Database table name - Players Gambling": "db_players_gambling",
  "Database table name - Players Kills": "db_players_kills",
  "Database table name - Players Explosions": "db_players_explosions",
  "Database table name - Players Raids": "db_players_raids",
  "Is it worth clearing saved statistics when a wipe is detected?": true,
  "Is it worth clearing the database when a wipe is detected?": true,
  "List of statistic categories to clear when a wipe is detected. Leave empty to recreate defaults": [
    "players",
    "teams",
    "clans",
    "feedbacks",
    "reports"
  ],
  "Dictionary of display names for deployable entities by key": {},
  "Wipe ID": null,
  "Version": {
    "Major": 0,
    "Minor": 1,
    "Patch": 4
  }
}

• ServerData:
  • ServerName
  • ServerIdentity
  • ServerIP
  • ServerPort
  • QueryPort
  • ServerDescription
  • ServerHeader
  • ServerURL
  • ServerTime
  • ServerTags
  • GameTags
  • MaxPlayers
  • ServerEntities
  • ServerFPS
  • ServerAvgFPS
  • ServerUptime
  • ServerMap
  • MapSize
  • MapSeed
  • FirstSave
  • LastSave
  • WipeID
  • ServerVersion
  • ServerProtocol
  • RconPort
  • RconPassword
• TeamData:
  • TeamID
  • TeamName
  • CreatorID
  • LeaderID
  • TeamMembers
• ClanData(Temporarily not working) :
  • ClanID
  • ClanName
  • CreatorID
  • LeaderID
  • ClanMembers
• FeedbackData(Since the corresponding Oxide hook has shifted, not all types of feedback are processed) :
  • ID
  • UserID
  • Subject
  • Type
  • Message
  • Time
• ReportData:
  • ID
  • UserID
  • TargetID
  • TargetName
  • Subject
  • Type
  • Message
  • Time
• PlayerData:
  • Info:
    • UserID
    • DisplayName
    • Flags
    • Language
    • GroupsList
    • TeamID
    • ClanID
    • BanReason
  • Connection:
    • PlayedTime - requires the PlaytimeTracker/PlayTimeRewards plugins
    • IdleTime - requires the PlaytimeTracker/PlayTimeRewards plugins
    • Connections
    • Ping
    • FirstConnectionIP
    • LastConnectionIP
    • FirstConnectionDate
    • LastConnectionDate
  • Balance:
    • Balance - requires the Economics plugin
    • BankBalance - requires the BankSystem plugin
    • Points - requires the ServerRewards plugin
    • Experience
    • Reputation - requires the ReputationMaster plugin
  • Statistics:
    • TimeAlive - updates only after the player's death
    • TimeSleeping - updates only after the player's death
    • DistanceWalked - updates only after the player's death
    • DistanceRun - updates only after the player's death
    • TimeWilderness - updates only after the player's death
    • TimeInBase - updates only after the player's death
    • TimeInMonument - updates only after the player's death
    • TimeSwimming - updates only after the player's death
    • TimeFlying - updates only after the player's death
    • TimeBoating - updates only after the player's death
    • TimeDriving - updates only after the player's death
    • Wounded
    • WoundsInflicted
    • WoundAssisted
    • WoundRecovered
    • DamageInflicted
    • DamageTaken - updates only after the player's death
    • Healed - updates only after the player's death
    • ShotsFired - updates only after the player's death
    • ShotsHit
    • ExcavatorStarts
    • BearTrapInflicted
    • BearTrapSteps
    • MineInflicted
    • MineSteps
    • HandcuffsApplied
    • Handcuffed
    • PhoneCalls
    • PhoneCallsTimeout
    • MissionsStarted
    • MissionsSucceeded
    • MissionsFailed
  • DeployedsList
  • MonumentsList - requires the MonumentsWatcher plugin
  • Farming:
    • Barrels
    • UnderWaterCrates
    • ShreddedEntities
    • DetectResourceFlags
    • GreenDoors
    • BlueDoors
    • RedDoors
    • FishAttempts
    • Guts
    • Supplies
    • ExcavatorSupplies
    • Chinooks
    • Surveys
    • ChickensHatched
    • ChickenEggs
    • BeehiveXP
  • Blueprints
  • CraftList
  • GatherList
  • RecycleList
  • BuyerPurchaseList
  • BuyerSpentList
  • SellerSalesList
  • SellerRevenueList
  • CratesList
  • FishList
  • Gambling:
    • BWG_Spins
    • BWG_WinSpins
    • BWG_SpendScraps
    • BWG_WinScraps
    • Slot_Spins
    • Slot_WinSpins
    • Slot_SpendScraps
    • Slot_WinScraps
    • Poker_Games - Placeholder
    • Poker_WinGames - Placeholder
    • Poker_SpendScraps - Placeholder
    • Poker_WinScraps - Placeholder
    • BlackJ_Games
    • BlackJ_WinGames
    • BlackJ_StandoffGames
    • BlackJ_SpendScraps
    • BlackJ_WinScraps
    • RPS_Wins
    • RPS_Losses
    • RPS_Draws
  • Kills:
    • Kills
    • FriendlyKills
    • Deaths
    • Suicides
    • Beehives
    • Chickens
    • FarmChickens
    • Snakes
    • Boars
    • Stags
    • Horses
    • Wolves
    • Bears
    • Polarbears
    • Panthers
    • Tigers
    • Crocodiles
    • Sharks
    • PlayerNPCs
    • Scientists
    • Zombies
    • Patrols
    • Bradleys
  • KillVehicles:
    • PedalBikes
    • MotorBikes
    • Cars
    • RowBoats
    • RHIBs
    • SubmarinesSolo
    • SubmarinesDuo
    • Tugs
    • MiniHelis
    • AttackHelis
    • ScrapHelis
    • Balloons
    • Trains
    • TrainWagons
    • TrainCabooses
    • Snowmobiles
    • Ballistas
    • BatteringRams
    • Catapults
    • SiegeTowers
  • HitParts
  • KillParts
  • KillWeapons
  • Explosions:
    • Rockets
    • RocketsHV
    • RocketsIncendiary
    • RocketsSmoke
    • RocketsMissile
    • RocketsMLRS
    • Torpedoes
    • ExplosiveAmmo
    • Ammo40mmExplosive
    • Ammo40mmSmoke
    • GrenadesF1
    • GrenadesMolotov
    • GrenadesFlash
    • GrenadesSmoke
    • GrenadesBean
    • SatchelCharges
    • C4Explosives
    • PropaneBombs
    • FireBombs
  • Raids:
    • Cupboards
    • Doors
    • Windows
    • Foundations
    • Ceilings
    • Walls
    • Doorways
    • WindowFrames
    • Stairs
    • Hatches
    • ExtWoodenGates
    • ExtWoodenWalls
    • ExtStoneGates
    • ExtStoneWalls
    • ExtIceWalls
    • ExtIceShortWalls
  • RaidedConstructionsList
  • RaidedDeployableConstructionsList
  • RaidableBases:
    • RBEasy
    • RBMedium
    • RBHard
    • RBExpert
    • RBNightmare