Skip to content

Instantly share code, notes, and snippets.

View MagePsycho's full-sized avatar

magepsycho MagePsycho

168 followers · 557 following
View GitHub Profile
@MagePsycho
MagePsycho / Magento2-Sandbox-Script.php
Last active September 9, 2023 11:48
Magento2 Sandbox Script - http://www.blog.magepsycho.com/sandbox-script-quick-testing-magento2/
<?php
####################################################
# EDIT
$rootMagentoDir = __DIR__;
#$csvFile = $rootMagentoDir . '/update_skus.csv';
$logFile = $rootMagentoDir . '/var/log/cli-operation.log';
$dryRun = 0;
####################################################
@MagePsycho
MagePsycho / bash-alias-toggle-php-xdebug.sh
Last active March 28, 2017 15:17
Toggle PHP XDebug in Ubuntu
phpToggleXdebug() {
case $1 in
on)
[ -f /etc/php5/mods-available/xdebug.ini.deactivated ] && sudo mv /etc/php5/mods-available/xdebug.ini.deactivated /etc/php5/mods-available/xdebug.ini
sudo service php5-fpm restart
sudo service nginx restart
;;
off)
[ -f /etc/php5/mods-available/xdebug.ini ] && sudo mv /etc/php5/mods-available/xdebug.ini /etc/php5/mods-available/xdebug.ini.deactivated
sudo service php5-fpm restart
@MagePsycho
MagePsycho / mysql-create-db-user.sh
Last active January 8, 2025 00:09
Bash Script: Create MySQL Database & User - https://blog.magepsycho.com/
#!/bin/bash
#
# Script to create MySQL db + user
#
# @author Raj KB <[email protected]>
# @website http://www.magepsycho.com
# @version 0.1.0
################################################################################
@MagePsycho
MagePsycho / magento2-useful-commands.md
Created June 5, 2017 18:06
Magento2 - Useful Commands

Collect translation from Module: mage2 i18n:collect-phrases --output="app/code/MagePsycho/RedirectPro/i18n/en_US.csv" app/code/MagePsycho/RedirectPro/

@MagePsycho
MagePsycho / m2-import-prices-index.php
Last active January 8, 2024 03:08
Update Magento2 Prices in bulk - an easier and faster way! - https://www.magepsycho.com/magento2-mass-regular-special-tier-group-price-importer.html
<?php
/**
*
* @author Raj KB<[email protected]>
* @website http://www.magepsycho.com
* @extension MassImporterPro: Pricing - http://www.magepsycho.com/mass-importer-pro-price-importer-regular-special-tier-group.html
*/
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
@MagePsycho
MagePsycho / dump-all-dbs.sh
Last active October 6, 2017 06:44
MySQL: Dump all databases in a localhost
#! /bin/bash
TIMESTAMP=$(date +"%F")
BACKUP_DIR="/home/rajendra"
MYSQL=/usr/bin/mysql
MYSQL_USER="root"
MYSQL_PASSWORD="mys123"
MYSQLDUMP=/usr/bin/mysqldump
mkdir -p "$BACKUP_DIR/mysql-dump"
@MagePsycho
MagePsycho / dynamic-table.sql
Last active August 7, 2017 18:52
MySQL: Dynamic Table + SQL
-- @author Raj KB
-- @website http://blog.magepsycho.com
SET @STORE_ID = 7;
SET @CATALOG_FLAT_TABLE = CONCAT('catalog_product_flat_', @STORE_ID);
SET @QUERY = CONCAT('SELECT * FROM ', @CATALOG_FLAT_TABLE, ' LIMIT 10');
PREPARE stmt FROM @QUERY;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
@MagePsycho
MagePsycho / mysql-cumulative-sum.sql
Created August 7, 2017 19:18
MySQL: Running Total (Cumulative Sum)
-- without using SET variable
SELECT t.id,
t.count,
(@running_total := @running_total + t.count) AS cumulative_sum
FROM TABLE t
JOIN (SELECT @running_total := 0) r
ORDER BY t.id
-- with SET variable
SET @running_total := 0;
@MagePsycho
MagePsycho / Mongo-Installation-Ubuntu-20.04.md
Last active August 30, 2022 08:08
MongoDb (Server, Client, PHP Extension) #mongo #mongodb

Install MongoDB

wget -qO - https://www.mongodb.org/static/pgp/server-4.2.asc | sudo apt-key add -
echo "deb [ arch=amd64 ] https://repo.mongodb.org/apt/ubuntu bionic/mongodb-org/4.2 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-4.2.list
sudo apt-get update
sudo apt-get install -y mongodb-org

# Start MongoDB
sudo systemctl start mongod
@MagePsycho
MagePsycho / .gitignore
Created August 28, 2017 20:18
Magento 1: Gitignore
# General web stuff
#/.htaccess
/robots.txt
/sitemap.xml
# Dynamic Magento data
/var/*
/media/catalog/product/cache/*
/media/tmp/
/media/js/*