Skip to content

Instantly share code, notes, and snippets.

View liligga's full-sized avatar

Igor liligga

19 followers · 8 following
  • Novosibirsk
View GitHub Profile
@liligga
liligga / dcc_final_dataset_estimate.ipynb
Created August 16, 2021 07:30 — forked from pierrelouisbescond/dcc_final_dataset_estimate.ipynb
Data-Centric Competition - Final DataSet Estimate
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@liligga
liligga / wp_pages.html
Created July 3, 2019 02:31
<!-- about us -->
<section style="display:flex;justify-content:center;flex-wrap:wrap;margin-top:30px">
<div style="display:flex;align-items:center">
<div class="icon" style="margin:7px;width:252px;">
<img src="https://img.icons8.com/ios-glyphs/90/000000/batman-new.png">
</div>
<div class="description">
<h2>Quality Materials</h2>
<p>A good product that is looked after is likely to have an extended life, which means we don't need to make as many of them. As proof of our commitment to making long-lasting products, our axes come with a 20 year guarantee.</p>
@liligga
liligga / calculator.html
Last active June 28, 2019 01:32
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<style>
button{
min-width: 45px;
/*background-color: #FFCC66;*/
}
@liligga
liligga / carousel.html
Last active June 22, 2019 05:22
@liligga
liligga / lesson2_3_4.js
Last active June 21, 2019 04:06
// Variables - переменные
// var lol;
// lol = "мое настоящее имя";
// alert(lol);
// var name2, $, _, _name, myName; // a-z, A-Z, 0-9, $, _
// Variables - Let
// let name="igor", age=31;
// let name="zahar"; //error, cannot define twice
@liligga
liligga / SublimeText-Project-Line-Count
Created April 17, 2019 15:06 — forked from halcarleton/SublimeText-Project-Line-Count
Count total lines of code in a Sublime Text Project or Directory
Go to menu:
Find -> Find in Files... (windows: ctrl+shift+f)
Switch on reg_ex button (windows: alt+r)
Find:
^.*\S+.*$
Where:
c:\your_folder\,*.php,*.js,*.inc,*.html,*.htm,*.scss, -*/folder_to_exclude/*, -*.min.js
@liligga
liligga / nokogiri cygwin
Created April 2, 2019 07:55 — forked from ianmariano/nokogiri cygwin
nokogiri cygwin
Make sure libxml2-devel, libxslt-devel and libiconv-devel are installed:
$ gem install nokogiri -- --use-system-libraries --with-xml2-include=/usr/include/libxml2 --with-xml2-lib=/usr/lib --with-xslt-dir=/usr/include/libxslt --with-iconv-include=/usr/include --with-iconv-lib=/usr/lib
@liligga
liligga / ruby-2.3.0-cygwin-x64.md
Created March 5, 2019 01:02 — forked from aspyatkin/ruby-2.3.0-cygwin-x64.md
Ruby 2.3.0 on Cygwin x64

Installing Ruby 2.3.0 on Cygwin x64

Warning!

You won't get a fully-functional installation! At the time of writing, it turned out gem is kind of broken on Ruby 2.3.0. Ruby gem installation fails with an error like kernel_require.rb:54:in require': cannot load such file -- win32/resolv`.

Prerequisites

Installation

Install essential packages

@liligga
liligga / button.bas
Last active February 18, 2019 08:13
Color paayment and birthday dates when due
Public Sub test()
Dim birthDate As Range
Dim billDate As Range, today, sunday, saturday
Dim ws As Worksheet
today = Date
sunday = Date - 1
saturday = Date - 2
For Each ws In Worksheets
@liligga
liligga / query-2.sql
Last active December 14, 2018 16:28
query all products but with no duplicated additional_sizes or additional_colors columns. Empty values for those columns are excepted. Group by at the end prevents final duplications
SELECT p2.*, m2.*, GROUP_CONCAT(p2.id)
FROM wp_posts p2
INNER JOIN wp_postmeta m2 ON m2.post_id=p2.id
where p2.post_type='product' and (`meta_key`='additional_sizes' or `meta_key`='additional_colors')
GROUP BY case when m2.meta_value=''
then m2.post_id
else m2.meta_value
end
order by `menu_order`
limit 10