Skip to content

Instantly share code, notes, and snippets.

@busha98
busha98 / funnels.md
Last active May 30, 2019 10:59
mixpanel

Funnels needed

  • name "31", creator "George C."
  • name "[All] First open to Push Accepted", creator "Anton S."
  • name "[All] First open to Trial started funnel", creator "Anton S."
  • name "[All] First Open to Tutorial completion", creator "Anton S."
  • name "[All] Trial started to Cancel", creator "Anton S."
  • name "[NonOrganic] First Open to Trial", creator "Anton S."
  • name "[Organic] First open to Trial started", creator "Anton S."
  • name "[organic] Trial started to trial converted", creator "George C."
```sql
select publishingHouse.title, count(publishingHouse.title)
from publishingHouse JOIN book ON publishingHouse.id=book.publishingHouse_id
group by publishingHouse.title
having count(publishingHouse.title) = (select max(publishingHouse.num) as max_count
from (select publishingHouse.title, count(publishingHouse.title) as num
from publishingHouse JOIN book ON publishingHouse.id=book.publishingHouse_id
group by publishingHouse.id
)
publishingHouse
@busha98
busha98 / Qwerty
Created November 15, 2018 21:53
Qwerty
Добрая тетя
Пропустил лекцию, надо нагнать
КР (Го в пт в 14:30.)
Список вопросов для проверки
1. Редакции Windows Server 2016
Известны следующие редакции Windows Server 2016:
@busha98
busha98 / l3_1_2
Created November 14, 2018 19:44
sql
l3_1_2
1) необходимо приложение гугл
client_id
client_secret
2) необходимо создать
access_token
refresh_token
это можно сделать с помощью
https://developers.google.com/oauthplayground/?hl=ru#step1&scopes=https%3A//www.googleapis.com/auth/adwords&url=https%3A//&content_type=application/json&http_method=GET&useDefaultOauthCred=checked&oauthEndpointSelect=Google&oauthAuthEndpointValue=https%3A//accounts.google.com/o/oauth2/auth&oauthTokenEndpointValue=https%3A//www.googleapis.com/oauth2/v3/token&includeCredentials=unchecked&accessTokenType=bearer&autoRefreshToken=unchecked&accessType=offline&forceAprovalPrompt=checked&response_type=code
@busha98
busha98 / nginx.conf
Created July 19, 2018 12:19 — forked from plentz/nginx.conf
Best nginx configuration for improved security(and performance). Complete blog post here http://tautt.com/best-nginx-configuration-for-security/
# to generate your dhparam.pem file, run in the terminal
openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048
@busha98
busha98 / app.js
Created July 13, 2018 13:25 — forked from kkkrist/app.js
Rate limiting for FeathersJS HTTP (REST API) and Web Sockets connections (Express, Node.js)
'use strict'
const bodyParser = require('body-parser')
const compress = require('compression')
const configuration = require('feathers-configuration')
const cors = require('cors')
const favicon = require('serve-favicon')
const feathers = require('feathers')
const hooks = require('feathers-hooks')
const limiter = require('limiter').RateLimiter // Generic limiter used for authentication attempts inside web socket connection
campaigns model
add
frequencyType ENUM ('visit', 'programme', 'break')
removed
deliveryType
user model
add
companyBillingContactEmail STRING
@busha98
busha98 / 7
Last active May 27, 2018 19:19
umd
\documentclass{article}
\usepackage{amsmath}
\usepackage[utf8]{inputenc}
\usepackage[russian]{babel}
\usepackage[normalem]{ulem}
\usepackage[right=3cm,top=2cm,bottom=2cm,bindingoffset=0cm]{geometry}
\usepackage{listings}
\usepackage{color}
//trying to encrypt test string
__int64 xTest = 0xFF40EAD2;
__int64 yTest = 0x4D9E6788;
//key : "22F98814 51BADEBC DD8AF7A7 1E3504A4";
__int64 keyTest[] = {
0x22F98814,
0x51BADEBC,
0xDD8AF7A7,
0x1E3504A4