loorlab

UPDATE wp_posts
SET post_status = 'publish'
WHERE ID IN (
2804, 2808, 2812, 2816, 2821, 2823, 8676, 8677, 8678, 8701, 8702, 2829, 2831, 2833, 
2836, 2838, 2840, 2842, 2844, 2846, 2848, 2850, 2852, 2854, 2856, 2858, 2860, 2862, 
2864, 2868, 2959, 2961, 2963, 2965, 2968, 2970, 2972, 2974, 2976, 2978, 2980, 2982, 
2985, 2987, 4368, 4370, 4375, 4377, 4379, 4381, 4383, 4389, 4393, 4395, 4397, 4399, 
4401, 4403, 4405, 8564, 8566, 8567, 8565, 8568, 8569, 8570, 8571, 8572, 8573, 8883, 
8884, 8885, 8886, 8887, 8888, 8951, 8952, 8953, 8954, 8956, 8957, 8958, 8959, 8960, 
8961, 8955, 8962, 8963, 8964, 9094, 9095, 9096, 9097, 9098, 9099, 9100, 9101, 9102, 

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;