Aces High Bulletin Board

Special Events Forums => Friday Squad Operations => Topic started by: steely07 on July 25, 2026, 08:08:14 PM

Title: Announcing - FSOStats application - Get your whole FSO History!
Post by: steely07 on July 25, 2026, 08:08:14 PM
FSO Stats — eighteen years of Friday nights, in a database

The logs have been sitting on ahevents.net since 2008, one frame at a time. Reading them is an afternoon's work; I got tired of that, so here's a desktop app that scrapes the lot into SQLite and puts a grid on top. Pilot careers, squad histories, frame detail, leaderboards — a couple of clicks instead of forty browser tabs.

The reason it exists is head-to-head. An FSO log names both parties on every shootdown, which means your record against any one opponent is recoverable — across all eighteen years. Pick a name and every engagement between you is there: which way it went, which frame, what was lost. Settle it once and for all, or find out you'd rather not have looked.

A few things that fell out of 590,741 log entries, 656 frames, 4,161 pilots:

   
Most career kills   AKWarHwk — 1,364 over 304 frames
Best rate (200+ kills)   2cmex — 6.01 K/D
Iron men   Dantoo 541 frames, then Steely on 540, both since Jun 2009
Bitterest rivalry   AKWarHwk over JoeJoe, 33 kills. SNO over RedBrd, also 33
Bloodiest frame ever   Leyte 1944, F3 — 749 kills



35 pilots who flew in 2009 were still turning up in 2026, which tells you something about this community.

One honest note before anyone quotes a number at me: frame kill counts include gunners. That's why 49MERLIN's 47-kill frame in the Leyte fight looks inhuman — he was sitting on ship and field guns. The app doesn't hide that sort of thing, it surfaces it. Side labels are inferred from the aircraft flown (the log's own labels can't be trusted), shootdowns are written twice and de-duped, 73 events never rendered at all. It's a hand-kept record and it shows; FINDINGS.md documents every bit of it if you're the sort who checks.

Getting it running

1. Download. Grab FSOStats.exe from the releases page — 47 MB, and that's everything. No Python, no installer, no dependencies. Put it wherever you like and double-click it.

Defender may flag it as a false positive on first run. Same PyInstaller single-exe heuristic as ever, not the app doing anything; restore it from quarantine, or build from source — the code's all in the repo.

2. There is no sync. The database ships inside the exe, already filled: every FSO frame from August 2008 to August Storm Frame 3 on 24 July 2026, which is last Friday. 583 frames with logs across 201 campaigns, 590,741 log entries, 4,161 pilots. You don't fetch any of it, and you don't need to be online to use the app.

First launch shows a brief splash while it unpacks that database into %LOCALAPPDATA%\FSOStats — a few seconds, once. Every launch after that is instant.

3. Keeping it current. The Update button sits at the bottom right. It reads the ahevents.net listing, works out which frames it hasn't got, and fetches only those. After a Friday that's one or two pages — a minute at most. It's rate-limited on purpose; ahevents is a small community site and this isn't worth hammering it for.

Because the database lives in your own AppData rather than inside the exe, your updates stick. Dropping in a newer version of the exe later won't throw away what you've fetched.

4. Look at it. The Frames tab lists every frame; the toggle switches it to Campaigns if you'd rather think in three-frame events, which is how they were actually flown. Click any frame to see both teams, which side each actually fought for, and every pilot's result.

Pilot gives a career: totals, aircraft flown with a real per-type K/D, every frame, and a kills-per-year trend. Squad does the same for a unit. Leaderboards are all-time totals beside podium finishes.

And Head-to-head is the one nothing else can do — pick a pilot, pick an opponent, and get every engagement between the two of them across eighteen years, which way each went and what was lost.

Every grid sorts on a left-click, filters on a right-click, and exports to CSV.
Companion to AHStats (main-arena tour stats) — separate post for that one.

https://github.com/steelington/FSOStats (https://github.com/steelington/FSOStats)

(https://i.imgur.com/pbmwWky.png)

(https://i.imgur.com/7BTVwxA.png)

(https://i.imgur.com/tdVT53P.png)

(https://i.imgur.com/y7an8SW.png)

(https://i.imgur.com/8e2QuHG.png)

(https://i.imgur.com/ZWoER9p.png)

(https://i.imgur.com/QfSA1xS.png)

Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: xanax on July 25, 2026, 10:55:40 PM
Amazing, Steely. Thanks for the effort!
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: Bolt on July 26, 2026, 07:25:06 AM
Very cool, thanks!  :cheers: :salute
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: fudgums on July 26, 2026, 08:40:25 AM
Really cool tool - First sortie for me was June 2009(Think I was in FSO in 2008 but may be one of those that don't show any longer).

Apparently flew a month with 9th Giap in 2009, completely forgotten.

Sad to type in old names to see when the last time they were playing.

Thank you for the tool
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: Frodo on July 26, 2026, 02:30:09 PM
Thanks Steely  :salute

Something like this has been needed for a long time.
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: steely07 on July 26, 2026, 05:18:13 PM
You're all welcome, if anyone has ideas for features I didn't think of, feel free to ask, happy to add stuff!
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: Molsman on July 26, 2026, 05:43:10 PM
I totally forgot this feature was available. Excellent work Steeley
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: Animl-AW on July 26, 2026, 06:20:51 PM
You're all welcome, if anyone has ideas for features I didn't think of, feel free to ask, happy to add stuff!

Great contribution
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: Goat1 on July 26, 2026, 06:52:30 PM
I'm not to computer savvy, where do I find FSOStats.exe from the releases page?
I'm really looking forward to checking the stats.
Thanks,
Goat
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: steely07 on July 27, 2026, 04:53:34 PM
Goat, it's over on the right hand side, you'll see "About", under that is "Releases", click releases, and scroll down a tad, you'll then see FSOStats.exe
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: 800nate800 on July 27, 2026, 07:03:03 PM
wow, talk about a trip down memory lane.... excellent job sir <S>
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: Goat1 on July 27, 2026, 08:31:46 PM
Goat, it's over on the right hand side, you'll see "About", under that is "Releases", click releases, and scroll down a tad, you'll then see FSOStats.exe

Thanks Steely,
 Was fun checking out the various stats.
Hard to believe this this month marked my 17th year in FSO.
Thanks again for the help and the work you put into developing this program.
 Goat
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: APDrone on July 27, 2026, 10:08:18 PM
WOW!!   :x

Thanks, Steely!!

Brought back some memories with the squads I've been in since -09

Drone
APDrone
AKDrone

That is truly awesome!!

 :salute
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: steely07 on August 21, 2026, 02:56:57 AM
New version up, fixes and improvements, light theme and an update check on startup, grab here

https://github.com/steelington/FSOStats/releases/tag/v0.2.0
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: SNO on October 17, 2026, 05:35:00 PM
First off thanks Steely

When I run the update the update doesn't show up. My top line is 7-24-26 even after running the update, what am I doing wrong??
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: steely07 on October 18, 2026, 02:25:50 AM
First off thanks Steely

When I run the update the update doesn't show up. My top line is 7-24-26 even after running the update, what am I doing wrong??

New version, and should be a lot faster, now queries my site https://aceshigh.events via api instead of scraping the ahevents.net site each time

https://github.com/steelington/FSOStats/releases/tag/v0.2.1
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: SNO on October 18, 2026, 04:15:14 PM
Thanks Steely, worked perfectly
Title: Re: Announcing - FSOStats application - Get your whole FSO History!
Post by: steely07 on October 19, 2026, 01:01:58 AM
sweet!