api_server.py

"""CraftLife local HTTP API — wraps database.py for the React UI (Phase 0–1)."""
from __future__ import annotations

import base64
import json
import os
import tempfile
import re
import threading
import time as _time
import uuid

# Parity TimeSync._zone = "Asia/Jakarta": paksa zona proses berjalan di waktu WIB
# SEBELUM database.py diimpor, sehingga date.today()/datetime.now()/local_now()
# serta reset_daily_tasks semua memakai hari yang sama dengan jam yang ditampilkan.
# Tanpa ini, date.today() mengikuti zona server (mis. UTC) dan reset harian task
# terjadi di jam lokal yang salah → habit/daily tidak terulang dengan benar.
if "TZ" not in os.environ:
    os.environ["TZ"] = "Asia/Jakarta"
try:
    _time.tzset()
except Exception:
    pass
from http.server import BaseHTTPRequestHandler, ThreadingHTTPServer
from urllib.parse import parse_qs, urlparse

import database as db
import life_api
import studio_api
from translations import get_text

_state = {
    "user_id": None,
    "token": None,
}

# C07: cache hasil cek update — refresh di background per 6 jam agar /api/bootstrap
# tidak pernah block menunggu GitHub. Cek manual (/api/update/check) selalu live.
_UPDATE_CACHE = {"at": 0.0, "info": None, "refreshing": False}
_UPDATE_CACHE_TTL = 6 * 3600


def _update_cached_info():
    """Info update dari cache; picu refresh background bila basi."""
    try:
        import updater
        now = _time.time()
        if now - float(_UPDATE_CACHE.get("at") or 0) > _UPDATE_CACHE_TTL \
                and not _UPDATE_CACHE.get("refreshing"):
            _UPDATE_CACHE["refreshing"] = True

            def _ref():
                try:
                    info = updater.check_for_update()
                except Exception:
                    info = None
                _UPDATE_CACHE["info"] = info
                _UPDATE_CACHE["at"] = _time.time()
                _UPDATE_CACHE["refreshing"] = False

            threading.Thread(target=_ref, name="craftlife-update-cache",
                             daemon=True).start()
        return _UPDATE_CACHE.get("info")
    except Exception:
        return None


def _tasks_rollover(uid: int) -> dict:
    """C08: reset harian + daftar task segar utk rollover tengah malam.

    Ringan: hanya reset done/streak + habits/dailies + jam server
    (bukan bootstrap/snapshot penuh).
    """
    db.reset_daily_tasks(uid)
    now = _server_now()
    return {
        "ok": True,
        "serverNow": now,
        "serverDate": now["date"],
        "habits": [_map_habit(h) for h in db.get_habits(uid)],
        "dailies": [_map_daily(d) for d in db.get_dailies(uid)],
    }

