Skip to content

Instantly share code, notes, and snippets.

@16am
16am / Src featured image and timthumb.php
Created December 19, 2013 12:03
Source featured image and timthumb
@16am
16am / Disable all WP comments MySQL query.sql
Created October 30, 2013 08:56
Disable all WP comments MySQL query
UPDATE wp_posts SET comment_status='closed' WHERE post_date<'2011-05-01 00:00:00'
@16am
16am / new_gist_file
Created September 16, 2013 13:07
SQL Query after migrating WP from local to on line server
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl'); UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');
@16am
16am / Remove original size image.txt
Last active November 27, 2020 00:27
Remove original size image from WordPress Upload Directory after upload
add_filter( 'wp_generate_attachment_metadata', 'delete_fullsize_image' );
function delete_fullsize_image( $metadata )
{
$upload_dir = wp_upload_dir();
$full_image_path = trailingslashit( $upload_dir['basedir'] ) . $metadata['file'];
$deleted = unlink( $full_image_path );
return $metadata;
}
@16am
16am / Conditional php for WPML plugin
Created September 4, 2013 08:35
Conditional php for WPML plugin
<?php if (ICL_LANGUAGE_CODE == en) {
$showrum = '1343';
} else {
$showrum = '1096';
} ?>