Ashfire's Mirror

Hawken

Welcome to the Hawken section of the mirror.

Forums archives

• Meteor Entertainment era of the Forums
  Partial mirror of the forums before they were lost when Meteor Entertainment went under. Snapshot taken on 2014-11-01.
  Please note, a lot of content is missing from this archive. You will likely hit many 404 errors.
  Download snapshot (79MB xz-compressed tar, decompresses to ~2.2GiB)

• Reloaded era of the Forums
  Mirror of the Reloaded-run forums from before they were shut down. Snapshot taken on 2017-11-14.
  Download snapshot (203MB xz-compressed tar, decompresses to ~4.3GiB)

Patch archive

Archive of all known patches released for Hawken on PC.

Hawken Tracker database archives

This project of mine ran from 2014-05-18 to 2016-01-24, and was intended to be used for leaderboards and match tracking.
The original backup of the database is available below.
Please note, the script is intended to be run from the default postgres database, and will create the target database itself, as hawkentracker.

• Download backup (with callsigns) (419MiB xz-compressed sql, decompresses to 3.8GiB)
• Download backup (with callsigns) (948MiB gzip-compressed sql, decompresses to 3.8GiB)
• Download backup (without callsigns) (413MiB xz-compressed sql, decompresses to 3.8GiB)
• Download backup (without callsigns) (922MiB gzip-compressed sql, decompresses to 3.8GiB)

Revised backup

In 2024, I took another look at the tracker database and made a collection of fixes to make it easier to pull interesting statistics from.
The original database went through several changes during it's life, and the data was not updated to be consistent for future use.
I created a script to clean up the data and make several corrections, which is below.

• Download fixes script (sql)
• Download backup (with fixes pre-applied) (417MiB xz-compressed sql, decompresses to 3.8GiB)
• Download backup (with fixes pre-applied) (1GiB gzip-compressed sql, decompresses to 3.8GiB)

A summary of the changes made are as follows:

1. Create indexes on matches, players, match_players, and polls to support ranging by first_seen/last_seen (or start and end, for polls)
2. Backfill end on polls, using start and time_elapsed
3. Merge overlapping polls records into single records that cover the whole range
4. For first_seen/last_seen in players, matches, and match_players, set the timestamps to exactly match the startof the relevant polls records
   (This was implemented later in the project, but was never applied to the existing data. This change allows using polls start timestamps to range against these tables.)
5. Backfill players_updated, players_added, matches_updated, and matches_added on polls
   (This was implemented later in the project, but was never applied to the existing data.)

If you need to contact me, I can be reached at @ashfire908 on Discord (I'm usually in the Hawken Refugees discord).