rafaelstz

SET @entityid = '3';

SELECT ea.attribute_id, ea.attribute_code, eav.value AS 'value', 'varchar' AS 'type'
FROM catalog_category_entity e
JOIN catalog_category_entity_varchar eav
  ON e.entity_id = eav.entity_id
JOIN eav_attribute ea
  ON eav.attribute_id = ea.attribute_id
WHERE e.entity_id = @entityid
UNION

rafaelstz

#=========================#
# LeSite eCommerce Agency #
#=========================#

# Custom
#=========================#
/.dep/*
/.github
/*.sql
/*.sql.gz

rafaelstz

// Exemplo de requisição GET
var ajax = new XMLHttpRequest();

// Seta tipo de requisição e URL com os parâmetros
ajax.open("GET", "minha-url-api.com/?name=Henry&lastname=Ford", true);

// Envia a requisição
ajax.send();

// Cria um evento para receber o retorno.

rafaelstz

Magento Code Snippets

Download extension manually using mage

./mage config-set preferred_state stable
./mage clear-cache
./mage sync
./mage download community Module_Name

rafaelstz

server {
    listen 80;
    server_name localhost;
 
    root /var/www/cabocla;
 
    autoindex off;
    location /app/                { deny all; }
    location /includes/           { deny all; }
    location /lib/                { deny all; }

rafaelstz

<!-- Facebook Pixel Code --> 
<script> 
	!function(f,b,e,v,n,t,s){if(f.fbq)return;n=f.fbq=function(){n.callMethod? 
	n.callMethod.apply(n,arguments):n.queue.push(arguments)};if(!f._fbq)f._fbq=n; 
	n.push=n;n.loaded=!0;n.version='2.0';n.queue=[];t=b.createElement(e);t.async=!0; 
	t.src=v;s=b.getElementsByTagName(e)[0];s.parentNode.insertBefore(t,s)}(window, 
	document,'script','//connect.facebook.net/en_US/fbevents.js');

	fbq('init', 'Put your pixel ID here'); 
	fbq('track', "PageView");

rafaelstz

# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

rafaelstz

# With Sudo

sudo find . -type d -exec chmod 755 {} \;
sudo find . -type f -exec chmod 644 {} \;
sudo chmod 777 -R app/etc/;
sudo chmod 777 -R var/;
sudo chmod 777 -R media/;

# Without Sudo

rafaelstz

<reference name="breadcrumbs">
    <action method="addCrumb">
        <crumbname>Home</crumbname>
        <crumbinfo>
            <label>Home</label>
            <title>Home</title>
            <link>/</link>
        </crumbinfo>
    </action>
    <action method="addCrumb">

rafaelstz

SET FOREIGN_KEY_CHECKS=0; 
DROP TABLE my_first_table_to_drop; 
DROP TABLE my_second_table_to_drop; 
SET FOREIGN_KEY_CHECKS=1;