Skip to content

Instantly share code, notes, and snippets.

View Tomasz-Silpion's full-sized avatar
💭
I may be slow to respond.

Tomasz Gregorczyk Tomasz-Silpion

💭
I may be slow to respond.
View GitHub Profile
@Tomasz-Silpion
Tomasz-Silpion / gpsmp.sh
Created February 7, 2017 00:59
Script for parsing Google PageSpeed optimized content MANIFEST
# 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
@Tomasz-Silpion
Tomasz-Silpion / backup.sh
Created January 28, 2017 02:07
Shell script for database and files site backup
# Database credentials
DB_USER=""
DB_PASS=""
DB_HOST=""
DB_NAME=""
# Database dump
mysqldump --user=$DB_USER --password=$DB_PASS --host=$DB_HOST $DB_NAME > $(date +"%d-%m-%Y").sql
# Files backup
@Tomasz-Silpion
Tomasz-Silpion / prolong_cookie.php
Created December 12, 2016 17:27
Prolong all cookies by 1 minute (extending all cookies lifetime)
@Tomasz-Silpion
Tomasz-Silpion / cleanup.sh
Created November 19, 2016 00:00
Basic bash script to git stash every server directory
for d in */ ; do
(cd $d && git stash)
done
@Tomasz-Silpion
Tomasz-Silpion / validation.js
Created August 20, 2016 01:44
Prototype.js Magento value trim (replace spaces) on email validation
$$('.validate-email').each(function(input){
input.observe('change', function(e){
this.value = this.value.replace(/^\s+|\s+$/g,"");
});
});
@Tomasz-Silpion
Tomasz-Silpion / providers.php
Last active August 10, 2016 13:48
Count customers email domain occurences from Magento orders
<?php
require_once('app/Mage.php');
umask(0);
Mage::app();
$emails = array();
$orders = Mage::getModel('sales/order')->getCollection();
foreach ($orders as $order) {
$emails[] = $order->getCustomerEmail();
@Tomasz-Silpion
Tomasz-Silpion / payments.sql
Created July 20, 2016 17:20
Get all customers payment methods between range of dates from Magento database
SELECT
o.grand_total AS 'Order Total',
o.created_at AS 'Payment Day',
p.method AS 'Payment Method',
CONCAT_WS(' ', o.customer_firstname, o.customer_lastname) AS 'Customer Name',
o.increment_id AS 'Order Number'
FROM sales_flat_order o
LEFT JOIN sales_flat_order_payment p ON p.entity_id = o.entity_id
WHERE (o.created_at BETWEEN '2016-01-01' AND '2016-12-31')