Skip to content

Instantly share code, notes, and snippets.

View tillig's full-sized avatar

Travis Illig tillig

View GitHub Profile
@tillig
tillig / DatabaseMaintenance.aspx
Last active January 4, 2017 22:10
Subtext database administration page
<%@ Page Language="C#" Debug="true" EnableTheming="false" Title="Subtext Admin - Database Maintenance" MasterPageFile="~/aspx/Admin/WebUI/AdminPageTemplate.Master" AutoEventWireup="True" Inherits="Subtext.Web.Admin.Pages.AdminPage" %>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="Microsoft.ApplicationBlocks.Data" %>
<%@ Import Namespace="Subtext.Framework.Providers" %>
<script runat="server">
// Timeout has to be longer than the default because these ops can take a while.
@tillig
tillig / CreateTimeSnapperTaskDb.sql
Created January 4, 2017 22:35
Simple primary/subtask database integration for TimeSnapper.
USE [TimeSnapperTaskDb]
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'task_list'
GO
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'task_list'
GO
ALTER TABLE [dbo].[task] DROP CONSTRAINT [FK_task_project]
GO
@tillig
tillig / EnableCustomLyncStatus.reg
Created January 4, 2017 22:39
Enable a custom status in Microsoft Lync.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Office\15.0\Lync]
"EnableSIPHighSecurityMode"=dword:00000000
"CustomStateURL"="file:///C:/Users/tillig/OneDrive/Settings/Lync/presence.xml"
@tillig
tillig / itunes2html.xsl
Created January 4, 2017 23:36
XSL to convert your iTunes library to an HTML table
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
<table border="1">
<tr>
<th>Track ID</th>
<th>Name</th>
<th>Artist</th>
<th>Album</th>
@tillig
tillig / vsnetcmd.reg
Created January 4, 2017 23:46
VS 2003 Command Prompt Here
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Command Processor]
"AutoRun"="\"%VS71COMNTOOLS%vsvars32.bat\""
@tillig
tillig / FusLogVwSet.wsf
Created January 4, 2017 23:50
Enable/disable .NET Fusion logging for troubleshooting assembly binding issues.
<?xml version="1.0" ?>
<?job error="true" debug="false" ?>
<!--
'============================================================================
' FUSION LOG VIEWER SETTINGS
' FusLogVwSet.wsf
' Travis Illig
' tillig@paraesthesia.com
' http://www.paraesthesia.com
'
@tillig
tillig / sharpreader2rssbandit.xslt
Created January 4, 2017 23:52
Convert RSS Bandit export format to OPML for SharpReader (or other RSS reader) import.
<?xml version="1.0"?>
<!--
SharpReader2RssBandit.xslt v1.0
Travis Illig
tillig@paraesthesia.com
http://www.paraesthesia.com
Export your list of feeds from SharpReader, then
transform the output with this XSLT. The resulting
document can be imported into RSS Bandit and should
@tillig
tillig / M4P Backup.vbs
Created January 4, 2017 23:54
Automate running hymn against an iTunes library for removing DRM.
' M4P Backup
' by Travis Illig
' http://www.paraesthesia.com
'
' This script backs up your protected iTunes music (*.m4p) along with a
' decrypted version (*.m4a). The decryption is done using the "hymn"
' program, available at http://hymn-project.org/.
'
' Note that for "hymn" to properly decrypt your iTunes files, you may
' need to use the "FairKeys" program, available at
@tillig
tillig / TypemockSnippetTemplate.cs
Created January 5, 2017 18:39
Typemock Isolator snippet template for Snippet Compiler 2008.
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.IO;
using NUnit.Framework;
using TypeMock;
public class MyClass
{
}
@tillig
tillig / Add-DownloadedCoverArtToFile.js
Created January 5, 2017 18:54
Add cover art that iTunes downloaded so it's embedded into the track directly.
// Add-DownloadedCoverArtToFile.js
// By Travis Illig - http://www.paraesthesia.com
// THIS SCRIPT MODIFIES YOUR ITUNES TRACKS TO EMBED DOWNLOADED
// ARTWORK INTO TRACKS. USE AT YOUR OWN RISK. BACK UP YOUR FILES
// BEFORE RUNNING.
//
// Open iTunes, then run using cscript:
// cscript Add-DownloadedCoverArtToFile.js
// Set MAX_TRACKS_TO_PROCESS to the max number of tracks to process