This is more or less a programming question. $wpdb is not available everywhere. It’s a global variable. If you want to use it inside your own functions, just add global $wpdb; at the first line of the function. For general programming questions, this might be another discovery for you: stackoverflow.com,it is about programming in specific. … Read more
get_comments_number works in the loop. You’re using it outside. So do something like this $category = get_the_category(); $category = $category[0]; $category = $category->cat_ID; $posts = get_posts(‘numberposts=5&offset=0&orderby=post_date&order=DESC&category=’.$category); foreach($posts as $post){ setup_postdata($post); $total = get_comments_number(); echo ‘here we create the HTML and content for the post’; } wp_reset_query();
If you’re familiar with ZF you might be looking for models and layouts, both which you need to manually code with WordPress. But if you do so, you’ve got full possibilities. So feel free to create multiple template files and load them when it’s needed (e.g by hooking into template redirect or get_template_part) and then … Read more
Couple of possible ways. Use get_pages() with parent => 0 to fetch top-level ones and put them as post__not_in in query. Filter posts_where to add AND post_parent > 0 when necessary.
You almost have it right, it should be attachment instead of media since all media uploads are “called” attachments” in WordPress, so: $query->set( ‘post_type’, ‘attachment’ );
That sounds outside the scope of what you’re going to get from query_posts. If you have a custom template for your home page and you want to sprinkle in advertisement posts I would change the query_posts() that excludes the advertisement category, do a separate get_posts() for 2 posts in the advertisement category, and then put … Read more
It’s a long shot, but what happens if you add in a wp_reset_query() call?
This should do it: $querystr = “SELECT comment_count, ID, post_title FROM $wpdb->posts wposts, $wpdb->comments wcomments WHERE wposts.ID = wcomments.comment_post_ID AND wposts.post_status=”publish” AND wcomments.comment_approved=’1′ AND wcomments.comment_date > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 YEAR) GROUP BY wposts.ID ORDER BY comment_count DESC LIMIT 0 , 10 “;
You can easily sort by native post fields, so try something like this: $posts = get_posts( array( ‘numberposts’ => 10, ‘orderby’ => ‘comment_count’, ) );
I would create a separate Reviews CPT. In the Reviews write screen, I would add a metabox with a select input contain each Game CPT as an option. Using the metabox, you can associate the Game ID as postmeta with the Review. Finally, in your template page that displays the review, you can easily retrieve … Read more