// quick connection test
$connect = mysql_connect($host, $user, $pass) or die('Unable to connect to host');
mysql_select_db($name) or die('Could not open the database');
// update old style passwords
SET PASSWORD FOR 'user'@'host' = PASSWORD('pass');
Run this in command line on your local repo:
git repack remote/origin/master
If Notepad++ is missing from the context menu then follow the instructions found on the believeinmiraclesx website
To enable port 80 on Windows Server 2008 R2:
NOTE: This assumes that IIS is not installed. I added this firewall rule to enable Apache to accept connections on port 80.
- Click Start->Control Panel->Windows Firewall
- Click “Advanced Settings” in the left panel of Windows Firewall
- Click “Inbound rules” in the left panel of Advanced Settings
- Click “New Rule…” in right “Actions” panel
- Select “Port” and click “Next>”
- Select “TCP”, then “Specific local ports:” (should already be selected)
- Type 80 in the box (just the number) and click “Next>”
- Select “Allow the connection” and click “Next>”
- Leave all profiles checked and click “Next>”
- Enter a name and click “Finish”.
Your server should now be able to accept connections on port 80.
Git hooks are basically glorified shell scripts that execute before or after certain Git operations complete, allowing you to customize the behavior of Git.
The post-receive hook executes when a repository receives changes via a git push from another repository. One clever use of this hook is to automatically update another repository when the origin repository receives changes…
You can cause the body text to have a new line within the text you pre-populate by using the ascii characters for a carriage return (%0D) and line feed (%0A).
– gitbash in destination folder
– make sure you have a .ssh folder set up
– open puttygen and open the .ppk file.
– select Conversions -> Export OpenSSH key and it file as .ssh/id_rsa
– now set up user agent..
– add the ssh key
Most users have discovered that Excel has an option that lets you display formulas directly in their cells: Choose Tools Options, click the View tab, and select the Formulas checkbox. However, Excel doesn’t provide a way to generate a concise list of all formulas in a worksheet. The VBA macro below inserts a new worksheet, then creates a list of all formulas and their current values.
To use this subroutine:
- Copy the code below to a VBA module. You can also store it in your Personal Macro Workbook, or create an add-in.
- Activate the worksheet that contains the formulas you want to list.
- Execute the ListFormulas subroutine. The subroutine will insert a new worksheet that contains a list of the formulas and their values.
The ListFormulas Subroutine
Dim FormulaCells As Range, Cell As Range
Dim FormulaSheet As Worksheet
Dim Row As Integer
' Create a Range object for all formula cells
On Error Resume Next
Set FormulaCells = Range("A1").SpecialCells(xlFormulas, 23)
' Exit if no formulas are found
If FormulaCells Is Nothing Then
MsgBox "No Formulas."
' Add a new worksheet
Application.ScreenUpdating = False
Set FormulaSheet = ActiveWorkbook.Worksheets.Add
FormulaSheet.Name = "Formulas in " & FormulaCells.Parent.Name
' Set up the column headings
Range("A1") = "Address"
Range("B1") = "Formula"
Range("C1") = "Value"
Range("A1:C1").Font.Bold = True
' Process each formula
Row = 2
For Each Cell In FormulaCells
Application.StatusBar = Format((Row - 1) / FormulaCells.Count, "0%")
Cells(Row, 1) = Cell.Address _
Cells(Row, 2) = " " & Cell.Formula
Cells(Row, 3) = Cell.Value
Row = Row + 1
' Adjust column widths
Application.StatusBar = False
Way of adding gradients and rounded corners in an easy way directly in Interface Builder: