Grain Leaderboard for Splinterlands - Including Bash Script to Always Get The Data Yourself

Here is another leaderboard post for the Splinterlands Praetoria Land Expansion. This one will reveal the largest Grain holders of the continent. You will find the top 100 Grain rankings for each territory. And as a bonus, I have added the script code to pull that data yourself at any time from the Splinterlands API.

Did you see my Research Leaderboard already?

	Research of Praetoria Leaderboard for Splinterlands

Pristine Northwest - Total Grain Amount: 75,850,637

Broken Lands - Total Grain Amount: 74,769,637

Land of Prosperity - Total Grain Amount: 70,138,860

Central Fire - Total Grain Amount: 102,710,767

Wild Northeast - Total Grain Amount: 65,749,718

Great Lowlands - Total Grain Amount: 53,585,900

Shimmering Coast - Total Grain Amount: 22,235,245

Script

Create a file in Bash with these three commands:

1. nano richlist_grain.sh (copy/paste the script code in there, safe and exit)
2. chmod +x richlist_grain.sh
3. ./richlist_grain.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=GRAIN&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 Grain Amount: $total_amount"

Bon appetit!

	Research of Praetoria Leaderboard for Splinterlands