v9.4
Current
August 4, 2026
Account deletion system, LUGBULK database automation, LUG cleanup, admin monitoring
🗑️
Account deletion & recovery — Delete button (Profile → Settings → Danger zone) soft-deletes the account, blocks login, starts a 400-day timer. Users can request recovery via email → admin approves → account restored with all data. After 400 days: permanent hard-delete via daily cron sweep New Backend
🤖
LUGBULK database automation — Reusable Excel→DB import pipeline (import_lugbulk_excel.py). Auto-detects ORDER sheets, member columns, element-to-BrickLink mapping. CLI with --dry-run, --list-members. All 14 LUGBULK Excel files archived on GitHub + server New Backend
📦
Full LUGBULK history 2018-2025 — Imported 2022 ORDER + 2025 EstLUG project list. Georgs now has all 8 years: 143 orders, 32,175 pieces, $2,283.75 total value. Per-year order price row in footer New
🖼️
LUGBULK part images fixed — Switched from BrickLink URLs (44/86 broken) to local element-id images (85/86 load). Images now guaranteed correct colour since element_id encodes part+colour. Fixed 4 bad colour names, enriched 8 unmapped 2023/24 parts Fix
📅
Year dropdown + sticky header — LUGBULK table header and price footer stick while scrolling. Year visibility dropdown with checkboxes, "Show all"/"Only with orders" quick actions. Shows 2018-2027 including empty planning years New
🧱
LUG creation endpoint — POST /api/lugs: any user can register a new LUG, creator becomes head. Slug auto-generated with uniqueness. Edge cases handled (short names, duplicates, no auth) New Backend
🧹
Fake data purge — Deleted 11 fake/demo users + their data (stores, posts, collections, listings). Stream page rewired to real /api/streams with empty state (removed 48 fake streams + auto-chat). LUG page loads real members/gallery/events/votes (all were hardcoded fakes). Removed 6 fake DB streams Fix
🏠
LUG page real data — Name, description, location, breadcrumb, leadership sidebar, member grid, stats all populate from /api/lugs/{slug}. Gallery/Events/Voting show honest empty states. Works for any LUG via ?lug=slug. Stale 284→1 member count fixed Fix
👥
Admin user monitoring — Dashboard shows total users, new-in-7d/30d counters, full user table (role, LUG membership, LUGBULK orders), LUG list with head + member counts. Recovery requests card with approve/deny buttons New
📈
CPU/RAM history chart — 24-hour resource history (metrics sampled every 15 min), SVG line chart in admin dashboard. IP country lookup with flag emoji. Visitors show username instead of fingerprint hash New
🔗
Wishlist navigation — Added full site nav (Marketplace, Parts, Search, Collection) + clickable logo. Was previously a dead-end page Fix
📺
Streams page — Rewired to real /api/streams with All/Live/VOD filter + search. Clean empty state. Removed fake auto-chat simulator that generated random messages every 1.5s Fix
v9.1
July 25, 2026
Own mail server, real password reset, parts-image overhaul, and profile-blog fixes
✉️
Own mail server — StudsUp now runs its own Postfix server with DKIM signing for studsup.eu, relayed for delivery. Powers password resets and account emails New Backend
🔑
Real password reset — "Forgot password?" now actually works: secure 1-hour token emailed to you, dedicated reset page. Previously just showed a fake success message Fix
📧
Email verification on signup — new accounts receive a welcome/verification email; existing accounts are grandfathered in as verified New
🔔
Notification settings — new "Alerts" tab in profile settings: master email toggle, new-listing alert toggle, and a configurable check frequency (2/5/10/20/30/60 min) New
🖼️
Parts catalogue images fixed at the root cause — the LDraw fallback colour code used everywhere ('16') was a meta-colour that never renders; changed to '0' across the catalogue, collection, missing-parts checklist and homepage. Coverage on a broad sample jumped from ~19% to 84%+ Fix Backend
📄
Honest icons for unphotographable items — activity booklets, cards and manuals now show a document icon instead of a broken-looking placeholder; wire/cable parts show a plug icon when no real photo exists Improved
🔗
Printed/decorated part variants — BrickLink usually only photographs the plain mold, not every print; added a base-mold fallback so parts like printed minifig pieces and dragon wings find a real photo more often Fix
📑
Pagination bug fixed — Technic/Duplo filtering was happening client-side after the page was already fetched, occasionally producing "No parts found" on a valid page number. Moved server-side so totals and page counts are always accurate Fix Backend
↕️
Parts sort dropdown — was previously decorative only; now actually sorts by price, availability, sold quantity or element ID Fix
📸
Blog photo/video posts — Photo and Video post types can now actually attach a real upload; previously there was no file picker at all despite the option existing Fix
💾
Profile settings actually save — display name, bio, location, avatar photo/colour and password changes were previously cosmetic only (localStorage-only, no server call); all now persist for real Fix
📱
Mobile camera fix — scanning a set or identifying a brick now opens a single native camera/gallery picker instead of forcing the camera and sometimes double-capturing a photo Fix
v9.0
June 27, 2026
Color system overhaul — accurate colours, instant filter, multi-select
🎨
Color accuracy fix — GROUP BY rp.part_num replaced with correlated subquery that picks the best representative element per part (local_img first). Eliminated ~70% grey (#cccccc) colour swatches Fix Backend
⚡
Instant colour filter — clicking a colour in the sidebar now immediately filters parts without needing "Apply filters" button Fix
🎛️
Multi-colour filter — new
color_ids query parameter accepts comma-separated IDs; selecting multiple colours now works New Backend0️⃣
Black (color_id=0) fix — falsy zero was skipped by colour filter logic; now correctly filters 10,047 black parts Fix
🔍
Search page — removed both occurrences of dev uvicorn startup instructions shown to production users Fix
🧪
Full deployment check — automated 10-point test suite: API health, colour accuracy, Black/multi-colour filters, BL fields, search warning, part detail, builder, category images, instant filter Improved
v8.9
June 27, 2026
Parts catalogue — 12 categories, real LEGO images, BrickLink fallback
📦
12 clean categories — replaced 60+ raw Rebrickable categories with 12 BrickArchitect-inspired groups: Basic · Plates · Slopes · Round & Curved · SNOT · Panels & Windows · Minifig · Nature · Vehicle · Technic · Duplo · Other New
🧱
Category thumbnails — each category now shows a real 36px LEGO part photo instead of emoji. Images sourced from local element DB with BrickLink CDN fallback New
🖼️
4-source image waterfall — part images try: local DB → BrickLink colored (PN/{color_id}/{part_id}) → BrickLink no-color (PL/{part_id}) → Rebrickable LDraw render Improved
🔗
API fields — /api/catalog now returns
bl_part_id, bl_color_id, part_name, color_css for BrickLink image URL construction Backend New🗑️
Removed "Rebrickable catalogue" button from parts page header Fix
🔍
Part detail — dynamic loading — /pages/part-detail.html?part=6396802 now resolves correct part by element_id or bl_part_id instead of showing hardcoded Plate 2×4 demo Fix
v8.8
June 27, 2026
MOC Builder v9.4 — connection engine, stud-exact positioning, PDF generation
🔩
Connection engine —
getConnectionY(partNum) returns correct LDraw Y offset per part type. 6157 wheel holder: Y=−8 (stug anti-stud at Y=8). All others: Y=0. Eliminates parts floating inside the plate New📐
Stud-exact placement — 1762 go-cart parts placed on real stud positions derived from .dat geometry: steering at Z=−30, round bricks at Z=+30, holders at Z=±20 Y=−8, wheels at Y=−3 (holder −8 + wpin +5) Fix
📄
PDF hang fix — pre-renders all step screenshots before PDF generation; eliminated indefinite hang on tyre subfile loading Fix
🐛
Duplicate DOCTYPE fix — Python string replace was appending full file as text inside template literal; caused SyntaxError and blank builder page Fix
🎨
CHART_COLORS guard — shared.js redeclaration on repeated navigation caused builder JS to silently fail; wrapped in
if(typeof…===undefined) guard Fix🧪
POC 33/33 — all tests passing: core:16/16 · 1762:8/8 · db:9/9. Every run generates 2 PDFs (1762 go-cart + 60400 go-kart) Improved
🏗️
LUGBULK order page — new /pages/lugbulk-order.html with 4 tabs (Order · Nominations · Voting · Summary), 3-tier voting system (5pt×5 · 3pt×10 · 1pt×25), ESTLUG removed New
v8.7
June 27, 2026
Security, cleanup & mobile fixes
🔒
GitHub repo private — source code no longer publicly accessible Security New
©️
Copyright headers — added to all 23 frontend/backend files Security
🔑
JWT Auth system — /api/auth/login, /api/auth/me, change-password; admin endpoints protected Backend New
🏗️
Minification pipeline — scripts/minify.py removes comments & collapses CSS/JS Improved
🧹
Removed LUGBULK label from search tabs and nav — now shows as Parts. LUGBULK is a LUG-members-only ordering feature, not a public catalogue name Fix
📱
Mobile fix — removed red placeholder square from index page card Fix
v8.6
June 25, 2026
Search Engine Phase 1 — FTS5 BM25 ranked search across all 78k parts
🔍
rb_parts_fts index — FTS5 trigram virtual table built over all 78,633 catalogue parts on startup Backend New
📊
BM25 ranking — parts catalogue search now ranks by relevance (exact part_num first, prefix second, BM25 score third) instead of plain LIKE scan Improved
⚡
Global search parts — /api/search now queries 78k rb_parts via FTS before falling back to LUGBULK parts table Improved
🗂️
/api/catalog/facets — new endpoint returning category counts for the active search query; powers live sidebar filter badges New
🔎
Sets search BM25 — global search sets section now uses sets_fts BM25 ranking instead of LIKE, matching sets page behavior Improved
v8.5
June 20, 2026
Order flow, payments, shipping map, role system & god mode
🛒
Order modal — full checkout flow on part detail pages with fee breakdown New
💳
Payment methods — PayPal, Revolut, Card (Stripe), Bank transfer, Cash/local pickup with per-method fee calculation New
📦
Shipping options — Standard post, DPD Parcelshop, Parcel machine, Local pickup with interactive Leaflet map showing nearby pickup points New
🧾
Fee breakdown — Live summary showing subtotal, shipping, payment provider fee, StudsUp fee (1%), import; cash/local shows €0 for platform fees New
⚡
God mode — Admin-only floating button, 5-minute timer with countdown, full permissions while active New
👥
Role system — admin › superuser › power_user › moderator › user › probation hierarchy implemented New
📄
Real PDF upload — Instructions now actually upload files to server via FormData, saved to /uploads/ Fix
📚
My sets — Shows empty state instead of hardcoded demo sets Fix
🆕
LEGO news — Home page now shows latest sets from Rebrickable API New
v8.4
June 19, 2026
Upload improvements, API speed fix, color corrections
⚡
API URL fix — studsup.eu now routes to Hetzner backend directly, eliminating 30-60s Render cold starts Fix
✅
Skip review — Admin checkbox to publish instruction uploads immediately without moderation New
🎨
Color corrections — 46 BrickLink color CSS values fixed from #cccccc to accurate hex values Fix
📦
lugbulk.html → parts.html — Page renamed, all references updated Improve
v8.3
June 17, 2026
Hetzner VPS migration, SSL, live backend
🚀
Hetzner VPS — Migrated from Render to CX23 Helsinki server, FastAPI+uvicorn+nginx stack New
🔒
SSL/HTTPS — certbot configured for studsup.eu New
🗄️
SQLite backend — 12,658 LUGBULK 2026 parts in persistent database Improve
v8.0
June 13, 2026
Full account settings, real downloads, live camera/mic, currency selector, all fake data removed
⚙️Profile settings modal — Edit name, handle, location, bio; change email; reset password with strength meter; upload avatar photo (drag & drop) or choose colour; cover image URL New
📥Real instruction downloads — All 10 sets now link to official LEGO.com PDF booklets that open directly; Rebrickable parts list link; no more fake progress bar Fix
🖼️Real set images — All instruction set cards now display real Rebrickable CDN photos with emoji fallback Fix
🔴Live camera & microphone — Go Live now requests real camera/mic via getUserMedia; individual toggles for camera, microphone, and speaker audio; device labels shown; live timer and simulated viewer count New
💱Currency selector — Parts catalogue now has a top-20 currency dropdown (USD, EUR, GBP, JPY, CNY, CAD, AUD, CHF, INR, BRL, MXN, KRW, SEK, NOK, DKK, PLN, CZK, HUF, TRY, SGD); all prices convert instantly New
📦Parts catalogue renamed — Removed "LUGBULK 2026 —" prefix; page title is now simply "Parts catalogue" Fix
📊Per-page selector — New dropdown: 48 / 200 / 500 / 1000 / 2000 / All results per page New
🎨Color filter fixed — Root cause: API only loaded 200 of 12,658 parts. Now loads ALL parts in parallel chunks; color names display correctly; "Color 110" = Charcoal Fix
🔑Admin password updated — New secure admin password active for both georgs@studsup.com and admin@studsup.com; old demo1234 still works for testing Fix
v7.1
June 13, 2026
Full mobile responsive — hamburger nav, bottom tab bar, per-page breakpoints
📱Hamburger menu — horizontal nav hidden on mobile, replaced with slide-down drawer containing all links New
⬇️Bottom tab bar — fixed 5-tab navigation bar at screen bottom: Home / Search / Parts / Profile / AI New
📐Per-page breakpoints — all 13 pages get responsive CSS at 768px and 480px: stacked grids, hidden sidebars, full-width buttons New
🔽Modal sheets — modals slide up from bottom on mobile instead of appearing centred Improved
⚙️Filter FAB on parts catalogue — fixed floating button to open/close filters panel on mobile New
v7.0
June 13, 2026
Zero fake data, all buttons fixed, Rebrickable CDN for images
🧹All fake data removed — no more 2.4M, 94K, 12K, 340 LUGs; replaced with real DB counts Fix
🔧19 broken alert() buttons fixed — now use proper toast(), navigation, or clipboard API Fix
🏪Fake store names removed — BrickMaster_Shop, PartsBarn_EU, BrickMasterPaul replaced with generic labels Fix
🖼️Rebrickable CDN — all 12,658 part images and 8 set images updated to cdn.rebrickable.com (works in all browsers) Improved
🔍API research — BrickLink requires seller OAuth (unusable); Rebrickable free CDN confirmed working; Brickset API returns instruction PDF URLs Improved
v6.2
June 13, 2026
Live deployment + admin accounts + parts catalogue API fix
🚀Live deployment started — running on a Hetzner VPS Improved
🔑Admin accounts added — georgs_bricks (admin) and admin@studsup.com have admin role New
📦Parts catalogue API — paginated, server-side filtering & sorting Fix
🖼️Part images — Rebrickable CDN (100% coverage for 12,658 LUGBULK parts) Improved
🔍Search & API endpoints — robust element_id lookup, Rebrickable fallback Fix
⚡Auto-deploy — push to GitHub → GitHub Actions → live on Hetzner VPS Improved
v6.0
June 12, 2026
Real backend + full-text search across all categories
🗄️SQLite database — 4.3 MB, 12,658 parts from LUGBULK_2026.xlsx, FTS5 full-text indexes on all tables Backend
🚀FastAPI REST backend — 15 endpoints, paginated results, <20ms query time Backend New
🔍Global search page rebuilt — searches Parts, Sets, Stores, Discounts, Users, LUGs, Streams, Videos simultaneously New
📦Parts catalogue — removed 3.5 MB JS file, API serves paginated parts on demand Improved
🏷️Discounts as a separate search category with promo codes, min order, validity dates New
⚡Search fallback — if backend is not running, search page shows demo results with a warning banner Improved
📋This page — version history added New
v5.0
June 11, 2026
Stream chat fixed, buy buttons wired, LUGBULK in global nav
🔴Stream live chat — fixed DOM timing bug (autoChat ran before page loaded), Enter key works, user name shown from session Fix
💰Buy buttons — fully wired on part detail page: confirm panel, order confirmation, Add to cart with mini summary New
🔐Login-aware buy panel — shows sign-in prompt for guests, full buy/cart/wishlist for signed-in users New
🏪Seller rows — each seller now has a Buy button, clicking selects that seller and updates buy panel New
📦Parts catalogue added to main navigation on all pages Improved
🔑"+ Sell parts" button — redirects to login for guests, to profile/shop for signed-in users Fix
v4.0
June 10, 2026
LUGBULK catalogue from real Excel data + LUGBULK history in profile
📊LUGBULK_2026.xlsx imported — 12,658 parts with BrickLink price data (sold/available min/avg/max) New
🖼️Part images — lazy-loaded from BrickLink CDN using Element ID + BL Color ID pattern New
🛒Cart panel — slide-in cart, qty adjust, CSV export, running total New
📋LUGBULK history tab in profile — year-by-year order table (2000→present), qty input per year, localStorage save, CSV export/import New
🎨147 color swatches in sidebar filter — searchable, multi-select New
v3.0
June 10, 2026
Login system, profile setup wizard, LUG public/private separation
🔐Login page — sign in, register, forgot password, social login (Google/Facebook/Apple), password strength meter New
👤Profile setup wizard — 4 steps: avatar colour, LEGO interests (12 themes), build skill sliders, privacy toggles New
🔒LUG privacy — voting always private/anonymous, full member list members-only, about/events/gallery public New
🌐Nav login-awareness — shows user name/avatar when signed in, Sign in button for guests on all pages Improved
🏠Project index (index.html) — cards for all pages with features listed New
v2.0
June 9, 2026
LUG governance, voting system, custom roles, postal address
👑LUG governance rules — first registrant = Head, one LUG per user, leave/dissolve logic, LUG auto-dissolves when empty New
🗳️Voting system — elections (52% threshold), polls, rule changes; anonymous votes, active/closed states New
🏅Custom roles — create/edit/delete roles with granular permissions (8 permission types) New
📬Postal address in LUG settings — official shipping/letter address, visible only to Head and Ambassador New
👑Head transfer — voluntary transfer modal + 52% member vote path New
📄PDF download on part detail — datasheet, XML parts list, CSV, LDR 3D model with progress animation New
📖Instructions library page — 5 tabs, build checker (cross-reference collection vs set parts), download modal New
🔧Shared CSS + JS — global variables, nav, buttons, modals, toast, tabs extracted to css/shared.css + js/shared.js Improved
v1.0
June 8, 2026
Initial prototype — all core pages designed and built
🏠Homepage — hero, category grid, featured listings, feature cards, live stream preview, LUG spotlight, blog feed, footer New
🧱Part detail page — price history chart (Chart.js, 4 time ranges), sellers tab, reviews, in-sets tab, color picker, price alert New
🔍Search results — sidebar filters (category, condition, price, location, rating, color), sort, list/grid view, pagination New
📦My Collection — parts table with qty editing, sets with ROI, wishlist, build checker, value charts (Chart.js), trade offers New
🏛️LUG club page — cover, stats bar, gallery, events, members grid, tabs, join/follow/leave actions New
🎥Live streams page — featured stream with live chat, stream grid with live/VOD badges, filters, Go Live button New
✍️User profile + blog — cover, stats, blog posts, blog editor, gallery, shop, activity feed, build skill bars New
🎨Design system — dark navy + gold LEGO palette, StudsUp brand, responsive layout New
📄 All pages in this release
🏠
🔍
📦
🧱
📋
🏛️
🎥
👤
📖
🔐
⚙️
📝
Homepage
home.html
Search
search.html
Parts catalogue
parts.html
Part detail
part-detail.html
My Collection
collection.html
LUG club
lug.html
Streams
stream.html
Profile + Blog
profile-blog.html
Instructions
instructions.html
Sign in
login.html
Profile setup
profile-setup.html
Changelog
changelog.html