Table of Contents
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Script: update-moodle.sh | |
# From: https://gist.github.com/ | |
# This script will update Moodle within the same major version (example: 3.6.1 to 3.6.3). | |
# The nice thing about this simple approach is that it won't affect your plugins. | |
# Assumes you used "git clone" to create and install your instance of Moodle. If you did not, don't use this script! | |
# | |
# Copyright TNG Consulting Inc. | |
# Author: Michael Milette - <www.tngconsulting.ca> | |
# Release: 1.0 Alpha - 2019-04-16 | |
# |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
OS="$(uname -s)" | |
case "${OS}" in | |
Linux*) OS=Linux;; | |
Darwin*) OS=Mac;; | |
CYGWIN*) OS=Cygwin;; | |
MINGW*) OS=MinGw;; | |
*) if [[ -n "$IS_WSL" || -n "$WSL_DISTRO_NAME" ]]; then | |
OS="UNKNOWN:${OS}" | |
else | |
# WSL2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Moodle Site Backup version 1.1 | |
# Copyright 2005-2020 TNG Consulting Inc (www.tngconsulting.ca) | |
# Author: Michael Milette | |
# License: GNU GPL 3.0 or later. | |
# Installation: Place this script in the APPPATH folder. | |
# Run it as "sudo" or with sufficient permissions. | |
# ------------------------------------------------------------------------------------- | |
# Configuration section - Assumes Moodle's WEBROOT and DATA are under the APPPATH. | |
# ------------------------------------------------------------------------------------- | |
TIMEZONE="America/Toronto" |
- See git cheatsheet.
- rsync -a --delete --compress --omit-dir-times --omit-link-times --no-g --no-perms [user@server:]source [user@server:]target
- scp -Crqp [user@server:]source [user@server:]target
- ssh username@server
- tmux (Ctrl+b ":set -g status off" to disable status bar with clock)
Description | MySQL | PostgreSQL |
---|---|---|
Connect to database server | mysql -u username -p | psql -U username |
Import a database | mysql -u username -p databaseName < data.sql | psql -U username databaseName < data.sql |
List databases | SHOW databases; | \l |
Use/Connect to datbase with name | USE databaseName; | \c databaseName |
List tables | SHOW tables; | \dt |
List users | SELECT user, host FROM mysql.user; | \du |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* Enables scrolling to a class instead of an ID for applications like Moodle that use YUI. | |
* YUI often litters your HTML code adding what appears to be random ID's for every element. This means that you can't | |
* actually use ID's in your HTML, and hence, cannot create in-page links. This solves that problem. | |
* Usage: | |
* 1) Add this code to your web page. | |
* 2) Add a class called goto-WhatEverYouWant such as class="goto-section5" to an element. | |
* 3) When you load the page, any classes starting with goto- will become an ID for that element. | |
* This will enable you to create in-page links such as <a href="#section5">Section 5</a> | |
* Consider combining this with the optional smooth scrolling Gist for a nice touch. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#################################################### | |
# Force client to use secure HTTPS connections only. | |
#################################################### | |
RewriteEngine on | |
# Use HTTP Strict Transport Security to force client to use secure connections only. | |
RewriteCond %{HTTPS} on | |
RewriteRule ^ - [ENV=HTTPS:true] | |
Header always set Strict-Transport-Security "max-age=31536000; includeSubDomains; preload" env=HTTPS |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<style> | |
.banner { | |
position:relative; | |
} | |
.overlay { | |
position: absolute; | |
top: 50%; | |
left: 60%; | |
width:40%; | |
transform: translate(-50%, -50%); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Filename: touchsync.ps1 | |
# Purpose: To touch / Sync file and/or folder date and time timestamp between two file paths without copying. | |
# files or folders. The default is to just touch folders. See comment in code to change this. | |
# Language: PowerShell for Windows. | |
# Version: 0.1 | |
# Author: Michael Milette | |
# Copyright 2018 TNG Consulting Inc. | |
# License: GNU GPL 3. | |
# Configuration section. Note: Trailing slash must be included in the following paths. Example: "C:\DEV\": |
NewerOlder