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)