Changeset 830

Timestamp:

12/05/06 09:15:26 (2 years ago)

Author:

takayama

Message:

Fixed AssetCount SQL BugId: 45098

Files:

• branches/wheeljack/php/lib/function.MTAssetCount.php (modified) (1 diff)
• branches/wheeljack/php/lib/mtdb_base.php (modified) (1 diff)

branches/wheeljack/php/lib/function.MTAssetCount.php

@@ -2 +2 @@
-function smarty_function_MTAssetCount($args, &$ctx) {
-    $args['blog_id'] = $ctx->stash('blog_id');
-assets = $ctx->mt->db->fetch_assets
-count($assets)
+count = $ctx->mt->db->asset_count
+$count
-}

branches/wheeljack/php/lib/mtdb_base.php

@@ -1495 +1495 @@
-        }
-        return $results;
+    }
+
+    function asset_count($args) {
+        if (isset($args['blog_id'])) {
+            $blog_filter = 'and asset_blog_id = '.intval($args['blog_id']);
+        }
+
+        # Adds a type filter
+        if (isset($args['type'])) {
+            $type_filter = "and asset_class ='" . $args['type'] . "'";
+        }
+
+        $count = $this->get_var("
+            select count(*)
+              from mt_asset
+             where
+                   1 = 1
+                   $blog_filter
+                   $type_filter
+        ");
+        return $count;
-    }
-