Wellington Moraes kaellego

Big Endian Types for Cheat Engine

These auto assembly scripts add big endian value types for Cheat Engine, which is useful for games like Breath of the Wild.

How to add big endian types to Cheat Engine

Open Cheat Engine.
Attach to any process.
Right-click on the Value Type drop down box.
Click Define new custom type (Auto Assembler).

Workaround for Retrieving Direct Links of All Sheets from URL of `2PACX-###` of Web Published Google Spreadsheet

This is a sample script for retrieving the direct links of all sheets from the URL like https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml of the web published Google Spreadsheet. This sample script can be used for the following situation.

The Spreadsheet is published to Web and the URL like https://docs.google.com/spreadsheets/d/e/2PACX-###/pubhtml is known
You are not the owner of Google Spreadsheet.
You don't know the Spreadsheet ID and Sheet IDs.

Under above situation, unfortunately, the direct links of each sheet cannot be directly retrieved. I think that this is the specification of Google side. So in this post, I would like to introduce a workaround for retrieving the direct links of each sheet under above situation.

OpenVPN Server and certificate management on MikroTik

Notes on learning Active Directory

NetBIOS name should match your forest FQDN. So if FQDN=adlunches.net, NetBIOS name is ADLUNCHES
Every AD forest has a server which indexes all the objects in the forest. This is known as the Global Catalog server.
1. Each domain needs at least 1 GC server, can have more for redundancy. This is so it can find objects in other domains.
2. Any DC can be GC.
3. By default all DCs will be GCs. GCs take up disk space and bandwidth, but both are plentiful.
4. Microsoft Exchange requires GC server to run.
5. Allow logins via UPN eg. [email protected], which may be on same domain.
GC servers should be deployed at sites with poor WAN links or filtered connections.

⚠️ Note!

With VSCode version 1.94, the APC extension broke and there is no fix yet.

So, for those having issues with APC after the VSCode update, I recommend downloading the previous version of VSCode for now (https://code.visualstudio.com/updates/v1_93) and setting updates to manual by adding this to the editor's configuration:

"update.mode": "manual",

Microsoft Windows and Office KMS Setup

	# Install Ubiquiti Unifi Controller on Ubuntu 20.04.
	# As tested on a fresh install of ubuntu-20.04.1-live-server, August 22nd 2020.
	# Thanks to https://gist.github.com/tmuncks for posting the updated install steps.

	sudo apt update
	sudo apt install --yes apt-transport-https

	echo 'deb https://www.ui.com/downloads/unifi/debian stable ubiquiti' \| sudo tee /etc/apt/sources.list.d/100-ubnt-unifi.list
	sudo wget -O /etc/apt/trusted.gpg.d/unifi-repo.gpg https://dl.ui.com/unifi/unifi-repo.gpg

	Serial Keys:

	FU512-2DG1H-M85QZ-U7Z5T-PY8ZD
	CU3MA-2LG1N-48EGQ-9GNGZ-QG0UD
	GV7N2-DQZ00-4897Y-27ZNX-NV0TD
	YZ718-4REEQ-08DHQ-JNYQC-ZQRD0
	GZ3N0-6CX0L-H80UP-FPM59-NKAD4
	YY31H-6EYEJ-480VZ-VXXZC-QF2E0
	ZG51K-25FE1-H81ZP-95XGT-WV2C0
	VG30H-2AX11-H88FQ-CQXGZ-M6AY4

	#include <bits/stdc++.h>
	using namespace std;

	struct node {
	int data{};
	node* left = nullptr;
	node* right = nullptr;
	node* parent = nullptr;
	string color;
	};

	-- Accepted answer from here: https://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it
	SELECT pg_terminate_backend(pg_stat_activity.pid)
	FROM pg_stat_activity
	WHERE pg_stat_activity.datname = '[your database name goes here]'
	AND pid <> pg_backend_pid();