If you are going to do this is SQL, use a subquery. SELECT *, (SELECT meta_value FROM wp_commentmeta WHERE meta_key = ‘your-meta-key’ AND wp_commentmeta.comment_id = wp_comments.comment_ID LIMIT 1) as comment_author FROM wp_comments Instead of the *, enumerate the fields you want but leave out comment_author. Obviously, $wpdb functions to keep the table names straight.
You had to use LEFT JOIN to simplify the stuff. By the way, the same can be accomplished using WP_Query and I actualy don’t understand why you don’t want to use it. Also I’ve changed the way you write the query and I’ve not use the hardcoded $table_prefix for answer to be useful for others … Read more
You need to run the post_content filters. It is a one line change from your current code. This… echo $footerElement->post_content; … should be … echo apply_filters(‘the_content’,$footerElement->post_content); That will give you all the same formatting as with normal posts. You can of course pick and choose which filters you want to run, instead of running them … Read more
Don’t save everything as individual options, save all of your options as an array under a single key. One query to load it and save it, then just do all your manipulation in php. example structure and output: $colors = array( ‘current_scheme’ => ‘user_scheme’, ‘preset_schemes’ => array( ‘red’ => array( ‘menu’ => ‘#CC0000’, ‘footer’ => … Read more
Sticky posts are kept in a serialize array in an option in $wpdb->options with the option_name of sticky_posts. So you will need to pull that option and add an OR to the query. $sticky = get_option(‘sticky_posts’); $qry = “… OR {$wpdb->posts}.ID IN (“.implode(‘,’,$sticky).”)”;
Your question is not very detailed or very clear but get_user_meta will return all of the user metadata for a user. That should have all of your fields. You could also use get_users for the second tab. I am not dealing with the first since you state that your “have no idea how to do … Read more
Try something like this: global $wpdb; $from_user = 2; $to_user = 5; $posts_table = $wpdb->prefix . ‘posts’; $users_table = $wpdb->prefix . ‘users’; $strQuery = “UPDATE `$posts_table` SET post_author = $to_user WHERE post_author = $from_user AND $posts_table.post_date < ’01/01/2013′ AND $wpdb->term_taxonomy.term_id IN (1,2,3) AND $wpdb->term_taxonomy.taxonomy = ‘category'”; echo $strQuery; $wpdb->query($strQuery); For more info please visit this … Read more
Your question is more about SQL than WordPress. If you want to sort your term names as numbers, you can in general try SELECT * FROM wp_terms ORDER BY name+0 ASC or SELECT * FROM wp_terms ORDER BY name*1 ASC or use CAST: SELECT * FROM wp_terms ORDER BY CAST(name AS SIGNED) ASC where you … Read more
To get a % character into your SQL string without confusing sprintf() add it to the replacement string: $alabala_sql = $wpdb->prepare( ” SELECT * FROM $wpdb->posts p INNER JOIN $wpdb->term_relationships tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy tt ON tr.term_taxonomy_id=tt.term_taxonomy_id INNER JOIN $wpdb->terms t ON t.term_id=tt.term_id and t.slug= %s WHERE p.post_title LIKE %s AND … Read more
If you want to count the number of posts the user commented on, you can try: global $wpdb; $sql=”SELECT COUNT( comment_ID ) FROM ” . $wpdb->comments . ‘ WHERE user_id = %d AND comment_approved = “1” AND comment_type NOT IN (“pingback”, “trackback” ) GROUP by comment_post_ID’; $count = $wpdb->get_var( $wpdb->prepare( $sql, $user->ID ) ); where … Read more