Tech Cheat

We got your cheat sheets right here
Options:

Archive for the ‘Site’ Category

Wireless Channel Listing

Channel 1 : 2412 Mhz 802.11B/G
Channel 2 : 2417 Mhz 802.11B/G
Channel 3 : 2422 Mhz 802.11B/G
Channel 4 : 2427 Mhz 802.11B/G
Channel 5 : 2432 Mhz 802.11B/G
Channel 6 : 2437 Mhz 802.11B/G
Channel 7 : 2442 [...]

Subnet Cheat Sheet

/30 – 64 Subnets
2 Hosts/Subnet
/29 – 32 Subnets
6 Hosts/Subnet

Network
IP Range
Broadcast

.0
.1-.2
.3

.4
.5-.6
.7

.8
.9-.10
.11

.12
.13-.14
.15

.16
.17-.18
.19

.20
.21-.22
.23

.24
.25-.26
.27

.28
.29-.30
.31

.32
.33-.34
.35

.36
.37-.38
.39

.40
.41-.42
.43

.44
.45-.46
.47

.48
.49-.50
.51

.52
.53-.54
.55

.56
.57-.58
.59

.60
.61-.62
.63

.64
.65-.66
.67

.68
.69-.70
.71

.72
.73-.74
.75

.76
.77-.78
.79

.80
.81-.82
.83

.84
.85-.86
.87

.88
.89-.90
.91

.92
.93-.94
.95

.96
.97-.98
.99

.100
.101-.102
.103

.104
.105-.106
.107

.108
.109-.110
.111

.112
.113-.114
.115

.116
.117-.118
.119

.120
.121-.122
.123

.124
.125-.126
.127

.128
.129-.130
.131

.132
.133-.134
.135

.136
.137-.138
.139

.140
.141-.142
.143

.144
.145-.146
.147

.148
.149-.150
.151

.152
.153-.154
.155

.156
.157-.158
.159

.160
.161-.162
.163

.164
.165-.166
.167

.168
.169-.170
.171

.172
.173-.174
.175

.176
.177-.178
.179

.180
.181-.182
.183

.184
.185-.186
.187

.188
.189-.190
.191

.192
.193-.194
.195

.196
.197-.198
.199

.200
.201-.202
.203

.204
.205-.206
.207

.208
.209-.210
.211

.212
.213-.214
.215

.216
.217-.218
.219

.220
.221-.222
.223

.224
.225-.226
.227

.228
.229-.230
.231

.232
.233-.234
.235

.236
.237-.238
.239

.240
.241-.242
.243

.244
.245-.246
.247

.248
.249-.250
.251

.252
.253-.254
.255

Network
IP Range
Broadcast

.0
.1-.6
.7

.8
.9-.14
.15

.16
.17-.22
.23

.24
.25-.30
.31

.32
.33-.38
.39

.40
.41-.46
.47

.48
.49-.54
.55

.56
.57-.62
.63

.64
.65-.70
.71

.72
.73-.78
.79

.80
.81-.86
.87

.88
.89-.94
.95

.96
.97-.102
.103

.104
.105-.110
.111

.112
.113-.118
.119

.120
.121-.126
.127

.128
.129-.134
.135

.136
.137-.142
.143

.144
.145-.150
.151

.152
.153-.158
.159

.160
.161-.166
.167

.168
.169-.174
.175

.176
.177-.182
.183

.184
.185-.190
.191

.192
.193-.198
.199

.200
.201-.206
.207

.208
.209-.214
.215

.216
.217-.222
.223

.224
.225-.230
.231

.232
.233-.238
.239

.240
.241-.246
.247

.248
.249-.254
.255

/28 – 16 Subnets
14 Hosts/Subnet
/27 – 8 Subnets
30 Hosts/Subnet

Network
IP Range
Broadcast

.0
.1-.14
.15

.16
.17-.30
.31

.32
.33-.46
.47

.48
.49-.62
.63

.64
.65-.78
.79

.80
.81-.94
.95

.96
.97-.110
.111

.112
.113-.126
.127

.128
.129-.142
.143

.144
.145-.158
.159

.160
.161-.174
.175

.176
.177-.190
.191

.192
.193-.206
.207

.208
.209-.222
.223

.224
.225-.238
.239

.240
.241-.254
.255

Network
IP Range
Broadcast

.0
.1-.30
.31

.32
.33-.62
.63

.64
.65-.94
.95

.96
.97-.126
.127

.128
.129-.158
.159

.160
.161-.190
.191

.192
.193-.222
.223

.224
.225-.254
.255

/26 – 4 Subnets
62 Hosts/Subnet
/25 – 2 Subnets
126 Hosts/Subnet

Network
IP Range
Broadcast

.0
.1-.62
.63

.64
.65-.126
.127

.128
.129-.190
.191

