Free Tier (AdSense)
Insider / Members Only
Join / Conversion
Tools / Utility
Admin / Internal
Reference / Scrapped
Build Queue
SITE FLOW CHART
User journeys across FlyingNaked.com — Free tier (AdSense-safe) and Insider tier
🌐 Landing / Entry
Direct URL · Google Search · Social Share · Military referral
→
🏙️ City Page
fn-denver-city-page-v21.html
Primary hub. Hero + video carousel + 43 topic Browse grid
Free AdSense
→
🪖 Base Page
fn-base-buckley-v1.html
Military base template. OD theme. Off-post listings + PCS guide
Free 4× AdSense

Entry & Navigation

How users arrive & move

🗂️ Staging Index
index.html
Dev navigator — links to all pages
↓
🧭 Bottom Nav Bar
Present on all pages. ⚠️ Needs rework (items, icons, active states)
↓
🌙 Light / Dark Toggle
Every page. Toggles body.light-mode. ⚠️ Light mode CSS needs refinement
↓
🔲 Browse Topic Grid
43 tiles (31 Free · 12 Insider). All tiles look identical — lock reveals on tap

Free Tier Pages

AdSense-safe · Public access

🟢 No auth required — AdSense active
🎯 Topic Detail
fn-topic-pickleball.html
Collapsible sections, map, gear grid, affiliate disclaimer
Free
↓
🎬 Video Carousel
fn-video-carousel-v2.html
Platform filters · Modal player · TikTok / Reels / YouTube
Component
↓
🗺️ Garage Sales Map
fn-garage-sales-v5.html
Full-screen map · Day toggles · Source + category filters
Free AdSense
↓
🛠️ Tools Hub
fn-tools-landing.html
1 tool live (Packing List) · 5 coming soon · ⚠️ Link bug
AdSense
↓
🎒 Packing List
fn-packing-list-2.html
Activity chips · Progress tracker · Gear affiliates · Print layout
Free Tool

Insider Tier

Members Only · No AdSense

🔒 Requires Insider membership — $4.20 / 4 months
🚀 Join Page
fn-join-v1.html
$4.20 / 4 months · 2yr free National · Cheeky CTA · AdSense-safe copy
AdSense-safe
↓
🔑 Insider Topic Pages
12 topics behind paywall. No blur/lock overlay — links direct to join.html
Members Only
↓
🌿 Unlocked Content
Cannabis · Adult venues · Burlesque · Unfiltered reviews · Smoke & Whiskey · After Dark
No AdSense
↓
🪖 Base Off-Post Listings
fn-base-buckley-v1.html
Off-post Insider card → join.html · QuikQuiz · FN' Picks carousel · Intel strip
Insider Card

Admin / Internal

Dev tools · Reference

✅ Admin To-Do
fn-admin-todo.html
Task tracker · Category dropdown · Swipe-left delete · localStorage
Internal
↓
🏷️ Garage Sales Admin
fn-garage-sales-admin-v2.html
Editor login · Add/approve/draft listings · Demo: [email protected] / fn2026
Reference
↓
🗑️ AdSense Layout Test
fn-thefnguide-ads.html
Scrapped — early AdSense layout mockup
Scrapped
↓
🗑️ Perspectives Panel
fn-perspectives-panel.html
Scrapped — branding dropped. Review slots survive in build
Scrapped
TOPIC SYSTEM — 43 TOPICS
Browse grid appears on: City Page · Base Page. Term: "Topics" (not "Categories")

🟢 31 FREE TOPICS → Topic Detail Page

Pickleball Hiking Food & Eats Live Music Garage Sales State Parks Farmers Markets Trivia Nights Craft Beer Coffee Shops Escape Rooms Mini Golf Bowling Dog Parks Fishing Axe Throwing Go Karts Museums Comedy Shows + 12 more free

🔑 12 INSIDER TOPICS → join.html

