Skip to content

Instantly share code, notes, and snippets.

View Dehax's full-sized avatar

Denis Kubashevskiy Dehax

View GitHub Profile
@Dehax
Dehax / keybase.md
Created November 11, 2021 16:30
GitHub identity proof for Keybase

Keybase proof

I hereby claim:

  • I am dehax on github.
  • I am dehax (https://keybase.io/dehax) on keybase.
  • I have a public key ASDfwsV9sZW2HJDTobK1HXBC7bQK_3xn2bQ71P1Y7vfqWQo

To claim this, I am signing this object:

@Dehax
Dehax / queries.sql
Created October 30, 2017 08:36
Kidlespay database (Delphi/Firebird)
SELECT d.id_district, SUM(kmv.cost) FROM kindergartens k
INNER JOIN districts d ON d.id_district = k.district_id
INNER JOIN kindergartens_money_view kmv ON kmv.id_kindergarten = k.id_kindergarten
GROUP BY d.id_district;
/* итоговый запрос с условием на данные */
/* Посчитать по каждому детскому саду количество детей в выбранной группе. */
SELECT kindergartens.id_kindergarten, kindergartens.kindergarten_name, COUNT(*) FROM kindergartens
INNER JOIN children ON kindergartens.id_kindergarten = children.kindergarten_id
WHERE children.group_id = 1
@Dehax
Dehax / ApplicationFolderPath.cs
Last active April 27, 2017 08:16
Returns path to the application folder in %LOCALAPPDATA%
private static string _localAppFolderPath = null;
/// <summary>
/// Путь к папке программы в локальной папке пользователя.
/// </summary>
public static string ApplicationFolderPath
{
get
{
if (_localAppFolderPath != null)
{
@Dehax
Dehax / Engine.ini
Created February 20, 2017 12:16
UE4 — ultra low graphics
[SystemSettings]
r.DefaultFeature.Bloom=False
r.DefaultFeature.AutoExposure=False
r.DefaultFeature.MotionBlur=False
r.DefaultFeature.LensFlare=False
r.EarlyZPass=0
r.SSAOSmartBlur=0
r.AmbientOcclusionLevels=0
r.BloomQuality=0
r.DepthOfFieldQuality=0
@Dehax
Dehax / smst.js
Created February 4, 2017 09:29
Steam Market Sales Total at https://steamcommunity.com/market/
var xhr = new XMLHttpRequest();
xhr.open('GET', 'https://steamcommunity.com/market/myhistory/render/?query=&start=0&count=1', false);
xhr.send();
if (xhr.status != 200) {
alert(xhr.status + ': ' + xhr.statusText);
throw new Error();
}
var totalCount = JSON.parse(xhr.responseText)['total_count'];
xhr.open('GET', 'https://steamcommunity.com/market/myhistory/render/?query=&start=0&count=' + totalCount, false);
xhr.send();
@Dehax
Dehax / smtc.js
Created February 3, 2017 22:32
Steam Market Total Counter at https://steamcommunity.com/market/
var sum = 0.0;
document.querySelectorAll('.market_home_listing_table:first-child .market_recent_listing_row .market_listing_my_price .market_table_value .market_listing_price span span:last-child').forEach(function (item, i, arr) {
sum += parseFloat(item.innerText.slice(1).replace(/,/, '.'));
});
alert(sum);
package com.javatarts.basketballgm.data;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;