ROOT_DIR="$HOME/public_html/Sites"
BACKUP_DIR="$HOME/public_html/backup"
DATE=$(date +"%Y-%m-%d")
STAGING_DIR="$BACKUP_DIR/staging_$DATE"
ARCHIVE_PATH="$BACKUP_DIR/BACKUP_BDD_MIST7305_PRINCIPAL_$DATE.tar"
PHP_CLI="/usr/local/bin/php"
WP_CLI="/usr/local/bin/wp" 

export PATH=$PATH:/usr/local/bin:/usr/bin:/bin
cd /home/mist7305/public_html/backup
mkdir -p "$STAGING_DIR"

for SITE in "$ROOT_DIR"/*; do
  if [[ -f "$SITE/wp-config.php" ]]; then
    SITE_NAME=$(basename "$SITE")
    SQL_FILE="$STAGING_DIR/${SITE_NAME}_db_$DATE.sql"
    $PHP_CLI $WP_CLI --path="$SITE" db export "$SQL_FILE" --add-drop-table --quiet
    if [[ ! -s "$SQL_FILE" ]]; then
      rm -f "$SQL_FILE"
    fi
  fi
done

if [ -n "$(ls -A "$STAGING_DIR" 2>/dev/null)" ]; then
  tar -cf "$ARCHIVE_PATH" -C "$STAGING_DIR" .
fi

rm -rf "$STAGING_DIR"