Skip to content

Instantly share code, notes, and snippets.

View jpgninja's full-sized avatar
🎯
Got a ton of interesting projects going on, and loving it.

Chris Mewhort jpgninja

🎯
Got a ton of interesting projects going on, and loving it.
13 followers · 30 following
View GitHub Profile
@jpgninja
jpgninja / migrate-wordpress-db.sql
Last active February 3, 2017 07:18
Quick way to update WordPress DB during migration. Eliminates the need for running Find & Replace.
/* HTTP */
UPDATE wp_options SET option_value = replace(option_value, 'http://OLDDOMAIN.com', 'http://NEWDOMAIN.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://OLDDOMAIN.com','http://NEWDOMAIN.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://OLDDOMAIN.com', 'http://NEWDOMAIN.com');
/* HTTP + WWW */
UPDATE wp_options SET option_value = replace(option_value, 'http://www.OLDDOMAIN.com', 'http://NEWDOMAIN.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.OLDDOMAIN.com','http://NEWDOMAIN.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.OLDDOMAIN.com', 'http://NEWDOMAIN.com');
@jpgninja
jpgninja / css-breakpoint-mixins.scss
Created November 21, 2016 18:22 — forked from davidgilbertson/css-breakpoint-mixins.scss
@mixin for-phone-only {
@media (max-width: 599px) { @content; }
}
@mixin for-tablet-portrait-up {
@media (min-width: 600px) { @content; }
}
@mixin for-tablet-portait-only {
@media (min-width: 600px) and (max-width: 899px) { @content; }
}
@mixin for-tablet-landscape-up {
@jpgninja
jpgninja / css-breakpoint-mixins.less
Created January 26, 2017 02:15
/* Breakpoints */
/* ------------------------- Source: http://blog.scur.pl/2012/06/variable-media-queries-less-css/ */
@highdensity: ~"only screen and (-webkit-min-device-pixel-ratio: 1.5)",
~"only screen and (min--moz-device-pixel-ratio: 1.5)",
~"only screen and (-o-min-device-pixel-ratio: 3/2)",
~"only screen and (min-device-pixel-ratio: 1.5)";
@mobile: ~"only screen and (max-width: 529px)";
@tablet: ~"only screen and (min-width: 530px) and (max-width: 949px)";
@desktop: ~"only screen and (min-width: 950px) and (max-width: 1128px)";
@desktop-xl: ~"only screen and (min-width: 1129px)";
@jpgninja
jpgninja / .htaccess-block-all
Created January 26, 2017 04:32
order deny,allow
deny from all
allow from 127.0.0.1
@jpgninja
jpgninja / pert-bookmarklet.js
Last active March 15, 2017 19:47
PERT Estimation bookmarklet
javascript:(function(){let best=parseInt(prompt("Your best case scenario : ", "1000"), 10),amt=(((best*8)+(best)+(best*6))/6);alert('Total estimate: '+amt);})();
/* Here it is laid out: */
(function(){
let best=parseInt(prompt("Your best case scenario : ", "1000"), 10),
amt=(((best*8)+(best)+(best*6))/6);
alert('Total estimate: ' + amt);
})();
@jpgninja
jpgninja / wp-function-is-blog.php
Created May 23, 2017 21:27
/**
* Is blog page
*
*/
function is_blog() {
return ( (is_archive()) || (is_author()) || (is_category()) || (is_home()) || (is_single()) || (is_tag()) ) ? true : false ;
}
@jpgninja
jpgninja / clip-wp-excerpts.php
Created June 5, 2017 00:37
<?php
/**
* Clip blog post excerpts
*
*/
add_filter('get_the_excerpt','excerpt_char_limit');
function excerpt_char_limit($e){
return substr($e,0,150) . '&hellip;';
}
@jpgninja
jpgninja / mixin-vertical-align.less
Last active June 5, 2017 05:21
/**
* Vertical Align (Mixins)
*
*/
.vertical-align(@position: relative, @offset: 50%) {
top: @offset;
position: @position;
-webkit-transform: translateY(-@offset);
-ms-transform: translateY(-@offset);
transform: translateY(-@offset);
@jpgninja
jpgninja / getpokes.js
Created September 27, 2017 16:31
let ppokes = $$('._xco ._42us a');for(ppoke in ppokes){ document.writeln(ppokes[ppoke].innerHTML + ', '+ ppokes[ppoke].href +'<br>' ); };
@jpgninja
jpgninja / delete-duplicate-products-woocommerce.sql
Last active January 3, 2019 19:41
WordPress Snippets
## Delete duplicate WooCommerce products
## (Retains the lowest ID)
## Pro tip: Change to SELECT to test
DELETE bad_rows.*
from wp_posts as bad_rows
inner join (
select post_title, MIN(id) as min_id
from wp_posts
where post_type = 'product'