carlosleopoldo

#!/bin/sh

wget https://xdebug.org/files/xdebug-2.5.5.tgz
tar xvzf xdebug-2.5.5.tgz
cd xdebug-2.5.5
phpize
./configure
make
sudo cp modules/xdebug.so /usr/lib/php/20160303/
cd /etc/php/7.2/fpm/conf.d/

carlosleopoldo

# To recursively give directories read & execute privileges
chmod 755 $(find /path/to/base/dir -type d)

# To recursively give files read privileges
chmod 644 $(find /path/to/base/dir -type f)

carlosleopoldo

DELETE FROM wp_postmeta
WHERE post_id NOT IN (
  SELECT ID FROM wp_posts
);

carlosleopoldo

DELETE FROM wp_commentmeta
WHERE comment_id NOT IN (
  SELECT comment_id FROM wp_comments
);

carlosleopoldo

DELETE FROM wp_usermeta
WHERE NOT EXISTS (
  SELECT * FROM wp_users
	WHERE wp_usermeta.user_id = wp_users.ID
)

carlosleopoldo

-- Select users in WordPress without specific user meta key
-- * Replace meta_name for your meta key
-- * Replace > 0 for the minimum user ID

SELECT wp_users.ID
FROM wp_users
WHERE wp_users.ID > 0
AND wp_users.ID NOT IN (
  SELECT DISTINCT user_id FROM wp_usermeta WHERE meta_key = 'meta_name'
)

carlosleopoldo

find . -name '*.DS_Store' -type f -delete

carlosleopoldo

<?php

/**
 * Twitter Bootstrap Walker
 */

class Bootstrap_Walker_Nav_Menu extends Walker_Nav_Menu {
	/**
	 * @see Walker::start_el()
	 * @since 3.0.0