360 Secure SkillHub
360 安全技能中心

Pursuit Maps

这是TrackMania Pursuit地图的自动化数据管道，核心功能为从ManiaPlanet Feedback抓取地图评分、投票数据，结合ManiaExchange的地图详情同步至谷歌表格；支持数据同步、投票更新、表格排序、生成投票变化报告、数据校验等操作，每日自动运行。适用于TrackMania玩家或地图管理者追踪Pursuit地图数据、维护地图清单，通过命令行执行脚本，需部署GAS Web App实现表格写入，输出为更新后的谷歌表格或相关报告文件。

tomekdot
tomekdot
热度 16.02
最近更新 2026-06-12 19:58:51
分类：自动化依赖：代码执行 / 联网浏览搜索 / 第三方 API / 读写文件应用场景：数据处理 / 自动化脚本 / 报告撰写

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add pursuit-maps
Metadata
name
pursuit-maps
description
TrackMania Pursuit maps pipeline — fetches maps from ManiaPlanet Feedback (star ratings, vote counts), enriches with ManiaExchange data, syncs to Google Sheets via GAS Web App. Daily automated pipeline with vote tracking.
version
2.0.0
metadata
{"openclaw":{"tags":["trackmania","pursuit","maniaplanet","maps","thumbnails","gas","google-sheets","pipeline"]}}

Pursuit Maps Pipeline

Automated pipeline: ManiaPlanet Feedback + ManiaExchange → Google Sheets.

Quick Reference

Main script: pipeline/pipeline.py in repo tomekdot/pursuit-maps

python3 pipeline/pipeline.py                    # full pipeline
python3 pipeline/pipeline.py --action sync      # fetch + push new maps + auto-sort
python3 pipeline/pipeline.py --action votes     # update vote columns only
python3 pipeline/pipeline.py --action sort      # sort sheet by Uploaded At
python3 pipeline/pipeline.py --action report    # vote change report
python3 pipeline/pipeline.py --action validate  # data quality checks

GAS Web App: pipeline/gas-webapp/PursuitMaps.gs — deploy once in Sheet (Extensions → Apps Script → Deploy as Web App). Accepts HTTP POST from pipeline.

Repo Structure

pursuit-maps/
├── pipeline/pipeline.py      ← Main entry point (all actions)
├── pipeline/gas_runner.py    ← HTTP client for GAS
├── pipeline/gas-webapp/      ← GAS script (deploy in Sheet)
├── data/                     ← Cache, history, reports
├── docs/                     ← Setup guides
├── scripts/legacy/           ← Old scripts (reference)
└── .github/workflows/pipeline.yml  ← Daily 5:00 UTC

Sheet Columns

Col Name Source
A # Auto
B Map name Feedback
C Author login ManiaExchange
D Environment ManiaExchange
E Uploaded at ManiaExchange (ISO 8601 → normalized to YYYY-MM-DD HH:MM:SS)
F UID Feedback
G TrackMania\MapType ManiaExchange
H Notes Manual
I YN Rating Feedback YES/NO section
J YN Votes Feedback YES/NO section
K 5-Star Avg Feedback 5 STARS section
L 5-Star Total Feedback 5 STARS section

Sorting

Sheet is auto-sorted by Uploaded At (column E) descending after every sync (newest maps on top).

  • Column E is formatted as Date (yyyy-mm-dd hh:mm:ss) so Sheets treats it as proper date
  • Manual sort: python3 pipeline/pipeline.py --action sort or POST {"action":"sort"} to GAS
  • Sort function handles both Date objects and string dates from MX API

Key API Endpoints

  • Feedback page: feedback.prod.live.maniaplanet.com/votes/display/106
  • MX API: tm.mania.exchange/api/maps/get_map_info/id/{UID} (V1, accepts UID)
  • Sheet read: gviz API (no auth for public sheets)
  • Sheet write: GAS Web App (deployed once per user)

Parsing Notes

Feed page has TWO separate star rating sections per map card:

  1. YES/NO section: <h6>YES/NO</h6> → gold span → rating (count)
  2. 5 STARS section: <h6>5 STARS</h6> → gold span → rating (count)

Parse independently. ~80% of maps have 5-Star data but no YES/NO votes.

Split HTML at each <img src="...maps/..."> to isolate per-map cards.

Stats

  • 249 maps total
  • ~75% indexed on ManiaExchange
  • 248 thumbnails available (1 HTTP 403)
  • 4 environments: Valley, Canyon, Stadium, Lagoon
  • 3 map types: PursuitArena (~80%), GoalHuntArena (~15%), HuntersArena (~5%)