Closed (outdated)
Project:
File Framework
Version:
6.x-1.x-dev
Component:
Code
Priority:
Major
Category:
Feature request
Assigned:
Reporter:
Created:
22 Mar 2012 at 19:27 UTC
Updated:
30 Apr 2017 at 06:12 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #1
johanneshahn commentedthe news query for the count all files in subdiretories with access rights looks awesome :D
From a vocabulary with 3000 terms from 20 sec. to 100 milli sec.
"SELECT COUNT(*) AS count FROM {node_access} AS na
INNER JOIN (
SELECT fn.nid AS nid FROM {file_nodes} AS fn
WHERE nid IN (
SELECT nid
FROM {term_node} tn
INNER JOIN {term_data} td ON tn.tid = td.tid
WHERE tn.tid IN (". implode(',', $alltermids) .")
)
)
res ON res.nid = na.nid
WHERE res.nid $grants_sql AND grant_$op >= 1"
Comment #2
johanneshahn commentedneeds testing by community
Comment #3
srees commentedThis does not appear to be working correctly.
File count is broken at the vocab level, and we don't get file count or size for terms that act as folders anymore. Nodes look ok as far as I can tell.
Comment #4
srees commentedI've written a patch to fix the borked file counts and sizes.
Comment #5
gobinathmClosing the issue. It was inactive for a long time & it's related to a Drupal Version which is not supported anymore