Latest Snapshot in Database

Last Pulled At (UTC)
2025-10-31 08:49:36
Nations Cached
193
Cities Cached
5956
Target Infra Used For ROI Calc
3000
Treasure Bonus / Day
$5
Color Bonus / Day
$2,800,000
Alliance summary right now: 193 nations / 5956 cities tracked.
Total Infra: 13,585,467 | Avg Infra: 2,280.97
Bloc bonus assumed: $7,700,000/day (2,800,000 color + 4,900,000 treasure)

Live Pull Status

When you run a full refresh, we log progress like "Pulling nation X / City Y..." into the DB. You’ll see it here. This helps you know it's not frozen.
Status: idle

How to Refresh Alliance Snapshot

Use this on the server. It will:
• pull nations in allowed alliances (Rose + any you added in admin),
• pull all their cities,
• upsert into nations / cities one at a time,
• insert a new row into metadata,
• update status logs so you can watch progress.

It’s heavy, rate-limited by PnW, and can take a while, so it’s safer to run in screen/tmux/cron instead of hammering via browser.
php /var/www/html/calc/calc.php --pull-alliance
# Example:
# screen -S rosepull
# php /var/www/html/calc/calc.php --pull-alliance
# then come back to this page to watch status.