freedombone-utils-gnusocialtools

#!/bin/bash
#
# .---.                  .              .
# |                      |              |
# |--- .--. .-.  .-.  .-.|  .-. .--.--. |.-.  .-. .--.  .-.
# |    |   (.-' (.-' (   | (   )|  |  | |   )(   )|  | (.-'
# '    '     --'  --'  -' -  -' '  '   -' -'   -' '   -  --'
#
#                    Freedom in the Cloud
#
# functions common to GNU Social server varieties
#
# License
# =======
#
# Copyright (C) 2017-2018 Bob Mottram <bob@freedombone.net>
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Affero General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU Affero General Public License for more details.
#
# You should have received a copy of the GNU Affero General Public License
# along with this program.  If not, see <http://www.gnu.org/licenses/>.

# Qvitter upstream: https://git.gnu.io/h2p/Qvitter"
QVITTER_THEME_REPO="https://github.com/bashrc/Qvitter"
QVITTER_THEME_COMMIT='c6f09bda4e45be4290cf7409fa5efb4420538032'

PLEROMA_FRONTEND_REPO="https://gitgud.io/lambadalambda/pleroma-fe"
PLEROMA_FRONTEND_COMMIT='3b3bbaab822b553f514a62d20d679acc5ce4414a'

SHARINGS_REPO="http://github.com/bashrc/Sharings"
SHARINGS_COMMIT='0d30fe7d153c7ab44e8459970b8f2b5dec06e43c'
SHARINGS_THEME_REPO="http://github.com/bashrc/SharingsTheme"
SHARINGS_THEME_COMMIT='a46ef375d19e8ef6889653668a7e697b0ba2013c'

GNUSOCIAL_MARKDOWN_REPO="https://git.gnu.io/chimo/markdown.git"
GNUSOCIAL_MARKDOWN_COMMIT='03c53942f94b3376f0946e6e1fe566cc21ccf232'

# Stuff to be done after restoring from backup
function gnusocial_update_after_restore {
    gnusocial_variant=$1
    gnusocial_domain=$2

    cd /var/www/${gnusocial_domain}/htdocs

    # Ensure that the database password is correct
    MARIADB_PASSWORD=$(${PROJECT_NAME}-pass -u root -a mariadb)
    sed -i "s|\$config['db']['database'].*|\$config['db']['database'] = 'mysqli://root:${MARIADB_PASSWORD}@localhost/${gnusocial_variant}';|g" config.php
    MARIADB_PASSWORD=

    # Set permissions
    chmod g+w /var/www/$gnusocial_domain/htdocs
    chmod a+w /var/www/$gnusocial_domain/htdocs/avatar
    chmod a+w /var/www/$gnusocial_domain/htdocs/file
    chown -R www-data:www-data /var/www/$gnusocial_domain/htdocs
    chmod +x /var/www/$gnusocial_domain/htdocs/scripts/maildaemon.php

    # This seems to be necessary to get the UI back
    gnusocial_use_classic $gnusocial_variant
    gnusocial_use_qvitter $gnusocial_variant

    # start the daemons
    su -c "sh scripts/startdaemons.sh" -s /bin/sh www-data
}

function qvitter_update_background {
    domain_name="$1"
    ext=$2

    if [ -d /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img ]; then
        if [ -f bg_custom.${ext} ]; then
            cp bg_custom.${ext} /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img
            if ! grep -q "bg_custom.${ext}" /var/www/${domain_name}/htdocs/config.php; then
                if grep -q 'sitebackground' /var/www/${domain_name}/htdocs/config.php; then
                    sed -i '/sitebackground/d' /var/www/${domain_name}/htdocs/config.php
                fi
                echo "\$config['site']['qvitter']['sitebackground'] = 'img/bg_custom.${ext}';" >> /var/www/${domain_name}/htdocs/config.php
            fi
        fi
    fi
}

function pleroma_set_background_image_from_url {
    basedir="$1"
    domain_name="$2"
    url="$3"
    title="$4"

    if [ ${#domain_name} -eq 0 ]; then
        echo "1"
        return
    fi

    ext=
    if [ ${#url} -gt 0 ]; then
        if [[ "$url" == *".jpeg" || "$url" == *".jpg" ]]; then
            ext="jpg"
        fi
        if [[ "$url" == *".png" ]]; then
            ext="png"
        fi
        if [[ "$url" == *".gif" ]]; then
            ext="gif"
        fi
    fi

    if [ ${#ext} -gt 0 ]; then
        cd $basedir

        # remove any existing image
        if [ -f bg_custom.${ext} ]; then
            rm bg_custom.${ext}
        fi

        # get the new image
        wget "$url" -O bg_custom.${ext}
        if [ ! -f bg_custom.${ext} ]; then
            echo "$url"
            echo $'Custom background image for pleroma could not be downloaded'
            echo "1"
            return
        fi

        if [ -d $basedir/static ]; then
            cp bg_custom.${ext} static/bg_custom.${ext}
            chown www-data:www-data static/bg_custom.${ext}
            sed -i "s|\"background\":.*|\"background\": \"/static/bg_custom.${ext}\",|g" static/config.json
        fi
        if [ -d priv/static/static ]; then
            cp bg_custom.${ext} priv/static/static/bg_custom.${ext}
            chown www-data:www-data priv/static/static/bg_custom.${ext}
            sed -i "s|\"background\":.*|\"background\": \"/static/bg_custom.${ext}\",|g" priv/static/static/config.json
        fi

        if [[ "$basedir" != $PLEROMA_DIR ]]; then
            qvitter_update_background ${domain_name} ${ext}
        fi

        rm bg_custom.${ext}
    else
        echo "2"
        return
    fi

    # customise the logo
    if [ -f $basedir/static/logo.png ]; then
        if [ -f ~/freedombone/img/logo_fbone3.png ]; then
            cp ~/freedombone/img/logo_fbone3.png $basedir/static/logo.png
            if [ -d $basedir/priv/static/static ]; then
                cp ~/freedombone/img/logo_fbone3.png $basedir/priv/static/static/logo.png
            fi
        else
            if [ -f /home/$MY_USERNAME/freedombone/img/logo_fbone3.png ]; then
                cp /home/$MY_USERNAME/freedombone/img/logo_fbone3.png $basedir/static/logo.png
                if [ -d $basedir/priv/static/static ]; then
                    cp /home/$MY_USERNAME/freedombone/img/logo_fbone3.png $basedir/priv/static/static/logo.png
                fi
            fi
        fi
    fi

    # customise the title
    if [ -f $basedir/static/config.json ]; then
        sed -i "s|\"name\":.*|\"name\": \"${title}\",|g" $basedir/static/config.json
    fi
    if [ -f $basedir/priv/static/static/config.json ]; then
        sed -i "s|\"name\":.*|\"name\": \"${title}\",|g" $basedir/priv/static/static/config.json
    fi

    echo "0"
}

function install_qvitter {
    domain_name=$1
    app_name=$2

    # update to the next commit
    function_check set_repo_commit
    set_repo_commit /var/www/${domain_name}/htdocs/local/plugins/Qvitter "${app_name} theme commit" "$QVITTER_THEME_COMMIT" $QVITTER_THEME_REPO

    # customise with project logo
    if [ -f /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img/sprite.png ]; then
        if [ -f ~/freedombone/img/logo_fbone3.png ]; then
            cp ~/freedombone/img/logo_fbone3.png /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img/sprite.png
        else
            if [ -f /home/$MY_USERNAME/freedombone/img/logo_fbone3.png ]; then
                cp /home/$MY_USERNAME/freedombone/img/logo_fbone3.png /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img/sprite.png
            fi
        fi
    fi

    if [[ $(app_is_installed "${app_name}_theme") == "1" ]]; then
        return
    fi

    apt-get -yq install wget

    if [ ! -d /var/www/${domain_name}/htdocs/local/plugins ]; then
        mkdir -p /var/www/${domain_name}/htdocs/local/plugins
    fi

    cd /var/www/${domain_name}/htdocs/local/plugins

    if [ -d /repos/qvitter ]; then
        mkdir Qvitter
        cp -r -p /repos/qvitter/. Qvitter
        cd Qvitter
        git pull
    else
        function_check git_clone
        git_clone $QVITTER_THEME_REPO Qvitter
    fi

    if [ ! -d /var/www/${domain_name}/htdocs/local/plugins/Qvitter ]; then
        echo $'Qvitter repo was not installed'
        exit 835638
    fi

    cd /var/www/${domain_name}/htdocs/local/plugins/Qvitter
    git checkout $QVITTER_THEME_COMMIT -b $QVITTER_THEME_COMMIT

    config_file=/var/www/${domain_name}/htdocs/config.php
    if ! grep -q "addPlugin('Qvitter')" $config_file; then
        echo "" >> $config_file
        echo "// Qvitter settings" >> $config_file
        echo "addPlugin('Qvitter');" >> $config_file
        echo "\$config['site']['qvitter']['enabledbydefault'] = true;" >> $config_file
        echo "\$config['site']['qvitter']['defaultbackgroundcolor'] = '#f4f4f4';" >> $config_file
        echo "\$config['site']['qvitter']['defaultlinkcolor'] = '#0084B4';" >> $config_file
        echo "\$config['site']['qvitter']['timebetweenpolling'] = 30000; // 30 secs" >> $config_file
        if [[ $ONION_ONLY == 'no' ]]; then
            echo "\$config['site']['qvitter']['urlshortenerapiurl'] = 'http://qttr.at/shortener.php';" >> $config_file
            echo "\$config['site']['qvitter']['urlshortenersignature'] = 'b6afeec983';" >> $config_file
        fi
        echo "\$config['site']['qvitter']['favicon'] = 'img/favicon.ico?v=4';" >> $config_file
        echo "\$config['site']['qvitter']['sprite'] = Plugin::staticPath('Qvitter', '').'img/sprite.png?v=40';" >> $config_file
        echo "\$config['site']['qvitter']['enablewelcometext'] = false;" >> $config_file
        echo "\$config['site']['qvitter']['blocked_ips'] = array();" >> $config_file
    fi

    # customise with project logo
    if [ -f /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img/sprite.png ]; then
        if [ -f ~/freedombone/img/${app_name}_sprite.png ]; then
            cp ~/freedombone/img/${app_name}_sprite.png /var/www/${domain_name}/htdocs/local/plugins/Qvitter/img/sprite.png
        fi
    fi

    chown -R www-data:www-data /var/www/${domain_name}/htdocs

    cd /var/www/${domain_name}/htdocs
    php scripts/upgrade.php
    php scripts/checkschema.php
    chown -R www-data:www-data /var/www/${domain_name}/htdocs

    set_completion_param "${app_name} theme commit" "$QVITTER_THEME_COMMIT"

    install_completed ${app_name}_theme
}

function install_gnusocial_default_background {
    gnusocial_type=$1
    domain_name=$2

    basedir=/var/www/${domain_name}/htdocs
    if [[ "$gnusocial_type" == 'pleroma' ]]; then
        basedir=$PLEROMA_DIR/priv/static
    fi

    # customise the logo
    if [ -f $basedir/static/logo.png ]; then
        if [ -f ~/freedombone/img/logo_fbone3.png ]; then
            cp ~/freedombone/img/logo_fbone3.png $basedir/static/logo_custom.png
            sed -i "s|\"logo\":.*|\"logo\": \"/static/logo_custom.png\",|g" $basedir/static/config.json
        else
            if [ -f /home/$MY_USERNAME/freedombone/img/logo_fbone3.png ]; then
                cp /home/$MY_USERNAME/freedombone/img/logo_fbone3.png $basedir/static/logo_custom.png
                sed -i "s|\"logo\":.*|\"logo\": \"/static/logo_custom.png\",|g" $basedir/static/config.json
            fi
        fi
    fi

    if [ ! -f $basedir/static/bg.jpg ]; then
        return
    fi

    if [ -f ~/freedombone/img/backgrounds/${gnusocial_type}.jpg ]; then
        cp ~/freedombone/img/backgrounds/${gnusocial_type}.jpg $basedir/static/bg_custom.jpg
        sed -i "s|\"background\":.*|\"background\": \"/static/bg_custom.jpg\",|g" $basedir/static/config.json
    else
        if [ -f /home/$MY_USERNAME/freedombone/img/backgrounds/${gnusocial_type}.jpg ]; then
            cp /home/$MY_USERNAME/freedombone/img/backgrounds/${gnusocial_type}.jpg $basedir/static/bg_custom.jpg
            sed -i "s|\"background\":.*|\"background\": \"/static/bg_custom.jpg\",|g" $basedir/static/config.json
        fi
    fi
}


function install_pleroma_front_end {
    app_name="$1"
    pleroma_domain="$2"
    background_url="$3"
    title="$4"

    if [ ! -d $INSTALL_DIR/pleroma ]; then

        if [ -d /repos/pleroma-fe ]; then
            mkdir -p $INSTALL_DIR/pleroma
            cp -r -p /repos/pleroma-fe/. $INSTALL_DIR/pleroma
            cd $INSTALL_DIR/pleroma
            git pull
        else
            function_check git_clone
            git_clone $PLEROMA_FRONTEND_REPO $INSTALL_DIR/pleroma
        fi

        if [ ! -d $INSTALL_DIR/pleroma ]; then
            echo $'Unable to clone pleroma repo'
            exit 682252
        fi
    fi

    cd $INSTALL_DIR/pleroma
    git checkout $PLEROMA_FRONTEND_COMMIT -b $PLEROMA_FRONTEND_COMMIT
    set_completion_param "${app_name} pleroma commit" "$PLEROMA_FRONTEND_COMMIT"

    if [ -d $INSTALL_DIR/pleroma/node_modules ]; then
        rm -rf $INSTALL_DIR/pleroma/node_modules
    fi

    npm install -g yarn
    npm install -g eslint@3.19.0
    npm install -g eslint-plugin-promise@3.5.0
    npm install -g moment@2.18.1
    npm install -g node-sass@4.5.2
    npm install -g whatwg-fetch@2.0.3
    yarn
    if [ -f $INSTALL_DIR/pleroma/dist/index.html ]; then
        rm -rf $INSTALL_DIR/pleroma/dist/*
    fi
    npm run build
    if [ ! -d $INSTALL_DIR/pleroma/dist ]; then
        echo 'Unable to build pleroma'
        exit 7629352
    fi
    if [ ! -f $INSTALL_DIR/pleroma/dist/index.html ]; then
        echo $'Unable to build pleroma index.html'
        exit 5282682
    fi

    if [[ "$app_name" != 'pleroma' ]]; then
        cp -r $INSTALL_DIR/pleroma/dist/* /var/www/${pleroma_domain}/htdocs/
        pleroma_set_background_image_from_url /var/www/${pleroma_domain}/htdocs "$pleroma_domain" "$background_url" "$title"
    else
        cp -r $INSTALL_DIR/pleroma/dist/* $PLEROMA_DIR/priv/static
        pleroma_set_background_image_from_url $PLEROMA_DIR/priv/static "$pleroma_domain" "$background_url" "$title"
    fi


    nginx_site=/etc/nginx/sites-available/${pleroma_domain}
    sed -i 's|index index.php;|index index.html;|g' $nginx_site

    if [ -f /var/www/${pleroma_domain}/htdocs/index.php ]; then
        mv /var/www/${pleroma_domain}/htdocs/index.php /var/www/${pleroma_domain}/htdocs/index_qvitter.php
    fi
    sed -i 's|index.php|index_qvitter.php|g' $nginx_site

    # remove any cached yarn files
    if [ -d /root/.cache/yarn ]; then
        rm -rf /root/.cache/yarn
    fi

    if [[ "$app_name" != 'pleroma' ]]; then
        chown -R www-data:www-data /var/www/${pleroma_domain}/htdocs
    else
        chown -R pleroma:pleroma $PLEROMA_DIR
    fi
}

function upgrade_pleroma_frontend {
    domain_name="$1"
    app_name="$2"
    background_url="$3"
    title="$4"

    if [ -d $INSTALL_DIR/pleroma ]; then
        set_repo_commit $INSTALL_DIR/pleroma "${app_name} pleroma commit" "$PLEROMA_FRONTEND_COMMIT" $PLEROMA_FRONTEND_REPO
        cd $INSTALL_DIR/pleroma
        yarn
        npm run build
        if [ ! -d $INSTALL_DIR/pleroma/dist ]; then
            echo 'Unable to build pleroma'
            exit 268362
        fi

        basedir=/var/www/${domain_name}/htdocs
        if [[ "$app_name" == 'pleroma' ]]; then
            basedir=$PLEROMA_DIR/priv/static
        fi
        if [ -f $basedir/static/logo.png ]; then
            cp $basedir/static/logo.png $basedir/static/logo.png.old
        fi
        if [ -f $basedir/static/bg.jpg ]; then
            cp $basedir/static/bg.jpg $basedir/static/bg.jpg.old
        fi
        if [ -f $basedir/static/config.json ]; then
            cp $basedir/static/config.json $basedir/static/config.json.old
        fi
        cp -r $INSTALL_DIR/pleroma/dist/* $basedir/
        if [ -f $basedir/static/config.json.old ]; then
            mv $basedir/static/config.json.old $basedir/static/config.json
        fi
        sed -i "s|\"name\":.*|\"name\": \"${title}\",|g" $basedir/static/config.json
        if [ -f $basedir/static/logo.png.old ]; then
            cp $basedir/static/logo.png.old $basedir/static/logo.png
        fi
        if [ -f $basedir/static/bg.jpg.old ]; then
            cp $basedir/static/bg.jpg.old $basedir/static/bg.jpg
        fi

        if [ -f $basedir/index.php ]; then
            mv $basedir/index.php $basedir/index_qvitter.php
        fi
        chown -R www-data:www-data $basedir
    else
        install_pleroma_front_end "${app_name}" "${domain_name}" "${background_url}" "${title}"
    fi
}

function gnusocial_hourly_script {
    gnusocial_type=$1
    domain_name=$2

    # check that the daemon is running
    echo '#!/bin/bash' > /etc/cron.hourly/${gnusocial_type}-daemons
    echo -n 'daemon_lines=$(ps aux | grep "' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo -n "${domain_name}" >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo '/htdocs/scripts/queuedaemon.php" | grep "/var/www")' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo "cd /var/www/${domain_name}/htdocs" >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo 'if [[ $daemon_lines != *"/var/www/"* ]]; then' >> /etc/cron.hourly/${gnusocial_type}-daemons

    echo "    ADMIN_USER=\$(cat $COMPLETION_FILE | grep 'Admin user' | awk -F ':' '{print \$2}')" >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo '    MY_EMAIL_ADDRESS=$ADMIN_USER@$HOSTNAME' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo -n "    echo \"Restarting ${gnusocial_type} daemons\" | mail -s \"${gnusocial_type} " >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo 'daemons not found" $MY_EMAIL_ADDRESS' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo '    su -c "sh scripts/startdaemons.sh" -s /bin/sh www-data' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo 'fi' >> /etc/cron.hourly/${gnusocial_type}-daemons

    echo 'php scripts/delete_orphan_files.php > /dev/null' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo 'php scripts/clean_thumbnails.php -y > /dev/null' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo 'php scripts/clean_file_table.php -y > /dev/null' >> /etc/cron.hourly/${gnusocial_type}-daemons
    echo 'php scripts/upgrade.php > /dev/null' >> /etc/cron.hourly/${gnusocial_type}-daemons

    chmod +x /etc/cron.hourly/${gnusocial_type}-daemons
}

function gnusocial_block_user_script {
    echo '#!/bin/bash' > /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo 'database_name=$1' >> /usr/bin/gnusocial-delete-user
    echo 'remove_user=$2' >> /usr/bin/gnusocial-delete-user
    echo 'domain_name=$3' >> /usr/bin/gnusocial-delete-user
    echo 'MARIADB_PASSWORD=$(freedombone-pass -u root -a mariadb)' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo 'if [ ${#remove_user} -lt 2 ]; then' >> /usr/bin/gnusocial-delete-user
    echo '  echo $"No user was specified"' >> /usr/bin/gnusocial-delete-user
    echo '  exit 1' >> /usr/bin/gnusocial-delete-user
    echo 'fi' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo 'if [[ "$remove_user" != *"."* || "$remove_user" != *"@"* ]]; then' >> /usr/bin/gnusocial-delete-user
    echo '  echo $"This doesnt look like a user"' >> /usr/bin/gnusocial-delete-user
    echo '  exit 2' >> /usr/bin/gnusocial-delete-user
    echo 'fi' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo 'if [ ${#database_name} -lt 2 ]; then' >> /usr/bin/gnusocial-delete-user
    echo '  echo $"No database was specified"' >> /usr/bin/gnusocial-delete-user
    echo '  exit 3' >> /usr/bin/gnusocial-delete-user
    echo 'fi' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo "nickname=\$(echo \"\$remove_user\" | awk -F '@' '{print \$1}')" >> /usr/bin/gnusocial-delete-user
    echo "remove_domain=\$(echo \"\$remove_user\" | awk -F '@' '{print \$2}')" >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo "database_query=\"delete from notice where content REGEXP '\@\${remove_user}';\"" >> /usr/bin/gnusocial-delete-user
    echo 'mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo 'database_query="select profile.id from profile where nickname = '"'"'${nickname}'"'"' and profileurl like '"'"'%${remove_domain}%'"'"';"' >> /usr/bin/gnusocial-delete-user
    echo 'declare -a ids=$(mysql -u root --password="$MARIADB_PASSWORD" << EOF' >> /usr/bin/gnusocial-delete-user
    echo 'use $database_name;' >> /usr/bin/gnusocial-delete-user
    echo '$database_query' >> /usr/bin/gnusocial-delete-user
    echo 'EOF' >> /usr/bin/gnusocial-delete-user
    echo ')' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo 'ctr=0' >> /usr/bin/gnusocial-delete-user
    echo 'for id in $ids' >> /usr/bin/gnusocial-delete-user
    echo 'do' >> /usr/bin/gnusocial-delete-user
    echo '  if [ $ctr -gt 0 ]; then' >> /usr/bin/gnusocial-delete-user
    echo '      #echo "Removing user ID $id on $remove_domain"' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo '      database_query="delete from reply where profile_id=${id};"' >> /usr/bin/gnusocial-delete-user
    echo '      mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo '      database_query="delete from reply where replied_id=${id};"' >> /usr/bin/gnusocial-delete-user
    echo '      mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo '      if [ $domain_name ]; then' >> /usr/bin/gnusocial-delete-user
    echo '          database_query="select rendered from notice where profile_id=${id} and rendered like '"'"'%/file/%'"'"';"' >> /usr/bin/gnusocial-delete-user
    echo '          declare -a stored_files=$(mysql -u root --password="$MARIADB_PASSWORD" << EOF' >> /usr/bin/gnusocial-delete-user
    echo 'use $database_name;' >> /usr/bin/gnusocial-delete-user
    echo '$database_query' >> /usr/bin/gnusocial-delete-user
    echo 'EOF' >> /usr/bin/gnusocial-delete-user
    echo ')' >> /usr/bin/gnusocial-delete-user
    echo -n "          files_to_delete=\$(echo \"\$stored_files\" | " >> /usr/bin/gnusocial-delete-user
    echo 'sed -n '"'"'s/.*href="\([^"]*\).*/\1/p'"'"' | awk -F '"'"'file/'"'"' '"'"'{print $2}'"'"')' >> /usr/bin/gnusocial-delete-user
    echo '          filectr=0' >> /usr/bin/gnusocial-delete-user
    echo '          for f in $files_to_delete' >> /usr/bin/gnusocial-delete-user
    echo '          do' >> /usr/bin/gnusocial-delete-user
    echo '              if [ $filectr -gt 0 ]; then' >> /usr/bin/gnusocial-delete-user
    echo '                  if $(ls /var/www/${domain_name}/htdocs/file/*${f}* 1> /dev/null 2>&1); then' >> /usr/bin/gnusocial-delete-user
    echo '                      rm /var/www/${domain_name}/htdocs/file/*${f}*' >> /usr/bin/gnusocial-delete-user
    echo '                  fi' >> /usr/bin/gnusocial-delete-user
    echo '              fi' >> /usr/bin/gnusocial-delete-user
    echo '              filectr=$((filectr + 1))' >> /usr/bin/gnusocial-delete-user
    echo '          done' >> /usr/bin/gnusocial-delete-user
    echo '      fi' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo '      database_query="delete from notice where profile_id=${id};"' >> /usr/bin/gnusocial-delete-user
    echo '      mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo '      database_query="delete from profile where id=${id};"' >> /usr/bin/gnusocial-delete-user
    echo '      mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-user
    echo '' >> /usr/bin/gnusocial-delete-user
    echo '      database_query="delete from qvitternotification where to_profile_id=${id} or from_profile_id=${id};"' >> /usr/bin/gnusocial-delete-user
    echo '      mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-user
    echo '  fi' >> /usr/bin/gnusocial-delete-user
    echo '  ctr=$((ctr + 1))' >> /usr/bin/gnusocial-delete-user
    echo 'done' >> /usr/bin/gnusocial-delete-user
    chmod +x /usr/bin/gnusocial-delete-user
}

function gnusocial_block_domain_script {
    database_name=$1
    gnusoc_domain=$2

    echo '#!/bin/bash' > /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo 'database_name=$1' >> /usr/bin/gnusocial-delete-domain
    echo 'remove_domain=$2' >> /usr/bin/gnusocial-delete-domain
    echo 'domain_name=$3' >> /usr/bin/gnusocial-delete-domain
    echo "MARIADB_PASSWORD=\$(${PROJECT_NAME}-pass -u root -a mariadb)" >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo 'if [ ${#remove_domain} -lt 2 ]; then' >> /usr/bin/gnusocial-delete-domain
    echo '    echo $"No domain was specified"' >> /usr/bin/gnusocial-delete-domain
    echo '    exit 1' >> /usr/bin/gnusocial-delete-domain
    echo 'fi' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo 'if [[ "$remove_domain" != *"."* ]]; then' >> /usr/bin/gnusocial-delete-domain
    echo '    echo $"This doesnt look like a domain"' >> /usr/bin/gnusocial-delete-domain
    echo '    exit 2' >> /usr/bin/gnusocial-delete-domain
    echo 'fi' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo 'if [ ${#database_name} -lt 2 ]; then' >> /usr/bin/gnusocial-delete-domain
    echo '    echo $"No database was specified"' >> /usr/bin/gnusocial-delete-domain
    echo '    exit 3' >> /usr/bin/gnusocial-delete-domain
    echo 'fi' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo "database_query=\"select profile.id from profile where profileurl like '%\${remove_domain}%';\"" >> /usr/bin/gnusocial-delete-domain
    echo 'declare -a ids=$(mysql -u root --password="$MARIADB_PASSWORD" << EOF' >> /usr/bin/gnusocial-delete-domain
    echo 'use $database_name;' >> /usr/bin/gnusocial-delete-domain
    echo '$database_query' >> /usr/bin/gnusocial-delete-domain
    echo 'EOF' >> /usr/bin/gnusocial-delete-domain
    echo ')' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo 'ctr=0' >> /usr/bin/gnusocial-delete-domain
    echo 'for id in $ids' >> /usr/bin/gnusocial-delete-domain
    echo 'do' >> /usr/bin/gnusocial-delete-domain
    echo '    if [ $ctr -gt 0 ]; then' >> /usr/bin/gnusocial-delete-domain
    echo '        #echo "Removing user ID $id on $remove_domain"' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo "        database_query=\"delete from conversation where uri like '%\${remove_domain}%';\"" >> /usr/bin/gnusocial-delete-domain
    echo '        mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo '        database_query="delete from reply where profile_id=${id};"' >> /usr/bin/gnusocial-delete-domain
    echo '        mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo '        database_query="delete from reply where replied_id=${id};"' >> /usr/bin/gnusocial-delete-domain
    echo '        mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo '        if [ $domain_name ]; then' >> /usr/bin/gnusocial-delete-domain
    echo '          database_query="select rendered from notice where profile_id=${id} and rendered like '"'"'%/file/%'"'"';"' >> /usr/bin/gnusocial-delete-domain
    echo '          declare -a stored_files=$(mysql -u root --password="$MARIADB_PASSWORD" << EOF' >> /usr/bin/gnusocial-delete-domain
    echo 'use $database_name;' >> /usr/bin/gnusocial-delete-domain
    echo '$database_query' >> /usr/bin/gnusocial-delete-domain
    echo 'EOF' >> /usr/bin/gnusocial-delete-domain
    echo ')' >> /usr/bin/gnusocial-delete-domain
    echo -n "           files_to_delete=\$(echo \"\$stored_files\" | " >> /usr/bin/gnusocial-delete-domain
    echo 'sed -n '"'"'s/.*href="\([^"]*\).*/\1/p'"'"' | awk -F '"'"'file/'"'"' '"'"'{print $2}'"'"')' >> /usr/bin/gnusocial-delete-domain
    echo '            filectr=0' >> /usr/bin/gnusocial-delete-domain
    echo '            for f in $files_to_delete' >> /usr/bin/gnusocial-delete-domain
    echo '            do' >> /usr/bin/gnusocial-delete-domain
    echo '                if [ $filectr -gt 0 ]; then' >> /usr/bin/gnusocial-delete-domain
    echo '                    if $(ls /var/www/${domain_name}/htdocs/file/*${f}* 1> /dev/null 2>&1); then' >> /usr/bin/gnusocial-delete-domain
    echo '                        rm /var/www/${domain_name}/htdocs/file/*${f}*' >> /usr/bin/gnusocial-delete-domain
    echo '                    fi' >> /usr/bin/gnusocial-delete-domain
    echo '                fi' >> /usr/bin/gnusocial-delete-domain
    echo '                filectr=$((filectr + 1))' >> /usr/bin/gnusocial-delete-domain
    echo '            done' >> /usr/bin/gnusocial-delete-domain
    echo '        fi' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo '        database_query="delete from notice where profile_id=${id};"' >> /usr/bin/gnusocial-delete-domain
    echo '        mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo '        database_query="delete from profile where id=${id};"' >> /usr/bin/gnusocial-delete-domain
    echo '        mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-domain
    echo '' >> /usr/bin/gnusocial-delete-domain
    echo '        database_query="delete from qvitternotification where to_profile_id=${id} or from_profile_id=${id};"' >> /usr/bin/gnusocial-delete-domain
    echo '        mysql -u root --password="$MARIADB_PASSWORD" -e "$database_query" $database_name' >> /usr/bin/gnusocial-delete-domain
    echo '    fi' >> /usr/bin/gnusocial-delete-domain
    echo '    ctr=$((ctr + 1))' >> /usr/bin/gnusocial-delete-domain
    echo 'done' >> /usr/bin/gnusocial-delete-domain
    chmod +x /usr/bin/gnusocial-delete-domain

    echo '#!/bin/bash' > /usr/bin/${database_name}-firewall
    echo '' >> /usr/bin/${database_name}-firewall
    echo "PROJECT_NAME=$PROJECT_NAME" >> /usr/bin/${database_name}-firewall
    echo "GNUSOCIAL_DOMAIN_NAME=$gnusoc_domain" >> /usr/bin/${database_name}-firewall
    echo "database_name=$database_name" >> /usr/bin/${database_name}-firewall
    echo 'FIREWALL_DOMAINS=$HOME/${PROJECT_NAME}-firewall-domains.cfg' >> /usr/bin/${database_name}-firewall
    echo '' >> /usr/bin/${database_name}-firewall
    echo 'while read block; do' >> /usr/bin/${database_name}-firewall
    echo '    if [[ "$block" != *"@"* ]]; then' >> /usr/bin/${database_name}-firewall
    echo '        /usr/bin/gnusocial-delete-domain "$database_name" "$block" "$GNUSOCIAL_DOMAIN_NAME"' >> /usr/bin/${database_name}-firewall
    echo '    else' >> /usr/bin/${database_name}-firewall
    echo '        /usr/bin/gnusocial-delete-user "$database_name" "$block" "$GNUSOCIAL_DOMAIN_NAME"' >> /usr/bin/${database_name}-firewall
    echo '    fi' >> /usr/bin/${database_name}-firewall
    echo 'done <$FIREWALL_DOMAINS' >> /usr/bin/${database_name}-firewall
    echo '' >> /usr/bin/${database_name}-firewall
    echo '# remove any metadata from images uploaded in the last 2 minutes' >> /usr/bin/${database_name}-firewall
    echo 'if [ -d /var/www/$GNUSOCIAL_DOMAIN_NAME/htdocs ]; then' >> /usr/bin/${database_name}-firewall
    echo '    cd /var/www/$GNUSOCIAL_DOMAIN_NAME/htdocs' >> /usr/bin/${database_name}-firewall
    echo '    declare -a recent_image=$(find file ! -name thumb-* -mmin -2 -type f -exec ls -l {} + | awk -F '"'"'file/'"'"' '"'"'{print $2}'"'"')' >> /usr/bin/${database_name}-firewall
    echo '    for f in ${recent_image[@]}' >> /usr/bin/${database_name}-firewall
    echo '    do' >> /usr/bin/${database_name}-firewall
    echo '        if [ ${#f} -gt 1 ]; then' >> /usr/bin/${database_name}-firewall
    echo '            exiftool -q -all= "file/${f}"' >> /usr/bin/${database_name}-firewall
    echo '        fi' >> /usr/bin/${database_name}-firewall
    echo '    done' >> /usr/bin/${database_name}-firewall
    echo 'fi' >> /usr/bin/${database_name}-firewall
    chmod +x /usr/bin/${database_name}-firewall

    if ! grep -q "${database_name}-firewall" /etc/crontab; then
        cron_add_mins 1 "/usr/bin/${database_name}-firewall"
    fi
}

function expire_gnusocial_posts {
    domain_name=$1
    gnusocial_type=$2
    expire_months=$3

    if [ ! $expire_months ]; then
        expire_months=3
    fi

    expire_days=$((expire_months * 30))

    # files are what take up most of the backup time, so don't keep them for very long
    expire_days_files=7

    # To prevent the database size from growing endlessly this script expires posts
    # after a number of months
    if [ ! -d /var/www/${domain_name}/htdocs ]; then
        return
    fi

    gnusocial_expire_posts_script=/usr/bin/${gnusocial_type}-expire-posts

    echo '<?php' > $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo "// ${gnusocial_type} post expiry script, based on StatExpire by Tony Baldwin" >> $gnusocial_expire_posts_script
    echo '// https://github.com/tonybaldwin/statexpire' >> $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo "\$oldate=date((\"Y-m-d\"), strtotime(\"-${expire_months} months\"));" >> $gnusocial_expire_posts_script
    echo '$username="root";' >> $gnusocial_expire_posts_script
    echo "\$password=shell_exec('${PROJECT_NAME}-pass -u root -a mariadb');" >> $gnusocial_expire_posts_script
    echo "\$database=\"${gnusocial_type}\";" >> $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo 'if (!$link = mysqli_connect("localhost", $username, $password)) {' >> $gnusocial_expire_posts_script
    echo '    echo "Could not connect to mariadb";' >> $gnusocial_expire_posts_script
    echo '    exit;' >> $gnusocial_expire_posts_script
    echo '}' >> $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo 'if (!mysqli_select_db($link, $database)) {' >> $gnusocial_expire_posts_script
    echo "    echo \"Could not select ${gnusocial_type} database\";" >> $gnusocial_expire_posts_script
    echo '    exit;' >> $gnusocial_expire_posts_script
    echo '}' >> $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo "\$notice_query=\"DELETE FROM notice WHERE created <= '\$oldate 01:01:01'\";" >> $gnusocial_expire_posts_script
    echo "\$conversation_query=\"DELETE FROM conversation WHERE created <= '$oldate 01:01:01'\";" >> $gnusocial_expire_posts_script
    echo "\$reply_query=\"DELETE FROM reply WHERE modified <= '\$oldate 01:01:01'\";" >> $gnusocial_expire_posts_script
    echo "\$notification_query=\"DELETE FROM qvitternotification WHERE created <= '\$oldate 01:01:01'\";" >> $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo 'mysqli_query($link, $notice_query);' >> $gnusocial_expire_posts_script
    echo '$rowaff1=mysqli_affected_rows($link);' >> $gnusocial_expire_posts_script
    echo 'mysqli_query($link, $conversation_query);' >> $gnusocial_expire_posts_script
    echo '$rowaff2=mysqli_affected_rows($link);' >> $gnusocial_expire_posts_script
    echo 'mysqli_query($link, $reply_query);' >> $gnusocial_expire_posts_script
    echo '$rowaff3=mysqli_affected_rows($link);' >> $gnusocial_expire_posts_script
    echo 'mysqli_query($link, $notification_query);' >> $gnusocial_expire_posts_script
    echo '$rowaff4=mysqli_affected_rows($link);' >> $gnusocial_expire_posts_script
    echo 'mysqli_close($link);' >> $gnusocial_expire_posts_script
    echo '' >> $gnusocial_expire_posts_script
    echo -n "echo \"Expire ${gnusocial_type} posts: " >> $gnusocial_expire_posts_script
    echo '$rowaff1 notices, $rowaff2 conversations, $rowaff3 replies, and $rowaff4 qvitter notifications deleted from database.\n";' >> $gnusocial_expire_posts_script
    chmod +x $gnusocial_expire_posts_script

    gnusocial_expire_script=/etc/cron.daily/${gnusocial_type}-expire
    echo '#!/bin/bash' > $gnusocial_expire_script
    echo "find /var/www/${domain_name}/htdocs/file/* -mtime +${expire_days_files} -exec rm {} +" >> $gnusocial_expire_script
    echo "/usr/bin/php $gnusocial_expire_posts_script" >> $gnusocial_expire_script
    chmod +x $gnusocial_expire_script

    # remove any old cron job
    if grep -q "${gnusocial_type}-expire" /etc/crontab; then
        sed -i "/${gnusocial_type}-expire/d" /etc/crontab
        rm /usr/bin/${gnusocial_type}-expire
    fi

    # remove old expire script
    if [ -f /etc/cron.weekly/clear-${gnusocial_type}-database ]; then
        rm /etc/cron.weekly/clear-${gnusocial_type}-database
    fi
}

function gnusocial_use_classic {
    database_name=$1

    domain_name=$(get_completion_param "$database_name domain")

    if [ -f /var/www/$domain_name/htdocs/index_qvitter.php ]; then
        mv /var/www/$domain_name/htdocs/index_qvitter.php /var/www/$domain_name/htdocs/index.php
    fi

    if [ -f /etc/nginx/sites-available/$domain_name ]; then
        sed -i 's|index_qvitter.php|index.php|g' /etc/nginx/sites-available/$domain_name
        sed -i 's|index.html|index.php|g' /etc/nginx/sites-available/$domain_name
    fi

    if ! grep -q "//addPlugin('Qvitter')" /var/www/$domain_name/htdocs/config.php; then
        sed -i "s|// addPlugin('Qvitter')|addPlugin('Qvitter')|g" /var/www/$domain_name/htdocs/config.php
        sed -i "s|addPlugin('Qvitter')|//addPlugin('Qvitter')|g" /var/www/$domain_name/htdocs/config.php
    fi
    chown -R www-data:www-data /var/www/${domain_name}/htdocs

    systemctl restart nginx
}

function gnusocial_use_qvitter {
    database_name=$1

    domain_name=$(get_completion_param "$database_name domain")

    if [ -f /var/www/$domain_name/htdocs/index_qvitter.php ]; then
        mv /var/www/$domain_name/htdocs/index_qvitter.php /var/www/$domain_name/htdocs/index.php
    fi

    if [ -f /etc/nginx/sites-available/$domain_name ]; then
        sed -i 's|index_qvitter.php|index.php|g' /etc/nginx/sites-available/$domain_name
        sed -i 's|index.html|index.php|g' /etc/nginx/sites-available/$domain_name
    fi

    if grep -q "//addPlugin('Qvitter')" /var/www/$domain_name/htdocs/config.php; then
        sed -i "s|//addPlugin('Qvitter')|addPlugin('Qvitter')|g" /var/www/$domain_name/htdocs/config.php
    fi
    if grep -q "// addPlugin('Qvitter')" /var/www/$domain_name/htdocs/config.php; then
        sed -i "s|// addPlugin('Qvitter')|addPlugin('Qvitter')|g" /var/www/$domain_name/htdocs/config.php
    fi
    chown -R www-data:www-data /var/www/${domain_name}/htdocs

    systemctl restart nginx
    systemctl restart php7.0-fpm
}

function gnusocial_use_pleroma {
    database_name=$1

    domain_name=$(get_completion_param "$database_name domain")

    if [ ! -d /var/www/$domain_name/htdocs/static ]; then
        return
    fi

    if [ -f /var/www/$domain_name/htdocs/index.php ]; then
        mv /var/www/$domain_name/htdocs/index.php /var/www/$domain_name/htdocs/index_qvitter.php
    fi

    if [ -f /etc/nginx/sites-available/$domain_name ]; then
        sed -i 's|index.php|index_qvitter.php|g' /etc/nginx/sites-available/$domain_name
        sed -i 's|index index_qvitter.php|index index.html|g' /etc/nginx/sites-available/$domain_name
    fi

    if grep -q "//addPlugin('Qvitter')" /var/www/$domain_name/htdocs/config.php; then
        sed -i "s|//addPlugin('Qvitter')|addPlugin('Qvitter')|g" /var/www/$domain_name/htdocs/config.php
    fi
    if grep -q "// addPlugin('Qvitter')" /var/www/$domain_name/htdocs/config.php; then
        sed -i "s|// addPlugin('Qvitter')|addPlugin('Qvitter')|g" /var/www/$domain_name/htdocs/config.php
    fi

    cp $INSTALL_DIR/pleroma/dist/index.html /var/www/${domain_name}/htdocs/index.html
    chmod +x static/css
    chmod +x static/font
    chmod +x static/font/css
    chmod +x static/font/font
    chmod +x static/js
    chmod +x static
    chown -R www-data:www-data /var/www/${domain_name}/htdocs

    systemctl restart nginx
}

function install_gnusocial_plugin_sharings {
    domain_name=$1
    social_app_name=$2

    if [ ! -d /var/www/$domain_name/htdocs/local/plugins ]; then
        mkdir -p /var/www/$domain_name/htdocs/local/plugins
    fi

    apt-get -yq install liblocale-msgfmt-perl gettext

    # update to the next commit
    function_check set_repo_commit
    set_repo_commit /var/www/$domain_name/htdocs/local/plugins/Sharings "$social_app_name sharings plugin commit" "$SHARINGS_COMMIT" $SHARINGS_REPO

    if [[ $(app_is_installed ${social_app_name}_plugin_sharings) == "1" ]]; then
        return
    fi

    cd /var/www/$domain_name/htdocs/local/plugins

    if [ -d /repos/sharings ]; then
        mkdir Sharings
        cp -r -p /repos/sharings/. Sharings
        cd Sharings
        git pull
    else
        function_check git_clone
        git_clone $SHARINGS_REPO Sharings
    fi

    if [ ! -d /var/www/$domain_name/htdocs/local/plugins/Sharings ]; then
        echo $"Unable to clone $social_app_name sharings plugin"
        exit 36738
    fi

    cd /var/www/$domain_name/htdocs/local/plugins/Sharings
    git stash
    git checkout master
    git branch -D $SHARINGS_COMMIT
    git checkout $SHARINGS_COMMIT -b $SHARINGS_COMMIT

    # enable the plugin
    if ! grep -q "addPlugin('Sharings');" /var/www/$domain_name/htdocs/config.php; then
        echo "addPlugin('Sharings');" >> /var/www/$domain_name/htdocs/config.php
    fi

    cd /var/www/$domain_name/htdocs
    php scripts/checkschema.php
    cd /var/www/$domain_name/htdocs/local/plugins/Sharings
    php scripts/seedsharings.php
    cd /var/www/$domain_name/htdocs
    php scripts/upgrade.php
    php scripts/checkschema.php

    # Languages
    cd /var/www/$domain_name/htdocs/local/plugins/Sharings/locale/en/LC_MESSAGES
    msgfmt -o Sharings.mo Sharings.po
    if [ ! -f Sharings.po ]; then
        echo $"English translations for $social_app_name sharings plugin were not created"
        exit 782923
    fi
    cd /var/www/$domain_name/htdocs/local/plugins/Sharings/locale/en_GB/LC_MESSAGES
    msgfmt -o Sharings.mo Sharings.po
    if [ ! -f Sharings.po ]; then
        echo $"English (GB) translations for $social_app_name sharings plugin were not created"
        exit 23528
    fi
    cd /var/www/$domain_name/htdocs/local/plugins/Sharings/locale/en_US/LC_MESSAGES
    msgfmt -o Sharings.mo Sharings.po
    if [ ! -f Sharings.po ]; then
        echo $"English (US) translations for $social_app_name sharings plugin were not created"
        exit 567382
    fi

    # Looks like this update function isn't supported by the current php version
    sed -i 's|ActivityVerb::UPDATE, ||g' /var/www/$domain_name/htdocs/local/plugins/Sharings/SharingsPlugin.php

    chown -R www-data:www-data /var/www/$domain_name/htdocs

    set_completion_param gnusocial "$social_app_name sharings plugin commit" "$SHARINGS_COMMIT"
    install_completed ${social_app_name}_plugin_sharings
}

function install_gnusocial_plugin_sharings_theme {
    domain_name=$1
    social_app_name=$2

    if [ ! -d /var/www/$domain_name/htdocs/local/plugins ]; then
        mkdir -p /var/www/$domain_name/htdocs/local/plugins
    fi

    # update to the next commit
    function_check set_repo_commit
    set_repo_commit /var/www/$domain_name/htdocs/local/plugins/SharingsTheme "$social_app_name sharings theme plugin commit" "$SHARINGS_THEME_COMMIT" $SHARINGS_THEME_REPO

    if [[ $(app_is_installed ${social_app_name}_plugin_sharings_theme) == "1" ]]; then
        return
    fi

    cd /var/www/$domain_name/htdocs/local/plugins
    function_check git_clone
    git_clone $SHARINGS_THEME_REPO SharingsTheme
    if [ ! -d /var/www/$domain_name/htdocs/local/plugins/SharingsTheme ]; then
        echo $"Unable to clone $social_app_name sharings plugin theme"
        exit 639253
    fi

    cd /var/www/$domain_name/htdocs/local/plugins/SharingsTheme
    git stash
    git checkout master
    git branch -D $SHARINGS_THEME_COMMIT
    git checkout $SHARINGS_THEME_COMMIT -b $SHARINGS_THEME_COMMIT

    # enable the plugin
    if ! grep -q "addPlugin('SharingsTheme');" /var/www/$domain_name/htdocs/config.php; then
        echo "addPlugin('SharingsTheme');" >> /var/www/$domain_name/htdocs/config.php
    fi

    cd /var/www/$domain_name/htdocs
    php scripts/checkschema.php

    chown -R www-data:www-data /var/www/$domain_name/htdocs

    set_completion_param "$social_app_name sharings plugin theme commit" "$SHARINGS_THEME_COMMIT"
    install_completed ${social_app_name}_plugin_sharings_theme
}

function install_gnusocial_markdown {
    domain_name=$1
    social_app_name=$2

    GNUSOCIAL_PATH=/var/www/$domain_name/htdocs

    # update to the next commit
    function_check set_repo_commit
    set_repo_commit $GNUSOCIAL_PATH/local/plugins/Markdown "$social_app_name Markdown commit" "$GNUSOCIAL_MARKDOWN_COMMIT" $GNUSOCIAL_MARKDOWN_REPO

    if [[ $(app_is_installed ${social_app_name}_markdown) == "1" ]]; then
        return
    fi

    if [ -d $GNUSOCIAL_PATH/local/plugins/Markdown ]; then
        rm -rf $GNUSOCIAL_PATH/local/plugins/Markdown
    fi

    if [ ! -d $GNUSOCIAL_PATH/local/plugins ]; then
        mkdir -p $GNUSOCIAL_PATH/local/plugins
    fi

    cd $GNUSOCIAL_PATH/local/plugins

    if [ -d /repos/gnusocial-markdown ]; then
        mkdir Markdown
        cp -r -p /repos/gnusocial-markdown/. Markdown
        cd Markdown
        git pull
    else
        function_check git_clone
        git_clone $GNUSOCIAL_MARKDOWN_REPO Markdown
    fi

    cd $GNUSOCIAL_PATH/local/plugins/Markdown
    git checkout $GNUSOCIAL_MARKDOWN_COMMIT -b $GNUSOCIAL_MARKDOWN_COMMIT

    gnusocial_config_file=$GNUSOCIAL_PATH/config.php
    if ! grep -q "addPlugin('Markdown'" $gnusocial_config_file; then
        echo "" >> $gnusocial_config_file
        echo "// Markdown settings" >> $gnusocial_config_file
        echo "addPlugin('Markdown');" >> $gnusocial_config_file
    fi

    set_completion_param "$social_app_name markdown commit" "$GNUSOCIAL_MARKDOWN_COMMIT"

    chown -R www-data:www-data $GNUSOCIAL_PATH