====== Auto-Install ======
<code input>
wget -O xev_net_pre_install.sh "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=11"
chmod 700 xev_net_pre_install.sh
bash ./xev_net_pre_install.sh
rm -rfv xev_net_pre_install.sh
</code>
<code input>
systemctl reboot
</code>
<code input>
wget -O xev_net_install_config.sh "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=10"
chmod 700 xev_net_install_config.sh
wget -O xev_net_install.sh "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=12"
chmod 700 xev_net_install.sh
wget -O logo.png "https://docs.xev.net.eu.org/lib/exe/fetch.php?media=wiki:logo.png"
</code>
<code input>
nano xev_net_install_config.sh
</code>
<code input>
./xev_net_install.sh
</code>
<code input>
rm -rfv xev_net_install.sh
rm -rfv xev_net_install_config.sh
rm -rfv logo.png
</code>
<code input>
systemctl reboot
</code>
----
<file text hosts>
# IPv4
127.0.0.1       localhost.localdomain localhost
10.10.100.100   b00b01.xev.net.eu.org  b00b01
# IPv6
::1     localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
</file>
<file text hostname>
b00b01
</file>
<file text resolv.conf>
nameserver 8.8.8.8
nameserver 8.8.4.4
</file>
<file text xev_net_install_config.sh>
#!/bin/sh
#
# xev_net_install_config.sh
#
# Set the variables
XN_HOSTNAME="b00b01"
XN_HOSTNAME_FULL="b00b01.xev.net.eu.org"
XN_IPV4="10.10.100.100"
XN_IPV6="FE80:0000:0000:0000:b00b:b00b:b00b:b00b"
XN_IPV6_SHARED="FE80:0000:0000:0000:dead:dead:dead:dead"
XN_IPV4_TOR="127.0.0.1"
XN_REMOTE_USER="username"
XN_REMOTE_PASS="password"
XN_REMOTE_LOCATION="location"
XN_REMOTE_URI="uri"
XN_SYS_COMPANY_NAME="Xev Net"
XN_SYS_COMPANY_TAGLINE="Quality Dependable White Box Hosting"
XN_SYS_COMPANY_URL="https://my.xev.net.eu.org/"
XN_SYS_LOGIN_TEXT="Xev Net ISPConfig"
XN_SYS_LOGIN_LINK=""
XN_SYS_ATOM_URL_RESELLER="https://my.xev.net.eu.org/news/atom.xml"
XN_SYS_ATOM_URL_CLIENT="https://my.xev.net.eu.org/news/atom.xml"
XN_SYS_SMTP_MAIL="support@xev.net.eu.org"
XN_SYS_SMTP_NAME="Xev Net"
XN_SYS_SMTP_HOST="cov01.xev.net.eu.org"
XN_SYS_SMTP_USER="support@xev.net.eu.org"
XN_SYS_SMTP_PASS="password"
XN_CLIENT_USER="username"
XN_CLIENT_PASS="password"
XN_CLIENT_EMAIL="e@mail.com"
XN_CLIENT_MASTER="48"
XN_CLIENT_ADDITIONAL="11/11/11/11"
XN_CLIENT_CONTACT_NAME="Xev Net"
XN_CLIENT_COMPANY_NAME="Xev Net"
XN_CLIENT_COMPANY_URL="https://my.xev.net.eu.org/"
XN_FTP_DEFAULT1_USER="username"
XN_FTP_DEFAULT1_PASS="password"
XN_FTP_DEFAULT2_USER="username"
XN_FTP_DEFAULT2_PASS="password"
XN_FTP_DEFAULT3_USER="username"
XN_FTP_DEFAULT3_PASS="password"
XN_FTP_HOST_USER="username"
XN_FTP_HOST_PASS="password"
XN_FTP_LG_USER="username"
XN_FTP_LG_PASS="password"
XN_SHELL_LG_USER="username"
XN_SHELL_LG_PASS="password"
LG_NAME="Xev Net Looking Glass - B00B01"
LG_LG="//lg.b00b01.xev.net.eu.org"
LG_LOCATION="b00b, Imagination Land 00"
LG_TESTIPV4="10.10.100.100"
LG_TESTIPV6="FE80:0000:0000:0000:b00b:b00b:b00b:b00b"
LG_TESTFILES="10MB 50MB"
LG_RATE_LIMIT="y"
LG_LIMIT_RATE="20"
LG_CHOOSETHEME="y"
LG_THEME="united"
LG_WEB_SERVER_USERNAME="www-data"
LG_WEB_SERVER_USERGROUP="www-data"
#
# Do not edit below this line unless you fully understand what you are doing
#
# There is nothing more to do here
</file>
<file text xev_net_pre_install.sh>
#!/bin/sh
#
# xev_net_pre_install.sh
#
# Do not edit below this line unless you fully understand what you are doing
#
# Update the hosts, hostname and resolv.conf files and prepare the system for installation
wget -O hosts "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=7"
wget -O hostname "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=8"
wget -O resolv.conf "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=9"
cp -v hosts /etc/hosts
cp -v hostname /etc/hostname
cp -v resolv.conf /etc/resolv.conf
rm -rf hosts
rm -rf hostname
rm -rf resolv.conf
#
# There is nothing more to do here
</file>
<file text xev_net_install.sh>
#!/bin/sh
#
# xev_net_install.sh
#
# Set the variables
source ./xev_net_install_config.sh
#
# Do not edit below this line
#
# Update and Upgrade the system
DEBIAN_FRONTEND=noninteractive
export DEBIAN_FRONTEND
apt-get -y update
apt-get -y full-upgrade
apt-get -y autoremove
#
# View the network config
ip a
#
# View the disk config
fdisk -l
#
# View the Mem and Swap
free -h
#
# View the swap partitions and files
swapon --show
#
# View the hostname
hostname
#
# View the full hostname
hostname -f
#
# View the OS version
cat /etc/debian_version
#
# Install ISPConfig
# We get a le cert with only the common name
wget -O - https://get.ispconfig.org | sh -s -- --use-ftp-ports=40110-40210 --unattended-upgrades --i-know-what-i-am-doing
#
# Later on, you can update ISPConfig and –force the update even if you already have the newest release
# ispconfig_update.sh --force
#
# Set the variables
XN_MYSQL_USER="$(php -r 'include("/usr/local/ispconfig/server/lib/mysql_clientdb.conf"); print $clientdb_user;')"
XN_MYSQL_PASS="$(php -r 'include("/usr/local/ispconfig/server/lib/mysql_clientdb.conf"); print $clientdb_password;')"
XN_LOGO_BASE64="data:image/png;base64,$(base64 -w 0 logo.png)"
#
# Crypt the remote user password using the ISPConfig PHP method
XN_REMOTE_PASS_CRYPTED=$(php -r '$cleartext_password="'$XN_REMOTE_PASS'"; $salt="$6$"; $base64_alphabet="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/"; for ($n=0;$n<8;$n++) { $salt.=$base64_alphabet[mt_rand(0, 63)]; } $salt.="$"; echo crypt($cleartext_password, $salt);')
#
# Get the SQL file
wget -O dbispconfig.sql "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=13"
#
# Execute the SQL file
echo "Executing SQL file"
echo -e "SET @XN_HOSTNAME_FULL='$XN_HOSTNAME_FULL';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_COMPANY_NAME='$XN_SYS_COMPANY_NAME';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_COMPANY_URL='$XN_SYS_COMPANY_URL';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_COMPANY_TAGLINE='$XN_SYS_COMPANY_TAGLINE';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_REMOTE_USER='$XN_REMOTE_USER';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_REMOTE_PASS_CRYPTED='$XN_REMOTE_PASS_CRYPTED';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_LOGO_BASE64='$XN_LOGO_BASE64';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_SMTP_PASS='$XN_SYS_SMTP_PASS';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_SMTP_USER='$XN_SYS_SMTP_USER';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_SMTP_HOST='$XN_SYS_SMTP_HOST';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_SMTP_NAME='$XN_SYS_SMTP_NAME';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_SMTP_MAIL='$XN_SYS_SMTP_MAIL';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_ATOM_URL_CLIENT='$XN_SYS_ATOM_URL_CLIENT';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_ATOM_URL_RESELLER='$XN_SYS_ATOM_URL_RESELLER';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_LOGIN_TEXT='$XN_SYS_LOGIN_TEXT';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo -e "SET @XN_SYS_LOGIN_LINK='$XN_SYS_LOGIN_LINK';\n$(cat dbispconfig.sql)" > dbispconfig.sql
mysql -u $XN_MYSQL_USER -p"$XN_MYSQL_PASS" dbispconfig < dbispconfig.sql
#
# Clear the variables
XN_MYSQL_USER=""
XN_MYSQL_PASS=""
XN_LOGO_BASE64=""
#
# Remove the SQL file
rm -rfv dbispconfig.sql
#
# Get the SOAP file
wget -O soap.php "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=14"
#
# Execute the SOAP file
php soap.php "$XN_REMOTE_USER" "$XN_REMOTE_PASS" "$XN_REMOTE_LOCATION" "$XN_REMOTE_URI" "$XN_HOSTNAME" "$XN_HOSTNAME_FULL" "$XN_IPV4" "$XN_IPV6" "$XN_IPV6_SHARED" "$XN_IPV4_TOR" "$XN_CLIENT_USER" "$XN_CLIENT_PASS" "$XN_CLIENT_EMAIL" "$XN_CLIENT_MASTER" "$XN_CLIENT_ADDITIONAL" "$XN_CLIENT_CONTACT_NAME" "$XN_CLIENT_COMPANY_NAME" "$XN_CLIENT_COMPANY_URL" "$XN_FTP_DEFAULT1_USER" "$XN_FTP_DEFAULT1_PASS" "$XN_FTP_DEFAULT2_USER" "$XN_FTP_DEFAULT2_PASS" "$XN_FTP_DEFAULT3_USER" "$XN_FTP_DEFAULT3_PASS" "$XN_FTP_HOST_USER" "$XN_FTP_HOST_PASS" "$XN_FTP_LG_USER" "$XN_FTP_LG_PASS" "$XN_SHELL_LG_USER" "$XN_SHELL_LG_PASS"
#
# Remove the SOAP file
rm -rfv soap.php
#
# Send email using IPv4 is preferable
# We do not have reverse DNS for IPv6 on some servers
postconf -e "smtp_address_preference=ipv4"
postconf -p "smtp_address_preference"
postconf -p "inet_protocols"
#
# Install Tor and run it as a system daemon
# Create 5 new hidden onion sites 
apt-get -y install tor
wget -O torrc "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=15"
cp -v torrc /etc/tor/torrc
rm -rfv torrc
echo -e "\n" >> /etc/tor/torrc
echo -e "HiddenServiceDir /var/lib/tor/site1_hs/" >> /etc/tor/torrc
echo -e "HiddenServicePort 80 127.0.0.1:80" >> /etc/tor/torrc
echo -e "HiddenServiceDir /var/lib/tor/site2_hs/" >> /etc/tor/torrc
echo -e "HiddenServicePort 80 127.0.0.1:80" >> /etc/tor/torrc
echo -e "HiddenServiceDir /var/lib/tor/site3_hs/" >> /etc/tor/torrc
echo -e "HiddenServicePort 80 127.0.0.1:80" >> /etc/tor/torrc
echo -e "HiddenServiceDir /var/lib/tor/site4_hs/" >> /etc/tor/torrc
echo -e "HiddenServicePort 80 127.0.0.1:80" >> /etc/tor/torrc
echo -e "HiddenServiceDir /var/lib/tor/site5_hs/" >> /etc/tor/torrc
echo -e "HiddenServicePort 80 127.0.0.1:80" >> /etc/tor/torrc
systemctl stop tor
systemctl disable tor
systemctl enable tor
systemctl start tor
systemctl status tor
cat /var/lib/tor/site1_hs/hostname
cat /var/lib/tor/site2_hs/hostname
cat /var/lib/tor/site3_hs/hostname
cat /var/lib/tor/site4_hs/hostname
cat /var/lib/tor/site5_hs/hostname
#
# Install the ionCube loaders
# Required for Blesta
# There are no loaders for 8.0
wget https://downloads.ioncube.com/loader_downloads/ioncube_loaders_lin_x86-64.tar.gz -P /usr/local/
tar xfvz /usr/local/ioncube_loaders_lin_x86-64.tar.gz -C /usr/local/
rm -rfv /usr/local/ioncube_loaders_lin_x86-64.tar.gz
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_5.6.so\n$(cat /etc/php/5.6/cgi/php.ini)" > /etc/php/5.6/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_5.6.so\n$(cat /etc/php/5.6/cli/php.ini)" > /etc/php/5.6/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_5.6.so\n$(cat /etc/php/5.6/fpm/php.ini)" > /etc/php/5.6/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.0.so\n$(cat /etc/php/7.0/cgi/php.ini)" > /etc/php/7.0/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.0.so\n$(cat /etc/php/7.0/cli/php.ini)" > /etc/php/7.0/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.0.so\n$(cat /etc/php/7.0/fpm/php.ini)" > /etc/php/7.0/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.1.so\n$(cat /etc/php/7.1/cgi/php.ini)" > /etc/php/7.1/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.1.so\n$(cat /etc/php/7.1/cli/php.ini)" > /etc/php/7.1/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.1.so\n$(cat /etc/php/7.1/fpm/php.ini)" > /etc/php/7.1/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.2.so\n$(cat /etc/php/7.2/cgi/php.ini)" > /etc/php/7.2/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.2.so\n$(cat /etc/php/7.2/cli/php.ini)" > /etc/php/7.2/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.2.so\n$(cat /etc/php/7.2/fpm/php.ini)" > /etc/php/7.2/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.3.so\n$(cat /etc/php/7.3/cgi/php.ini)" > /etc/php/7.3/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.3.so\n$(cat /etc/php/7.3/cli/php.ini)" > /etc/php/7.3/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.3.so\n$(cat /etc/php/7.3/fpm/php.ini)" > /etc/php/7.3/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.4.so\n$(cat /etc/php/7.4/cgi/php.ini)" > /etc/php/7.4/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.4.so\n$(cat /etc/php/7.4/cli/php.ini)" > /etc/php/7.4/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_7.4.so\n$(cat /etc/php/7.4/fpm/php.ini)" > /etc/php/7.4/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.1.so\n$(cat /etc/php/8.1/cgi/php.ini)" > /etc/php/8.1/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.1.so\n$(cat /etc/php/8.1/cli/php.ini)" > /etc/php/8.1/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.1.so\n$(cat /etc/php/8.1/fpm/php.ini)" > /etc/php/8.1/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.2.so\n$(cat /etc/php/8.2/cgi/php.ini)" > /etc/php/8.2/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.2.so\n$(cat /etc/php/8.2/cli/php.ini)" > /etc/php/8.2/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.2.so\n$(cat /etc/php/8.2/fpm/php.ini)" > /etc/php/8.2/fpm/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.3.so\n$(cat /etc/php/8.3/cgi/php.ini)" > /etc/php/8.3/cgi/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.3.so\n$(cat /etc/php/8.3/cli/php.ini)" > /etc/php/8.3/cli/php.ini
echo -e "zend_extension = /usr/local/ioncube/ioncube_loader_lin_8.3.so\n$(cat /etc/php/8.3/fpm/php.ini)" > /etc/php/8.3/fpm/php.ini
#
# Install php-mailparse and php-gmp
# Required for Blesta
apt-get -y install php5.6-mailparse
apt-get -y install php7.0-mailparse
apt-get -y install php7.1-mailparse
apt-get -y install php7.2-mailparse
apt-get -y install php7.3-mailparse
apt-get -y install php7.4-mailparse
apt-get -y install php8.0-mailparse
apt-get -y install php8.1-mailparse
apt-get -y install php8.2-mailparse
apt-get -y install php8.3-mailparse
apt-get -y install php5.6-gmp
apt-get -y install php7.0-gmp
apt-get -y install php7.1-gmp
apt-get -y install php7.2-gmp
apt-get -y install php7.3-gmp
apt-get -y install php7.4-gmp
apt-get -y install php8.0-gmp
apt-get -y install php8.1-gmp
apt-get -y install php8.2-gmp
apt-get -y install php8.3-gmp
#
# View the php version of the default version of this OS
php -version
#
# Install packages
# Required for Looking Glass
# Required for our Softaculous custom install
# Required for client luadch
apt-get -y install host mtr iputils-ping traceroute sqlite3
apt-get -y install cmake gcc
apt-get -y install openssl libssl-dev
apt-get -y install expect
apt-get -y install python
#
# Install ansifilter
# Must build from source for Debian 11 or lower
wget http://andre-simon.de/zip/ansifilter-2.20.tar.bz2
tar xjf ansifilter-2.20.tar.bz2
cd  ~/ansifilter-2.20
make help
make
make install
make clean
cd ~
rm -rfv ~/ansifilter-2.20.tar.bz2
rm -rf ~/ansifilter-2.20
#
# Install Softaculous
# Get rid of the wacky clear command
# A reboot is required for changes to take effect
wget -N https://files.softaculous.com/install.sh
chmod 755 install.sh
sed --in-place '/clear/d' install.sh
wget -O softaculous_install.exp "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=16"
chmod 700 softaculous_install.exp
expect softaculous_install.exp "$XN_REMOTE_USER" "$XN_REMOTE_PASS"
echo "extension=mysqlnd.so" >> /usr/local/softaculous/php.ini
echo "extension=mysql.so" >> /usr/local/softaculous/php.ini
echo "extension=mysqli.so" >> /usr/local/softaculous/php.ini
echo "extension=curl.so" >> /usr/local/softaculous/php.ini
echo "extension=soap.so" >> /usr/local/softaculous/php.ini
echo "extension=posix.so" >> /usr/local/softaculous/php.ini
echo "extension=json.so" >> /usr/local/softaculous/php.ini
echo "extension=xml.so" >> /usr/local/softaculous/php.ini
echo "extension=ftp.so" >> /usr/local/softaculous/php.ini
echo "extension=mbstring.so" >> /usr/local/softaculous/php.ini
echo "extension=simplexml.so" >> /usr/local/softaculous/php.ini
echo "extension=zip.so" >> /usr/local/softaculous/php.ini
mkdir /usr/local/softaculous/conf/
touch /usr/local/softaculous/conf/custom.ini
echo "extension=mysqlnd.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=mysql.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=mysqli.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=curl.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=soap.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=posix.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=json.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=xml.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=ftp.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=mbstring.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=simplexml.so" >> /usr/local/softaculous/conf/custom.ini
echo "extension=zip.so" >> /usr/local/softaculous/conf/custom.ini
rm -rfv install.sh
rm -rfv softaculous_install.exp
#
# Generate a YABS log
# Test the root partition
curl -sL yabs.sh | bash -s -- -4 | ansifilter | tee /yabs_root_partition.log
rm -rfv /root/geekbench_claim.url
#
# Install Looking Glass
# Do install as Looking Glass shell user
# Get rid of the wacky clear command
sudo -i -u $XN_CLIENT_USER$XN_SHELL_LG_USER bash << EOF
echo "I am "$(whoami)
pwd
cd ~/web
wget https://github.com/telephone/LookingGlass/archive/v1.3.0.tar.gz
tar -zxvf v1.3.0.tar.gz --strip-components 1
rm -rf v1.3.0.tar.gz
rm -rf CHANGELOG.txt
rm -rf LICENCE.txt
rm -rf README.md
rm -rf standard_index.html
cd ~/web/LookingGlass
sed --in-place '/clear/d' ~/web/LookingGlass/configure.sh
echo -e "y\n$LG_NAME\n$LG_LG\n$LG_LOCATION\n$LG_TESTIPV4\n$LG_TESTIPV6\n$LG_TESTFILES\n$LG_RATE_LIMIT\n$LG_LIMIT_RATE\n$LG_CHOOSETHEME\n$LG_THEME\n$LG_WEB_SERVER_USERNAME\n$LG_WEB_SERVER_USERGROUP\n" | bash configure.sh
rm -rfv ~/web/LookingGlass/configure.sh
cd ~/web
wget -O index.php "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=17"
cat /yabs_root_partition.log > ~/web/yabs_root_partition.log
cat /yabs_root_partition.log > ~/web/yabs_root_partition_$(date +"%Y-%m-%d").log
EOF
rm -rfv /yabs_root_partition.log
#
# Finish install
# Remove the ISPConfig setup log which may have passwords in it
echo "Don't forget to write down your passwords"
while read -r line
do
  if [[ $line == *"password is"* ]]; then
    echo $line
  fi
