onwp

SELECT  u.user_email,
	um.meta_key AS "login_type", 
	from_unixtime(um.meta_value,'%c/%e/%y') AS "login_date",
	GROUP_CONCAT(p.post_title) AS "courses"
FROM nPJeAgtL_users u 
	INNER JOIN nPJeAgtL_usermeta um ON um.user_id = u.id AND um.meta_key = 'learndash-last-login'
   	LEFT JOIN nPJeAgtL_learndash_user_activity lua ON lua.user_id = u.id AND lua.activity_type = 'course'
   	LEFT JOIN nPJeAgtL_posts p ON lua.course_id = p.id
WHERE from_unixtime(um.meta_value) < '2019-03-01 00:00:00' AND p.id IN (1947,1938,7694,1932)
GROUP BY u.user_login

onwp

/*------------------Group leader frontpage table------------------------*/

function group_leader_data() {
ob_start();

$user = wp_get_current_user();
if ( in_array( 'group_leader', (array) $user->roles ) || in_array( 'administrator', (array) $user->roles )) {   

    $group_leader_id = $user->ID;
    $user_group_ids  = learndash_get_administrators_group_ids( $group_leader_id, true );

onwp

<?php
define( 'WP_USE_THEMES', false );
require( 'wp-blog-header.php' );

$usermeta = get_user_meta( 354, '_sfwd-quizzes', true );
$new = array();

foreach ($usermeta as $key => $value) {
	if ( $value['time'] < 1476545002 ) 
		array_push($new, $value);

onwp

<?php
function inspect_scripts() {
	if (!is_admin()) {
	global $wp_scripts, $wp_styles;
	echo '<h1>Scripts</h1>';
	echo '<ol>';
    foreach( $wp_scripts->queue as $handle ) :
		echo '<li>' . $handle . '</li>';
    endforeach;
	echo '</ol>';

onwp

<?php


class SES
{
	public $accessKey = NULL;
	public $accessKeyID = NULL;
	public $host = 'https://email.us-east-1.amazonaws.com/';
	public $userAgent = 'Test SES Class / v1.0';
	public $data = array();

onwp

<?php
/**
 * Contains the grade for a given user.
 *
 * @since 1.0.0
 *
 * @package LearnDash_Gradebook
 * @subpackage LearnDash_Gradebook/includes
 */

onwp

// https://developer.wordpress.org/reference/functions/add_post_type_support/

add_action( 'init', 'lelandf_custom_fields_support_learndash' );
function lelandf_custom_fields_support_learndash() {
    $post_types = [
        'sfwd-courses',
        'sfwd-lessons',
        'sfwd-topic',
    ];
     

onwp

//thanks to https://gist.github.com/sultann/24baa5483b4632c3cf214a8de5648204#file-ld-auto-mark-complete-php-L17 for most of 
//this code, i just corrected it to work with ld_lesson_tag to grab the tags as the original version returned empty 
//array since it was looking for standard wp tags 

function ld_is_tagged($postId) {
    //get all learndash tags on post
    $tags = wp_get_post_terms($postId,'ld_lesson_tag');

    foreach ($tags as $tag) {
        //need to check for auto-mark-complete tag exists on this post

onwp

WordPress database clean up queries

• Orphan rows
  • wp_posts -> wp_posts (parent/child)
  • wp_postmeta -> wp_posts
  • wp_term_taxonomy -> wp_terms
  • wp_term_relationships -> wp_term_taxonomy
  • wp_usermeta -> wp_users
  • wp_posts -> wp_users
• Other
  • wp_postmeta dupes

onwp

Commit type	Emoji
Initial commit	🎉 :tada:
Readme	👀 :eyes:
Add or update a .gitignore file	🙈 :see_no_evil:
Add or update snapshots	📸 :camera_flash:
Folder .github	:octocat:
Version tag	🔖 :bookmark:
New feature	✨ :sparkles:
Introduce breaking changes	💥 :boom: