Skip to content

Instantly share code, notes, and snippets.

View mikaelz's full-sized avatar

Michal Zuber mikaelz

34 followers · 33 following
View GitHub Profile
@mikaelz
mikaelz / wc-delete-old-shop-orders.sql
Created October 14, 2020 09:02
Delete old (not current year) WooCommerce shop orders
DELETE
FROM wp_postmeta
WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = 'shop_order' AND YEAR(post_date) != YEAR(NOW()));
DELETE
FROM wp_commentmeta
WHERE comment_id IN (SELECT comment_ID
FROM wp_comments
WHERE comment_post_id IN
(SELECT ID FROM wp_posts WHERE post_type = 'shop_order' AND YEAR(post_date) != YEAR(NOW()))
@mikaelz
mikaelz / rc.lua
Created May 5, 2020 04:16
AwesomeWM spawn terminal on focused screen and tag
awesome-client 'awful=require("awful");awful.spawn(terminal, {tag = mouse.screen.selected_tag})'
@mikaelz
mikaelz / mosaic-live-6ch-substream.sh
Last active January 30, 2024 21:19
Grid/mosaic view RTSP streams with ffmpeg based on https://trac.ffmpeg.org/wiki/Create%20a%20mosaic%20out%20of%20several%20input%20videos
#!/bin/bash
ffmpeg -rtsp_transport tcp \
-i rtsp://smartiptv:PASSWORD@192.168.2.3/Streaming/Channels/102 \
-i rtsp://smartiptv:PASSWORD@192.168.2.3/Streaming/Channels/202 \
-i rtsp://smartiptv:PASSWORD@192.168.2.3/Streaming/Channels/302 \
-i rtsp://smartiptv:PASSWORD@192.168.2.3/Streaming/Channels/402 \
-i rtsp://smartiptv:PASSWORD@192.168.2.3/Streaming/Channels/502 \
-i rtsp://smartiptv:PASSWORD@192.168.2.3/Streaming/Channels/602 \
-filter_complex "
@mikaelz
mikaelz / ttm-dividend-yield.js
Created May 3, 2020 09:20
Google Spreadsheet script to fetch Dividend Yield from https://fmpcloud.io/plans
function DivYieldTtm(ticker) {
var ticker = ticker || "GOOG";
ticker = encodeURI(ticker);
var response = UrlFetchApp.fetch("https://fmpcloud.io/api/v3/ratios-ttm/" + ticker + "?apikey=YOUR_API_KEY");
var result = JSON.parse(response.getContentText());
return parseFloat(result[0].dividendYielTTM);
}
@mikaelz
mikaelz / YahooFinance.js
Created April 20, 2020 06:34
Google script to fetch stock quote data from Yahoo Finance
function YahooFinance(ticker) {
var ticker = ticker || "GOOG";
ticker = encodeURI(ticker);
var response = UrlFetchApp.fetch("https://query2.finance.yahoo.com/v7/finance/options/" + ticker);
var chain = JSON.parse(response.getContentText());
return parseFloat(chain.optionChain.result[0].quote.regularMarketPrice);
}
@mikaelz
mikaelz / ssh-login-notify.sh
Created November 23, 2019 09:34
SSH login email notify. Inspired by https://askubuntu.com/a/702743/168459
$ cat /etc/profile.d/ssh-login-notify.sh
if [ -n "$SSH_CLIENT" ]; then
TEXT="$(date): ssh login to ${USER}@$(hostnamectl --static)"
TEXT="$TEXT from $(echo $SSH_CLIENT|awk '{print $1}')"
echo $TEXT|mail -s "ssh login" info@example.com
fi
@mikaelz
mikaelz / order-by-field.sql
Created July 20, 2019 04:39
Custom WP query ORDER BY with FIELD()
function pn_woocommerce_product_query( WP_Query $wp_query ) {
if ( $wp_query->get( 'orderby' ) == 'menu_order title' ) {
$wp_query->set( 'meta_query', [
'relation' => 'AND',
'internal_stock' => [
'key' => '_manage_stock',
'compare' => 'EXIST',
],
'stock_status' => [
'key' => '_stock_status',
@mikaelz
mikaelz / mother-day.ics
Created May 1, 2019 12:07
ICS Calendar event with Mother's day in Hungary
BEGIN:VCALENDAR
VERSION:2.0
BEGIN:VEVENT
RRULE:FREQ=YEARLY;BYMONTH=5;BYDAY=1SU
SUMMARY:Mother day in Hungary
DTSTART;VALUE=DATE:20190101
SEQUENCE:0
DESCRIPTION:
END:VEVENT
END:VCALENDAR
@mikaelz
mikaelz / docker-compose.yml
Created February 14, 2019 12:35 — forked from kylechase/docker-compose.yml
version: "3.2"
services:
wordpress:
image: wordpress
volumes:
- type: volume
source: www-data
target: /var/www/html
expose:
- 80
@mikaelz
mikaelz / get_time_from_ntp.php
Created September 17, 2018 10:54 — forked from bohwaz/get_time_from_ntp.php
Fetches timestamp from a NTP server in PHP
<?php
/**
* Returns UNIX timestamp from a NTP server (RFC 5905)
*
* @param string $host Server host (default is pool.ntp.org)
* @param integer $timeout Timeout in seconds (default is 10 seconds)
* @return integer Number of seconds since January 1st 1970
*/
function getTimeFromNTP($host = 'pool.ntp.org', $timeout = 10)