How to remove WordPress spam users using MySQL command line

Here is described way to remove spam users you got on 2019-03

select * from wp_users where user_registered like '2019-03%';

MariaDB [db]> select * from wp_users where user_registered like '2019-03%';
15215 rows in set (0.027 sec
delete from wp_users where user_registered like '2019-03%';

MariaDB [db]> delete from wp_users where user_registered like '2019-03%';
Query OK, 15204 rows affected (0.682 sec)
Read the rest

How to install multiple Drush versions on the account

It requires a lot of resources, so double check if you have enough

The latest dev version to drush/ folder:

mkdir drush
cd drush
curl -sS https://getcomposer.org/installer | php
./composer.phar require drush/drush:dev-master
cd
echo "alias drush='~/drush/vendor/bin/drush'" >> .bashrc
source .bashrc

Drush 9 version

mkdir drush9
cd drush9
curl -sS https://getcomposer.org/installer
Read the rest

Child failed to make LIVEAPI connection to cPanel.

Just do reinstall

cd /usr/local/cpanel
rm -rf cloudflare*
curl -k -L https://github.com/cloudflare/CloudFlare-CPanel/tarball/master > cloudflare.tar.gz
tar -zxvf cloudflare.tar.gz
cd /usr/local/cpanel/cloudflare-Cloudflare-CPanel-*
./cloudflare.install.sh -k YOUR_KEY_HERE -n LABEL_HERE

Another way:

bash <(curl -s https://raw.githubusercontent.com/cloudflare/CloudFlare-CPanel/master/cloudflare.install.sh) -k YOUR_KEY_HERE -n COMPANY_NMAME_HERE

Source:

https://support.cloudflare.com/hc/en-us/articles/204010320-How-can-I-get-started-with-Cloudflare-s-cPanel-plugin-Read the rest

Drupal 8 index.php file

<?php
/**
@file
The PHP page that serves all page requests on a Drupal installation.
*
All Drupal code is released under the GNU General Public License.
See COPYRIGHT.txt and LICENSE.txt files in the "core" directory.
*/
use Drupal\Core\DrupalKernel;
use Symfony\Component\HttpFoundation\Request;
$autoloader = require_once 'autoload.php';
Read the rest

How to upgrade ZenCart from 1.3.x to ZenCart 1.5.x

First of all backup your current website’s version (files/folders/database)

Supposed you have ZenCart on yourdomain.com pointed to /home/USERNAME/public_html

So, we will upgrade your ZenCart to /home/USERNAME/public_html/shop to prevent any issue with your current installation.

Create sub domain shop.yourdomain.com and point it to /home/USERNAME/public_html/shop

Create if needed shop folder under /home/USERNAME/public_html/

mkdir -p shop
cd shop/

Download the latest version

wget https://sourceforge.net/projects/zencart/files/CURRENT%20-%20Zen%20Cart%201.5.x%20Series/zen-cart-v1.5.5f-12312017b.zip
Read the rest