Skip to content

Instantly share code, notes, and snippets.

View sdrwtf's full-sized avatar
👾

Patsch sdrwtf

👾
View GitHub Profile
@sdrwtf
sdrwtf / ffmpeg hmtl5-video-conversion.sh
Last active September 8, 2021 12:36
ffmpeg hmtl5 video conversion note
# ffmpeg hmtl5 video conversion
# MP4
# Adjust quality by changing the CRF or PRESET value, see https://trac.ffmpeg.org/wiki/Encode/H.265 for details
ffmpeg -i [IN-FILENAME] -acodec aac -strict experimental -ac 2 -ab 128k -vcodec libx264 -f mp4 -crf 25 -preset slow -s 1920x1080 [OUT-FILENAME].mp4
# OGV
# Adjust quality with -q:v (video) and -q:a (audio) values, lower means better quality but bigger file size. Range is 0 to 10.
@sdrwtf
sdrwtf / select_unsupported_ordernumbers.sql
Last active August 4, 2021 06:52
Select all active articles in a Shopware 5.x database which have unsupported special characters in the ordernumber.
/*
Select all active articles in a Shopware 5.x database
which have unsupported special characters in the ordernumber.
(Supported special characters are: . - _)
*/
SELECT
sad.ordernumber,
sa.name AS 'ArticleName',
sa.active,
@sdrwtf
sdrwtf / console_log.php
Last active October 4, 2021 11:04
Simple function to write to dev-tools console log
<?php
// Ment to be used within an existing class
$this->console_log('log me');
/**
* Simple function to write to dev-tools console log
* @param $output Whatever shall be pushed to the log
* @param boolean $with_script_tags Flag to enable <script> tags
*/