EM3R50N cemerson

Minecraft: Bookshelf Setup for getting Library of Alexandria (#Apotheosis)

After trying many different setups I finally got my shelves to allow infusing the Enchantment Library to get the Library of Alexandria w/the following setup:

  [01][02][03][04][05]
  [06]            [07]
  [08]            [09]
  [10]            [11]
  [12][13][14][15][16]

resolving issue where local development branch is out of sync has odd/new merge issues not on remote/azure/github ...

To reset your local development branch to match the remote branch from Azure DevOps (or any remote repository), you can use the following steps. This will overwrite your local branch completely with the latest version from the remote.

Steps to Reset `development` to Match Remote:

Switch to the development branch:

git checkout development

SFDC Authorize an Org Issues

Getting sfdx "Authorize an Org" to work is very hit/miss depending on your luck/setup/etc. This is mainly just a note to myself that when you're on the last part of the auth process where you're at a locahost URL post SFDC login and you get a ERR_CONNECTION REFUSED or other error, try changing the port in the URL to 7717 or 7177 and maybe it will work. This assumes MS Defender/etc have proper firewall rules/exeptions etc in place.

Related Errors/Strings

(mostly here just for metadata/search indexing)

ERR_CONNECTION_REFUSED
OauthRedirect
sfdx force:auth:web:login -a

Summary

I needed something to clean my HTML content when using in public/AI sources
I initially tried Sublime Text's "macros" but they apparently can't do search/replace which is insane (imo)
Finally got a Sublime Text "plugin" version working - it took bit of time to hash out because all online sources (including/especially AI) were wrong and gave back/non-functioning code.
Sharing in case others find useful.

Important

Camel Case Command

The command in the py file * * MUST * * be exactly camel case like this or it will silently fail and never show up in the cmd palette: If the file name is my_cool_plugin.py the PY class def should be like: MyCoolPluginCommand. So:

	BEGIN TRY
	BEGIN TRANSACTION
	-- DO STUFF
	ROLLBACK TRANSACTION --ROLLBACK COMMIT
	END TRY
	BEGIN CATCH
	IF @@TRANCOUNT > 0
	BEGIN
	ROLLBACK TRANSACTION
	END

	BEGIN TRANSACTION

	DECLARE @reviewMode int = '0';
	DECLARE @password nvarchar(max) = 'password_here';
	DECLARE @testStudyIDList NVARCHAR(MAX) = '2791,2793,2843,2844';
	DECLARE @testStudyID NVARCHAR(4000);
	DECLARE @TestStudyIDTable TABLE (ID NVARCHAR(4000));
	INSERT INTO @TestStudyIDTable(ID)
	SELECT Data FROM dbo.Split(@testStudyIDList, ',');

	/* ---------- Usage ----------------------------------
	string exceptionDetailsHtml = ExceptionHelper.GetExceptionDetailsInNicelyFormatted(ex, "HTML");
	Console.WriteLine(exceptionDetailsHtml);

	string exceptionDetailsText = ExceptionHelper.GetExceptionDetailsInNicelyFormatted(ex, "TEXT");
	Console.WriteLine(exceptionDetailsText);
	// ---------------------------------------------------- */
	public static class ExceptionHelper
	{
	public static string GetExceptionDetailsInNicelyFormatted(Exception ex, string displayFormat = "TEXT")

	function getRandomString(length) {
	const characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
	let result = '';
	const charactersLength = characters.length;
	for (let i = 0; i < length; i++) {
	result += characters.charAt(Math.floor(Math.random() * charactersLength));
	}
	return result;
	}

	BEGIN TRY
	-- Start a transaction
	BEGIN TRANSACTION;

	-- Your T-SQL statements go here
	-- Example:

	----- YOUR SQL WORK HERE

	-- If everything is successful, commit the transaction

	var videoPlayers = document.querySelectorAll("video");
	for(v=0;v<videoPlayers.length;v++) videoPlayers[v].playbackRate = 1.65;