General idea would be to loop through all attachments to retrieve, modify and write back their meta. Something like this (test thoroughly before using on anything important): $posts = get_posts(array( ‘post_type’ => ‘attachment’, ‘numberposts’ => -1, )); foreach( $posts as $post ) { // retrieve data, unserialized automatically $meta = get_post_meta($post->ID,’_wp_attachment_metadata’, true); // do stuff … Read more
Rake a look at wp_insert_post() which handles the insertion of new posts to the database. and there are many example how to create posts from the front end here, here, here, here and here:
See Initialization Script for “Standard” Aspects of a WordPress Website? and my plugin WordPress Basic Settings for details. You may also use a custom install.php but that’s somewhat tricky for multi-site setups.
You’re not going to get cross domain cookie sharing working. Browsers will not allow domaina.com to access cookies set for domainb.com and vice versa. Subdomains can share cookies set for the parent domain. So domaina.mydomain.com and domainb.mydomain.com can access cookies set for .mydomain.com
Just use the built-in exporter/importer. Export from the existing site, and import into the new site. You won’t ever even need to touch the database.
Have a look at this question for a fairly simple solution. Basically, create a plugin to contain your code, add a rewrite rule to intercept any requests that match your custom url, and parse or pass whatever data they contain to your plugin, which can then use those variables to produce whatever output you need. … Read more
You modified a copy of a row from the wp_posts table. You need to send the modified version back to the database: wp_update_post( $post_info );
When you call the database directly rather then using the $wpdb object its faster for a simple reason which is you only call the database, and the when you use $wpdb it loads extra functions and basically most of WordPress before you can use the $wpdb object. What you should try is to use the … Read more
Use the php function unserialize() on that string and you will get a proper array. $cats = get_cats_from_database(); $cats = unserialize($cats); //now $cats is an array like Array(0 => 20, 1 => 343 );
The second approach (joining additional table) is better for several reasons. When plugin is not active, you won’t retrieve it’s data (or with other words, you won’t select additional data unless you explicitly join it) It’s more maintainable. You can alter your plugin table without altering posts table and vice versa. The join most likely … Read more