Skip to content

Instantly share code, notes, and snippets.

View magadanskiuchen's full-sized avatar

Georgi Popov magadanskiuchen

View GitHub Profile
@magadanskiuchen
magadanskiuchen / relevant-posts-query.sql
Last active December 20, 2015 01:29
Get related posts by number of shared terms (WordPress). Update {POST_ID} and {TAXONOMY_NAME}
SELECT `posts`.`ID`, `posts`.`post_title`, COUNT(`posts`.`post_title`) AS `connections`
FROM `wp_posts` AS `posts`
INNER JOIN `wp_term_relationships` AS `term_rel` ON (`term_rel`.`object_id` = `posts`.`ID`)
INNER JOIN `wp_term_taxonomy` AS `term_tax` ON (`term_tax`.`term_taxonomy_id` = `term_rel`.`term_taxonomy_id`)
WHERE `term_rel`.`term_taxonomy_id` IN (
SELECT `term_rel`.`term_taxonomy_id`
FROM `wp_term_relationships` AS `term_rel`
WHERE `term_rel`.`object_id` = {POST_ID}
)
AND `term_tax`.`taxonomy` = '{TAXONOMY_NAME}'
@magadanskiuchen
magadanskiuchen / functions.js
Last active August 29, 2015 14:03
Accessible Sider
function Slider() {
// private variables
var container = slider.addClass('js');
var ul = container.find('ul');
var lis = ul.find('li');
var btnNext = null;
var btnPrev = null;
var currentSlide = 0;
// public variables
@magadanskiuchen
magadanskiuchen / functions.js
Created November 16, 2014 19:14
semi-fixed-semi-scrolling (sidebar)
jQuery(function ($) {
var $win = $(window);
var $scrollPanel = $('#scrollPanel');
var windowTop = 0;
var lastDelta = 0;
var fixed = false;
$win.scroll(function (e) {
var newTop = $win.scrollTop();
var delta = newTop - windowTop;
@magadanskiuchen
magadanskiuchen / post-merge.sh
Created March 21, 2015 17:55
A GIT post-merge hook to auto combine and minify all of your JavaScript files when merging a branch into "production"
current_branch="$(git rev-parse --abbrev-ref HEAD)";
if [[ $current_branch == 'production' ]]; then
find js -name *.js | xargs cat > js/combined.js
curl -X POST -s --data-urlencode 'input@js/combined.js' http://javascript-minifier.com/raw > js/combined.min.js
rm js/combined.js
git commit -a -m "[automated] combined and minified JS"
@magadanskiuchen
magadanskiuchen / wp-markdown-markdownify-updates.diff
Created April 10, 2016 12:09
Partial update to WP-MarkDown's Markdownify class to add support for GitHub flavor-like codeblocks
diff --git a/markdownify/markdownify.php b/markdownify/markdownify.php
index e9b43bd..24ddac3 100644
--- a/markdownify/markdownify.php
+++ b/markdownify/markdownify.php
@@ -816,15 +816,39 @@ class Markdownify {
*/
public function handleTag_pre() {
if ($this->keepHTML && $this->parser->isStartTag) {
- # check if a simple <code> follows
- if (!preg_match('#^\s*<code\s*>#Us', $this->parser->html)) {