Vitalii Voskobovich voskobovich

## gist:537b2000108e4781f70b
DROP TABLE currency;

-- Create table variable
CREATE TABLE currency (
  name   VARCHAR(20),
  code   VARCHAR(3),
  symbol VARCHAR(5)
);

ALTER TABLE currency CONVERT TO CHARACTER SET utf8;

## gist:58a1e0ac9ca44b891f31a0b4433be49b
1. Open document
2. Crtl + R
3. Checked Regexp
4. Find \$(.+)(\w)_(\w)
5. Replace to \$$1$2\u$3
6. Unchecked Regexp
7. Profit!

## gist:43f851859c23a8261514
DROP TABLE currency;

-- Create table variable
CREATE TABLE currency (
  country  VARCHAR(100),
  currency VARCHAR(100),
  code     VARCHAR(100),
  symbol   VARCHAR(100)
);

## gist:d746899b1488beee69505193dfcc1d46
server {
    listen 80;
    server_name www.hostname.com;
    rewrite ^(.+)$ http://hostname.com permanent;
}

server {
    charset utf-8;
    client_max_body_size 128M;

## gist:15ad5fc71e957bbe87d45cd88295f5b8
    /**
     * @param $url
     */
    public function actionStreamVideoFromCdn($url)
    {
        $headersCollection = Yii::$app->request->getHeaders();
        $responseHeaders = [];

        $chInfo = curl_init();
        curl_setopt($chInfo, CURLOPT_URL, $url);

## ignition.json
{"ignition":{"config":{},"timeouts":{},"version":"2.1.0"},"networkd":{},"passwd":{"users":[{"name":"core","sshAuthorizedKeys":["ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDF/SQhH7qOjqeF+OuS2iGEsBnpFjkc+031vdM6UU4lUwYXkLr0tUqmB3LcPiAax55e56ELuJO1wlAI7SMvZZ+dfGoCDv/z4GMN4pscxWd1FmzJBNBsKSGJKc/qswMbunwBC8H9dPa3YrVZXO00D9fcatA9VuyImiRai6Q87sGuKBPo4dNfMZfTZjUfglzydyJm8valewdd6gWwif2uX+N3SM0bLeuUncpF00PdBMWPljrJDBUVjYOudt8R9sXflldxcB+ggs3YlKVc+28+stFDwpT67AOOypSOcz/VMSpIciJXEGIn4ziAHiwA8rCNg+0IjF4OUEWdqqfG3DRWc1LR vitaly@MacBook-Pro-Vitaly.local"]}]},"storage":{"files":[{"filesystem":"root","group":{},"path":"/etc/coreos/update.conf","user":{},"contents":{"source":"data:,GROUP%3Dstable%0ASERVER%3Dhttps%3A%2F%2Fpublic.update.core-os.net%2Fv1%2Fupdate%2F","verification":{}},"mode":420}]},"systemd":{"units":[{"dropins":[{"contents":"[Service]\nEnvironment=\"ETCD_IMAGE_TAG=v3.2.18\"\nExecStart=\nExecStart=/usr/lib/coreos/etcd-wrapper $ETCD_OPTS \\\n  --discovery=\"https://discovery.etcd.io/2d3d6e80944b0e219036dd8b34aef889\"

## gist:611e82306bab9e4223f53147456d32fc
<?php

/**
 * To run the code, use the following link:
 * @link http://sandbox.onlinephpfunctions.com/code/c0c3b9e0f3df2aa3f1251594dc09282e5aabf5fc
 *
 * Please do not use this in PRODUCTION systems!
 */

/**

## gist:3072697f9cf6c7c4a2242140a8a0ff5e
class User extends ActiveRecord
{
    /**
     * @var StatusEnum
     */
    private $_statusEnum;

    /**
     * BaseUser constructor.
     * @param StatusEnum $statusEnum

## gist:b65e46a4510955feb3500fa5d29879d7
/**
 * Class BaseEnum.
 */
abstract class BaseEnum
{
    /**
     * Get All Labels
     * @return array
     */
    public static function getLabels(): array

## gist:7df1c603d9a0dacfc22930157157f6a2
class UrlManager extends \yii\web\UrlManager
{
    /**
     * @inheritdoc
     */
    public function createUrl($params)
    {
        //Получаем сформированный URL(без префикса идентификатора языка)
        $url = parent::createUrl($params);
	DROP TABLE currency;

	-- Create table variable
	CREATE TABLE currency (
	name VARCHAR(20),
	code VARCHAR(3),
	symbol VARCHAR(5)
	);

	ALTER TABLE currency CONVERT TO CHARACTER SET utf8;
	1. Open document
	2. Crtl + R
	3. Checked Regexp
	4. Find \$(.+)(\w)_(\w)
	5. Replace to \$$1$2\u$3
	6. Unchecked Regexp
	7. Profit!
	server {
	listen 80;
	server_name www.hostname.com;
	rewrite ^(.+)$ http://hostname.com permanent;
	}

	server {
	charset utf-8;
	client_max_body_size 128M;
	/**
	* @param $url
	*/
	public function actionStreamVideoFromCdn($url)
	{
	$headersCollection = Yii::$app->request->getHeaders();
	$responseHeaders = [];

	$chInfo = curl_init();
	curl_setopt($chInfo, CURLOPT_URL, $url);
	<?php

	/**
	* To run the code, use the following link:
	* @link http://sandbox.onlinephpfunctions.com/code/c0c3b9e0f3df2aa3f1251594dc09282e5aabf5fc
	*
	* Please do not use this in PRODUCTION systems!
	*/

	/**
	class User extends ActiveRecord
	{
	/**
	* @var StatusEnum
	*/
	private $_statusEnum;

	/**
	* BaseUser constructor.
	* @param StatusEnum $statusEnum
	/**
	* Class BaseEnum.
	*/
	abstract class BaseEnum
	{
	/**
	* Get All Labels
	* @return array
	*/
	public static function getLabels(): array
	class UrlManager extends \yii\web\UrlManager
	{
	/**
	* @inheritdoc
	*/
	public function createUrl($params)
	{
	//Получаем сформированный URL(без префикса идентификатора языка)
	$url = parent::createUrl($params);