WEB_I18N_KEYS = [
    "app_logo", "loading", "nav_dashboard", "nav_habits", "nav_dailies",
    "nav_quests", "nav_sport", "nav_economy", "nav_health_food", "nav_shop",
    "nav_pets", "nav_guild", "nav_achievements", "nav_settings", "nav_learning",
    "nav_music", "nav_love", "nav_calendar", "nav_friends",
    "page_home_title", "page_home_subtitle", "dashboard_greeting",
    "dashboard_level", "dashboard_gold", "dashboard_hp", "dashboard_mp",
    "dashboard_streak", "web_shell_title", "web_engine_missing", "web_loading",
    "web_api_offline", "web_live_badge", "nav_adventure_menu", "nav_prestige_level",
    "nav_toggle_menu", "nav_hero_profile", "nav_level_progress", "nav_toggle_language",
    "nav_hp_abbr", "nav_mp_abbr",
    "web_offline_first", "web_connecting", "web_use_game_error",
    "web_legacy_ui", "web_open_web_ui",
    "web_shop_title", "web_shop_subtitle", "web_shop_tab", "web_inv_tab",
    "web_forge_tab", "web_buy", "web_buy_more", "web_sell", "web_use_item",
    "web_equip", "web_unequip", "web_forge_item", "web_inv_empty",
    "web_pet_adopt", "web_pet_feed", "web_pet_train", "web_boss_start",
    "web_boss_attack", "web_boss_skill", "web_ach_claim", "web_level_up",
    "cloud_group", "cloud_account_title", "cloud_account_info", "cloud_email",
    "cloud_password", "cloud_create_account", "cloud_signin_link",
    "cloud_credentials_invalid", "cloud_verification_sent", "cloud_account_created",
    "cloud_error", "cloud_link_account", "cloud_sync_now", "cloud_migrate_local",
    "cloud_sign_out", "cloud_status_not_configured", "cloud_status_ready_unlinked",
    "cloud_status_linked", "cloud_never", "cloud_syncing", "cloud_sync_success",
    "cloud_sync_partial", "cloud_queue_inspect", "cloud_queue_retry",
    "cloud_queue_empty", "cloud_realtime_on", "cloud_realtime_connecting",
    "cloud_personal_revision", "cloud_personal_conflict", "cloud_conflict_title",
    "cloud_conflict_hint", "cloud_conflict_keep_local", "cloud_conflict_use_remote",
    "cloud_conflict_keep_local_confirm", "cloud_conflict_use_remote_confirm",
    "cloud_conflict_resolved", "cloud_devices_title", "cloud_devices_info",
    "cloud_device_revoke", "cloud_device_revoke_others", "cloud_device_active",
    "cloud_device_revoked", "cloud_device_last_seen", "cloud_device_current_block",
    "cloud_device_register_failed", "cloud_off_hint", "cloud_shop_wallet", "web_enchant",
    "love_add_photo", "love_photo_pick_hint", "cloud_friend_username", "cloud_friend_add",
    "cloud_pvp_challenge", "cloud_chat_pick_friend", "love_daily_checkin", "love_save_checkin",
    "web_supplies_title", "web_supplies_sub", "web_supplies_add",
    "web_music_download", "web_music_search", "web_quiz_generate",
    "web_cal_day_note", "web_cal_save_note", "web_health_history",
    "web_local_account", "web_leaderboard", "web_profile", "web_create_guild", "web_join_guild",
    "web_tracker_export", "web_tracker_import", "web_check_update", "web_stay_logged_in", "web_switch_local",
    "web_task_fail", "web_task_duplicate", "web_task_folder_new", "web_supply_adjust",
    "web_sport_complete", "web_water_goal", "web_calorie_goal",
    # ── Phase P1: drag & drop reorder + quick add + undo ──
    "task_reorder_hint", "quick_add_title", "quick_add_habit", "quick_add_daily",
    "quick_add_quest", "quick_add_placeholder", "quick_add_add", "quick_add_cancel",
    "task_undo", "task_deleted", "task_restored", "task_moved_folder",
    # ── Phase P3: economy trend + supplies ──
    "economy_trend_title", "economy_trend_income", "economy_trend_expense",
    "economy_trend_net", "economy_period_7d", "economy_period_30d",
    "economy_period_90d", "economy_expense_split", "economy_trend_empty",
    "supplies_dlg_title_add", "supplies_dlg_title_edit", "supplies_name_ph",
    "supplies_category_ph", "supplies_unit_ph", "supplies_stock_lbl",
    "supplies_min_lbl", "supplies_price_lbl", "supplies_location_ph",
    "supplies_notes_ph", "supplies_economy_lbl", "supplies_stock_now",
    "supplies_tx_title", "supplies_tx_in", "supplies_tx_out",
    "supplies_tx_adjust", "supplies_qty_lbl", "supplies_note_ph",
    "supplies_restock_expense", "supplies_economy_amount",
    "supplies_economy_category_ph", "btn_save",
    "dashwidgets_title", "dashwidgets_hint", "dashwidgets_visible",
    "dashwidgets_hidden", "dashwidgets_compact", "dashwidgets_expanded",
    "dashwidgets_save", "dashwidgets_cancel", "wrapped_title", "wrapped_open",
    "wrapped_empty", "wrapped_hero", "wrapped_total", "wrapped_active_days",
    "wrapped_best", "wrapped_focus", "wrapped_level", "wrapped_streak",
    "wrapped_income", "wrapped_expense", "wrapped_top_habits", "talents_points",
    "talents_unlocked", "talents_unlock", "talents_locked_level",
    "talents_locked_prereq", "talents_no_points", "talents_tier",
    "web_retry", "web_err_action", "web_upload_too_large",
    "web_upload_bad_type", "web_upload_ok", "web_offline_gate_hint",
    # ── P3: Dashboard (rank card, stat cards, rings, insight, weekly, grafik tidur) ──
    "dashboard_progress", "dashboard_quick_actions", "dashboard_streak_days",
    "dashboard_tasks_done", "dashboard_boss_killed", "dashboard_sport_level",
    "dashboard_calories", "dashboard_habits", "dashboard_dailies",
    "dashboard_quests", "dashboard_sport", "dashboard_economy",
    "dashboard_achievements", "dashboard_level_progress", "dashboard_hp_progress",
    "dashboard_sport_progress", "dashboard_weekly_chart", "dashboard_title",
    "insights_title", "insights_no_data", "insights_top_day", "insights_best_day",
    "insights_longest", "insights_active", "insights_focus", "widget_health_chart",
    "rank_dialog_title", "rank_score_label", "rank_required_score",
    "rank_current_badge", "rank_unlocked_badge", "rank_locked_badge",
    "rank_footer_progress",
    "rank_pemula", "rank_penambang", "rank_penjelajah", "rank_petualang",
    "rank_ksatria", "rank_veteran", "rank_legenda", "rank_raja",
    "rank_penguasa_naga", "rank_dewa",
    "rank_desc_pemula", "rank_desc_penambang", "rank_desc_penjelajah",
    "rank_desc_petualang", "rank_desc_ksatria", "rank_desc_veteran",
    "rank_desc_legenda", "rank_desc_raja", "rank_desc_penguasa_naga",
    "rank_desc_dewa",
    # ── P3: Profile (foto & gelar) ──
    "title_none", "title_locked_hint", "title_selector_label",
    "profile_photo_change", "profile_photo_remove",
    "profile_photo_remove_title", "profile_photo_remove_confirm",
    # ── P3: Sport (MET, ranks, reps) ──
    "sport_rank_rookie", "sport_rank_bronze", "sport_rank_silver",
    "sport_rank_gold", "sport_rank_platinum", "sport_rank_diamond",
    "sport_rank_master", "sport_rank_mythic",
    "sport_reps_total_label", "sport_log_reps_sets", "sport_log_reps_reps",
    "sport_reps_logged", "sport_rank_up",
    "sport_reward_format", "task_streak_days",
    "sport_type_running", "sport_type_gym", "sport_type_cycling", "sport_type_swimming", "sport_type_yoga", "sport_type_football",
    "sport_type_calisthenics", "sport_type_martial_arts", "sport_type_badminton", "sport_type_other",
    "task_difficulty_easy", "task_difficulty_medium", "task_difficulty_hard", "task_difficulty_epic",
    # ── P14: Task template dialog (parity HabitTemplateDialog) ──
    "template_btn", "template_title", "template_subtitle", "template_no_templates",
    "template_count", "template_apply", "template_applied",
    # ── P15: Profile parity (rebirth modal, security, backup, lock) ──
    "profile_rebirth_title", "profile_rebirth_info", "profile_rebirth_btn",
    "profile_rebirth_confirm_title", "profile_rebirth_confirm_warning",
    "profile_rebirth_confirm_detail", "profile_rebirth_confirm_benefit",
    "profile_rebirth_confirm_placeholder", "profile_rebirth_confirm_btn",
    "profile_rebirth_cond_achievements", "profile_rebirth_cond_level",
    "profile_rebirth_cond_pets", "profile_rebirth_cond_items",
    "profile_rebirth_success_title", "profile_rebirth_loading",
    "profile_security", "profile_security_answer", "profile_save_security_btn",
    "security_questions_not_empty", "security_questions_saved",
    "backup_codes_intro", "backup_codes_warning", "backup_codes_title",
    "backup_code_generate_fail", "backup_codes_copy",
    "profile_redeem", "profile_redeem_placeholder", "profile_redeem_btn",
    "profile_redeem_desc", "redeem_code_empty", "redeem_admin_password_title",
    "redeem_admin_password_prompt", "redeem_admin_password_wrong",
    "redeem_admin_password_required",
    "profile_lock_account", "profile_account_locked", "profile_lock_confirm",
    "profile_unlock_account", "profile_unlock_confirm",
    "food_today", "food_cal_stat", "food_protein_stat", "food_carbs_stat", "food_fat_stat", "food_set_goals_btn",
    "food_calories_label", "food_protein_label", "food_carbs_label", "food_fat_label", "food_save_goals", "health_daily_targets",
    "food_tab_water", "food_water_goal_default", "food_water_set_goal", "water_progress_format", "food_water_add_250", "food_water_add_500",
    "food_water_add_1000", "food_water_custom_label", "food_water_log_title", "food_no_water_today", "food_water_goal_dialog_title", "food_water_goal_dialog_label",
    "dialog_add", "unit_ml", "unit_cm", "unit_kg", "unit_steps", "unit_hours",
    "food_bmi_title", "food_bmi_height", "food_bmi_weight", "food_bmi_age", "food_bmi_gender", "food_bmi_activity",
    "food_bmi_gender_m", "food_bmi_gender_f", "food_bmi_activity_sedentary", "food_bmi_activity_light", "food_bmi_activity_moderate", "food_bmi_activity_active",
    "food_bmi_activity_very_active", "food_bmi_save_profile", "food_bmi_calc", "food_bmi_set_target", "food_bmi_result", "food_bmi_result_format",
    "food_bmi_status_underweight", "food_bmi_status_normal", "food_bmi_status_overweight", "food_bmi_status_obese", "food_bmi_profile_saved", "food_target_updated_title",
    "food_target_updated_msg", "food_log_group_title", "food_no_logs_today", "food_meal_breakfast", "food_meal_lunch", "food_meal_dinner",
    "food_meal_snack", "food_log_name_serving", "food_nutrition_detail", "health_steps", "health_steps_value", "health_sleep",
    "health_sleep_value", "health_water", "health_water_value", "health_mood", "health_mood_value", "health_weight",
    "health_weight_value", "health_height", "health_height_value", "health_hr", "health_hr_value", "health_stress",
    "health_stress_value", "health_calories", "health_calories_value", "health_protein", "health_protein_value", "health_burned",
    "health_burned_value", "health_net_calories", "health_net_calories_value", "health_note_placeholder", "health_tab_input", "health_activity_group",
    "health_steps_label", "health_hr_label", "health_sleep_group", "health_sleep_label", "health_stress_label", "health_stress_low",
    "health_stress_normal", "health_stress_high", "health_mood_label", "health_mood_happy", "health_mood_normal", "health_mood_tired",
    "health_mood_sad", "health_notes_group", "health_notes_placeholder", "health_save", "health_data_saved", "saved_title",
    "health_avg_7days", "health_avg_7days_suffix", "health_avg_steps", "health_avg_sleep", "health_avg_water", "health_avg_hr",
    "health_unit_hour", "health_unit_ml", "health_unit_bpm", "health_weight_trend", "health_height_trend", "health_height_week_delta", "health_chart_weight",
    "health_chart_height", "health_tips", "health_tip_calorie_deficit", "health_tip_calorie_surplus", "health_tip_calorie_normal", "health_tip_static_1",
    "health_tip_static_2", "health_tip_static_3", "health_tip_static_4", "health_tip_static_5", "health_tip_static_6", "health_tip_static_7",
    "food_add_custom", "food_log", "food_recipes", "food_export", "food_export_format_title", "economy_export_label",
    "export_csv_option", "food_save_csv", "food_save_excel", "food_save_word", "food_save_pdf", "export_date",
    "export_xlsx_option", "export_docx_option", "food_export_days_hint",
    "export_calories", "export_protein", "export_carbs", "export_fat", "export_water_ml", "export_calories_burned",
    "export_net_calories", "health_nutrition_bonus_msg", "bonus_title", "level_up_bonus", "water_goal_reached",
    "rank_next_progress", "rank_max_label", "rank_view_all", "healthchart_title", "heatmap_less",
    "heatmap_more", "dashboard_recent_activity", "dashboard_xp", "title_select_label", "profile_photo_title",
    "photo_error_generic",
    "supplies_stat_items", "supplies_stat_low", "supplies_stat_value", "supplies_open_economy", "economy_open_supplies",
    "supplies_low_banner", "supplies_per_category", "supplies_history_title", "supplies_history_empty", "supplies_search_ph",
    "supplies_all_categories", "supplies_col_stock", "supplies_col_min", "supplies_col_price", "supplies_col_value",
    "supplies_empty",
    "economy_search", "economy_filter_all", "economy_filter_income", "economy_filter_expense", "economy_all_categories", "economy_folder",
    "economy_folder_label", "dialog_no_folder", "msg_name_empty", "economy_category_ph", "economy_category_hint", "economy_category_suggest",
    # WEB_I18N += P5 LovePage parity (93)
    "love_tab_overview",
    "love_tab_connection",
    "love_tab_cycle",
    "love_tab_memories",
    "love_tab_gallery",
    "love_tab_plans",
    "love_days_together",
    "love_next_moment",
    "love_connection",
    "love_my_mood",
    "love_partner_mood",
    "love_connection_score",
    "love_checkin_note_ph",
    "love_checkin_history",
    "love_upcoming",
    "love_connection_prompts",
    "love_prompt_all",
    "love_prompt_connection",
    "love_prompt_appreciation",
    "love_prompt_support",
    "love_prompt_future",
    "love_prompt_fun",
    "love_prompt_favorites",
    "love_prompt_shuffle",
    "love_prompt_favorite",
    "love_prompt_my_reflection",
    "love_prompt_my_ph",
    "love_prompt_partner_reflection",
    "love_prompt_partner_ph",
    "love_prompt_save",
    "love_prompt_history",
    "love_delete_selected",
    "love_weekly_review",
    "love_week_of",
    "love_review_appreciation_ph",
    "love_review_wins_ph",
    "love_review_support_ph",
    "love_review_intention_ph",
    "love_review_appreciation",
    "love_review_wins",
    "love_review_support",
    "love_review_intention",
    "love_review_save",
    "love_cycle_prediction",
    "love_cycle_for",
    "love_last_period",
    "love_cycle_length",
    "love_period_length",
    "love_save_cycle",
    "love_log_cycle",
    "love_cycle_history",
    "love_cycle_disclaimer",
    "love_cycle_no_data",
    "love_memories_title",
    "love_add_memory",
    "love_gallery_title",
    "love_gallery_all",
    "love_gallery_shared",
    "love_gallery_private",
    "love_gallery_upload",
    "love_gallery_select",
    "love_album_title",
    "love_album_new",
    "love_album_rename",
    "love_album_delete",
    "love_gallery_select_all",
    "love_gallery_bulk_delete",
    "love_gallery_bulk_private",
    "love_gallery_bulk_shared",
    "love_events",
    "love_add",
    "love_bucket_list",
    "love_gallery_count",
    "love_gallery_selected_count",
    "love_album_choose",
    "love_album_copy_to",
    "love_album_move_to",
    "love_album_remove",
    "love_album_personal",
    "love_gallery_delete_title",
    "love_gallery_delete_confirm",
    "love_gallery_pick_multi",
    "love_gallery_multi_result",
    "love_cycle_range",
    "love_cycle_days_until",
    "love_edit_profile",
    "love_open_tracking",
    "couple_end",
    "love_gallery_privacy_hint",
    "love_album_scope_label",
    "love_confirm",
    "love_delete",
    "love_checkin_saved",
    # WEB_I18N += P5 LovePage seluruh halaman (66)
    "berhasil_title",
    "couple_end_confirm",
    "couple_end_local_success",
    "couple_end_title",
    "couple_result_invalid_request",
    "gagal_title",
    "love_add_bucket",
    "love_add_event",
    "love_album_all",
    "love_album_copied",
    "love_album_create",
    "love_album_created",
    "love_album_delete_confirm",
    "love_album_empty",
    "love_album_err_album",
    "love_album_err_name",
    "love_album_moved",
    "love_album_name_ph",
    "love_album_no_albums",
    "love_album_removed",
    "love_album_scope",
    "love_album_shared",
    "love_album_shared_need_couple",
    "love_category",
    "love_category_date",
    "love_category_dream",
    "love_category_milestone",
    "love_checkin_row",
    "love_checkin_today_done",
    "love_checkin_today_none",
    "love_cloud_migration_required",
    "love_cloud_write_failed",
    "love_cloud_write_local_fallback",
    "love_couple_format",
    "love_couple_linked",
    "love_couple_not_linked",
    "love_cycle_available",
    "love_cycle_gender_notice",
    "love_date_label",
    "love_gallery_access_denied",
    "love_gallery_delete",
    "love_gallery_deselect_all",
    "love_gallery_edit",
    "love_gallery_empty",
    "love_gallery_meta",
    "love_gallery_private_hint",
    "love_gallery_shared_hint",
    "love_gallery_toggle_tip",
    "love_gallery_untitled",
    "love_health_sync",
    "love_myself",
    "love_no_upcoming",
    "love_partner_not_set",
    "love_period_end",
    "love_period_start",
    "love_prompt_answer_required",
    "love_prompt_empty_history",
    "love_prompt_no_favorites",
    "love_prompt_unfavorite",
    "love_review_empty_history",
    "love_review_required",
    "love_title_label",
    "msg_cancel",
    "msg_error",
    "msg_ok",

    # WEB_I18N += P5 prompt bank (20)
    "love_prompt_connection_seen",
    "love_prompt_connection_safe",
    "love_prompt_connection_listen",
    "love_prompt_connection_closer",
    "love_prompt_appreciation_small",
    "love_prompt_appreciation_quality",
    "love_prompt_appreciation_memory",
    "love_prompt_appreciation_growth",
    "love_prompt_support_stress",
    "love_prompt_support_request",
    "love_prompt_support_energy",
    "love_prompt_support_team",
    "love_prompt_future_year",
    "love_prompt_future_home",
    "love_prompt_future_skill",
    "love_prompt_future_priority",
    "love_prompt_fun_date",
    "love_prompt_fun_laugh",
    "love_prompt_fun_adventure",
    "love_prompt_fun_switch",

    # WEB_I18N += P5 learning studio
    "learning_export",
    "learning_export_title",
    "learning_export_done",
    "learning_export_extension_error",
    "learning_font_size",
    "learning_font_chat",
    "learning_font_studio",
    "learning_font_decrease",
    "learning_font_increase",
    "learning_font_reset",
    "learning_mindmap_invalid",

    # WEB_I18N += Learning parity keys
    "learning_history",
    "learning_view",
    "learning_rename_title",
    "learning_no_title",
    "learning_delete_gen",
    "learning_topic_label",
    "learning_upload_source",
    # WEB_I18N += P38 learning parity
    "learning_title_label",
    "learning_type_label",
    "learning_nb_title_ph",
    "learning_nb_desc_ph",
    "learning_source_title_ph",
    "learning_source_content_ph",
    "learning_generic_topic",
    "learning_quiz_evaluated",
    "learning_quiz_check_score",
    # WEB_I18N += P6 pomodoro parity
    "pomodoro_task_label",
    "pomodoro_task_placeholder",
    "pomodoro_focus_label",
    "pomodoro_break_label",
    "pomodoro_minutes_unit",
    "pomodoro_start",
    "pomodoro_pause",
    "pomodoro_resume",
    "pomodoro_reset",
    "pomodoro_give_up",
    "pomodoro_state_focus",
    "pomodoro_state_break",
    "pomodoro_state_idle",
    "pomodoro_complete_title",
    "pomodoro_complete_msg",
    "pomodoro_break_done",
    "pomodoro_break_done_title",
    "pomodoro_start_break",
    "pomodoro_back_to_focus",
    "pomodoro_today",
    "pomodoro_total",
    "pomodoro_stat_sessions",
    "pomodoro_stat_minutes",
    "pomodoro_recent",
    "pomodoro_no_recent",
    "pomodoro_test_alarm",
    "pomodoro_test_alarm_info",
    "level_up_msg",
    # WEB_I18N += P6 music parity
    "music_title_plain",
    "music_subtitle",
    "music_title",
    "music_select_folder",
    "music_now_playing",
    "music_play",
    "music_pause",
    "music_next",
    "music_prev",
    "music_shuffle",
    "music_repeat",
    "music_select_playlist",
    "music_playlist_label",
    "music_save_playlist",
    "music_delete_playlist",
    "music_playlist_playing",
    "music_no_tracks_to_save",
    "music_save_playlist_title",
    "music_playlist_name",
    "music_playlist_saved",
    "music_delete_playlist_confirm",
    "music_playlist_deleted",
    "music_format_error",
    "music_resource_error",
    "music_lyrics",
    "music_no_lyrics",
    "music_lyrics_not_found",
    "music_download_title",
    "music_search_web",
    "music_btn_search",
    "music_url_placeholder",
    "music_btn_download",
    "music_target_playlist",
    "music_no_results",
    "music_downloading",
    "music_download_done",
    "music_download_failed",
    "music_format_unsupported",
    "music_need_ytdlp",
    "music_lyrics_searching",
    "music_lyrics_from_file",
    "music_lyrics_from_web",
    "music_new_playlist",
    "music_add_song",
    "music_delete_playlist",
    "music_move_to_playlist",
    "music_copy_to_playlist",
    "music_remove_from_playlist",
    "music_add_files",
    "music_your_library",
    "music_now_playing_kicker",
    "music_nothing_playing",
    "music_choose_track",
    "music_search_placeholder",
    "music_track_title",
    "music_artist",
    "music_album",
    "music_duration",
    "music_track_count",
    "music_rename_playlist",
    "music_audio_filter",
    "music_unknown_artist",
    "music_unknown_album",
    "music_missing_file",
    "music_add_to_favorites",
    # WEB_I18N += P7 notes/reminder/calendar parity
    "notes_title",
    "notes_add_folder",
    "notes_add_note",
    "notes_delete",
    "notes_archive",
    "notes_save",
    "notes_title_label",
    "notes_content_label",
    "notes_no_folder",
    "notes_count_format",
    "notes_folder_label",
    "notes_list_label",
    "notes_note_title_ph",
    "notes_note_content_ph",
    "notes_saved",
    "notes_deleted",
    "notes_archived",
    "notes_unarchived",
    "notes_delete_confirm",
    "notes_folder_name",
    "notes_folder_name_ph",
    "notes_show_archived",
    "notes_hide_archived",
    "notes_archive_empty",
    "notes_add_subfolder",
    "notes_subfolder_title",
    "notes_subfolder_name",
    "notes_edit_folder_title",
    "notes_folder_delete_confirm",
    "notes_all",
    "notes_folder",
    "notes_folder_icon_default",
    "notes_folder_icon_star",
    "notes_folder_icon_heart",
    "notes_edit",
    "notes_delete",
    "notes_edit_folder",
    "notes_edit_folder_title",
    "notes_add_subfolder",
    "notes_subfolder_title",
    "notes_subfolder_name",
    "notes_all",
    "notes_no_folder",
    "notes_folder_label",
    "notes_folder_name_ph",
    "notes_folder_delete_confirm",
    "notes_folder",
    "notes_add_folder",
    "notes_folder_name",
    "notes_edit_icon",
    "notes_duplicate_folder",
    "notes_duplicate_title",
    "notes_duplicate_choose_folder",
    "notes_duplicate_btn",
    "notes_attach_file",
    "notes_attach_paste_hint",
    "notes_attach_delete_confirm",
    "notes_attach_too_large",
    "notes_attach_type_unsupported",
    "notes_attach_open",
    "notes_attach_download",
    "notes_math_palette_greek",
    "notes_math_palette_operators",
    "notes_math_palette_arrows",
    "notes_math_palette_relations",
    "notes_math_palette_calculus",
    "notes_math_palette_letters",
    "notes_math_palette_templates",
    "folder_edit_title",
    "folder_edit_icon",
    "folder_icon_picker_title",
    "folder_icon_reset",
    "essay_answer_ph",
    "quiz_model_answer",
    "quiz_score",
    "panel_resize_hint",
    "panel_slider_aria",
    "music_miniplayer_now_playing",
    "music_miniplayer_open",
    "music_lyrics_saved_badge",
    "music_lyrics_save",
    "music_lyrics_saved_ok",
    "music_lyrics_delete_saved",
    "music_lyrics_import",
    "music_lyrics_import_ok",
    "music_lyrics_import_invalid",
    "music_lyrics_offset",
    "music_lyrics_offset_reset",
    "music_lyrics_match_duration",
    # A01: lirik mengikuti lagu yang diputar (drawer).
    "music_lyrics_now_for",
    "music_lyrics_track_change_hint",
    "music_lyrics_disabled_no_track",
    "music_lyrics_scroll_paused",
    # A02: perluasan & akurasi pencarian lirik.
    "music_lyrics_candidates",
    "music_lyrics_search_expand",
    "music_lyrics_use",
    "music_lyrics_duration_match",
    "music_lyrics_duration_off",
    "music_lyrics_version_warning",
    "music_lyrics_source_lrclib",
    "music_lyrics_source_ovh",
    "music_lyrics_source_embedded",
    "music_lyrics_source_user",
    "music_lyrics_source_pick",
    "music_lyrics_no_candidates",
    "music_lyrics_index_hint",
    "music_lyrics_score",
    "music_lyrics_close",
    # A03.5: unduhan/ekspor ke komputer.
    "download_saved_title",
    "download_saved_msg",
    "download_started_msg",
    "download_failed_title",
    "download_failed_msg",
    "download_folder_default",
    "download_open_folder",
    "download_open_failed",
    "download_web_mode_note",
    # A13: Year Wrapped (mata uang aktif user + pemilih tahun).
    "wrapped_tasks_done",
    "wrapped_net",
    "wrapped_saving_rate",
    "wrapped_by_type",
    "wrapped_currency_note",
    "wrapped_currency_note_idr",
    "wrapped_pick_year",
    "wrapped_copy",
    "wrapped_download",
    "wrapped_copied",
    "wrapped_error",
    "wrapped_type_habit",
    "wrapped_type_daily",
    "wrapped_type_todo",
    "wrapped_type_sport",
    "wrapped_type_other",
    # A12: tab overview + Special Day → Reminder tahunan.
    "reminders_repeat_yearly_hint",
    "reminders_repeat_until_hint",
    "love_score_short",
    "love_checkin_today_short",
    "love_days_ago",
    "love_me",
    "love_together_days",
    "love_together_years",
    "love_hero_title",
    "love_hero_since",
    "love_hero_no_date",
    "love_empty_cta",
    "love_rel_dating",
    "love_rel_engaged",
    "love_rel_married",
    "love_overview_sub",
    "love_next_special",
    "love_special_none",
    "love_special_today",
    "love_special_tomorrow",
    "love_in_days",
    "love_years_count",
    "love_create_reminder",
    "love_reminder_created",
    "love_reminder_created_detail",
    "love_reminder_exists",
    "love_reminder_no_date",
    "love_reminder_bad_event",
    "love_reminder_from_love",
    "love_reminder_anniversary",
    "love_reminder_birthday",
    "love_reminder_repeat_yearly",
    "love_reminder_repeat_once",
    "love_reminder_hint",
    "love_special_remind_days",
    "love_special_days_list",
    "love_special_source_profile",
    "love_open_reminders",
    "love_score_ring",
    "love_score_breakdown",
    "love_score_last_checkin",
    "love_score_no_checkin",
    "love_score_avg_my",
    "love_score_avg_partner",
    "love_stat_title",
    "love_stat_memories",
    "love_stat_bucket_done",
    "love_stat_photos",
    "love_stat_prompts",
    "love_stat_checkins_month",
    "love_stat_albums",
    "love_stat_bucket_of",
    "love_quick_title",
    "love_quick_checkin",
    "love_quick_checkin_done",
    "love_quick_memory",
    "love_quick_event",
    "love_quick_bucket",
    "love_quick_reminders",
    "reminders_repeat_yearly",
    "reminders_badge_yearly",
    "reminders_source_love",
    "dash_next_special",
    "dash_next_special_today",
    # A11: tab connection · cycle · gallery.
    "love_cycle_no_fields",
    "love_conn_streak",
    "love_conn_streak_sub",
    "love_conn_stat_total",
    "love_conn_my_mood",
    "love_conn_partner_mood",
    "love_conn_score",
    "love_conn_mood_trend",
    "love_conn_range_30",
    "love_conn_range_90",
    "love_conn_trend_empty",
    "love_conn_points",
    "love_conn_score_trend",
    "love_conn_ask_partner",
    "love_conn_pool_count",
    "love_conn_history",
    "love_conn_search_ph",
    "love_conn_filter_all",
    "love_conn_only_favorites",
    "love_conn_showing",
    "love_conn_reuse",
    "love_conn_no_match",
    "love_conn_empty_history",
    "love_conn_favorites",
    "love_conn_favorites_empty",
    "love_conn_use",
    "love_conn_copied",
    "love_prompt_daily",
    "love_cycle_stat_count",
    "love_cycle_stat_avg",
    "love_cycle_stat_last",
    "love_cycle_next",
    "love_cycle_confidence",
    "love_cycle_confidence_low",
    "love_cycle_confidence_medium",
    "love_cycle_confidence_high",
    "love_cycle_ovulation",
    "love_cycle_fertile",
    "love_cycle_based_on",
    "love_cycle_based_on_value",
    "love_cycle_add_reminder",
    "love_cycle_reminder_title",
    "love_cycle_reminder_toast",
    "love_cycle_history",
    "love_cycle_history_summary",
    "love_cycle_history_empty",
    "love_cycle_add",
    "love_cycle_save",
    "love_cycle_save_edit",
    "love_cycle_edit_title",
    "love_cycle_notes",
    "love_cycle_notes_ph",
    "love_cycle_running",
    "love_cycle_days_count",
    "love_cycle_date_required",
    "love_cycle_date_invalid",
    "love_cycle_range_invalid",
    "love_gallery_album_count",
    "love_gallery_photos_short",
    "love_gallery_album_cover",
    "love_gallery_cover_saved",
    "love_gallery_cover_need_album",
    "love_gallery_select_mode",
    "love_gallery_bulk_move",
    "love_gallery_bulk_move_go",
    "love_gallery_bulk_deleted",
    "love_gallery_bulk_moved",
    "love_gallery_bulk_visibility",
    "love_gallery_none_selected",
    "love_gallery_invalid_action",
    "love_gallery_invalid_visibility",
    "love_gallery_save_meta",
    "love_gallery_caption_ph",
    "love_gallery_add_to_album",
    "love_gallery_no_match",
    "love_gallery_zoom_hint",
    "love_album_copy_to",
    "love_album_move_to",
    "love_album_remove",
    "love_album_picked",
    "love_album_invalid",
    "love_actions",
    # A10: tab memories & Bucket List (A10).
    "love_memory_add_title",
    "love_memory_edit_title",
    "love_memory_create",
    "love_memory_save",
    "love_memory_saving",
    "love_memory_emoji",
    "love_memory_emoji_custom",
    "love_memory_title",
    "love_memory_title_ph",
    "love_memory_title_required",
    "love_memory_date_required",
    "love_memory_tags",
    "love_memory_tags_ph",
    "love_memory_notes",
    "love_memory_notes_ph",
    "love_memory_link_photo",
    "love_memory_photo_none",
    "love_memory_photo_empty",
    "love_memory_favorite",
    "love_memory_favorite_on",
    "love_memory_favorite_off",
    "love_memory_count",
    "love_memory_stat_total",
    "love_memory_stat_fav",
    "love_memory_stat_tagged",
    "love_memory_stat_photo",
    "love_memory_search_ph",
    "love_memory_filter_year",
    "love_memory_year_all",
    "love_memory_tag_all",
    "love_memory_sort",
    "love_memory_sort_newest",
    "love_memory_sort_oldest",
    "love_memory_only_fav",
    "love_memory_has_photo",
    "love_memory_edited_at",
    "love_memory_empty",
    "love_memory_no_match",
    "love_memory_delete_confirm",
    "love_memory_updated",
    "love_memory_added",
    "love_bucket_add_title",
    "love_bucket_edit_title",
    "love_bucket_create",
    "love_bucket_save",
    "love_bucket_saving",
    "love_bucket_title_ph",
    "love_bucket_title_required",
    "love_bucket_category",
    "love_bucket_category_dream",
    "love_bucket_category_travel",
    "love_bucket_category_experience",
    "love_bucket_category_learning",
    "love_bucket_category_gift",
    "love_bucket_category_home",
    "love_bucket_target_date",
    "love_bucket_target_optional",
    "love_bucket_target_past",
    "love_bucket_priority",
    "love_bucket_priority_none",
    "love_bucket_priority_n",
    "love_bucket_notes",
    "love_bucket_notes_ph",
    "love_bucket_mark_done",
    "love_bucket_mark_open",
    "love_bucket_add",
    "love_bucket_quick_ph",
    "love_bucket_search_ph",
    "love_bucket_filter_all",
    "love_bucket_filter_open",
    "love_bucket_filter_done",
    "love_bucket_filter_late",
    "love_bucket_stat_total",
    "love_bucket_stat_done",
    "love_bucket_stat_open",
    "love_bucket_stat_overdue",
    "love_bucket_progress",
    "love_bucket_overdue",
    "love_bucket_overdue_days",
    "love_bucket_h_days",
    "love_bucket_promote",
    "love_bucket_promote_short",
    "love_bucket_is_memory",
    "love_bucket_promoted",
    "love_bucket_empty",
    "love_bucket_no_match",
    "love_bucket_delete_confirm",
    "love_bucket_updated",
    "love_bucket_added",
    "love_gallery_privacy_hint",
    "love_category_travel",
    "love_category_gift",
    # A09: tab plans Love Space — dialog acara, catatan, Special Day & pengingat.
    "love_event_add_title",
    "love_event_edit_title",
    "love_event_create",
    "love_event_save",
    "love_event_saving",
    "love_event_date",
    "love_event_category",
    "love_event_location",
    "love_event_location_ph",
    "love_event_icon",
    "love_event_icon_auto",
    "love_event_icon_default",
    "love_event_icon_custom",
    "love_event_title_ph",
    "love_event_title_required",
    "love_event_date_required",
    "love_event_notes",
    "love_event_notes_ph",
    "love_event_notes_hint",
    "love_event_special",
    "love_event_special_hint",
    "love_event_recurring",
    "love_event_remind_before",
    "love_event_remind_none",
    "love_event_remind_days",
    "love_event_remind_short",
    "love_event_upcoming",
    "love_event_past",
    "love_event_today",
    "love_event_tomorrow",
    "love_event_in_days",
    "love_event_days_ago",
    "love_event_in_past",
    "love_event_next_yearly",
    "love_event_pick_date",
    "love_event_special_upcoming",
    "love_event_special_count",
    "love_event_search_ph",
    "love_event_filter_all",
    "love_event_only_special",
    "love_event_empty",
    "love_event_no_match",
    "love_event_updated",
    "love_event_added",
    "love_category_anniversary",
    "love_category_trip",
    # A08: sitasi sumber, grounding & pemutar podcast dua host.
    "play",
    "pause",
    "learning_citations_found",
    "learning_citation_source_n",
    "learning_open_source",
    "learning_grounding_on",
    "learning_sources_selected_count",
    "learning_filter_sources",
    "learning_podcast_title",
    "learning_podcast_hosts_voices",
    "learning_podcast_seek",
    "learning_podcast_back15",
    "learning_podcast_fwd15",
    "learning_podcast_speed",
    "learning_podcast_loop",
    "learning_podcast_loop_short",
    "learning_podcast_follow",
    "learning_podcast_follow_short",
    "learning_podcast_download",
    "learning_podcast_download_short",
    "learning_podcast_regenerate",
    "learning_podcast_regenerate_short",
    "learning_podcast_generating_hint",
    "learning_podcast_generate_hint",
    "learning_podcast_engine",
    "learning_podcast_host",
    "learning_podcast_now",
    "learning_podcast_no_turns",
    "learning_podcast_audio_failed",
    "learning_podcast_audio_ready",
    "learning_podcast_audio_ready_detail",
    "learning_no_podcast",
    # A07: shell Learning ala NotebookLM (rail · topbar · panel preset).
    "learning_nb_switcher",
    "learning_rail_expand",
    "learning_rail_collapse",
    "learning_workspace_short",
    "learning_view_sources",
    "learning_view_chat",
    "learning_view_studio",
    "learning_topbar_sources",
    "learning_topbar_ready",
    "learning_rename_short",
    "learning_add_source_hint",
    "learning_source_search_ph",
    "learning_source_no_match",
    "learning_source_used",
    "learning_source_unused",
    "learning_source_type_pdf",
    "learning_source_type_doc",
    "learning_source_type_text",
    "learning_source_type_url",
    "learning_source_type_youtube",
    "learning_panel_narrow",
    "learning_panel_medium",
    "learning_panel_wide",
    "learning_panel_collapse",
    "learning_panel_width_hint",
    "learning_panel_preset_hint",
    "learning_suggestion_q1",
    "learning_suggestion_q2",
    "learning_suggestion_q3",
    "learning_suggestion_q4",
    # A06: daftar artefak Studio (list ke bawah) + aksi kartu.
    "learning_artifacts",
    "learning_artifacts_count",
    "learning_artifact_open",
    "learning_artifact_rename",
    "learning_artifact_export_md",
    "learning_artifact_duplicate",
    "learning_artifact_delete",
    "learning_artifact_items_quiz",
    "learning_artifact_items_cards",
    "learning_artifact_items_turns",
    "learning_artifact_empty_title",
    "learning_artifact_empty_hint",
    "learning_artifact_filter_all",
    "learning_artifact_sort_newest",
    "learning_artifact_sort_oldest",
    "learning_artifact_sort_type",
    "learning_artifact_renamed",
    "learning_artifact_now",
    "learning_artifact_min_ago",
    "learning_artifact_hour_ago",
    "learning_artifact_day_ago",
    "learning_artifact_items_words",
    "learning_artifact_preview",
    "learning_artifact_search_ph",
    "learning_artifact_sort",
    "learning_artifact_empty_filtered",
    "learning_artifact_empty_content",
    "learning_artifact_active",
    "learning_artifact_edited",
    "learning_artifact_open_hint",
    "learning_artifact_not_latest",
    "learning_artifact_rename_title",
    "learning_artifact_rename_ph",
    "learning_artifact_export_txt",
    "learning_artifact_export_done",
    "learning_artifact_export_failed",
    "learning_artifact_duplicated",
    "learning_artifact_deleted",
    "learning_artifact_interactive",
    "learning_not_found",
    # A05: dialog konfigurasi per tipe Studio.
    "learning_dialog_title",
    "learning_dialog_config",
    "learning_dialog_sources_summary",
    "learning_dialog_no_sources",
    "learning_dialog_advanced",
    "learning_dialog_remember",
    "learning_dialog_reset_default",
    "learning_dialog_generate_now",
    "learning_dialog_generating",
    "learning_dialog_last_settings",
    "learning_dialog_edit_settings",
    "learning_dialog_open_hint",
    "learning_dialog_quick_hint",
    "learning_dialog_toggle_on",
    "learning_dialog_toggle_off",
    "learning_dialog_blurb_summary",
    "learning_dialog_blurb_study_guide",
    "learning_dialog_blurb_flashcards",
    "learning_dialog_blurb_faq",
    "learning_dialog_blurb_mindmap",
    "learning_dialog_blurb_timeline",
    "learning_dialog_blurb_quiz",
    "learning_dialog_blurb_podcast",
    "learning_opt_difficulty",
    "learning_opt_difficulty_easy",
    "learning_opt_difficulty_mixed",
    "learning_opt_difficulty_hard",
    "learning_opt_language",
    "learning_opt_language_auto",
    "learning_opt_language_hint",
    "learning_opt_lang_id",
    "learning_opt_lang_en",
    "learning_opt_focus",
    "learning_opt_focus_hint",
    "learning_opt_card_style",
    "learning_opt_card_style_term",
    "learning_opt_card_style_qa",
    "learning_opt_card_style_formula",
    "learning_opt_host_style",
    "learning_opt_host_casual",
    "learning_opt_host_formal",
    "learning_opt_host_debate",
    "learning_opt_length",
    "learning_opt_length_short",
    "learning_opt_length_standard",
    "learning_opt_length_deep",
    "learning_opt_depth",
    "learning_opt_depth_hint",
    "learning_opt_branches",
    "learning_opt_subs",
    "learning_opt_sections",
    "learning_opt_sections_hint",
    "learning_opt_section_summary",
    "learning_opt_section_concepts",
    "learning_opt_section_examples",
    "learning_opt_section_practice",
    "learning_opt_section_conclusion",
    "learning_opt_exercises",
    "learning_opt_faq_count",
    "learning_opt_answer_style",
    "learning_opt_answer_brief",
    "learning_opt_answer_detail",
    "learning_opt_granularity",
    "learning_opt_granularity_day",
    "learning_opt_granularity_week",
    "learning_opt_granularity_month",
    "learning_opt_granularity_year",
    "learning_opt_absolute_dates",
    "learning_opt_absolute_dates_hint",
    "learning_opt_summary_style",
    "learning_opt_summary_bullets",
    "learning_opt_summary_narrative",
    "learning_opt_custom_instructions",
    "learning_opt_custom_instructions_hint",
    "ai_thinking",
    "learning_gen_done_title",
    "learning_gen_done_msg",
    "learning_gen_flashcards",
    "learning_gen_flashcards_done",
    "learning_gen_flashcards_failed",
    "learning_gen_audio_title",
    "learning_gen_audio",
    "learning_gen_audio_done",
    "learning_gen_audio_failed",
    # A04: kuis — dua counter PG/Essay, skor komposit, nilai mandiri.
    "learning_quiz_mc_count",
    "learning_quiz_essay_count",
    "learning_quiz_total_count",
    "learning_quiz_total_over",
    "learning_quiz_total_zero",
    "learning_quiz_preset_default",
    "learning_quiz_preset_full",
    "learning_quiz_preset_mc_only",
    "learning_quiz_preset_essay_only",
    "learning_quiz_answer_hint",
    "learning_quiz_essay_self_mark",
    "learning_quiz_essay_done",
    "learning_quiz_essay_partial",
    "learning_quiz_essay_missing",
    "learning_quiz_score_detail",
    "learning_quiz_score_hint",
    "learning_quiz_review_again",
    "learning_quiz_show_model_answers",
    "learning_quiz_hide_model_answers",
    "learning_quiz_count_title",
    "learning_quiz_no_model_answer",
    "learning_quiz_ready_title",
    "learning_quiz_ready_msg",
    "learning_quiz_generating",
    "learning_flashcard_count_label",
    # A03: import lirik manual — panduan, template, validasi, ekspor.
    "music_lyrics_import_title",
    "music_lyrics_import_drop",
    "music_lyrics_import_format",
    "music_lyrics_format_lrc_desc",
    "music_lyrics_format_plain_desc",
    "music_lyrics_format_tags_desc",
    "music_lyrics_download_template",
    "music_lyrics_validate",
    "music_lyrics_validate_ok",
    "music_lyrics_validate_plain",
    "music_lyrics_validate_warn",
    "music_lyrics_export",
    "music_lyrics_copy_example",
    "music_lyrics_import_guide",
    "music_lyrics_import_tab",
    "music_lyrics_guide_tab",
    "music_lyrics_import_file",
    "music_lyrics_import_save",
    "music_lyrics_import_empty",
    "music_lyrics_copied",
    "music_lyrics_export_ok",
    "music_lyrics_export_none",
    "music_lyrics_export_unsaved",
    "music_lyrics_meta_read",
    "music_lyrics_breaks",
    "music_lyrics_offset_applied",
    "music_lyrics_warn_no_timestamps",
    "music_lyrics_warn_untimed_lines",
    "music_lyrics_warn_duplicate_timestamps",
    "music_lyrics_warn_unknown_tags",
    "music_lyrics_warn_too_few_lines",
    "music_lyrics_warn_first_line_late",
    "music_lyrics_warn_beyond_track_duration",
    "music_lyrics_warn_offset_bad_value",
    "music_playlist_icon_change",
    "music_playlist_icon_emoji",
    "music_playlist_icon_photo",
    "music_playlist_icon_reset",
    "music_playlist_icon_too_large",
    "music_playlist_icon_ok",
    "music_playlist_icon_hint",
    "love_couple_status_active",
    "love_couple_status_pending",
    "love_couple_status_none",
    "love_couple_partner_card",
    "settings_maintenance_title",
    "settings_db_size",
    "settings_cleanup_now",
    "settings_cleanup_confirm",
    "settings_cleanup_done",
    "settings_cleanup_retention",
    "settings_cleanup_retention_1d",
    "settings_cleanup_retention_7d",
    "settings_cleanup_retention_30d",
    "settings_cleanup_retention_90d",
    "settings_cleanup_retention_off",
    "settings_cleanup_auto",
    "settings_cleanup_estimate",
    "settings_cleanup_last",
    "settings_cleanup_warning",
    "notes_duplicate_tooltip",
    "notes_select_note_first",
    "notes_edit_icon_title",
    "notes_bold",
    "notes_italic",
    "notes_underline",
    "notes_strike",
    "notes_superscript",
    "notes_subscript",
    "notes_latex",
    "notes_select_icon",
    "notes_folder_info",
    "notes_icon_updated",
    "notes_folder_renamed",
    "notes_subfolder_added",
    "notes_search_placeholder",
    "notes_search_result",
    "notes_zoom_label",
    "notes_select_icon",
    "notes_to_learning",
    "notes_to_learning_title",
    "notes_to_learning_no_note",
    "notes_to_learning_empty",
    "notes_to_learning_notebook",
    "notes_to_learning_new_nb_ph",
    "notes_to_learning_sent",
    "notes_to_learning_need_notebook",
    "notes_font_preserved",
    "notes_math_btn_tooltip",
    "notes_math_convert_sel",
    "notes_math_convert_all",
    "notes_math_preview",
    "notes_math_none",
    "notes_math_converted",
    "notes_math_preview_title",
    "notes_math_render_fail",
    "calendar_title",
    "calendar_note_title",
    "calendar_note_label",
    "calendar_note_placeholder",
    "calendar_holiday_info",
    "calendar_holiday_tooltip",
    "calendar_delete",
    "expand_all",
    "collapse_all",

    # WEB_I18N += P7 Reminders parity (dialog, repeat, sound, due)
    "confirm_title",
    "day_0",
    "day_1",
    "day_2",
    "day_3",
    "day_4",
    "day_5",
    "day_6",
    "day_fri",
    "day_fri_short",
    "day_mon",
    "day_mon_short",
    "day_sat",
    "day_sat_short",
    "day_sun",
    "day_sun_short",
    "day_thu",
    "day_thu_short",
    "day_tue",
    "day_tue_short",
    "day_wed",
    "day_wed_short",
    "dialog_save",
    "msg_no",
    "msg_yes",
    "page_reminders_subtitle",
    "page_reminders_title",
    "reminders_add",
    "reminders_add_title",
    "reminders_added",
    "reminders_alert_title",
    "reminders_browse",
    "reminders_custom_days_required",
    "reminders_custom_file_required",
    "reminders_datetime_label",
    "reminders_delete",
    "reminders_delete_confirm",
    "reminders_deleted",
    "reminders_desc_label",
    "reminders_desc_ph",
    "reminders_edit",
    "reminders_edit_title",
    "reminders_empty",
    "reminders_invalid_datetime",
    "reminders_notification",
    "reminders_past_datetime_confirm",
    "reminders_refresh",
    "reminders_repeat_custom",
    "reminders_repeat_daily",
    "reminders_repeat_label",
    "reminders_repeat_none",
    "reminders_repeat_until_label",
    "reminders_repeat_weekly",
    "reminders_select_mp3",
    "reminders_sound_beep1",
    "reminders_sound_beep2",
    "reminders_sound_custom",
    "reminders_sound_default",
    "reminders_sound_label",
    "reminders_test",
    "reminders_test_msg",
    "reminders_test_title",
    "reminders_title",
    "reminders_title_label",
    "reminders_title_ph",
    "reminders_title_required",
    "reminders_toggle",
    "reminders_updated",

    # WEB_I18N += P7 Calendar year-view parity
    "btn_cancel",
    "month_01",
    "month_02",
    "month_03",
    "month_04",
    "month_05",
    "month_06",
    "month_07",
    "month_08",
    "month_09",
    "month_10",
    "month_11",
    "month_12",
    "page_calendar_subtitle",
    "page_calendar_title",

    # WEB_I18N += P8 crafting/shop/pets parity
    "crafting_btn",
    "crafting_gold_cost",
    "crafting_gold_short",
    "crafting_have_tag",
    "crafting_missing_tag",
    "crafting_needs",
    "crafting_owned",
    "crafting_subtitle",
    "crafting_title",
    "db_enchant_max",
    "db_enchant_no_xp",
    "db_enchant_not_allowed",
    "db_enchant_success",
    "db_gold_insufficient",
    "db_pet_adopted",
    "db_pet_already_active",
    "db_pet_already_owned",
    "db_pet_equip_fail",
    "db_pet_equipped",
    "db_pet_fed",
    "db_pet_hungry",
    "db_pet_level_up",
    "db_pet_max_level",
    "db_pet_not_active",
    "db_pet_not_found",
    "db_pet_trained",
    "db_pet_unequipped",
    "enchant_btn",
    "enchant_first_btn",
    "enchant_level_tag",
    "enchant_max_tag",
    "enchant_success_title",
    "item_used_title",
    "page_crafting_subtitle",
    "page_crafting_title",
    "page_pets_subtitle",
    "page_pets_title",
    "page_shop_subtitle",
    "page_shop_title",
    "pet_active_title",
    "pet_adopted",
    "pet_already_owned",
    "pet_equipped",
    "pet_fed",
    "pet_fed_success",
    "pet_hungry",
    "pet_level_up",
    "pet_level_up_notif",
    "pet_max_level",
    "pet_not_found",
    "pet_trained",
    "pet_trained_success",
    "pet_unequipped",
    "pets_active_info",
    "pets_buff_dmg_format",
    "pets_buff_gold_format",
    "pets_buff_reduc_format",
    "pets_buff_xp_format",
    "pets_empty",
    "pets_exp_format",
    "pets_feed",
    "pets_hunger",
    "pets_level_label",
    "pets_max_1",
    "pets_max_2",
    "pets_max_n",
    "pets_title",
    "pets_train",
    "shop_active",
    "shop_adopt",
    "shop_buff_active",
    "shop_buff_boss_dmg",
    "shop_buff_gold",
    "shop_buff_hp_reduc",
    "shop_buff_mp",
    "shop_buff_totem",
    "shop_buff_xp",
    "shop_buy",
    "shop_buy_again",
    "shop_equip",
    "shop_no_buffs",
    "shop_owned",
    "shop_seasonal_badge",
    "shop_sell",
    "shop_sell_confirm",
    "shop_sell_price",
    "shop_sell_quantity",
    "shop_sell_title",
    "shop_tab_items",
    "shop_tab_pets",
    "shop_title",
    "shop_type_armor",
    "shop_type_consumable",
    "shop_type_legendary",
    "shop_type_special",
    "shop_type_tool",
    "shop_type_weapon",
    "shop_unequip",
    "shop_use",

    # WEB_I18N += P9 friends/guild parity
    "boss_action_block_label",
    "boss_action_block_tip",
    "boss_action_heavy_label",
    "boss_action_heavy_tip",
    "boss_action_light_label",
    "boss_action_light_tip",
    "boss_action_ultimate_label",
    "boss_action_ultimate_tip",
    "boss_appear_title",
    "boss_ultimate_name_archer",
    "boss_ultimate_name_healer",
    "boss_ultimate_name_mage",
    "boss_ultimate_name_rogue",
    "boss_ultimate_name_warrior",
    "chat_admin_block",
    "cloud_friend_accepted",
    "cloud_friend_not_linked",
    "cloud_friend_rejected",
    "cloud_friend_removed",
    "cloud_friend_request_sent",
    "cloud_friendship_not_synced",
    "cloud_pvp_claim",
    "cloud_pvp_empty",
    "cloud_pvp_finalize",
    "cloud_pvp_reward",
    "cloud_pvp_score",
    "cloud_pvp_sent",
    "couple_accept",
    "couple_cancel",
    "couple_connect",
    "couple_end_cloud_success",
    "couple_reject",
    "couple_request_accepted_notification",
    "couple_request_incoming",
    "couple_request_notification",
    "couple_request_outgoing",
    "couple_requests_title",
    "couple_result_accepted",
    "couple_result_already_couple",
    "couple_result_cancelled",
    "couple_result_error",
    "couple_result_not_friends",
    "couple_result_partner_exists",
    "couple_result_pending",
    "couple_result_rejected",
    "couple_result_self",
    "couple_status_couple",
    "couple_status_friend",
    "couple_status_pending",
    "couple_title",
    "db_boss_already_active",
    "db_boss_attack_loading",
    "db_boss_block_result",
    "db_boss_block_success",
    "db_boss_block_title",
    "db_boss_defeated",
    "db_boss_defeated_notif",
    "db_boss_hp_zero",
    "db_boss_level_too_low",
    "db_boss_no_active",
    "db_boss_not_found",
    "db_boss_reward_claimed",
    "db_boss_reward_invalid",
    "db_boss_seasonal_inactive",
    "db_boss_shield_active",
    "db_boss_started",
    "db_guild_chat_admin_cannot",
    "db_guild_chat_message",
    "db_guild_created",
    "db_guild_full",
    "db_guild_joined",
    "db_guild_kick_not_member",
    "db_guild_kick_only_leader",
    "db_guild_kick_self",
    "db_guild_kicked",
    "db_guild_kicked_notif",
    "db_guild_leader_accepted",
    "db_guild_leader_left",
    "db_guild_leader_transfer_notif",
    "db_guild_leave_admin",
    "db_guild_leave_disband",
    "db_guild_leave_not_found",
    "db_guild_leave_not_in",
    "db_guild_leave_success",
    "db_guild_leave_transfer",
    "db_guild_level_up",
    "db_guild_member_accepted",
    "db_guild_not_found",
    "db_guild_request_accept_only_leader",
    "db_guild_request_accepted_notif",
    "db_guild_request_not_found",
    "db_guild_request_notif",
    "db_guild_request_pending",
    "db_guild_request_reject_only_leader",
    "db_guild_request_rejected",
    "db_guild_request_sent",
    "db_guild_transfer_accepted",
    "db_guild_transfer_failed",
    "db_guild_transfer_invalid",
    "db_guild_transfer_not_leader",
    "db_guild_transfer_not_member",
    "db_guild_transfer_not_member_accept",
    "db_guild_transfer_old_notif",
    "db_guild_transfer_success",
    "db_mp_insufficient",
    "db_mp_insufficient_msg",
    "db_mp_insufficient_title",
    "db_mp_invalid",
    "db_raid_not_participant",
    "friends_add_btn",
    "friends_add_placeholder",
    "friends_admin_block",
    "friends_chat_btn",
    "friends_chat_unread",
    "friends_list",
    "friends_pending",
    "friends_profile_btn",
    "friends_profile_short",
    "friends_profile_title",
    "friends_remove_btn",
    "friends_title",
    "guild_accept",
    "guild_admin_warning",
    "guild_attack",
    "guild_boss_all",
    "guild_boss_atk_info",
    "guild_boss_battle",
    "guild_boss_filter",
    "guild_boss_hp",
    "guild_boss_info_format",
    "guild_boss_none",
    "guild_boss_selector_item",
    "guild_boss_tier_label",
    "guild_cant_attack",
    "guild_chat_admin_block",
    "guild_chat_message_format",
    "guild_chat_title",
    "guild_claim",
    "guild_create",
    "guild_create_btn",
    "guild_created",
    "guild_created_title",
    "guild_decs_edit_title",
    "guild_desc",
    "guild_desc_done",
    "guild_description_label",
    "guild_disbanded",
    "guild_edit_desc_btn",
    "guild_exp_progress",
    "guild_hp_zero",
    "guild_hp_zero_msg",
    "guild_id_level",
    "guild_invite_from",
    "guild_invites",
    "guild_join_request_format",
    "guild_join_requests",
    "guild_kick",
    "guild_kicked",
    "guild_leader_inherit_box",
    "guild_leader_inherit_msg",
    "guild_leader_transfer",
    "guild_leader_transfer_old",
    "guild_leave_btn",
    "guild_left",
    "guild_level_up",
    "guild_members",
    "guild_name",
    "guild_name_header",
    "guild_new_desc",
    "guild_no_guild",
    "guild_only_leader",
    "guild_quick_heal",
    "guild_reject",
    "guild_request",
    "guild_request_accepted",
    "guild_request_btn",
    "guild_request_rejected",
    "guild_request_sent",
    "guild_reward_format",
    "guild_skill_info",
    "guild_spyglass_active",
    "guild_spyglass_detail",
    "guild_spyglass_buy_hint",
    "guild_boss_min_level",
    "guild_no_boss",
    "guild_chat_send_fail",
    "guild_chat_send_ok",
    "guild_start_boss",
    "guild_stats_bonus_crit",
    "guild_stats_bonus_crit_value",
    "guild_stats_bonus_damage",
    "guild_stats_bonus_damage_value",
    "guild_stats_bonus_gold",
    "guild_stats_bonus_gold_value",
    "guild_stats_bonus_xp",
    "guild_stats_bonus_xp_value",
    "guild_stats_level",
    "guild_stats_level_value",
    "guild_stats_members",
    "guild_stats_members_value",
    "guild_title",
    "guild_transfer",
    "guild_transfer_confirm_msg",
    "guild_transfer_title",
    "guild_unclaimed_rewards",
    "guild_use_skill",
    "guild_use_skill_with_icon",
    "hp_habis_title",
    "info_title",
    "level_abbr",
    "msg_enter_username",
    "page_friends_subtitle",
    "page_friends_title",
    "page_guild_subtitle",
    "page_guild_title",
    "presence_offline",
    "presence_online",
    "pvp_accept",
    "pvp_btn",
    "pvp_decline",
    "pvp_finished_lose",
    "pvp_finished_tie",
    "pvp_finished_win",
    "pvp_none",
    "pvp_pending_out",
    "pvp_score_line",
    "pvp_section",
    "raid_select_boss_first",
    "raid_start_btn",
    "raid_team_selection",
    "raid_team_selection_info",
    "raid_team_selection_title",
    "raid_ultimate_label",
    "victory_title",
    "cloud_guild_leave_confirm",
    "chat_clear_all",
    "chat_clear_all_confirm",
    "chat_send_btn",
    "register_bio",
    "register_class_label",
    "register_username",
    "register_display",
    "register_password",
    "register_confirm",
    "adopt_success",
    "chat_you",
    "chat_friend",
    "chat_message_deleted",
    "chat_reply_unavailable",
    "chat_replying_to",
    "chat_reply",
    "chat_edit",
    "chat_edit_prompt",
    "chat_delete_message",
    "chat_delete_confirm",
    "chat_react",
    "chat_remove_reaction",
    "chat_clear_self",
    "chat_clear_confirm_self",
    "chat_edited",
    "chat_download_attachment",
    "chat_pending",
    "chat_pending_action_blocked",

    "a11y_font_apply_hint", "a11y_font_scale", "a11y_group", "a11y_high_contrast", "achievement_all", "achievement_claim", "achievement_empty", "achievement_locked", "achievement_reward", "achievement_search", "achievement_unlocked", "admin_add_gold", "admin_add_xp", "admin_complete_tasks", "admin_debug_title", "admin_export_blocked", "admin_fill_hp_mp", "admin_hp_restored", "admin_import_blocked", "admin_max_level", "admin_mode_active", "admin_mode_msg", "admin_mode_title", "admin_panel", "admin_pet_add_exp", "admin_pet_cheat", "admin_pet_feed", "admin_pet_level_up", "admin_tasks_done", "admin_warning", "cheat_title", "currency_idr", "debug_gold_added", "debug_hp_mp_restored", "debug_level_already", "debug_level_set", "debug_tasks_done", "debug_title", "debug_xp_added", "export_failed", "export_generic_error", "export_history_action", "export_history_date", "export_history_task_id", "export_history_type", "export_lib_docx", "export_lib_missing", "export_lib_openpyxl", "export_lib_reportlab", "export_metric", "export_section_dailies", "export_section_economy", "export_section_economy_items", "export_section_habits", "export_section_health", "export_section_health_log", "export_section_history", "export_section_quests", "export_section_sport", "export_section_stats", "export_section_user", "export_success", "export_value", "import_confirm_warning", "import_failed", "import_success", "lang_en", "lang_id", "leaderboard_col_gold", "leaderboard_col_level", "leaderboard_col_pet", "leaderboard_col_rebirth", "leaderboard_col_sport", "leaderboard_col_user", "leaderboard_col_xp", "leaderboard_partner_tip", "leaderboard_single_tip", "nav_leaderboard", "redeem_admin_password_prompt", "redeem_admin_password_title", "redeem_admin_password_wrong", "reset_answer_empty", "reset_answer_wrong", "reset_backup_code_label", "reset_backup_reset_btn", "reset_bc_empty", "reset_bc_invalid", "reset_cancel", "reset_confirm_btn", "reset_confirm_detail", "reset_confirm_invalid", "reset_confirm_placeholder", "reset_confirm_title", "reset_confirm_type_label", "reset_confirm_warning", "reset_error", "reset_loading", "reset_method_backup", "reset_method_security", "reset_method_title", "reset_no_bc", "reset_no_bc_long", "reset_no_sq", "reset_password_answer", "reset_password_backup_btn", "reset_password_backup_code", "reset_password_backup_title", "reset_password_btn", "reset_password_check", "reset_password_confirm", "reset_password_new", "reset_password_security_question", "reset_password_security_title", "reset_password_username", "reset_password_verify", "reset_success_msg", "reset_success_title", "reset_username_empty", "reset_username_notfound", "reset_verify_password_prompt", "reset_verify_password_title", "settings_backup_now", "settings_change_restart_msg", "settings_currency", "settings_data_management", "settings_database", "settings_db_path", "settings_exit", "settings_exit_btn", "settings_export_tracker", "settings_import_tracker", "settings_language", "settings_language_en", "settings_language_id", "settings_language_restart_msg", "settings_language_restart_no", "settings_language_restart_title", "settings_language_restart_yes", "settings_reset_btn", "settings_reset_progress", "settings_reset_warning", "settings_sound", "settings_sound_enable", "settings_sound_hint", "settings_theme", "settings_theme_changed", "settings_theme_title", "settings_title", "unit_exp", "unit_gold", "unit_xp", "update_apply", "update_applying", "update_auto_countdown", "update_available", "update_available_title", "update_check", "update_check_failed", "update_check_offline", "update_checking", "update_download", "update_downloaded", "update_downloading", "update_failed", "update_group_title", "update_later", "update_latest", "update_notes_label", "update_reopen_note", "update_restarting", "update_size", "update_version",

    "cloud_leaderboard_events", "cloud_leaderboard_exp", "cloud_leaderboard_guild", "cloud_leaderboard_local", "cloud_leaderboard_members", "cloud_leaderboard_points", "cloud_leaderboard_productivity", "leaderboard_guild", "leaderboard_rank", "leaderboard_title",

    "achievement_category_boss", "achievement_category_crafting", "achievement_category_daily", "achievement_category_economy", "achievement_category_focus", "achievement_category_guild", "achievement_category_habit", "achievement_category_health", "achievement_category_level", "achievement_category_nutrition", "achievement_category_pet", "achievement_category_social", "achievement_category_special", "achievement_category_sport", "achievement_category_todo", "achievement_claimed", "achievement_progress_format", "achievement_reward_format",

    "web_hero_custom", "web_hero_avatar", "web_hero_name", "web_hero_class", "web_hero_bio", "web_profile_saved", "web_profile_save", "reload_now_confirm",

    "btn_close", "food_meal_type", "health_mood_low", "learning_no_notebook", "nav_notes", "nav_pomodoro", "notes_color", "notes_default_title", "notes_denominator", "notes_empty", "notes_fraction", "notes_fraction_title", "notes_highlight", "notes_numerator", "notes_select_hint", "notes_symbols", "notes_to_learning_done", "notes_unarchive", "notes_unsaved", "notes_updated", "pomodoro", "sport_activity_ph", "sport_calories_label", "sport_rank_max", "sport_rank_progress", "sport_type_label", "supplies_add", "web_backup_code", "web_display_name", "web_forgot_password", "web_have_account", "web_login_btn", "web_login_subtitle", "web_need_account", "web_palette_placeholder", "web_password", "web_register_btn", "web_register_subtitle", "web_username",
    "habit_habit_tracker", "habit_templates", "habit_new_habit", "habit_search_habits", "habit_all_difficulty", "habit_all_habits", "habit_duplicate", "habit_no_habits_in_this_category", "habit_create_first_habit", "habit_edit_habit", "habit_habit_title", "habit_difficulty", "habit_folder", "habit_no_folder", "habit_habit_nature", "habit_notes", "habit_cancel", "habit_done_today", "habit_save", "daily_daily_routine_dailies", "daily_new_daily", "daily_search_dailies", "daily_all_dailies", "daily_fail_hp", "daily_days", "daily_no_daily_tasks_in_this_category", "daily_edit_daily", "daily_daily_task_title", "daily_folder", "daily_repeat_days", "daily_notes", "quest_quest_to_do_list", "quest_new_quest", "quest_search_quests", "quest_all_priorities", "quest_all_quests", "quest_completed", "quest_all", "quest_no_quests_in_this_category", "quest_edit_quest", "quest_quest_title", "quest_due_date",
    "habit_subtitle", "daily_subtitle", "quest_subtitle",
    "shop_tab_inventory",
    "shop_equipped", "shop_type_item",
    "friend_guild", "friend_sport_level", "friend_rebirth", "friend_joined", "friend_xp_progress", "friend_total_xp", "friend_achievements_progress", "friend_latest_achievements", "friend_stats_title", "friend_tasks_done", "friend_pomodoro", "friend_profile_title", "stats_habit_today", "stats_daily_today", "stats_quest_done", "stats_max_streak", "stats_boss_killed", "stats_pets",
    "class_warrior_name", "class_healer_name", "class_mage_name", "class_archer_name", "class_rogue_name",
    "db_guild_invite_self", "db_guild_invite_not_leader", "db_guild_invite_no_guild", "db_guild_invite_not_friend", "db_guild_invite_no_target", "db_guild_invite_admin_target", "db_guild_invite_already_guild", "db_guild_invite_sent", "db_guild_invite_notif",
    "guild_invite_friend_btn", "guild_invite_friend_title", "guild_invite_friend_empty", "guild_invite_friend_send",
    "talent_tree", "account_security", "old_password", "new_password",
    "profile_color", "profile_emoji",
    "db_equip_not_equippable", "db_equip_not_owned", "db_equip_slots_full", "shop_equip_slots_label", "shop_equip_slot_empty",
    "shop_equip_slot_hint",
    "love_gallery_zoom_out_tip", "love_gallery_zoom_in_tip", "love_gallery_zoom_reset_tip",
    "page_sport_title", "page_sport_subtitle", "page_health_title", "page_health_subtitle", "page_leaderboard_title", "page_leaderboard_subtitle", "page_achievements_title", "page_achievements_subtitle", "page_love_title", "page_love_subtitle", "page_notes_title", "page_notes_subtitle",
    "dash_wrapped_btn", "dash_widgets_btn", "dash_water", "dash_ai_study", "dash_focus_audio",
    "dash_love_space", "dash_guild_pvp", "dash_calendar", "dash_daily_routine", "dash_manage_dailies",
    "dash_manage_habits", "dash_view_all", "dash_heatmap_title", "dash_dungeon_boss",
    "dash_no_active_boss", "dash_enter_boss_arena", "dash_open", "dash_all_quests_done",
    "dash_sport_level", "dash_calories_eaten", "dash_water_hydration", "dash_sporttrack",
    "dash_habit_tracker", "sport_activities_title", "sport_pyqt_templates", "sport_complete_xp",
    "sport_no_logs_yet", "sport_log_session_title", "sport_difficulty_label", "sport_weight_label",
    "sport_auto_calc", "sport_manual", "sport_notes_label", "sport_formula", "sport_cancel",
    "sport_total_reps_label", "sport_reps_empty", "sport_reps_session_title", "sport_reps_note_ph",
    "health_no_recipes", "health_ingredients", "health_servings", "health_total_calories",
    "food_recipe_new_title", "food_recipe_name", "food_recipe_icon", "food_recipe_servings",
    "food_recipe_ingredients", "sport_empty_activity", "sport_total_sessions", "sport_total_duration", "sport_calories_burned", "sport_mastery", "sport_log_workout", "sport_reps_chart", "health_food_db", "health_search_food_ph", "health_portion", "health_log_notes_ph", "health_manage_btn",
    "account_not_linked_to_cloud_falling_back_to_loca", "active", "add_a_morning_routine_dailies", "add_a_source_to_begin", "add_custom_food", "add_debt", "add_habit_tracker_items", "add_ingredient", "add_study_source", "adjust", "adoption_sanctuary", "ai", "ai_answers_grounded_in_this_notebook_s_sources", "ai_is_synthesizing", "ai_learning_workspace", "alarm_ringing_press_ok_to_stop", "all_set_start_leveling_up_your_hero_and_complete", "answer", "ask_anything_about_this_notebook", "ask_questions_about_your_sources", "bg_slate_800_text_slate_400_border_slate_700", "bg_slate_950_border_slate_800", "bmi_body_goals", "boost_real_world_productivity_with_gamified_pomo", "boss_rewards", "calories", "category", "challenge_boss", "cherish_shared_memories_daily_connection_prompts", "choose_food", "choose_your_hero", "claim", "click_the_flashcards_button", "click_the_podcast_button", "click_the_quiz_button", "click_to_flip", "click_to_listen", "color", "combat_actions", "completing_habits_dailies_and_quests_will_automa", "content_text", "continue_adventure", "create_boss", "create_custom_boss", "create_new_notebook", "create_notebook", "current_stock", "custom_boss", "daily_health_metrics", "daily_nutrition_macros", "daily_reflection_notes", "daily_steps", "debts", "deep_dive_episode", "description", "due_date", "dungeon_boss_arena", "dungeon_monster_roster", "e_g_lunch", "edit_debt", "edit_nutrition_goals", "edit_transaction", "edit_transaction_862", "en_gb", "enable_sound", "engaged_in_battle", "enter_anything_it_appears_as_a_filter_tab", "evaluate", "explanation", "flee_encounter", "flip", "folder_name_177", "food_database", "food_recipes_154", "get_started", "gold_bounty_reward", "health_food", "health_metrics_focus_pomodoro", "health_metrics_healthfoodpage", "health_steps_sleep", "hero", "hero_name_optional", "hosts_alex_sam_text_to_speech", "in", "instructions", "invest", "investment", "iou_notes", "level_up_congratulations", "light", "load_earlier_messages", "loading_667", "loading_theme_catalog", "log", "log_recipe", "log_transaction", "logged_to_economy", "love_space", "low_stock", "max_hp_increased", "max_mp_increased", "min_level", "mind_map", "moderate", "mood", "mood_mindset", "name_is_empty", "net_balance", "new_debt", "new_recipe", "new_recipe_107", "new_transaction", "next", "next_495", "no_active_boss_encounter", "no_cloud_rows_yet", "no_episode_yet", "no_expenses_yet", "no_flashcards_yet", "no_health_data_yet", "no_meals_logged_for_today", "no_mood_data_yet", "no_quiz_yet", "no_rows_yet", "no_sources_yet", "no_supplies_yet", "no_transactions_recorded", "nutrition_goals_saved", "of_daily_goal", "ok_stop_alarm", "open_economy", "open_supplies", "out", "paid_off", "pay", "payable", "per_category", "person", "personal_debt_with_installments_pay_in_parts_aut", "pomodoro_focus_chamber", "preferences", "prev", "question", "recipe_logged", "recipe_name", "recipe_saved", "remaining", "reminder", "rename_folder", "renew", "resting_bpm", "retake", "save_bmi", "save_health", "save_health_entry", "save_log", "save_source", "saving_name", "savings", "search_transactions", "sedentary", "select_a_monster_boss_from_the_dungeon_roster_be", "select_dungeon_bosses_complete_tasks_to_unleash_", "select_or_create_a_notebook", "serving", "servings", "set_language_starter_tasks", "settings", "settle", "sleep_h", "sleep_hours", "some_items_are_low", "source_title", "sources_chat_studio_in_one_grounded_learning_wor", "sources_grounding_the_ai_answers", "sport_workout_tracker", "start_adventure", "start_focus", "start_solo", "steps", "stock_in", "stock_out", "subs", "subscription", "supplies", "task_deleted_147", "task_restored_820", "task_synergy", "title_person", "total", "total_expenses", "total_income", "total_payable_i_owe", "total_receivable_owed_to_me", "track_daily_calorie_and_macronutrient_intake_to_", "transaction_history", "transaction_name", "transactions", "turn_your_daily_habits_into_an_rpg_adventure_com", "ungrouped", "very_active", "water_hydration", "weight_kg", "welcome", "welcome_to_craftlife", "withdraw", "words", "you_friends_and_guild_members_local_data", "your_class_determines_your_buffs",
    "account_deleted_title", "ach_desc_Completionist", "ach_desc_Demigod", "ach_desc_Explorer", "ach_desc_Friendly", "ach_desc_Ksatria", "ach_desc_Legenda", "ach_desc_Millionaire", "ach_desc_Pemula", "ach_desc_Popular", "ach_desc_Prajurit", "ach_desc_Saver", "ach_desc_Shopaholic", "ach_name_Completionist", "ach_name_Demigod", "ach_name_Explorer", "ach_name_Friendly", "ach_name_Ksatria", "ach_name_Legenda", "ach_name_Millionaire", "ach_name_Pemula", "ach_name_Popular", "ach_name_Prajurit", "ach_name_Saver", "ach_name_Shopaholic", "achievement_all_categories", "achievement_progress", "achievement_title", "achievement_unlock_msg", "action_achievement", "action_buy", "action_debt_paid", "action_debt_installment", "action_debt_penalty", "action_invest", "action_invest_return", "action_invest_withdraw", "action_penalty_gold", "action_penalty_xp", "action_reward", "action_sell_item", "action_subscription", "app_error_title", "app_tagline", "app_title_format", "attack_damage_reduction", "attack_message", "attack_message_no_spyglass", "attack_title", "attack_totem_revive", "berhasil_debt_paid", "berhasil_invest_withdraw", "berhasil_saving_add", "berhasil_saving_withdraw", "berhasil_saving_withdraw2", "blend_default_name", "boss_appear_msg", "boss_attack", "boss_block_active_info", "boss_block_result", "boss_block_success", "boss_block_title", "boss_critical_mark", "boss_damage_text", "boss_defeated", "boss_loading", "boss_reduction_info", "boss_revive", "boss_shield_used", "boss_title_format", "boss_ultimate_archer_effect", "boss_ultimate_cooldown", "boss_ultimate_healer_effect", "boss_ultimate_mage_effect", "boss_ultimate_rogue_effect", "boss_ultimate_warrior_effect", "boss_victory", "btn_ok", "calorie_penalty", "calorie_penalty_title", "calories_logged", "cboss_atk", "cboss_btn", "cboss_create", "cboss_custom_tag", "cboss_hp", "cboss_icon", "cboss_minlvl", "cboss_name", "cboss_title", "change_password", "chat_attachment_filter", "chat_attachment_max", "chat_attachment_message", "chat_attachment_not_cached", "chat_attachment_saved", "chat_attachments_ready", "chat_choose_attachment", "chat_guild_message", "chat_input_placeholder", "chat_load_earlier", "chat_message_format", "chat_new_message", "chat_with", "check_backup_code_btn", "class_archer_bonus", "class_healer_bonus", "class_mage_bonus", "class_rogue_bonus", "class_warrior_bonus", "cloud_auth_required", "cloud_chat_clear_local_only", "cloud_chat_typing", "cloud_device_name", "cloud_device_name_default", "cloud_device_rename", "cloud_device_revoke_confirm", "cloud_device_revoke_others_confirm", "cloud_devices_none_other", "cloud_guild_available", "cloud_guild_ban", "cloud_guild_ban_reason", "cloud_guild_boss", "cloud_guild_contribution_feed", "cloud_guild_create", "cloud_guild_default_boss", "cloud_guild_disband", "cloud_guild_disband_confirm", "cloud_guild_exp", "cloud_guild_join", "cloud_guild_members_title", "cloud_guild_no_boss", "cloud_guild_no_description", "cloud_guild_offline", "cloud_guild_reward_ready", "cloud_guild_set_member", "cloud_guild_set_officer", "cloud_guild_show_local", "cloud_guild_show_online", "cloud_guild_start_boss", "cloud_guild_unban", "cloud_migration_preview", "cloud_queue_failed_hint", "cloud_queue_inspect_desc", "cloud_queue_inspect_title", "cloud_relationship_not_synced", "cloud_wallet_format", "color_blue", "color_cyan", "color_gold", "color_green", "color_orange", "color_purple", "color_red", "color_white", "ct_avg_connection", "ct_dailies_line", "ct_economy_line", "ct_habits_line", "ct_health_line", "ct_learning_line", "ct_love_line", "ct_music_playlists", "ct_music_recent", "ct_no_couple", "ct_none", "ct_pomodoro_line", "ct_sport_line", "ct_supplies_line", "ct_tab_achievements", "ct_tab_economy", "ct_tab_health", "ct_tab_learning", "ct_tab_love", "ct_tab_music", "ct_tab_pomodoro", "ct_tab_reminders", "ct_tab_sport", "ct_tab_supplies", "ct_tab_tasks", "ct_title", "ct_todos_line", "daily_complete_msg", "daily_login_item_bonus", "daily_login_msg", "daily_login_title", "dashboard_active_buffs", "dashboard_avg_hr", "dashboard_avg_sleep", "dashboard_avg_steps", "dashboard_avg_water", "dashboard_avg_weight", "dashboard_days_recorded", "dashboard_footer", "dashboard_health_summary", "dashboard_more_buffs", "dashboard_no_achievements", "dashboard_no_activity", "dashboard_no_buffs", "dashboard_recent_achievements", "dashwidgets_btn", "db_accept_invite_success", "db_accept_invite_welcome", "db_accept_leader_transfer_notif", "db_account_locked", "db_account_locked_msg", "db_account_locked_success", "db_account_unlocked", "db_achievement_claimed", "db_achievement_not_found", "db_achievement_reward_claimed", "db_achievement_reward_unavailable", "db_achievement_unlocked", "db_admin_cannot_guild", "db_admin_cheat_pets_add_exp", "db_admin_cheat_pets_feed", "db_admin_cheat_pets_level_up", "db_already_in_guild", "db_attack_limit_reached", "db_avatar_updated", "db_cboss_bad_stats", "db_cboss_created", "db_cboss_name_bad", "db_chat_admin_cannot_send", "db_chat_new_message", "db_class_change_cooldown", "db_class_changed", "db_class_unknown", "db_craft_already_owned", "db_craft_missing", "db_craft_success", "db_daily_already_done", "db_daily_fail_already", "db_daily_not_found", "db_debt_installment", "db_debt_insufficient_balance", "db_debt_not_found", "db_debt_paid", "db_debt_penalty_already", "db_debt_penalty_notif", "db_debt_penalty_user_not_found", "db_delete_account_failed", "db_delete_account_success", "db_delete_account_wrong_password", "db_folder_not_found", "db_food_not_found", "db_friend_accept_admin_cannot", "db_friend_accepted", "db_friend_accepted_notif", "db_friend_admin_cannot_send", "db_friend_admin_target", "db_friend_already", "db_friend_rejected", "db_friend_remove_admin", "db_friend_removed", "db_friend_request_invalid", "db_friend_request_notif", "db_friend_request_pending", "db_friend_request_sent", "db_friend_self", "db_friend_user_not_found", "db_general_error", "db_habit_already_done", "db_heal_regenerate", "db_hp_zero", "db_installment_exceed", "db_installment_zero", "db_investment_exceeds_balance", "db_investment_max_10", "db_investment_no_funds", "db_investment_not_found", "db_investment_success", "db_investment_withdrawn", "db_invite_invalid", "db_invite_rejected", "db_item_already_owned", "db_item_bought", "db_item_insufficient_quantity", "db_item_not_found", "db_item_sold", "db_item_used", "db_level_up", "db_login_failed", "db_login_failed_attempts", "db_login_locked", "db_nutrition_bonus_claimed", "db_nutrition_bonus_notif", "db_nutrition_goal_not_reached", "db_nutrition_goal_not_set", "db_old_password_wrong", "db_password_changed", "db_password_too_short", "db_pomodoro_invalid", "db_pvp_dup", "db_pvp_not_friends", "db_pvp_sent", "db_pvp_won", "db_rebirth_achievements_required", "db_rebirth_items_required", "db_rebirth_level_required", "db_rebirth_pets_required", "db_rebirth_success", "db_recipe_not_found", "db_recur_every_day", "db_redeem_admin_already", "db_redeem_admin_success", "db_redeem_code_exists", "db_redeem_gold", "db_redeem_invalid", "db_redeem_item_fail", "db_redeem_item_success", "db_redeem_unknown", "db_redeem_xp", "db_register_success", "db_register_username_taken", "db_restore_success", "db_skill_arcane", "db_skill_gold_shot", "db_skill_shadow", "db_skill_shield", "db_skill_unknown", "db_sport_activity_done_today", "db_sport_activity_not_found", "db_sport_level_up", "db_subscription_expired_notif", "db_subscription_insufficient_balance", "db_subscription_insufficient_notif", "db_subscription_not_found", "db_subscription_renew_manual_success", "db_subscription_renew_warning", "db_subscription_renewed_auto", "db_subscription_renewed_auto_notif", "db_subscription_renewed_manual", "db_talent_cant", "db_talent_unlocked", "db_totem_revive", "db_ultimate_archer_effect", "db_ultimate_cooldown", "db_ultimate_healer_effect", "db_ultimate_mage_effect", "db_ultimate_rogue_effect", "db_ultimate_warrior_effect", "db_unknown_action", "db_user_not_found", "debnote_add_btn", "debnote_add_title", "debnote_added", "debnote_already_paid", "debnote_date_label", "debnote_delete_confirm", "debnote_empty", "debnote_hint", "debnote_not_found", "debnote_person_empty", "debnote_person_label", "debnote_person_ph", "debnote_settle_btn", "debnote_settle_confirm", "debnote_settled", "debnote_status_paid", "debnote_status_unpaid", "debnote_total_unpaid", "debt_add_title", "debt_added", "debt_edit_title", "debt_installment", "debt_insufficient_balance", "debt_paid", "debt_penalty", "debt_penalty_detail", "debt_penalty_label", "debt_remaining", "delete_account_confirm", "delete_account_loading", "delete_account_password", "delete_confirm_msg", "delete_confirm_title", "dialog_add_daily", "dialog_add_habit", "dialog_add_todo", "dialog_difficulty", "dialog_edit_mode", "dialog_folder", "dialog_icon", "dialog_move", "dialog_move_folder", "dialog_name", "dialog_name_placeholder", "dialog_notes", "dialog_notes_placeholder", "dialog_notes_placeholder2", "dialog_priority", "dialog_select_folder", "drop_here_to_remove_folder", "duplicate_failed", "economy_add", "economy_add_debt", "economy_add_saving", "economy_amount_gt_zero", "economy_amount_label", "economy_balance", "economy_btn_installment", "economy_btn_pay", "economy_btn_withdraw", "economy_category", "economy_confirm", "economy_daily_chart_empty", "economy_daily_chart_title", "economy_daily_empty", "economy_daily_expense", "economy_daily_income", "economy_daily_list_title", "economy_daily_net", "economy_daily_running", "economy_daily_today_btn", "economy_daily_today_note", "economy_date_label", "economy_debnote_category", "economy_debnote_expense_name", "economy_debnote_income_name", "economy_debt_add_title", "economy_debt_date_invalid", "economy_debt_deadline_label", "economy_debt_delete_confirm", "economy_debt_done_update", "economy_debt_empty", "economy_debt_installment_btn", "economy_debt_installment_hint", "economy_debt_installment_label", "economy_debt_installment_title", "economy_debt_nama_not_empty", "economy_debt_name_label", "economy_debt_name_ph", "economy_empty", "economy_export_title", "economy_icon_education", "economy_icon_entertainment", "economy_icon_expense", "economy_icon_food", "economy_icon_gift", "economy_icon_health", "economy_icon_income", "economy_icon_investment", "economy_icon_rent", "economy_icon_salary", "economy_icon_shopping", "economy_icon_transport", "economy_invest_add", "economy_invest_add_amount", "economy_invest_amount_label", "economy_invest_btn", "economy_invest_collect", "economy_invest_date_label", "economy_invest_delete_confirm", "economy_invest_empty", "economy_invest_name", "economy_invest_name_ph", "economy_invest_return_label", "economy_invest_return_title", "economy_invest_withdraw_btn", "economy_invest_withdraw_confirm", "economy_item_format", "economy_overdue_warning", "economy_saving_add_btn", "economy_saving_add_confirm_btn", "economy_saving_add_funds", "economy_saving_current_amount", "economy_saving_delete_confirm", "economy_saving_empty", "economy_saving_name_label", "economy_saving_name_ph", "economy_saving_target_amount_label", "economy_saving_target_date_label", "economy_saving_withdraw_btn", "economy_saving_withdraw_label", "economy_saving_withdraw_record", "economy_saving_withdraw_title", "economy_sub_add", "economy_sub_autorenew", "economy_sub_cost_label", "economy_sub_delete_confirm", "economy_sub_due_format", "economy_sub_due_label", "economy_sub_empty", "economy_sub_name_label", "economy_sub_period_label", "economy_sub_renew", "economy_succes_add_debt", "economy_supplies_card", "economy_supplies_summary", "economy_tab_all", "economy_tab_daily", "economy_tab_debt", "economy_tab_debtnotes", "economy_tab_invest", "economy_tab_saving", "economy_tab_subscription", "economy_title", "economy_tooltip_balance", "economy_tooltip_category", "economy_tooltip_expense", "economy_tooltip_income", "economy_total_debt", "economy_total_expense", "economy_total_income", "economy_total_saving", "economy_transaction_name", "economy_transaction_name_ph", "economy_transaction_title_add", "economy_transaction_title_edit", "economy_transaction_type", "economy_type_expense", "economy_type_income", "error_loading_page", "error_occurred", "excel_sheet_dailies", "excel_sheet_economy", "excel_sheet_habits", "excel_sheet_health", "excel_sheet_health_log", "excel_sheet_history", "excel_sheet_nutrition", "excel_sheet_quests", "excel_sheet_sport", "excel_sheet_summary", "excel_sheet_xp_chart", "exit_application", "export_no_data", "export_pdf_option", "export_summary_avg_cal", "export_summary_avg_water", "export_summary_label", "export_summary_total_cal", "export_summary_total_water", "folder_create", "folder_create_btn", "folder_create_new", "folder_edit_title", "folder_empty", "folder_icon_default", "folder_icon_exercise", "folder_icon_favorite", "folder_icon_goal", "folder_icon_health", "folder_icon_hobby", "folder_icon_home", "folder_icon_morning", "folder_icon_night", "folder_icon_priority", "folder_icon_study", "folder_icon_work", "folder_item_count", "folder_name", "folder_name_empty", "folder_name_placeholder", "folder_no_folder", "folder_tooltip_del", "folder_tooltip_dup", "folder_tooltip_edit", "food_add_custom_title", "food_added_success", "food_all_categories", "food_bmi_calc_btn", "food_bmi_set_target_btn", "food_calorie_recorded", "food_calories", "food_carbs", "food_category_drink", "food_category_international", "food_category_main", "food_category_protein", "food_category_snack", "food_category_veg", "food_chart_calories", "food_csv_filter", "food_custom_ph", "food_date", "food_docx_filter", "food_empty_log", "food_empty_water", "food_export_format_label", "food_export_lib_csv", "food_export_lib_docx", "food_export_lib_pdf", "food_fat", "food_filter_category", "food_goals_title", "food_goals_title_window", "food_icon_label", "food_ingredient_picker_title", "food_ingredient_qty_label", "food_ingredient_search_label", "food_ingredient_search_ph", "food_ingredient_select_label", "food_ingredient_select_label_short", "food_log_btn", "food_name_empty", "food_name_label", "food_net_calories", "food_pdf_filter", "food_protein", "food_recipe_add_btn", "food_recipe_add_ingredient", "food_recipe_delete", "food_recipe_delete_confirm", "food_recipe_detail_title", "food_recipe_ingredients_label", "food_recipe_instructions_ph", "food_recipe_log_fail", "food_recipe_log_success", "food_recipe_log_today", "food_recipe_manager_title", "food_recipe_name_empty", "food_recipe_name_label", "food_recipe_name_ph", "food_recipe_no_ingredient", "food_recipe_save", "food_recipe_saved", "food_recipe_serving_label", "food_save_btn", "food_search_label", "food_search_ph", "food_select_first", "food_serving_dialog_msg", "food_serving_dialog_title", "food_serving_label", "food_set_goals", "food_tab_food", "food_title", "food_water_custom", "food_water_goal", "food_water_set_goal_btn", "food_xlsx_filter", "forgot_backup_btn", "forgot_cancel_btn", "forgot_security_btn", "freeze_added_success", "freeze_error", "freeze_max_reached", "freeze_no_item", "freeze_used_message", "friend_already", "friend_class_label", "friend_info_title", "friend_level_format", "friend_level_prefix", "friend_not_found", "friend_removed", "friend_request_accepted", "friend_request_rejected", "friend_request_sent", "friend_self", "generate_backup_codes", "gold_format", "gold_insufficient", "habit_complete_msg", "health_calorie_goal_label", "health_cancel_goals_btn", "health_chart_height_label", "health_chart_weight_label", "health_daily_targets_label", "health_daily_targets_line", "health_edit_target_btn", "health_empty_history", "health_progress_chart", "health_progress_today", "health_save_goals_btn", "health_sleep_goal_label", "health_sleep_quality", "health_sleep_quality_metric", "health_steps_goal_label", "health_tab_history", "health_tab_summary", "health_target_title", "health_title", "health_water_goal_label", "healthchart_corr", "healthchart_need_data", "healthchart_verdict_neg", "healthchart_verdict_neutral", "healthchart_verdict_pos", "heatmap_title", "heatmap_tooltip", "heatmap_tooltip_zero", "hp_format", "hp_restored_msg", "hp_restored_title", "ice_block_desc", "installment_amount_zero", "invalid_format", "invalid_json", "invest_amount_positive", "invest_icon_crypto", "invest_icon_deposit", "invest_icon_gold", "invest_icon_property", "invest_icon_stock", "invest_name_empty", "investment_add_title", "investment_added", "investment_max_10_percent", "investment_return", "investment_return_detail", "investment_withdrawn", "item_already_owned", "item_bought", "item_not_found", "item_used", "learning_add_source", "learning_add_source_compact", "learning_add_url_prompt", "learning_add_url_title", "learning_all_sources", "learning_api_btn", "learning_api_dialog_desc", "learning_api_dialog_title", "learning_api_key_info", "learning_api_key_label", "learning_api_missing", "learning_api_missing_short", "learning_api_ready", "learning_api_ready_short", "learning_api_saved", "learning_autosaved", "learning_chars", "learning_chars_k", "learning_chat_clear", "learning_chat_clear_compact", "learning_chat_error", "learning_chat_input_no_source", "learning_chat_input_ph", "learning_chat_panel", "learning_chat_placeholder", "learning_chat_send", "learning_chat_short", "learning_chat_title", "learning_choose_file", "learning_choose_files", "learning_citations", "learning_clear_chat", "learning_clear_chat_msg", "learning_clear_chat_title", "learning_close_creator", "learning_composer_hint", "learning_count_hint", "learning_count_invalid", "learning_count_label", "learning_default_topic", "learning_delete", "learning_delete_compact", "learning_delete_confirm", "learning_delete_generation", "learning_delete_generation_msg", "learning_delete_generation_title", "learning_delete_notebook", "learning_delete_notebook_msg", "learning_delete_notebook_title", "learning_delete_source", "learning_delete_source_compact", "learning_delete_source_msg", "learning_delete_source_title", "learning_empty_chat_desc", "learning_empty_chat_no_source_desc", "learning_empty_chat_no_source_title", "learning_empty_chat_title", "learning_empty_sources_desc", "learning_empty_sources_title", "learning_empty_studio_desc", "learning_empty_studio_no_source_desc", "learning_empty_studio_no_source_title", "learning_empty_studio_title", "learning_export_compact", "learning_fetching_source", "learning_files_imported", "learning_first_notebook", "learning_flashcard_answer", "learning_flashcard_counter", "learning_flashcard_format_error_desc", "learning_flashcard_format_error_title", "learning_flashcard_hint", "learning_flashcard_question", "learning_flashcard_shuffle", "learning_flip_card", "learning_generate_type_tip", "learning_generated", "learning_generating", "learning_generating_type", "learning_generation_deleted", "learning_generation_failed", "learning_generation_history", "learning_generation_ready", "learning_generation_title", "learning_history_empty", "learning_mindmap_expand", "learning_mindmap_fit", "learning_mindmap_render_failed", "learning_mindmap_tab", "learning_mock_answer", "learning_mock_generation", "learning_need_notebook", "learning_need_notebook2", "learning_need_source_chat", "learning_need_source_studio", "learning_new_generation", "learning_new_notebook", "learning_new_notebook_prompt", "learning_new_notebook_title", "learning_next", "learning_no_result_save", "learning_no_source", "learning_notebook", "learning_notebook_label", "learning_partial_import_msg", "learning_partial_import_title", "learning_paste_content_ph", "learning_paste_default_title", "learning_paste_desc", "learning_paste_title_label", "learning_paste_title_ph", "learning_podcast_error", "learning_podcast_generate", "learning_podcast_generating", "learning_podcast_generating_language", "learning_podcast_generation_failed", "learning_podcast_not_generated", "learning_podcast_pause", "learning_podcast_play", "learning_podcast_ready", "learning_podcast_ready_language", "learning_podcast_save", "learning_podcast_save_title", "learning_podcast_saved", "learning_podcast_stop", "learning_podcast_tts_unavailable", "learning_previous", "learning_quiz_correct", "learning_quiz_essay_ph", "learning_quiz_explain", "learning_quiz_invalid", "learning_quiz_model_answer", "learning_quiz_score", "learning_quiz_self_correct", "learning_quiz_self_wrong", "learning_quiz_show_answer", "learning_quiz_wrong", "learning_quota_title", "learning_reading_files", "learning_reading_source", "learning_rename_notebook", "learning_rename_prompt", "learning_result", "learning_result_meta", "learning_role_ai", "learning_role_user", "learning_save", "learning_show_answer", "learning_show_question", "learning_source_added", "learning_source_added_detail", "learning_source_added_generic", "learning_source_detail_meta", "learning_source_docx", "learning_source_empty_file", "learning_source_fetch_failed", "learning_source_files", "learning_source_paste", "learning_source_pdf", "learning_source_summary", "learning_source_txt", "learning_source_website", "learning_source_youtube", "learning_sources", "learning_sources_panel", "learning_sources_short", "learning_studio", "learning_studio_audio", "learning_studio_briefing", "learning_studio_faq", "learning_studio_flashcards", "learning_studio_guide", "learning_studio_hint", "learning_studio_mindmap", "learning_studio_panel", "learning_studio_podcast_script", "learning_studio_quiz", "learning_studio_saved", "learning_studio_short", "learning_studio_summary", "learning_studio_timeline", "learning_subtitle", "learning_text_empty", "learning_title", "learning_topic_input_ph", "learning_topic_prompt", "learning_typing", "learning_untitled_source", "learning_view_source", "level_label", "level_up", "level_up_sport", "level_xp_format", "log_achievement", "log_buy", "log_debt_installment", "log_debt_paid", "log_debt_penalty", "log_invest", "log_invest_return", "log_invest_withdraw", "log_penalty_gold", "log_penalty_xp", "log_reward", "log_sell_item", "log_subscription_auto", "log_subscription_manual", "login_button_text", "login_forgot", "login_forgot_btn", "login_password", "login_processing", "login_pw_min", "login_pw_mismatch", "login_remember_text", "login_tab_login_label", "login_tab_register_label", "login_title", "login_username", "logout", "love_album_deleted", "love_album_err_photo", "love_album_renamed", "love_cloud_realtime", "love_gallery_caption", "love_gallery_date", "love_gallery_edit_title", "love_gallery_error_dimensions", "love_gallery_error_file_size", "love_gallery_error_file_type", "love_gallery_error_forbidden", "love_gallery_error_generic", "love_gallery_error_invalid_data", "love_gallery_error_no_couple", "love_gallery_multi_selected", "love_gallery_upload_title", "love_gallery_visibility", "love_grace_read_only", "love_my_age", "love_my_birthdate", "love_my_gender", "love_my_name", "love_my_name_ph", "love_partner", "love_partner_age", "love_partner_birthdate", "love_partner_gender", "love_partner_name", "love_partner_name_ph", "love_partner_required", "love_profile_both_hint", "love_profile_partner_title", "love_profile_title", "love_profile_you_title", "love_relationship_type", "love_start_date", "love_subtitle", "love_title", "love_type_dating", "love_type_engaged", "love_type_long_distance", "love_type_married", "mp_format", "mp_insufficient_msg", "mp_insufficient_title", "msg_berhasil", "msg_info", "msg_invalid_amount", "msg_saved", "msg_success", "msg_warning", "nav_achievement", "nav_boss", "nav_crafting", "nav_group_body", "nav_group_life", "nav_group_play", "nav_group_social", "nav_group_system", "nav_home", "nav_next", "nav_prev", "nav_profile", "nav_reminders", "nav_sporttrack", "nav_supplies", "no_golden_apple", "no_item_msg", "no_item_title", "notif_button", "notif_button_empty", "notif_close", "notif_empty", "notif_filter_all", "notif_filter_guild", "notif_filter_love", "notif_filter_message", "notif_filter_pvp", "notif_filter_security", "notif_filter_social", "notif_load_more", "notif_mark_all", "notif_mark_read", "notif_open", "notif_title", "notif_window_title", "nutrition_bonus", "onboard_back", "onboard_class_body", "onboard_class_title", "onboard_done_body", "onboard_done_title", "onboard_finish", "onboard_habits_body", "onboard_habits_title", "onboard_next", "onboard_skip", "onboard_welcome_body", "onboard_welcome_title", "open_json", "page_dailies_subtitle", "page_dailies_title", "page_economy_subtitle", "page_economy_title", "page_habits_subtitle", "page_habits_title", "page_learning_subtitle", "page_learning_title", "page_profile_subtitle", "page_profile_title", "page_quests_subtitle", "page_quests_title", "page_settings_subtitle", "page_settings_title", "palette_action_add_daily", "palette_action_add_habit", "palette_action_add_todo", "palette_footer", "palette_no_results", "palette_placeholder", "palette_section_actions", "palette_section_pages", "palette_title", "penalty_all_failed", "penalty_gold_popup", "penalty_hp_zero_gold", "penalty_none_popup", "penalty_title", "penalty_xp_loss_percent", "penalty_xp_popup_percent", "photo_browse", "photo_choose_file", "photo_error_decode", "photo_error_dimensions", "photo_error_dimensions_ui", "photo_error_encode", "photo_error_file_size", "photo_error_file_type", "photo_error_invalid_data", "photo_error_original_size", "photo_forbidden", "photo_no_selection", "photo_ready", "photo_requirements", "points", "pomodoro_sound_disabled", "pomodoro_subtitle", "pomodoro_title", "pomodoro_title_plain", "proces_freeze", "profile_active_label", "profile_backup_codes", "profile_backup_desc", "profile_berhasil", "profile_bio", "profile_bio_label", "profile_bio_label_short", "profile_change_pw", "profile_change_pw_btn", "profile_class", "profile_class_level", "profile_confirm_delete_type", "profile_confirm_title", "profile_delete_account", "profile_delete_btn", "profile_delete_cancel", "profile_delete_permanent", "profile_delete_ph", "profile_delete_title", "profile_delete_warning", "profile_delete_warning2", "profile_delete_warning_label", "profile_display_name", "profile_display_name_label", "profile_display_ph", "profile_edit", "profile_generate_backup", "profile_joined_prefix", "profile_new_pw", "profile_new_pw_placeholder", "profile_no_bio", "profile_old_pw", "profile_old_pw_placeholder", "profile_photo", "profile_photo_dialog_title", "profile_rebirth_conditions", "profile_rebirth_error", "profile_relationship_couple", "profile_relationship_none", "profile_relationship_pending", "profile_save", "profile_save_security", "profile_security_question", "profile_select_class", "profile_title", "profile_update_success", "pw_strength_fair", "pw_strength_hint", "pw_strength_strong", "pw_strength_title", "pw_strength_very_strong", "pw_strength_very_weak", "pw_strength_weak", "quest_complete_msg", "quest_pending", "quickadd_add", "quickadd_added", "quickadd_name_ph", "quickadd_title", "quickadd_type", "recipe_add_title", "recur_days_label", "recur_every_day_hint", "recur_not_today", "redeem_admin", "redeem_code", "redeem_invalid", "redeem_success", "register_button_text", "register_success_login_now", "register_username_invalid", "restore_window", "return_title", "save_json", "save_profile", "saving_add_amount_label", "saving_add_funds_title", "saving_add_title", "saving_added", "saving_added_amount", "saving_balance_label", "saving_current_amount", "saving_deadline_format", "saving_edit_title", "saving_icon_bank", "saving_icon_education", "saving_icon_food", "saving_icon_gift", "saving_icon_health", "saving_icon_house", "saving_icon_investment", "saving_icon_pet", "saving_icon_shopping", "saving_icon_target", "saving_icon_vacation", "saving_icon_vehicle", "saving_name_empty", "saving_target_format", "saving_updated", "saving_withdraw_balance_label", "saving_withdraw_income", "saving_withdrawn", "seasonal_active_banner", "security_q1", "security_q2", "security_q3", "security_q4", "security_q5", "security_q6", "security_q7", "skill_arcane", "skill_gold_shot", "skill_mp_insufficient", "skill_regenerate", "skill_shadow", "skill_shield", "skill_used_msg", "skill_used_title", "sport_activity_name", "sport_add_title", "sport_best_rank", "sport_btn_complete", "sport_btn_done", "sport_cal_avg", "sport_cal_today", "sport_cal_week", "sport_complete_message", "sport_complete_title", "sport_difficulty_easy", "sport_difficulty_epic", "sport_difficulty_hard", "sport_difficulty_medium", "sport_duration", "sport_edit_title", "sport_empty", "sport_filter_all", "sport_intensity", "sport_intensity_easy", "sport_intensity_epic", "sport_intensity_hard", "sport_intensity_medium", "sport_level", "sport_level_default", "sport_level_up", "sport_log_reps_btn", "sport_log_reps_hint", "sport_log_reps_title", "sport_log_reps_total", "sport_no_activity", "sport_reps_chart_title", "sport_reps_chip", "sport_reps_today", "sport_reps_week", "sport_tab_all", "sport_title", "stats_active_pet", "stats_activity_log", "stats_avg_calories", "stats_avg_hr", "stats_avg_hr_value", "stats_avg_sleep", "stats_avg_sleep_value", "stats_avg_steps", "stats_avg_steps_value", "stats_avg_water", "stats_avg_water_ml", "stats_avg_water_value", "stats_avg_weight", "stats_avg_weight_value", "stats_boss_killed_value", "stats_buff_active", "stats_buff_boss_damage", "stats_buff_gold_multiplier", "stats_buff_hp_reduction", "stats_buff_mp_bonus", "stats_buff_none", "stats_buff_revive", "stats_buff_xp_multiplier", "stats_calories_7days", "stats_chart_economy", "stats_chart_xp_gold", "stats_class", "stats_daily_today_value", "stats_days_recorded", "stats_days_recorded_value", "stats_days_tracked", "stats_export", "stats_export_btn", "stats_export_format_label", "stats_export_format_title", "stats_export_lib_error", "stats_habit_today_value", "stats_health_7days", "stats_hp", "stats_hp_value", "stats_items", "stats_items_value", "stats_level", "stats_mp", "stats_mp_value", "stats_no_buff", "stats_nutrition", "stats_pets_value", "stats_quest_done_value", "stats_save_file", "stats_sport_level", "stats_sport_level_value", "stats_sport_streak", "stats_sport_streak_value", "stats_sport_today", "stats_sport_today_value", "stats_streak_value", "stats_title", "stats_total_calories", "stats_total_gold", "stats_total_gold_value", "stats_total_sport_pts", "stats_total_sport_pts_value", "stats_total_transactions", "stats_total_water", "stats_total_xp", "stats_total_xp_value", "stats_weekly_economy", "stats_weekly_xp", "sub_icon_ai", "sub_icon_book", "sub_icon_general", "sub_icon_gym", "sub_icon_music", "sub_icon_tv", "sub_name_placeholder", "sub_period_monthly", "sub_period_onetime", "sub_period_yearly", "subscription_add_title", "subscription_added", "subscription_amount_period", "subscription_edit_title", "subscription_expired", "subscription_insufficient_balance", "subscription_renewed_auto", "subscription_renewed_manual", "supplies_col_category", "supplies_col_location", "supplies_col_name", "supplies_col_unit", "supplies_delete", "supplies_delete_confirm", "supplies_economy_category", "supplies_economy_linked", "supplies_economy_ph", "supplies_edit", "supplies_err_name", "supplies_err_qty", "supplies_err_stock", "supplies_subtitle", "supplies_title", "supplies_tx", "supplies_value_by_category", "talents_btn", "talents_title", "task_add_button", "task_bad_habit", "task_btn_check", "task_btn_delete", "task_btn_done", "task_btn_duplicate", "task_btn_fail", "task_btn_folder", "task_daily_fail", "task_daily_fail_title", "task_daily_freeze_title", "task_daily_success", "task_diff_easy_text", "task_diff_epic_text", "task_diff_hard_text", "task_diff_medium_text", "task_empty_daily", "task_empty_habit", "task_empty_todo", "task_fail_streak_days", "task_filter_all", "task_folder_button", "task_habit_success", "task_hp_loss", "task_icon_build", "task_icon_combat", "task_icon_exercise", "task_icon_focus", "task_icon_growth", "task_icon_health", "task_icon_hydration", "task_icon_ideas", "task_icon_mindfulness", "task_icon_quest", "task_icon_sleep", "task_icon_study", "task_priority_easy", "task_priority_easy_text", "task_priority_hard", "task_priority_hard_text", "task_priority_medium", "task_priority_medium_text", "task_priority_trivial", "task_priority_trivial_text", "task_quest_complete", "task_quest_success", "task_reward_format", "task_search", "task_status_history", "task_status_never", "task_tab_all", "task_title_daily", "task_title_habit", "task_title_todo", "theme_ancient_city", "theme_change_success", "theme_changed_title", "theme_nether", "theme_ocean", "theme_overworld", "theme_the_end", "theme_toggle_tip", "tier_beginner", "tier_elite", "tier_hard", "tier_legendary", "tier_normal", "tray_quick_add", "undo_btn", "undo_expired", "undo_item_deleted", "undo_restored", "unit_kcal", "unit_minutes", "unit_quantity", "unit_serving", "victory_msg", "water_bonus", "web_api_start_failed", "web_boss_block", "web_boss_class_skill", "web_boss_heavy", "web_boss_light", "web_boss_ultimate", "web_craft_title", "web_engine_missing_exe", "web_life_cal", "web_life_econ", "web_life_food", "web_life_notes", "web_life_pomo", "web_life_saved", "web_life_sport", "web_palette_empty", "web_studio_guild", "web_studio_learn", "web_studio_love", "web_studio_music", "web_studio_need_key", "web_studio_need_source", "web_switch_account", "web_switch_lang", "web_update_none", "widget_compact", "widget_heatmap", "widget_insights", "word_section_economy", "word_section_health", "word_section_health_log", "word_section_nutrition", "word_section_stats", "word_section_user", "word_section_xp_gold", "word_table_dailies", "word_table_economy", "word_table_habits", "word_table_quests", "word_table_sport", "word_title_export", "wrapped_btn", "wrapped_close", "wrapped_economy", "wrapped_habits_top",
    "boss_locked", "economy_total_label", "guild_unclaimed_reward", "health_meal_log_title", "supplies_more",
    "dialog_cancel", "music", "music_download",
    "ph_e_g_20_pushups_stretching", "ph_e_g_5km_morning_loop_4_sets_pullups", "ph_e_g_chapter_1_notes_article_summary", "ph_e_g_makan_siang_bersama_tim", "ph_e_g_master_of_habits_conqueror_of_procra", "ph_e_g_minum_2l_air_read_15_mins", "ph_e_g_physics_dynamics_machine_learning", "ph_e_g_pinjaman_laptop_piutang_ke_budi", "ph_e_g_selesaikan_laporan_keuangan_q3", "ph_e_g_slept_deeply_had_high_focus_today", "ph_e_g_sup_buntut_protein_bar", "ph_nama_makanan", "ph_notes", "ph_paste_notes_textbook_paragraphs_or_docum", "ph_routine_instructions", "ph_short_summary_of_this_notebook", "ph_sleep_h", "ph_steps", "ph_task_details_and_deliverables", "ph_tips_or_motivations",
    "buff_xp_multiplier", "buff_gold_multiplier", "buff_boss_damage", "buff_hp_reduction", "buff_mp_bonus", "buff_revive", "buff_crit_chance", "buff_block_chance", "buff_block_strength", "buff_spyglass", "buff_guild_xp", "buff_guild_gold", "buff_guild_damage", "buff_guild_crit", "buff_pet", "buff_class_hp", "buff_class_streak", "buff_skill_shield", "buff_skill_arcane", "buff_skill_goldshot", "buff_skill_shadow", "buff_rebirth", "buff_bar_title", "buff_bar_empty",
    "profile_class_cooldown_hint",
    "task_difficulty_trivial", "task_difficulty_easy", "task_difficulty_medium", "task_difficulty_hard", "task_difficulty_epic", "habit_good", "habit_bad", "habit_positive", "habit_negative", "habit_edit_habit", "daily_edit_daily", "quest_edit_quest", "ph_e_g_minum_2l_air_read_15_mins", "ph_tips_or_motivations", "ph_e_g_20_pushups_stretching", "ph_routine_instructions", "ph_e_g_selesaikan_laporan_keuangan_q3", "ph_task_details_and_deliverables", "daily_freeze_shields", "daily_frozen", "daily_freeze_tooltip", "task_delete_title", "task_edit_title", "task_duplicate_title", "sport_notes_ph",
    "folder_rename_prompt", "folder_new_placeholder",
    "economy_total_income_label", "economy_total_expense_label", "economy_net_balance_label", "economy_donut_empty", "economy_donut_total", "economy_tab_transactions", "economy_tab_debts", "economy_tab_savings", "economy_tab_investments", "economy_tab_subs", "economy_tab_iou", "economy_new_transaction", "economy_new_debt", "economy_edit_transaction_tooltip", "economy_edit_debt_tooltip", "economy_edit_tooltip", "economy_empty_transactions", "economy_debt_total_payable", "economy_debt_total_receivable", "economy_debt_type_payable", "economy_debt_type_receivable", "economy_debt_paid", "economy_due_label", "economy_total_label", "economy_remaining_label", "economy_pay_installment", "economy_saving_name_ph", "economy_invest_placeholder", "economy_withdraw_btn", "economy_sub_placeholder", "economy_save_btn", "economy_iou_person_ph", "economy_settle_btn", "economy_tx_name_ph", "economy_category_label", "economy_amount_currency_label", "economy_debt_total_input", "economy_notes_label", "economy_tx_notes_ph", "economy_debt_title_label", "economy_debt_title_ph", "economy_debt_due_label", "economy_debt_hint", "economy_folder_root", "economy_status_paid", "economy_status_unpaid", "economy_invest_collect_btn", "subscription_updated",
    "supplies_stock_in", "supplies_stock_out", "supplies_logged_to_economy", "achievement_claimed_toast", "achievement_subtitle", "leaderboard_local_hint", "leaderboard_cloud_fallback", "leaderboard_empty", "leaderboard_cloud_empty"]







