Changeset 2326

Timestamp:

05/14/08 09:22:20 (6 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/block.mtcomments.php (modified) (1 diff)
• branches/release-38/php/lib/mtdb_base.php (modified) (2 diffs)

branches/release-38/php/lib/block.mtcomments.php

@@ -37 +37 @@
-        if ($comment['comment_commenter_id']) {
-            $commenter = $ctx->mt->db->fetch_author($comment['comment_commenter_id']);
+            $permission = $ctx->mt->db->fetch_permission(array('blog_id' => $comment['comment_blog_id'], 'id' => $comment['comment_commenter_id']));
+            $commenter = array_merge($commenter, $permission[0]);
-            $ctx->stash('commenter', $commenter);
-        } else {

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;
-    }
-