Ok, if i understand you clearly, then this is the solution // first get the post ids that have the breakfast food type $post_ids = $wpdb->get_col( “SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = ‘type’ AND meta_value=”Breakfast”” ); // now get the food names $stocktypes = $wpdb->get_col( “SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = … Read more
No matter how you create a new user, it will end up calling wp_insert_user, which runs the action user_register right before finishing. So you can do something like the following: add_action(‘user_register’,’register_user_remotely’); function register_user_remotely($user_id) { //add user to external database $url = …; //url of file that will receive the $user->data in the $_POST variable $user … Read more
While custom SQL is sometimes what it takes, note that to address your concern for WP_Query it supports ‘fields’ => ‘ids’ argument to limit data returned to IDs (which can be easily used for count). In many cases that is reasonably efficient while more robust and future-proof in WP environment.
You can do that in PHPMyAdmin or using a plugin which has already been answered. Another option is to register the same CPT and taxonomies by changing the names in this code How to Structure WordPress for an Organization and its Departments? The data is not lost. All you need to do is retrieve it … Read more
You have got a few things mixed up. First, your query checks for time_created, which does not exist in your table. Second, you try to insert the date as a integer using %d. You may have to treat it as a string. Finally, you have to set $wpdb to global in your function function postviews_add_ip … Read more
No idea why you’re using clunky custom SQL, use a meta query instead. $pageposts = get_posts( array( ‘posts_per_page’ => -1, ‘post_type’ => ‘page’, ‘post_status’ => ‘publish’, ‘meta_query’ => array( array( ‘key’ => ‘_wp_page_template’, ‘value’ => array( ‘templates/front-page-excerpt.php’, ‘templates/front-page.php’, ) ) ), ) );
Use a new instance of wpdb to connect and read from the other database: $mydb = new wpdb(‘blah’,’blah’,’dkpldump’,’localhost’); $event_categories = $mydb->get_results(“SELECT * FROM calendar_cats”); foreach( $event_categories as $event_category ){ //create term! $term = wp_insert_term( $event_category->categoryId, ‘event_category’, array( ‘slug’ => $event_category->categoryName ) ); }
This feels like it is too link-heavy for an answer, but oh well. You can either use the Velvet Blues Update URLs plugin or the Serialized Search and Replace script. Either will allow you to search for a string in the database and change it to something else. The former lets you do it from … Read more
Your question is vague: i’ll try to be as specific as possible. The basic rule is: if you need to modify the default query, use pre_get_post If you need to display another list of results than the one linked to your template url, use get_posts. I find this documentation to be quite useful http://developer.wordpress.com/2012/05/14/querying-posts-without-query_posts/ Doc … Read more
Here is what you need. <?php $date = new DateTime(‘NOW’); $date->sub(new DateInterval(‘P30D’)); //30 Days Interval echo $back30days= $date->format(‘Y-m-d H:i:s’) . “\n”; global $wpdp; $top_users = $wpdb->get_results(“select count(users.user_nicename) as posts, users.user_nicename as user_name from $wpdb->users as users join $wpdb->posts as posts where users.ID = posts.post_author AND posts.post_status=”publish” AND posts.post_date_gmt > ‘$back30days’ GROUP BY users.user_nicename ORDER BY … Read more