You should use taxonomies to store your relationships. Sidenote: A possible answer was to make the releases children of the artists using the classic post_parent field, however a post can only have 1 parent, and the need for a release to also have a director and other relationships eliminates this option. Taxonomies You will want … Read more
WP functions… Serialize: maybe_serialze Unserialize: maybe_unserialize
You could start from today and just work backwards, one day at a time: $start_hour = 8; $end_hour = 17; $date = new DateTime; foreach ( $posts as $post ) { $time = sprintf( /* Left-pad time values with zeros to two digits */ ‘%02d:%02d:%02d’, /* Random hour between start and end */ rand( $start_hour, … Read more
You are right, APIs should not expose internal data and structures, but if you depend on APIs not written by you, it will rarely be a good use of your time to develop a different API just feel better about this. And even if you develop your own API it is going to be hard … Read more
Post meta data is stored in the wp_postmeta table, the prefix wp_ may also be something else depending on your setup, in the meta_value column. If there isn’t a metabox in the post edit screen for updating the value, then instead of modifying the database directly you could temporarily add update_post_meta() call to your functions.php … Read more
This is more or less a programming question. $wpdb is not available everywhere. It’s a global variable. If you want to use it inside your own functions, just add global $wpdb; at the first line of the function. For general programming questions, this might be another discovery for you: stackoverflow.com,it is about programming in specific. … Read more
Best way would be to use this plugin: http://wordpress.org/extend/plugins/simple-term-meta/
The query_posts() inside your database call is being evaluated first, on the current site, and returning an array – which is probably empty, since its not the database you were expecting to be querying. Then that array of posts is being passed to the outer $hbldb->get_results() call, which is giving you your error, because it … Read more
To export everything in the database, go to your hosting provider’s control panel such as CPanel and find out how to do “an SQL dump”. An SQL dump is a text file containing the SQL script to rebuild your database on your local computer. You can often do that in software your host may provide … Read more
That’s a serialized object variable. The numbers are string lengths, for example, where you see s:8:”duration”, notice that the word ‘duration’ is 8 characters long. You shouldn’t have to worry about that, because WordPress will take care of it for you. You can access the fields like so: global $user_ID; // Get the ‘paypal_user’ info … Read more