Modifiedcontent

Apparently it’s an underdocumented peculiarity of WordPress MU.

query_posts(‘showposts=5’); doesn’t work anymore in 2.7

What’s the latest way to do this (2.6 officially I guess)?

In this case I use WordPress to manage a table of “records” instead of blog posts. I already had this table with another script, but needed a flexible category system like WP has.

Yes, I went into MySQL to add these fields. I’m not a PHP/SQL coder, but I’m trying to get to the basics, not pile on more WP specific code and plugins.

Again, as far as I can tell the Custom Field option stores data as meta data, not regular fields. That is no good, because I want to be able to access the same “records” table through other scripts.

Even with turning off post revision the latest versions of WordPress don’t seem to keep the integrity of the records. They still create new versions with new IDs.

I also couldn’t get custom permalinks to work in my modified WP 2.6 experiment. In 2.2 it works beautifully. For straightforward blogging WP 2.6+ is fine, for anything else WP has jumped the shark imho.

So no, thanks for your effort, but your post was not helpful at all. I deliberately mentioned these points in my original question, hoping to avoid answers like yours.

So forget all that, here’s my question again:

I have manually added several custom fields in the ‘posts’ table in the database (‘tagline’, ‘url’, ‘address’, etc.). I’m trying to edit edit-form-advanced.php to add form input elements for these fields to the editor page in admin.

Adding the form input elements is not that complicated, getting the input stored is trickier. Where is the code/query that stores the data from the edit-form into the MySQL ‘posts’ table? Which WP files are involved in this process?

What would it be for WordPress 2.2?

It has different table names and probably structure. Can’t figure it out. Found this on another thread about changes for 2.3:

$wpdb->categories is replaced by $wpdb->terms
$wpdb->post2cat is replaced by $wpdb->term_relationships
$wpdb->post2cat.post_id is replaced by $wpdb->term_relationships.object_id
$wpdb->post2cat.category_id is replaced by $wpdb->term_relationships.term_taxonomy_id
$wpdb->categories.cat_ID is replaced by $wpdb->terms.term_id

wp_terms now contains all the category (read: taxonomy) names and IDs.

wp_term_taxonomy contains the term (read category) ID, a description of what type it is (category, link_category, etc), the description and the number of posts/links in that taxonomy.

wp_term_relationships contains a lookup of an object_id (read: post ID, link ID, etc) and a term taxonomy ID (from the term_taxonomy table, which relates back to the category).

Other refs to look out for are (especially when they are used OUT of the above context):
cat_ID –> term_ID
categories –> terms
cat_name –> name

I get this far:
$query = "SELECT * FROM posts as wpost INNER JOIN post2cat ON (wpost.ID = post2cat.post_id) INNER JOIN term_taxonomy ON (post2cat.category_id = 3) AND term_taxonomy.taxonomy = 'category' AND term_taxonomy.term_id IN (3)";

I have no clue what to do with term_taxonomy and probably need a different structure anyway. Can’t puzzle it together.