agarzon

// This command line program helps to install 4k or 2k textures in the Zibo's B738
// Author: Alexander Garzon
// Multi-platform. It should work with WIN, OS and Linux. Just be sure the file has execution permisstions.
// Tested with Zibo 3.31

package main

import (
	"fmt"
	"io"

agarzon

SELECT tblhosting.domain, tblservers.name, tblhosting.domainstatus, tblproducts.name , CONCAT(tblclients.firstname, ' ', tblclients.lastname) AS Client, tblclients.status AS Clientstatus
FROM tblhosting 
LEFT JOIN tblproducts ON tblhosting.packageid = tblproducts.id
LEFT JOIN tblservers ON tblhosting.server = tblservers.id
LEFT JOIN tblclients ON tblhosting.userid = tblclients.id
WHERE tblhosting.domainstatus IN ('Active', 'Suspended')
ORDER BY tblservers.id ASC
INTO OUTFILE '/tmp/whmcs.csv';

agarzon

#!/bin/bash

#If you want more "passes" change vzun0 for vzun1 or any other number (process will be slower!)
find /mnt/backup -type f -print0 | xargs -0 shred -vzun0

agarzon

gitlab:
  image: 'gitlab/gitlab-ce:latest'
  container_name: gitlab
  restart: always
  hostname: 'gitlab.mcu.dc'
  environment:
    GITLAB_OMNIBUS_CONFIG: |
      external_url 'http://gitlab.mcu.dc:8090'
      gitlab_rails['gitlab_shell_ssh_port'] = 2290
      gitlab_rails['smtp_enable'] = true

agarzon

#!/usr/bin/env bash                                                                                      │ject-with tcp-reset
# usage: ./senderscore.sh 74.91.28.11

if [ -z "$1" ]
    then
    echo "IP is missing as arguemnt."
    exit
fi

IP=$1

agarzon

find . -name "*.php" -print0 | xargs -0 -n1 -P $(nproc) php -l | grep -v '^No'

agarzon

#!/bin/bash

#To execute it directly: sudo bash <(curl -s https://gist.githubusercontent.com/agarzon/ecb0b92d4c8e1bbde126534c76721a58/raw/install-php-tools.sh)

BIN_PATH=/usr/local/bin/

#COMPOSER
sudo curl -LsS https://getcomposer.org/composer.phar -o ${BIN_PATH}composer
sudo chmod a+x ${BIN_PATH}composer

agarzon

#!/bin/bash -e
### Copyright 1999-2015. Parallels IP Holdings GmbH. All Rights Reserved.
### Secure plesk clean installation with hostname certificate by Let's Encrypt

export PYTHONWARNINGS="ignore:Non-standard path"
LE_HOME=${LE_HOME:-"/usr/local/psa/var/modules/letsencrypt"}
HOSTNAME=$(hostname)

# Use staging server for testing
# --server https://acme-staging.api.letsencrypt.org/directory

agarzon

dpkg --list | grep linux-image | awk '{ print $2 }' | sort -V | sed -n '/'(uname -r)'/q;p' | xargs sudo apt-get -y purge

agarzon

#!/bin/bash

TIMESTAMP=$(date +'%Y-%m-%d_%Hh%Mm')
BACKUP_FOLDER=/mnt/backup/mysql
MYSQL_USER=admin
MYSQL_PASS=`cat /etc/psa/.psa.shadow`
MAX_DAYS=15
DATABASES=`mysql --user=$MYSQL_USER -p$MYSQL_PASS -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"`

mkdir -p "$BACKUP_FOLDER"