View truncate_woocommerce_data.sql
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`; |
View pca.js
pca.on("load", function (type, id, control) { | |
control.listen("populate", function (address) { | |
console.log('here'); | |
}); | |
}); |
View hide_children_products.php
<?php | |
require_once 'abstract.php'; | |
class Hide_Children_Products extends Mage_Shell_Abstract { | |
/** | |
* Hide products having at least one configurable parent | |
*/ | |
public function run() |
View recipients.sql
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' |
View config.php
<?php | |
/** | |
* @author Silpion <tomasz@silpion.com.pl> | |
*/ | |
class Config { | |
protected $config = [ | |
'a' => [ |
View nocache.conf
location ^~ /media/catalog/product/cache/ { | |
try_files $uri @nocache; | |
} | |
location @nocache { | |
rewrite ^/(media/catalog/product)/(.*/.*/.*/.*)/(.*/.*/.*) /$1/$3 redirect; | |
} |
View deploy.sh
# 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 |
View wcpdf.php
<?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; |
View fix_stock.php
<?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(); |
View gpsmp.sh
# 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 |
NewerOlder