This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT `e`.entity_id, `at_category_id`.`category_id` | |
FROM `catalog_product_entity` AS `e` | |
LEFT JOIN `catalog_category_product` AS `at_category_id` | |
ON (at_category_id.`product_id`=e.entity_id) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/bin/bash | |
# | |
# This script configures WordPress file permissions based on recommendations | |
# from http://codex.wordpress.org/Hardening_WordPress#File_permissions | |
# | |
# Author: Michael Conigliaro | |
# | |
WP_OWNER=changeme # <-- wordpress owner | |
WP_GROUP=changeme # <-- wordpress group | |
WP_ROOT=/home/changeme # <-- wordpress root directory |
Here is a high level overview for what you need to do to get most of an Android environment setup and maintained.
Prerequisites (for Homebrew at a minimum, lots of other tools need these too):
- XCode is installed (via the App Store)
- XCode command line tools are installed (
xcode-select --install
will prompt up a dialog) - Java
Install Homebrew:
ruby -e "$(curl -fsSL https://raw.github.com/Homebrew/homebrew/go/install)"
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// iMacro CheatSheet - Command Reference | |
// http://wiki.imacros.net/Command_Reference | |
// iMacros supports 3 types of variables: | |
// * The macro variables !VAR0 thru !VAR9. They can be used with the SET and ADD command inside a macro. | |
// * Built-in variables. They contain certain values set by iMacros. | |
// * User-defined variables. They are defined in-macro using the SET command. | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// iMacros Bootstrap - Write your macros with JavaScript. | |
// Be careful, you need to rename and set the extension of your macro to ".js". | |
// 1. Variables Initialization. | |
var variable1, variable2, variable3; | |
macro = ""; |
Find a list of magento sku's and the category paths they belong in via MySQL query.
SELECT product_id, sku, catid, cce.path FROM (
SELECT entity_id as product_id, category_id as catid FROM (
SELECT `e`.entity_id, `at_category_id`.`category_id`
FROM `catalog_product_entity` AS `e`
LEFT JOIN `catalog_category_product` AS `at_category_id`
ON (at_category_id.`product_id`=e.entity_id)
) sub_query
) final_query
Hierarchical data metrics that allows fast read operations on tree like structures.
Based on Left and Right fields that are set during tree traversal. When entered into node value is set to it's Left, when exiting node value is set to it's Right.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Perform a Network Service Lookup, using StatDNS API. | |
* | |
* @param {"google.com"} dn A well-formed domain name to resolve. | |
* @return {String} Resolved IP address | |
* @customfunction | |
*/ | |
function NSLookup(dn) { | |
// From gist.github.com/mogsdad/ece531531e0ef5dc355d | |
var url = "http://api.statdns.com/%FQDN%/a".replace("%FQDN%",dn); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Para a inscrição: | |
1. {{var customer}} irá imprimir todas as informações do cliente | |
2. {{var customer.ID}} | |
3. {{var customer.email}} | |
4. {{var customer.firstname}} | |
5. {{var customer.lastname}} | |
6. {{var customer.name}} | |
7. {{var customer.password}} | |
8. {{var customer.created_in}} |