Has anyone developed a command line script to download the xml for OCMods?

Code: Select all

#!/bin/bash

CURRENT_DIR=$(pwd)

# Prompt user for the db info
read -p "Enter the user: " user
read -p "Enter the password: " password
read -p "Enter the database name: " db

# Database credentials
DB_HOST="localhost"
DB_USER=$user
DB_PASS=$password
DB_NAME=$db

# Output directory for XML file
OUTPUT_DIR="$CURRENT_DIR/ocmodxml_downloads"
mkdir -p "$OUTPUT_DIR"

# Prompt user for the code
read -p "Enter the modification code to download its XML: " CODE

# Check if code is provided
if [ -z "$CODE" ]; then
    echo "Error: No code provided. Exiting."
    exit 1
fi

# Query to get xml for the specific code
QUERY="SELECT xml FROM modification WHERE code = '$CODE';"

# Execute query and save the result
XML_CONTENT=$(mysql -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -N -e "$QUERY")

# Check if anything was returned
if [ -z "$XML_CONTENT" ]; then
    echo "No XML found for code: $CODE"
    exit 1
else
    # Save XML to a file named after the code
    echo -e "$XML_CONTENT" > "$OUTPUT_DIR/${CODE}.xml"
    echo "XML downloaded to $OUTPUT_DIR/${CODE}.xml"
fi

echo "Done!"