Tomasz-Silpion

DELETE FROM `wp_woocommerce_order_itemmeta`;
DELETE FROM `wp_woocommerce_order_items`;
DELETE FROM `wp_comments` WHERE `comment_type` = 'order_note';
DELETE FROM `wp_postmeta` WHERE `post_id` IN (SELECT `ID` FROM `wp_posts` WHERE `post_type` = 'shop_order');
DELETE FROM `wp_posts` WHERE `post_type` = 'shop_order';
DELETE FROM `wp_users` WHERE `wp_users`.`ID` NOT IN (SELECT `meta_value` FROM `wp_postmeta` WHERE `meta_key` = '_customer_user') AND `wp_users`.ID NOT IN (SELECT DISTINCT (`post_author`) FROM `wp_posts`);
DELETE FROM `wp_usermeta` WHERE `user_id` NOT IN (SELECT `ID` FROM `wp_users`);
TRUNCATE `wp_woocommerce_order_items`;
TRUNCATE `wp_woocommerce_order_itemmeta`;

Tomasz-Silpion

pca.on("load", function (type, id, control) {
    control.listen("populate", function (address) {
        console.log('here');
    });
});

Tomasz-Silpion

<?php

require_once 'abstract.php';

class Hide_Children_Products extends Mage_Shell_Abstract {

    /**
     * Hide products having at least one configurable parent
     */
    public function run()

Tomasz-Silpion

SELECT DISTINCT `recipient_email` FROM `core_email_queue` INNER JOIN `core_email_queue_recipients` ON `core_email_queue`.`message_id` = `core_email_queue_recipients`.`message_id` WHERE `processed_at` > '2017-10-30 00:00:00' AND `created_at` < '2017-10-25 00:00:00' 

Tomasz-Silpion

<?php

/**
 * @author Silpion <tomasz@silpion.com.pl>
 */

class Config {

    protected $config = [
        'a' => [

Tomasz-Silpion

location ^~ /media/catalog/product/cache/ {

	try_files $uri @nocache;
}
location @nocache {

	rewrite ^/(media/catalog/product)/(.*/.*/.*/.*)/(.*/.*/.*) /$1/$3 redirect;
}

Tomasz-Silpion

# Magento2 shell script shorthand for redeployment 

php bin/magento setup:upgrade
cd tools && gulp clean && cd ..
php bin/magento setup:di:compile
php bin/magento setup:static-content:deploy
cd tools && gulp styles && cd ..
chmod -R 775 var
chmod -R 775 pub/static

Tomasz-Silpion

<?php

require('./wp-load.php');

$wpo_wcpdf = WPO_WCPDF();
$pdf = $wpo_wcpdf->export->get_pdf('invoice', array($order_id));

header("Content-type:application/pdf");
echo $pdf;

Tomasz-Silpion

<?php

define('WP_USE_THEMES', false);
require('./wp-load.php');

$args = array('post_type' => 'product', 'posts_per_page' => -1);

$loop = new WP_Query($args);

while ($loop->have_posts()) : $loop->the_post();

Tomasz-Silpion

# Script for parsing Google PageSpeed optimized content MANIFEST
# Copyright (C) 2016 Tomasz Silpion Gregorczyk - All Rights Reserved

file="MANIFEST"
while IFS= read line
do    

#strip file paths
IFS=':' read -r src protocol url <<EOF
$line