def configure(user_id: int, token: str | None = None) -> None:
    _state["user_id"] = int(user_id)
    _state["token"] = token
    # P62: auto-purge history tracker di background bila sudah due (best-effort,
    # tidak memblokir login; backup otomatis dibuat di dalam purge).
    try:
        import threading as _th
        _th.Thread(target=db.maybe_auto_purge, args=(int(user_id),), daemon=True).start()
    except Exception:
        pass


def _json_bytes(obj) -> bytes:
    return json.dumps(obj, ensure_ascii=False, default=str).encode("utf-8")


def _row_user(u: dict) -> dict:
    if not u:
        return {}
    level = int(u.get("level") or 1)
    cls = (u.get("avatar_class") or "warrior").lower()
    if cls == "archer":
        cls = "ranger"
    ice = 0
    try:
        for row in db.get_inventory(u.get("id")):
            if row.get("item_id") == "ice_block":
                ice += int(row.get("quantity") or 0)
    except Exception:
        ice = 0
    active_pet = None
    try:
        for p in db.get_user_pets(u.get("id")):
            if p.get("is_active"):
                active_pet = p.get("pet_id")
                break
    except Exception:
        pass
    has_photo = False
    try:
        has_photo = db.get_profile_photo(u.get("id")) is not None
    except Exception:
        has_photo = False
    return {
        "id": str(u.get("id")),
        "username": u.get("username") or "",
        "displayName": u.get("display_name") or u.get("username") or "",
        "name": u.get("display_name") or "",
        "bio": u.get("bio") or "",
        "avatarClass": cls if cls in ("warrior", "mage", "rogue", "paladin", "ranger", "healer") else "warrior",
        "heroClass": u.get("avatar_class") or "warrior",
        "avatarEmoji": u.get("avatar_emoji") or "⚔️",
        "avatar": u.get("avatar_emoji") or "⚔️",
        "avatarColor": u.get("avatar_color") or "#ef4444",
        "level": level,
        "xp": int(u.get("xp") or 0),
        "xpToNextLevel": level * 150,
        "hp": int(u.get("hp") or 0),
        "maxHp": int(u.get("max_hp") or 50),
        "mp": int(u.get("mp") or 0),
        "maxMp": int(u.get("max_mp") or 30),
        "gold": int(round(float(u.get("gold") or 0))),
        "gems": int(u.get("gems") or 0),
        "rebirthCount": int(u.get("rebirth_count") or 0),
        "sportLevel": int(u.get("sport_level") or 1),
        "sportXp": int(u.get("sport_xp") or 0),
        "activePetId": active_pet,
        "equippedWeapon": None,
        "equippedArmor": None,
        "equippedTool": None,
        "equippedLegendary": None,
        "freezeSlots": ice,
        "createdAt": u.get("created_at") or "",
        "language": u.get("language") or "id",
        "theme": u.get("theme") or "modern_dark",
        "soundEnabled": bool(u.get("sound_enabled", 1)),
        "longestStreak": int(u.get("longest_streak") or 0),
        "guildId": u.get("guild_id"),
        "currency": u.get("currency") or "IDR",
        "selectedTitle": u.get("selected_title") or "",
        "hasProfilePhoto": has_photo,
        "fontScale": int(u.get("font_scale") or 100),
        "highContrast": bool(u.get("high_contrast")),
        "isAdmin": bool(u.get("is_admin")),
        "hasSpyglass": bool(u.get("has_spyglass")),
        "lastClassChange": u.get("last_class_change") or "",
        "onboardingDone": bool(u.get("onboarding_done")),
        # Parity GuildPage._attack attack-info line: atk = 25 + bonus buff damage.
        "bossDamageBonus": int(u.get("boss_damage_bonus") or 0),
        "hpDamageReduction": int(u.get("hp_damage_reduction") or 0),
        "mpBonus": int(u.get("mp_bonus") or 0),
        "locked": bool(db.is_account_locked(u.get("id"))),
    }


