Forum MetaData Deep Dive — What a 2002 Message Board Recorded About Itself

Forum archives usually preserve the posts and lose everything else. When FinalFantasyFanatic.com's board was backed up on November 20, 2002, the copy captured the whole Ikonboard 3.0.2a installation — including roughly two dozen side tables that were never meant to be read by anyone: who was logged in at that moment, what had been deleted and when, who held moderator powers versus who used them, what members typed into the search box, and how the board was configured. The full deep dive is here.

The who's-online table is a live scratch file, overwritten constantly, so what survived is a single frozen instant: two moderators reading the same thread in the admin-only forum, and the administrator arriving seconds earlier with no page loaded yet. One of them was still running Windows Me. The session tokens themselves turned out to be unhashed — Ikonboard 3.0.2a prints the login timestamp, process ID and a 16-bit random directly into the token, so every session ID in the archive dates itself.

A 716-entry deletion ledger records every record the board ever removed. It explains a gap the recovery had never accounted for: the Promote It forum was not lost to a failed extraction, it was deleted outright at 22:05 on November 17, 2002, three days before the backup, with the forum record itself removed one second after its last topic. Cross-referencing that ledger against the moderator log puts names back on nineteen deleted threads, and the search log supplies thirty-nine more thread titles that survive nowhere else.

The search log is the strangest artifact in the set: 5,147 queries, but only 305 distinct terms, of which 231 are exact thread titles accounting for 85 percent of all searching. The board surfaced no bookmarks, so members used the search box as a jump list. In 5,147 searches, nobody ever once searched for another member.

Because Ikonboard kept its own running counters, the recovery can be measured rather than estimated: 100 percent of members, 89.4 percent of topics and 98.2 percent of replies. The board also recorded its all-time peak of seven users online, on September 13, 2002, and the birthdays of 22 members — in aggregate, a community whose median age was sixteen.