Michal Zuber mikaelz

Dev @ websupport.sk

mikaelz / librenms-alerts.service

Last active October 30, 2020 12:55

librenms systemd timers as crontab repalcement

	# /etc/systemd/system/librenms-alerts.service

	[Unit]
	Description=Run librenms poller

	[Service]
	Type=oneshot
	ExecStart=/opt/librenms/alerts.php
	User=librenms

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 / 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 / mosaic-live-6ch-substream.sh

Last active June 1, 2025 09:52

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:[email protected]/Streaming/Channels/102 \
	-i rtsp://smartiptv:[email protected]/Streaming/Channels/202 \
	-i rtsp://smartiptv:[email protected]/Streaming/Channels/302 \
	-i rtsp://smartiptv:[email protected]/Streaming/Channels/402 \
	-i rtsp://smartiptv:[email protected]/Streaming/Channels/502 \
	-i rtsp://smartiptv:[email protected]/Streaming/Channels/602 \
	-filter_complex "

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 / 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 / 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" [email protected]
	fi

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 / 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 / docker-compose.yml

Created February 14, 2019 12:35 — forked from kylechase/docker-compose.yml