def _rebirth_status(uid: int) -> dict:
    """Parity ProfilePage._rebirth / load(): kembalikan 4 syarat rebirth + info bonus.

    React memakai data ini untuk menampilkan daftar kondisi ✅/❌ sebelum konfirmasi
    (sama seperti PyQt rebirth_conditions_label).
    """
    u = db.get_user(uid) or {}
    conn = db.get_conn()
    try:
        ach_count = conn.execute(
            "SELECT COUNT(*) FROM user_achievements WHERE user_id=? AND unlocked_at IS NOT NULL",
            (uid,),
        ).fetchone()[0]
        pet_count = conn.execute("SELECT COUNT(*) FROM user_pets WHERE user_id=?", (uid,)).fetchone()[0]
        item_count = conn.execute("SELECT COUNT(*) FROM inventory WHERE user_id=?", (uid,)).fetchone()[0]
    finally:
        conn.close()
    level = int(u.get("level") or 1)
    rebirth = int(u.get("rebirth_count") or 0)
    return {
        "ok": True,
        "rebirthCount": rebirth,
        "xpBonus": rebirth * 10,
        "goldBonus": rebirth * 5,
        "level": level,
        "conditions": {
            "achievements": {"count": ach_count, "need": 10, "met": ach_count >= 10},
            "level": {"count": level, "need": 25, "met": level >= 25},
            "pets": {"count": pet_count, "need": 2, "met": pet_count >= 2},
            "items": {"count": item_count, "need": 6, "met": item_count >= 6},
        },
        "canRebirth": ach_count >= 10 and level >= 25 and pet_count >= 2 and item_count >= 6,
    }


