Skip to content

Instantly share code, notes, and snippets.

View MagePsycho's full-sized avatar

magepsycho MagePsycho

View GitHub Profile
@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<magepsycho@gmail.com>
* @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 / mysql-create-db-user.sh
Last active November 5, 2023 05:44
Bash Script: Create MySQL Database & User - https://blog.magepsycho.com/
#!/bin/bash
#
# Script to create MySQL db + user
#
# @author Raj KB <magepsycho@gmail.com>
# @website http://www.magepsycho.com
# @version 0.1.0
################################################################################
@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 / m2-installer.sh
Last active December 2, 2022 08:47
Magento 2 Installer - Full Bash Script with Documentation - https://github.com/MagePsycho/magento2-installer-bash-script
#!/usr/bin/env bash
#
# Script to install Magento2
#
# @author Raj KB <magepsycho@gmail.com>
# @website http://www.magepsycho.com
# @version 0.1.0
# UnComment it if bash is lower than 4.x version
@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 / Installation.md
Last active June 3, 2022 09:44
Wordpress: Cheatsheet

Manually (Option 1)

warden shell
cd /tmp
curl -O https://wordpress.org/latest.tar.gz
tar -zxvf latest.tar.gz
touch /tmp/wordpress/.htaccess
mkdir /tmp/wordpress/wp-content/upgrade
cp /tmp/wordpress/wp-config-sample.php /tmp/wordpress/wp-config.php
cp -a /tmp/wordpress/. /var/www/html
@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 / varcharToPriceConverter.php
Created January 14, 2020 13:45
How to convert varchar type attribute to decimal/price type in Magento? - https://blog.magepsycho.com/how-to-convert-attribute-type-of-varchar-to-price-in-magento/
<?php
/**
* @author Raj KB <magepsycho@gmail.com>
* @website https://www.magepsycho.com
*
*/
$mageFilename = 'app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
@MagePsycho
MagePsycho / default.vcl
Created February 21, 2019 10:49
Wordpress Varnish VCL File
vcl 4.0;
import std;
import directors;
backend server1 {
.host = "127.0.0.1"; # IP or Hostname of backend
.port = "8080"; # Port Apache or whatever is listening
.max_connections = 800; # That's it
.first_byte_timeout = 300s; # How long to wait before we receive a first byte from our backend?
@MagePsycho
MagePsycho / README.md
Last active July 6, 2018 21:40
Code Deployment via Webhook (Bitbucket)

Assumption

  • OS: Ubuntu 16.04
  • SCM: Bitbucket
  • Remote Git Repo: git@bitbucket.org:magepsycho/magepsycho.git
  • Deployment Branch: master
  • Web Root Dir: /var/www/magento2/magepsycho
  • Git Repo Dir: /var/www/magento2/magepsycho.git

Git Setup

In remote server