bmakowski

delete
p,pm
from wp_posts p
join wp_postmeta pm on pm.post_id = p.id
where p.post_type = 'shop_order';
delete
p,pm
from wp_posts p
join wp_postmeta pm on pm.post_id = p.id
where p.post_type = 'shop_subscription';

bmakowski

/^\d+(\s[A-Z]*[a-z]*[.]*){1,}(\s\d*)*$/

bmakowski

-- to open reviews for currently added products
UPDATE wp_posts SET comment_status = 'open' WHERE post_type = 'product';
-- to close reviews
UPDATE wp_posts SET comment_status = 'closed' WHERE post_type = 'product';

bmakowski

<?php

// Traditional way
$array = array('0', '1', '2');
foreach ($array as $key => $var) {
    $array[$key] = (int)$var;
}

// The nice way
$array = array('0', '1', '2');

bmakowski

add_action( 'woocommerce_before_checkout_form', 'custom_payment_overlay' );
function custom_payment_overlay(){
	echo sprintf('<div class="custom-payment-popup"><div class="wpt-payment-overlay"></div><div class="wpt-payment-message">%s</div></div>',
		'We are processing your payment. Please hold on and do not refresh your browser.'
	);
}

bmakowski

delete
u,um
from wp_users u
join wp_usermeta um on um.user_id = u.id
where um.meta_key = 'wp_user_level' and um.meta_value = 0

bmakowski

delete
p,pm
from wp_posts p
join wp_postmeta pm on pm.post_id = p.id
where p.post_type = 'companies'

bmakowski

wp user list --field=ID --role=customer | xargs wp user delete --yes

bmakowski

This allows only domains with "." for example "example.com"
^(?!\-)(?:[a-zA-Z\d\-]{0,62}[a-zA-Z\d]\.){1,126}(?!\d+)[a-zA-Z\d]{1,63}$

This allows also one-name domains like "localhost". "." is optional
^(?!\-)(?:[a-zA-Z\d\-]{0,62}[a-zA-Z\d]\.?){1,126}(?!\d+)[a-zA-Z\d]{1,63}$

bmakowski

<?php

if( !preg_match('/^(?!\-)(?:[a-zA-Z\d\-]{0,62}[a-zA-Z\d]\.){1,126}(?!\d+)[a-zA-Z\d]{1,63}$/', $domain) ){
  // didn't match return error
  return false;
}