def _map_habit(h: dict) -> dict:
    diff = (h.get("difficulty") or "medium").lower()
    if diff not in ("trivial", "easy", "medium", "hard", "epic"):
        diff = "medium"
    return {
        "id": str(h.get("id")),
        "title": h.get("name") or "",
        "notes": h.get("notes") or "",
        "folderId": str(h["folder_id"]) if h.get("folder_id") else None,
        "difficulty": diff,
        "isPositive": bool(h.get("positive", 1)),
        "isNegative": bool(h.get("negative", 0)),
        # C08: streak MURNI — JANGAN fallback ke counter lifetime (bug: angka
        # lama bangkit lagi saat streak=0). counter_* tetap di DB sbg statistik.
        "positiveStreak": int(h.get("streak") or 0),
        "negativeStreak": int(h.get("fail_streak") or 0),
        "history": [],
        "createdAt": h.get("created_at") or "",
        "icon": h.get("icon") or "⚔️",
        "doneToday": bool(h.get("done_today")),
        "sortOrder": int(h.get("sort_order") or 0),
    }


def _parse_repeat(raw) -> list:
    if not raw:
        return [0, 1, 2, 3, 4, 5, 6]
    s = str(raw)
    days = []
    for part in s.replace(";", ",").split(","):
        part = part.strip()
        if part.isdigit():
            days.append((int(part) + 1) % 7)
    return sorted(set(days)) or [0, 1, 2, 3, 4, 5, 6]


def _repeat_to_db(days) -> str:
    """Konvensi JS getDay (0=Minggu..6=Sabtu) → Python weekday untuk simpan
    repeat_days. Semua 7 hari terpilih = string kosong (parity WeekdaySelector:
    kosong berarti tiap hari)."""
    valid = sorted({(int(d) + 6) % 7 for d in days if 0 <= int(d) <= 6})
    if not valid or len(valid) == 7:
        return ""
    return ",".join(str(d) for d in valid)


def _dashboard_summary(uid):
    """/api/dashboard/summary — rank, statistik, insight, grafik tidur↔produktivitas,
    weekly XP/gold, target & kalori hari ini, berat terakhir.
    Parity DashboardPage PyQt (_rank_card, stat cards, progress rings,
    _refresh_insights, _refresh_health_chart)."""
    s = db.get_stats(uid)
    u = s.get("user") or {}
    weight_kg = 65.0
    try:
        conn = db.get_conn()
        rw = conn.execute(
            "SELECT weight_kg FROM health_logs WHERE user_id=? AND weight_kg IS NOT NULL ORDER BY log_date DESC LIMIT 1",
            (uid,),
        ).fetchone()
        conn.close()
        if rw and rw["weight_kg"]:
            weight_kg = float(rw["weight_kg"])
    except Exception:
        pass
    try:
        goals = db.get_nutrition_goals(uid) or {}
        cal_goal = int(goals.get("daily_calories") or 2000)
    except Exception:
        cal_goal = 2000
    try:
        cal_today = int((db.get_nutrition_summary(uid) or {}).get("calories") or 0)
    except Exception:
        cal_today = 0
    try:
        rank = db.calculate_rank(uid)
    except Exception:
        rank = {}
    try:
        insights = db.get_insights(uid)
    except Exception:
        insights = {"has_data": False}
    try:
        health_chart = db.get_health_productivity_series(uid)
    except Exception:
        health_chart = {"series": [], "correlation": 0.0, "days_with_sleep_data": 0}
    return {
        "ok": True,
        "rank": {
            "rank": int(rank.get("rank") or 0),
            "icon": rank.get("rank_icon") or "🥚",
            "nameKey": rank.get("rank_name_key") or "rank_pemula",
            "descKey": rank.get("rank_desc_key") or "rank_desc_pemula",
            "score": int(rank.get("score") or 0),
            "maxScore": int(rank.get("max_score") or 100),
        },
        "stats": {
            "maxStreak": int(s.get("max_streak") or 0),
            "bossesKilled": int(s.get("bosses_killed") or 0),
            "totalTasksCompleted": int(u.get("total_tasks_completed") or 0),
            "habitsDoneToday": int(s.get("habits_done_today") or 0),
            "habitsTotal": int(s.get("habits_total") or 0),
            "dailiesDoneToday": int(s.get("dailies_done_today") or 0),
            "dailiesTotal": int(s.get("dailies_total") or 0),
            "todosDone": int(s.get("todos_done") or 0),
            "todosTotal": int(s.get("todos_total") or 0),
        },
        "caloriesToday": cal_today,
        "calorieGoal": cal_goal,
        "weightKg": weight_kg,
        "insights": insights,
        "healthChart": {
            "series": [
                {"date": d, "sleep": sl, "tasks": tk}
                for d, sl, tk in (health_chart.get("series") or [])
            ],
            "correlation": float(health_chart.get("correlation") or 0.0),
            "daysWithSleepData": int(health_chart.get("days_with_sleep_data") or 0),
        },
        "weekly": s.get("weekly") or [],
        # P29: parity DashboardPage._render — recent activity feed (s["recent_log"]) +
        # health summary group (db.get_health_summary). Keduanya bagian tetap (bukan
        # widget configurable) yang dulu belum dirender di React.
        "recentLog": [
            {
                "ts": (entry.get("created_at") or "")[11:16] if entry.get("created_at") else "",
                "action": entry.get("action") or "",
                "detail": entry.get("detail") or "",
            }
            for entry in (s.get("recent_log") or [])[:8]
        ],
        "healthSummary": (lambda _h: {
            "avg_steps": _h.get("avg_steps") or 0,
            "avg_sleep": _h.get("avg_sleep") or 0,
            "avg_water": _h.get("avg_water") or 0,
            "avg_weight": _h.get("avg_weight") or 0,
            "avg_hr": _h.get("avg_hr") or 0,
            "days_recorded": _h.get("days_recorded") or 0,
        })(db.get_health_summary(uid)),
    }


def _map_daily(d: dict) -> dict:
    diff = (d.get("difficulty") or "medium").lower()
    if diff not in ("trivial", "easy", "medium", "hard", "epic"):
        diff = "medium"
    return {
        "id": str(d.get("id")),
        "title": d.get("name") or "",
        "notes": d.get("notes") or "",
        "folderId": str(d["folder_id"]) if d.get("folder_id") else None,
        "difficulty": diff,
        "streak": int(d.get("streak") or 0),
        "isCompletedToday": bool(d.get("done_today")),
        "repeatDays": _parse_repeat(d.get("repeat_days")),
        "lastCompletedDate": d.get("last_done"),
        "isFrozen": int(d.get("freeze_slots") or 0) > 0,
        "createdAt": d.get("created_at") or "",
        "icon": d.get("icon") or "📅",
        "sortOrder": int(d.get("sort_order") or 0),
    }


def _map_todo(t: dict) -> dict:
    prio = (t.get("priority") or "medium").lower()
    if prio not in ("trivial", "easy", "medium", "hard", "epic"):
        prio = "medium"
    return {
        "id": str(t.get("id")),
        "title": t.get("name") or "",
        "notes": t.get("notes") or "",
        "folderId": str(t["folder_id"]) if t.get("folder_id") else None,
        "difficulty": prio,
        "dueDate": t.get("due_date"),
        "isCompleted": bool(t.get("done")),
        "completedAt": None,
        "createdAt": t.get("created_at") or "",
        "icon": t.get("icon") or "📜",
        "sortOrder": int(t.get("sort_order") or 0),
    }


def _map_inv(row: dict) -> dict:
    qty = row.get("quantity")
    return {
        "itemId": row.get("item_id"),
        # qty 0 HARUS tetap 0 (consumable habis) — jangan di-coerce jadi 1,
        # kalau tidak Crafting menganggap bahan masih ada. NULL (legacy) → 1.
        "quantity": int(qty) if qty is not None else 1,
        "equipped": bool(row.get("equipped")),
        "rowId": row.get("id"),
        "enchantLevel": int(row.get("enchant_level") or 0),
        # P26: slot equipment (1..10); 0 = tidak di-slot.
        "equipSlot": int(row.get("equip_slot") or 0),
    }


def _map_pet(row: dict) -> dict:
    return {
        "petId": row.get("pet_id"),
        "nickname": row.get("nickname") or row.get("pet_id"),
        "level": int(row.get("level") or 1),
        "xp": int(row.get("exp") or row.get("xp") or 0),
        # P25-fix: jangan pakai `or 100` pada hunger — ketika hunger = 0,
        # `0 or 100` menjadi 100 (bug 0->100). Hanya default ke 100 bila NULL/absent.
        "hunger": int(row.get("hunger")) if row.get("hunger") is not None else 100,
        "isEquipped": bool(row.get("is_active")),
        "adoptedAt": row.get("adopted_at") or "",
    }


def _leaderboard_title_loc(key: str, uid: int) -> str:
    """Parity LeaderboardPage: map title key → nama terlokalisasi (db.TITLES)."""
    if not key:
        return ""
    try:
        u = db.get_user(uid) or {}
        lang = u.get("language") or "id"
        tmap = {t["key"]: (t["name"][0] if lang == "id" else t["name"][1]) for t in db.TITLES}
        return tmap.get(key, "")
    except Exception:
        return ""


def _map_ach(row: dict) -> dict:
    unlocked = bool(row.get("unlocked_at"))
    try:
        _lang = (db.get_user(_state.get("user_id") or 0) or {}).get("language") or "id"
        _t_name, _t_desc = db.tr_achievement(row, _lang)
    except Exception:
        _t_name, _t_desc = row.get("name") or "", row.get("description") or ""
    return {
        "id": str(row.get("id")),
        "title": _t_name,
        "desc": _t_desc,
        "rawName": row.get("name") or "",
        "rawDesc": row.get("description") or "",
        "category": row.get("category") or "level",
        "icon": row.get("icon") or "🏆",
        "xpReward": int(row.get("xp_reward") or 0),
        "goldReward": int(row.get("gold_reward") or 0),
        "currentProgress": int(row.get("progress") or 0),
        "targetProgress": int(row.get("requirement_value") or 1),
        "isUnlocked": unlocked,
        "isClaimed": bool(row.get("claimed")),
    }


def _shop_catalog() -> list:
    out = []
    for iid, item in getattr(db, "SHOP_ITEMS", {}).items():
        rec = dict(item)
        rec["id"] = iid
        rec["buffDesc"] = rec.pop("buff_desc", rec.get("buffDesc", ""))
        rec["craftOnly"] = bool(rec.get("craftOnly") or rec.get("craft_only"))
        rec["seasonal"] = rec.get("seasonal") or ""
        # Parity ShopPage.load: db.is_shop_item_visible (craft_only tersembunyi,
        # seasonal hanya saat window event aktif).
        try:
            rec["visible"] = bool(db.is_shop_item_visible(iid))
        except Exception:
            rec["visible"] = not rec["craftOnly"]
        out.append(rec)
    return out


def _pet_catalog() -> list:
    out = []
    for pid, pet in getattr(db, "PETS_DATA", {}).items():
        rec = dict(pet)
        rec["id"] = pid
        rec["baseBuff"] = rec.pop("base_buff", rec.get("baseBuff", {}))
        out.append(rec)
    return out


def _boss_catalog() -> list:
    out = []
    for bid, b in getattr(db, "BOSSES", {}).items():
        rec = dict(b)
        rec["id"] = bid
        rec["maxHp"] = rec.get("hp")
        rec["xpReward"] = rec.get("xp") or rec.get("xpReward")
        rec["goldReward"] = rec.get("gold") or rec.get("goldReward")
        rec["minLevel"] = rec.get("min_level") or rec.get("minLevel") or 1
        out.append(rec)
    return out


def _recipe_catalog() -> list:
    out = []
    for rid, r in getattr(db, "CRAFTING_RECIPES", {}).items():
        inputs = r.get("inputs") or []
        req = [{"itemId": i, "quantity": 1} for i in inputs]
        desc = r.get("desc") or ("", "")
        out.append({
            "id": rid,
            "resultItemId": r.get("output") or rid,
            "requiredItems": req,
            "goldCost": int(r.get("gold") or 0),
            # Parity CraftingPage: desc dipilih per bahasa user.
            "descId": desc[0] if len(desc) > 0 else "",
            "descEn": desc[1] if len(desc) > 1 else desc[0] if desc else "",
        })
    return out


