Changeset 1974

Timestamp:

04/18/08 04:50:29 (4 months ago)

Author:

bchoate

Message:

Load object metadata from narrow tables. BugId:79287

Files:

• branches/release-35/php/lib/mtdb_base.php (modified) (5 diffs)

branches/release-35/php/lib/mtdb_base.php

@@ -25 +25 @@
-    var $id;
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-        $this->id = md5(uniqid('MTDatabaseBase',true));
-        $this->hide_errors();
@@ -105 +129 @@
-
-    function fetch_blogs($args) {
-
-        if ($blog_ids = $this->include_exclude_blogs($args)) {
-            $where = ' where blog_id ' . $blog_ids;
@@ -2839 +2862 @@
-                    $expanded[$key] = $this->expand_meta($value);
-                } else {
-
-
+
+
+
+
+
+
-                        if (isset($data)) {
-
-
+
+
+
-                            }
-                        }
@@ -2853 +2881 @@
-        }
-        return $expanded;
+    }
+
+    function get_meta($obj_type, $obj_id) {
+        $real_type = $obj_type;
+        if ('page' == strtolower($obj_type))
+            $real_type = 'entry';
+        elseif ('folder' == strtolower($obj_type))
+            $real_type = 'category';
+
+        $meta = $this->_meta_cache["${obj_type}_meta_${obj_id}"];
+        if (!$meta) {
+            $datasource = $real_type;
+            $datasource = preg_replace("/^mt_/", "", $datasource);
+            $result = $this->get_results("select * from mt_${datasource}_meta  where ${datasource}_meta_${datasource}_id = $obj_id", ARRAY_A);
+            $field_prefix = "${datasource}_meta_";
+            $meta = array();
+            foreach ($result as $cfrow) {
+                unset($value);
+                unset($field);
+                // need to test for each v* column to see which is populated
+                // take that value and store for meta row
+                foreach ($cfrow as $cffield => $cfvalue) {
+                    if (preg_match("/^${field_prefix}v/", $cffield)) {
+                        if (isset($cfvalue)) {
+                            $value = $cfvalue;
+                            $field = $cffield;
+                            break;
+                        }
+                    }
+                }
+                if (isset($value)) {
+                    if (preg_match("/_vblob$/", $field)) {
+                        # unserialize blob if value is serialized
+                        if (preg_match("/^BIN:SERG/", $value)) {
+                            $value = $this->unserialize($value);
+                        }
+                        elseif (preg_match("/^ASC:/", $value)) {
+                            $value = preg_replace("/^ASC:/", "", $value);
+                        }
+                    }
+                    $meta[$cfrow["${datasource}_meta_type"]] = $value;
+                }
+            }
+            $this->_meta_cache["${obj_type}_meta_${obj_id}"] = $meta;
+        }
+
+        return $meta;
-    }
-
@@ -3002 +3077 @@
-    }
-}
-?>