Skip to content

Instantly share code, notes, and snippets.

@laacz
laacz / dns-izmainu-pieprasijums.md
Created May 24, 2011 18:06
DNS izmaiņu pieteikums migrācijai uz Google Apps.

Lūdzu nomainīt domeina {kantorīc.lv} esošos MX DNS ierakstus uz sekojošiem:

IN      MX      1     ASPMX.L.GOOGLE.COM.
IN      MX      5     ALT1.ASPMX.L.GOOGLE.COM.
IN      MX      5     ALT2.ASPMX.L.GOOGLE.COM.
IN      MX      10    ASPMX2.GOOGLEMAIL.COM.
IN      MX      10    ASPMX3.GOOGLEMAIL.COM.
@laacz
laacz / html5_template.html
Created August 1, 2011 17:27
Minimal HTML5 Template (indented)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
<!--[if IE]>
<script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
@laacz
laacz / harikiri.php
Created August 23, 2011 18:55
Jāmet pie malas...
<?php
$worker= new GearmanWorker();
$worker->addServer('gms');
/* .. whiskas .. */
$worker->addFunction("die", "harikiri");
function harikiri($bushido = false) {
@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 / func.php
Created October 31, 2011 17:58
Legacy FTW
<?
$NOW=date("U");
$TODAY = mktime(0, 0, 0, date("m") , date("d"), date("Y"));
$TOMORROW = mktime(0, 0, 0, date("m") , date("d")+1, date("Y"));
$DFORMAT="d.m.Y.";
$DTFORMAT="d.m.Y. H:i:s";
$lvdayL=array("","pirmdiena","otrdiena","trešdiena","ceturtdiena","piektdiena","sestdiena","svetdiena");
$lvday=array("","Pirmdiena","Otrdiena","Trešdiena","Ceturtdiena","Piektdiena","Sestdiena","Svetdiena");
@laacz
laacz / lks-92.php
Last active March 2, 2021 11:20
LKS-92 koordināšu pārrēķins uz platuma un garuma grādiem.
<?php
// Ja šis nedod korektu rezultātu Y asī, atkomentē rindiņu, kur ir "$y -= -6000000.0;"
function LKSToLatLon($x, $y)
{
/* Ellipsoid model constants (actual values here are for WGS84) */
$UTMScaleFactor = 0.9996;
$sm_a = 6378137.0;
$sm_b = 6356752.314;
@laacz
laacz / nearest-road.sql
Created May 19, 2012 08:19
PostGIS: Find nearest roads (represented by linestring) to a given point
/*
* Road data comes from OpenStreetmap (http://download.geofabrik.de/osm/)
**/
select st_distance(st_closestpoint(r.the_geog::geometry, wa.location::geometry), wa.location::geometry) as cp
, r.name
, r.ref
, r.ogc_fid
, r.type
, st_astext(wa.location)
, wa.*
@laacz
laacz / sublime-text-2-setup.md
Created November 20, 2012 18:34
SublimeText 2 setup

My SublimeText 2 Set-Up

I usually install TortoiseGit and msysgit, so these two are required.

Install Package Control

import urllib2,os; pf='Package Control.sublime-package'; ipp=sublime.installed_packages_path(); os.makedirs(ipp) if not os.path.exists(ipp) else None; urllib2.install_opener(urllib2.build_opener(urllib2.ProxyHandler())); open(os.path.join(ipp,pf),'wb').write(urllib2.urlopen('http://sublime.wbond.net/'+pf.replace(' ','%20')).read()); print 'Please restart SublimeText to finish installation'
if [ ! -f $fname ]
then
curl -s http://dumps.wikimedia.org/other/pagecounts-raw/$y/$ym/$fname.gz | zgrep -a "^lv" >$fname
fi
@laacz
laacz / gist:4427065
Last active December 10, 2015 11:19
Ivara Svilāna jaungada uzruna katram.

Oriģināls ir pie autora - Ivara Svilāna feisbukā.

Apsēdos un uzrakstīju pats: kādu es gribētu politiķu Jaungada oficiālo uzrunu

Daudzus gadus esmu klausījies valstsvīru svētku uzrunas. Un domājis: „Nu, kādēļ viņi tā?!” Kādēļ tik reti aizrauj tas, ko man saka svētku reizē? Kad gribas kopības sajūtu, iedvesmu un cerību, ka esam labākie. Vai vismaz labāki.

Tad nu šogad brieda doma un beidzot esmu uzrakstījis savu variantu, ko es gribētu, lai man Jaungada uzrunā pasaka kāds valstsvīrs vai valstssieva.

(ok, lai skaidrs - uzreiz teikšu: politisku ambīciju man nav, partijās neesmu, vēlēšanās nestartēju un neplānoju.:) )