def _server_now() -> dict:
    """Waktu server saat ini (zona app = Asia/Jakarta). Parity TimeSync: frontend
    memakai ini sebagai sumber 'today' + jam tunggal agar konsisten dengan reset
    harian backend (bukan new Date() browser yang bisa beda zona/clock).
    epoch (unix s) + tzOffsetMin dipakai frontend merender HH:MM:SS yang benar."""
    import datetime as _dt
    try:
        now = _dt.datetime.now()
    except Exception:
        now = _dt.datetime.now()
    try:
        tz = _dt.datetime.now().astimezone().tzinfo
        off = _dt.datetime.now().astimezone().utcoffset() or _dt.timedelta()
        tz_min = int(off.total_seconds() // 60)
    except Exception:
        tz_min = 0
    return {
        "iso": now.isoformat(),
        "date": now.strftime("%Y-%m-%d"),
        "time": now.strftime("%H:%M:%S"),
        "epoch": int(now.timestamp()),
        "tzOffsetMin": tz_min,
        "weekday": now.weekday(),
    }


# ── A03.5: berkas yang dibuat di sisi klien (tracker JSON, ekspor studio) ──────
# Dulu UI memakai blob + <a download>, yang dibuang diam-diam oleh Qt WebEngine.
# Kini berkas "dititipkan" ke server lalu diunduh sebagai ATTACHMENT HTTP biasa —
# jalur yang pasti memicu unduhan + nama berkas benar.
_DL_MAX_BYTES = 8 * 1024 * 1024
_DL_TTL_SECONDS = 3600


def _dl_stage_dir(uid) -> str:
    d = os.path.join(tempfile.gettempdir(), "craftlife_downloads", str(uid or 0))
    os.makedirs(d, exist_ok=True)
    return d


def _dl_prune(folder: str) -> None:
    """Buang berkas titipan yang lebih tua dari _DL_TTL_SECONDS (best-effort)."""
    try:
        now = _time.time()
        for name in os.listdir(folder):
            path = os.path.join(folder, name)
            try:
                if os.path.isfile(path) and (now - os.path.getmtime(path)) > _DL_TTL_SECONDS:
                    os.remove(path)
            except Exception:
                continue
    except Exception:
        pass


def _dl_stage_file(uid, body: dict) -> dict:
    """Simpan isi berkas dari UI → kembalikan id untuk diunduh via attachment."""
    name = os.path.basename(str(body.get("name") or "craftlife-download").replace("\\", "/").split("/")[-1])
    name = "".join(ch for ch in name if ch not in '<>:"/\\|?*' and ord(ch) >= 32).strip(" .") or "craftlife-download"
    mime = str(body.get("mime") or "application/octet-stream").split(";")[0].strip()
    raw = b""
    if body.get("base64"):
        try:
            raw = base64.b64decode(str(body.get("base64")))
        except Exception:
            return {"ok": False, "error": "bad_base64"}
    elif body.get("text") is not None:
        raw = str(body.get("text")).encode("utf-8")
    if not raw:
        return {"ok": False, "error": "empty_content"}
    if len(raw) > _DL_MAX_BYTES:
        return {"ok": False, "error": "too_large", "maxBytes": _DL_MAX_BYTES}
    folder = _dl_stage_dir(uid)
    _dl_prune(folder)
    file_id = f"{int(_time.time())}_{uuid.uuid4().hex[:12]}"
    with open(os.path.join(folder, f"{file_id}.{name}"), "wb") as fh:
        fh.write(raw)
    return {"ok": True, "id": file_id, "name": name, "mime": mime, "size": len(raw)}


# A06: Content-Type yang benar per ekstensi. Sebelumnya SEMUA berkas titipan
# dikirim sebagai `application/octet-stream` (mime dari UI hilang), sehingga browser
# tidak mengenali mis. .md/.csv/.lrc dan hanya menawarkannya sebagai unduhan mentah.
_DL_MIME = {
    ".md": "text/markdown", ".txt": "text/plain", ".csv": "text/csv",
    ".json": "application/json", ".lrc": "text/plain", ".log": "text/plain",
    ".pdf": "application/pdf", ".zip": "application/zip",
    ".xlsx": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
    ".docx": "application/vnd.openxmlformats-officedocument.wordprocessingml.document",
    ".png": "image/png", ".jpg": "image/jpeg", ".jpeg": "image/jpeg",
    ".gif": "image/gif", ".webp": "image/webp", ".svg": "image/svg+xml",
    ".mp3": "audio/mpeg", ".wav": "audio/wav", ".ogg": "audio/ogg", ".m4a": "audio/mp4",
}


def _dl_mime_for(name: str) -> str:
    """Tentukan Content-Type dari ekstensi berkas (fallback octet-stream)."""
    return _DL_MIME.get(os.path.splitext(name or "")[1].lower(), "application/octet-stream")


def _dl_serve_staged(uid, file_id: str):
    """Ambil berkas titipan (id milik user ini saja) → (bytes, name, mime)."""
    if not file_id or not re.fullmatch(r"\d+_[0-9a-f]{6,32}", file_id):
        return None
    folder = _dl_stage_dir(uid)
    prefix = f"{file_id}."
    for name in os.listdir(folder):
        if name.startswith(prefix):
            path = os.path.join(folder, name)
            try:
                with open(path, "rb") as fh:
                    real = name[len(prefix):]
                    return fh.read(), real, _dl_mime_for(real)
            except Exception:
                return None
    return None


def _download_mod():
    """A03.5: akses helper unduhan shell (web_shell) tanpa memaksa PyQt6 terpasang.

    web_shell mengimpor Qt secara opsional, jadi mode web/headless tetap aman:
    folder unduhan + permintaan "buka folder" dihitung dari modul yang sama.
    """
    try:
        import web_shell
        return web_shell
    except Exception:
        return None


def _downloads_info() -> dict:
    mod = _download_mod()
    if mod is None:
        return {"ok": True, "active": False, "dir": "", "lastName": "", "lastPath": "",
                "count": 0, "failures": 0, "note": "shell_unavailable"}
    info = mod.download_info()
    info["ok"] = True
    try:
        info["exists"] = os.path.isdir(info.get("dir") or "")
    except Exception:
        info["exists"] = False
    return info


def _open_downloads_folder(body: dict) -> dict:
    """Buka folder unduhan (atau folder berkas tertentu) di file explorer pengguna."""
    mod = _download_mod()
    target = (body.get("path") or "").strip()
    if target and not os.path.exists(target):
        target = ""
    if mod is None:
        return {"ok": False, "error": "shell_unavailable"}
    if not target:
        target = mod.download_dir()
    # Shell Qt aktif → minta GUI thread membukanya (aman dari thread server).
    mgr = mod.get_download_manager()
    if mgr is not None and getattr(mgr, "installed", False):
        mod.request_open_folder(target)
        return {"ok": True, "dir": target, "mode": "shell"}
    opened = mod.open_folder_via_os(target)
    return {"ok": bool(opened), "dir": target, "mode": "os" if opened else "none",
            "error": "" if opened else "open_failed"}


def _api_daily_reset(kind: str, uid: int):
    """Reset done_today lalu kembalikan list task (habits/dailies/todos)."""
    try:
        db.reset_daily_tasks(uid)
    except Exception:
        pass
    if kind == "habits":
        return {"ok": True, "habits": [_map_habit(h) for h in db.get_habits(uid)]}
    if kind == "dailies":
        return {"ok": True, "dailies": [_map_daily(d) for d in db.get_dailies(uid)]}
    return {"ok": True, "quests": [_map_todo(t) for t in db.get_todos(uid)]}


def _snapshot(uid: int) -> dict:
    u = db.get_user(uid) or {}
    # Parity MainWindow/PostLogin + TaskPage.load/SportTrackPage.load: reset
    # done_today di habits/dailies/sport setiap hari (idempotent — hanya baris
    # yang last_done != hari ini yang dikembalikan ke 0). Tanpa ini web tidak
    # pernah mereset dan habit/daily tidak berulang tiap hari.
    try:
        db.reset_daily_tasks(uid)
    except Exception:
        pass
    try:
        ach = [_map_ach(a) for a in db.get_user_achievements(uid)]
    except Exception:
        ach = []
    try:
        inv = [_map_inv(r) for r in db.get_inventory(uid)]
    except Exception:
        inv = []
    try:
        pets = [_map_pet(r) for r in db.get_user_pets(uid)]
    except Exception:
        pets = []
    payload = {
        "user": _row_user(u),
        "habits": [_map_habit(h) for h in db.get_habits(uid)],
        "dailies": [_map_daily(d) for d in db.get_dailies(uid)],
        "quests": [_map_todo(t) for t in db.get_todos(uid)],
        "inventory": inv,
        "userPets": pets,
        # P43: slot pet aktif bertingkat — dihitung backend (db.max_active_pets),
        # TIDAK boleh dihitung ulang di TypeScript (aturan: rule hanya di database.py).
        "maxActivePets": db.max_active_pets(int((u or {}).get("level") or 1)),
        "achievements": ach,
        "lang": u.get("language") or "id",
        # Parity ShopPage._buff_bar: daftar string buff aktif apa adanya dari db.
        "activeBuffs": db.get_all_active_buffs(uid),
        # P30: buff terstruktur (key + params) untuk render i18n id/en di Navbar.
        "activeBuffsDetail": db.get_active_buffs_structured(uid),
    }
    payload.update(life_api.snapshot(uid))
    payload.update(studio_api.snapshot(uid))
    try:
        battle = db.get_active_boss_for_user(uid)
    except Exception:
        battle = None
    if battle:
        payload["activeBoss"] = {
            "id": battle.get("boss_id") or "",
            "name": battle.get("boss_name") or "",
            "icon": battle.get("boss_icon") or "🐉",
            "tier": battle.get("boss_tier") or "normal",
            "hp": int(battle.get("boss_max_hp") or battle.get("boss_hp") or 0),
            "maxHp": int(battle.get("boss_max_hp") or battle.get("boss_hp") or 0),
            "atk": int(battle.get("boss_attack") or 0),
            "xpReward": 0,
            "goldReward": 0,
            "minLevel": 1,
        }
        payload["activeBossHp"] = int(battle.get("boss_hp") or 0)
        payload["activeBossId"] = battle.get("boss_id")
    else:
        payload["activeBoss"] = None
        payload["activeBossHp"] = 0
        payload["activeBossId"] = None
    link = None
    try:
        link = db.get_cloud_user_link(uid)
    except Exception:
        link = None
    wallet = None
    if link:
        try:
            wallet = db.get_cloud_wallet(uid)
        except Exception:
            wallet = None
        gold_cloud = int((wallet or {}).get("gold") or 0) if wallet else None
        payload["user"]["cloudLinked"] = True
        payload["user"]["goldLocal"] = payload["user"]["gold"]
        payload["user"]["goldCloud"] = gold_cloud
        payload["goldLocal"] = payload["user"]["gold"]
        payload["goldCloud"] = gold_cloud
        payload["cloudLinked"] = True
        # OFFLINE-FIRST: gold & gems LOKAL adalah source of truth yang ditampilkan.
        # Nilai cloud hanya referensi (goldCloud) untuk indikator/sync — JANGAN timpa
        # nilai lokal dengan wallet cloud yang bisa stale/0.
        # (Catatan: sesuai README, wallet/inventory stay local-authoritative sampai
        #  migration 5a/5b diterapkan & terbukti sinkron.)
        # OFFLINE-FIRST: inventory LOKAL = source of truth yang ditampilkan.
        # Cache cloud hanya referensi (inventoryCloud); jangan timpa inventory lokal
        # dengan snapshot cloud yang bisa stale (konsisten dengan gold/gems di atas).
        try:
            cloud_inv = db.get_cloud_inventory_cache(uid)
        except Exception:
            cloud_inv = []
        payload["inventoryCloud"] = [
            {
                "item_id": row.get("item_key"),
                "quantity": row.get("qty") or 0,
                "equipped": row.get("equipped"),
                "enchant_level": row.get("enchant_level") or 0,
            }
            for row in cloud_inv
            if int(row.get("qty") or 0) > 0
        ] if cloud_inv else []
    else:
        payload["goldLocal"] = payload["user"]["gold"]
        payload["goldCloud"] = None
        payload["cloudLinked"] = False
        payload["user"]["goldLocal"] = payload["user"]["gold"]
        payload["user"]["goldCloud"] = None
        payload["user"]["cloudLinked"] = False
    return payload


def _ok_payload(uid: int, result=None, extra=None) -> dict:
    payload = {"ok": True, "result": result or {}}
    payload.update(_snapshot(uid))
    if extra:
        payload.update(extra)
    if isinstance(result, dict) and result.get("leveled_up"):
        payload["levelUp"] = {
            "level": result.get("new_level"),
            "hpGain": 15,
            "mpGain": 10,
            "goldGain": result.get("gold_gained") or 0,
        }
    return payload


def _best_effort_cloud(fn):
    """Jalankan fn di thread daemon dan abaikan error (best-effort cloud sync).

    Dipakai agar sinkronisasi cloud TIDAK PERNAH memblokir sukses operasi lokal.
    Prinsip offline-first: local DB = source of truth seketika; cloud = sync best-effort.
    """
    def _run():
        try:
            fn()
        except Exception:
            pass
    threading.Thread(target=_run, daemon=True).start()


def _equip_item(uid: int, item_id: str, equipped: bool) -> dict:
    # P26: sistem 10 SLOT equipment. Tidak lagi melepas semua item sama-tipe;
    # beberapa item boleh aktif sekaligus (maks 10 slot) di backend.
    if equipped:
        return db.equip_item_slot(uid, item_id)
    return db.unequip_item_slot(uid, item_id)


def _ensure_user() -> int | None:
    uid = _state.get("user_id")
    if uid:
        return int(uid)
    try:
        conn = db.get_conn()
        row = conn.execute("SELECT id FROM users ORDER BY id LIMIT 1").fetchone()
        conn.close()
        if row:
            _state["user_id"] = int(row["id"])
            return int(row["id"])
    except Exception:
        return None
    return None


def _auth_ok(handler) -> bool:
    uid = _ensure_user()
    if not uid:
        return False
    token = _state.get("token")
    hdr = handler.headers.get("Authorization") or ""
    qtoken = parse_qs(urlparse(handler.path).query).get("token", [None])[0]
    given = None
    if hdr.lower().startswith("bearer "):
        given = hdr[7:].strip()
    elif qtoken:
        given = qtoken
    if token and given and given != token:
        return False
    return True


def _guild_id(uid: int):
    u = db.get_user(uid) or {}
    return u.get("guild_id")


_UPLOAD_IMAGE_MAX = 8 * 1024 * 1024
# P54: lampiran note — maks 5 MB/file, whitelist ekstensi (keputusan user 2026-09-08).
_NOTE_ATTACH_MAX = 5 * 1024 * 1024
_NOTE_ATTACH_EXTS = (".png", ".jpg", ".jpeg", ".webp", ".gif", ".pdf", ".txt", ".md", ".csv")
_UPLOAD_AUDIO_MAX = 25 * 1024 * 1024


def _note_attachments_dir(uid: int) -> str:
    """Folder lampiran note P54: <data_root>/craftlife_attachments/<user_id>/."""
    try:
        root = db.get_data_root()  # type: ignore[attr-defined]
    except Exception:
        root = os.path.dirname(os.path.abspath(db.DB_PATH)) if getattr(db, "DB_PATH", "") else os.getcwd()
    d = os.path.join(root, "craftlife_attachments", str(uid))
    os.makedirs(d, exist_ok=True)
    return d

def _learning_source_user_dir(uid: int) -> str:
    """C02: learning_sources/<uid>/ (dibuat bila belum ada)."""
    d = os.path.join(_learning_sources_dir(), str(uid or 0))
    os.makedirs(d, exist_ok=True)
    return d


def _learning_sources_dir() -> str:
    """Folder penyimpanan file sumber Learning (parity path PyQt di data root)."""
    try:
        root = db.get_data_root()  # type: ignore[attr-defined]
    except Exception:
        root = os.path.dirname(os.path.abspath(db.DB_PATH)) if getattr(db, "DB_PATH", "") else os.getcwd()
    d = os.path.join(root, "learning_sources")
    os.makedirs(d, exist_ok=True)
    return d


def _safe_upload_name(name: str, default_ext: str) -> str:
    base = os.path.basename(name or "") or "upload" + default_ext
    base = re.sub(r"[^A-Za-z0-9._\- ]+", "_", base).strip(" .")
    return base or ("upload" + default_ext)


def _prepare_upload_image(raw: bytes, max_side: int):
    """Normalisasi foto upload web — parity _prepare_image_file/_ImagePickerDialog PyQt
    (decode, hormati EXIF orientation, batas 32..4096, downscale ≤ max_side, re-encode
    JPEG q88). Return (bytes, "image/jpeg", w, h) atau None bila bukan gambar valid.
    """
    try:
        import io as _io
        from PIL import Image, ImageOps
        with Image.open(_io.BytesIO(raw)) as im:
            im.load()
            im = ImageOps.exif_transpose(im)
            w, h = im.size
            if not (32 <= w <= 4096 and 32 <= h <= 4096):
                return None
            if im.mode not in ("RGB", "L"):
                im = im.convert("RGB")
            im.thumbnail((max_side, max_side), Image.LANCZOS)
            buf = _io.BytesIO()
            im.save(buf, "JPEG", quality=88)
            return buf.getvalue(), "image/jpeg", im.width, im.height
    except Exception:
        return None


def _handle_upload_file(uid: int, body: dict) -> dict:
    """POST /api/upload/file  {target, name, dataBase64}

    target: love_photo | profile_photo | reminder_sound | music
    Return dict 'result' yang dibungkus _ok_payload oleh caller.
    """
    import base64
    target = (body.get("target") or "").strip()
    raw_b64 = body.get("dataBase64") or ""
    try:
        raw = base64.b64decode(raw_b64, validate=True)
    except Exception:
        return {"ok": False, "error": "invalid_base64", "msg": "invalid_base64"}
    if not raw:
        return {"ok": False, "error": "empty_file", "msg": "empty_file"}

    if target in ("love_photo", "profile_photo"):
        if len(raw) > _UPLOAD_IMAGE_MAX:
            return {"ok": False, "error": "file_too_large", "msg": "web_upload_too_large"}
        max_side = 1280 if target == "love_photo" else 768
        prepared = _prepare_upload_image(raw, max_side)
        if not prepared:
            return {"ok": False, "error": "bad_type", "msg": "web_upload_bad_type"}
        blob, mime, w, h = prepared
        if target == "love_photo":
            import cloud_api as ca
            # Parity LovePage._GalleryPhotoDialog: metadata (caption/date/visibility) ikut
            # saat upload; visibilitas 'shared' hanya valid bila couple aktif.
            try:
                _ctx = db.get_couple_context(uid) or {}
                _couple_active = bool(_ctx.get("active"))
            except Exception:
                _couple_active = False
            vis = "shared" if ((body.get("visibility") or "private") == "shared" and _couple_active) else "private"
            pdate = (body.get("photoDate") or body.get("photo_date") or "").strip() or None
            return ca.love_photo_from_bytes(
                uid, blob, mime,
                caption=(body.get("caption") or "").strip() or None,
                photo_date=pdate,
                visibility=vis,
            )
        result = db.set_profile_photo(uid, uid, blob, mime, w, h)
        if result.get("ok"):
            try:
                if db.get_cloud_user_link(uid):
                    from sync_service import get_sync_service
                    get_sync_service().queue_profile_photo(uid)
            except Exception:
                pass
        return result

    if target in ("reminder_sound", "music"):
        if len(raw) > _UPLOAD_AUDIO_MAX:
            return {"ok": False, "error": "file_too_large", "msg": "web_upload_too_large"}
        name = _safe_upload_name(body.get("name") or "", ".mp3")
        ext = os.path.splitext(name)[1].lower()
        if ext not in (".mp3", ".m4a", ".ogg", ".wav", ".opus", ".flac", ".mp4"):
            return {"ok": False, "error": "bad_type", "msg": "web_upload_bad_type"}
        try:
            import music_downloader as md
            lib_dir = md.get_download_dir()
        except Exception:
            lib_dir = os.path.join(os.path.expanduser("~"), "Music", "CraftLife")
            os.makedirs(lib_dir, exist_ok=True)
        sub = "reminder_sounds" if target == "reminder_sound" else ""
        dest_dir = os.path.join(lib_dir, sub) if sub else lib_dir
        os.makedirs(dest_dir, exist_ok=True)
        dest = os.path.join(dest_dir, f"{uuid.uuid4().hex[:8]}_{name}")
        with open(dest, "wb") as f:
            f.write(raw)
        return {"ok": True, "path": dest, "name": os.path.basename(dest)}

    if target == "playlist_icon":
        # P59: icon playlist dari foto komputer — resize ≤512px (JPEG q88),
        # simpan ke <data_root>/playlist_icons/<uid>/, playlists.icon='photo:<id>'.
        if len(raw) > _UPLOAD_IMAGE_MAX:
            return {"ok": False, "error": "file_too_large", "msg": "music_playlist_icon_too_large"}
        try:
            pid = int(body.get("playlistId") or 0)
        except (TypeError, ValueError):
            pid = 0
        if not pid:
            return {"ok": False, "error": "playlist_required", "msg": "playlist_required"}
        prepared = _prepare_upload_image(raw, 512)
        if not prepared:
            return {"ok": False, "error": "bad_type", "msg": "web_upload_bad_type"}
        blob, mime, _w, _h = prepared
        try:
            root = db.get_data_root()  # type: ignore[attr-defined]
        except Exception:
            root = os.path.dirname(os.path.abspath(db.DB_PATH)) if getattr(db, "DB_PATH", "") else os.getcwd()
        idir = os.path.join(root, "playlist_icons", str(uid))
        os.makedirs(idir, exist_ok=True)
        dest = os.path.join(idir, f"{uuid.uuid4().hex[:8]}.jpg")
        with open(dest, "wb") as f:
            f.write(blob)
        icon_id = db.add_playlist_icon(uid, pid, dest, mime)
        if not icon_id:
            return {"ok": False, "error": "playlist_not_found", "msg": "db_playlist_not_found"}
        return {"ok": True, "icon": f"photo:{icon_id}"}

    if target == "learning_source":
        # C02: dokumen + gambar + audio (20 MB seragam — batas inline API Gemini).
        # Berkas asli DISIMPAN di learning_sources/<uid>/ dan tidak dihapus.
        _LEARN_MAX = 20 * 1024 * 1024
        _LEARN_EXTS = (".pdf", ".docx", ".xlsx", ".xls", ".pptx", ".csv", ".tsv",
                       ".txt", ".md", ".markdown", ".rtf", ".epub",
                       ".png", ".jpg", ".jpeg", ".webp", ".gif",
                       ".mp3", ".wav", ".m4a", ".ogg", ".opus", ".flac")
        if len(raw) > _LEARN_MAX:
            return {"ok": False, "error": "file_too_large", "msg": "learning_too_large",
                    "limit_mb": 20}
        name = _safe_upload_name(body.get("name") or "", ".txt")
        ext = os.path.splitext(name)[1].lower()
        if ext not in _LEARN_EXTS:
            return {"ok": False, "error": "bad_type", "msg": "learning_type_unsupported"}
        sdir = _learning_source_user_dir(uid)
        dest = os.path.join(sdir, f"{uuid.uuid4().hex[:8]}_{name}")
        with open(dest, "wb") as f:
            f.write(raw)
        return {"ok": True, "path": dest, "name": os.path.basename(dest),
                "orig_name": name, "size_bytes": len(raw), "ext": ext}

    if target == "note_attachment":
        # P54: lampiran catatan. File disimpan ke craftlife_attachments/<uid>/,
        # metadata ke tabel note_attachments. Konten note memakai URL file langsung.
        if len(raw) > _NOTE_ATTACH_MAX:
            return {"ok": False, "error": "file_too_large", "msg": "notes_attach_too_large"}
        name = _safe_upload_name(body.get("name") or "", ".txt")
        ext = os.path.splitext(name)[1].lower()
        if ext not in _NOTE_ATTACH_EXTS:
            return {"ok": False, "error": "bad_type", "msg": "notes_attach_type_unsupported"}
        try:
            note_id = int(body.get("noteId") or 0)
        except (TypeError, ValueError):
            note_id = 0
        conn = db.get_conn()
        row = conn.execute("SELECT id FROM notes WHERE id=? AND user_id=?", (note_id, uid)).fetchone()
        conn.close()
        if not note_id or not row:
            return {"ok": False, "error": "bad_note", "msg": "notes_to_learning_no_note"}
        kind = "image" if ext in (".png", ".jpg", ".jpeg", ".webp", ".gif") else "file"
        mime = (body.get("mime") or "").split(";")[0].strip() or "application/octet-stream"
        adir = _note_attachments_dir(uid)
        dest = os.path.join(adir, f"{uuid.uuid4().hex[:8]}_{name}")
        with open(dest, "wb") as f:
            f.write(raw)
        result = db.add_note_attachment(uid, note_id, name, mime, len(raw), kind, dest)
        if not result.get("ok"):
            try:
                os.remove(dest)
            except Exception:
                pass
            return {"ok": False, "error": "attach_fail", "msg": "web_upload_bad_type"}
        att = result.get("attachment") or {}
        return {"ok": True, "attachment": att}

    return {"ok": False, "error": "unknown_target", "msg": "web_upload_bad_type"}


class Handler(BaseHTTPRequestHandler):
    def log_message(self, fmt, *args):
        return

    def _cors(self):
        origin = self.headers.get("Origin") or "*"
        self.send_header("Access-Control-Allow-Origin", origin)
        self.send_header("Access-Control-Allow-Headers", "Authorization, Content-Type")
        self.send_header("Access-Control-Allow-Methods", "GET, POST, OPTIONS")
        self.send_header("Access-Control-Allow-Credentials", "true")

    def _send(self, code, payload, content="application/json"):
        body = payload if isinstance(payload, bytes) else _json_bytes(payload)
        self.send_response(code)
        self._cors()
        self.send_header("Content-Type", content + "; charset=utf-8")
        self.send_header("Content-Length", str(len(body)))
        self.end_headers()
        self.wfile.write(body)

    def do_OPTIONS(self):
        self.send_response(204)
        self._cors()
        self.end_headers()

    def do_GET(self):
        parsed = urlparse(self.path)
        path = parsed.path.rstrip("/") or "/"
        qs = parse_qs(parsed.query)

        if path == "/api/health":
            self._send(200, {"ok": True, "phase": 1})
            return

        if path.startswith("/assets/") or path in ("/", "/index.html"):
            self._serve_static(path)
            return

        # Stream a local library audio file to the browser <audio> element.
        # The path is validated to live inside the CraftLife Music folder, so a
        # web client can "play a local file" (parity with PyQt QMediaPlayer),
        # and stays local — the file is never uploaded anywhere.
        if path == "/music/stream":
            file_path = (qs.get("path") or [""])[0]
            self._serve_audio(file_path)
            return

        # A08: pemutar podcast interaktif memakai elemen <audio> → berkas MP3
        # dua host disajikan dengan Range (bisa seek & lompat antar giliran).
        # Path TIDAK datang dari klien: diambil dari baris DB (notebook+generasi),
        # jadi hanya audio milik notebook pengguna yang bisa diakses.
        if path == "/api/learning/podcast/audio":
            try:
                nid = int((qs.get("notebook") or ["0"])[0] or 0)
                gid = int((qs.get("id") or ["0"])[0] or 0)
            except (TypeError, ValueError):
                nid = gid = 0
            uid_now = _state.get("user_id")
            target = ""
            if nid and gid and uid_now:
                try:
                    import studio_api as _sa
                    nb_ok = any(str(n.get("id")) == str(nid) for n in (db.get_learning_notebooks(uid_now) or []))
                    if nb_ok:
                        row = db.get_learning_audio(nid, gid) or {}
                        target = row.get("path") or ""
                except Exception:
                    target = ""
            if not target:
                target = ""
            audio_root = ""
            try:
                import studio_api as _sa2
                audio_root = _sa2.podcast_audio_dir()
            except Exception:
                audio_root = ""
            self._serve_audio(target, extra_roots=[audio_root] if audio_root else [])
            return

        if not _auth_ok(self) and path.startswith("/api/") and path != "/api/health":
            if path != "/api/i18n":
                self._send(401, {"ok": False, "error": "unauthorized"})
                return

        uid = _state.get("user_id")
        if path == "/api/i18n":
            lang = (qs.get("lang") or ["id"])[0]
            if lang not in ("id", "en"):
                lang = "id"
            keys = qs.get("keys")
            out = {}
            source_keys = keys[0].split(",") if keys else WEB_I18N_KEYS
            for k in source_keys:
                k = k.strip()
                if k:
                    out[k] = get_text(k, lang)
            self._send(200, {"lang": lang, "messages": out})
            return

        if path == "/api/system/download-file":
            file_id = (qs.get("id") or [""])[0].strip()
            got = _dl_serve_staged(_state.get("user_id"), file_id)
            if not got:
                self._send(404, {"ok": False, "error": "file_not_found"})
                return
            blob, fname, mime = got
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Disposition", f'attachment; filename="{fname.split("/")[-1]}"')
            self.send_header("Content-Length", str(len(blob)))
            self.end_headers()
            self.wfile.write(blob)
            return
        routes = {
            "/api/me": lambda: {"ok": True, "user": _row_user(db.get_user(uid))},
            # A03.5: info folder unduhan + berkas terakhir (UI menampilkan lokasi).
            "/api/system/downloads-info": _downloads_info,
            "/api/habits": lambda: _api_daily_reset("habits", uid),
            "/api/dailies": lambda: _api_daily_reset("dailies", uid),
            "/api/todos": lambda: _api_daily_reset("todos", uid),
            "/api/inventory": lambda: {"ok": True, "inventory": [_map_inv(r) for r in db.get_inventory(uid)]},
            "/api/pets": lambda: {"ok": True, "userPets": [_map_pet(r) for r in db.get_user_pets(uid)]},
            "/api/achievements": lambda: {"ok": True, "achievements": [_map_ach(a) for a in db.get_user_achievements(uid)]},
            "/api/catalog/shop": lambda: {"ok": True, "items": _shop_catalog()},
            "/api/catalog/pets": lambda: {"ok": True, "pets": _pet_catalog()},
            "/api/catalog/bosses": lambda: {"ok": True, "bosses": _boss_catalog()},
            "/api/catalog/recipes": lambda: {"ok": True, "recipes": _recipe_catalog()},
            "/api/catalog/currency": lambda: {"ok": True, "rates": getattr(db, "CURRENCY_RATES", {"IDR": 1})},
            "/api/catalog/enchant": lambda: {"ok": True,
                "maxLevel": getattr(db, "ENCHANT_MAX_LEVEL", 5),
                "baseXp": getattr(db, "ENCHANT_BASE_XP", 50)},
            "/api/catalog/class-skills": lambda: {"ok": True,
                "skills": getattr(db, "CLASS_SKILLS", {})},
            "/api/catalog/avatar-classes": lambda: {"ok": True,
                "classes": getattr(db, "AVATAR_CLASSES", {})},
            "/api/buffs": lambda: {"ok": True, "buffs": db.get_all_active_buffs(uid)},
            "/api/profile/talents": lambda: {"ok": True, "talents": db.get_talent_state(uid)},
            "/api/profile/rebirth/status": lambda: _rebirth_status(uid),
            "/api/dashboard/widgets": lambda: {"ok": True, "widgets": db.get_dashboard_widgets(uid)},
            "/api/dashboard/summary": lambda: _dashboard_summary(uid),
            "/api/profile/titles": lambda: {
                "ok": True,
                "selectedTitle": (db.get_user(uid) or {}).get("selected_title") or "",
                "titles": db.get_unlocked_titles(uid),
            },
            # Parity SettingsPage: versi app + path DB (label database group)
            "/api/catalog/avatar-classes": lambda: {
                "ok": True,
                # Parity db.AVATAR_CLASSES — hero class select SettingsView
                "classes": [
                    {"key": k, "name": v.get("name") or k, "icon": v.get("icon") or "",
                     "bonus": v.get("bonus") or ""}
                    for k, v in (db.AVATAR_CLASSES or {}).items()
                ],
            },
            "/api/catalog/themes": lambda: {
                "ok": True,
                # Parity SettingsPage theme radios: palet penuh per tema + preview dot.
                # Palet diekspos utk React (CSS vars) — parity db.THEMES (source of truth).
                "themes": [
                    {"key": k, "label": v.get("label") or k,
                     "primary": v.get("primary") or "", "light": v.get("light") or "",
                     "bg": v.get("bg") or "", "bg2": v.get("bg2") or "", "bg3": v.get("bg3") or "",
                     "panel": v.get("panel") or "", "border": v.get("border") or "",
                     "accent": v.get("accent") or "", "accent2": v.get("accent2") or "",
                     "accent3": v.get("accent3") or "", "glow": v.get("glow") or "",
                     "text": v.get("text") or "", "muted": v.get("muted") or ""}
                    for k, v in (db.THEMES or {}).items()
                ],
            },
            "/api/version": lambda: {
                "ok": True,
                "version": getattr(__import__("updater"), "APP_VERSION", "?"),
                "dbPath": getattr(db, "DB_PATH", ""),
            },
            "/api/leaderboard": lambda: {
                "ok": True,
                "linked": bool(db.get_cloud_user_link(uid)),
                "leaderboard": [
                    {
                        "id": str(r.get("id")),
                        "username": r.get("username") or "",
                        "displayName": r.get("display_name") or r.get("username") or "",
                        "level": int(r.get("level") or 1),
                        "xp": int(r.get("total_xp_earned") or 0),
                        "gold": int(r.get("gold") or 0),
                        "sportLevel": int(r.get("sport_level") or 1),
                        "pets": int(r.get("pet_count") or 0),
                        "rebirth": int(r.get("rebirth_count") or 0),
                        "title": _leaderboard_title_loc(r.get("selected_title") or "", uid),
                        # Parity LeaderboardPage: 💞 + tooltip partner / single
                        "partner": (db.get_couple_partners_map().get(r.get("id")) or [None, ""])[1],
                        "cloudUserId": r.get("cloud_user_id") or "",
                        "presence": (
                            (db.get_cached_presence(r.get("cloud_user_id")) or {}).get("status")
                            if r.get("cloud_user_id")
                            else "offline"
                        ),
                    }
                    for r in (db.get_leaderboard_for_user(uid) or db.get_leaderboard(50) or [])
                ],
            },
        }
        if path in routes:
            self._send(200, routes[path]())
            return
        if path == "/api/update/check":
            # C07: live check verbose — bedakan 'terbaru' vs 'gagal cek' (dulu
            # error ikut dilaporkan latest=True sehingga user terkecoh).
            try:
                import updater
                st = updater.check_update_status()
                self._send(200, {"ok": True, "update": st.get("update"),
                                 "latest": st.get("update") is None and not st.get("error"),
                                 "error": st.get("error"),
                                 "version": getattr(updater, "APP_VERSION", "?")})
            except Exception as e:
                self._send(200, {"ok": False, "update": None, "latest": False,
                                 "error": str(e) or "update_check_failed"})
            return
        if path == "/api/update/status":
            # C07: poll progres unduh latar (lihat POST /api/update/download).
            try:
                import updater
                self._send(200, {"ok": True, "status": updater.download_status()})
            except Exception as e:
                self._send(200, {"ok": False, "error": str(e) or "update_status_failed"})
            return
        if path == "/api/clock":
            # C08: jam server ringan (koreksi drift tanpa bootstrap).
            self._send(200, {"ok": True, "serverNow": _server_now()})
            return
        if path == "/api/year-wrapped":
            # A13: laporan tahunan Wrapped. `?year=2025` memilih tahun lain
            # (default: tahun berjalan). Angka ekonomi tetap IDR mentah — konversi
            # ke mata uang aktif user WAJIB lewat satu-satunya formatter resmi
            # (web/src/utils/currency.ts) agar tidak ada "Rp" hardcoded di UI.
            try:
                tahun = int((qs.get("year") or [0])[0] or 0) or None
            except (TypeError, ValueError):
                tahun = None
            if tahun is not None and (tahun < 1970 or tahun > 2999):
                tahun = None
            try:
                wrapped = db.get_year_wrapped(uid, tahun)
            except Exception as exc:
                self._send(200, {"ok": False, "msg": str(exc)})
                return
            if wrapped is None:
                self._send(200, {"ok": False, "msg": "year_wrapped_unavailable"})
                return
            # Bahasa user dipakai server untuk label hari istimewa dsb. — tidak
            # ada di sini; Wrapped sepenuhnya di-i18n di klien.
            self._send(200, {"ok": True, "wrapped": wrapped,
                             "years": db.get_wrapped_years(uid)})
            return

        if path == "/api/holidays":
            year = int((qs.get("year") or [0])[0] or 0) or None
            try:
                import holidays as hol
                from datetime import datetime as _dt
                y = year or _dt.now().year
                data = hol.get_holidays_for_year(y) or {}
            except Exception:
                data = {}
                y = year or 0
            items = []
            for ds, names in data.items():
                if isinstance(names, (list, tuple)) and len(names) >= 2:
                    nid, nen = names[0], names[1]
                else:
                    nid = nen = str(names)
                items.append({"date": ds, "nameId": nid, "nameEn": nen, "type": "national"})
            self._send(200, {"ok": True, "year": y, "holidays": items})
            return
        # Serve a Love Space photo image (BLOB) to the browser <img>. Visibility
        # (owner / shared-with-couple) is enforced inside get_love_space_photo.
        if path == "/api/love/photo/image":
            pid = (qs.get("id") or [None])[0]
            if not pid:
                self._send(400, {"ok": False, "error": "id"})
                return
            try:
                ph = db.get_love_space_photo(uid, int(pid))
            except (ValueError, TypeError):
                ph = None
            if not ph:
                self._send(404, {"ok": False, "error": "not_found"})
                return
            blob = ph.get("image_data")
            mime = (ph.get("mime_type") or "image/jpeg").split(";")[0].strip()
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Length", str(len(blob)))
            self.send_header("Cache-Control", "private, max-age=3600")
            self.end_headers()
            self.wfile.write(blob)
            return

        if path == "/api/music/playlist-icon/image":
            # P59: serve icon playlist (owner-only; file di playlist_icons/<uid>/).
            try:
                icon_id = int((qs.get("id") or ["0"])[0])
            except (TypeError, ValueError):
                icon_id = 0
            row = None
            if icon_id:
                try:
                    row = db.get_playlist_icon(uid, icon_id)
                except Exception:
                    row = None
            if not row or not row.get("storage_path") or not os.path.isfile(row["storage_path"]):
                self._send(404, {"ok": False, "error": "not_found"})
                return
            with open(row["storage_path"], "rb") as f:
                blob = f.read()
            mime = (row.get("mime") or "image/jpeg").split(";")[0].strip()
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Length", str(len(blob)))
            self.send_header("Cache-Control", "private, max-age=300")
            self.end_headers()
            self.wfile.write(blob)
            return

        if path == "/api/profile/photo":
            try:
                ph = db.get_profile_photo(uid)
            except Exception:
                ph = None
            if not ph or not ph.get("image_data"):
                self._send(404, {"ok": False, "error": "not_found"})
                return
            blob = ph["image_data"]
            mime = (ph.get("mime_type") or "image/jpeg").split(";")[0].strip()
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Length", str(len(blob)))
            self.send_header("Cache-Control", "private, max-age=300")
            self.end_headers()
            self.wfile.write(blob)
            return

        # C02 — serve berkas asli sumber Learning (owner only, folder kelolaan saja).
        if path.startswith("/api/learning/sources/") and path.endswith("/file"):
            try:
                sid = int(path.split("/")[4])
            except (TypeError, ValueError, IndexError):
                sid = 0
            src = db.get_learning_source(sid, uid) if sid else None
            fp = (src.get("file_path") or "") if src else ""
            if not src or not fp or not db.is_managed_source_file(fp) or not os.path.isfile(fp):
                self._send(404, {"ok": False, "error": "not_found"})
                return
            try:
                with open(fp, "rb") as f:
                    raw = f.read()
            except Exception:
                self._send(404, {"ok": False, "error": "file_missing"})
                return
            import mimetypes as _mt
            fname = (src.get("file_name") or os.path.basename(fp) or "source").split("/")[-1]
            mime = (src.get("mime_type") or _mt.guess_type(fp)[0]
                    or "application/octet-stream").split(";")[0].strip()
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Length", str(len(raw)))
            self.send_header("Content-Disposition", f'attachment; filename="{fname}"')
            self.send_header("Cache-Control", "private, max-age=3600")
            self.end_headers()
            self.wfile.write(raw)
            return

        # P54 — serve file lampiran note (owner only).
        if path == "/api/notes/attachment/file":
            try:
                att_id = int(parse_qs(urlparse(self.path).query).get("id", ["0"])[0])
            except (TypeError, ValueError):
                att_id = 0
            att = db.get_note_attachment(uid, att_id) if att_id else None
            if not att:
                self._send(404, {"ok": False, "error": "not_found"})
                return
            try:
                with open(att["storage_path"], "rb") as f:
                    raw = f.read()
            except Exception:
                self._send(404, {"ok": False, "error": "file_missing"})
                return
            fname = (att.get("file_name") or "attachment").split("/")[-1]
            mime = (att.get("mime") or "application/octet-stream").split(";")[0].strip()
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Length", str(len(raw)))
            self.send_header("Content-Disposition", f'inline; filename="{fname}"')
            self.send_header("Cache-Control", "private, max-age=3600")
            self.end_headers()
            self.wfile.write(raw)
            return

        # P44 — download attachment chat (parity ChatDialog._download_selected_attachment).
        dm = re.match(r"^/api/friends/attachments/(\d+)/download$", path)
        if dm:
            try:
                att = db.get_chat_attachment(int(dm.group(1)))
            except Exception:
                att = {}
            # Owner check: attachment harus di-cache/di-upload oleh user ini.
            if not att or int(att.get("local_user_id") or 0) != int(uid):
                self._send(404, {"ok": False, "error": "not_found"})
                return
            raw = att.get("file_data")
            if raw is None:
                # Cloud: belum di-cache offline → unduh dari Supabase storage.
                try:
                    from cloud_service import get_cloud_service
                    raw = get_cloud_service().download_chat_attachment(uid, att)
                except Exception:
                    self._send(404, {"ok": False, "error": "chat_attachment_not_cached"})
                    return
            if not raw:
                self._send(404, {"ok": False, "error": "chat_attachment_not_cached"})
                return
            fname = (att.get("original_filename") or "attachment").split("/")[-1]
            mime = (att.get("mime_type") or "application/octet-stream").split(";")[0].strip()
            self.send_response(200)
            self._cors()
            self.send_header("Content-Type", mime)
            self.send_header("Content-Disposition", f'attachment; filename="{fname}"')
            self.send_header("Content-Length", str(len(raw)))
            self.end_headers()
            self.wfile.write(raw)
            return

        extra = life_api.handle_get(path, uid, qs)
        if extra is not None:
            # Marker unduhan binary (parity ekspor PyQt): dict {"__file_bytes__": bytes}
            file_bytes = extra.get("__file_bytes__") if isinstance(extra, dict) else None
            if file_bytes is not None:
                fname = extra.get("name") or "export.bin"
                mime = extra.get("mime") or "application/octet-stream"
                self.send_response(200)
                self._cors()
                self.send_header("Content-Type", mime)
                self.send_header("Content-Disposition", f'attachment; filename="{fname.split("/")[-1]}"')
                self.send_header("Content-Length", str(len(file_bytes)))
                self.end_headers()
                self.wfile.write(file_bytes)
                return
            self._send(200, extra)
            return
        extra = studio_api.handle_get(path, uid, qs)
        if extra is not None:
            # A03: unduhan berkas dari studio_api (template/ekspor lirik) memakai
            # marker yang sama dengan life_api: {"__file_bytes__": bytes, ...}.
            file_bytes = extra.get("__file_bytes__") if isinstance(extra, dict) else None
            if file_bytes is not None:
                fname = extra.get("name") or "export.txt"
                mime = extra.get("mime") or "application/octet-stream"
                self.send_response(200)
                self._cors()
                self.send_header("Content-Type", mime + "; charset=utf-8")
                self.send_header("Content-Disposition", f'attachment; filename="{fname.split("/")[-1]}"')
                self.send_header("Content-Length", str(len(file_bytes)))
                self.end_headers()
                self.wfile.write(file_bytes)
                return
            self._send(200, extra)
            return
        if path.startswith("/api/cloud"):
            try:
                import cloud_api
                extra = cloud_api.handle_get(path, uid)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            if extra is not None:
                code = 200 if extra.get("ok", True) else 400
                self._send(code, extra)
                return

        if path == "/api/tracker/export":
            try:
                data = db.export_tracker_data(uid)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, {"ok": True, "tracker": data})
            return
        if path == "/api/update/check":
            info = {"ok": True, "current": None, "update": None}
            try:
                import updater
                info["current"] = getattr(updater, "APP_VERSION", None)
                info["update"] = updater.check_for_update()
            except Exception as e:
                info["error"] = str(e)
            self._send(200, info)
            return

        if path == "/api/bootstrap":
            snap = _snapshot(uid)
            snap["ok"] = True
            snap["shop"] = _shop_catalog()
            snap["petCatalog"] = _pet_catalog()
            snap["bossCatalog"] = _boss_catalog()
            snap["recipes"] = _recipe_catalog()
            snap["serverNow"] = _server_now()
            snap["serverDate"] = _server_now()["date"]
            snap["updateCheck"] = _update_cached_info()
            self._send(200, snap)
            return

        self._serve_static(path)

    def do_POST(self):
        parsed = urlparse(self.path)
        path = parsed.path.rstrip("/")
        length = int(self.headers.get("Content-Length") or 0)
        raw = self.rfile.read(length) if length else b"{}"
        try:
            body = json.loads(raw.decode("utf-8") or "{}")
        except json.JSONDecodeError:
            body = {}

        if path == "/api/auth/reset":
            username = (body.get("username") or "").strip()
            new_pw = body.get("password") or body.get("newPassword") or ""
            # P24: metode recovery parity PyQt — "security" (pertanyaan keamanan)
            # atau "backup" (kode cadangan).
            method = (body.get("method") or "backup").lower()
            try:
                conn = db.get_conn()
                row = conn.execute("SELECT id FROM users WHERE username=?", (username,)).fetchone()
                conn.close()
                if not row:
                    self._send(400, {"ok": False, "error": "user_not_found"})
                    return
                uid = int(row["id"])
                if method == "security":
                    answer = (body.get("answer") or "").strip()
                    if not db.verify_security_answer(uid, answer):
                        self._send(400, {"ok": False, "error": "invalid_answer"})
                        return
                    result = db.reset_password_by_security(uid, new_pw)
                else:
                    code = (body.get("code") or "").strip()
                    if not db.verify_backup_code(uid, code):
                        self._send(400, {"ok": False, "error": "invalid_code"})
                        return
                    result = db.reset_password_with_backup_code(uid, new_pw)
                self._send(200, {"ok": True, "result": result if isinstance(result, dict) else {"ok": True}})
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
            return
        if path == "/api/system/stage-file":
            # A03.5: UI menitipkan berkas (JSON/txt) agar diunduh sebagai attachment.
            self._send(200, _dl_stage_file(_state.get("user_id"), body))
            return
        if path == "/api/system/open-downloads":
            # A03.5: tombol "Buka folder" setelah ekspor — file explorer pengguna.
            self._send(200, _open_downloads_folder(body))
            return
        if path in ("/api/auth/login", "/api/auth/register"):
            try:
                if path.endswith("register"):
                    result = db.register_user(
                        body.get("username") or "",
                        body.get("password") or "",
                        display_name=body.get("displayName") or "",
                        bio=body.get("bio") or "",
                        avatar_class=body.get("avatarClass") or "warrior",
                    )
                    if result.get("ok"):
                        result = db.login_user(body.get("username") or "", body.get("password") or "")
                else:
                    result = db.login_user(body.get("username") or "", body.get("password") or "")
                if not result.get("ok"):
                    self._send(401, {"ok": False, "error": result.get("msg") or "login_failed", "result": result})
                    return
                user = result.get("user") or {}
                uid = int(user.get("id"))
                token = db.create_session_token(uid)
                configure(uid, token)
                self._send(200, {"ok": True, "token": token, "user": _row_user(db.get_user(uid))})
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
            return

        if path == "/api/profile/rebirth":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                result = db.perform_rebirth(uid)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True}))
            return
        if path == "/api/profile/title":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            key = str(body.get("key") or "")
            try:
                res = db.set_title(uid, key)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            if not res.get("ok"):
                self._send(400, {"ok": False, "error": "title_locked"})
                return
            self._send(200, _ok_payload(uid, res))
            return
        if path == "/api/profile/photo/remove":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            res = db.remove_profile_photo(uid, uid)
            if not res.get("ok"):
                self._send(400, {"ok": False, "error": res.get("code") or "failed"})
                return
            self._send(200, _ok_payload(uid, res))
            return
        if path == "/api/profile/redeem":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            code = (body.get("code") or "").strip()
            # P24: kode admin (reward_type == "admin") wajib memverifikasi password akun,
            # parity dengan PyQt (MainPyQt6._redeem: prompt password sebelum granting admin).
            # Tanpa ini, siapa pun yang tahu kode admin bisa jadi admin (bypass).
            try:
                conn = db.get_conn()
                row = conn.execute("SELECT reward_type FROM redeem_codes WHERE code=?", (code.upper().strip(),)).fetchone()
                conn.close()
                is_admin_code = bool(row and row["reward_type"] == "admin")
            except Exception:
                is_admin_code = (code == "ADMINADMINADMIN")
            if is_admin_code:
                pwd = body.get("password") or ""
                if not pwd:
                    # P47: server yang meminta password untuk kode bertipe admin APA PUN
                    # (frontend tidak lagi meng-hardcode nama kode admin, jadi kode
                    # admin kustom yang ditambah via add_redeem_code juga terlindungi).
                    self._send(400, {"ok": False, "error": "admin_redeem_password_required"})
                    return
                u = db.get_user(uid) or {}
                try:
                    valid = db._verify_password(pwd, u.get("password_hash", ""))
                except Exception:
                    valid = False
                if not valid:
                    self._send(400, {"ok": False, "error": "admin_redeem_password_wrong"})
                    return
            try:
                result = db.redeem_code(uid, code)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True}))
            return
        if path == "/api/admin/debug":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            u = db.get_user(uid) or {}
            if not u.get("is_admin"):
                self._send(403, {"ok": False, "error": "not_admin"})
                return
            action = str(body.get("action") or "")
            amount = int(body.get("amount") or 0)
            result = None
            if action == "add_xp":
                result = db.gain_xp_gold(uid, amount, 0)
            elif action == "add_gold":
                result = db.gain_xp_gold(uid, 0, amount)
            elif action == "fill_hp_mp":
                db.update_user(uid, hp=u.get("max_hp"), mp=u.get("max_mp"))
                result = {"ok": True, "msg": db.tr_db(user_id=uid, key="debug_hp_mp_restored")}
            elif action == "max_level":
                target = 50
                cur = int(u.get("level") or 1)
                if cur >= target:
                    result = {"ok": True, "msg": db.tr_db(user_id=uid, key="debug_level_already", level=cur)}
                else:
                    need = sum(lvl * 150 for lvl in range(cur, target))
                    db.gain_xp_gold(uid, need, 0)
                    result = {"ok": True, "msg": db.tr_db(user_id=uid, key="debug_level_set", target=target)}
            elif action == "complete_tasks":
                for h in db.get_habits(uid) or []:
                    if not h.get("done_today"):
                        db.complete_habit(uid, h["id"], "up")
                for d in db.get_dailies(uid) or []:
                    if not d.get("done_today"):
                        db.complete_daily(uid, d["id"])
                for t in db.get_todos(uid) or []:
                    if not t.get("done"):
                        db.complete_todo(uid, t["id"])
                result = {"ok": True, "msg": db.tr_db(user_id=uid, key="debug_tasks_done")}
            elif action == "pet_level_up":
                result = db.admin_level_up_all_pets(uid)
            elif action == "pet_add_exp":
                result = db.admin_add_exp_all_pets(uid, max(1, amount))
            elif action == "pet_feed":
                result = db.admin_feed_all_pets(uid)
            else:
                result = {"ok": False, "msg": "unknown_action"}
            self._send(200, _ok_payload(uid, result))
            return
        if path == "/api/tracker/reset":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            pwd = body.get("password") or ""
            u = db.get_user(uid) or {}
            try:
                from database import _verify_password
                valid = _verify_password(pwd, u.get("password_hash", ""))
            except Exception:
                valid = db.login_user(u.get("username", ""), pwd).get("ok", False)
            if not valid:
                self._send(400, {"ok": False, "error": "wrong_password"})
                return
            try:
                db.reset_user_progress(uid)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(uid, {"ok": True}))
            return
        if path == "/api/notes/attachment/delete":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                att_id = int(body.get("id") or 0)
            except (TypeError, ValueError):
                att_id = 0
            att = db.get_note_attachment(uid, att_id) if att_id else None
            if not att:
                self._send(404, {"ok": False, "error": "not_found"})
                return
            try:
                os.remove(att["storage_path"])
            except Exception:
                pass
            result = db.delete_note_attachment(uid, att_id)
            self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True}))
            return
        if path == "/api/upload/file":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                result = _handle_upload_file(uid, body)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            if result.get("ok"):
                self._send(200, _ok_payload(uid, result))
            else:
                self._send(400, {"ok": False, "error": result.get("error") or "upload_failed", "result": result})
            return
        if path == "/api/profile/talent":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                result = db.unlock_talent(uid, body.get("key") or body.get("talentKey") or "")
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True}))
            return
        if path == "/api/dashboard/widgets":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            widgets = body.get("widgets")
            if not isinstance(widgets, list):
                self._send(400, {"ok": False, "error": "widgets_required"})
                return
            try:
                db.set_dashboard_widgets(uid, widgets)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(uid, {"ok": True}))
            return
        if path == "/api/settings/backup":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            # Parity _manual_backup: db.backup_database() → path backup.
            try:
                bpath = db.backup_database()
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(_state.get("user_id"),
                                        {"ok": bool(bpath), "path": bpath or ""}))
            return
        if path == "/api/profile/backup-codes":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                result = db.generate_backup_codes(uid)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, {"ok": True, "result": result})
            return
        if path == "/api/profile/security":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                result = db.set_security_question(uid, body.get("question") or "", body.get("answer") or "")
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, {"ok": True, "result": result})
            return
        if path == "/api/profile/password":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                result = db.change_password(uid, body.get("oldPassword") or "", body.get("newPassword") or body.get("password") or "")
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, {"ok": True, "result": result})
            return
        if path == "/api/profile/lock":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            try:
                if body.get("unlock"):
                    result = db.unlock_account(uid, body.get("password") or "")
                else:
                    result = db.lock_account(uid, body.get("password") or "")
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, {"ok": True, "result": result})
            return
        if path == "/api/profile/class":
            # P24: ganti class harus lewat db.change_class (enforce cooldown +
            # recalc passive buffs). Jangan lewat /api/settings yang tak menegakkan cooldown.
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            cls = str(body.get("class") or body.get("heroClass") or body.get("avatarClass") or "").lower()
            try:
                result = db.change_class(uid, cls)
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            # Terapkan di state/game snapshot juga agar navbar & buff ikut berubah.
            try:
                _state["force_refresh"] = True
            except Exception:
                pass
            self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True}))
            return
        if path == "/api/settings":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            lang = body.get("language") or body.get("lang")
            if lang in ("id", "en"):
                try:
                    db.set_user_language(uid, lang)
                except Exception:
                    pass
            theme = body.get("theme")
            if theme and hasattr(db, "set_user_theme"):
                try:
                    db.set_user_theme(uid, theme)
                except Exception:
                    pass
            kw = {}
            if body.get("displayName") or body.get("name"):
                kw["display_name"] = body.get("displayName") or body.get("name")
            if "bio" in body:
                kw["bio"] = body.get("bio") or ""
            if body.get("avatar") or body.get("avatarEmoji"):
                kw["avatar_emoji"] = body.get("avatar") or body.get("avatarEmoji")
            cls = body.get("heroClass") or body.get("avatarClass")
            if cls and cls.strip():
                # P24: class harus lewat change_class agar cooldown ter-enforce.
                # Jangan tulis avatar_class langsung via update_user (bypass cooldown).
                try:
                    rc = db.change_class(uid, str(cls).lower())
                    if isinstance(rc, dict) and not rc.get("ok", True):
                        pass  # cooldown/unknown → tetap lanjut simpan field lain, class tidak berubah
                except Exception:
                    pass
            if kw:
                try:
                    db.update_user(uid, **kw)
                except Exception:
                    pass
            if "soundEnabled" in body:
                try:
                    db.set_user_settings(uid, sound_enabled=1 if body.get("soundEnabled") else 0)
                except Exception:
                    pass
            cur = body.get("currency")
            if cur:
                try:
                    db.set_user_currency(uid, str(cur).upper())
                except Exception:
                    pass
            if body.get("fontScale") is not None:
                try:
                    db.set_font_scale(uid, int(body.get("fontScale") or 100))
                except Exception:
                    pass
            if "highContrast" in body:
                try:
                    db.set_high_contrast(uid, bool(body.get("highContrast")))
                except Exception:
                    pass
            if body.get("avatarColor"):
                try:
                    db.update_user(uid, avatar_color=body.get("avatarColor"))
                except Exception:
                    pass
            if "onboardingDone" in body:
                try:
                    if body.get("onboardingDone"):
                        db.mark_onboarding_done(uid)
                except Exception:
                    pass
            self._send(200, _ok_payload(uid, {"ok": True, "user": _row_user(db.get_user(uid))}))
            return

        if path == "/api/tracker/import":
            if not _auth_ok(self):
                self._send(401, {"ok": False, "error": "unauthorized"})
                return
            uid = _state.get("user_id")
            payload = body.get("tracker") or body
            try:
                db.import_tracker_data(uid, payload, preserve_progress=bool(body.get("preserveProgress")))
            except Exception as e:
                self._send(400, {"ok": False, "error": str(e)})
                return
            self._send(200, _ok_payload(uid, {"ok": True}))
            return

        if path == "/api/update/check":
            info = {"ok": True, "current": None, "update": None}
            try:
                import updater
                info["current"] = getattr(updater, "APP_VERSION", None)
                chk = updater.check_for_update()
                info["update"] = chk
            except Exception as e:
                info["error"] = str(e)
            self._send(200, info)
            return
        if path == "/api/update/download":
            # C07: mulai unduh rilis terbaru di background. Server selalu fresh-check
            # sendiri (body diabaikan) agar URL unduh tak bisa dikendalikan klien.
            # Progres: poll GET /api/update/status.
            try:
                import updater
                st = updater.download_status()
                if st.get("state") == "downloading":
                    self._send(200, {"ok": True, "status": st})
                    return
                chk = updater.check_update_status()
                if chk.get("error"):
                    self._send(200, {"ok": False, "error": chk["error"]})
                    return
                info = chk.get("update")
                if not info:
                    self._send(200, {"ok": False, "error": "no_update_available"})
                    return
                self._send(200, {"ok": True, "status": updater.start_download(info)})
            except Exception as e:
                self._send(200, {"ok": False, "error": str(e) or "update_download_failed"})
            return
        if path == "/api/update/apply":
            # C07: terapkan zip yang sudah ready (staging + restart).
            # Merespons dulu, lalu keluar agar updater batch bisa ganti file.
            try:
                import updater
                from pathlib import Path as _P
                st = updater.download_status()
                zp = _P(st.get("zip") or "")
                if st.get("state") != "ready" or not zp.is_file():
                    self._send(200, {"ok": False, "error": "update_not_ready"})
                    return
                updater.apply_downloaded(zp, st.get("version") or "")
                updater.reset_download()
                self._send(200, {"ok": True, "applied": True,
                                 "version": st.get("version") or ""})
            except Exception as e:
                try:
                    self._send(200, {"ok": False, "error": str(e) or "update_apply_failed"})
                except Exception:
                    pass
                return
            threading.Timer(2.0, lambda: os._exit(0)).start()
            return

        if not _auth_ok(self):
            self._send(401, {"ok": False, "error": "unauthorized"})
            return
        uid = _state.get("user_id")
        parts = [p for p in path.split("/") if p]

        def fail(e):
            self._send(400, {"ok": False, "error": str(e)})

        try:
            # tasks reorder (drag & drop) — one call handles reorder-in-folder + move across folders
            if path == "/api/tasks/rollover":
                # C08: rollover tengah malam — reset harian + task segar (ringan).
                self._send(200, _tasks_rollover(uid))
                return
            if path == "/api/tasks/reorder":
                mode = str(body.get("mode") or "habit")
                items = body.get("items")
                if not isinstance(items, list):
                    self._send(400, {"ok": False, "error": "items_required"})
                    return
                result = db.reorder_tasks(uid, mode, items)
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "reorder_failed", **_snapshot(uid)})
                    return
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/trash/restore":
                result = db.restore_task_from_trash(uid, body.get("trashId") or body.get("trash_id"))
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "restore_failed", **_snapshot(uid)})
                    return
                self._send(200, _ok_payload(uid, result))
                return

            # habits
            if path == "/api/habits":
                name = (body.get("title") or body.get("name") or "").strip()
                if not name:
                    self._send(400, {"ok": False, "error": "empty"})
                    return
                db.add_habit(
                    uid, name,
                    icon=body.get("icon") or "⚔️",
                    difficulty=body.get("difficulty") or "medium",
                    positive=1 if body.get("isPositive", True) else 0,
                    negative=1 if body.get("isNegative") else 0,
                    notes=body.get("notes") or "",
                )
                fid = body.get("folderId") or body.get("folder_id")
                if fid not in (None, "", "null"):
                    try:
                        conn = db.get_conn()
                        row = conn.execute(
                            "SELECT id FROM habits WHERE user_id=? ORDER BY id DESC LIMIT 1", (uid,)
                        ).fetchone()
                        conn.close()
                        if row:
                            db.update_habit(int(row["id"]), uid, folder_id=int(fid))
                    except Exception:
                        pass
                self._send(200, _ok_payload(uid))
                return
            if len(parts) >= 4 and parts[1] == "habits":
                hid = int(parts[2])
                action = parts[3]
                if action == "complete":
                    direction = "up" if body.get("positive", True) else "down"
                    result = db.complete_habit(uid, hid, direction=direction)
                    self._send(200, _ok_payload(uid, result))
                    return
                if action == "delete":
                    result = db.delete_habit(uid, hid)
                    self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True, "trash_id": None}))
                    return
                if action == "duplicate":
                    result = db.duplicate_habit(uid, hid)
                    self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {}))
                    return
                if action == "update":
                    kw = {}
                    if body.get("title") or body.get("name"):
                        kw["name"] = body.get("title") or body.get("name")
                    if body.get("difficulty"):
                        kw["difficulty"] = body.get("difficulty")
                    if body.get("icon"):
                        kw["icon"] = body.get("icon")
                    if "notes" in body:
                        kw["notes"] = body.get("notes") or ""
                    if "isPositive" in body:
                        kw["positive"] = 1 if body.get("isPositive") else 0
                    if "isNegative" in body:
                        kw["negative"] = 1 if body.get("isNegative") else 0
                    if "folderId" in body or "folder_id" in body:
                        fid = body.get("folderId") if "folderId" in body else body.get("folder_id")
                        kw["folder_id"] = int(fid) if fid not in (None, "", "null") else None
                    db.update_habit(hid, uid, **kw)
                    self._send(200, _ok_payload(uid))
                    return

            if path == "/api/dailies":
                name = (body.get("title") or body.get("name") or "").strip()
                if not name:
                    self._send(400, {"ok": False, "error": "empty"})
                    return
                days = body.get("repeatDays") or []
                repeat = _repeat_to_db(days)
                db.add_daily(
                    uid, name,
                    icon=body.get("icon") or "📅",
                    difficulty=body.get("difficulty") or "medium",
                    notes=body.get("notes") or "",
                    repeat_days=repeat,
                )
                fid = body.get("folderId") or body.get("folder_id")
                if fid not in (None, "", "null"):
                    try:
                        conn = db.get_conn()
                        row = conn.execute(
                            "SELECT id FROM dailies WHERE user_id=? ORDER BY id DESC LIMIT 1", (uid,)
                        ).fetchone()
                        conn.close()
                        if row:
                            db.set_item_folder(uid, "daily", int(row["id"]), int(fid))
                    except Exception:
                        pass
                self._send(200, _ok_payload(uid))
                return
            if len(parts) >= 4 and parts[1] == "dailies":
                did = int(parts[2])
                action = parts[3]
                if action == "complete":
                    result = db.complete_daily(uid, did)
                    self._send(200, _ok_payload(uid, result))
                    return
                if action == "fail":
                    result = db.fail_daily(uid, did)
                    self._send(200, _ok_payload(uid, result))
                    return
                if action == "freeze":
                    result = db.add_freeze_to_daily(uid, did)
                    self._send(200, _ok_payload(uid, result))
                    return
                if action == "delete":
                    result = db.delete_daily(uid, did)
                    self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True, "trash_id": None}))
                    return
                if action == "duplicate":
                    result = db.duplicate_daily(uid, did)
                    self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {}))
                    return
                if action == "update":
                    kw = {}
                    if body.get("title") or body.get("name"):
                        kw["name"] = body.get("title") or body.get("name")
                    if body.get("difficulty"):
                        kw["difficulty"] = body.get("difficulty")
                    if "notes" in body:
                        kw["notes"] = body.get("notes") or ""
                    if body.get("repeatDays") is not None:
                        days = body.get("repeatDays") or []
                        kw["repeat_days"] = _repeat_to_db(days)
                    if "folderId" in body or "folder_id" in body:
                        fid = body.get("folderId") if "folderId" in body else body.get("folder_id")
                        kw["folder_id"] = int(fid) if fid not in (None, "", "null") else None
                    db.update_daily(did, uid, **kw)
                    self._send(200, _ok_payload(uid))
                    return

            if path == "/api/todos":
                name = (body.get("title") or body.get("name") or "").strip()
                if not name:
                    self._send(400, {"ok": False, "error": "empty"})
                    return
                db.add_todo(
                    uid, name,
                    priority=body.get("difficulty") or "medium",
                    icon=body.get("icon") or "📜",
                    due_date=body.get("dueDate"),
                    notes=body.get("notes") or "",
                )
                fid = body.get("folderId") or body.get("folder_id")
                if fid not in (None, "", "null"):
                    try:
                        conn = db.get_conn()
                        row = conn.execute(
                            "SELECT id FROM todos WHERE user_id=? ORDER BY id DESC LIMIT 1", (uid,)
                        ).fetchone()
                        conn.close()
                        if row:
                            db.update_todo(int(row["id"]), uid, folder_id=int(fid))
                    except Exception:
                        pass
                self._send(200, _ok_payload(uid))
                return
            if len(parts) >= 4 and parts[1] == "todos":
                tid = int(parts[2])
                action = parts[3]
                if action == "complete":
                    result = db.complete_todo(uid, tid)
                    self._send(200, _ok_payload(uid, result))
                    return
                if action == "delete":
                    result = db.delete_todo(uid, tid)
                    self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True, "trash_id": None}))
                    return
                if action == "duplicate":
                    result = db.duplicate_todo(uid, tid)
                    self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {}))
                    return
                if action == "update":
                    kw = {}
                    if body.get("title") or body.get("name"):
                        kw["name"] = body.get("title") or body.get("name")
                    if body.get("difficulty") or body.get("priority"):
                        kw["priority"] = body.get("difficulty") or body.get("priority")
                    if body.get("icon"):
                        kw["icon"] = body.get("icon")
                    if "notes" in body:
                        kw["notes"] = body.get("notes") or ""
                    if "dueDate" in body:
                        kw["due_date"] = body.get("dueDate") or None
                    if "folderId" in body or "folder_id" in body:
                        fid = body.get("folderId") if "folderId" in body else body.get("folder_id")
                        kw["folder_id"] = int(fid) if fid not in (None, "", "null") else None
                    db.update_todo(tid, uid, **kw)
                    self._send(200, _ok_payload(uid))
                    return

            if path == "/api/shop/buy":
                item_id = body.get("itemId") or body.get("item_id")
                qty = int(body.get("quantity") or 1)
                # Offline-first: jalankan lokal SELALU dulu. db.buy_item meng-debit gold,
                # menambah inventory, dan sudah `_queue_cloud_econ` (sync best-effort via
                # background sync_now). Kegagalan cloud (JWT/PGRST303) TIDAK memblokir sukses lokal.
                result = db.buy_item(uid, item_id)
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "buy_failed", **_snapshot(uid)})
                    return
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/shop/sell":
                item_id = body.get("itemId") or body.get("item_id")
                row_id = body.get("rowId")
                if not row_id:
                    for r in db.get_inventory(uid):
                        if r.get("item_id") == item_id:
                            row_id = r.get("id")
                            break
                result = db.sell_item(uid, row_id, quantity=int(body.get("quantity") or 1))
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/shop/use":
                result = db.use_item(uid, body.get("itemId") or body.get("item_id"))
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/shop/equip":
                item_id = body.get("itemId") or body.get("item_id")
                equipped = bool(body.get("equipped", True))
                # Offline-first: equip lokal SELALU dulu (local DB = source of truth).
                result = _equip_item(uid, item_id, equipped)
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "equip_failed", **_snapshot(uid)})
                    return
                # Best-effort cloud sync (background) — TIDAK memblokir respons sukses lokal.
                try:
                    import cloud_api
                    if cloud_api.is_shop_cloud(uid):
                        _best_effort_cloud(lambda: cloud_api.shop_cloud_equip(uid, item_id, equipped))
                except Exception:
                    pass
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/shop/craft":
                rid = body.get("recipeId") or body.get("resultItemId")
                # Offline-first: craft lokal SELALU dulu. db.craft_item sudah _queue_cloud_econ.
                result = db.craft_item(uid, rid)
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "craft_failed", **_snapshot(uid)})
                    return
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/shop/enchant":
                item_id = body.get("itemId") or body.get("item_id")
                # Offline-first: enchant lokal SELALU dulu. db.enchant_item sudah _queue_cloud_econ.
                result = db.enchant_item(uid, item_id)
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "enchant_failed", **_snapshot(uid)})
                    return
                self._send(200, _ok_payload(uid, result))
                return

            if path == "/api/pets/adopt":
                result = db.adopt_pet(uid, body.get("petId"))
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/pets/feed":
                result = db.feed_pet(uid, body.get("petId"))
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/pets/train":
                result = db.train_pet(uid, body.get("petId"))
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/pets/equip":
                result = db.equip_pet(uid, body.get("petId"))
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/pets/unequip":
                result = db.unequip_pet(uid, body.get("petId"))
                self._send(200, _ok_payload(uid, result))
                return

            if path == "/api/boss/start":
                u = db.get_user(uid)
                gid = u.get("guild_id") or 0
                result = db.start_boss(gid, body.get("bossId"), u)
                self._send(200, _ok_payload(uid, result, extra={"activeBossId": body.get("bossId")}))
                return
            if path == "/api/boss/attack":
                u = db.get_user(uid)
                gid = u.get("guild_id") or 0
                action = body.get("action") or "light"
                result = db.attack_boss(uid, gid, action=action)
                self._send(200, _ok_payload(uid, result))
                return
            if path == "/api/boss/flee":
                self._send(200, _ok_payload(uid, {"ok": True, "fled": True}))
                return
            if path == "/api/skill/use":
                result = db.use_class_skill(uid)
                if not result.get("ok"):
                    self._send(400, {"ok": False, "error": result.get("msg") or "skill_failed", **_snapshot(uid)})
                    return
                self._send(200, _ok_payload(uid, result))
                return

            if len(parts) >= 4 and parts[1] == "achievements" and parts[3] == "claim":
                aid = parts[2]
                try:
                    aid_int = int(aid)
                except ValueError:
                    aid_int = aid
                result = db.claim_achievement_reward(uid, aid_int)
                self._send(200, _ok_payload(uid, result))
                return

            life = life_api.handle_post(path, uid, body, parts)
            if life is not None:
                if life.get("skip_snap"):
                    self._send(200, {"ok": True, "result": life.get("result")})
                    return
                self._send(200, _ok_payload(uid, life.get("result")))
                return
            studio = studio_api.handle_post(path, uid, body, parts)
            if studio is not None:
                if studio.get("skip_snap"):
                    payload = {"ok": True, "result": studio.get("result")}
                    if isinstance(studio.get("result"), dict):
                        payload.update(studio.get("result"))
                    self._send(200, payload)
                    return
                self._send(200, _ok_payload(uid, studio.get("result")))
                return
            if path == "/api/admin/debug":
                u = db.get_user(uid) or {}
                if not u.get("is_admin"):
                    self._send(403, {"ok": False, "error": "forbidden"})
                    return
                action = body.get("action") or ""
                result = {"ok": True}
                if action == "xp":
                    result = db.gain_xp_gold(uid, int(body.get("amount") or 0), 0)
                elif action == "gold":
                    result = db.gain_xp_gold(uid, 0, int(body.get("amount") or 0))
                elif action == "fill":
                    db.update_user(uid, hp=u.get("max_hp"), mp=u.get("max_mp"))
                elif action == "maxLevel":
                    target = 50
                    needed = 0
                    for lvl in range(int(u.get("level") or 1), target):
                        needed += lvl * 150
                    result = db.gain_xp_gold(uid, needed, 0)
                elif action == "completeTasks":
                    for h in db.get_habits(uid):
                        if not h.get("done_today"):
                            db.complete_habit(uid, h["id"], "up")
                    for d in db.get_dailies(uid):
                        if not d.get("done_today"):
                            db.complete_daily(uid, d["id"])
                    for t in db.get_todos(uid):
                        if not t.get("done"):
                            db.complete_todo(uid, t["id"])
                elif action == "petLevel":
                    result = db.admin_level_up_all_pets(uid)
                elif action == "petExp":
                    result = db.admin_add_exp_all_pets(uid, int(body.get("amount") or 100)) if hasattr(db, "admin_add_exp_all_pets") else {"ok": False}
                elif action == "feedPets":
                    result = db.admin_feed_all_pets(uid) if hasattr(db, "admin_feed_all_pets") else {"ok": False}
                self._send(200, _ok_payload(uid, result if isinstance(result, dict) else {"ok": True}))
                return
            if path.startswith("/api/cloud"):
                import cloud_api
                extra = cloud_api.handle_post(path, uid, body)
                if extra is not None:
                    code = 200 if extra.get("ok", True) else 400
                    self._send(code, extra)
                    return
        except Exception as e:
            fail(e)
            return

        self._send(404, {"ok": False, "error": "not_found"})

    def _serve_audio(self, file_path: str, extra_roots=None):
        """Serve a local audio file with HTTP Range support (for <audio> seek).

        Only files inside the CraftLife Music library dir (+ `extra_roots` yang
        eksplisit, mis. `learning_audio` untuk podcast A08) yang bisa diakses;
        tidak ada berkas yang diunggah ke internet — semuanya tetap lokal.
        """
        import mimetypes
        from http import HTTPStatus
        roots = []
        try:
            import music_downloader as md
            roots.append(os.path.realpath(md.get_download_dir()))
        except Exception:
            pass
        for extra in (extra_roots or []):
            try:
                if extra:
                    roots.append(os.path.realpath(extra))
            except Exception:
                continue
        if not roots:
            self._send(404, {"ok": False, "error": "no_music_dir"})
            return
        if not file_path:
            self._send(404, {"ok": False, "error": "bad_path"})
            return
        real = os.path.realpath(file_path)
        if not any(real.startswith(root + os.sep) for root in roots):
            self._send(403, {"ok": False, "error": "forbidden"})
            return
        if not os.path.isfile(real):
            self._send(404, {"ok": False, "error": "not_found"})
            return
        size = os.path.getsize(real)
        ctype = mimetypes.guess_type(real)[0] or "audio/mpeg"
        rng = self.headers.get("Range")
        start = 0
        end = size - 1
        if rng:
            try:
                spec = rng.replace("bytes=", "").strip()
                if "-" in spec:
                    a, b = spec.split("-", 1)
                    start = int(a) if a else 0
                    end = (int(b) if b else end)
                else:
                    start = int(spec)
            except (ValueError, IndexError):
                start = 0
                end = size - 1
            start = max(0, min(start, size - 1))
            end = max(start, min(end, size - 1))
        length = end - start + 1
        self.send_response(206 if rng else 200)
        self._cors()
        self.send_header("Content-Type", ctype)
        self.send_header("Accept-Ranges", "bytes")
        self.send_header("Content-Length", str(length))
        if rng:
            self.send_header("Content-Range", f"bytes {start}-{end}/{size}")
        self.end_headers()
        try:
            with open(real, "rb") as f:
                f.seek(start)
                remaining = length
                while remaining > 0:
                    chunk = f.read(min(65536, remaining))
                    if not chunk:
                        break
                    self.wfile.write(chunk)
                    remaining -= len(chunk)
        except (BrokenPipeError, ConnectionResetError):
            pass

    def _serve_static(self, path: str):
        try:
            from web_shell import web_dist_candidates
            cands = web_dist_candidates()
        except Exception:
            here = os.path.dirname(os.path.abspath(__file__))
            cands = [
                os.path.join(here, "web", "dist"),
                os.path.join(os.path.dirname(here), "web", "dist"),
            ]
            meipass = getattr(__import__("sys"), "_MEIPASS", None)
            if meipass:
                cands.insert(0, os.path.join(meipass, "web", "dist"))
        root = next((c for c in cands if os.path.isdir(c)), cands[-1])
        if not os.path.isdir(root) or not os.path.isfile(os.path.join(root, "index.html")):
            html = (
                "<!DOCTYPE html><html><head><meta charset='utf-8'><title>CraftLife</title></head>"
                "<body style='font-family:Segoe UI,sans-serif;background:#0f172a;color:#e2e8f0;padding:48px'>"
                "<h1>UI React belum di-build</h1>"
                "<p>Folder <code>web/dist</code> kosong. API di port ini hidup, tapi tidak ada index.html.</p>"
                "<ol>"
                "<li>Buka PowerShell di folder <code>web</code></li>"
                "<li><code>npm install</code></li>"
                "<li><code>npm run build</code></li>"
                "<li>Jalankan ulang CraftLife</li>"
                "</ol>"
                "<p>Jangan pakai <code>npm run dev</code> untuk jendela exe — WebEngine memuat "
                "<code>http://127.0.0.1:8765/</code>.</p>"
                "</body></html>"
            ).encode("utf-8")
            self._send(200, html, "text/html")
            return
        if path in ("/", "", "/index.html"):
            rel = "index.html"
        else:
            rel = path.lstrip("/")
        full = os.path.normpath(os.path.join(root, rel))
        if not full.startswith(os.path.normpath(root)):
            self._send(403, {"ok": False})
            return
        if not os.path.isfile(full):
            full = os.path.join(root, "index.html")
        lower = full.lower()
        ctype = "text/html"
        if lower.endswith(".js") or lower.endswith(".mjs"):
            ctype = "application/javascript"
        elif lower.endswith(".css"):
            ctype = "text/css"
        elif lower.endswith(".ico"):
            ctype = "image/x-icon"
        elif lower.endswith(".png"):
            ctype = "image/png"
        elif lower.endswith(".jpg") or lower.endswith(".jpeg"):
            ctype = "image/jpeg"
        elif lower.endswith(".webp"):
            ctype = "image/webp"
        elif lower.endswith(".svg"):
            ctype = "image/svg+xml"
        elif lower.endswith(".woff"):
            ctype = "font/woff"
        elif lower.endswith(".woff2"):
            ctype = "font/woff2"
        elif lower.endswith(".json"):
            ctype = "application/json"
        elif lower.endswith(".map"):
            ctype = "application/json"
        with open(full, "rb") as f:
            data = f.read()
        self._send(200, data, ctype)


