briantully

SELECT
    # Change the interval based on UTC to show on specific timezone
    date_format(date_sub(o.created_at, INTERVAL 7 HOUR), "%l:%i %p") `Time in PST`,
    count(*) OPM
FROM sales_flat_order o
# Time from the DB - last 3 hours
WHERE o.created_at > DATE_SUB(NOW(), INTERVAL 3 HOUR)
AND o.created_at < NOW()
AND o.store_id='1374'
GROUP BY HOUR(o.created_at),MINUTE(o.created_at)

briantully

# get average number of orders per min for last 8 hours

SELECT
    `Time Period`,
    round(AVG(num), 1) `Average Number of Orders Per Minute`
FROM (
    SELECT
        date_format(date_sub(o.created_at, INTERVAL 1 HOUR), "%Y-%m-%d %H:00 - %H:59 UTC") `Time Period`,
        count(*) num,
        date_format(date_sub(o.created_at, INTERVAL 8 HOUR), "%Y-%m-%d %H") sort

briantully

    colors = [
      'rgba(46, 204, 113,1.0)', // pass
      'rgba(192, 57, 43,1.0)',  // fail
      'rgba(230, 126, 34,1.0)', // error
      'rgba(241, 196, 15,1.0)', // warning
      'rgba(52, 73, 94,1.0)',   // not applicable
      'rgba(26, 188, 156,1.0)',
      'rgba(52, 152, 219,1.0)',
      'rgba(155, 89, 182,1.0)',
      'rgba(231, 76, 60,1.0)',

briantully

<?
/////////////////////
// slack2html
// by @levelsio
/////////////////////
//
/////////////////////
// WHAT DOES THIS DO?
/////////////////////
//

briantully

body { background: #0e0f0f; color: #aaaaaa; }

a { color: #949494; }

a:link, a:visited { color: #949494; }

a:hover, a:active, a:focus { color: #c7c7c7; }

hr { border-bottom: 1px solid #424242; border-top: 1px solid #222; }

briantully

#msgs_scroller_div::-webkit-scrollbar-track, #client_body::before, .client_container, 
#search_terms, #client_body, #footer, ts-message, .channel_header, ts-jumper ts-jumper-container,
ts-jumper input[type="text"],
.supports_custom_scrollbar:not(.slim_scrollbar) #col_channels:hover #channels_scroller::-webkit-scrollbar-track{
  background: #333 !important;
}

#client_body::before {
  border-bottom: 1px solid #1a2129 !important;
}

briantully

server {
    listen 8080;
    root /Users/user/Sites/magento.co.nz;
    server_name magento.dev "~magento\.(.*)\.xip\.io$";
    fastcgi_buffer_size 128k;
    fastcgi_buffers 4 256k;
    fastcgi_busy_buffers_size 256k;
    proxy_connect_timeout 90;
    proxy_send_timeout 180;
    proxy_read_timeout 180;

briantully

select
    `Time Period`,
    round(avg(num), 1) `Average Number of Orders`
from (
    select
        date_format(date_sub(o.created_at, interval 8 hour), "%l:00 - %l:59 %p PST") `Time Period`,
        count(*) num,
        date_format(date_sub(o.created_at, interval 8 hour), "%H") sort
    from sales_flat_order o
    where o.created_at > '2016-01-01 00:00:00'

briantully

#!/bin/sh

DIRECTORY="$HOME/Library/Application Support/Google/Chrome/"

cd "${DIRECTORY}"

CUR_DIR=`pwd`

echo "CURRENT DIRECTORY IS: ${CUR_DIR}"

briantully

#!/bin/sh

# This script runs every other night at 04:56 CET on a webserver I maintain
# Resulting file is always at: https://jult.net/block.txt ( or https://jult.net/block.txt.gz )
# but DON'T open that URL in a browser..
# Best use the much smaller, stripped of BS; https://jult.net/bloc.txt
# For use in Tixati IP filter: https://jult.net/bloc.txt.gz
# And finally a txt file with just the bold IP-ranges: https://jult.net/bl.txt (or https://jult.net/bl.txt.gz )

# Download open block-lists, unpack, filter: