Sébastien Barbieri scips

23 followers · 38 following

RTBF
Brussels, Belgium
http://www.sbw.be

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

scips / Get slide metadata.POWERPOINT.yaml

Created October 6, 2022 10:36

Gets the title, index, and ID of the selected slide(s).

	name: Get slide metadata
	description: 'Gets the title, index, and ID of the selected slide(s).'
	host: POWERPOINT
	api_set: {}
	script:
	content: \|
	$("#get-slide-metadata").click(getSlideMetadata);

	function getSlideMetadata() {
	Office.context.document.getSelectedDataAsync(Office.CoercionType.SlideRange, function(asyncResult) {

scips / browser_major_version.sql

Created June 2, 2022 12:33

	SELECT event_date, device.web_info.browser, REGEXP_EXTRACT(device.web_info.browser_version, r'^(\d+)') as browser_major_version, COUNT(*) as total
	FROM `-analytics-.analytics_.events_`
	WHERE platform='WEB' AND event_name = 'page_view' AND event_date BETWEEN FORMAT_DATE("%Y%m%d",DATE_ADD(CURRENT_DATE(), INTERVAL -1 WEEK)) AND FORMAT_DATE("%Y%m%d",CURRENT_DATE())
	GROUP BY event_date, device.web_info.browser, browser_major_version
	ORDER BY event_date DESC,total DESC

scips / cat-head.ps1

Created February 12, 2022 15:36

Powershell cat tail head ...

	gc log.txt \| select -first 10 # head
	gc -TotalCount 10 log.txt # also head
	gc log.txt \| select -last 10 # tail
	gc -Tail 10 log.txt # also tail (since PSv3), also much faster than above option
	gc log.txt \| more # or less if you have it installed
	gc log.txt \| %{ $_ -replace '\d+', '($0)' } # sed

scips / tampermonkey-GA-tracking.js

Created January 11, 2022 17:23

	// ==UserScript==
	// @name Google Analytics Checker
	// @namespace https://rtbf.be/
	// @version 0.1
	// @description Modify the lang to track in Real Time on GA
	// @author Sébastien Barbieri
	// @match https://*.rtbf.be/
	// @icon https://www.google.com/s2/favicons?domain=userscript.zone
	// @grant none
	// @run-at document-start

scips / XMLHTTPRquest_Interceptor.js

Created December 6, 2021 08:31

	<!-- begin snippet: js hide: false console: false babel: null -->
	<!-- language: lang-js -->
	<!-- @credit: EtherDream https://stackoverflow.com/users/4565883/etherdream -->

	//
	// firefox, ie8+
	//
	var accessor = Object.getOwnPropertyDescriptor(XMLHttpRequest.prototype, 'responseText');

	Object.defineProperty(XMLHttpRequest.prototype, 'responseText', {

scips / ffmpeg-concat-and-compress-nvidia-mts.bat

Last active November 30, 2021 13:09

~\Applications\ffmpeg-2021-11-29-git-86a2123a6e-full_build\bin\ffmpeg.exe -i "concat:user03-mobile-part1.MTS|user03-mobile-part2.MTS" -f mp4 -vcodec h264_nvenc -acodec mp3 user03-mobile-full-compressed.mp4

scips / Apk deploy on phone or tv.md

Last active February 3, 2022 16:02

usb

  $ adb devices
  $ adb install myapk.apk

wifi

scips / Which element has the current focus.js

Created June 9, 2021 14:00

	setInterval(() => {console.info(document.activeElement);}, 1000)

	/*
	* @author [@françoismassart](https://github.com/francoismassart)
	*/

scips / Count Media on Auvio by page.js

Last active June 19, 2020 07:46

Count Media on Auvio by page

	// ==UserScript==
	// @name Count Media on Auvio Page
	// @version 1
	// @include https://.rtbf.be/auvio/
	// @author Sébastien Barbieri
	// ==/UserScript==


	var counter = document.createElement("div");
	counter.innerHTML = '<div id="myCounter" style="margin: 0 auto 0 auto; ' +

scips / Readme.txt

Created February 7, 2019 17:24 — forked from jcward/Readme.txt

Generating iOS P12 / certs without Mac OSX Keychain (on linux, windows, etc)

	1) Generate a private key and certificate signing request:

	openssl genrsa -out ios_distribution.key 2048
	openssl req -new -key ios_distribution.key -out ios_distribution.csr -subj '/[email protected], CN=Example, C=US'

	2) Upload CSR to apple at: https://developer.apple.com/account/ios/certificate/create
	- choose Production -> App Store and Ad Hoc

	3) Download the resulting ios_distribution.cer, and convert it to .pem format:

NewerOlder

	gc log.txt \| select -first 10 # head
	gc -TotalCount 10 log.txt # also head
	gc log.txt \| select -last 10 # tail
	gc -Tail 10 log.txt # also tail (since PSv3), also much faster than above option
	gc log.txt \| more # or less if you have it installed
	gc log.txt \| %{ $_ -replace '\d+', '($0)' } # sed