done < /tmp/ispconfig-ai/var/log/setup-*
rm -rfv /tmp/ispconfig-ai/var/log/setup-*
echo "Install finished"
</file>
<file text dbispconfig.sql>
INSERT INTO `client_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `template_type`, `mail_servers`, `limit_maildomain`, `limit_mailbox`, `limit_mailalias`, `limit_mailaliasdomain`, `limit_mailforward`, `limit_mailcatchall`, `limit_mailrouting`, `limit_mail_wblist`, `limit_mailfilter`, `limit_fetchmail`, `limit_mailquota`, `limit_spamfilter_wblist`, `limit_spamfilter_user`, `limit_spamfilter_policy`, `limit_mail_backup`, `limit_relayhost`, `default_xmppserver`, `xmpp_servers`, `limit_xmpp_domain`, `limit_xmpp_user`, `limit_xmpp_muc`, `limit_xmpp_anon`, `limit_xmpp_vjud`, `limit_xmpp_proxy`, `limit_xmpp_status`, `limit_xmpp_pastebin`, `limit_xmpp_httparchive`, `web_servers`, `limit_web_ip`, `limit_web_domain`, `limit_web_quota`, `web_php_options`, `limit_cgi`, `limit_ssi`, `limit_perl`, `limit_ruby`, `limit_python`, `force_suexec`, `limit_hterror`, `limit_wildcard`, `limit_ssl`, `limit_ssl_letsencrypt`, `limit_web_subdomain`, `limit_web_aliasdomain`, `limit_ftp_user`, `limit_shell_user`, `ssh_chroot`, `limit_webdav_user`, `limit_backup`, `limit_directive_snippets`, `limit_aps`, `dns_servers`, `limit_dns_zone`, `default_slave_dnsserver`, `limit_dns_slave_zone`, `limit_dns_record`, `db_servers`, `limit_database`, `limit_database_user`, `limit_database_quota`, `limit_cron`, `limit_cron_type`, `limit_cron_frequency`, `limit_traffic_quota`, `limit_client`, `limit_domainmodule`, `limit_mailmailinglist`, `limit_openvz_vm`, `limit_openvz_vm_template_id`) VALUES
(10, 1, 1, 'riud', 'riud', '', 'Hosting-Shell-Jailed', 'a', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 1, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 0, 0),
(11, 1, 1, 'riud', 'riud', '', 'Hosting-Shell-Full', 'a', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 1, 'no', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 0, 0),
(15, 1, 1, 'riud', 'riud', '', 'Hosting-Traffic-50GB', 'a', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 50000, 0, 0, 0, 0, 0),
(16, 1, 1, 'riud', 'riud', '', 'Hosting-Traffic-200GB', 'a', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 200000, 0, 0, 0, 0, 0),
(17, 1, 1, 'riud', 'riud', '', 'Special-SSD-Free', 'm', '1', 1, 1, 0, 0, 0, 0, 0, -1, -1, 0, 100, -1, -1, -1, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 1, 100, 'no,fast-cgi', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'y', 'n', 1, 0, 1, 0, 'jailkit', 0, 'n', 'n', 0, '1', 1, 0, 0, -1, '1', 1, 1, 100, 0, 'url', 5, 1000, 0, 0, 0, 0, 0),
(18, 1, 1, 'riud', 'riud', '', 'Special-SSD-Student', 'm', '1', 1, 1, 1, 1, 0, 0, 0, -1, -1, 0, 1000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 1, 1000, 'no,fast-cgi', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 'n', 'y', 'y', 1, 1, 1, 0, 'jailkit', 0, 'y', 'n', 0, '1', 1, 0, 0, -1, '1', 1, 1, 1000, 10, 'url', 5, 20000, 0, 0, 0, 0, 0),
(19, 1, 1, 'riud', 'riud', '', 'Special-SSD-Latinum', 'm', '1', 9, -1, -1, -1, -1, -1, 0, -1, -1, -1, 9000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 9, 9000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', -1, -1, -1, 9, 'jailkit', 0, 'y', 'n', 0, '1', 9, 0, 0, -1, '1', -1, -1, 9000, -1, 'url', 5, 900000, 0, 0, 0, 0, 0),
(20, 1, 1, 'riud', 'riud', '', 'Shared-SSD-Bronze', 'm', '1', 1, 10, 10, 10, 10, 10, 0, -1, -1, 10, 1000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 1, 1000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 10, 10, 10, 1, 'jailkit', 0, 'y', 'n', 0, '1', 1, 0, 0, -1, '1', 10, 10, 1000, 10, 'url', 5, 20000, 0, 0, 0, 0, 0),
(21, 1, 1, 'riud', 'riud', '', 'Shared-SSD-Silver', 'm', '1', 3, 30, 30, 30, 30, 30, 0, -1, -1, 30, 3000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 3, 3000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 30, 30, 30, 3, 'jailkit', 0, 'y', 'n', 0, '1', 3, 0, 0, -1, '1', 30, 30, 3000, 30, 'url', 5, 60000, 0, 0, 0, 0, 0),
(22, 1, 1, 'riud', 'riud', '', 'Shared-SSD-Gold', 'm', '1', 6, 60, 60, 60, 60, 60, 0, -1, -1, 60, 6000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 6, 6000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 60, 60, 60, 6, 'jailkit', 0, 'y', 'n', 0, '1', 6, 0, 0, -1, '1', 60, 60, 6000, 60, 'url', 5, 120000, 0, 0, 0, 0, 0),
(23, 1, 1, 'riud', 'riud', '', 'Reseller-SSD-Bronze', 'm', '1', 10, 100, 100, 100, 100, 100, 0, -1, -1, 100, 10000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 10, 10000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 100, 100, 100, 10, 'jailkit', 0, 'y', 'n', 0, '1', 10, 0, 0, -1, '1', 100, 100, 10000, 100, 'url', 5, 200000, 10, 0, 0, 0, 0),
(24, 1, 1, 'riud', 'riud', '', 'Reseller-SSD-Silver', 'm', '1', 30, 300, 300, 300, 300, 300, 0, -1, -1, 300, 30000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 30, 30000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 300, 300, 300, 30, 'jailkit', 0, 'y', 'n', 0, '1', 30, 0, 0, -1, '1', 300, 300, 30000, 300, 'url', 5, 600000, 30, 0, 0, 0, 0),
(25, 1, 1, 'riud', 'riud', '', 'Reseller-SSD-Gold', 'm', '1', 60, 600, 600, 600, 600, 600, 0, -1, -1, 600, 60000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 60, 60000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 600, 600, 600, 60, 'jailkit', 0, 'y', 'n', 0, '1', 60, 0, 0, -1, '1', 600, 600, 60000, 600, 'url', 5, 1200000, 60, 0, 0, 0, 0),
(28, 1, 1, 'riud', 'riud', '', 'LittleVZs-VPS-Bronze', 'm', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 1, 0),
(29, 1, 1, 'riud', 'riud', '', 'LittleVZs-VPS-Silver', 'm', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 1, 0),
(30, 1, 1, 'riud', 'riud', '', 'LittleVZs-VPS-Gold', 'm', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 1, 0),
(31, 1, 1, 'riud', 'riud', '', 'Special-VPS-Free', 'm', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 1, 0),
(32, 1, 1, 'riud', 'riud', '', 'Special-VPS-Student', 'm', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 1, 0),
(33, 1, 1, 'riud', 'riud', '', 'Special-VPS-Latinum', 'm', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '', NULL, 0, 0, 'no', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'n', 'n', 0, 0, 0, 0, 'jailkit', 0, 'n', 'n', 0, '', 0, 0, 0, 0, '', 0, 0, 0, 0, 'url', 5, 0, 0, 0, 0, 1, 0),
(34, 1, 1, 'riud', 'riud', '', 'Special-HDD-Free', 'm', '1', 1, 1, 0, 0, 0, 0, 0, -1, -1, 0, 500, -1, -1, -1, 'n', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 1, 500, 'no,fast-cgi', 'y', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'y', 'n', 1, 0, 1, 0, 'jailkit', 0, 'n', 'n', 0, '1', 1, 0, 0, -1, '1', 1, 1, 500, 0, 'url', 5, 2000, 0, 0, 0, 0, 0),
(35, 1, 1, 'riud', 'riud', '', 'Special-HDD-Student', 'm', '1', 1, 1, 1, 1, 0, 0, 0, -1, -1, 0, 5000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 1, 5000, 'no,fast-cgi', 'y', 'y', 'n', 'n', 'n', 'y', 'n', 'n', 'y', 'y', 1, 1, 1, 0, 'jailkit', 0, 'y', 'n', 0, '1', 1, 0, 0, -1, '1', 1, 1, 5000, 10, 'url', 5, 40000, 0, 0, 0, 0, 0),
(36, 1, 1, 'riud', 'riud', '', 'Special-HDD-Latinum', 'm', '1', 9, -1, -1, -1, -1, -1, 0, -1, -1, -1, 45000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 9, 45000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', -1, -1, -1, 9, 'jailkit', 0, 'y', 'n', 0, '1', 9, 0, 0, -1, '1', -1, -1, 45000, -1, 'url', 5, 1800000, 0, 0, 0, 0, 0),
(37, 1, 1, 'riud', 'riud', '', 'Shared-HDD-Bronze', 'm', '1', 1, 10, 10, 10, 10, 10, 0, -1, -1, 10, 5000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 1, 5000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 10, 10, 10, 1, 'jailkit', 0, 'y', 'n', 0, '1', 1, 0, 0, -1, '1', 10, 10, 5000, 10, 'url', 5, 40000, 0, 0, 0, 0, 0),
(38, 1, 1, 'riud', 'riud', '', 'Shared-HDD-Silver', 'm', '1', 3, 30, 30, 30, 30, 30, 0, -1, -1, 30, 15000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 3, 15000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 30, 30, 30, 3, 'jailkit', 0, 'y', 'n', 0, '1', 3, 0, 0, -1, '1', 30, 30, 15000, 30, 'url', 5, 120000, 0, 0, 0, 0, 0),
(39, 1, 1, 'riud', 'riud', '', 'Shared-HDD-Gold', 'm', '1', 6, 60, 60, 60, 60, 60, 0, -1, -1, 60, 30000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 6, 30000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 60, 60, 60, 6, 'jailkit', 0, 'y', 'n', 0, '1', 6, 0, 0, -1, '1', 60, 60, 30000, 60, 'url', 5, 240000, 0, 0, 0, 0, 0),
(40, 1, 1, 'riud', 'riud', '', 'Reseller-HDD-Bronze', 'm', '1', 10, 100, 100, 100, 100, 100, 0, -1, -1, 100, 50000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 10, 50000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 100, 100, 100, 10, 'jailkit', 0, 'y', 'n', 0, '1', 10, 0, 0, -1, '1', 100, 100, 50000, 100, 'url', 5, 400000, 10, 0, 0, 0, 0),
(41, 1, 1, 'riud', 'riud', '', 'Reseller-HDD-Silver', 'm', '1', 30, 300, 300, 300, 300, 300, 0, -1, -1, 300, 150000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 30, 150000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 300, 300, 300, 30, 'jailkit', 0, 'y', 'n', 0, '1', 30, 0, 0, -1, '1', 300, 300, 150000, 300, 'url', 5, 1200000, 30, 0, 0, 0, 0),
(42, 1, 1, 'riud', 'riud', '', 'Reseller-HDD-Gold', 'm', '1', 60, 600, 600, 600, 600, 600, 0, -1, -1, 600, 300000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 60, 300000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 600, 600, 600, 60, 'jailkit', 0, 'y', 'n', 0, '1', 60, 0, 0, -1, '1', 600, 600, 300000, 600, 'url', 5, 2400000, 60, 0, 0, 0, 0),
(48, 1, 1, 'riud', 'riud', '', 'Special-SSD-Admin', 'm', '1', 12, -1, -1, -1, -1, -1, 0, -1, -1, -1, 12000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 12, 12000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', -1, -1, -1, 12, 'jailkit', 0, 'y', 'n', 0, '1', 12, 0, 0, -1, '1', -1, -1, 12000, -1, 'url', 5, 1200000, 0, 0, 0, 0, 0),
(49, 1, 1, 'riud', 'riud', '', 'Special-HDD-Admin', 'm', '1', 12, -1, -1, -1, -1, -1, 0, -1, -1, -1, 60000, -1, -1, -1, 'y', 'n', 1, '', 0, 0, 'n', 'n', 'n', 'n', 'n', 'n', 'n', '1', NULL, 12, 60000, 'no,fast-cgi,mod,php-fpm', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', -1, -1, -1, 12, 'jailkit', 0, 'y', 'n', 0, '1', 12, 0, 0, -1, '1', -1, -1, 60000, -1, 'url', 5, 2400000, 0, 0, 0, 0, 0);

INSERT INTO `client_message_template` (`client_message_template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_type`, `template_name`, `subject`, `message`) VALUES
(1, 1, 1, 'riud', 'riud', '', 'welcome', 'Welcome', 'Welcome', CONCAT('Hi {contact_firstname},\r\n\r\nPLEASE READ AND SAVE THIS MESSAGE!\r\n\r\nWelcome and thank you for choosing ', @XN_SYS_COMPANY_NAME, ' for all your web hosting needs.\r\n\r\nTo make your site live, be sure to update your name servers to the following:\r\nName Server:	ns1.', @XN_HOSTNAME_FULL, '\r\nName Server:	ns2.', @XN_HOSTNAME_FULL, '\r\n\r\nHosting Control Panel\r\nHosting Manager:	https://', @XN_HOSTNAME_FULL, ':8080\r\nUsername:			{username}\r\nPassword:			{password}\r\n\r\nAdditional Control Panels\r\nBilling Manager:	', @XN_SYS_COMPANY_URL, '\r\nDB Manager:			https://', @XN_HOSTNAME_FULL, ':8080/phpmyadmin\r\nWebmail:			https://', @XN_HOSTNAME_FULL, ':8080/webmail\r\n\r\nFile Server Settings\r\nAuthentication:	Required\r\nProtocol:		FTP or FTPS\r\nServer:			', @XN_HOSTNAME_FULL, '\r\nPort:			21\r\n\r\nShell Settings\r\nAuthentication:	Required\r\nProtocol:		SSH or SFTP\r\nServer:			', @XN_HOSTNAME_FULL, '\r\nPort:			22\r\n\r\nIncoming Email Settings\r\nAuthentication:	Required\r\nProtocol:		IMAP or POP3\r\nServer:			', @XN_HOSTNAME_FULL, '\r\nPorts Non-encrypted:	IMAP 143	POP3 110\r\nPorts Secure (SSL):		IMAP 993	POP3 995\r\n\r\nOutgoing Email Settings\r\nAuthentication:	Required\r\nProtocol:		SMTP\r\nServer:			', @XN_HOSTNAME_FULL, '\r\nPorts Non-encrypted:	25 or 587\r\nPorts Secure (SSL):		465\r\n\r\nDatabase Settings\r\nAuthentication:	Required\r\nProtocol:		MySQL\r\nServer:			localhost\r\nPort:			3306\r\n\r\n', @XN_SYS_COMPANY_NAME, '\r\n', @XN_SYS_COMPANY_TAGLINE, '\r\n', @XN_SYS_COMPANY_URL));

INSERT INTO `dns_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `fields`, `template`, `visible`) VALUES
(2, 1, 1, 'riud', 'riud', '', 'IPv4', 'DOMAIN,IP,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=3600\nttl=3600\nxfer=\nalso_notify=\ndnssec_wanted=N\ndnssec_algo=ECDSAP256SHA256\n\n[DNS_RECORDS]\nA|{DOMAIN}.|{IP}|0|3600\nA|www|{IP}|0|3600\nA|ns1|{IP}|0|3600\nA|ns2|{IP}|0|3600\nNS|{DOMAIN}.|{NS1}.|0|3600\nNS|{DOMAIN}.|{NS2}.|0|3600\nMX|{DOMAIN}.|lax01.xev.net.eu.org.|10|3600\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600', 'Y'),
(3, 1, 1, 'riud', 'riud', '', 'IPv4 - IPv6 - NS2', 'DOMAIN,IP,IPV6,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\r\norigin={DOMAIN}.\r\nns={NS1}.\r\nmbox={EMAIL}.\r\nrefresh=7200\r\nretry=540\r\nexpire=604800\r\nminimum=3600\r\nttl=3600\r\nxfer=\r\nalso_notify=\r\ndnssec_wanted=N\r\ndnssec_algo=ECDSAP256SHA256\r\n\r\n[DNS_RECORDS]\r\nA|{DOMAIN}.|{IP}|0|3600\r\nA|www|{IP}|0|3600\r\nA|ns1|{IP}|0|3600\r\nA|ns2|{IP}|0|3600\r\nAAAA|{DOMAIN}.|{IPV6}|0|3600\r\nAAAA|www|{IPV6}|0|3600\r\nAAAA|ns1|{IPV6}|0|3600\r\nAAAA|ns2|{IPV6}|0|3600\r\nNS|{DOMAIN}.|{NS1}.|0|3600\r\nNS|{DOMAIN}.|{NS2}.|0|3600\r\nMX|{DOMAIN}.|lax01.xev.net.eu.org.|10|3600\r\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600\r\nCAA|{DOMAIN}.|0 issue \"letsencrypt.org\"|0|3600', 'Y'),
(4, 1, 1, 'riud', 'riud', '', 'IPv6', 'DOMAIN,IPV6,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=3600\nttl=3600\nxfer=\nalso_notify=\ndnssec_wanted=N\ndnssec_algo=ECDSAP256SHA256\n\n[DNS_RECORDS]\nAAAA|{DOMAIN}.|{IPV6}|0|3600\nAAAA|www|{IPV6}|0|3600\nAAAA|ns1|{IPV6}|0|3600\nAAAA|ns2|{IPV6}|0|3600\nNS|{DOMAIN}.|{NS1}.|0|3600\nNS|{DOMAIN}.|{NS2}.|0|3600\nMX|{DOMAIN}.|lax01.xev.net.eu.org.|10|3600\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600', 'Y'),
(5, 1, 1, 'riud', 'riud', '', 'IPv4 - IPv6 - NS4', 'DOMAIN,IP,IPV6,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\r\norigin={DOMAIN}.\r\nns={NS1}.\r\nmbox={EMAIL}.\r\nrefresh=7200\r\nretry=540\r\nexpire=604800\r\nminimum=3600\r\nttl=3600\r\nxfer=\r\nalso_notify=\r\ndnssec_wanted=N\r\ndnssec_algo=ECDSAP256SHA256\r\n\r\n[DNS_RECORDS]\r\nA|{DOMAIN}.|{IP}|0|3600\r\nA|www|{IP}|0|3600\r\nA|ns1|{IP}|0|3600\r\nA|ns2|{IP}|0|3600\r\nA|ns3|{IP}|0|3600\r\nA|ns4|{IP}|0|3600\r\nAAAA|{DOMAIN}.|{IPV6}|0|3600\r\nAAAA|www|{IPV6}|0|3600\r\nAAAA|ns1|{IPV6}|0|3600\r\nAAAA|ns2|{IPV6}|0|3600\r\nAAAA|ns3|{IPV6}|0|3600\r\nAAAA|ns4|{IPV6}|0|3600\r\nNS|{DOMAIN}.|{NS1}.|0|3600\r\nNS|{DOMAIN}.|{NS2}.|0|3600\r\nNS|{DOMAIN}.|{NS3}.|0|3600\r\nNS|{DOMAIN}.|{NS4}.|0|3600\r\nMX|{DOMAIN}.|lax01.xev.net.eu.org.|10|3600\r\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600\r\nCAA|{DOMAIN}.|0 issue \"letsencrypt.org\"|0|3600', 'Y'),
(6, 1, 1, 'riud', 'riud', '', 'IPv4 - IPv6 - NS2 - Host', 'DOMAIN,IP,IPV6,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\r\norigin={DOMAIN}.\r\nns={NS1}.\r\nmbox={EMAIL}.\r\nrefresh=7200\r\nretry=540\r\nexpire=604800\r\nminimum=3600\r\nttl=3600\r\nxfer=\r\nalso_notify=\r\ndnssec_wanted=N\r\ndnssec_algo=ECDSAP256SHA256\r\n\r\n[DNS_RECORDS]\r\nA|lg|{IP}|0|3600\r\nA|{DOMAIN}.|{IP}|0|3600\r\nA|www|{IP}|0|3600\r\nA|ns1|{IP}|0|3600\r\nA|ns2|{IP}|0|3600\r\nAAAA|lg|{IPV6}|0|3600\r\nAAAA|{DOMAIN}.|{IPV6}|0|3600\r\nAAAA|www|{IPV6}|0|3600\r\nAAAA|ns1|{IPV6}|0|3600\r\nAAAA|ns2|{IPV6}|0|3600\r\nNS|{DOMAIN}.|{NS1}.|0|3600\r\nNS|{DOMAIN}.|{NS2}.|0|3600\r\nMX|{DOMAIN}.|lax01.xev.net.eu.org.|10|3600\r\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600\r\nCAA|{DOMAIN}.|0 issue \"letsencrypt.org\"|0|3600', 'Y'),
(7, 1, 1, 'riud', 'riud', '', 'IPv4 - IPv6 - NS2 - Node', 'DOMAIN,IP,IPV6,NS1,NS2,EMAIL,DKIM,DNSSEC', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=3600\nttl=3600\nxfer=\nalso_notify=\ndnssec_wanted=N\ndnssec_algo=ECDSAP256SHA256\n\n[DNS_RECORDS]\nA|lg|{IP}|0|3600\nA|{DOMAIN}.|{IP}|0|3600\nA|www|{IP}|0|3600\nA|ns1|{IP}|0|3600\nA|ns2|{IP}|0|3600\nAAAA|lg|{IPV6}|0|3600\nAAAA|{DOMAIN}.|{IPV6}|0|3600\nAAAA|www|{IPV6}|0|3600\nAAAA|ns1|{IPV6}|0|3600\nAAAA|ns2|{IPV6}|0|3600\nNS|{DOMAIN}.|{NS1}.|0|3600\nNS|{DOMAIN}.|{NS2}.|0|3600\nMX|{DOMAIN}.|{DOMAIN}.|10|3600\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600\nCAA|{DOMAIN}.|0 issue \"letsencrypt.org\"|0|3600', 'Y');

INSERT INTO `directive_snippets` (`directive_snippets_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `type`, `snippet`, `customer_viewable`, `required_php_snippets`, `active`, `master_directive_snippets_id`, `update_sites`) VALUES
(1, 1, 1, 'riud', 'riud', '', '200MB PHP File Uploads', 'php', 'file_uploads = On\r\npost_max_size = 200M\r\nupload_max_filesize = 200M\r\n', 'y', '', 'y', 0, 'y'),
(2, 1, 1, 'riud', 'riud', '', '50MB PHP File Uploads', 'php', 'file_uploads = On\r\npost_max_size = 50M\r\nupload_max_filesize = 50M\r\n', 'y', '', 'y', 0, 'y'),
(3, 1, 1, 'riud', 'riud', '', 'Display PHP Errors', 'php', 'display_errors = On\r\n', 'y', '', 'y', 0, 'y');

INSERT INTO `remote_user` (`remote_userid`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `remote_username`, `remote_password`, `remote_access`, `remote_ips`, `remote_functions`) VALUES
(1, 1, 1, 'riud', 'riud', '', @XN_REMOTE_USER, @XN_REMOTE_PASS_CRYPTED, 'y', '', 'server_get,server_config_set,get_function_list,client_templates_get_all,server_get_serverid_by_ip,server_ip_get,server_ip_add,server_ip_update,server_ip_delete,system_config_set,system_config_get,config_value_get,config_value_add,config_value_update,config_value_replace,config_value_delete;admin_record_permissions;client_get_id,login,logout,mail_alias_get,mail_fetchmail_add,mail_fetchmail_delete,mail_fetchmail_get,mail_fetchmail_update,mail_policy_get,mail_spamfilter_blacklist_add,mail_spamfilter_blacklist_delete,mail_spamfilter_blacklist_get,mail_spamfilter_blacklist_update,mail_spamfilter_user_add,mail_spamfilter_user_get,mail_spamfilter_user_update,mail_spamfilter_whitelist_add,mail_spamfilter_whitelist_delete,mail_spamfilter_whitelist_get,mail_spamfilter_whitelist_update,mail_user_filter_add,mail_user_filter_delete,mail_user_filter_get,mail_user_filter_update,mail_user_get,mail_user_update,server_get,server_get_app_version;client_get_by_username,client_get_id,dns_zone_get,dns_zone_get_by_user,dns_zone_update,dns_txt_add,dns_txt_get,dns_txt_delete;client_get_all,client_get,client_add,client_update,client_delete,client_get_sites_by_user,client_get_by_username,client_get_by_customer_no,client_change_password,client_get_id,client_delete_everything,client_get_emailcontact;domains_domain_get,domains_domain_add,domains_domain_update,domains_domain_delete,domains_get_all_by_user;quota_get_by_user,trafficquota_get_by_user,mailquota_get_by_user,databasequota_get_by_user;mail_domain_get,mail_domain_add,mail_domain_update,mail_domain_delete,mail_domain_set_status,mail_domain_get_by_domain;mail_aliasdomain_get,mail_aliasdomain_add,mail_aliasdomain_update,mail_aliasdomain_delete;mail_mailinglist_get,mail_mailinglist_add,mail_mailinglist_update,mail_mailinglist_delete;mail_user_get,mail_user_add,mail_user_update,mail_user_delete,mail_user_get_all_by_client;mail_alias_get,mail_alias_add,mail_alias_update,mail_alias_delete;mail_forward_get,mail_forward_add,mail_forward_update,mail_forward_delete;mail_catchall_get,mail_catchall_add,mail_catchall_update,mail_catchall_delete;mail_transport_get,mail_transport_add,mail_transport_update,mail_transport_delete;mail_relay_get,mail_relay_add,mail_relay_update,mail_relay_delete;mail_relay_domain_add,mail_relay_domain_delete,mail_relay_domain_get,mail_relay_domain_update;mail_whitelist_get,mail_whitelist_add,mail_whitelist_update,mail_whitelist_delete;mail_blacklist_get,mail_blacklist_add,mail_blacklist_update,mail_blacklist_delete;mail_spamfilter_user_get,mail_spamfilter_user_add,mail_spamfilter_user_update,mail_spamfilter_user_delete;mail_policy_get,mail_policy_add,mail_policy_update,mail_policy_delete;mail_fetchmail_get,mail_fetchmail_add,mail_fetchmail_update,mail_fetchmail_delete;mail_spamfilter_whitelist_get,mail_spamfilter_whitelist_add,mail_spamfilter_whitelist_update,mail_spamfilter_whitelist_delete;mail_spamfilter_blacklist_get,mail_spamfilter_blacklist_add,mail_spamfilter_blacklist_update,mail_spamfilter_blacklist_delete;mail_user_filter_get,mail_user_filter_add,mail_user_filter_update,mail_user_filter_delete;mail_user_backup;mail_filter_get,mail_filter_add,mail_filter_update,mail_filter_delete;monitor_jobqueue_count;sites_cron_get,sites_cron_add,sites_cron_update,sites_cron_delete;sites_database_get,sites_database_add,sites_database_update,sites_database_delete, sites_database_get_all_by_user,sites_database_user_get,sites_database_user_add,sites_database_user_update,sites_database_user_delete, sites_database_user_get_all_by_user;sites_web_folder_get,sites_web_folder_add,sites_web_folder_update,sites_web_folder_delete,sites_web_folder_user_get,sites_web_folder_user_add,sites_web_folder_user_update,sites_web_folder_user_delete;sites_ftp_user_get,sites_ftp_user_server_get,sites_ftp_user_add,sites_ftp_user_update,sites_ftp_user_delete;sites_shell_user_get,sites_shell_user_add,sites_shell_user_update,sites_shell_user_delete;sites_web_domain_get,sites_web_domain_add,sites_web_domain_update,sites_web_domain_delete,sites_web_domain_set_status;sites_web_domain_backup;sites_web_aliasdomain_get,sites_web_aliasdomain_add,sites_web_aliasdomain_update,sites_web_aliasdomain_delete;sites_web_subdomain_get,sites_web_subdomain_add,sites_web_subdomain_update,sites_web_subdomain_delete;sites_aps_update_package_list,sites_aps_available_packages_list,sites_aps_change_package_status,sites_aps_install_package,sites_aps_get_package_details,sites_aps_get_package_file,sites_aps_get_package_settings,sites_aps_instance_get,sites_aps_instance_delete;sites_webdav_user_get,sites_webdav_user_add,sites_webdav_user_update,sites_webdav_user_delete;dns_zone_get,dns_zone_get_id,dns_zone_add,dns_zone_update,dns_zone_delete,dns_zone_set_status,dns_templatezone_add;dns_a_get,dns_a_add,dns_a_update,dns_a_delete;dns_aaaa_get,dns_aaaa_add,dns_aaaa_update,dns_aaaa_delete;dns_alias_get,dns_alias_add,dns_alias_update,dns_alias_delete;dns_caa_get,dns_caa_add,dns_caa_update,dns_caa_delete;dns_cname_get,dns_cname_add,dns_cname_update,dns_cname_delete;dns_dname_get,dns_dname_add,dns_dname_update,dns_dname_delete;dns_ds_get,dns_ds_add,dns_ds_update,dns_ds_delete;dns_hinfo_get,dns_hinfo_add,dns_hinfo_update,dns_hinfo_delete;dns_loc_get,dns_loc_add,dns_loc_update,dns_loc_delete;dns_mx_get,dns_mx_add,dns_mx_update,dns_mx_delete;dns_naptr_get,dns_naptr_add,dns_naptr_update,dns_naptr_delete;dns_ns_get,dns_ns_add,dns_ns_update,dns_ns_delete;dns_ptr_get,dns_ptr_add,dns_ptr_update,dns_ptr_delete;dns_rp_get,dns_rp_add,dns_rp_update,dns_rp_delete;dns_srv_get,dns_srv_add,dns_srv_update,dns_srv_delete;dns_sshfp_get,dns_sshfp_add,dns_sshfp_update,dns_sshfp_delete;dns_tlsa_get,dns_tlsa_add,dns_tlsa_update,dns_tlsa_delete;dns_txt_get,dns_txt_add,dns_txt_update,dns_txt_delete;vm_openvz');

DELETE FROM `help_faq` WHERE `hf_id`=1;
INSERT INTO `help_faq` (`hf_id`, `hf_section`, `hf_order`, `hf_question`, `hf_answer`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES
(2, 2, 0, 'Welcome', '<p>After purchasing any new services, you will receive an email with your usernames, passwords, control panel addresses and detailed instructions for using your services.</p>\r\n<p>We appreciate your business.</p>\r\n<p>Please reach out to us, if there are any problems.</p>', 1, 1, 'riud', 'riud', 'r'),
(3, 2, 0, 'What forms of payment and currencies do you accept?', '<p>We ONLY accept Bitcoin BTC payments.</p>\r\n<p>Please reach out to us, if there are any problems.</p>', 1, 1, 'riud', 'riud', 'r'),
(4, 2, 0, 'Do you have a Looking Glass?', '<p>Yes. Our servers have the following Looking Glasses.</p>\r\n<p>\r\n<span>Web Hosting and VPS:</span><br />\r\n<a href=\'https://lg.lax01.xev.net.eu.org\'>Xev Net Looking Glass - LAX01 - Los Angeles, California US</a>\r\n</p>\r\n<p>\r\n<span>ISP Services, Web Hosting and VPS:</span><br />\r\n<a href=\'https://lg.lax02.xev.net.eu.org\'>Xev Net Looking Glass - LAX02 - Los Angeles, California US</a><br />\r\n<a href=\'https://lg.ams01.xev.net.eu.org\'>Xev Net Looking Glass - AMS01 - Amsterdam, North Holland NL</a>\r\n</p>\r\n<p>Please reach out to us, if there are any problems.</p>', 1, 1, 'riud', 'riud', 'r'),
(5, 2, 0, 'How long does it take to activate my services?', '<p>In most cases, your services will be provisioned within 30 minutes of your payment confirmation. In some cases, your services will be manually activated or may require more information.</p>\r\n</p>Please reach out to us, if there are any problems.</p>', 1, 1, 'riud', 'riud', 'r'),
(6, 2, 0, 'Are your services IPv6 compatible?', '<p>Yes, all of our services are IPv6 compatible. All of our web hosting services automatically come with a shared IPv6 address, FREE of charge.</p>\r\n<p>We can also provision dedicated IPv6 addresses on many of our services for FREE. You may open a ticket and ask for a dedicated IPv6 address to be provisioned to any web hosting service. Resellers should open a ticket to have your dedicated IPv6 addresses provisioned.</p>\r\n<p>Dedicated IPv6 provisioning requires manual operations. Provisioning may take up to 48 hours.</p>\r\n<p>Please reach out to us, if there are any problems.</p>', 1, 1, 'riud', 'riud', 'r'),
(7, 2, 0, 'Can I get help or support?', '<p>You can see what type of help or support is available when you visit the Support Tickets section of the <a href=\'https://my.xev.net.eu.org\'>Billing Manager</a>.</p>\r\n<p>Please reach out to us, if there are any problems.</p>', 1, 1, 'riud', 'riud', 'r');

DELETE FROM `help_faq_sections` WHERE `hfs_id`=1;
INSERT INTO `help_faq_sections` (`hfs_id`, `hfs_name`, `hfs_order`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES
(2, 'Sales/Billing/Support', 0, 1, 1, 'riud', 'riud', '');

DELETE FROM `sys_ini` WHERE `sysini_id`=1;
INSERT INTO `sys_ini` (`sysini_id`, `config`, `default_logo`, `custom_logo`) VALUES
(1, CONCAT('[mail]\nenable_custom_login=n\nenable_welcome_mail=y\nshow_per_domain_relay_options=n\nmailbox_show_autoresponder_tab=y\nmailbox_show_mail_filter_tab=y\nmailbox_show_custom_rules_tab=y\nmailboxlist_webmail_link=y\nwebmail_url=https://[SERVERNAME]:8081/webmail\nmailmailinglist_link=n\nmailmailinglist_url=\nadmin_mail=', @XN_SYS_SMTP_MAIL, '\nadmin_name=', @XN_SYS_SMTP_NAME, '\nsmtp_enabled=y\nsmtp_host=', @XN_SYS_SMTP_HOST, '\nsmtp_port=25\nsmtp_user=', @XN_SYS_SMTP_USER, '\nsmtp_pass=', @XN_SYS_SMTP_PASS, '\nsmtp_crypt=\ndefault_mailserver=1\n\n[sites]\ndbname_prefix=c[CLIENTID]\ndbuser_prefix=c[CLIENTID]\nftpuser_prefix=[CLIENTNAME]\nshelluser_prefix=[CLIENTNAME]\nwebdavuser_prefix=[CLIENTNAME]\ndblist_phpmyadmin_link=y\nphpmyadmin_url=https://[SERVERNAME]:8081/phpmyadmin\nwebftp_url=\nclient_protection=y\nvhost_subdomains=n\nvhost_aliasdomains=n\nclient_username_web_check_disabled=n\nbackups_include_into_web_quota=y\nreseller_can_use_options=n\nshow_aps_menu=n\ndefault_webserver=1\ndefault_dbserver=1\ndisable_client_remote_dbserver=y\ndefault_remote_dbserver=\nweb_php_options=no,fast-cgi,mod,php-fpm\nssh_authentication=\nle_caa_autocreate_options=y\n\n[domains]\nuse_domain_module=n\nnew_domain_html=Please contact our support to create a new domain for you.\n\n[misc]\ncompany_name=', @XN_SYS_COMPANY_NAME, '\ncustom_login_text=', @XN_SYS_LOGIN_TEXT, '\ncustom_login_link=', @XN_SYS_LOGIN_LINK, '\ndashboard_atom_url_admin=https://www.ispconfig.org/atom\ndashboard_atom_url_reseller=', @XN_SYS_ATOM_URL_RESELLER, '\ndashboard_atom_url_client=', @XN_SYS_ATOM_URL_CLIENT, '\ntab_change_discard=n\ntab_change_warning=n\nuse_loadindicator=y\nuse_combobox=y\nshow_support_messages=n\nshow_delete_on_forms=n\nmaintenance_mode=n\nmaintenance_mode_exclude_ips=\nadmin_dashlets_left=\nadmin_dashlets_right=\nreseller_dashlets_left=\nreseller_dashlets_right=\nclient_dashlets_left=\nclient_dashlets_right=\ncustomer_no_template=C[CUSTOMER_NO]\ncustomer_no_start=1\ncustomer_no_counter=3\nsession_timeout=0\nsession_allow_endless=n\nmin_password_length=8\nmin_password_strength=5\n\n[dns]\ndefault_dnsserver=1\ndefault_slave_dnsserver=0\ndns_show_zoneexport=y\n\n'), 'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMgAAABBCAYAAACU5+uOAAAItUlEQVR42u1dCWwVVRStUJZCK6HsFNAgWpaCJkKICZKApKUFhURQpEnZF4EEUJZYEEpBIamgkQpUQBZRW7YCBqQsggsQEAgKLbIGCYsSCNqyQ8D76h18Hd/MvJk/n/bXc5KT+TNz79vPzNv+/2FhAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAOAe++s0akTsRZxMnE6cGkKcxkwhPofaBPwWRzxxB/EO8UGI8xhxEGoV8EscY8qBKFRcgdoFAhXHC+VUHAbHo5aBQASyrZwL5DoxEjUNeBXI9XIuEMEE1DTgVSA3FA3qIDEtBLnTQiBDUNOAV4EUKhpURojmZQQEAjwKgSwK0bykWQgEU74ABAKBABAIBOIJffoNrkRsS0whDiMO5uNw4gBiSxvfGOJrbDtMOgr2JNa18HmZmETsopnGp4h9xdF0TcQRb8NEPkawTzv2qaWIoybnZYRUBoJD+difGAuBlCy0qsRM4mfERcTFfGygsBUF/xFxE/EQ8RixwIbi/j7il8R3iE8qwuxAXMJxuuFiTvNMYleb/E0gXiI+cOBaISTJrzLxcw2/+8Q5pjjfNNkM0RDILLadpbimw+bsc4DPkxRpuqkZ1orisoBAiguuhkUhPSvZRBA3u6gsK94g9jDFP9aHcAV3EKNNYX8i3RcNJ4M4nTiROJCYykIzbGZKvouk68vYbyS/cUbz+RrJZpzkO5Sv3eajaJhRDvUwg21nKK4VcF5WKPgFH6PZZw/7dJXC6S6lczunfbIQLpeDkZ+lJcoCAikuvChioaLBtfD4JHPiXSFKKexBPoa9Wwr3ael6skMZDGO7K3z+uOSb5OA7mu2KiOGmPH3ADVh8/sohnDS2S1NcG+uiO/kd+8RL146YRWzj359tb0Eg+gIpsHkjFNrQqiF3DZJABDtyuCP5/FuNRlHN8Ofz9nx+XLNR3jR1c4w8TSFGSmnr4FEgU7wKhI51jAeTpv+/ZQGBOAuEu1d/Ku6LV35t9rdigkUjHuMgkHPEecQsxdjjUx4zHbMI+10OdzqfZ2o0iiqSfzgPfMXnzZqN6iTbJ5jytMTU0E97FEhaAAJ5kc/PuJjQOCoIgegJpKbUl5b5vGaBT+A+vOgn5/JYIdFBIOs1wo1kIZl93+P70/h8oUZYFXkmKInPU9h3m2YeT8lvRilPyyWbi3xt4iMWSDc+P4lp3uAIRDxdryjui6dmuujXcr91IDcMmaJv31WISfTrLeJXCUT3yb1a4Ztmalyu61MaZG/XtD9tapRGnpZKNp2lNNZ3KZARAQgk3untBYEEPgbJ92FsIAax34v1AQ2B5Go2BlW60n0QyCC/BWISdJ5LgewWU8k86DdTzMyNh0BKVyAzfB5I93YQyBGeTlW9lQbwIle2Rdgzy7BAxJT6Hb6X6EIgTrznRSCiHli02cwcPor1pbkQiL5AKvOA+ZZPAtkfxFms3j4IZHAwBGJaRPxdjH00BSImJRqKOlEwjtjUo0Dm2pWla4HMzsyqQIxSMKI8C8RkL9YXuhDf5gqcw4NweaZJiGkh8UeLwi+Utkb4KZCrYszkVSDiQRDMN4hkf5DvZ2gKZJyLPJgFkmAjEDEF3EYSWzPeklO8Q8CLQGKJhQquK+eDdLFNZBJxFLEf8XUXFTbcYv2kRhAEIq+vGNO88zTTKVaRzxPrSSvPW11O8yZqCiROSnMsX0sP0ixWops1Hfbx/AaJIz5QcFc5n+ZVNcbxmoWtEsBNB4EU8Tgk32Gv1wneEybeWG1N8RoNbplmOo2neiyxE3/eoun7G9t31hGIqXuzl8/HB0kgxhvhD03/KoEIpIWFQPLK+UJhkWpgKLZP8IKhajNhJg8A7yt8/5K6QoFM8z5mc68Ph3VWM6wTbN+a+AR/vqThV13KYyMXAgmXps9FnK8GSSA17KaXFf7R3gUyd8H/TiBss9fngfQehzfMpkDLgxcS73J4k1y85WrxtTtOjZPuVZA2O55RhLfUId5XpI2UHwZDIHxtp7HtRrVL25SfhWy7z7VAMuYvipszd0FJcfxzHspdrMctGnGcZNPTZ4F0VszqyPSlPHm8JG9f2SDtgF3Nq/rnJZssyXeUdP0CN64c9l/FDfGyZNNNkaeVGmnMM+Vdtd19los8/2e7Ow/E70lxiG7pRmkn8AaeULlcoo4sBDLfKvL0nLUxablfX0hfmfuQ01avI65fUQYEkupRIJHcAMwbDWNNdmLgupV4zeMO3stcIZ1M4aYo4vZt0oO7Locd0ndGTEQofN+QxiZ22+y7W+RpgUb66vOU7232SZXupZqvaYT3Dfu8ZLrejtc47mvkJ9FoVEWKBmW7dyc7ZXD1Nb2TH3JVn5Tqa3r1repzY6/gwWeqhUCGO/XjWSTmjYYVLOzFoP0Z/qJTks033brxrtjmxCbGtK4ivEqKuH2fNuc0tDatIYgna4yGbz2eeTL8WhJbic2aDnmqqpm2KlLeK5vWn0pc0wirGvtUtBkzNdPKDzWe24oGdZX4CzGfWCD4U93GBQdqNSw4Uiny8K9h4buOhlU2scq+Q1G1i233k63hFwBPEfcS04l1FGJoynbH+fgz8ZKFQJLDAMDjk/psCPzw20XxE6mmdLd24d8KNQ14FciUEPl1xHvEhlK6W2j65aOWgUAEUpV4NEREstyDQNqjloFARVKL/xukrAvkGjGC09zGwfYKsQdqF/BTKMnEJcTtxC3EPAU3iic5cRkfjc/ZFvZuuZm4gXjOouG35LQ2Yfutkq/4pfpN/E9TDVCjQGkJqQExho+CjYlRPseRiQE3EIriaMZTw4K3mOJv23J8jme23RsEAMqqQJrb9PnnEbPEVpUAuJD4Mf/PoCqeONQCUJYFElGKf7ojpnqjUQtAWRdJaf1t2w8ofSAUBNKulATSEaUPhIpIRj9icbyFUgdCTSRTeR0i2HwfpQ0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQBnG392D9QU+JXhxAAAAAElFTkSuQmCC', @XN_LOGO_BASE64);
</file>
<file text soap.php>
<?php
//* Set the SOAP variables
$soap_username = $_SERVER['argv'][1];
$soap_password = $_SERVER['argv'][2];
$soap_location = $_SERVER['argv'][3];
$soap_uri = $_SERVER['argv'][4];
$server_hostname = $_SERVER['argv'][5];
$server_hostname_full = $_SERVER['argv'][6];
$server_ipv4 = $_SERVER['argv'][7];
$server_ipv6 = $_SERVER['argv'][8];
$server_ipv6_shared = $_SERVER['argv'][9];
$server_ipv4_tor = $_SERVER['argv'][10];
$client_username = $_SERVER['argv'][11];
$client_password = $_SERVER['argv'][12];
$client_email = $_SERVER['argv'][13];
$client_template_master = $_SERVER['argv'][14];
$client_template_additional = $_SERVER['argv'][15];
$client_contact_name = $_SERVER['argv'][16];
$client_company_name = $_SERVER['argv'][17];
$client_company_url = $_SERVER['argv'][18];
$ftp_default1_username = $_SERVER['argv'][19];
$ftp_default1_password = $_SERVER['argv'][20];
$ftp_default2_username = $_SERVER['argv'][21];
$ftp_default2_password = $_SERVER['argv'][22];
$ftp_default3_username = $_SERVER['argv'][23];
$ftp_default3_password = $_SERVER['argv'][24];
$ftp_host_username = $_SERVER['argv'][25];
$ftp_host_password = $_SERVER['argv'][26];
$ftp_lg_username = $_SERVER['argv'][27];
$ftp_lg_password = $_SERVER['argv'][28];
$shell_lg_username = $_SERVER['argv'][29];
$shell_lg_password = $_SERVER['argv'][30];

//* Set the SSL policy for this script
$context = stream_context_create([
	'ssl' => [
		// set some SSL/TLS specific options
		'verify_peer' => false,
		'verify_peer_name' => false,
		'allow_self_signed' => true
	]
]);

//* Create the SOAP client connection
$client = new SoapClient(null, array('location' => $soap_location,
	'uri' => $soap_uri,
	'trace' => 1,
	'exceptions' => 1,
	'stream_context' => $context));

try {
	//* Login as remote user
	if($session_id = $client->login($soap_username, $soap_password)) {
		echo "Login successfull\n";
		echo "Session ID: ".$session_id."\n";
	}

	//* Set the function parameters
	$client_id = 0;
	$params = array(
		'server_id' => 1,
		'client_id' => 0,
		'ip_type' => 'IPv4',
		'ip_address' => $server_ipv4_tor,
		'virtualhost' => 'y',
		'virtualhost_port' => '80,443'
	);

	//* Add the Tor IP
	$local_ip_id = $client->server_ip_add($session_id, $client_id, $params);

	//* Print the results
	echo "Tor IP ID: ".$local_ip_id."\n";

	//* Set the function parameters
	$reseller_id = 0; // this id has to be 0 if the client shall not be assigned to admin or if the client is a reseller
	$params = array(
		'company_name' => $client_company_name,
		'contact_name' => $client_contact_name,
		'customer_no' => '',
		'vat_id' => '',
		'street' => '',
		'zip' => '',
		'city' => '',
		'state' => '',
		'country' => 'US',
		'telephone' => '',
		'mobile' => '',
		'fax' => '',
		'email' => $client_email,
		'internet' => $client_company_url,
		'icq' => '',
		'notes' => 'awesome',
		'default_mailserver' => 1,
		'limit_maildomain' => 0,
		'limit_mailbox' => 0,
		'limit_mailalias' => 0,
		'limit_mailaliasdomain' => 0,
		'limit_mailforward' => 0,
		'limit_mailcatchall' => 0,
		'limit_mailrouting' => 0,
		'limit_mail_wblist' => 0,
		'limit_mailfilter' => 0,
		'limit_fetchmail' => 0,
		'limit_mailquota' => 0,
		'limit_spamfilter_wblist' => 0,
		'limit_spamfilter_user' => 0,
		'limit_spamfilter_policy' => 1,
		'default_webserver' => 1,
		'limit_web_ip' => '',
		'limit_web_domain' => 0,
		'limit_web_quota' => 0,
		'web_php_options' => 'no',
		'limit_web_subdomain' => 0,
		'limit_web_aliasdomain' => 0,
		'limit_ftp_user' => 0,
		'limit_shell_user' => 0,
		'ssh_chroot' => 'no',
		'limit_webdav_user' => 0,
		'default_dnsserver' => 1,
		'limit_dns_zone' => 0,
		'limit_dns_slave_zone' => 0,
		'limit_dns_record' => 0,
		'default_dbserver' => 1,
		'limit_database' => 0,
		'limit_cron' => 0,
		'limit_cron_type' => 'url',
		'limit_cron_frequency' => 5,
		'limit_traffic_quota' => 0,
		'limit_client' => 0, // If this value is > 0, then the client is a reseller
		'parent_client_id' => 0,
		'username' => $client_username,
		'password' => $client_password,
		'language' => 'en',
		'usertheme' => 'default',
		'template_master' => $client_template_master,
		'template_additional' => $client_template_additional,
		'created_at' => 0
	);

	//* Add the client
	$client_ispc_id = $client->client_add($session_id, $reseller_id, $params);

	//* Print the results
	echo "Client ID: ".$client_ispc_id."\n";

	//* Set the function parameters.
	$primary_id = -1;

	//* Get the IP array
	$record_record = $client->server_ip_get($session_id, $primary_id);

	//* Loop through the results
	foreach ($record_record as $key => $val) {
		//* Check if the IP matches
		if ($val['ip_address'] == $server_ipv6) {
			//* Set the function parameters.
			$client_id = 0;
			$ip_id = $val['server_ip_id'];
			$params = array(
				'server_id' => $val['server_id'],
				'client_id' => $client_ispc_id,
				'ip_type' => $val['ip_type'],
				'ip_address' => $val['ip_address'],
				'virtualhost' => 'y',
				'virtualhost_port' => $val['virtualhost_port']
			);

			//* Update the IP
			$affected_rows = $client->server_ip_update($session_id, $client_id, $ip_id, $params);

			//* Print the results
			echo "IPv6 Affected Rows: ".$affected_rows."\n";
		}
		if ($val['ip_address'] == $server_ipv4) {
			//* Set the function parameters.
			$client_id = 0;
			$ip_id = $val['server_ip_id'];
			$params = array(
				'server_id' => $val['server_id'],
				'client_id' => $val['client_id'],
				'ip_type' => $val['ip_type'],
				'ip_address' => $val['ip_address'],
				'virtualhost' => 'y',
				'virtualhost_port' => $val['virtualhost_port']
			);

			//* Update the IP
			$affected_rows = $client->server_ip_update($session_id, $client_id, $ip_id, $params);

			//* Print the results
			echo "Shared IPv4 Affected Rows: ".$affected_rows."\n";
		}
		if ($val['ip_address'] == $server_ipv6_shared) {
			//* Set the function parameters.
			$client_id = 0;
			$ip_id = $val['server_ip_id'];
			$params = array(
				'server_id' => $val['server_id'],
				'client_id' => $val['client_id'],
				'ip_type' => $val['ip_type'],
				'ip_address' => $val['ip_address'],
				'virtualhost' => 'y',
				'virtualhost_port' => $val['virtualhost_port']
			);

			//* Update the IP
			$affected_rows = $client->server_ip_update($session_id, $client_id, $ip_id, $params);

			//* Print the results
			echo "Shared IPv6 Affected Rows: ".$affected_rows."\n";
		}
	}

	//* Set the function parameters
	$client_id = $client_ispc_id;
	$template_id = 6;
	$domain = $server_hostname_full;
	$ip = $server_ipv4;
	$ns1 = 'ns1.'.$server_hostname_full;
	$ns2 = 'ns2.'.$server_hostname_full;
	$email = 'hostmaster@xev.net.eu.org';
	$ipv6 = $server_ipv6;

	//* Add a DNS zone using a template
	$dns_zone_id = $client->dns_templatezone_add($session_id, $client_id, $template_id, $domain, $ip, $ns1, $ns2, $email, $ipv6);

	//* Print the results
	echo "DNS Zone ID: ".$dns_zone_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'domain' => $server_hostname_full,
		'active' => 'y'
	);

	//* Add the mail domain
	$mail_domain_id = $client->mail_domain_add($session_id, $client_id, $params);

	//* Print the results
	echo "Mail Domain ID: ".$mail_domain_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'priority' => 5,
		'policy_id' => 5,
		'email' => "@".$server_hostname_full,
		'fullname' => "@".$server_hostname_full,
		'local' => 'Y'
	);

	//* Add the mail spamfilter user
	$spamfilter_user_id = $client->mail_spamfilter_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "Spamfilter User ID: ".$spamfilter_user_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'ip_address' => '127.0.0.1',
		'ipv6_address' => '',
		'domain' => '00000-defaultsite.tld',
		'type' => 'vhost',
		'parent_domain_id' => 0,
		'vhost_type' => 'name',
		'hd_quota' => 100,
		'traffic_quota' => 10000,
		'cgi' => 'y',
		'ssi' => 'y',
		'suexec' => 'y',
		'errordocs' => 0,
		'is_subdomainwww' => 1,
		'subdomain' => 'www',
		'php' => 'fast-cgi',
		'server_php_id' => '',
		'ruby' => 'n',
		'perl' => 'n',
		'python' => 'n',
		'redirect_type' => '',
		'redirect_path' => '',
		'ssl' => 'y',
		'ssl_letsencrypt' => 'n',
		'ssl_state' => '',
		'ssl_locality' => '',
		'ssl_organisation' => 'Default Org',
		'ssl_organisation_unit' => 'IT',
		'ssl_country' => 'US',
		'ssl_domain' => '00000-defaultsite.tld',
		'ssl_request' => '',
		'ssl_key' => '',
		'ssl_cert' => '',
		'ssl_bundle' => '',
		'ssl_action' => 'create',
		'stats_password' => '',
		'stats_type' => 'webalizer',
		'allow_override' => 'All',
		'apache_directives' => '',
		'php_open_basedir' => '/',
		'php_fpm_use_socket' => 'y',
		'pm' => 'ondemand',
		'pm_max_children' => 10,
		'pm_start_servers' => 2,
		'pm_max_requests' => 0,
		'pm_max_spare_servers' => 5,
		'pm_process_idle_timeout' => 10,
		'custom_php_ini' => '',
		'backup_interval' => '',
		'backup_copies' => 1,
		'backup_format_web' => 'default',
		'backup_format_db' => 'gzip',
		'active' => 'y',
		'traffic_quota_lock' => 'n',
		'http_port' => '80',
		'https_port' => '443',
		'log_retention' => '10'
	);

	//* Add a web domain
	$web_domain_id = $client->sites_web_domain_add($session_id, $client_id, $params, $readonly = false);

	//* Print the results
	echo "Web Domain ID: ".$web_domain_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'parent_domain_id' => $web_domain_id,
		'username' => $client_username.$ftp_default1_username,
		'username_prefix' => $client_username,
		'password' => $ftp_default1_password,
		'quota_size' => 100,
		'active' => 'y',
		'uid' => 'web'.$web_domain_id,
		'gid' => 'client'.$client_id,
		'dir' => '/var/www/clients/client'.$client_id.'/web'.$web_domain_id,
		'quota_files' => -1,
		'ul_ratio' => -1,
		'dl_ratio' => -1,
		'ul_bandwidth' => -1,
		'dl_bandwidth' => -1
	);

	//* Add a FTP user
	$ftp_id = $client->sites_ftp_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "FTP User ID: ".$ftp_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'ip_address' => $server_ipv4,
		'ipv6_address' => '',
		'domain' => '00001-defaultsite.tld',
		'type' => 'vhost',
		'parent_domain_id' => 0,
		'vhost_type' => 'name',
		'hd_quota' => 100,
		'traffic_quota' => 10000,
		'cgi' => 'y',
		'ssi' => 'y',
		'suexec' => 'y',
		'errordocs' => 0,
		'is_subdomainwww' => 1,
		'subdomain' => 'www',
		'php' => 'fast-cgi',
		'server_php_id' => '',
		'ruby' => 'n',
		'perl' => 'n',
		'python' => 'n',
		'redirect_type' => '',
		'redirect_path' => '',
		'ssl' => 'y',
		'ssl_letsencrypt' => 'n',
		'ssl_state' => '',
		'ssl_locality' => '',
		'ssl_organisation' => 'Default Org',
		'ssl_organisation_unit' => 'IT',
		'ssl_country' => 'US',
		'ssl_domain' => '00001-defaultsite.tld',
		'ssl_request' => '',
		'ssl_key' => '',
		'ssl_cert' => '',
		'ssl_bundle' => '',
		'ssl_action' => 'create',
		'stats_password' => '',
		'stats_type' => 'webalizer',
		'allow_override' => 'All',
		'apache_directives' => '',
		'php_open_basedir' => '/',
		'php_fpm_use_socket' => 'y',
		'pm' => 'ondemand',
		'pm_max_children' => 10,
		'pm_start_servers' => 2,
		'pm_max_requests' => 0,
		'pm_max_spare_servers' => 5,
		'pm_process_idle_timeout' => 10,
		'custom_php_ini' => '',
		'backup_interval' => '',
		'backup_copies' => 1,
		'backup_format_web' => 'default',
		'backup_format_db' => 'gzip',
		'active' => 'y',
		'traffic_quota_lock' => 'n',
		'http_port' => '80',
		'https_port' => '443',
		'log_retention' => '10'
	);


	//* Add a web domain
	$web_domain_id = $client->sites_web_domain_add($session_id, $client_id, $params, $readonly = false);

	//* Print the results
	echo "Web Domain ID: ".$web_domain_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'parent_domain_id' => $web_domain_id,
		'username' => $client_username.$ftp_default2_username,
		'username_prefix' => $client_username,
		'password' => $ftp_default2_password,
		'quota_size' => 100,
		'active' => 'y',
		'uid' => 'web'.$web_domain_id,
		'gid' => 'client'.$client_id,
		'dir' => '/var/www/clients/client'.$client_id.'/web'.$web_domain_id,
		'quota_files' => -1,
		'ul_ratio' => -1,
		'dl_ratio' => -1,
		'ul_bandwidth' => -1,
		'dl_bandwidth' => -1
	);

	//* Add a FTP user
	$ftp_id = $client->sites_ftp_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "FTP User ID: ".$ftp_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'ip_address' => '*',
		'ipv6_address' => '',
		'domain' => '00002-defaultsite.tld',
		'type' => 'vhost',
		'parent_domain_id' => 0,
		'vhost_type' => 'name',
		'hd_quota' => 100,
		'traffic_quota' => 10000,
		'cgi' => 'y',
		'ssi' => 'y',
		'suexec' => 'y',
		'errordocs' => 0,
		'is_subdomainwww' => 1,
		'subdomain' => 'www',
		'php' => 'fast-cgi',
		'server_php_id' => '',
		'ruby' => 'n',
		'perl' => 'n',
		'python' => 'n',
		'redirect_type' => '',
		'redirect_path' => '',
		'ssl' => 'y',
		'ssl_letsencrypt' => 'n',
		'ssl_state' => '',
		'ssl_locality' => '',
		'ssl_organisation' => 'Default Org',
		'ssl_organisation_unit' => 'IT',
		'ssl_country' => 'US',
		'ssl_domain' => '00002-defaultsite.tld',
		'ssl_request' => '',
		'ssl_key' => '',
		'ssl_cert' => '',
		'ssl_bundle' => '',
		'ssl_action' => 'create',
		'stats_password' => '',
		'stats_type' => 'webalizer',
		'allow_override' => 'All',
		'apache_directives' => '',
		'php_open_basedir' => '/',
		'php_fpm_use_socket' => 'y',
		'pm' => 'ondemand',
		'pm_max_children' => 10,
		'pm_start_servers' => 2,
		'pm_max_requests' => 0,
		'pm_max_spare_servers' => 5,
		'pm_process_idle_timeout' => 10,
		'custom_php_ini' => '',
		'backup_interval' => '',
		'backup_copies' => 1,
		'backup_format_web' => 'default',
		'backup_format_db' => 'gzip',
		'active' => 'y',
		'traffic_quota_lock' => 'n',
		'http_port' => '80',
		'https_port' => '443',
		'log_retention' => '10'
	);


	//* Add a web domain
	$web_domain_id = $client->sites_web_domain_add($session_id, $client_id, $params, $readonly = false);

	//* Print the results
	echo "Web Domain ID: ".$web_domain_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'parent_domain_id' => $web_domain_id,
		'username' => $client_username.$ftp_default3_username,
		'username_prefix' => $client_username,
		'password' => $ftp_default3_password,
		'quota_size' => 100,
		'active' => 'y',
		'uid' => 'web'.$web_domain_id,
		'gid' => 'client'.$client_id,
		'dir' => '/var/www/clients/client'.$client_id.'/web'.$web_domain_id,
		'quota_files' => -1,
		'ul_ratio' => -1,
		'dl_ratio' => -1,
		'ul_bandwidth' => -1,
		'dl_bandwidth' => -1
	);

	//* Add a FTP user
	$ftp_id = $client->sites_ftp_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "FTP User ID: ".$ftp_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'ip_address' => $server_ipv4,
		'ipv6_address' => $server_ipv6,
		'domain' => $server_hostname_full,
		'type' => 'vhost',
		'parent_domain_id' => 0,
		'vhost_type' => 'name',
		'hd_quota' => 100,
		'traffic_quota' => 10000,
		'cgi' => 'y',
		'ssi' => 'y',
		'suexec' => 'y',
		'errordocs' => 0,
		'is_subdomainwww' => 1,
		'subdomain' => 'www',
		'php' => 'fast-cgi',
		'server_php_id' => '',
		'ruby' => 'n',
		'perl' => 'n',
		'python' => 'n',
		'redirect_type' => 'R=301,L',
		'redirect_path' => 'https://'.$server_hostname_full.':8080/',
		'ssl' => 'y',
		'ssl_letsencrypt' => 'n',
		'ssl_state' => '',
		'ssl_locality' => '',
		'ssl_organisation' => 'Default Org',
		'ssl_organisation_unit' => 'IT',
		'ssl_country' => 'US',
		'ssl_domain' => $server_hostname_full,
		'ssl_request' => '',
		'ssl_key' => '',
		'ssl_cert' => '',
		'ssl_bundle' => '',
		'ssl_action' => 'create',
		'stats_password' => '',
		'stats_type' => 'webalizer',
		'allow_override' => 'All',
		'apache_directives' => '',
		'php_open_basedir' => '/',
		'php_fpm_use_socket' => 'y',
		'pm' => 'ondemand',
		'pm_max_children' => 10,
		'pm_start_servers' => 2,
		'pm_max_requests' => 0,
		'pm_max_spare_servers' => 5,
		'pm_process_idle_timeout' => 10,
		'custom_php_ini' => '',
		'backup_interval' => '',
		'backup_copies' => 1,
		'backup_format_web' => 'default',
		'backup_format_db' => 'gzip',
		'active' => 'y',
		'traffic_quota_lock' => 'n',
		'http_port' => '80',
		'https_port' => '443',
		'log_retention' => '10'
	);


	//* Add a web domain
	$web_domain_id = $client->sites_web_domain_add($session_id, $client_id, $params, $readonly = false);

	//* Print the results
	echo "Web Domain ID: ".$web_domain_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'parent_domain_id' => $web_domain_id,
		'username' => $client_username.$ftp_host_username,
		'username_prefix' => $client_username,
		'password' => $ftp_host_password,
		'quota_size' => 100,
		'active' => 'y',
		'uid' => 'web'.$web_domain_id,
		'gid' => 'client'.$client_id,
		'dir' => '/var/www/clients/client'.$client_id.'/web'.$web_domain_id,
		'quota_files' => -1,
		'ul_ratio' => -1,
		'dl_ratio' => -1,
		'ul_bandwidth' => -1,
		'dl_bandwidth' => -1
	);

	//* Add a FTP user
	$ftp_id = $client->sites_ftp_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "FTP User ID: ".$ftp_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'ip_address' => $server_ipv4,
		'ipv6_address' => $server_ipv6,
		'domain' => 'lg.'.$server_hostname_full,
		'type' => 'vhost',
		'parent_domain_id' => 0,
		'vhost_type' => 'name',
		'hd_quota' => 100,
		'traffic_quota' => 10000,
		'cgi' => 'y',
		'ssi' => 'y',
		'suexec' => 'y',
		'errordocs' => 0,
		'is_subdomainwww' => 1,
		'subdomain' => 'www',
		'php' => 'fast-cgi',
		'server_php_id' => '1',
		'ruby' => 'n',
		'perl' => 'n',
		'python' => 'n',
		'redirect_type' => '',
		'redirect_path' => '',
		'ssl' => 'y',
		'ssl_letsencrypt' => 'y',
		'ssl_state' => '',
		'ssl_locality' => '',
		'ssl_organisation' => 'Default Org',
		'ssl_organisation_unit' => 'IT',
		'ssl_country' => 'US',
		'ssl_domain' => 'lg.'.$server_hostname_full,
		'ssl_request' => '',
		'ssl_key' => '',
		'ssl_cert' => '',
		'ssl_bundle' => '',
		'ssl_action' => 'create',
		'stats_password' => '',
		'stats_type' => 'webalizer',
		'allow_override' => 'All',
		'apache_directives' => '',
		'php_open_basedir' => '/',
		'php_fpm_use_socket' => 'y',
		'pm' => 'ondemand',
		'pm_max_children' => 10,
		'pm_start_servers' => 2,
		'pm_max_requests' => 0,
		'pm_max_spare_servers' => 5,
		'pm_process_idle_timeout' => 10,
		'custom_php_ini' => '',
		'backup_interval' => '',
		'backup_copies' => 1,
		'backup_format_web' => 'default',
		'backup_format_db' => 'gzip',
		'active' => 'y',
		'traffic_quota_lock' => 'n',
		'http_port' => '80',
		'https_port' => '443',
		'log_retention' => '10'
	);


	//* Add a web domain
	$web_domain_id = $client->sites_web_domain_add($session_id, $client_id, $params, $readonly = false);

	//* Print the results
	echo "Web Domain ID: ".$web_domain_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'parent_domain_id' => $web_domain_id,
		'username' => $client_username.$ftp_lg_username,
		'username_prefix' => $client_username,
		'password' => $ftp_lg_password,
		'quota_size' => 100,
		'active' => 'y',
		'uid' => 'web'.$web_domain_id,
		'gid' => 'client'.$client_id,
		'dir' => '/var/www/clients/client'.$client_id.'/web'.$web_domain_id,
		'quota_files' => -1,
		'ul_ratio' => -1,
		'dl_ratio' => -1,
		'ul_bandwidth' => -1,
		'dl_bandwidth' => -1
	);

	//* Add a FTP user
	$ftp_id = $client->sites_ftp_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "FTP User ID: ".$ftp_id."\n";

	//* Set the function parameters.
	$client_id = $client_ispc_id;
	$params = array(
		'server_id' => 1,
		'parent_domain_id' => $web_domain_id,
		'username' => $client_username.$shell_lg_username,
		'username_prefix' => $client_username,
		'password' => $shell_lg_password,
		'quota_size' => 100,
		'active' => 'y',
		'puser' => 'web'.$web_domain_id,
		'pgroup' => 'client'.$client_id,
		'shell' => '/bin/bash',
		'dir' => '/var/www/clients/client'.$client_id.'/web'.$web_domain_id,
		'chroot' => 'no'
	);

	//* Add a shell user
	$shell_id = $client->sites_shell_user_add($session_id, $client_id, $params);

	//* Print the results
	echo "Shell User ID: ".$shell_id."\n";

	//* Logout remote user
	if($client->logout($session_id)) {
		echo "Logged out\n";
	}
} catch (SoapFault $e) {
	echo "Last Response: ".$client->__getLastResponse()."\n";
	die("SOAP Error: ".$e->getMessage()."\n");
}
?>
</file>
<file text torrc>
############### This section is just for configuring Tor services ###
## Start the process in the background...
## or use --runasdaemon 1 on the command line.
RunAsDaemon 1
## The directory for keeping all the keys/etc.
DataDirectory /var/lib/tor

############### This section is just for location-hidden services ###
## Once you have configured a hidden service, you can look at the
## contents of the file ".../hidden_service/hostname" for the address
## to tell people.
##
## HiddenServicePort x y:z says to redirect requests on port x to the
## address y:z.

</file>
<file text softaculous_install.exp>
#!/usr/bin/expect
#
# softaculous_install.exp
#
# Set the variables
set XN_REMOTE_USER [lindex $argv 0]
set XN_REMOTE_PASS [lindex $argv 1]
#
# Do not edit below this line unless you fully understand what you are doing
#
# Spawn and install
spawn ./install.sh
expect "Please enter the Remote User : "
send -- "$XN_REMOTE_USER\n"
expect "Enter Password: "
send -- "$XN_REMOTE_PASS\n"
interact
</file>
<file text index.php>
<?php
// lazy config check/load
if (file_exists('LookingGlass/Config.php')) {
  require 'LookingGlass/Config.php';
  if (!isset($ipv4, $ipv6, $siteName, $siteUrl, $serverLocation, $testFiles, $theme)) {
    exit('Configuration variable/s missing. Please run configure.sh');
  }
} else {
  exit('Config.php does not exist. Please run configure.sh');
}
// Bench Tests
$benchTests = array();
$benchTests[] = 'yabs_root_partition.log';
// $benchTests[] = 'yabs_storage_partition.log';
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title><?php echo $siteName; ?> - Looking Glass</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="LookingGlass - Open source PHP looking glass">
    <meta name="author" content="Telephone">

    <!-- IE6-8 support of HTML elements -->
    <!--[if lt IE 9]>
      <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->

    <!-- Styles -->
    <link href="assets/css/<?php echo $theme; ?>.min.css" rel="stylesheet">
  </head>
  <body>
    <!-- Container -->
    <div class="container">

      <!-- Header -->
      <header class="header nohighlight" id="overview">
        <div class="row">
          <div class="span12">
            <h1><a id="title" href="<?php echo $siteUrl; ?>"><?php echo $siteName; ?></a></h1>
          </div>
        </div>
      </header>

      <!-- Network Information -->
      <section id="information">
        <div class="row">
          <div class="span8">
            <div class="well">
              <span id="legend">Network Information</span><!-- IE/Safari dislike <legend> out of context -->
              <p>Server Location: <b><?php echo $serverLocation; ?></b></p>
              <div style="margin-left: 10px;">
                <p>Test IPv4: <?php echo $ipv4; ?></p>
                <p><?php if (!empty($ipv6)) { echo 'Test IPv6: ',$ipv6; } ?></p>
                <p>Test Files: <?php
                  foreach ($testFiles as $val) {
                    echo "<a href=\"{$val}.test\" id=\"testfile\">{$val}</a> ";
                  }
                ?></p>
                <p>Bench Tests: <?php
                  foreach ($benchTests as $val) {
                    echo "<a href=\"{$val}\" id=\"testfile\">{$val}</a> ";
                  }
                ?></p>
              </div>
              <p>Your IP Address: <b><a href="#tests" id="userip"><?php echo $_SERVER['REMOTE_ADDR']; ?></a></b></p>
            </div>
          </div>

          <div class="span4">
            <div class="well">
              <span id="legend">
                More Locations
              </span>
              <p><a href="//lg.ams01.xev.net.eu.org/">AMS01 - Amsterdam, North Holland NL</a></p>
              <p><a href="//lg.lax01.xev.net.eu.org/">LAX01 - Los Angeles, California US</a></p>
              <p><a href="//lg.lax02.xev.net.eu.org/">LAX02 - Los Angeles, California US</a></p>
              <p><a href="//my.xev.net.eu.org/order/forms/" target="_blank">Order Services</a></p>
            </div>
          </div>

        </div>
      </section>

      <!-- Network Tests -->
      <section id="tests">
        <div class="row">
          <div class="span12">
            <form class="well form-inline" id="networktest" action="#results" method="post">
              <fieldset>
                <span id="legend">Network Tests</span>
                <div id="hosterror" class="control-group">
                  <div class="controls">
                    <input id="host" name="host" type="text" class="input-large" placeholder="Host or IP address">
                  </div>
                </div>
                <select name="cmd" class="input-medium" style="margin-left: 5px;">
                  <option value="host">host</option>
                  <option value="mtr">mtr</option>
                  <?php if (!empty($ipv6)) { echo '<option value="mtr6">mtr6</option>'; } ?>
                  <option value="ping" selected="selected">ping</option>
                  <?php if (!empty($ipv6)) { echo '<option value="ping6">ping6</option>'; } ?>
                  <option value="traceroute">traceroute</option>
                  <?php if (!empty($ipv6)) { echo '<option value="traceroute6">traceroute6</option>'; } ?>
                </select>
                <button type="submit" id="submit" name="submit" class="btn btn-primary" style="margin-left: 10px;">Run Test</button>
              </fieldset>
            </form>
          </div>
        </div>
      </section>

      <!-- Results -->
      <section id="results" style="display:none">
        <div class="row">
          <div class="span12">
            <div class="well">
              <span id="legend">Results</span>
              <pre id="response" style="display:none"></pre>
            </div>
          </div>
        </div>
      </section>

      <!-- Footer -->
      <footer class="footer nohighlight">
        <p class="pull-right">
            <a href="#">Back to top</a>
        </p>
        <p>Powered by <a href="http://github.com/telephone/LookingGlass">LookingGlass</a></p>
      </footer>

    </div><!-- /container -->

    <!-- Javascript -->
    <script src="assets/js/jquery-1.11.2.min.js"></script>
    <script src="assets/js/LookingGlass.min.js"></script>
    <script src="assets/js/XMLHttpRequest.min.js"></script>
  </body>
</html>
</file>
<file text mysql_install.sh>
#!/bin/sh
#
# mysql_install.sh
#
# Set the variables
source ./xev_net_install_config.sh
#
# Do not edit below this line unless you fully understand what you are doing
#
# Set the variables
XN_MYSQL_USER="$(php -r 'include("/usr/local/ispconfig/server/lib/mysql_clientdb.conf"); print $clientdb_user;')"
XN_MYSQL_PASS="$(php -r 'include("/usr/local/ispconfig/server/lib/mysql_clientdb.conf"); print $clientdb_password;')"
XN_LOGO_BASE64="data:image/png;base64,$(base64 -w 0 logo.png)"
#
# Crypt the remote user password using the ISPConfig PHP method
XN_REMOTE_PASS_CRYPTED=$(php -r '$cleartext_password="'$XN_REMOTE_PASS'"; $salt="$6$"; $base64_alphabet="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/"; for ($n=0;$n<8;$n++) { $salt.=$base64_alphabet[mt_rand(0, 63)]; } $salt.="$"; echo crypt($cleartext_password, $salt);')
#
# Get the SQL file
wget -O dbispconfig.sql "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=13"
#
# Execute the SQL file
echo "SET @XN_HOSTNAME_FULL='$XN_HOSTNAME_FULL';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_COMPANY_NAME='$XN_SYS_COMPANY_NAME';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_COMPANY_URL='$XN_SYS_COMPANY_URL';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_COMPANY_TAGLINE='$XN_SYS_COMPANY_TAGLINE';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_REMOTE_USER='$XN_REMOTE_USER';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_REMOTE_PASS_CRYPTED='$XN_REMOTE_PASS_CRYPTED';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_LOGO_BASE64='$XN_LOGO_BASE64';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_SMTP_PASS='$XN_SYS_SMTP_PASS';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_SMTP_USER='$XN_SYS_SMTP_USER';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_SMTP_HOST='$XN_SYS_SMTP_HOST';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_SMTP_NAME='$XN_SYS_SMTP_NAME';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_SMTP_MAIL='$XN_SYS_SMTP_MAIL';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_ATOM_URL_CLIENT='$XN_SYS_ATOM_URL_CLIENT';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_ATOM_URL_RESELLER='$XN_SYS_ATOM_URL_RESELLER';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_LOGIN_TEXT='$XN_SYS_LOGIN_TEXT';\n$(cat dbispconfig.sql)" > dbispconfig.sql
echo "SET @XN_SYS_LOGIN_LINK='$XN_SYS_LOGIN_LINK';\n$(cat dbispconfig.sql)" > dbispconfig.sql
mysql -u $XN_MYSQL_USER -p"$XN_MYSQL_PASS" dbispconfig < dbispconfig.sql
#
# Clear the variables
XN_MYSQL_USER=""
XN_MYSQL_PASS=""
XN_LOGO_BASE64=""
#
# Remove the SQL file
rm -rfv dbispconfig.sql
</file>
<file text soap_install.sh>
#!/bin/sh
#
# soap_install.sh
#
# Set the variables
source ./xev_net_install_config.sh
#
# Do not edit below this line unless you fully understand what you are doing
#
# Get the SOAP file
wget -O soap.php "https://docs.xev.net.eu.org/doku.php?do=export_code&id=auto-install&codeblock=14"
#
# Execute the SOAP file
php soap.php "$XN_REMOTE_USER" "$XN_REMOTE_PASS" "$XN_REMOTE_LOCATION" "$XN_REMOTE_URI" "$XN_HOSTNAME" "$XN_HOSTNAME_FULL" "$XN_IPV4" "$XN_IPV6" "$XN_IPV6_SHARED" "$XN_IPV4_TOR" "$XN_CLIENT_USER" "$XN_CLIENT_PASS" "$XN_CLIENT_EMAIL" "$XN_CLIENT_MASTER" "$XN_CLIENT_ADDITIONAL" "$XN_CLIENT_CONTACT_NAME" "$XN_CLIENT_COMPANY_NAME" "$XN_CLIENT_COMPANY_URL" "$XN_FTP_DEFAULT1_USER" "$XN_FTP_DEFAULT1_PASS" "$XN_FTP_DEFAULT2_USER" "$XN_FTP_DEFAULT2_PASS" "$XN_FTP_DEFAULT3_USER" "$XN_FTP_DEFAULT3_PASS" "$XN_FTP_HOST_USER" "$XN_FTP_HOST_PASS" "$XN_FTP_LG_USER" "$XN_FTP_LG_PASS" "$XN_SHELL_LG_USER" "$XN_SHELL_LG_PASS"
#
# Remove the SOAP file
rm -rfv soap.php
</file>