Some things to check. Have permissions changed during your migration? Sometimes those things change unexpectedly. Use Chrome inspector to see if any Javascript is failing to load (look for the red x). Have you updated permalinks? Is your new dedicated environment able to support the requirements of everything you’re running? If your code hasn’t changed, … Read more
Can you use the SQL OFFSET statement: OFFSET 1 $query = “SELECT * FROM ” . $wpdb->base_prefix . “site_posts WHERE blog_public=”1″ AND post_type=”” . $recentglobalpoststype . “” ORDER BY post_published_stamp OFFSET 1 DESC LIMIT ” . $recentglobalpostsnumber;
When in multisite, the wpdb prefix is always the prefix required to access the tables for the current site. This includes the site ID so this should work: $wpdb->get_results($wpdb->prepare(“SELECT * FROM “.$wpdb->prefix.”options WHERE …..”)); There should be no difference at all when using multisite, just make your queries as if it were single site.
To get a specific post in WordPress, you can use the get_post() function and get_the_category() to get the categories associated with it. You can then use the code found in this answer to dump the SQL queries used. <?php $post_ID = 7; $the_post = get_post( $post_ID ); $the_category = get_the_category( $post_ID );
I agree with @Simon Blackbourn, but for arguments sake, here’s one technique: $data = get_user_meta( $user_id ); $data = wp_list_filter( $data, array( ‘ive-read-this’ ) ); $keys = array_keys( $data );
example: <?php query_posts(‘posts_per_page=5&order=ASC&post_status=future’); if ( !have_posts() ) query_posts(‘posts_per_page=5&order=DESC&post_status=publish’); if( have_posts() ) : while ( have_posts() ) : the_post(); ?>
You can’t alter a page query via pre_get_posts (in any fashion I’ve tried) to something other than a page query. If you look at the generated SQL, it’s trying to query all your post types for a pagename of new. If you set pagename to null, it’ll return posts, but it will disregard any taxonomy … Read more
ok not the most handsome solution but it works i transported the update function to update.php also wp-load.php $(“.col_visitor”).click(function(){ visitorID = $(this).attr(‘id’); //alert(‘testing ‘+visitorID); $.ajax({ url: ‘update.php’, data: {action: visitorID}, type: ‘post’, success: function(output) { //alert(output); window.location.reload(); //reload so we see the updated values } }); });//#end click
Arbitrary SQL query can be run via wpdb by using get_results() method: $results = $wpdb->get_results( $query ); You can work through documentation for wpdb at Codex to gain basic understanding of how it works.
You have to enclose the OR part to brackets: $sql = “SELECT ID,post_title,post_content,post_date,post_type FROM {$wpdb->posts} WHERE (post_content LIKE {$stuff}) AND post_status=”publish” AND post_type=”{$post_type}” AND ID != {$post->ID} LIMIT {$limit}”; $results= $wpdb->get_results($sql); Try this one: SELECT ID,post_title,post_content,post_date,post_type FROM wp_posts WHERE (post_content LIKE ‘%Battery%’ OR post_content LIKE ‘%Watcher%’ OR post_content LIKE ‘%Widget%’ OR post_content LIKE ‘%matches%’ OR … Read more