kibotu

// http://stackoverflow.com/questions/1249973/decompiling-dex-into-java-sourcecode/4177581#4177581

0. brew install apktool

   apktool -d app.apk

1. dex2jar, which is made by a Chinese student. It will translate dex files to jar files

   brew install dex2jar

Tomasz-Silpion

SELECT 
o.grand_total AS 'Order Total',
o.created_at AS 'Payment Day',
p.method AS 'Payment Method',
CONCAT_WS(' ', o.customer_firstname, o.customer_lastname) AS 'Customer Name',
o.increment_id AS 'Order Number'

FROM sales_flat_order o
LEFT JOIN sales_flat_order_payment p ON p.entity_id = o.entity_id
WHERE (o.created_at BETWEEN '2016-01-01' AND '2016-12-31')

olih

Processing JSON using jq

jq is useful to slice, filter, map and transform structured json data.

Installing jq

On Mac OS

brew install jq

SmetDenis

<?php

// https://pear.php.net/manual/en/package.php.php-codesniffer.advanced-usage.php
// @codingStandardsIgnoreLine
// @codingStandardsIgnoreFile
// @codingStandardsIgnoreStart
// @codingStandardsIgnoreEnd

// https://phpunit.de/manual/current/en/appendixes.annotations.html#appendixes.annotations.codeCoverageIgnore
// @codeCoverageIgnore

mehdichaouch

#!/bin/bash

###############################
### Magento Permissions

find . -type f -exec chmod 644 {} \; && find . -type d -exec chmod 755 {} \; && chmod o+w var var/.htaccess includes includes/config.php app/etc && chmod 550 pear && sudo find *.sh -type f -exec chmod 755 {} \;

rm -rf var/cache/*
rm -rf var/session/*

Nolwennig

DELETE 
  FROM `core_email_queue_recipients` 
  WHERE `core_email_queue_recipients`.`message_id` NOT IN 
  (
    SELECT `core_email_queue`.`message_id` 
    FROM `core_email_queue`
  )

parmentf

Inspired by dannyfritz/commit-message-emoji

See also gitmoji.

Commit type	Emoji
Initial commit	🎉 :tada:
Version tag	🔖 :bookmark:
New feature	✨ :sparkles:
Bugfix	🐛 :bug:

rugbymauri

{
  "semart" : {
    "display"   : "xxx Magento",
    "path"      : "\/home\/xxx\/public_html\/yyyy\/magento\/var\/log\/system.log",
    "refresh"   : 5,
    "max"       : 10,
    "export"    : true,
    "notify"    : true,
    "tags"    : [ "magento"],
    "multiline" : "",

guntidheerajkumar

setInterval(function updateClock() {
   var currentTime = new Date();
   var currentHours = currentTime.getHours();
   var currentMinutes = currentTime.getMinutes();
   var currentSeconds = currentTime.getSeconds();
   // Pad the minutes and seconds with leading zeros, if required
   currentMinutes = (currentMinutes < 10 ? "0" : "") + currentMinutes;
   currentSeconds = (currentSeconds < 10 ? "0" : "") + currentSeconds;
   // Choose either "AM" or "PM" as appropriate

rponte

# The command finds the most recent tag that is reachable from a commit.
# If the tag points to the commit, then only the tag is shown.
# Otherwise, it suffixes the tag name with the number of additional commits on top of the tagged object 
# and the abbreviated object name of the most recent commit.
git describe

# With --abbrev set to 0, the command can be used to find the closest tagname without any suffix:
git describe --abbrev=0

# other examples