Skip to content

Instantly share code, notes, and snippets.

View gitfvb's full-sized avatar

Florian von Bracht gitfvb

2 followers · 5 following
View GitHub Profile
@gitfvb
gitfvb / random_strings.ps1
Last active February 1, 2021 23:56
random strings eg for vouchers
function getRandomString([int] $length) {
$random = [Random]::new()
$chars = @("0", "2", "3", "4", "5", "6", "8", "9", "a", "b", "c", "d", "e", "f", "g", "h", "j", "k", "m", "n", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z")
$stringBuilder = ""
for ($i = 0; $i -lt $length; $i++) {
$stringBuilder += $chars[$random.Next($chars.Length)]
}
return $stringBuilder
}
@gitfvb
gitfvb / readme.md
Created January 9, 2021 11:39
Playing minecraft 1.16.4 on local network LAN with one purchased game

Notebook #1

  • Open Minecraft normally
  • Go into a single player game
  • When in the gameplay, open the menu and open the game in the LAN
  • Note the port and maybe the IP

Notebook #2

  • Open the minecraft launcher so the current login tokens are getting refreshed
@gitfvb
gitfvb / check-datatypes.ps1
Created December 22, 2020 11:13
Check some datatypes in PowerShell
<#
Is-Numeric 10 # True
Is-Numeric "10" # True
Is-Numeric "10f" # False
Is-Numeric "+10" # True
Is-Numeric "-10" # True
Is-Numeric "-10.5" # False
#>
function Is-Int ($value) {
@gitfvb
gitfvb / splatting.ps1
Created December 16, 2020 17:18
splatting in powershell
# this method allows a command execution with a hashtable instead of one big line
$restParams = @{
method = "Get"
uri = "https://www.google.de"
ContentType = "application/json"
verbose = $true
}
Invoke-RestMethod @restParams # note the @ instead of the $
@gitfvb
gitfvb / query.sql
Created December 9, 2020 08:18
db2 queries for loading a sliding window
SELECT *
,BIGINT (DATE) AS DATEERN -- this is used as ERN field
,CASE Kundennummer WHEN '0' THEN '9999'||lpad(dayofyear(date),4,'0') ELSE Kartennummer END CONCAT '|' CONCAT BIGINT (DATE) AS DateKey
FROM APTECO.BONS
WHERE DATE BETWEEN (
TIMESTAMP_FORMAT(CASE
WHEN @ERN < BIGINT (0)
THEN '20161231'
ELSE @ERN
@gitfvb
gitfvb / Convert-XMLtoPSObject.ps1
Created December 3, 2020 11:12
Allow xml to pscustomobject transformation in PowerShell to allow conversion to json, copied from https://github.com/gitfvb/AptecoHelperScripts/blob/master/functions/Xml/Convert-XMLtoPSObject.ps1
<#
.SYNOPSIS
Conversion of valid xml into a PSCustomObject, so it can be easily used to create json instead
.DESCRIPTION
Inspired from the C# example from: Translated into PowerShell from https://dev.to/adamkdean/xml-to-hashtable-59dg
This script uses xml input and converts all tags and attributes into a PSCustomObject.
This allows a much easier transformation into a json object.
.EXAMPLE
# Using this input xml (could also be a file) ...
@gitfvb
gitfvb / Rprofile.site
Created December 3, 2020 11:10
R profile file for including some scripts at startup
# Things you might want to change
# options(papersize="a4")
# options(editor="notepad")
# options(pager="internal")
# set the default help type
# options(help_type="text")
options(help_type="html")
@gitfvb
gitfvb / gist:121f888648f707a0b477d9c8cafc8646
Last active September 10, 2020 16:37
Use OBS for Videorecording of Screen and Webcam

Setup OBS

  • E.g. double your screen resolution like here:

grafik

grafik

grafik

@gitfvb
gitfvb / timer.ps1
Created September 4, 2020 14:26
A timer in PowerShell controlled through a "tick" event instead of a start-sleep. Script can be run standalone out of the box.
<#
Good example inspired from here
https://gist.github.com/SteveGilham/98a39f621cfed70bfa0a
To explore possible events, type in
$timer | gm
#>
@gitfvb
gitfvb / binary_cleverreach.ps1
Created June 22, 2020 08:49
Binary options in powershell
<#
HINTS
# check bitwise: https://ingogegenwarth.wordpress.com/2016/11/17/powershell-and-bit-field-attributes/
#>
# Good example because the cleverreach api checks the details to download bitwise... those are the values
$cleverreachDetails = @{
events = 1