Daan van den Bergh Dan0sz

## functions.php
<?php
// The start of my Child Theme's functions.php

function sparkling_remove_google_fonts() {
    wp_dequeue_style('sparkling-fonts');
    wp_deregister_style('sparkling-fonts');
}

add_action('wp_enqueue_scripts', 'sparkling_remove_google_fonts', 100);

## edited-wp-config.php
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define( 'DB_NAME', 'new_db_name' ); # CHANGE THIS!

/** MySQL database username */
define( 'DB_USER', 'existing_db_username' );

/** MySQL database password */
define( 'DB_PASSWORD', 'existing_db_password' );

## find-replace.sql
UPDATE `table_name`
SET `column_name` = replace(column_name, 'olddomain.com', 'newdomain.com')

## 301-redirect-with-exception.sh
RewriteEngine on
# Exception for Google Verification
RewriteCond %{REQUEST_URI} !^/google-verification-file.html
# Exception Let's Encrypt Challenge
RewriteCond %{REQUEST_URI} !^/.well-known/
# 301 Redirect to New Domain incl. Request URI
RewriteRule ^(.*)$ https://newdomain.com/$1 [R=301,L]

## host-anything-locally.php
<?php
// Script to update any js-file
// Credits go to: Matthew Horne

// Remote file to download
$remoteFile = 'https://www.google-analytics.com/analytics.js';
$localFile  = /path/to/your/webroot/analytics.js;

// Check if directory exists, otherwise create it.
$uploadDir = /path/to/your/webroot/;

## Model\Custom.php
<?php

namespace Daan\CustomModule\Model; // Or Controller, or Plugin, or anything actually.

use Magento\Framework\Pricing\PriceCurrencyInterface as CurrencyInterface;

class Custom {

	protected $currencyInterface;

## make-altinstall-python.sh
# Prerequisites for Python 2.7.x
apt-get update
apt-get install build-essential checkinstall
apt-get install libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev

# Download and extract Python 2.7.13
cd /usr/src
curl -O https://www.python.org/ftp/python/2.7.13/Python-2.7.13.tgz
tar xvfz Python-2.7.13.tgz

## total-price-of-cart.php
<?php

// Get Price of all Items in Cart including VAT/Tax
Mage::helper('checkout')->formatPrice(Mage::getSingleton('checkout/cart')->getQuote()->getGrandTotal()

// Get Total Price excluding/without VAT/Tax
Mage::helper('checkout')->formatPrice(Mage::getSingleton('checkout/cart')->getQuote()->getSubtotal()

## disable-emojis.php
<?php

// Disable WP Emoji's
function disable_emojis() {
	remove_action( 'wp_head', 'print_emoji_detection_script', 7 );
	remove_action( 'admin_print_scripts', 'print_emoji_detection_script' );
	remove_action( 'wp_print_styles', 'print_emoji_styles' );
	remove_action( 'admin_print_styles', 'print_emoji_styles' );
	remove_filter( 'the_content_feed', 'wp_staticize_emoji' );
	remove_filter( 'comment_text_rss', 'wp_staticize_emoji' );

## text-overflow.php
<?php

$text = 'your text';    // or $yourtext;
$maxPos = 50;           // Max. number of characters
if (strlen($text) > $maxPos)
{
    $lastPos = ($maxPos - 3) - strlen($text);
    $text = substr($text, 0, strrpos($text, ' ', $lastPos)) . '...';
}
echo $text;