Changeset 946

Timestamp:

02/26/2004 09:42:47 PM (22 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');