Khoa Võ khoazero123

Install SQL Server Express

Download SQL Server Express 2019: https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Choose CUSTOM install
Choose media download target location, leave it default.
On SQL Server Installation Center choose "New SQL Server stand-alone installation..." menu.
On Feature Selection at least select the main "Database Engine Services" option (SQL Server Replication, Machine Learning stuff, Full-Text search are optional). Also make sure all "Client Tools..." options and "SQL Client Connectivity SDK" are selected.
On Instance Configuration we set the SQL Server instance name, we can leave all options default (SQLEXPRESS).
On Server Configuration, we can set the "Startup Type" for "SQL Server Database Engine" to manual. So in order to use the SQL Server, we have to start it manualy through the Sql Server Configuration Manager application.
On Database Engine Configuration set the "Authentication Mode" to Mixed Mode.

	RUN apt update
	RUN apt upgrade -y
	RUN apt install -y apt-utils
	RUN a2enmod rewrite
	RUN apt install -y libmcrypt-dev
	RUN docker-php-ext-install mcrypt
	RUN apt install -y libicu-dev
	RUN docker-php-ext-install -j$(nproc) intl
	RUN apt-get install -y libfreetype6-dev libjpeg62-turbo-dev libpng12-dev
	RUN docker-php-ext-configure gd --with-freetype-dir=/usr/include/ --with-jpeg-dir=/usr/include/

	function isLeapYear(year) {
	let yearInEra;
	let [_, firstLetter, numOfYear] = /(\w)(\d+)/.exec(year);
	numOfYear = parseInt(numOfYear) - 1;
	switch (firstLetter) {
	case 'M':
	yearInEra = 1868 + numOfYear;
	break;
	case 'T':
	yearInEra = 1912 + numOfYear;

	function count_groups(friend_pairs) {
	let [numFriendPair, numElementsOfElment, ...numOfArray] = friend_pairs.split("\n");
	let formatedArr = [];
	for (let i = 0; i < numOfArray.length; i++) {
	const [idA, idB] = numOfArray[i].trim().split(' ');
	formatedArr.push([idA, idB]);
	}
	let newArr = [[...formatedArr[0]]];
	for (let i = 1; i < formatedArr.length; i++) {
	const [idA, idB] = formatedArr[i];

	#!/usr/bin/env node

	var args = process.argv.slice(2);
	var input = args[0];

	var isTTY = process.stdin.isTTY;
	var stdin = process.stdin;
	var stdout = process.stdout;

	// If no STDIN and no arguments, display usage message

	'use strict';

	const crypto = require('crypto');

	const ENCRYPTION_KEY = process.env.ENCRYPTION_KEY; // Must be 256 bits (32 characters)
	const IV_LENGTH = 16; // For AES, this is always 16

	function encrypt(text) {
	let iv = crypto.randomBytes(IV_LENGTH);
	let cipher = crypto.createCipheriv('aes-256-cbc', Buffer.from(ENCRYPTION_KEY), iv);

	#!/bin/bash

	# Install dependencies
	# older ubuntus
	#apt-get install build-essential libsqlite3-dev ruby1.9.1-dev
	# xenial
	apt install build-essential libsqlite3-dev ruby-dev

	# Install the gem
	gem install mailcatcher --no-ri --no-rdoc