Function report_edit

Scripts/ButSystem.py:17566–17601

(rid: int)

    try:
        conn = db_connect()
        rows = conn.execute("SELECT username FROM pending_users WHERE status='pending' ORDER BY id ASC").fetchall()
        conn.close()
        for r in rows:
            try:
                PENDING_QUEUE.put_nowait(r["username"])
            except Exception:
                pass
    except Exception:
        pass

def approval_prompt(username: str):
    """Run an interactive approve/deny prompt in the *main thread*.

    Termux/Android terminals can fail to show `input()` prompts reliably when they
    happen inside background threads. This function is meant to be called from
    the main loop so the prompt always appears.
    """
    if not username:
        return
    try:
        conn = db_connect()
        row = conn.execute("""SELECT username, requested_ip, requested_at, status, pw_hash
                              FROM pending_users WHERE username=?""", (username,)).fetchone()
        if not row or row["status"] != "pending":
            conn.close()
            return

        sys.stdout.write("\n")
        sys.stdout.flush()
        prompt = (f"[ButSystem] Signup request: '{row['username']}' from {row['requested_ip']} "
                  f"at {row['requested_at']}  Approve? (y/N): ")
        try:
            ans = input(prompt).strip().lower()
        except EOFError:
            # No TTY / stdin closed.
            ans = ""

        if ans == "y":
            conn.execute("INSERT OR IGNORE INTO users(username, pw_hash, is_admin, created_at) VALUES(?,?,0,?)",