Research of Praetoria Leaderboard for Splinterlands - Including Bash Script to Always Get The Data Yourself

The Battle Mages of Splinterlands have built thousands of Research Huts all over Praetoria and are searching for the Secret of Praetoria. Various ancient ruins have been spotted in all territories and the race to discover their mystery has begun. The lords of Praetoria have even dedicated special titles to those, that lead these efforts. And everyone was wondering, where the most research is being done. At least this secret has now been lifted.

---

I have written, with the help of Splinterlands APIs and ChatGPT, a Bash script that you can run in your own console, to pull the current research rankings from the game.

Below, you will find the top 100 rankings for each territory.

Pristine Northwest - Total Amount: 537233

Broken Lands - Total Amount: 897981

Land of Prosperity - Total Amount: 528229

Central Fire - Total Amount: 1141649

Wild Northeast - Total Amount: 861892

Great Lowlands - Total Amount: 366060

Shimmering Coast - Total Amount: 152919

Script

Create a file in Bash with these three commands:

1. nano richlist_script.sh (copy/paste the script code in there, safe and exit)
2. chmod +x richlist_script.sh
3. ./richlist_script.sh (execute the script, select the territory and wait a moment)

#!/bin/bash

declare -A player_amounts
declare -A player_amounts_regions
total_amount=0

# Function to fetch data for a specific region uid and resource
fetch_data() {
    local region_uid=$1
    local api_url="https://vapi.splinterlands.com/land/resources/richlist?region=PR-${region_code}-${region_uid}&resource=RESEARCH&limit=100"
    local data=$(curl -s "$api_url")

    # Check if data array is empty
    if [ -n "$data" ] && [ "$(echo "$data" | jq -r '.data')" != "[]" ]; then
        echo "$data"
    fi
}

# Prompt for region selection
echo "Select a territory:"
echo "1) PRISTINE NORTHWEST"
echo "2) BROKEN LANDS"
echo "3) LAND OF PROSPERITY"
echo "4) CENTRAL FIRE"
echo "5) WILD NORTHEAST"
echo "6) GREAT LOWLANDS"
echo "7) SHIMMERING COASTS"
read -p "Enter the territory number: " region_number

# Define region code and range based on user input
case $region_number in
    1)
        region_code="PNW"
        region_start=1
        region_end=20
        ;;
    2)
        region_code="BRL"
        region_start=21
        region_end=41
        ;;
    3)
        region_code="LOP"
        region_start=42
        region_end=63
        ;;
    4)
        region_code="CEF"
        region_start=64
        region_end=85
        ;;
    5)
        region_code="WNE"
        region_start=86
        region_end=106
        ;;
    6)
        region_code="GLL"
        region_start=107
        region_end=128
        ;;
    7)
        region_code="SHC"
        region_start=129
        region_end=150
        ;;
    *)
        echo "Invalid region number. Exiting."
        exit 1
        ;;
esac

# Process data for each region uid
for region_uid in $(seq $region_start $region_end); do
    data=$(fetch_data $region_uid)

    if [ -n "$data" ] && [ "$(echo "$data" | jq -r '.status')" == "success" ]; then
        while IFS= read -r line; do
            player=$(echo "$line" | jq -r '.player')
            amount=$(echo "$line" | jq -r '.amount' | cut -f1 -d".")

            total_amount=$(echo "$total_amount + $amount" | bc)

            region_value="PR-${region_code}-${region_uid}"
            if [ -n "${player_amounts["$player"]}" ]; then
                player_amounts["$player"]=$(echo "${player_amounts["$player"]} + $amount" | bc)
                if [ -n "${player_amounts_regions["$player"]}" ]; then
                    player_amounts_regions["$player"]+=" + $region_value"
                else
                    player_amounts_regions["$player"]="$region_value"
                fi
            else
                player_amounts["$player"]=$amount
                player_amounts_regions["$player"]="$region_value"
            fi
        done <<< "$(echo "$data" | jq -c '.data[]')"
    fi
done

# Sort players by amount in descending order
sorted_players=($(for player in "${!player_amounts[@]}"; do
    echo "$player ${player_amounts["$player"]}"
done | sort -k2 -n -r | cut -d' ' -f1))

# Print the result
echo "| Row | Player | Amount | Region UID |"
echo "|-----|--------|--------|------------|"

row=1
for player in "${sorted_players[@]}"; do
    amount="${player_amounts["$player"]}"
    regions="${player_amounts_regions["$player"]}"
    echo "| $row | $player | $amount | $regions |"
    ((row++))
done

# Print total amount
echo -e "\nTotal Research Amount: $total_amount"

---

Cheers!