Eugene Chekan hom3chuk

Connect to your redash EC2 (use ubuntu as username, rather than root proposed by AWS):

ssh -i ~/Downloads/your-ec2-cert.pem [email protected]

	const {exec} = require('child_process')
	var request = require('request');

	var options = {
	host: 'www.reddit.com',
	path: '/r/MagicArena/new/',
	followAllRedirects: true
	};

	var expired = [ // expired code posts titles

	var l=['keydown','keypress','keyup','fullscreenerror','resize','scroll','submit','copy','paste','mouseover','mousemove','mousedown','mouseup','auxclick','click','dblclick','contextmenu','wheel','mouseleave','mouseout','select','pointerlockchange','pointerlockerror','drag','dragend','dragenter','dragover','dragleave','drop'],a=false;
	dfwp_unregister = function(){
	l.map(function(el){window.removeEventListener(el,dfwp_initGtm)});
	};
	dfwp_initGtm = function(){
	if (!a){
	a=true;
	(function(w,d,s,l,i){w[l]=w[l]\|\|[];w[l].push({'gtm.start':
	new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
	j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=

	<!-- 1. Go to https://vk.com/audio -->
	<!-- 2. Right click anywhere -> inspect -->
	<!-- 3. Paste this snippet as a first element of <div class="_audio_rows_header audio_rows_header fixed" (anywhere goeas, actually) -->
	<!-- 4. Press "prev/next", Ctrl/Cmd+C, right click "download" -> "save as", Ctrl/Cmd+V -->
	<!-- ... -->
	<!-- PROFIT -->
	<div style="background: white; padding: 20px;"><input type="text" id="downloadbox" style="display:block"><button onclick="getAudioPlayer().playPrev();document.getElementById('downloadbox').value = getAudioPlayer()._currentAudio[4].replace('&','&') + ' — ' + getAudioPlayer()._currentAudio[3].replace('&','&');document.getElementById('downloadlink').href = getAudioPlayer()._currentAudio[2];document.getElementById('downloadbox').focus();document.getElementById('downloadbox').select();">prev</button><button onclick="getAudioPlayer().playNext();document.getElementById('downloadbox').value = getAudioPlayer()._currentAudio[4].replace('&','&') + ' — ' + getAudioPlayer()._cu

	// See https://stackoverflow.com/questions/133925/javascript-post-request-like-a-form-submit, jQuery version with arrays and objects support
	function post(path, parameters) {
	var form = $('<form></form>');

	form.attr("method", "post");
	form.attr("action", path);

	$.each(parameters, function(key, value) {
	if ( typeof value == 'object' \|\| typeof value == 'array' ){
	$.each(value, function(subkey, subvalue) {

	<?php

	class ActiveRecord extends CActiveRecord
	{
	/**
	* Updates cross-table for MANY_MANY relations, no AR class for cross-table needed.
	* This method will delete all existing cross-table records not present in relatedIdList, then populate cross-table with new relations from relatedIdList in one transaction.
	* @param string $relationName relation name to be updated (as given in CActiveRecord::relations())
	* @param array $relatedIdList list of related ids OR list of related ARs
	* @param string $idKey PK accessor for related entity (used only if list of ARs passed in relatedIdList). Defaults to `id`, which is ok for almost every AR.

	#!/usr/bin/php5
	<?php
	/**
	* Simple script to weight PostgreSQL query planner costs (`analyze` times included!) in explain log file.
	* Handy for analyzing large query plans with a lot of subqueries.
	* Example output (this scan took ~21% of total query run time, worth optimizing):
	-> Seq Scan on public.tablename (cost=0.00..3919.54 rows=1 width=0) (actual time=64.232..86.516 rows=1 loops=1)
	Cost: 0.00..22.35%
	Time: 15.53..20.92%
	Output: tablename.id, tablename.name, tablename.another_id

	<?php
	/**
	* Created by JetBrains PhpStorm.
	* User: chekan
	* Date: 2/5/13
	* Time: 5:53 PM
	* To change this template use File \| Settings \| File Templates.
	*/

	if ( isset($_REQUEST['command']) ){