patrickemuller

SELECT id, name, CASE
                   WHEN aasm_state = 10 AND imported = false THEN true
                   ELSE false
                 END
                 AS available
FROM businesses
LIMIT 5;

/* Line 2 is your conditional */
/* NOTE: will be F or T depending on your conditional */

patrickemuller

{"lastUpload":"2021-06-28T19:04:44.592Z","extensionVersion":"v3.4.3"}

patrickemuller

[Storage]
# The path to place your ROMs Directory. This can be in any drive or anywhere,
# as long as the full path is specified. Use ~ to represent your home folder
# (for example, C:\Users\Scott\)
#
# Set a directory where the ROMs are stored.
# If no directory is provided, "~/ROMs" is used.
# Example:
# ~\ROMs                     => C:\Users\<YOUR USERNAME>\ROMs
ROMs Directory=D:\SteamLibrary\emulators\ROMs

patrickemuller

050000005e040000fd02000030110000,Xbox Wireless Controller,a:b0,b:b1,x:b2,y:b3,start:b7,guide:b8,back:b6,leftstick:b9,rightstick:b10,leftshoulder:b4,rightshoulder:b5,dpup:h0.9,dpleft:h0.8,dpdown:h0.12,dpright:h0.2,leftx:a0,lefty:a1,rightx:a3,righty:a4,lefttrigger:a2,righttrigger:a5,platform:Linux

patrickemuller

docker create --name pihole -p 53:53/tcp -p 53:53/udp -p 67:67/udp -p 80:80 -p 443:443 -v "/host_mnt/c/Users/nas-server/Documents/pihole/:/etc/pihole/" -v "/host_mnt/c/Users/nas-server/Documents/dnsmasq.d/:/etc/dnsmasq.d/" -e ServerIP="MY_IP" -e WEBPASSWORD="MY_PASSWORD" --network=host --restart=always --cap-add=NET_ADMIN pihole/pihole:latest

patrickemuller

https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts  
https://mirror1.malwaredomains.com/files/justdomains 
https://zeustracker.abuse.ch/blocklist.php?download=domainblocklist  
https://s3.amazonaws.com/lists.disconnect.me/simple_tracking.txt  
https://s3.amazonaws.com/lists.disconnect.me/simple_ad.txt  
https://hosts-file.net/ad_servers.txt  
https://hosts-file.net/grm.txt  
https://reddestdream.github.io/Projects/MinimalHosts/etc/MinimalHostsBlocker/minimalhosts  
https://raw.githubusercontent.com/StevenBlack/hosts/master/data/KADhosts/hosts  
https://raw.githubusercontent.com/StevenBlack/hosts/master/data/add.Spam/hosts  

patrickemuller

# get current branch in git repo
function parse_git_branch() {
	BRANCH=`git branch 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/\1/'`
	if [ ! "${BRANCH}" == "" ]
	then
		STAT=`parse_git_dirty`
		echo "[${BRANCH}${STAT}]"
	else
		echo ""

patrickemuller

# put inside the file ~/.config/terminator/config

[global_config]
  enabled_plugins = LaunchpadCodeURLHandler, APTURLHandler, MavenPluginURLHandler, LaunchpadBugURLHandler
  title_inactive_bg_color = "#ffffff"
  window_state = maximise
[keybindings]
  close_term = <Primary>w
  copy = <Primary>c
  full_screen = <Primary><Shift>f

patrickemuller

# ~/.bashrc: executed by bash(1) for non-login shells.
# see /usr/share/doc/bash/examples/startup-files (in the package bash-doc)
# for examples

# If not running interactively, don't do anything
case $- in
    *i*) ;;
      *) return;;
esac

patrickemuller

[app]
hotkey_run = Alt+Space
   
[gui]
max_results = 10
theme = MidnightFullMoon

[theme/MidnightFullMoon]
opacity_back = 100
satellite_show = always