Update app.py

app.py

@@ -459,43 +459,46 @@ def sync_firebase_leaderboard_to_csv():
 # ---------------------------
 def unified_push_leaderboard(row):
     """
-    Push a row to:
-    - Firebase per game
-    - Firebase global leaderboard
-    - Local CSV backup
-    - Online CSV (optional)
+    Push score to:
+    - Firebase (only Online mode)
+    - Local leaderboard.csv (ALWAYS)
     """
+
     row = row.copy()
     row["timestamp"] = datetime.utcnow().isoformat() + "Z"
 
-    game_id = row.get("game_id")
-    username = row.get("name")
     mode = st.session_state.get("mode_selection", "Offline")
 
     # ---------------- ONLINE MODE ----------------
     if mode == "Online":
         ok, _ = init_firebase_if_needed()
-        if ok and game_id and username:
-
-            # 1️⃣ Push per game
-            ref = db.reference(f"/games/{game_id}/scores/{username}")
-            ref.set(row)
+        if ok:
+            try:
+                # Save in per-game scores
+                db.reference(f"/games/{row['game_id']}/scores").push(row)
 
-            # 2️⃣ Push to global leaderboard
-            global_ref = db.reference("leaderboard_online")
-            global_ref.push(row)
+                # Save in global online leaderboard
+                db.reference("/leaderboard_online").push(row)
+            except Exception as e:
+                st.warning(f"Firebase save failed: {e}")
 
-    # ---------------- LOCAL CSV BACKUP ----------------
+    # ---------------- LOCAL CSV (MAIN LEADERBOARD) ----------------
     try:
-        df = pd.read_csv(LEADERBOARD_FILE)
-    except FileNotFoundError:
-        df = pd.DataFrame(columns=list(row.keys()))
+        file_exists = os.path.isfile(LEADERBOARD_FILE)
+
+        with open(LEADERBOARD_FILE, "a", newline="", encoding="utf-8") as f:
+            writer = csv.DictWriter(f, fieldnames=row.keys())
+
+            if not file_exists:
+                writer.writeheader()
+
+            writer.writerow(row)
+
+    except Exception as e:
+        st.warning(f"CSV save failed: {e}")
+
 
-    df = pd.concat([df, pd.DataFrame([row])], ignore_index=True)
-    df.to_csv(LEADERBOARD_FILE, index=False)
 
-    # ---------------- ONLINE CSV PUSH (OPTIONAL) ----------------
-    # If you host CSV somewhere like GitHub raw file
     # You must handle upload using requests (if needed)
 
 
@@ -1314,16 +1317,6 @@ def play_page():
                     "correct_flags": json.dumps(flags),
                 }
                 unified_push_leaderboard(row)
-                save_score_to_csv(
-                    name=row["name"],
-                    score=row["score"],
-                    game_id=row["game_id"],
-                    topics=row["topics"],
-                    avatar=row["avatar"],
-                    questions=row["questions"],
-                    answers=row["answers"],
-                    correct_flags=row["correct_flags"]
-                )
 
 
                 # ---------------- AUTO CLOSE GAME ----------------