Changeset 2326 for branches/release-38/php/lib/mtdb_base.php

Timestamp:

05/14/08 09:22:20 (19 months ago)

Author:

takayama

Message:

Fixed BugId:78122
* Not join to mt_permission
* Added function that fetches mt_permission

Files:

• branches/release-38/php/lib/mtdb_base.php (modified) (2 diffs)

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

@@ -1428 +1428 @@
         if ($sql = $this->include_exclude_blogs($args)) {
             $blog_join = 'join mt_permission on permission_author_id = author_id and permission_blog_id ' . $sql;
-            $extend_column = ', mt_permission.*';
+            $unique_filter = 'distinct';
         } elseif (isset($args['blog_id'])) {
             $blog_id = intval($args['blog_id']);
             $blog_join = "join mt_permission on permission_author_id = author_id and permission_blog_id = $blog_id";
-            $extend_column = ', mt_permission.*';
         }
 
@@ -1666 +1665 @@
 
         return $authors;
+    }
+
+    function &fetch_permission($args) {
+        if ($sql = $this->include_exclude_blogs($args)) {
+            $blog_filter = 'permission_blog_id ' . $sql;
+        } elseif (isset($args['blog_id'])) {
+            $blog_id = intval($args['blog_id']);
+            $blog_filter = "and permission_blog_id = $blog_id";
+        }
+        if (isset($args['id'])) {
+          $id_filter = 'and permission_author_id in ('.$args['id'].')';
+        }
+
+        $sql = "select
+                    *
+                from
+                    mt_permission
+                where
+                    1 = 1
+                    $blog_filter
+                    $id_filter";
+
+        $result = $this->get_results($sql, ARRAY_A);
+        return $result;
     }