Skip to content

Instantly share code, notes, and snippets.

View logical-and's full-sized avatar

And logical-and

  • Ukraine, Lviv (Lemberg)
View GitHub Profile
CREATE TEMPORARY TABLE sessions_calculation(
wnum INT(11) NOT NULL,
work_date DATE NOT NULL,
worked_hours TIME DEFAULT 0,
INDEX (wnum, work_date)
);
# Same day
INSERT INTO sessions_calculation (wnum, work_date, worked_hours)
SELECT wnum
@logical-and
logical-and / 2nd task.html
Last active December 19, 2015 11:29
2nd task
<!doctype html>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<script src="//ajax.googleapis.com/ajax/libs/mootools/1.4.5/mootools-yui-compressed.js"></script>
</head>
<body>
<script type="text/javascript">
console.log((function (servers, neededServers, neededClusters, performanceDegradation) {
var defaultServerStringSeparator = "\n",
<?php
class InvoiceManagerSubscriberTest extends KernelTestCase {
public function testGetInvoiceForAccountLogic()
{
$userRepository = $this->getUserRepository();
$user = (new User())->addQualification(1);
$userSys = $userRepository->findSysUser();
@logical-and
logical-and / AbstractWidget.js
Created December 11, 2014 14:37
Sermik code examples
define([
'jsclass/class',
'./WidgetService',
'app/common/layout/manager',
'app/common/layout/model',
'app/common/datatable/component.datatable',
'Shared/Base/ConfigureGrid',
'Shared/Filter/filter',
'Shared/Filter/PageFilterSortInfo',
'Shared/Base/LoadMask',
@logical-and
logical-and / gist:6c9b5a172026ffdbebdf
Created January 17, 2015 16:50
virtualmin-apache-and-nginx-reverse-proxy.html commentary
Nextgen version :)
##
# Template
##
server {
listen {SITE_IP}:80;
server_name {SITE_DOMAIN} www.{SITE_DOMAIN};
layout title description tags
default
SQL Style Guide
A guide to writing clean, clear, and consistent SQL.
data
process

Purpose

@logical-and
logical-and / README.md
Last active October 22, 2023 13:02 — forked from pcworld/_README.md
Linux Spotify Ad Mute

We all love Spotify, but sometimes people (like us) want to throw a party without having to listen to interrupting ads before having bought Spotify Premium. Well, with this killer project, now you can!

This is for testing purposes ONLY! Spotify is a fantastic service and worth every penny. This script is NOT meant to circumvent buying premium! Please do consider switching to premium to support Spotify - especially if you're going to use it on mobile. If the script does not work for you, help us improve it!

Usage

wget -O spotify-mute-ads.sh https://gist.githubusercontent.com/logical-and/825bab160d604d82bf6ad9ebd3a6410d/raw/84f77518f6fa8980e73fcf1fadd30d223f2100a1/spotify-mute-ads.sh
chmod ug+x spotify-mute-ads.sh
./spotify-mute-ads.sh