rosswd

# get a list of video titles for a channel
youtube-dl -i -e https://youtube.com/channel/CHANNEL_ID

# alternative
youtube-dl --skip-download --ignore-errors https://youtube.com/channel/CHANNEL_ID

rosswd

How to stop Steam Big Picture opening when you press the guide button on your XBox Controller

Scenario: You have an XBOX One Controller, or similar, and to turn off the controller you press and hold the guide button. Unfortunately, even though you have turned off guide button focuses steam in Steam's Controller Settings, the button press still opens Big Picture Mode.

Guide

• With your controller on, open Controller Settings: Steam > Settings > Controller > General Controller Settings
• Using the controller, highlight Xbox One Controller or similar, navigate to Define Layout and press A on the controller

The next step involves remapping the Guide Button to another button and then reassigning that button back to the original. This will leave the guide button unassigned so that the controller can be turned off without Steam getting involved.

rosswd

Setting up github and bitbucket on the same computer (Windows)

Guide for Windows

mix3d asked for some help using this guide with windows so here we go. This was tested with Windows 10. Run all commands in Git Bash once it's installed.

Github will be the main account and bitbucket the secondary.

Git for Windows

• Download and install Git for Windows
  • In the installer, select everything but decide if you want a desktop icon (2nd step)

rosswd

Installing a new ssd in MacOS High Sierra

This guide is for upgrading to a new SSD, restoring from Time Machine and keeping your Recovery Partition.

The first time I tried to install a new SSD I just installed the SSD and didn't format anything. I figured the format would be chosen by MacOS but it wasn't and the recovery partition didn't copy over to the new disk. If you don't have a Recovery Partition you can't use Disk Encryption or Find My Mac.

Note: you may have to disable/remove disk encryption but my Disk wasn't encrypted so I don't have steps for that

Preparing your Computer

• Do a Time Machine Backup and make sure you're not excluding anything you need
• Shut down your Mac and go through the process of removing the old drive

rosswd

How to Install Quake and the Arcane Dimensions Mod

Assumptions

This guide assumes you're using Windows 10 and the Steam version of Quake. Although it might work for other systems I don't have access to said systems. We will use Quakespasm as the Quake Engine.

Install Quake

• Download and Install Quake from Steam
• You can also install Mission Pack 1: Scourge of Armagon and Mission Pack 2: Dissolution of Eternity, if you like. Scourge of Armagon is seen as the better of the two.

Install the Soundtrack

rosswd

Learning Relational Database Design and SQL

Learn SQL (interactive)

• SQLBolt
• SQLZoo
• GalaXQL
• Mode SQL Tutorial
• Datacamp: Intro to SQL for Data Science
• Codecademy Learn SQL
• Select Star SQL

rosswd

Game Programming & Game Design Books

• Introduction to 3D Game Programming with DirectX 11 (Frank D. Luna)

• Mathematics for 3D Game Programming and Computer Graphics (Eric Lengyel)

• 3D Game Engine Programming (Stefan Zerbst, Oliver Duvel)

• Black Art of 3D Game Programming: Writing Your Own High-Speed 3D Polygon Video Games in C (Andre LaMothe)

rosswd

Using Archer C8 as an Access Point

• Log in to 192.168.0.1 directly using an ethernet cable
• Default user and password on a new box is admin and admin
• If your Internet provider's router is using the same address, go to Advanced > Network > LAN and change your ip address
• Go to Advanced > DHCP > DHCP Settings and disable the DHCP server
  • Ignore other settings unless the default gateway (provider's router) is not correct, then just change that
• Change SSID names and passwords to match the main provider
• Change the default user and password in Advanced > System Tools > Password
• Connect a cable from your C8 LAN PORT to your Internet provider's Router.
• There should not be a cable connected to the WAN PORT when your using the C8 as an Access Point.

rosswd

Vegas Pro 14 Tweaks for Windows 10

Turn off GPU Acceleration

• Options > Preferences > Video > GPU acceleration of video processing: Off
• Click Apply then OK
• Restart Vegas

Disable Multi-Core Rendering for Playback

• Ctrl+Shift + Options > Preferences (gives hidden Internal tab)
• Click the Internal tab

rosswd

Drawing Tablet Software

Software for drawing using graphics tablets like wacom or using a tablet like an iPad.

Software List

Title	Platforms	Pricing
Medibang Paint / Paint Pro	Windows, Mac OS, iOS, Android	Adware, no paid version
Paint Tool SAI	Windows	$51
ArtRage	Windows, Mac OS, Android, iOS	$79 + tax