Skip to content

Instantly share code, notes, and snippets.

@tombmedia
tombmedia / prd.md
Created April 21, 2025 02:56 — forked from burkeholland/prd.md
TheUrlist PRD

Project Requirements Document: The Urlist Website

The following table outlines the detailed functional requirements of The Urlist website.

Requirement ID Description User Story Expected Behavior/Outcome
FR001 Creating a New URL List As a user, I want to be able to start a new, empty list so I can begin adding URLs. The system should provide a clear way for the user to initiate the creation of a new list, potentially presenting an empty list view or an "add new list" button.
FR002 A
@tombmedia
tombmedia / UpdateIISExpressCertificate.ps1
Last active November 20, 2022 20:25 — forked from camieleggermont/UpdateIISExpressCertificate.ps1
This powershell script generates a new certificate, removes the old certificate assignments from the IISExpress ssl ports and adds the newly generated one. The certificate is also copied over to the Trusted Root Certificate Authorities.
$cert = New-SelfSignedCertificate -DnsName "localhost", "localhost" -CertStoreLocation "cert:\LocalMachine\My" -NotAfter (Get-Date).AddYears(10)
$thumb = $cert.GetCertHashString()
For ($i=44300; $i -le 44399; $i++) {
netsh http delete sslcert ipport=0.0.0.0:$i
}
For ($i=44300; $i -le 44399; $i++) {
netsh http add sslcert ipport=0.0.0.0:$i certhash=$thumb appid=`{214124cd-d05b-4309-9af9-9caa44b2b74a`}
}
@tombmedia
tombmedia / UmbracoTemplateQuery
Created March 14, 2016 16:02
Get a list of all Umbraco nodes which use a certain template
DECLARE @templateId AS int
SET @templateId = 1234
SELECT C.path AS 'Path',
C.level AS 'Level',
C.id AS 'Node Id',
C.text AS 'Text',
A.alias AS 'docType Alias'
FROM cmsContentType A
@tombmedia
tombmedia / UmbracoMediaQuery
Created March 10, 2016 21:05
Get the a list of all media nodes in Umbraco
select * from cmsPropertyData
inner join cmsPropertyType on cmsPropertyData.propertytypeid = cmsPropertyType.id
inner join cmsDataType on cmsPropertyType.dataTypeId = cmsDataType.nodeId
where cmsDataType.controlId = '5032a6e6-69e3-491d-bb28-cd31cd11086c'
and cmsPropertyData.dataNvarchar is not null