Skip to content

Instantly share code, notes, and snippets.

View bdukes's full-sized avatar

Brian Dukes bdukes

View GitHub Profile
@bdukes
bdukes / ClearUsers.sql
Created March 22, 2013 18:14
Clear out orphan users from DNN
DELETE UserProfile WHERE UserID IN (SELECT UserID FROM Users WHERE UserID NOT IN (SELECT UserID FROM UserPortals) AND IsSuperUser = 0)
DELETE aspnet_Membership WHERE UserId IN (SELECT UserId FROM aspnet_Users WHERE UserName IN (SELECT UserName FROM Users WHERE UserID NOT IN (SELECT UserID FROM UserPortals) AND IsSuperUser = 0))
DELETE aspnet_Profile WHERE UserId IN (SELECT UserId FROM aspnet_Users WHERE UserName IN (SELECT UserName FROM Users WHERE UserID NOT IN (SELECT UserID FROM UserPortals) AND IsSuperUser = 0))
DELETE aspnet_Users WHERE UserName IN (SELECT UserName FROM Users WHERE UserID NOT IN (SELECT UserID FROM UserPortals) AND IsSuperUser = 0) DELETE Users WHERE UserID NOT IN (SELECT UserID FROM UserPortals) AND IsSuperUser = 0
@bdukes
bdukes / 1.txt
Created November 20, 2012 15:51
SoX output with Write-Progress
Transforming Audio
20121111-Ranvestel-TwoShallBecomeOne_3.MP3
[oooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo]
Input File : 'C:\Users\bdukes\Dropbox\Music\Podcasts\20121111-Ranvestel-TwoShallBecomeOne_3.MP3'
Channels : 2
Sample Rate : 48000
Precision : 16-bit
Duration : 00:56:26.16 = 162535680 samples ~ 253962 CDDA sectors
File Size : 24.1M
@bdukes
bdukes / Telerik.RadEditor.onChange.js
Created September 26, 2012 16:15
RadEditor onChange
var editor = $find($('.RadEditor').first().attr('id'));
editor.attachEventHandler('onkeyup', function (event) {
console.log(editor.get_html());
});
@bdukes
bdukes / skin.ascx
Created May 24, 2012 19:45
DNN Meta Skin Object example
<%@ Control Language="C#" AutoEventWireup="true" Inherits="DotNetNuke.UI.Skins.Skin" %>
<%@ Register TagPrefix="dnn" TagName="Meta" Src="~/Admin/Skins/Meta.ascx" %>
<script runat="server">
private void Page_PreRender(object sender, EventArgs e) {
var metaRobots = Page.FindControl("MetaRobots") as HtmlMeta;
if (metaRobots != null) {
metaRobots.Visible = false;
}
}
@bdukes
bdukes / default.css
Created February 23, 2012 16:54
Default DotNetNuke CSS (version 6.1.2)
/*
* Deprecated DNN CSS class names will remain available for some time
* before being permanently removed. Removal will occur according to
* the following process:
*
* 1. Removal will only occur with a major (x.y) release, never
* with a maintenance (x.y.z) release.
* 2. Removal will not occur less than six months after the release
* when it was deprecated.
* 3. Removal will not occur until after deprecation has been noted
@bdukes
bdukes / Template.htm
Created February 7, 2012 22:55
Engage: Rotator Template With Template Value in Attribute
<div class="rotate-wrap">
<engage:list>
<div class="image" style="background:url('<engage:Literal Text='%#ImageUrl%' />');height:250px;width:100px;"></div>
</engage:list>
</div>
.blog .main {
float: left;
width: 61.111111111111%; /* 550px / 900px */
}
.blog .adside {
float: right;
width: 36.7777778%; /* 331px / 900px */
}
@bdukes
bdukes / Skin.ascx
Created December 7, 2011 17:48
DNN Skin with Client Capability checks
<%@ Control Language="C#" AutoEventWireup="false" Inherits="DotNetNuke.UI.Skins.Skin" %>
<%@ Import Namespace="DotNetNuke.Services.ClientCapability" %>
<div class="<%= ClientCapabilityProvider.CurrentClientCapability.IsTouchScreen ? "touch-please" : "no-touching" %>">
<div id="ContentPane" runat="server"></div>
</div>
@bdukes
bdukes / ClearPortal.cs
Created June 7, 2011 18:18
Attempts to clear DotNetNuke page output cache. Using the PE MemoryOutputCachingProvider
OutputCachingProvider.Instance(Host.PageCachingMethod).PurgeCache(portalId);
@bdukes
bdukes / web.config
Created May 5, 2011 13:55
Assembly binding redirect for Ajax Control Toolkit. <runtime> element is at the same level as <system.web> and <system.webServer>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<probing privatePath="bin;bin\HttpModules;bin\Providers;bin\Modules;bin\Support;" />
<dependentAssembly xmlns="urn:schemas-microsoft-com:asm.v1">
<assemblyIdentity name="AjaxControlToolkit" publicKeyToken="28f01b0e84b6d53e" />
<bindingRedirect oldVersion="0.0.0.0-99.99.99.99" newVersion="4.1.50401.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>