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
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, |
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 |
<?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); |
<?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); |
<?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'); |
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
# ------------------------------------------------------------ | |
# 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' |
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'; |
<?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. |
<?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; |