CajuCLC’s gists

CajuCLC / magento-admin-user-via-database.sql

Last active July 2, 2018 18:51

	LOCK TABLES `admin_role` WRITE , `admin_user` WRITE;

	SET @SALT = "ms";
	SET @PASSWORD = "password";
	SET @PASS = CONCAT(MD5(CONCAT( @SALT , @PASSWORD) ), CONCAT(":", @SALT ));
	SET @FIRSTNAME = "firstname";
	SET @LASTNAME = "lastname";
	SET @EMAIL = "[email protected]";
	SET @USERNAME = "myusername";
	SELECT @EXTRA := MAX(extra) FROM admin_user WHERE extra IS NOT NULL;

CajuCLC / magento_clearcache.php

Created June 24, 2018 07:32

	<?php
	/**
	* Clear cache via CLI
	*
	* @category MageBR
	* @author Eric Cavalcanti <[email protected]>
	* @license MageBR License
	* @link https://www.magebr.com
	*/

CajuCLC / magento_crawler.sh

Created June 5, 2018 17:42

Magento Crawler

	#!/bin/bash
	URL='domain.com'

	wget --quiet http://$URL/sitemap.xml --no-cache --output-document - \| egrep -o "http://$URL[^<]+" \| while read line; do
	time curl -A 'Cache Warmer' -s -L $line > /dev/null 2>&1
	echo $line
	done

CajuCLC / preco.html

Last active March 26, 2018 13:07

tenda atualizar preço produto

	<html>
	<body>

	<form action="trocapreco.php" method="post">
	Valor: <input type="text" name="preco"><br>
	<input type="submit">
	</form>

	</body>
	</html>

CajuCLC / dev_tenda_header.txt

Created February 23, 2018 19:32

dev tenda header

	* Trying 104.25.181.16...
	* TCP_NODELAY set
	* Connected to dev.tendagospel.com (104.25.181.16) port 443 (#0)
	* ALPN, offering h2
	* ALPN, offering http/1.1
	* Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@STRENGTH
	* successfully set certificate verify locations:
	* CAfile: /etc/ssl/cert.pem
	CApath: none
	* TLSv1.2 (OUT), TLS handshake, Client hello (1):

CajuCLC / tenda_header.txt

Created February 23, 2018 19:31

tenda_header

	* Trying 104.25.181.16...
	* TCP_NODELAY set
	* Connected to tendagospel.com (104.25.181.16) port 443 (#0)
	* ALPN, offering h2
	* ALPN, offering http/1.1
	* Cipher selection: ALL:!EXPORT:!EXPORT40:!EXPORT56:!aNULL:!LOW:!RC4:@STRENGTH
	* successfully set certificate verify locations:
	* CAfile: /etc/ssl/cert.pem
	CApath: none
	* TLSv1.2 (OUT), TLS handshake, Client hello (1):

CajuCLC / magento1_currency_code_options

Created December 3, 2017 04:36

AFN,MGA,THB,PAB,ETB,BOB,VEF,VEB,GHS,SVC,CRC,CZK,DKK,SKK,EEK,ISK,NOK,SEK,ZMK,AOA,GEK,NIC,GMD,DZD,BHD,KWD,IQD,JOD,LYD,MKD,RSD,TND,MAD,AED,STD,VND,AMD,AUD,BSD,BBD,CAD,NZD,BMD,KYD,SBD,SGD,HKD,TTD,BZD,BND,XCD,ZWD,FJD,GYD,JMD,LRD,NAD,USD,RHD,SRD,GQE,CVE,EUR,CHE,AWG,ANG,HUF,XOF,XPF,CHW,BIF,KMF,CDF,DJF,GNF,RWF,CHF,HTG,PYG,UAH,JPY,PGK,LAK,HRK,MWK,BUK,MMK,GEL,LVL,ALL,HNL,SLL,MDL,RON,ROL,BGN,GIP,SHP,EGP,GBP,LBP,FKP,SDG,SYP,SZL,TRY,TRL,LTL,LSL,AZM,AZN,TMM,BAM,MZN,NGN,ERN,BTN,TWD,PEN,MRO,MOP,TOP,ARS,CLP,COP,CUP,DOP,PHP,MXN,UYU,BWP,GTQ,ZAR,BRL,QAR,YER,IRR,OMR,SAR,KHR,MYR,BYR,RUB,LKR,INR,IDR,MVR,MUR,NPR,PKR,SCR,ILS,KGS,UZS,TJS,BDT,WST,KZT,MNT,VUV,KPW,KRW,TZS,KES,SOS,UGX,CNY,PLN

CajuCLC / magento1_timezone_options

Created December 3, 2017 04:35

	php -f install.php -- --get_options
	array (
	'locale' =>
	array (
	0 =>
	array (
	'value' => 'af_ZA',
	'label' => 'Afrikaans (South Africa)',
	),
	1 =>

CajuCLC / magento1_enterprise_index_diagnostics.sql

Created November 9, 2017 19:53 — forked from mttjohnson/magento1_enterprise_index_diagnostics.sql

Magento 1.x Enterprise Partial Indexing Diagnostics Toolset

	-- When products are added/removed from a category this table stores all the relation data
	select * from catalog_category_product where product_id = '24526';

	-- The index that is used for presenting products in a category on the frontend
	select * from catalog_category_product_index where product_id = '24526';

	-- The change log table used for Magento EE partial index functionality
	select * from catalog_category_product_index_cl where product_id = '24526' and version_id > (select version_id from enterprise_mview_metadata where changelog_name = 'catalog_category_product_index_cl');

CajuCLC / aws_ami

Created October 20, 2017 01:57

	[PHP Modules]
	bcmath
	bz2
	calendar
	Core
	ctype
	curl
	date
	dom
	ereg

Eric Cavalcanti CajuCLC