Skip to content

Instantly share code, notes, and snippets.

Avatar

James Skemp JamesSkemp

View GitHub Profile
@JamesSkemp
JamesSkemp / README.md
Last active Apr 14, 2020
.NET auto versioning math
View README.md

When using 1.0.*.* for the AssemblyVersion it will automatically populate the build and revision numbers.

Build number can be determined via the following LINQPad C# Statements.

var startingDate = new DateTime(2000, 1, 1);
DateTime.Now.Subtract(startingDate).Dump();

startingDate.AddDays(4695).Dump();
startingDate.AddDays(7409).Dump();
@JamesSkemp
JamesSkemp / red-sword-skills.md
Last active Mar 25, 2020
Red Sword (Android) Skills
View red-sword-skills.md

Skills from Red Sword as of version 1.1.9. Some added from 1.2.1.

Order based upon Skill catalog.

Name Rarity Cooldown Damage Number Description Cost Inheritance Cost
F Laser Rod 2 6.2s 750 1 Fires a laser beam
F Laser Rod +1 3 6.4s 1400 1 Fires a laser beam
Magic Trigger 1 2.6s 38 1 Places a trap
Raining Arrows 1 8.7s 13 26 Magic arrows rain from above 600
@JamesSkemp
JamesSkemp / rpg-dice-roller.d.ts
Created Aug 17, 2019
TypeScript definitions for GreenImp/rpg-dice-roller
View rpg-dice-roller.d.ts
/** Declaration file generated by dts-gen */
/** For https://github.com/GreenImp/rpg-dice-roller */
/** This is a work in progress */
declare module "rpg-dice-roller" {
export class DiceRoll {
/**
*
* @param notation
*/
constructor(notation: string);
@JamesSkemp
JamesSkemp / find net version.linq
Created Apr 3, 2019
Find Installed .NET Version with LINQPad
View find net version.linq
<Query Kind="Program">
<Namespace>Microsoft.Win32</Namespace>
</Query>
// From https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/how-to-determine-which-versions-are-installed
public static void Main()
{
Get45PlusFromRegistry();
}
View solr-patch-config
<?xml version="1.0"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/" xmlns:search="http://www.sitecore.net/xmlconfig/search/">
<sitecore search:require="solr">
<contentSearch>
<configuration type="Sitecore.ContentSearch.ContentSearchConfiguration, Sitecore.ContentSearch">
<indexes hint="list:AddIndex">
<index id="sitecore_master_index" type="Sitecore.ContentSearch.SolrProvider.SolrSearchIndex, Sitecore.ContentSearch.SolrProvider">
<param desc="core" patch:instead="param[@desc='core']">instance1_$(id)</param>
</index>
<index id="sitecore_core_index" type="Sitecore.ContentSearch.SolrProvider.SolrSearchIndex, Sitecore.ContentSearch.SolrProvider">
@JamesSkemp
JamesSkemp / __.md
Last active Jun 7, 2018
Example getting first 10 requests from today's IIS logs and saving to dated txt file
View __.md

See https://stackoverflow.com/a/10945887/11912 for more information on the first two lines (today is being set just to help understand the date formatting).

If run 6/7/2018, it would check the IIS log at C:\inetpub\logs\LogFiles\W3SVC1\u_ex180607.log and save the output to _test180607.txt.

@JamesSkemp
JamesSkemp / elmah - class.cs
Last active Jan 29, 2018
Parse ELMAH XML files with LINQPad (C# Program)
View elmah - class.cs
void Main()
{
// Update with the path to Elmah.Errors/where the ELMAH logs are being stored.
var directoryPath = @"\\path\to\Elmah.Errors\";
var directory = new DirectoryInfo(directoryPath);
var files = directory.GetFiles("*.xml").OrderByDescending(f => f.CreationTime);
files.Count().Dump();
var messages = new List<string>();
@JamesSkemp
JamesSkemp / Search Files with Git Grep.ps1
Last active Jan 29, 2020
Use built-in Windows functionality to find a string of text in a directory.
View Search Files with Git Grep.ps1
# Can only be run within a Git repository, but this will also search untracked files, as well as those that are tracked.
git grep --untracked '<term>'
@JamesSkemp
JamesSkemp / Application Settings.md
Created Aug 24, 2017
Visual Studio Code Settings
View Application Settings.md

Application Settings

Extensions

  • Add jsdoc comments
  • C#
  • C# XML Documentation
  • Cordova Tools
  • PowerShell
  • seti-icons
View CREATE VIEW.sql
CREATE VIEW authorizer.ElevatedUserSiteRoles
AS
/*
DESCRIPTION: Used to display all elevated users with their specific site roles.
CALLED BY: SSMS.
*/
SELECT u.Id AS UserId, u.NetId, u.Added, u.SiteId, s.WiscWebId, s.Name AS SiteName, s.Url, s.DefaultRole, s.RequireWsb, u.RoleId, r.Name AS RoleName, r.[Description]
FROM authorizer.ElevatedUser u
LEFT JOIN authorizer.WiscWebSite s ON u.SiteId = s.Id
LEFT JOIN authorizer.AccessRole r ON u.RoleId = r.Id
You can’t perform that action at this time.