nd3w

Git commands Cheat Sheet

Initialize a new git repository:

git init

Set configuration values for your username and email:

git config --global user.name

Backup your SLiMS directory first.

Line number 42, change:

include 'parts/_member.php';

List databases:

\l

Use a database:

\c db_name

Use schema other than default 'public':

Move a window to another workspace

Press Ctrl+Alt+Shift Left or Ctrl+Alt+Shift Right

Move a window to another monitor

Press Super+Shift Left or Super-Shift Right

Move active window around on the desktop

Search and Replace

Search and replace PHP variable in if control structure using regex:

if \(isset\(\$([a-zA-Z_]+)\)\) \{

Replace pattern

if (isset($$$1) AND $$$1 !== '') {

sudo apt install apache2

sudo ufw app list

sudo ufw allow in "Apache"

Calculate average value from B2 to B32 with B24 to B32 are blanks:

=SUM(B2:B32)/(ROWS(B2:B32)-COUNTBLANK(B2:B32))

or simply:

=AVERAGE(B2:B32)

	<html>
	<head>
	<meta charset="utf-8" />
	<meta name="viewport" content="width=device-width, initial-scale=1" />
	<title>Examples Bootstrap v5.3</title>
	<script src="./assets/js/color-modes.js"></script>
	<link href="./assets/dist/css/bootstrap.min.css" rel="stylesheet" />
	<style>
	body {margin: 1em 1em}
	.three-column-list {

	#!/bin/bash
	#convert
	for image in *.png; do
	convert "$image" -quality 80 "${image%.png}.jpg"
	echo “$image converted to ${image%.png}.jpg ”
	done
	exit 0