AaronSadlerUK

-- Find PUBLISHED content with macros in Umbraco 13
SELECT DISTINCT 
    n.text AS 'Content Name',
    n.id AS 'Node ID',
    pt.Alias AS 'Property Alias',
    SUBSTRING(pd.textValue, 1, 500) AS 'Preview'
FROM umbracoPropertyData pd
INNER JOIN umbracoContentVersion cv ON pd.versionId = cv.id
INNER JOIN umbracoDocumentVersion dv ON cv.id = dv.id AND dv.published = 1
INNER JOIN umbracoNode n ON cv.nodeId = n.id

AaronSadlerUK

# Git
.git
.gitignore
.gitattributes
*/.github

# Build outputs
**/bin/
**/obj/
**/out/

AaronSadlerUK

#!/bin/bash

RESOURCE_GROUP="your-rg"
APP_NAME="your-app"
PRIORITY_START=200

priority=$PRIORITY_START

curl -s https://cdn.uptimerobot.com/api/IPv4andIPv6.txt | while read -r ip; do
  [[ -z "$ip" ]] && continue

AaronSadlerUK

                bool isManual = false;
                if (context != null)
                {
                    var jobId = context.BackgroundJob?.Id;

                    if (jobId != null)
                    {
                        var jobDetails = JobStorage.Current.GetMonitoringApi().JobDetails(jobId);
                        if (jobDetails != null)
                            isManual = jobDetails.History.ToList()

AaronSadlerUK

using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using Umbraco.Cms.Core.Configuration.Models;
using Umbraco.Cms.Core.Models.PublishedContent;
using Umbraco.Cms.Core.Routing;
using Umbraco.Cms.Core.Services;
using Umbraco.Cms.Core.Web;

public class HomePageUrlProvider : DefaultUrlProvider
{

AaronSadlerUK

# Set the directory path where you want to search
$directory = "E:\\"

# Get files matching the specified pattern and older than 90 days
$files = Get-ChildItem -Path $directory -Filter "UmbracoTraceLog*" -Recurse | Where-Object { $_.LastWriteTime -lt (Get-Date).AddDays(-90) }

$count = $files.Count

Write-Host "Number of files found: $count"

AaronSadlerUK

select * from cmsDataType where nodeId = ID

update cmsDataType set propertyEditorAlias = 'Umbraco.DropDown.Flexible' where nodeId = ID

select * from cmsDataTypePreValues where datatypeNodeId = ID

insert into cmsDataTypePreValues (alias, sortorder, [value], datatypeNodeId) values ('multiple', 7, '0', ID)

AaronSadlerUK

DECLARE @AlterStatements TABLE (
    Statement NVARCHAR(MAX)
)

INSERT INTO @AlterStatements (Statement)
SELECT 'ALTER INDEX [' + I.name + '] ON [' + T.name + '] REBUILD'
FROM sys.indexes I
INNER JOIN sys.tables T ON I.object_id = T.object_id
WHERE I.type_desc = 'NONCLUSTERED'
AND I.name IS NOT NULL

AaronSadlerUK

<script id="gtmScript" data-nonce="@Html.CspScriptNonceValue()">
(function (w, d, s, l, i) {
w[l] = w[l] || []; w[l].push({
'gtm.start':
new Date().getTime(), event: 'gtm.js'
}); var f = d.getElementsByTagName(s)[0],
j = d.createElement(s), dl = l != 'dataLayer' ? '&l=' + l : ''; j.async = true; j.src =
'https://www.googletagmanager.com/gtm.js?id=' + i + dl; var n = d.querySelector('[nonce]');
n && j.setAttribute('nonce', n.nonce || n.getAttribute('nonce')); f.parentNode.insertBefore(j, f);
})(window, document, 'script', 'dataLayer', '###-#######');</script>

AaronSadlerUK

using Umbraco.Cms.Core.Models.PublishedContent;
using Umbraco.Cms.Core;
using Umbraco.Cms.Core.PropertyEditors.ValueConverters;
using Umbraco.Cms.Core.PublishedCache;
using Umbraco.Cms.Core.Composing;
using Umbraco.Cms.Core.DependencyInjection;
using Umbraco.Cms.Core.Services;

public class IntFriendlyMediaPickerValueConverter : MediaPickerValueConverter
{