Abdul Al-Hasany abdul-alhasany

Google / YouTube Authentication using a Brand Account

Below describes the only way I was able to get (programmatic) access to the YouTube Analytics API on behalf of our Brand Account. Google documentation is convoluted, to say the least, so if you know a more straightforward way, please do share.

Getting a Client ID and Refresh Token

Create a Project in the Developers Console - https://console.developers.google.com/
Go to the Library tab and enable desired APIs (e.g. YouTube Analytics)
Go to OAuth consent screen and make project external. Select Test mode

Export

Creates a .bacpac file from live database.

"C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" /a:Export /scs:"Data Source=SERVER;Initial Catalog=db_name;Integrated Security=False;Persist Security Info=False;User ID=db_user;Password=db_password" /tf:"D:\backup\database_backup.bacpac"

Import

Import from .bacpac file to database.

	<?php

	namespace App\Casts;

	use Illuminate\Support\Facades\DB;
	use Illuminate\Contracts\Database\Eloquent\CastsAttributes;

	// todo: make it even better by implementing a Point class and working with that

	class Point implements CastsAttributes

	/*
	--------------------------------------------------------------------------------------
	Stored Procedures are late-binding, so they will build even with references to non-existant objects, and will fail at runtime
	This script attempts to find any missing references in a database, and can be run as a post deployment script in SSDT to
	verify there are no unvalid references after a database has been deployed.
	--------------------------------------------------------------------------------------
	*/

	DECLARE @ResultStr varchar(max)
	DECLARE @ResultTable TABLE

	<?php
	/**
	* The Template for displaying product archives, including the main shop page which is a post type archive
	*
	* This template can be overridden by copying it to yourtheme/woocommerce/archive-product.php.
	*
	* HOWEVER, on occasion WooCommerce will need to update template files and you
	* (the theme developer) will need to copy the new files to your theme to
	* maintain compatibility. We try to do this as little as possible, but it does
	* happen. When this occurs the version of the template file will be bumped and

	<?php
	namespace JensSogaard;

	class BlockHelper
	{
	/**
	* Gets ACF fields for a specific block on a given post
	* @author Jens Soegaard <[email protected]>
	*/
	public function getBlockFromPage(string $block_id, int $post_id)

	# PHP
	# Test and package your PHP project.
	# Add steps that run tests, save build artifacts, deploy, and more:
	# https://docs.microsoft.com/azure/devops/pipelines/languages/php

	pool:
	vmImage: 'Ubuntu 16.04'

	variables:
	phpVersion: 7.2

	# This file is for unifying the coding style for different editors and IDEs
	# editorconfig.org

	# WordPress Coding Standards
	# http://make.wordpress.org/core/handbook/coding-standards/

	root = true

	[*]
	charset = utf-8

	Eliminate All Blocks from Editor
	wp.data.dispatch( 'core/block-editor' ).resetBlocks([]);

	How to disable and lock Gutenberg blocks
	https://kinsta.com/blog/disable-gutenberg-blocks/

	Convert group of file blocks to ACF block
	https://bdwm.be/gutenberg-case-study-convert-group-of-file-blocks-to-acf-block/

	Enabling Gutenberg-Based Custom Post Types and Taxonomies

	'use strict';

	const crypto = require('crypto');

	const AES_METHOD = 'aes-256-cbc';
	const IV_LENGTH = 16; // For AES, this is always 16, checked with php

	const password = 'lbwyBzfgzUIvXZFShJuikaWvLJhIVq36'; // Must be 256 bytes (32 characters)

	function encrypt(text, password) {