Skip to content

Instantly share code, notes, and snippets.

View code-of-kpp's full-sized avatar

Konstantin code-of-kpp

46 followers · 31 following
  • Prague
View GitHub Profile
@code-of-kpp
code-of-kpp / gmail_full.csv
Created September 10, 2014 17:21
Leaked gmail passwords w/o login sorted by popularity
We can't make this file beautiful and searchable because it's too large.
passw count
123456 47817
password 11548
123456789 11133
12345 8088
qwerty 5915
12345678 5248
111111 3514
abc123 3011
123123 2971
@code-of-kpp
code-of-kpp / gmail_1.csv
Last active April 4, 2024 16:14
Leaked gmail passwords w/o logins sorted by popularity (at least 11 occurrences)
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
passw count
123456 47817
password 11548
123456789 11133
12345 8088
qwerty 5915
12345678 5248
111111 3514
abc123 3011
123123 2971
@code-of-kpp
code-of-kpp / users.csv
Created September 16, 2014 16:12
top twitter users 14.09.2014, Russia
We can't make this file beautiful and searchable because it's too large.
"user__screen_name" "user__created_at" "user__default_profile" "user__default_profile_image" "user__description" "user__favourites_count" "user__followers_count" "user__friends_count" "user__geo_enabled" "user__id" "user__is_translator" "user__lang" "user__listed_count" "user__location" "user__name" "user__profile_background_color" "user__profile_background_image_url" "user__profile_background_image_url_https" "user__profile_background_tile" "user__profile_banner_url" "user__profile_image_url" "user__profile_image_url_https" "user__profile_link_color" "user__profile_sidebar_border_color" "user__profile_sidebar_fill_color" "user__profile_text_color" "user__profile_use_background_image" "user__statuses_count" "user__time_zone" "user__url" "user__utc_offset" "user__verified" "monitored_statuses_count" "source_name" "top_words"
"nat12751" "2014-06-04 09:23:59" "True" "False" "" "29" "176" "1004" "True" "2545624686" "False" "ru" "0" "город Москва " "Урываева Юлия" "C0DEED" "http://abs.twimg.com/images/themes/theme
@code-of-kpp
code-of-kpp / raw_spamers14.09.2014.json
Created September 20, 2014 01:27
Twitter spamers for 2014.09.14 (Moscow)
This file has been truncated, but you can view the full file.
[
[
"1410914432.14",
{
"contributors": null,
"truncated": false,
"text": "\u041c\u043e\u0441\u043a\u0432\u0430\u0412\u044b\u0431\u0438\u0440\u0430\u0435\u0442 http://t.co/PIDgIXrx2z",
"in_reply_to_status_id": null,
"id": 512037172300746753,
"favorite_count": 0,
@code-of-kpp
code-of-kpp / setup.ipynb
Last active September 17, 2015 09:32
PyCon Russia 2015 talk on setup.py
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@code-of-kpp
code-of-kpp / clickhouse-cmake.log
Created January 31, 2017 00:53
clickhouse-cmake 2016.01.31
-- The C compiler identification is GNU 5.4.0
-- The CXX compiler identification is GNU 5.4.0
-- Check for working C compiler: /usr/lib/ccache/bin/gcc
-- Check for working C compiler: /usr/lib/ccache/bin/gcc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- Check for working CXX compiler: /usr/lib/ccache/bin/g++
-- Check for working CXX compiler: /usr/lib/ccache/bin/g++ -- works
@code-of-kpp
code-of-kpp / fix-mmssms.db.sql
Last active May 26, 2017 02:42
Fix SMS db in Android 7 after update
BEGIN TRANSACTION;
CREATE TABLE threads_1 (_id INTEGER PRIMARY KEY AUTOINCREMENT,date INTEGER DEFAULT 0,message_count INTEGER DEFAULT 0,
recipient_ids TEXT,snippet TEXT,snippet_cs INTEGER DEFAULT 0,read INTEGER DEFAULT 1,archived INTEGER DEFAULT 0,
type INTEGER DEFAULT 0,error INTEGER DEFAULT 0,has_attachment INTEGER DEFAULT 0,attachment_info TEXT,
hack_ INTEGER DEFAULT 0,notification INTEGER DEFAULT 1);
INSERT INTO threads_1 SELECT *, 1 FROM threads;
DROP TABLE threads;
ALTER TABLE threads_1 RENAME TO threads;
DROP VIEW sms_restricted;
DROP VIEW pdu_restricted;
@code-of-kpp
code-of-kpp / openpgp.txt
Created February 12, 2018 01:22
OpenKeychain Linked Identity
This Gist confirms the Linked Identity in my OpenPGP key, and links it to this GitHub account.
Token for proof:
[Verifying my OpenPGP key: openpgp4fpr:a21a39d606faa389136344241d37b87a37726eb4]
@code-of-kpp
code-of-kpp / tasks.md
Last active February 14, 2019 17:38
Qrator - Иннпрак ФИВТ

Даты

Выбор проектов должен быть закончен сегодня, 12 февраля. Проекты длятся до середины мая. Индивидуальные оценки будут известны в конце апреля, групповые - по дедлайну.

Формат общения

Все проекты open source, их код либо уже есть либо будет на гитхабе или гитлабе в организации Qrator Labs.

Основная форма общения - это код. Если у вас есть вопрос технического характера, вы сопровождаете его сниплетом кода.

@code-of-kpp
code-of-kpp / google-search.xml
Last active June 26, 2019 00:13
Opensearch plugin for custom Google search - Always English, HTTPS, new-window, 100 results/per page
<SearchPlugin xmlns="http://www.mozilla.org/2006/browser/search/">
<ShortName>Google.com</ShortName>
<Description>Google Search English, HTTPS, new-window, 100/per page</Description>
<InputEncoding>UTF-8</InputEncoding>
<Image width="16" height="16">data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiA/PjwhRE9DVFlQRSBzdmcgIFBVQkxJQyAnLS8vVzNDLy9EVEQgU1ZHIDEuMS8vRU4nICAnaHR0cDovL3d3dy53My5vcmcvR3JhcGhpY3MvU1ZHLzEuMS9EVEQvc3ZnMTEuZHRkJz48c3ZnIGVuYWJsZS1iYWNrZ3JvdW5kPSJuZXcgMCAwIDQwMCA0MDAiIGhlaWdodD0iNDAwcHgiIGlkPSJMYXllcl8xIiB2ZXJzaW9uPSIxLjEiIHZpZXdCb3g9IjAgMCA0MDAgNDAwIiB3aWR0aD0iNDAwcHgiIHhtbDpzcGFjZT0icHJlc2VydmUiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgeG1sbnM6eGxpbms9Imh0dHA6Ly93d3cudzMub3JnLzE5OTkveGxpbmsiPjxnPjxwYXRoIGQ9Ik0xNDIuOSwyNC4yQzk3LjYsMzkuNyw1OSw3My42LDM3LjUsMTE2LjVjLTcuNSwxNC44LTEyLjksMzAuNS0xNi4yLDQ2LjhjLTguMiw0MC40LTIuNSw4My41LDE2LjEsMTIwLjMgICBjMTIuMSwyNCwyOS41LDQ1LjQsNTAuNSw2Mi4xYzE5LjksMTUuOCw0MywyNy42LDY3LjYsMzQuMWMzMSw4LjMsNjQsOC4xLDk1LjIsMWMyOC4yLTYuNSw1NC45LTIwLDc2LjItMzkuNiAg