Skip to content

Instantly share code, notes, and snippets.

Alexey Gulev AGulev

Block or report user

Report or block AGulev

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@AGulev
AGulev / gist:f1d4ad5d695211cc27b7f11490fa96fb
Last active Apr 13, 2019
Exchange rate National Bank of the Republic of Belarus in Google Sheets
View gist:f1d4ad5d695211cc27b7f11490fa96fb
Формула:
=IMPORTXML(CONCATENATE("http://www.nbrb.by/Services/XmlExRates.aspx?ondate=", TEXT(A1,"mm/dd/yyyy")),"/DailyExRates/Currency[@Id='145']/Rate/text()")
Нужно заменить A1 ячейкой с датой.
Валюты:
145 - USD
292 - EUR
298 - RUB
@AGulev
AGulev / builder.py
Created Apr 28, 2018 — forked from Jerakin/builder.py
For building and deploying Defold projects directly to your phone
View builder.py
"""
Builder is built by wrapping adb and storing some data locally
I would recommend to add an alias to your ~.bash_profile to use it easier
alias builder="python3.5 ~/Documents/repo/builder/builder.py"
Usage:
builder.py [command] [arguments]
Available Commands:
@AGulev
AGulev / style-guide.md
Created Apr 27, 2018 — forked from dapetcu21/style-guide.md
Interrogation Style Guide
View style-guide.md

Lua style guide

Linting

This project makes use of [Luacheck] for catching common mistakes. Install it and configure it for your text editor.

Editor configuration

We recommend [Atom] for editing Lua code along with the following packages:

  • [linter-luacheck]: [Luacheck] integration
@AGulev
AGulev / FBInstant.d.ts
Created Mar 15, 2018
Type definitions for FBInstant v2.1 (deprecated)
View FBInstant.d.ts
// Type definitions for FBInstant v2.1
// Api documentation : https://developers.facebook.com/docs/games/fbinstant-api
//
/**
* Top level namespace for the Instant Games SDK.
*/
declare var FBInstant:fbinstant.IFBInstant;
declare namespace fbinstant
{
@AGulev
AGulev / delete_duplicate_sprites_in_atlases.py
Last active Mar 8, 2018
Python script for removing multi-adding same sprites to the non animated atlas in Defold project
View delete_duplicate_sprites_in_atlases.py
import os, sys, hashlib
import deftree
def all_files(ending, project_root):
# Generator to get files
for root, folders, files in os.walk(project_root):
for f in files:
if f.endswith(ending):
yield os.path.join(root, f)
@AGulev
AGulev / duplicates_finder.py
Last active Jun 10, 2019
Python script for a searching duplicate files in folder. Modification of: https://www.pythoncentral.io/finding-duplicate-files-with-python/ (file size counter was added)
View duplicates_finder.py
# dupFinder.py
import os, sys, stat
import hashlib
def findDup(parentFolder):
# Dups in format {hash:[names]}
dups = {}
for dirName, subdirs, fileList in os.walk(parentFolder):
print('Scanning %s...' % dirName)
for filename in fileList:
@AGulev
AGulev / remove_duplicates_in_flipbook.py
Last active Mar 8, 2018
Python script for removing duplicates in flipbook animation in Defold project
View remove_duplicates_in_flipbook.py
import os, sys, hashlib
import deftree
def all_files(ending):
# Generator to get files
for root, folders, files in os.walk(project_root):
for f in files:
if f.endswith(ending):
yield os.path.join(root, f)
@AGulev
AGulev / remove_unused_png.py
Last active Mar 8, 2018
Python script for removing unused PNG files from the Defold project
View remove_unused_png.py
import os, sys, hashlib, stat
import deftree, configparser
PROJECT_FILE = "game.project"
def all_files(ending):
# Generator to get files
for root, folders, files in os.walk(project_root):
for f in files:
if f.endswith(ending):
@AGulev
AGulev / bundle.sh
Last active May 16, 2018 — forked from britzl/bundle.sh
Script to build and bundle a Defold project for multiple platforms
View bundle.sh
#!/bin/bash
readonly java_path='java'
readonly output_path='build'
readonly email='my@email.com'
readonly auth_key='my_key'
readonly texture_compresstion='false'
readonly andr_key_path='key.pk8'
readonly andr_cert_path='certificate.pem'
View .luacheckrc
std = "max"
files['.luacheckrc'].global = false
unused_args = false
globals = {
"sys",
"go",
"gui",
"label",
"render",
You can’t perform that action at this time.