_httpd = None


def start_server(host="127.0.0.1", port=8765):
    global _httpd
    if _httpd is not None:
        return _httpd, f"http://{host}:{port}"
    # C07: hangatkan cache update di background (bootstrap tidak block).
    try:
        _update_cached_info()
    except Exception:
        pass
    last_err = None
    for candidate in range(int(port), int(port) + 8):
        try:
            httpd = ThreadingHTTPServer((host, candidate), Handler)
            t = threading.Thread(target=httpd.serve_forever, daemon=True)
            t.start()
            _httpd = httpd
            # C06: checkpoint WAL berkala juga saat jalan sebagai server
            # (sebelumnya hanya desktop yang menyalakannya → WAL membengkak).
            try:
                db.start_periodic_checkpoint()
            except Exception:
                pass
            if candidate != int(port):
                os.environ["CRAFTLIFE_API_PORT"] = str(candidate)
            print(f"CraftLife API http://{host}:{candidate}", flush=True)
            return httpd, f"http://{host}:{candidate}"
        except OSError as exc:
            last_err = exc
            continue
    print(f"CraftLife API gagal bind {host}:{port}: {last_err}", flush=True)
    raise last_err or OSError("api_bind_failed")


if __name__ == "__main__":
    db.init_db()
    _ensure_user()
    host = os.environ.get("CRAFTLIFE_API_HOST", "127.0.0.1")
    port = int(os.environ.get("CRAFTLIFE_API_PORT", "8765"))
    start_server(host, port)
    print(f"CraftLife API http://{host}:{port} user_id={_state.get('user_id')}", flush=True)
    try:
        threading.Event().wait()
    except KeyboardInterrupt:
        pass