Skip to content

Instantly share code, notes, and snippets.

@reinislejnieks
reinislejnieks / delete-all-woocommerce-products.php
Last active April 12, 2018 07:27 — forked from mikaelz/delete-all-woocommerce-products.php
Remove all WooCommerce products from database via SQL
<?php
require dirname(__FILE__).'/wp-blog-header.php';
$wpdb->query("DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%')");
$wpdb->query("DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'");
$wpdb->query("DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy)");
$wpdb->query("DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'))");
$wpdb->query("DELETE FROM wp_posts WHERE post_type IN ('product','product_variation')");
@reinislejnieks
reinislejnieks / #mysql_import.txt
Created February 26, 2018 10:20
#mysql import large dumps
#in terminal with MAMP
/Applications/MAMP/Library/bin/mysql -u root -p {DB_NAME} < {PATH/TO/MYSQL/DUMP/FILE.SQL}
@reinislejnieks
reinislejnieks / wp.php
Created January 23, 2018 12:43
#wp include template part and pass it variables
<?php
$var = 'test';
include(locate_template( 'template-parts/loop-frontpage.php' ));
// then you can use $var in loop-frontpage.php
@reinislejnieks
reinislejnieks / throttling-scroll.js
Created October 31, 2017 14:05
#js scroll throttling in plain javascript
// helper
function throttle(fn, wait) {
var time = Date.now();
return function() {
if ((time + wait - Date.now()) < 0) {
fn();
time = Date.now();
}
}
}
@reinislejnieks
reinislejnieks / spinner.css
Created October 27, 2017 10:31
#css spinner, spinning dots in circle
.sk-circle {
margin: 100px auto;
width: 40px;
height: 40px;
position: relative;
}
.sk-circle .sk-child {
width: 100%;
height: 100%;
position: absolute;
@reinislejnieks
reinislejnieks / spinner.html
Created October 27, 2017 10:29
#css spinner, 3 horizontal dots
<div class="spinner">
<div class="bounce1"></div>
<div class="bounce2"></div>
<div class="bounce3"></div>
</div>
@reinislejnieks
reinislejnieks / functions.php
Last active October 24, 2017 11:42
#wp #js send ajax data to Wordpress
<?php
// this is the php part of the ajax call
// we define the nonce value for security
define('WP_FORM_NONCE_STR', 'awefaewf234@#$FSD');
// we define action hooks so that WP knows which function needs to caled
// this is for loged in users
add_action("wp_ajax_uzl_subscr_form","uzl_subscr_form");
// this is for non loged in users
@reinislejnieks
reinislejnieks / dropcap.css
Created September 29, 2017 09:38
#css dropcap
.dropcap > div:first-child:first-letter{
float: left;
font-size: 6.2em;
line-height: 1.1em;
margin: -.15em .08em -.2em 0;
}
@reinislejnieks
reinislejnieks / grid.scss
Created September 15, 2017 09:09
#scss mixins for IE10 compatible css grid
@mixin display-grid {
display: -ms-grid;
display: grid;
}
@mixin grid-child ($col-start, $col-end, $row-start, $row-end) {
-ms-grid-column: $col-start;
-ms-grid-column-span: $col-end - $col-start;
-ms-grid-row: $row-start;
-ms-grid-row-span: $row-end - $row-start;
@reinislejnieks
reinislejnieks / undeline.scss
Last active September 15, 2017 09:09
#scss mixins for text underline
/* mixins for text underline */
@mixin text-underline-crop($background) {
text-shadow: .03em 0 $background,
-.03em 0 $background,
0 .03em $background,
0 -.03em $background,
.06em 0 $background,
-.06em 0 $background,
.09em 0 $background,
-.09em 0 $background,