.192
.193-.254
.255

Network
IP Range
Broadcast

.0
.1-.126
.127

.128
.129-.254
.255

/24 – 1 Subnets
254 Hosts/Subnet

Network
IP Range
Broadcast

.0
.1-.254
.255

Small to Large Subnets

CIDR
Hosts
Netmask
Class C’s

/30
4
255.255.255.252
1/64

/29
8
255.255.255.248
1/32

/28
16
255.255.255.240
1/16

/27
32
255.255.255.224
1/8

/26
64
255.255.255.192
1/4

/25
128
255.255.255.128
1/2

/24
256
255.255.255.0
1

/23
512
255.255.254.0
2

/22
1024
255.255.252.0
4

/21
2048
255.255.248.0
8

/20
4096
255.255.240.0
16

/19
8192
255.255.224.0
32

/18
16384
255.255.192.0
64

/17
32768
255.255.128.0
128

/16
65536
255.255.0.0
256

/15
131072
255.254.0.0
512

/14
262144
255.252.0.0
1024

/13
524288
255.248.0.0
2048

/12
1048576
255.240.0.0
4096

/11
2097152
255.224.0.0
8192

/10
4194304
255.192.0.0
16384

/9
8388608
255.128.0.0
32768

/8
16777216
255.0.0.0
65536

For subnetting and general IP tools check here IPThingy.com

Vi Cheat Sheet

Modes
Vi has two modes insertion mode and command mode. The editor begins in command mode, where the cursor movement and text deletion and pasting occur. Insertion mode begins upon entering an insertion or change command. [ESC] returns the editor to command mode (where you can quit, for example by typing :q!). Most commands execute as [...]

Perl Cheat Sheet

CONTEXTS SIGILS ARRAYS HASHES
void $scalar whole: @array %hash
scalar @array [...]

CSS Cheat Sheet

Syntax
selector {property: value;}
External Style Sheet
<link rel=”stylesheet” type=”text/css” href=”style.css” />
Internal Style
<style type=”text/css”>
selector {property: value;}
</style>
Inline Style
<tag style=”property: value”>
General
Class String preceded by a period
ID String preceded by a hash mark
div Formats structure or block of text
span Inline formatting
color [...]

MySQL Cheat Sheet

 
Selecting a database
mysql> USE database;
Listing databases
mysql> SHOW DATABASES;
Listing tables in a db
mysql> SHOW TABLES;
Describing the format of a table
mysql> DESCRIBE table;
Creating a database
mysql> CREATE DATABASE db_name;
Creating a table
mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE));
Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), birth DATE);
Load tab-delimited data into a table
mysql> LOAD DATA LOCAL INFILE “infile.txt” [...]

HTML Cheat Sheet

Basic Tags
<html></html>
Creates an HTML document
<head></head>
Sets off the title and other information that isn’t displayed on the Web page itself
<body></body>
Sets off the visible portion of the document
Header Tags
<title></title>
Puts the name of the document in the title bar
Body Attributes
<body bgcolor=?>
Sets the background color, using name or hex value
<body text=?>
Sets the text color, using name or hex value
<body [...]

htaccess Cheat Sheet

Enable Directory Browsing
bc.. Options +Indexes
1. block a few types of files from showing
IndexIgnore *.wmv *.mp4 *.avi
Disable Directory Browsing
bc.. Options All -Indexes
Customize Error Messages
bc.. ErrorDocument 403 /forbidden.html
ErrorDocument 404 /notfound.html
ErrorDocument 500 /servererror.html
Get SSI working with HTML/SHTML
bc.. AddType text/html .html
AddType text/html .shtml
AddHandler server-parsed .html
AddHandler server-parsed .shtml
1. AddHandler server-parsed .htm
Change Default Page (order is followed!)
bc.. DirectoryIndex myhome.htm index.htm index.php
Block [...]

Apache Cheat Sheet

Setup a Virtual Domain
NameVirtualHost *
<VirtualHost *>
DocumentRoot /web/example.com/www
ServerName www.example.com
ServerAlias example.com
CustomLog /web/example.com/logs/access.log combined
ErrorLog /web/example.com/logs/error.log
</VirtualHost>
Include another conf file
Include /etc/apache/virtual-hosts/*.conf
Hide apache version info
ServerSignature Off
ServerTokens Prod
Custom 404 Error message
ErrorDocument 404 /404.html
Create a virtual directory (mod_alias)
Alias /common /web/common
Permanent redirect (mod_alias)
Redirect permanent /old http://example.com/new
Create a cgi-bin
ScriptAlias /cgi-bin/ /web/cgi-bin/
Process .cgi scripts
AddHandler cgi-script .cgi
Add a directory index
DirectoryIndex index.cfm index.cfm
Turn off directory browsing
Options -Indexes
Turn on [...]