Chuckles/Knuckles/Boogie Nights Booze Pew-Pew Taps & Tokes Kumbaya Gamble Pub Games Extreme Bucket List After Dark Smoke & Whiskey The Password Is... Above It All
DATABASE FLOW
Schema architecture for FlyingNaked.com — content, membership, locations, topics, ads
users
User
🔑user_idUUID PK
emailVARCHAR
created_atTIMESTAMP
tierENUMfree | insider
insider_sinceDATE
insider_expiresDATE
national_free_untilDATE2yr
notified_2yrBOOL
pref_city_idFK → cities
subscriptions
Billing
🔑sub_idUUID PK
↗user_idFK → users
amountDECIMAL$4.20
interval_daysINT120 days
statusENUMactive|cancelled|paused
next_billingDATE
stripe_sub_idVARCHAR
cities
Core
🔑city_idUUID PK
nameVARCHAR
stateVARCHAR
slugVARCHARurl key
hero_image_urlVARCHAR
accent_colorVARCHARe.g. Broncos blue
is_activeBOOL
latFLOAT
lngFLOAT
topics
Core
🔑topic_idUUID PK
nameVARCHAR
slugVARCHAR
subtitleVARCHAR
tierENUMfree | insider
is_adsense_safeBOOL
hero_filter_pillVARCHAR
sort_orderINT
icon_emojiVARCHAR
listings
Content
🔑listing_idUUID PK
↗city_idFK → cities
↗topic_idFK → topics
nameVARCHAR
descriptionTEXT
addressVARCHAR
lat / lngFLOAT
tierENUMfree | insider
is_fn_pickBOOL
statusENUMdraft|active|archived
affiliate_urlVARCHAR
military_bases
Core
🔑base_idUUID PK
↗city_idFK → cities
nameVARCHARe.g. Buckley SFB
branchENUMArmy|Navy|AF|Marines|CG|NG
slugVARCHAR
hero_silhouetteVARCHARairfield svg
pcs_guide_contentTEXT
intel_strip_htmlTEXT
quikquiz_configJSONBBar/Range/Both/Neither
garage_sales
Content
🔑sale_idUUID PK
↗city_idFK → cities
titleVARCHAR
addressVARCHAR
lat / lngFLOAT
daysSETFri|Sat|Sun
sourceVARCHAR
categoriesJSONB
statusENUMdraft|approved|expired
↗submitted_byFK → users?public form planned
videos
Content
🔑video_idUUID PK
↗city_idFK → cities
↗topic_idFK → topics
platformENUMTikTok|Reels|YouTube
embed_urlVARCHAR
thumbnail_urlVARCHAR
titleVARCHAR
tierENUMfree | insider
sort_orderINT
adsense_zones
Ads
🔑zone_idUUID PK
↗page_typeENUMcity|base|tool|topic
placementVARCHARafter_hero|between_sections
sizeVARCHAR320×50 | 300×250
ad_slot_idVARCHARGoogle Ad slot
is_activeBOOL
tier_visibilityENUMfree_only
KEY RELATIONSHIPS
users→subscriptions1:many
users→cities (pref_city)many:1
cities→listings1:many
cities→military_bases1:many
cities→videos1:many
cities→garage_sales1:many
topics→listings1:many
topics→videos1:many
listings.tier→users.tier checkgate logic
topics.is_adsense_safe→adsense_zones visibilitygate logic
MEMBERSHIP LIFECYCLE
01
User Taps Insider Content
Any of 12 Insider topics or off-post listing → direct link to join.html
listings.tier = insider
→
02
Join Page
fn-join-v1.html. $4.20 / 4 months pitch. AdSense-safe copy only.
fn-join-v1.html
→
03
Payment Processed
Stripe subscription created. $4.20 every 120 days.
subscriptions.stripe_sub_id
→
04
Insider Unlocked
users.tier = insider. All 12 Insider topics + off-post content unlocked.
users.tier = insider
→
05
2-Year Free National
national_free_until set. At 2 years, notified_2yr = true. User chooses to continue.
users.national_free_until
KNOWN ISSUES
Active bugs and to-dos flagged in project inventory
⚠️
Packing List Broken Link
fn-tools-landing.html links to fn-packing-list.html — actual file is fn-packing-list-2.html
Not Fixed
🌙
Light Mode CSS
All pages have 🌙/☀️ toggle wired up, but light-mode CSS overrides need per-page refinement across all mockups
To-Do
🧭
Bottom Nav Bar
Needs rework across ALL pages — items, active states, icons, and spacing are inconsistent
To-Do
BUILD QUEUE
Pages planned for next build sprint
🎓 School Page
University/college page template
📍 Activity Detail
Individual listing/activity page
🔍 Browse / Explore
Filterable activity feed
🥾 Trail Page
Food/activity trail format
📬 Garage Sale Submission
Public-facing submission form
DESIGN SYSTEM REFERENCE
Colors
#FF5C35 — FN Orange
#001830 — Base Dark
#1A1F0F — OD Dark
#C4B078 — OD Tan
#D4A017 — Amber
Typography & Layout
Display: Bebas Neue
Body: DM Sans
Mobile max-width: 430px
Nav height: 56px
Bottom nav height: 60px
AdSense: 320×50 (after hero)
AdSense: 300×250 (between sections)