The main query is generated before the template is loaded, the results of the main query are how WordPress knows what template to load. If you want to alter query parameters of the main query to change things like orderby, you should add a function hooked to pre_get_posts. The argument passed to the function contains … Read more
Actually, with a little digging this is quite easy to do. WooCommerce has already set up a filter so all you have to do it add a small snippet in your functions.php file. // Modify the default WooCommerce orderby dropdown // // Options: menu_order, popularity, rating, date, price, price-desc function my_woocommerce_catalog_orderby( $orderby ) { unset($orderby[“price”]); … Read more
Try this: function my_custom_ordering( $query ) { if($query->is_main_query() AND !is_admin() ) { if ( $query->is_home() || $query->is_category() || $query->is_tag() ){ $query->set( ‘orderby’, ‘modified’ ); } } } add_action( ‘pre_get_posts’, ‘my_custom_ordering’ ); This will set orderby field to modified in the WordPress query.
Eric based on your code I wrote to meet my needs, for those who want to follow: Eric com base em seu código eu escrevi o para atender as minhas necessidades, para quem quiser segue abaixo: <?php global $wpdb; $produto_id = 22777; // ID do produto $consulta = “SELECT order_id FROM {$wpdb->prefix}woocommerce_order_itemmeta woim LEFT JOIN … Read more
I solved the same problem like this First you store each posts in another array called $events_by_date with date as the index. If another event post falls in the same date you put that post under the same index. Please comment if you need further explanation. <?php //setup your wp_query parmeters to make the query … Read more
To show a list by Year DESC and by month ASC: change your post type with custom_post. global $wpdb; $posts = $wpdb->posts; $sql = “SELECT DISTINCT(YEAR(`post_date`)) as years FROM $posts WHERE post_type=”custom_post” ORDER BY years DESC”; //Get all post year list by DESC $result = $wpdb->get_results($sql); foreach($result as $rs) { echo ‘<h2>’.$rs->years.'</h2>’; $args = array( … Read more
As mentioned above, never use query_posts, as it breaks a lot of stuff. Use a filter like pre_get_posts instead. The filter pre_get_posts allows you to edit the query before it gets executedby WP. The following code will order by the meta value you want. I made it so it only works on the main query … Read more
Gallery “order” is saved in the gallery shortcode itself. Take a look at the code for the gallery using the “text” editor, then drag the images around, and look at the raw code again. To make this work, you will have to parse the post content for the gallery shortcode and extract its data. Something … Read more
Finally found out using two (single) posts metas : likes_log where I keep up to date an array where each entry is the time the item was liked. Entries are removed if they are too old (here, >1 month) likes_log_count where I update the number of entries in the previous log. function update_likes_monthly_count(){ if ( … Read more
This should give you an idea and I believe this should help you forward. This query first uses WP_User_Query to fetch all users that are authors registered as premium subscribers and basic subscribers. These users are ordered by meta_value so that premium subscribers are shown first. A foreach loop return each users’ own ID which … Read more