Skip to content

Instantly share code, notes, and snippets.

@brachycera
brachycera / niceDate.php
Last active Aug 29, 2015
Convert DB timestamp to nice looking date format with many variations
View niceDate.php
<?php
/**
* Convert DB timestamp to nice looking string with many variations
*
* @param string $date - Database Timestamp
* @param int/bol $style - Date Layout, false for DD.MM.YYYY HH:MM, 1 for DD.MM.YYYY HH:MM:SS, 2 for DD.MM.YYYY, 3 for HH:MM, 4 for DD Month YYYY, 5 for Weekday, DD.MM.YYYY, 6 for MM.YYYY, 7 for WW-YYYY
* @param string $local - Default language is german
* @return string $date_nice
*
*/
@brachycera
brachycera / multipleCounting.sql
Created Sep 2, 2015
Multiple count within one query
View multipleCounting.sql
SELECT
SUM(CASE WHEN foo = '0' THEN 1 ELSE 0 END) AS bar_count,
SUM(CASE WHEN foo = '1' OR foo = '2' THEN 1 ELSE 0 END) AS baz_count
FROM
database
WHERE
baz = qux
GROUP BY baz
@brachycera
brachycera / delete_local_indexedDB.js
Last active Oct 11, 2015
Delete all local indexedDB
View delete_local_indexedDB.js
window.indexedDB.webkitGetDatabaseNames().onsuccess = function(sender,args){
var r = sender.target.result;
for(var i in r)
{
indexedDB.deleteDatabase(r[i]);
}
};
View countdown.js
/**
*
* Simple Countdown Function
* @param {num} duration - in Milliseconds
* @param {string} elemID - DOM Object ID to show the Countdown
*
*/
function countdown(duration, elemID) {
var start = Date.now( );
@brachycera
brachycera / karma.conf.js
Last active Oct 11, 2015
Karma configuration File to run with gulp-karma - This setup is for an AMD project with Angular and RequireJS. The essential part to get Karma working, was to load Angular and requireJS test.config.js files before the project files. Plugins: karma-requireJS, karma-spec-reporter, karma-jasmine, karma-phantomjs-launcher
View karma.conf.js
(function ( module ) {
'use strict';
module.exports = function( config ) {
config.set({
basePath : '../',
urlRoot: '/base/',
@brachycera
brachycera / outline.css
Created Oct 23, 2015
Remove yellow outline in Android Chrome & iOS Safari Browsers
View outline.css
html, body, div, span, applet, object, iframe,
h1, h2, h3, h4, h5, h6, p, blockquote, pre,
a, abbr, acronym, address, big, cite, code,
del, dfn, em, img, ins, kbd, q, s, samp,
small, strike, strong, sub, sup, tt, var,
b, u, i, center,
dl, dt, dd, ol, ul, li,
fieldset, form, label, legend,
table, caption, tbody, tfoot, thead, tr, th, td,
article, aside, canvas, details, embed,
@brachycera
brachycera / errors_tpl.html
Last active Dec 30, 2015
Angular 1.3.x Directive to fetch minlength Value from Input Text Field and show the Value in the ng-message for minlength Errors
View errors_tpl.html
<small class="error" ng-message="minlength" validate-minlength>Please enter at least {{requiredMinLength}} characters</small>
@brachycera
brachycera / install_gettext.sh
Created Jan 20, 2016 — forked from istepanov/install_gettext.sh
Compile and install gettext.so PHP extension for Mac OS X 10.8 Mountain Lion
View install_gettext.sh
#!/usr/bin/sh
# Scipt for installing mcrypt.so extension for PHP 5.3.13 (default PHP for OS X 10.8 Mountain Lion)
mkdir /tmp/gettext
cd /tmp/gettext
curl --location --progress-bar http://us.php.net/get/php-5.3.13.tar.gz/from/nl.php.net/mirror | tar -zx
brew update
@brachycera
brachycera / Export each as SVG.js
Created Jan 26, 2016 — forked from vieron/Export each as SVG.js
Export each as SVG. Modified some lines from the original by Aaron Beall (http://fireworks.abeall.com/extensions/commands/Export/Export%20SVG.jsf) to export each selected object as a separate SVG file.
View Export each as SVG.js
// Fireworks JavaScript Command
// Exports current document state as SVG graphics format
// Install by copying to Fireworks/Configuration/Commands/
// Run via the Commands menu in Fireworks
// Aaron Beall 2010-2011
// Version
var VERSION = "0.6.1";
// Params
@brachycera
brachycera / svg_filters.svg
Last active Aug 18, 2018
Collection from SVG Filters
View svg_filters.svg
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
You can’t perform that action at this time.