ArneAnka

# Assuming extglob option of bash is set, which is the default, otherwise set with shopt -s extglob
# http://askubuntu.com/a/903235/562529
`find . -name '*.rar' -exec unrar e {} \; -exec rm {} \; && rm *.r+([[:digit:]])`

# Maybe better option?
find . -name '*.rar' -exec unrar e {} \; -exec rm {} \; && rm *.r*

ArneAnka

# This scripts helps you when seraching images of a speceifc dimension. Lets
# say you want to remove thumbnails or something, then this is good!
# Notice the `echo`, remove that and run the script. That will REMOVE you files.
# Change `rm` to `cp` to copy the files if you want to review them before deletion.


```
#!/bin/bash

targetDir="$HOME/Pictures"

ArneAnka

Font awesome:
In App directory, run:
```
npm install font-awesome
```

In App/resources/assets/sass/app.scss add
```
// Font awsome
$fa-font-path: "/assets/fonts";

ArneAnka

https://serverfault.com/a/35079


```
find /home/user -type d -print0 | xargs -0 chmod 0775
find /home/user -type f -print0 | xargs -0 chmod 0664
```

ArneAnka

find . -type f -exec bash -c 'mkdir -p sorted/"${0##*.}"; cp "$0" sorted/"${0##*.}"' {} \;

ArneAnka

# Two scripts that do the same thing a little different, notice `mv` and `cp`. Your choice
# What will happen is that find will recursivly serach the current folder for images, read when
# the file was created, and move/copy it to a corresponding folder.

# This is from https://apple.stackexchange.com/questions/280252/recursively-search-for-images-and-move-them-to-a-date-folder

# http://unix.stackexchange.com/a/83838
find -E . -regex '.*\.(jpg|JPG|png|PNG|jpeg|JPEG|bmp|BMP)' | while read file; do
    ts=$(stat -f '%Sm' -t '%Y-%m-%d' "$file")
    folder="/Users/username/Documents/Backup_images/$ts"

ArneAnka

1. youtube-dl -a lista.txt // Download all lectures with youtube-dl from file `lista.txt`
2. for f in *.mp4; do ffmpeg -i "$f" -vn "$(basename "$f" .mp4).mp3"; done // convert all mp4 to mp3
3. for f in *.mp3; do ffmpeg -i "$f" -af "highpass=f=200, lowpass=f=3000" "$(basename "$f" .mp3)_noice.mp3"; done
4. for f in *_noice.mp3; do ffmpeg -i "$f" -af silenceremove=1:0:-50dB "$(basename "$f" .mp3)_silence.mp3"; done
5. ffmpeg-normalize *.mp3 -c:a libmp3lame -b:a 192k -ext mp3 (https://superuser.com/a/323127/643639, https://stackoverflow.com/a/58997035/4892914)
6. ????
7. PROFIT

(2. ffmpeg -i input.mp4 -f mp3 -ab 192000 -vn output.mp3)
(3. ffmpeg -i output.mp3 -af "highpass=f=200, lowpass=f=3000" output_clean.mp3) // reduce noice (https://superuser.com/questions/733061/reduce-background-noise-and-optimize-the-speech-from-an-audio-clip-using-ffmpeg)

ArneAnka

#!/bin/bash
HOST=192.168.1.50

# Check if the script is being executed as root
if [[ $EUID -ne 0 ]]; then
   echo -e "🥴 \033[0;31mThis script must be run as root \033[0m" 
   exit 1
fi

# Ping the storage server to determin connectivity

ArneAnka

Uninstall MySQL

https://gist.github.com/vitorbritto/0555879fe4414d18569d https://coderwall.com/p/os6woq/uninstall-all-those-broken-versions-of-mysql-and-re-install-it-with-brew-on-mac-mavericks

Install MariaDB and change root password

Install

https://mariadb.com/resources/blog/installing-mariadb-10-1-16-on-mac-os-x-with-homebrew/

Permissions

https://stackoverflow.com/questions/39597682/mysql-error-1698-28000-access-denied-for-user-rootlocalhost

ArneAnka

UPDATE games
     SET title = CASE WHEN INSTR(title,' ')>0 
             AND LEFT(title,INSTR(title,' '))
              IN ('The ')
            THEN CONCAT(UPPER(SUBSTRING(title,INSTR(title,' ')+1,1))
                       ,SUBSTRING(title,INSTR(title,' ')+2)
                       , ', '
                       , LEFT(title,INSTR(title,' ')-1))
            ELSE title
        END