leekelleher’s gists

leekelleher / backup-dev.bat

Created April 13, 2012 17:33

Personal batch script to quickly back-up my MSSQL database and wwwroot files, (typically for use with Umbraco).

	:: ###### BACK-UP JOB ######
	@ECHO OFF

	:: Set the constants
	SET BACKUP_DIR=C:\path\to\_backup
	SET TEMP_DIR=%BACKUP_DIR%\TEMP
	SET TODAY=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%
	SET ARCHIVE_DIR=%BACKUP_DIR%\%TODAY%
	SET WWWROOT_NAME="ProjectName"
	SET WWWROOT_SOURCE=C:\path\to\wwwroot

leekelleher / SearchResults.xslt

Created February 21, 2012 21:26

Manipulate XSLTsearch

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE xsl:stylesheet [
	<!ENTITY nbsp " ">
	]>
	<xsl:stylesheet
	version="1.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns:msxml="urn:schemas-microsoft-com:xslt"
	xmlns:umbraco.library="urn:umbraco.library"
	xmlns:PS.XSLTsearch="urn:PS.XSLTsearch"

leekelleher / ArchiveNewsPages.cs

Created January 9, 2012 16:01

Example Umbraco /Base method to archive news pages if they are over 30 days. (Using uComponents' uQuery)

	using uComponents.Core.uQueryExtensions;
	using umbraco.presentation.umbracobase;

	namespace Our.Umbraco
	{
	[RestExtension("examples")]
	public class Examples
	{
	public static bool ArchiveNewsPages()
	{

leekelleher / cakes.json

Created November 28, 2011 16:56

Example JSON dataset (for uComponents' JsonDropDown data-type)

leekelleher / NavigationAToZ.xslt

Created November 24, 2011 11:22

XSLT snippet for generating an A to Z list for Umbraco content nodes.

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE xsl:stylesheet [
	<!ENTITY nbsp " ">
	]>
	<xsl:stylesheet version="1.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns:msxml="urn:schemas-microsoft-com:xslt"
	xmlns:umbraco.library="urn:umbraco.library"
	exclude-result-prefixes="msxml umbraco.library">

leekelleher / ExternalLink.master

Created September 22, 2011 15:48

Umbraco template to redirect to an external URL, (set as a property on the current page/node).

	<%@ Master Language="C#" MasterPageFile="~/umbraco/masterpages/default.master" AutoEventWireup="true" %>
	<%@ Import Namespace="umbraco" %>

	<script runat="server">
	protected void Page_Load(object sender, EventArgs e)
	{
	var url = uQuery.GetCurrentNode().GetPropertyAsString("url");
	if (!string.IsNullOrEmpty(url))
	{
	Response.RedirectPermanent(url, true);

leekelleher / USStatesDataType.cs

Created September 14, 2011 19:47

U.S. States DropDownList DataType for Umbraco

	using System;
	using System.Collections.Generic;
	using System.Web.UI.WebControls;
	using umbraco.cms.businesslogic.datatype;

	namespace Our.Umbraco.DataTypes
	{
	public class USStates : AbstractDataEditor
	{
	private DropDownList m_Control = new DropDownList();

leekelleher / ForceEmptyRecycleBin.sql

Last active July 18, 2020 11:15

Umbraco: Force empty the Recycle Bin

	-- Uncomment below to verify the number of nodes returned is the same as the number of nodes that is in the Recycle Bin
	-- SELECT * FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20

	-- Delete all 'related' nodes and table contents...
	DELETE FROM cmsPreviewXml WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
	DELETE FROM cmsContentVersion WHERE contentId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
	DELETE FROM cmsDocument WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
	DELETE FROM cmsContentXML WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
	DELETE FROM cmsContent WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)
	DELETE FROM cmsPropertyData WHERE contentNodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20)

leekelleher / RedirectToFirstChild.master

Created August 24, 2011 15:55

Umbraco template to redirect the current page/node to its first child page/node.

	<%@ Master Language="C#" MasterPageFile="~/masterpages/BlankTemplate.master" AutoEventWireup="true" %>
	<script runat="server">
	protected void Page_Load(object sender, EventArgs e)
	{
	var current = umbraco.NodeFactory.Node.GetCurrent();
	if (current != null)
	{
	var child = current.ChildrenAsList.FirstOrDefault();
	if (child != null)
	{

leekelleher / PaginationExample.xslt

Created August 3, 2011 08:08

Generic XSLT template for pagination with Umbraco

	<?xml version="1.0" encoding="utf-8"?>
	<!DOCTYPE xsl:stylesheet [
	<!ENTITY nbsp " ">
	]>
	<xsl:stylesheet
	version="1.0"
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns:msxml="urn:schemas-microsoft-com:xslt"
	xmlns:umbraco.library="urn:umbraco.library"
	exclude-result-prefixes="msxml umbraco.library">

Lee Kelleher leekelleher