Update app.py

app.py

@@ -714,15 +714,41 @@ def home_page():
     st.markdown("---")
 
     # Recent games
-    games = unified_get("games") or {}
-    players_map = unified_get("players") or {}
+games = unified_get("games") or {}
+players_map = unified_get("players") or {}
+
+st.subheader("Recent games")
+
+for g in sorted(games.values(), key=lambda x: x.get("created_at", ""), reverse=True)[:10]:
+    gid = g.get("game_id")
+
+    st.markdown(f"### 🎮 Game: **{gid}** {'(Closed)' if g.get('closed') else ''}")
+    st.write(f"Host: {g.get('host')} — Topics: {', '.join(g.get('topics', []))}")
+    st.write(f"Created: {g.get('created_at')}")
+
+    # ✅ FIX: get players for THIS game
+    players_here = players_map.get(gid, {}) or {}
+
+    st.write(f"Players joined: **{len(players_here)}**")
+
+    # ✅ Submitted count
+    submitted_count = sum(1 for p in players_here.values() if p.get("submitted"))
+    st.write(f"Submitted: **{submitted_count} / {len(players_here)}**")
+
+    # ✅ Final scores per game
+    if players_here:
+        st.markdown("**📊 Final Scores**")
+        for uname_p, info in players_here.items():
+            if info.get("submitted"):
+                st.write(
+                    f"{info.get('avatar','🎮')} **{uname_p}** — "
+                    f"Score: **{info.get('score', 0)}**, "
+                    f"Percentage: **{info.get('percentage', 0)}%**"
+                )
+
+    st.markdown("---")
+
 
-    st.subheader("Recent games")
-    for g in sorted(list(games.values()), key=lambda x: x.get("created_at",""), reverse=True)[:10]:
-        gid = g.get("game_id")
-        st.markdown(f"### 🎮 Game: **{gid}** {'(Closed)' if g.get('closed') else ''}")
-        st.write(f"Host: {g.get('host')} — Topics: {', '.join(g.get('topics',[]))}")
-        st.write(f"Created: {g.get('created_at')}")
 
         players_here = players_map.get(gid, {}) or {}
         st.write(f"Players joined: **{len(players_here)}**")
@@ -757,17 +783,27 @@ def home_page():
                             send_game_invite(st.session_state['username'], f, gid)
                         st.success("Invites sent to friends.")
 
-        if st.button(f"Challenge friends with a new game like {gid}", key=f"challenge_{gid}"):
-            new_id = create_game(
-                st.session_state.get('username','Host'),
-                g.get('topics',[]),
-                num_questions=len(g.get('questions',[]))
-            )
-            st.success(f"Challenge created: {new_id}")
-
-        st.markdown("---")
-
-
+            if st.button(f"Challenge friends with a new game like {gid}", key=f"challenge_{gid}"):
+                new_id = create_game(
+                    st.session_state.get('username','Host'),
+                    g.get('topics',[]),
+                    num_questions=len(g.get('questions',[]))
+                )
+                st.success(f"Challenge created: {new_id}")
+
+            st.markdown("---")
+        
+        st.subheader("🏆 Weekly Leaderboard (Top 10)")
+
+        weekly = get_weekly_leaderboard()
+        if not weekly:
+            st.info("No scores yet this week.")
+        else:
+            for i, r in enumerate(weekly, 1):
+                st.write(
+                    f"{i}. {r.get('avatar','🎮')} **{r['name']}** "
+                    f"(Game {r['game_id']}) — {r['score']} pts"
+                )
 
 # Create game
 def create_game(topics=None, num_questions=5, auto_close=True, ai_topic=None):
@@ -948,10 +984,14 @@ def play_page():
                     "correct_flags": " || ".join(flags)
                 }
                 unified_push_leaderboard(row)
+                players[gid][uname]['score'] = score
+                players[gid][uname]['percentage'] = round((score / len(questions)) * 100, 2)
                 players = unified_get("players") or {}
                 if players.get(gid) and players[gid].get(uname):
                     players[gid][uname]['submitted'] = True
                     players[gid][uname]['submitted_at'] = now
+                    players[gid][uname]['score'] = score
+                    players[gid][uname]['percentage'] = round((score / len(questions)) * 100, 2)
                     unified_set("players", players)
                 if game.get('auto_close', True):
                     games = unified_get("games") or {}
@@ -1115,6 +1155,19 @@ def leaderboard_page():
     st.plotly_chart(fig, use_container_width=True)
 
 
+def get_weekly_leaderboard():
+    rows = unified_get("leaderboard") or []
+    one_week_ago = datetime.utcnow() - timedelta(days=7)
+
+    weekly = []
+    for r in rows:
+        ts = parse_iso(r.get("timestamp"))
+        if ts and ts >= one_week_ago:
+            weekly.append(r)
+
+    # Sort by score desc
+    weekly.sort(key=lambda x: x.get("score", 0), reverse=True)
+    return weekly[:10]
 # Route pages
 if page == "Home":
     home_page()