#**************************************
# This Bash Script accomplishes the following task:
#------------------------------------
# Refer below tables:
# Table1:
# Device                    Interface                          Specified
#--------------------------------------------------------------------------
# HDC-TBONE-P1     PO9/0/0-pos                     121.36
# ocb-pe1                Gi5/2-ethernetCsmacd     0.17
#______________________________________________________________
# Table2:
# CID                        Device                  Interface       Avgin
#---------------------------------------------------------------------------
# HDC-HKG-R01      HDC-TBONE-P1    PO9/0/0
# OCB-OCD-R01     OCB-PE1 Gi5/2
# HDC-BSA-R01      HDC-TBONE-P1    Se9/2/0
#______________________________________________________________
# 1. It matches the row with this condition: Common values of Device columns AND first three chars of Interface column from both tables.
# 2. Then the row which matched the above condition from Table1, retrieve the value of Specified column and store it in the Avgin column of the Table2 in the row where above condition matched.
#------------------------------------
# Tested on Fedora with MySQL version 14.14.
# Created by geeksScript | Sanchit (//geeksScript.com), Dated: 07-04-2013.
#**************************************

Click Here to view this script.

#**************************************
# This Python Script accomplishes the following task:
#------------------------------------
# 1. This script takes a csv file as input file which has following pattern: ip,hostname
# 2. Script then tries to make a connection with port 22,25,80,110,443,8080,8008 (one by one).
# 3. Responses (Banner Response) to store in a text file or display on screen, in following pattern: ip, hostname, port, banner_response.
# 4. Banner could be ssh banner or smtp banner or http head response.
# 5. Input is csv and output should be in csv comaptible format which can either be stored in a text file or prefered to be displayed on screen.
# 6. The script has a port array at top where custom port numbers can be defined.
#------------------------------------
# This archive contains: sample input/output files as infile/ofile and script.
# Simply run this script (script.py) and Enjoy!.
# Tested on Ubuntu, Fedora, CentOs, Mac with Python version 2.7.3.
# Created by geeksScript | Sanchit (//geeksScript.com), Dated: 04-04-2013.
#**************************************

Click Here to view this script.

#**************************************
# It accomplishes the following task:
#------------------------------------
# 1. Your script will check if Apache, Mysql & PHP are installed. If not present, missing packages will be installed.
# 2. Then script will then ask user for domain name. (Suppose user enters example.com)
# 3. Create a /etc/hosts entry for example.com pointing to localhost IP.
# 4. Create apache config file for example.com
# 5. Download WordPress latest version from //wordpress.org/latest.zip and unzip it locally in example.com document root.
# 6. Create a new mysql database for new WordPress. (database name “example.com_db” )
# 7. Create wp-config.php with proper DB configuration. (You can use wp-config-sample.php as your template)
# 8. You may need to fix file permissions, cleanup temporary files, restart or reload apache config.
# 9. Tell user to open example.com in browser (if all goes well)
#------------------------------------
# Each Block will state about the task it is going to perform and assumptions made, if any.
# Possible Errors/Output are redirected to /dev/null.
# Created and Tested on Ubuntu 11.04.
# Script only for Ubuntu Systems.
# Written By: geeksScript | Sanchit-(//geeksScript.com), Dated: 02-04-2013.
#**************************************

Click Here to view this script.

#**************************************
# It accomplishes the following task:
#------------------------------------
# 1. Your script will check if Nginx, Mysql & PHP are installed. If not present, missing packages will be installed.
# 2. Then script will then ask user for domain name. (Suppose user enters example.com)
# 3. Create a /etc/hosts entry for example.com pointing to localhost IP.
# 4. Create nginx config file for example.com
# 5. Download WordPress latest version from //wordpress.org/latest.zip and unzip it locally in example.com document root.
# 6. Create a new mysql database for new WordPress. (database name “example.com_db” )
# 7. Create wp-config.php with proper DB configuration. (You can use wp-config-sample.php as your template)
# 8. You may need to fix file permissions, cleanup temporary files, restart or reload nginx config.
# 9. Tell user to open example.com in browser (if all goes well)
#------------------------------------
# Each Block will state about the task it is going to perform and assumptions made, if any.
# Known Possible/Conflicting Errors are redirected to /dev/null.
# Created and Tested on Ubuntu 11.04.
# Script only for Ubuntu Systems.
# Written By: geeksScript | Sanchit-(//geeksScript.com), Dated: 03-04-2013.
#**************************************

Click Here to view this script.