m4tlch

Trello CSS Guide

“I perfectly understand our CSS. I never have any issues with cascading rules. I never have to use !important or inline styles. Even though somebody else wrote this bit of CSS, I know exactly how it works and how to extend it. Fixes are easy! I have a hard time breaking our CSS. I know exactly where to put new CSS. We use all of our CSS and it’s pretty small overall. When I delete a template, I know the exact corresponding CSS file and I can delete it all at once. Nothing gets left behind.”

You often hear updog saying stuff like this. Who’s updog? Not much, who is up with you?

This is where any fun you might have been having ends. Now it’s time to get serious and talk about rules.

Writing CSS is hard. Even if you know all the intricacies of position and float and overflow and z-index, it’s easy to end up with spaghetti code where you need inline styles, !important rules, unused cruft, and general confusion. This guide provides some architecture for writing CSS so it stays clean and ma

m4tlch

UPDATE wp_options SET option_value = replace(option_value, 'http://wp', 'http://pushkarev-adv.ru') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://wp','http://pushkarev-adv.ru');
UPDATE wp_posts SET post_content = replace(post_content, 'http://wp', 'http://pushkarev-adv.ru');

m4tlch

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

m4tlch

@echo off
SET st2Path=C:\Program Files\Sublime Text 2\sublime_text.exe

rem add it for all file types
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 2"         /t REG_SZ /v "" /d "Open with Sublime Text 2"   /f
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 2"         /t REG_EXPAND_SZ /v "Icon" /d "%st2Path%,0" /f
@reg add "HKEY_CLASSES_ROOT\*\shell\Open with Sublime Text 2\command" /t REG_SZ /v "" /d "%st2Path% \"%%1\"" /f

rem add it for folders
@reg add "HKEY_CLASSES_ROOT\Folder\shell\Open with Sublime Text 2"         /t REG_SZ /v "" /d "Open with Sublime Text 2"   /f

m4tlch

<?php

function my_module_product_add($pid,$quantity=1){

    if ($product = commerce_product_load($pid) ) {
            global $user;
            //uid of the logged in user
            $uid = $user->uid;
            $line_item = commerce_product_line_item_new($product, $quantity);
            $line_item->field_ticket_type['und'][]['value'] = 0;

m4tlch

#!/usr/bin/env sh

# Download lists, unpack and filter, write to stdout
curl -s https://www.iblocklist.com/lists.php \
  | sed -n "s/.*value='\(http:.*=bt_.*\)'.*/\1/p" \
  | xargs wget -O - \
  | gunzip \
  | egrep -v '^#'

m4tlch

# Redirect to HTTPS
RewriteCond %{HTTPS} off 
RewriteCond %{HTTP:X-Forwarded-Proto} !https 
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

m4tlch

# KILL THEM ETAGS
# http://www.askapache.com/htaccess/apache-speed-etags.html
FileETag none

# set expires header
<FilesMatch "\.(ico|jpg|jpeg|png|gif|js|css|swf|woff|eot|svg|ttf)$">
   Header set Expires "Tue, 16 Jun 2020 20:00:00 GMT"
</FilesMatch>

# turn on gzip compression

m4tlch

DELETE locales_source FROM locales_source left join locales_target lt using (lid) where lt.lid is null;

m4tlch

Deleted Field Tables keep multiplying

When you delete a field, if there is data in it, Drupal does a bit of a two-step shuffle to avoid locking the tables while it gets rid of them, so it moves them to other tables so it can go through them one at a time when cron runs.

Sometimes this process does not clean itself up. You will notice It by seeing the number of tables in your DB grow and the DB will contain lots of
tables like this
field_deleted_data_103
field_deleted_data_105
field_deleted_data_109