Laim

## modifiers.txt
%USERPROFILE%\AppData\LocalLow\Mandragora\I Am Future\SaveData

-- Go for the NEWEST save, as there is an auto save system.  Make sure you're in the main menu or not in-game at all, if you're on the Roof then the changes won't take affect.

Open the json file in a file editor (vscode, notepad++, notepad (not the best for it, massive file))

Ctrl+f, replace the value with the value you want.

=========

## powershell_messaging_system.ps1
<#

.SYNOPSIS
Sends a message to an external provider such as Discord or Telegram

.DESCRIPTION
Script that allows sending a pre-defined message to Discord or Telegram.  Useful for Handbrake when conversions are completed.

.PARAMETER messageSystem
Which message system you want to use, Discord or Telegram.

## org_rules.sql
/*

	Author: Laim McKenzie
	URL: https://gist.github.com/Laim/dee0e030cc6b452d1eafb4b7e48ca9c5
	Date: 14-03-2022

*/

SELECT

## handbrakePresets.json
{
  "PresetList": [
    {
      "ChildrenArray": [
        {
          "AlignAVStart": true,
          "AudioCopyMask": [
            "copy:aac"
          ],
          "AudioEncoderFallback": "av_aac",

## SSLlabs-powershellscan.ps1
<#
.NOTES
    Version         : 1.0
    Author          : Laim McKenzie
    Creation Date   : 17.05.2021
    Purpose         : Automation of SSLLabs SSLtests.
    Credits         : Modified version of script by /u/tramperdk
#>


## lmu_del_sql_jobs.sql
/*
	Author: Laim McKenzie
	Website: https://laim.scot
	Version: 1.0

	Modified version of https://sqlgeekspro.com/script-to-delete-sql-agent-jobs/
*/

DECLARE @SQLStatement VARCHAR(200)
DECLARE @jobName SYSNAME

## CopyLogFiles.ps1
#<----------------------------------------->#
# > Author: Laim McKenzie
# > Date: 29-07-2021
# > Description: This script can be ran under a Scheduled Task and collect log files from the Source Directory and copy to the Destination Directory
# > Pre-requisites:
# >              1. You need to ensure the Source Directory exists
# >              2. You need to ensure the Desitnation Directory exists
# >              3. The account running the scheduled task (if ran under one) needs to have access to both directories
# > Copyright (c) 2021 Laim McKenzie
#<----------------------------------------->#

## hide_unassigned.sql
/*
	Author: Laim McKenzie
	Website: https://laim.scot
	Version: 1.0

	You can view the Hidden Software count using this script
	SELECT COUNT(*) FROM SnowLicenseManager.dbo.tblSoftware WHERE IsHidden = 1

*/

## snow_stuff.sql
-- Custom Fields
SELECT C.Name, COUNT(CF.CID) AS [CustomFieldCount] FROM SnowLicenseManager.dbo.tblCustomField CF
INNER JOIN SnowLicenseManager.dbo.tblCID C ON CF.CID = C.CID
GROUP BY C.Name

-- Custom Compare Values
SELECT C.Name, COUNT(CCV.CID) AS [CCVCount] FROM SnowLicenseManager.dbo.tblCustomCompareValues CCV
INNER JOIN SnowLicenseManager.dbo.tblCID C ON CCV.CID = C.CID
GROUP BY C.Name

## versions.ps1
# START : Get SQL Instance Version #
cls # prevents the script itself from echoing out into ISE

"---------------------------------------------------------------------"

$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances # Gets the installed SQL instances

$sqlInstanceCount = 0; # loop for the foreach

foreach ($i in $inst)
	%USERPROFILE%\AppData\LocalLow\Mandragora\I Am Future\SaveData

	-- Go for the NEWEST save, as there is an auto save system. Make sure you're in the main menu or not in-game at all, if you're on the Roof then the changes won't take affect.

	Open the json file in a file editor (vscode, notepad++, notepad (not the best for it, massive file))

	Ctrl+f, replace the value with the value you want.

	=========
	<#

	.SYNOPSIS
	Sends a message to an external provider such as Discord or Telegram

	.DESCRIPTION
	Script that allows sending a pre-defined message to Discord or Telegram. Useful for Handbrake when conversions are completed.

	.PARAMETER messageSystem
	Which message system you want to use, Discord or Telegram.
	/*

	Author: Laim McKenzie
	URL: https://gist.github.com/Laim/dee0e030cc6b452d1eafb4b7e48ca9c5
	Date: 14-03-2022

	*/

	SELECT
	{
	"PresetList": [
	{
	"ChildrenArray": [
	{
	"AlignAVStart": true,
	"AudioCopyMask": [
	"copy:aac"
	],
	"AudioEncoderFallback": "av_aac",
	<#
	.NOTES
	Version : 1.0
	Author : Laim McKenzie
	Creation Date : 17.05.2021
	Purpose : Automation of SSLLabs SSLtests.
	Credits : Modified version of script by /u/tramperdk
	#>
	/*
	Author: Laim McKenzie
	Website: https://laim.scot
	Version: 1.0

	Modified version of https://sqlgeekspro.com/script-to-delete-sql-agent-jobs/
	*/

	DECLARE @SQLStatement VARCHAR(200)
	DECLARE @jobName SYSNAME
	#<----------------------------------------->#
	# > Author: Laim McKenzie
	# > Date: 29-07-2021
	# > Description: This script can be ran under a Scheduled Task and collect log files from the Source Directory and copy to the Destination Directory
	# > Pre-requisites:
	# > 1. You need to ensure the Source Directory exists
	# > 2. You need to ensure the Desitnation Directory exists
	# > 3. The account running the scheduled task (if ran under one) needs to have access to both directories
	# > Copyright (c) 2021 Laim McKenzie
	#<----------------------------------------->#
	-- Custom Fields
	SELECT C.Name, COUNT(CF.CID) AS [CustomFieldCount] FROM SnowLicenseManager.dbo.tblCustomField CF
	INNER JOIN SnowLicenseManager.dbo.tblCID C ON CF.CID = C.CID
	GROUP BY C.Name

	-- Custom Compare Values
	SELECT C.Name, COUNT(CCV.CID) AS [CCVCount] FROM SnowLicenseManager.dbo.tblCustomCompareValues CCV
	INNER JOIN SnowLicenseManager.dbo.tblCID C ON CCV.CID = C.CID
	GROUP BY C.Name
	# START : Get SQL Instance Version #
	cls # prevents the script itself from echoing out into ISE

	"---------------------------------------------------------------------"

	$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances # Gets the installed SQL instances

	$sqlInstanceCount = 0; # loop for the foreach

	foreach ($i in $inst)