Update app.py

app.py

@@ -1194,59 +1194,37 @@ def inbox_page():
 def leaderboard_page():
     st.header("🏆 Leaderboard")
 
-    rows = unified_get("leaderboard") or []
-    if not rows:
-        st.info("No scores yet. Play some games first!")
-        return
+    # Get leaderboard data
+    leaderboard = unified_get("leaderboard") or []
 
-    # Convert to DataFrame
-    df = pd.DataFrame(rows)
+    if not leaderboard:
+        st.info("No scores yet.")
+        return
 
-    # Ensure columns exist
-    for col in ["name", "score", "game_id", "avatar", "timestamp"]:
-        if col not in df.columns:
-            df[col] = ""
+    # Sort by score descending
+    leaderboard = sorted(leaderboard, key=lambda x: x.get("score", 0), reverse=True)
 
-    # ---------------- Weekly Leaderboard ----------------
-    st.subheader("This Week — Top 10")
-    now = datetime.utcnow()
-    start_of_week = now - timedelta(days=now.weekday())
-    df['ts'] = pd.to_datetime(df['timestamp'], errors='coerce')
-    weekly_df = df[df['ts'] >= start_of_week].copy()
+    # Display top 10
+    st.subheader("Top Players")
+    for i, row in enumerate(leaderboard[:10], 1):
+        st.write(
+            f"{i}. {row.get('avatar','🎮')} **{row.get('name','Guest')}** "
+            f"(Game {row.get('game_id','')}) — {row.get('score',0)} pts — {row.get('percentage',0)}%"
+        )
 
-    if weekly_df.empty:
-        st.info("No scores recorded this week.")
+    # Weekly leaderboard (optional)
+    st.subheader("Weekly Leaderboard (Top 10)")
+    week_leaderboard = [r for r in leaderboard if datetime.fromisoformat(r.get("timestamp", now_iso())).isocalendar()[1] == datetime.now().isocalendar()[1]]
+    if not week_leaderboard:
+        st.info("No scores yet this week.")
     else:
-        weekly_df = weekly_df.sort_values(by='score', ascending=False).head(10)
-        for i, row in weekly_df.iterrows():
-            user_marker = "👈 You" if row['name'] == st.session_state.get('username') else ""
-            st.write(f"{i+1}. {row.get('avatar','🎮')} **{row['name']}** (Game {row['game_id']}) — {row['score']} pts {user_marker}")
-
-    st.markdown("---")
-
-    # ---------------- All-time Leaderboard ----------------
-    st.subheader("All-Time Top 10")
-    alltime_df = df.sort_values(by='score', ascending=False).head(10)
-    for i, row in alltime_df.iterrows():
-        user_marker = "👈 You" if row['name'] == st.session_state.get('username') else ""
-        st.write(f"{i+1}. {row.get('avatar','🎮')} **{row['name']}** (Game {row['game_id']}) — {row['score']} pts {user_marker}")
-
-    st.markdown("---")
-
-    # Optional: allow search by username
-    search_user = st.text_input("Search leaderboard by username")
-    if search_user:
-        search_df = df[df['name'].str.lower() == search_user.lower()]
-        if search_df.empty:
-            st.info(f"No scores found for {search_user}.")
-        else:
-            st.subheader(f"Scores for {search_user}")
-            for i, row in search_df.iterrows():
-                st.write(f"Game {row['game_id']} — {row['score']} pts — {row.get('avatar','🎮')} — {row['timestamp']}")
-
-
-
-
+        week_leaderboard = sorted(week_leaderboard, key=lambda x: x.get("score",0), reverse=True)
+        for i, r in enumerate(week_leaderboard[:10], 1):
+            st.write(
+                f"{i}. {r.get('avatar','🎮')} **{r.get('name','Guest')}** "
+                f"(Game {r.get('game_id','')}) — {r.get('score',0)} pts"
+            )
+            
 def get_weekly_leaderboard(limit=10):
     rows = unified_get("/leaderboard") or []
     one_week_ago = datetime.utcnow() - timedelta(days=7)