Skip to content

Instantly share code, notes, and snippets.

View SaeedSoltoon's full-sized avatar

Saeed Soltani SaeedSoltoon

View GitHub Profile
Accessing docker container private network easily from your boot2docker host
-----
(from http://ispyker.blogspot.com/2014/04/accessing-docker-container-private.html)
add a Host-only adapter in VirtualBox
OSX:
# show route table
netstat -nr
@SaeedSoltoon
SaeedSoltoon / get_woocommerce_completed_orders_for_all_users.sql
Created January 1, 2021 15:04
Woocommerce Get All Users Completed Orders Total Mysql Query, Product names concatenated by | and exported to csv
SELECT u.ID,
u.display_name as fullname,
GROUP_CONCAT(oi.order_item_name SEPARATOR ' | ') as courses,
SUM(pm2.meta_value) as order_total
FROM wp_users as u
INNER JOIN wp_posts as p on p.post_status = 'wc-completed'
INNER JOIN wp_postmeta as pm on pm.post_id = p.ID
and pm.meta_key = '_customer_user'
and u.ID = pm.meta_value
INNER JOIN wp_postmeta as pm2 on pm2.post_id = p.ID
@SaeedSoltoon
SaeedSoltoon / my.cnf
Created May 19, 2020 15:33 — forked from fevangelou/my.cnf
Optimized my.cnf configuration for MySQL/MariaSQL (on Ubuntu, CentOS etc. servers)
# Optimized my.cnf configuration for MySQL/MariaSQL
#
# by Fotis Evangelou, developer of Engintron (engintron.com)
#
# ~ Updated January 2020 ~
#
#
# The settings provided below are a starting point for a 2GB - 4GB RAM server with 2-4 CPU cores.
# If you have different resources available you should adjust accordingly to save CPU, RAM & disk I/O usage.
#
@SaeedSoltoon
SaeedSoltoon / user-agents
Last active January 7, 2020 11:26
Get list of all user agents from nginx access log
awk -F'"' '/GET/ {print $6}' /var/log/nginx-access.log | cut -d' ' -f1 | sort | uniq -c | sort -rn
@SaeedSoltoon
SaeedSoltoon / .zshrc
Created December 24, 2019 06:47
useful aliases
alias ci='composer install'
alias c='composer'
alias cu='composer update'
alias o='open .'
alias ..='cd ..'
alias ...='cd ../..'
alias ....='cd ../../..'
alias gs='git status'
alias gsh='git push'
alias gll='git pull'
@SaeedSoltoon
SaeedSoltoon / notes.md
Created November 24, 2019 09:43 — forked from inecmc/notes.md
How to run multiple Redis instances on Ubuntu 16.04

Create the directory for the new instance

$ sudo install -o redis -g redis -d /var/lib/redis2

Create a new configuration file

$ sudo cp -p /etc/redis/redis.conf /etc/redis/redis2.conf
@SaeedSoltoon
SaeedSoltoon / reddit-signup.js
Created June 12, 2019 09:07 — forked from jsoverson/reddit-signup.js
Reddit signup script w/Puppeteer and 2Captcha
const puppeteer = require('puppeteer');
const request = require('request-promise-native');
const poll = require('promise-poller').default;
const siteDetails = {
sitekey: '6LeTnxkTAAAAAN9QEuDZRpn90WwKk_R1TRW_g-JC',
pageurl: 'https://old.reddit.com/login'
}
const getUsername = require('./get-username');
@SaeedSoltoon
SaeedSoltoon / .htaccess
Created February 6, 2018 11:52 — forked from ScottPhillips/.htaccess
Common .htaccess Redirects
#301 Redirects for .htaccess
#Redirect a single page:
Redirect 301 /pagename.php http://www.domain.com/pagename.html
#Redirect an entire site:
Redirect 301 / http://www.domain.com/
#Redirect an entire site to a sub folder
Redirect 301 / http://www.domain.com/subfolder/