javikalsan

SELECT AddGeometryColumn('geoms', 'the_geom', 25830, 'MULTIPOLYGON', 2 );

Trigger sup. ha

      BEGIN
        IF (TG_OP = 'INSERT') THEN
          NEW.supha := area(NEW.the_geom)/10000;
        ELSIF (TG_OP = 'UPDATE') THEN
          IF NOT (NEW.the_geom ~= OLD.the_geom) THEN
            NEW.supha := area(NEW.the_geom)/10000;

javikalsan

<IfModule pagespeed_module>

    ModPagespeed on
    ModPagespeedFileCachePath /var/mod_pagespeed/cache/

    # Direct Apache to send all HTML output to the mod_pagespeed output handler.
    AddOutputFilterByType MOD_PAGESPEED_OUTPUT_FILTER text/html

    # Turn this on if /var/mod_pagespeed/cache/ is on a ext3 filesystem.
    ModPagespeedSharedMemoryLocks on

javikalsan

<snippet>
    <content><![CDATA[/**
 * ${4:undocumented function}
 *
 * @param $7
 * @return ${5:void}
 * @author ${PHPDOC_AUTHOR:$TM_FULLNAME}$6
 *
 **/
$1function $2($3)

javikalsan

ps aux | cut -d " " -f1 | sort | uniq | grep -v USER

javikalsan

psql -U postgres -W -d database_name -f my_dump_file.sql -h localhost

javikalsan

#!/bin/sh
# replace cmd1 for the command to execute

host=192.168.1.1
port=23
user=myuser
pass=mypass
cmd1='ifconfig wl0 down'

( echo open ${host}

javikalsan

git config --global alias.st "status -s"
git config --global alias.puom "push -u origin master"
git config --global alias.lol "log --all --graph --decorate"
git config --global alias.com "checkout master"
git config --global alias.cod "checkout dev"
git config --global alias.b "branch"

javikalsan

egrep 'wp_version =' `find . -name version.php`

javikalsan

{
  "color_scheme": "Packages/Color Scheme - Default/Blackboard.tmTheme",
  "font_size": 12,
  "translate_tabs_to_spaces": true,
  "tab_size": 2,
  "scroll_speed": 2.0,
  "folder_exclude_patterns": [".svn", ".git", "._d", ".metadata", ".settings"],
  "file_exclude_patterns": ["*.pyc", "*.pyo", ".project", "*.jpg", "*.png", "*.gif"],
  "detect_indentation": true,
  "detect_slow_plugins": false,

javikalsan

DocBlockr
HTML/CSS/JS Prettify
Brack­etHigh­lighter
SublimeLinter
PHPUnit Completions
ColorHighlighter
SublimeCodeIntel
Emmet
Colorsublime
SidebarEnhancements