@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | // get count of Items in this folder |
72 | 72 | $get = DB::queryfirstrow( |
73 | 73 | 'SELECT count(*) as num_results |
74 | - FROM ' . prefixTable('items') . ' |
|
74 | + FROM ' . prefixTable('items').' |
|
75 | 75 | WHERE inactif = %i AND id_tree = %i', |
76 | 76 | 0, |
77 | 77 | $child->id |
@@ -80,14 +80,14 @@ discard block |
||
80 | 80 | $ret[$child->id]['id'] = $child->id; |
81 | 81 | |
82 | 82 | // get number of subfolders |
83 | - $nodeDescendants =$tree->getDescendants($child->id, false, false, true); |
|
83 | + $nodeDescendants = $tree->getDescendants($child->id, false, false, true); |
|
84 | 84 | $ret[$child->id]['subfoldersCount'] = count($nodeDescendants); |
85 | 85 | |
86 | 86 | // get items number in subfolders |
87 | 87 | if (count($nodeDescendants) > 0) { |
88 | 88 | $get = DB::queryfirstrow( |
89 | 89 | 'SELECT count(*) as num_results |
90 | - FROM ' . prefixTable('items') . ' |
|
90 | + FROM ' . prefixTable('items').' |
|
91 | 91 | WHERE inactif = %i AND id_tree IN (%l)', |
92 | 92 | 0, |
93 | 93 | implode(',', $nodeDescendants) |