50 |
|
return path.GetName(); |
51 |
|
} |
52 |
|
|
53 |
< |
_L<MediaFile> MediaFolder::GetFiles() const |
53 |
> |
_L<MediaFile> MediaFolder::GetFiles(unsigned page) const |
54 |
|
{ |
55 |
< |
_R<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM files WHERE live = TRUE AND folder = ? ORDER BY path"))->Execute(path.GetPath())); |
55 |
> |
_R<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM files WHERE live = TRUE AND folder = ? ORDER BY path LIMIT 50 OFFSET ?"))->Execute(path.GetPath(), page * 50)); |
56 |
|
_L<MediaFile> files; |
57 |
|
|
58 |
|
while (paths->MoveNext()) |
61 |
|
return files; |
62 |
|
} |
63 |
|
|
64 |
< |
_L<MediaFolder> MediaFolder::GetFolders() const |
64 |
> |
_L<MediaFolder> MediaFolder::GetFolders(unsigned page) const |
65 |
|
{ |
66 |
< |
_R<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM folders WHERE folder = ? ORDER BY path"))->Execute(path.GetPath())); |
66 |
> |
_R<dbi::ResultSet> paths(connection->Parse(_B("SELECT path FROM folders WHERE folder = ? ORDER BY path LIMIT 50 OFFSET ?"))->Execute(path.GetPath(), page * 50)); |
67 |
|
_L<MediaFolder> folders; |
68 |
|
|
69 |
|
while (paths->MoveNext()) |