OFP MP Games history

Archive of snapshots of all servers reported to master.ofpisnotdead.com done each 30 seconds starting 6. January 2021 until 5. June 2021.

It is SQLite database with two columns - "time" and "data" (JSON payload).

How to use this?

Download following file, use xz tool to extract to ofp-mp-games.db file and open with any SQLite client.

ofp-mp-games.db.xz

Here's example using official sqlite client CLI.

sqlite3 ofp-mp-games.db

sqlite> .schema ofp_games
CREATE TABLE ofp_games (
        time int,
        data blob
      );

sqlite> SELECT * FROM ofp_games LIMIT 1;

1609899707|{"213.175.54.194:2322":{"gamename":"opflashr","gamever":"1.96","groupid":"261","hostname":"[CZ] MOR Czechoslovak (@DVD, @80_Islands, @csec_server)","hostport":"2322","mapname":"","gametype":"","numplayers":"0","maxplayers":"66","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"196","reqver":"196","mod":"RES;@DVD;@80_Islands","equalModRequired":"0","password":"1","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.015971606597304344},"89.163.140.196:4500":{"gamename":"opflashr","gamever":"1.96","groupid":"261","hostname":"##[K-TTT]WW4 public coop server (RECON addons)","hostport":"4500","mapname":"","gametype":"","numplayers":"0","maxplayers":"38","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"55","actver":"196","reqver":"196","mod":"RES;@recon;@reconextra1;@jam3;@isles;@ww4mod25","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"linux","players":[],"replied_in":0.0191394267603755},"89.163.140.196:5000":{"gamename":"opflashr","gamever":"1.96","groupid":"261","hostname":"##[K-TTT]CTI|xrofp+ww4full","hostport":"5000","mapname":"","gametype":"","numplayers":"0","maxplayers":"38","gamemode":"openplaying","timeleft":"0","param1":"9","param2":"1311","actver":"196","reqver":"196","mod":"RES;@xrofp+ww4full","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"linux","players":[],"replied_in":0.019627504982054234},"135.181.162.169:2202":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"{KG}100 RAD Community","hostport":"2202","mapname":"","gametype":"","numplayers":"0","maxplayers":"26","gamemode":"openplaying","timeleft":"0","param1":"10","param2":"9","actver":"199","reqver":"199","mod":"RES;@dvdcrcti1.79;@80+Islands1.3;@wintercti7;@sons;@res-z","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.03446851018816233},"185.102.190.8:4000":{"gamename":"opflashr","gamever":"2.01","groupid":"261","hostname":"[PR MOD] WWW.PRMOD.COM.PL","hostport":"4000","mapname":"","gametype":"","numplayers":"0","maxplayers":"18","gamemode":"openplaying","timeleft":"0","param1":"4","param2":"12","actver":"201","reqver":"201","mod":"@PRMOD","equalModRequired":"1","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.03648278955370188},"79.17.73.221:2302":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"KASKAD BF Server - https://discord.gg/tCMuwQRA8T","hostport":"2302","mapname":"","gametype":"","numplayers":"0","maxplayers":"32","gamemode":"openplaying","timeleft":"0","param1":"1200","param2":"3","actver":"199","reqver":"199","mod":"RES","equalModRequired":"1","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.0392509875819087},"213.171.57.81:52317":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"EASY_BOH https://silion.ru/@BOH.rar","hostport":"52317","mapname":"","gametype":"","numplayers":"0","maxplayers":"22","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"199","reqver":"199","mod":"RES;@BOH","equalModRequired":"1","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.043164219707250595},"135.181.162.169:2102":{"gamename":"opflashr","gamever":"1.96","groupid":"261","hostname":"{KG}100 RAD Community","hostport":"2102","mapname":"","gametype":"","numplayers":"0","maxplayers":"26","gamemode":"openplaying","timeleft":"0","param1":"1800","param2":"5","actver":"196","reqver":"196","mod":"RES;@dvdcrcti1.79;@80+Islands1.3;@wintercti7;@sons;@res-z","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.042302483692765236},"213.171.57.81:52305":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"EASY_SovNoe  https://yadi.sk/d/8SEGdiYZA7YVlw","hostport":"52305","mapname":"","gametype":"","numplayers":"0","maxplayers":"22","gamemode":"openplaying","timeleft":"0","param1":"1","param2":"4","actver":"199","reqver":"199","mod":"RES;@sovnoe","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.044095294550061226},"213.171.57.81:52311":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"EASY_WW2  https://silion.ru/@WW2_MP.7z","hostport":"52311","mapname":"","gametype":"","numplayers":"0","maxplayers":"22","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"199","reqver":"199","mod":"RES;@WW2_MP","equalModRequired":"1","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.04537756647914648},"109.238.81.81:2302":{"gamename":"opflashr","gamever":"1.96","groupid":"261","hostname":"PioneerNet CTI Server","hostport":"2302","mapname":"","gametype":"","numplayers":"0","maxplayers":"20","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"196","reqver":"196","mod":"RES;@80islands;@cti;@winter;@resv","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"linux","players":[],"replied_in":0.04665664490312338},"89.178.1.142:2302":{"gamename":"opflashr","gamever":"2.01","groupid":"261","hostname":"[USSR] 'PHOBOS' | bit.ly/ares201","hostport":"2302","mapname":"","gametype":"","numplayers":"0","maxplayers":"32","gamemode":"openplaying","timeleft":"0","param1":"2","param2":"2","actver":"201","reqver":"201","mod":"","equalModRequired":"1","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.050552344880998135},"194.87.232.94:2302":{"gamename":"opflashr","gamever":"2.01","groupid":"261","hostname":"WW4 v2.01 vk.com/FOXHOUND_server","hostport":"2302","mapname":"","gametype":"","numplayers":"0","maxplayers":"34","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"201","reqver":"201","mod":"@ww4mod25;@TSQ","equalModRequired":"1","password":"1","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.05374989192932844},"89.178.1.142:2305":{"gamename":"opflashr","gamever":"2.01","groupid":"261","hostname":"[USSR] 'DEIMOS' | bit.ly/ussr_deimos | TZK 4.0.5","hostport":"2305","mapname":"","gametype":"","numplayers":"0","maxplayers":"17","gamemode":"openplaying","timeleft":"0","param1":"1","param2":"4","actver":"201","reqver":"201","mod":"@tzk_4.0.5;@tzk_islands","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.05547093227505684},"213.171.57.81:52302":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"EASY_SERVER https://silion.ru/@MFTZK.7z","hostport":"52302","mapname":"","gametype":"","numplayers":"0","maxplayers":"24","gamemode":"openplaying","timeleft":"0","param1":"20","param2":"1212","actver":"199","reqver":"199","mod":"RES;@MFTZK","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.05652166064828634},"173.208.203.130:2332":{"gamename":"opflashr","gamever":"2.01","groupid":"261","hostname":"TuPaS Team | bit.ly/TUPASTEAM","hostport":"2332","mapname":"","gametype":"","numplayers":"0","maxplayers":"22","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"201","reqver":"201","mod":"@TuPaS","equalModRequired":"1","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.13218986336141825},"96.89.191.129:2302":{"gamename":"opflashr","gamever":"1.96","groupid":"261","hostname":"CGS OFP Server","hostport":"2302","mapname":"","gametype":"","numplayers":"0","maxplayers":"66","gamemode":"openplaying","timeleft":"0","param1":"1","param2":"0","actver":"196","reqver":"196","mod":"RES","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.1430590394884348},"73.83.252.207:2305":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"BBQ Bob's SLC2A | Public Dev | Addons: http://solaria5web.dyndns.org/bbq.html","hostport":"2305","mapname":"","gametype":"","numplayers":"0","maxplayers":"10","gamemode":"openplaying","timeleft":"0","param1":"0","param2":"0","actver":"199","reqver":"199","mod":"RES;@SLC2A;@MFCTI116;@EditorUpdate","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.18647969793528318},"73.83.252.207:2302":{"gamename":"opflashr","gamever":"1.99","groupid":"261","hostname":"BBQ Bob's Inferno | Over 500 classic maps | Addons: http://solaria5web.dyndns.org/bbq.html","hostport":"2302","mapname":"","gametype":"","numplayers":"0","maxplayers":"10","gamemode":"openplaying","timeleft":"0","param1":"1","param2":"8","actver":"199","reqver":"199","mod":"RES;@Desert;@RNServer;@ctitc6;@EditorUpdate","equalModRequired":"0","password":"0","gstate":"2","impl":"sockets","platform":"win","players":[],"replied_in":0.1995158502832055}}

In data column, there is JSON having server IP and port as a keys and data snapshot as a value.

Example server snapshot

{
   "gamename":"opflashr",
   "gamever":"1.96",
   "groupid":"261",
   "hostname":"[CZ] MOR Czechoslovak (@DVD, @80_Islands, @csec_server)",
   "hostport":"2322",
   "mapname":"",
   "gametype":"",
   "numplayers":"0",
   "maxplayers":"66",
   "gamemode":"openplaying",
   "timeleft":"0",
   "param1":"0",
   "param2":"0",
   "actver":"196",
   "reqver":"196",
   "mod":"RES;@DVD;@80_Islands",
   "equalModRequired":"0",
   "password":"1",
   "gstate":"2",
   "impl":"sockets",
   "platform":"win",
   "players":[

   ],
   "replied_in":0.015971606597304344
}