For those who may come along: In addition to your proposed answer, you can use the .htaccess file in your web root directory. These often get missed as they are hidden files on linux systems. You can check and make sure that was copied over, or make a new file and paste the rewrite rules … Read more
$Featured_image = $wpdb->get_results(” SELECT p.* FROM net_5_postmeta AS pm INNER JOIN net_5_posts AS p ON pm.meta_value=p.ID WHERE pm.post_id = $da_id AND pm.meta_key = ‘_thumbnail_id’ ORDER BY p.post_date DESC LIMIT 15 “,’ARRAY_A’); A related solution, to query for posts WITHOUT providing a post ID (ordered by post date, and using the wp_ database prefix): SELECT p1.*, … Read more
function delete_posts() { $lastposts = get_posts(array(‘numberposts’ => -1)); if ( $lastposts ) { foreach ( $lastposts as $post ) : setup_postdata( $post ); ?> <?php $content = get_the_content(); if (str_word_count($content) < 100) { wp_trash_post($post->ID); } ?> <?php endforeach; wp_reset_postdata(); }}add_action( ‘init’, ‘delete_posts’ );
Apparently someplace in the wp_list_table, or maybe someplace else, the escape character \ was inserted before any ‘ . I was able to solve this by adding this line of code just before the $wpdb->update statement. $item[‘RecordedSubdivision’] = str_replace(“\'”, “‘”,$item[‘RecordedSubdivision’]);
If you have your data in separate table adding support for it in query is somewhat messy. Basically you will need to filter posts_where and posts_join to modify raw SQL query so that your custom table is joined and checked against your custom values. As per [faster :)] anu’s suggestion it would make sense to … Read more
This doesn’t seem especially complex, but does seem bulky and prone to errors. As I answered couple of times on similar issues – if this isn’t time critical then wait for WP 3.1 because it will have major improvements for querying by custom fields. See Advanced Metadata Queries for brief writeup on upcoming improvements. For … Read more
First of all, what you’re calling $current_tax would more appropriately be named $current_term. The taxonomy is ‘game’. Secondly, what you’re trying to do is basically adding term metadata. There already are several plugins that provide the custom table and functions for that. I recommend Simple Term Meta.
Have you tried the search and replace plugin? it will allow you to select particular tables: http://wordpress.org/extend/plugins/search-and-replace/ Of course use it with caution. etc.
You can bulk edit posts in the admin. I have never tried more than 500 or so but you can display 999 per page. To have more than the default 20 click screen options. Click posts–>filter by Category A Click Edit—> select all posts ( clicking top square next to “title”)–>Apply Click Category B and … Read more
The WordPress plugin repository has several “export to CSV” plugins available. For example this one looks interesting. Its also a good startpoint if you don’t want to use a plugin and code this on your own.