loorlab

SELECT 
    p.ID AS original_post_id,
    p.post_title AS original_post_title,
    p.post_modified AS last_modified_date,
    r.ID AS revision_id,
    r.post_modified AS revision_date,
    u.display_name AS author_name,
    u.user_email AS author_email
FROM 
    wp_posts p

loorlab

<?php
/* YOAST SEO */

// FILE no-index.txt
function get_ids_from_file($file_path) {
    if (file_exists($file_path)) {
        $file_contents = file_get_contents($file_path);

        $ids = explode(',', $file_contents);

loorlab

<?php

/* YOAST SEO*/

add_filter('wpseo_exclude_from_sitemap_by_post_ids', 'exclude_persons_cpt_from_sitemap');

function exclude_persons_cpt_from_sitemap($excluded_posts) {
    // ID para excluir del sitemap
    $specific_posts_to_exclude = array(1147);

loorlab

<?php
/********* DO NOT COPY THE PARTS ABOVE THIS LINE *********/

/*
 * Replace Disallow with Allow Generated Robots.txt
 * Credit: Unknown
 * Last Tested: June 09 2020 using WordPress 5.4.1
 */

add_filter('robots_txt','custom_robots');

loorlab

Enter this in the search box along with your search terms:

Get all gists from the user santisbon.
user:santisbon

Find all gists with a .yml extension.
extension:yml

Find all gists with HTML files.
language:html

loorlab

# ------------------------------------------------------------
# Master queries to modify databases in WordPress ------------
# ------------------------------------------------------------

# show all admin users
SELECT u.ID, u.user_login, u.user_email, u.user_nicename, 
       um.meta_value AS capability
FROM wp_users AS u
INNER JOIN wp_usermeta AS um ON (u.ID = um.user_id)
WHERE um.meta_key = 'wp_capabilities'

loorlab

update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_capabilities' where meta_key = 'OLDPREFIX_capabilities';
update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_user_level' where meta_key = 'OLDPREFIX_user_level';
update NEWPREFIX_usermeta set meta_key = 'NEWPREFIX_autosave_draft_ids' where meta_key = 'OLDPREFIX_autosave_draft_ids';
update NEWPREFIX_options set option_name = 'NEWPREFIX_user_roles' where option_name = 'OLDPREFIX_user_roles';

loorlab

<?php
//enable upload for webp image files.
function webp_upload_mimes($existing_mimes) {
    $existing_mimes['webp'] = 'image/webp';
    return $existing_mimes;
}
add_filter('mime_types', 'webp_upload_mimes');

// functions.php
//enable preview / thumbnail for webp image files.

loorlab

<?php 
// functions.php
function custom_archive_title($title) {
    if (is_category()) {
        $title = 'Category: ' . single_cat_title('', false);
    } elseif (is_tag()) {
        $title = 'Tag: ' . single_tag_title('', false);
    } elseif (is_author()) {
        $author = get_queried_object();
        $title = 'Author: ' . $author->display_name;

loorlab

<?php
/* Recent Post | image */
function show_related_posts($atts) {
    $atts = shortcode_atts(array(
        'post_id' => get_option('page_on_front'), 
    ), $atts);

    $related_post_ids = get_field('recent_post', $atts['post_id']);

    if ($related_post_ids) {