USE suremdmdb
INSERT INTO runscript(id_runscript,type_runscript, title_runscript, script_runscript, helptext_runscript, notes_runscript, inputplaceholder_runscript, inputClass_runscript, accordionGrouping_runscript,priority_runscript)--nomigration;
VALUES
('30025','LINUX', 'Agent Update - Latest version', '#!/bin/bash

NIX_DEFAULT_LOCATION="https://suremdm.42gears.com/nix/nix.tar.gz"

if [ "$EUID" -ne 0 ]
  then echo "Permission denied. Please run as root."
  exit 126
fi

DPKG=$(type -p dpkg)

installDPKGs() {
    #For Package integrity check
    REQUIRED_PKG_DEBSUMS="debsums"
    DEBSUMS_PKG_OK=$(dpkg-query -W --showformat=' + CHAR(39) + '${Status}\n' + CHAR(39) + ' $REQUIRED_PKG_DEBSUMS|grep "install ok installed")
    if [ "" = "$DEBSUMS_PKG_OK" ]; then
    apt-get --yes install $REQUIRED_PKG_DEBSUMS
    fi
}

if [ ! -z  $DPKG ]; then
  installDPKGs
fi

if [ ! -f "/usr/share/java/nix/nix.jar" ]; then
    echo "Cannot find existing nix @ /usr/share/java/nix/nix.jar"
    echo "Nothing to upgrade. Exiting..."
    exit 1
fi

rm nix.tar.gz*
rm -rf ./nix

if [ -z "$1" ]; then
    wget $NIX_DEFAULT_LOCATION
else
    wget $1
fi

if [ ! -f "nix.tar.gz" ]; then
    echo "Cannot Download Nix package. Please check your Internet connection or download URL."
    echo "Exiting"
    exit 1
fi

tar -xvzf nix.tar.gz*

# Backup Existing Nix Installation in-case something goes wrong - 
BACKUP_FILE=$HOME"/nix_backup_date_"$(date ' + CHAR(39) + '+%d%b%Y_%H%M%S' + CHAR(39) + ')".tar.gz"
echo "Backing up to $BACKUP_FILE"
tar -zcvf $BACKUP_FILE /usr/share/java/nix/

if [ -f "$BACKUP_FILE" ]; then
    echo "Nix backup location: $BACKUP_FILE"
else
    echo "Could not create backup file $BACKUP_FILE. Exiting..."
    exit 1
fi

SCRIPT_PATH="nix/upgradenixdynamic.sh"

source $SCRIPT_PATH

echo "Upgrade Complete"', '', 'Script to update agent to latest available version.', '', '', 'SureMDM Agent', 0),
('30026','LINUX', 'Agent Update - Specific Version', '#!/bin/bash

NIX_DEFAULT_LOCATION="https://mars.42gears.com/support/inout/nixv%input~text%.tar.gz"
filename=$(basename "$NIX_DEFAULT_LOCATION")

if [ "$EUID" -ne 0 ]
  then echo "Permission denied. Please run as root."
  exit 126
fi

DPKG=$(type -p dpkg)

installDPKGs() {
    #For Package integrity check
    REQUIRED_PKG_DEBSUMS="debsums"
    DEBSUMS_PKG_OK=$(dpkg-query -W --showformat=' + CHAR(39) + '${Status}\n' + CHAR(39) + ' $REQUIRED_PKG_DEBSUMS|grep "install ok installed")
    if [ "" = "$DEBSUMS_PKG_OK" ]; then
    apt-get --yes install $REQUIRED_PKG_DEBSUMS
    fi
}

if [ ! -z  $DPKG ]; then
  installDPKGs
fi

if [ ! -f "/usr/share/java/nix/nix.jar" ]; then
    echo "Cannot find existing nix @ /usr/share/java/nix/nix.jar"
    echo "Nothing to upgrade. Exiting..."
    exit 1
fi

rm nix*.tar.gz
rm -rf ./nix

if [ -z "$1" ]; then
    wget $NIX_DEFAULT_LOCATION
else
    wget $1
fi

if [ ! -f "$filename" ]; then
    echo "Cannot Download Nix package. Please check your Internet connection or download URL."
    echo "Exiting"
    exit 1
fi

tar -xvzf nix*.tar.gz

# Backup Existing Nix Installation in-case something goes wrong - 
BACKUP_FILE=$HOME"/nix_backup_date_"$(date ' + CHAR(39) + '+%d%b%Y_%H%M%S' + CHAR(39) + ')".tar.gz"
echo "Backing up to $BACKUP_FILE"
tar -zcvf $BACKUP_FILE /usr/share/java/nix/

if [ -f "$BACKUP_FILE" ]; then
    echo "Nix backup location: $BACKUP_FILE"
else
    echo "Could not create backup file $BACKUP_FILE. Exiting..."
    exit 1
fi

SCRIPT_PATH="nix/upgradenixdynamic.sh"

source $SCRIPT_PATH

echo "Upgrade Complete"', 'Eg : NIX_DEFAULT_LOCATION="https://mars.42gears.com/support/inout/nixv4.2.1.tar.gz"', 'Script to update agent to a specific version.', 'Agent version', '','SureMDM Agent', 0)