mikejolley

DELETE from wp_users where wp_users.ID not in (
	SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
) AND wp_users.ID not in (
	select distinct(post_author) from wp_posts
);

delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users);

avataru

Overview

Source: https://medium.com/@Mahmoud_Zalt/eloquent-relationships-cheat-sheet-5155498c209

	One to one (1-1)	One to many (1-n)	Poly one to many (1x-n)	Many to many (n-n)	Poly many to many (nx-n)
Number of models	2 only	2 only	3 and above	2 only	3 and above
Number of tables	2 (1/model)	2 (1/model)	3+ (1/model)	3 (1/model + pivot)	4+ (1/model + pivot)
Pivot table	-	-	-	required

ErikCH

10 Front-End Websites You Need To Know As A developer

HTML/CSS Templates

• https://templated.co/
• https://html5up.net/

Design Inspiration

• https://dribbble.com/
• https://www.behance.net/

yanknudtskov

# Use with EXTREME CAUTION

DELETE FROM wp_users WHERE ID IN ( SELECT user_id FROM wp_usermeta
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%' 
AND user_id NOT IN ( SELECT user_id FROM wp_usermeta
WHERE meta_key = 'billing_first_name' AND meta_value != ''
AND user_id IN ( SELECT user_id FROM wp_usermeta
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%' ) ) )

DELETE FROM wp_usermeta WHERE user_id IN ( SELECT user_id FROM wp_usermeta

lgladdy

<?php

add_filter( 'acf/json/load_paths', 'set_custom_json_load_paths' );
function set_custom_json_load_paths( $paths ) {
	$paths[] = get_stylesheet_directory() . '/acf-json/post-types';
	$paths[] = get_stylesheet_directory() . '/acf-json/field-groups';
	$paths[] = get_stylesheet_directory() . '/acf-json/taxonomies';
	$paths[] = get_stylesheet_directory() . '/acf-json/option-pages';
	return $paths;
}

ixahmedxi

{
  // open json editor for settings
  "workbench.settings.editor": "json",

  // Theme
  "workbench.colorTheme": "Aura Dark",
  "workbench.iconTheme": "moxer-icons",

  // Change font
  "editor.fontFamily": "Geist Mono",