All your Galleries are stored a table called wp_ngg_gallery in your wordpress database. (For the sake of completeness: nextGen Gallery creates 2 more tables for albums and pictures, respectively) $gallery_ids = $wpdb->get_results( “SELECT gid FROM “.$wpdb->prefix.”ngg_gallery ORDER BY gid ASC”, ARRAY_A); fetches the IDs of all galleries into an array, ordered by ID from 1 … Read more
Why not use the SELECT INTO OUTFILE syntax: $wpdb->query(“SELECT * INTO OUTFILE ‘/path/to/file’ FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’ FROM tracking”);
If you’re in need of Meta Boxes for WordPress, check out the amazing code in github by jaredatch. https://github.com/jaredatch/Custom-Metaboxes-and-Fields-for-WordPress This allows you to add all sorts of metaboxes to your WP theme (or plugin). Date Picker, file upload, wysiwyg, text areas, text boxes…it’s really amazing and saves lots of time.
I am not positive how to do what you want. But I have been using this framework which is very similar to what you have above but is much easier to use http://aquagraphite.com/2011/11/smof-documentation/ setting up options is really easy and it is supported through github. There is a place to ask these exact kind of … Read more
Not tested but you can try this: $args = array( ‘posts_per_page’ => 4, ‘post_type’ => ‘post’, ‘meta_key’ => ‘meta-select’, ‘order’ => ‘ASC’, ‘orderby’ => ‘meta_value_num’, ‘meta_query’ => array( array( ‘key’ => ‘meta-select’, ‘value’ => array( 2, 3, 4, 5 ), ‘compare’ => ‘IN’, ), ), ); Ordering is done by value of meta field meta-select … Read more
Use a custom table. Create it as a network table, and store the site ID, so you can use just one table for the whole network. row_id | site_id | post_id | user_id There is no equivalent for such a table in the current core tables. Avoid serialized data, because that format is PHP specific, … Read more
Per comments a way around it is to set the post_type to something that isn’t a hierarchical type in the filter, as the wp_dropdown_pages() function used to populate the select calls get_pages() which just returns without doing anything if the post_type isn’t hierarchical. So using a non-existent post_type works: function limit_parents_wpse_106164( $args ) { $args[‘post_type’] … Read more
So based on our discussion, the meta named opposition (for match posts) has its value set to the slug of the corresponding club post; e.g. club-1, club-two, etc., right? If so, then you first get the ID of the club post using a custom query (see in the code below) and then you can access … Read more
After much trial and error I finally figured out a solution using mysqli. I consider it a acceptable solution since the query will only be run on plugin updates. $mysqli = new mysqli(); $mysqli->connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $sql = ” DROP TRIGGER IF EXISTS {$wpdb->get_blog_prefix($site->id)}post_queue_insert; CREATE TRIGGER {$wpdb->get_blog_prefix($site->id)}post_queue_insert BEFORE INSERT ON {$wpdb->get_blog_prefix($site->id)}posts FOR EACH ROW … Read more
May be it’s a bad idea, but it’s the only. Don’t print posts immediately, but collect them in different variables: one for category “test”, one for the rest. <?php $w_h = $w_d = $last = 0; // init variables to concatenate content later $primary_posts = $secondary_posts=””; // empty array to fill later $category_names = array(); … Read more