Skip to content

Instantly share code, notes, and snippets.

View scips's full-sized avatar

Sébastien Barbieri scips

21 followers · 36 following
View GitHub Profile
@scips
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
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
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
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
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
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
scips / Apk deploy on phone or tv.md
Last active February 3, 2022 16:02

usb

  $ adb devices
  $ adb install myapk.apk

wifi




  


  




    


          
    

      

        
        

          

              @scips
          

          

            
                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
          

          

            
                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
          

          

            
                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 '/emailAddress=me@example.com, 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: