Skip to content

Instantly share code, notes, and snippets.

View hmcclungiii's full-sized avatar
👨‍💻
Available for Hire

Houston McClung hmcclungiii

👨‍💻
Available for Hire
9 followers · 115 following
View GitHub Profile
@hmcclungiii
hmcclungiii / dbo.Country.sql
Created November 13, 2016 05:43
MS SQL dump of countries along with their ISO codes, phone codes, and other related information. I took this from http://www.infomazing.net/blog/database-country-table-with-sql-insert-statements
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Country](
@hmcclungiii
hmcclungiii / wp_terms-states.sql
Last active March 6, 2016 21:28
An SQL Query to Add the 50 US States into the Wordpress wp_terms (Categories) Table
INSERT INTO `wp_terms`(`name`, `slug`, `term_group`) VALUES
('AK - Alaska', 'ak', 0),
('AZ - Arizona', 'az', 0),
('AR - Arkansas', 'ar', 0),
('CA - California', 'ca', 0),
('CO - Colorado', 'co', 0),
('CT - Connecticut','ct', 0),
('DE - Delaware','de', 0),
('FL - Florida','fl', 0),
('GA - Georgia','ga', 0),
@hmcclungiii
hmcclungiii / states.sql
Last active March 6, 2016 20:27 — forked from JeremyMorgan/states.sql
An SQL Query to insert 50 U.S. States into a database.Make sure your auto increment is set in MySQL, and Identity_insert is set in MS-SQL.
CREATE TABLE [state](
[stateID] [int] IDENTITY(1,1) NOT NULL,
[stateCode] [nchar](2) NOT NULL,
[stateName] [nvarchar](128) NOT NULL,
CONSTRAINT [PK_state] PRIMARY KEY CLUSTERED
( [stateID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY])
ON [PRIMARY]
@hmcclungiii
hmcclungiii / functions.php
Created January 19, 2016 20:02
Adds a custom stylesheet to your WordPress Login Page.
<?php
/* You can remove the above opening php tag
when pasting this code inside your
functions.php file.
*/
/* The following code adds your custom stylesheet
to the wordpress login screen, allowing you to
customize the background, colors and fonts of the
page to match your custom theme.
@hmcclungiii
hmcclungiii / gist:df345264901ed2dac905
Last active August 29, 2015 14:19
Zig-Zag Borders, Credit to http://bradsknutson.com/blog/css-zig-zag-border/
<div class="container1"></div>
<div class="container2 zigzag"></div>
<div class="container3 zigzag"></div>
<div class="container4 zigzag"></div>
/* Zig-Zag Border
Credit to http://bradsknutson.com/blog/css-zig-zag-border/
*/
.container1 {
width: 100%;
@hmcclungiii
hmcclungiii / border.css
Created March 20, 2015 19:07
CSS to add borders to any box element.
.borders {
-webkit-box-shadow: 0px 1px 3px #666666;
-moz-box-shadow: 0px 1px 3px #666666;
box-shadow: 0px 1px 3px #666666;
-webkit-border-radius: 10;
-moz-border-radius: 10;
border-radius: 10px;
}
@hmcclungiii
hmcclungiii / button.css
Created March 19, 2015 21:43
A nice clickable button in css.
.button {
-webkit-border-radius: 10;
-webkit-box-shadow: 0px 1px 3px #666666;
-moz-border-radius: 10;
-moz-box-shadow: 0px 1px 3px #666666;
background: #F97878;
border-radius: 10px;
box-shadow: 0px 1px 3px #666666;
color: #ffffff;
font-family: Arial;
@hmcclungiii
hmcclungiii / eventpattern.cs
Created April 14, 2014 07:25
C# Event Pattern
namespace eventpattern {
public delegate void AllPropertiesDetailsParsedEventHandler(object sender, AllPropertiesDetailsParsedEventArgs e);
public class AllPropertiesDetailsParsedEventArgs : EventArgs
{
}
public partial class Controller
{
public event AllPropertiesDetailsParsedEventHandler AllPropertiesDetailsParsed;
@hmcclungiii
hmcclungiii / gist:9924148
Created April 1, 2014 22:10
Remove any non-numeric characters from a string.
string newValue = System.Text.RegularExpressions.Regex.Replace(oldValue, "[^.0-9]", "");
@hmcclungiii
hmcclungiii / clean.bat
Created March 12, 2014 04:51
Simple little batch file that I use to delete unneeded files that are generated at compile time.
@echo off
FOR /D /R %%X IN (debug,release,bin,obj,ipch) DO RD /S /Q "%%X"
del /S /F /AH *.suo
del /S /F *.user
del /S /F *.ncb
del /S /F *.sbr
del /S /F *.log