Changeset 946

Timestamp:

02/26/2004 09:42:47 PM (21 years ago)

Author:

emc3

Message:

Added per-post custom metadata support.

Location:

trunk

Files:

• wp-admin/upgrade-functions.php (modified) (2 diffs)
• wp-blog-header.php (modified) (1 diff)
• wp-includes/template-functions-post.php (modified) (1 diff)
• wp-settings.php (modified) (1 diff)

trunk/wp-admin/upgrade-functions.php

@@ -674 +674 @@
 
 function upgrade_110() {
-  global $wpdb, $tableusers, $tablecomments, $tableposts, $tableoptiongroups, $tableoptiongroup_options, $tableoptions;
+  global $wpdb, $tableusers, $tablecomments, $tableposts, $tableoptiongroups, $tableoptiongroup_options, $tableoptions, $tablepostmeta;
     
     maybe_add_column($tablecomments, 'user_id', "ALTER TABLE `$tablecomments` ADD `user_id` INT DEFAULT '0' NOT NULL ;");
@@ -754 +754 @@
 
     }
+ 
+    // post-meta
+    maybe_create_table($tablepostmeta, "
+    CREATE TABLE $tablepostmeta (
+      meta_id int(11) NOT NULL auto_increment,
+      post_id int(11) NOT NULL default 0,
+      meta_key varchar(255),
+      meta_value text,
+      PRIMARY KEY (meta_id),
+      INDEX (post_id),
+      INDEX (meta_key)
+    )
+    ");
+
 }
 

trunk/wp-blog-header.php

@@ -449 +449 @@
     }
 
+    // Get post-meta info
+    if ( $meta_list = $wpdb->get_results("
+            SELECT post_id,meta_key,meta_value 
+            FROM $tablepostmeta 
+            WHERE post_id IN($post_id_list)
+            ORDER BY post_id,meta_key
+        ", ARRAY_A) ) {
+        
+        // Change from flat structure to hierarchical:
+        $post_meta_cache = array();
+        foreach ($meta_list as $metarow) {
+            $mpid = $metarow['post_id'];
+            $mkey = $metarow['meta_key'];
+            $mval = $metarow['meta_value'];
+            
+            // Force subkeys to be array type:
+            if (!is_array($post_meta_cache[$mpid]))
+                $post_meta_cache[$mpid] = array();
+            if (!is_array($post_meta_cache[$mpid][$mkey]))
+                $post_meta_cache[$mpid][$mkey] = array();
+            
+            // Add a value to the current pid/key:
+            $post_meta_cache[$mpid][$mkey][] = $mval;
+        }
+    }
+
+
     if (1 == count($posts)) {
         if ($p || $name) {

trunk/wp-includes/template-functions-post.php

@@ -444 +444 @@
 }
 
+/*
+ * Post-meta: Custom per-post fields.
+ */
+ 
+function get_post_custom() {
+    global $id, $post_meta_cache;
+
+    return $post_meta_cache[$id];
+}
+
+function get_post_custom_keys() {
+    global $id, $post_meta_cache;
+    
+    if (!is_array($post_meta_cache[$id]))
+        return;
+    if ($keys = array_keys($post_meta_cache[$id]))
+        return $keys;
+}
+
+function get_post_custom_values($key='') {
+    global $id, $post_meta_cache;
+
+    return $post_meta_cache[$id][$key];
+}
+
+// this will probably change at some point...
+function the_meta() {
+    global $id, $post_meta_cache;
+    
+    if ($keys = get_post_custom_keys()) {
+        echo "<ul>\n";
+        foreach ($keys as $key) {
+            $value = implode($post_meta_cache[$id][$key],',');
+            
+            echo "<li>$key: $value</li>\n";
+        }
+        echo "</ul>\n";
+    }
+}
+
 ?>

trunk/wp-settings.php

@@ -24 +24 @@
 $tableoptiongroups        = $table_prefix . 'optiongroups';
 $tableoptiongroup_options = $table_prefix . 'optiongroup_options';
+$tablepostmeta            = $table_prefix . 'postmeta';
 define('WPINC', 'wp-includes');
 require_once (ABSPATH . WPINC . '/wp-db.php');