Popular downloads stuff.

[rock.divinelegy.git] / DataAccess / StepMania / SimfileRepository.php

diff --git a/DataAccess/StepMania/SimfileRepository.php b/DataAccess/StepMania/SimfileRepository.php
index 3cbc015..443c967 100644 (file)
--- a/DataAccess/StepMania/SimfileRepository.php
+++ b/DataAccess/StepMania/SimfileRepository.php
@@ -36,11 +36,19 @@ class SimfileRepository implements ISimfileRepository
         return $result;\r
     }\r
     \r
+    public function findByFileId($id)\r
+    {\r
+        $queryBuilder = $this->_queryBuilderFactory->createInstance();\r
+        $queryBuilder->where('simfile_file_id', '=', $id);\r
+        return $this->_dataMapper->map('Simfile', $queryBuilder);\r
+    }\r
+    \r
     public function findRange($id, $limit)\r
     {\r
         $queryBuilder = $this->_queryBuilderFactory->createInstance();\r
-        $queryBuilder->where('id', '>=', $id)->null('pack_id')->limit($limit);\r
-                \r
+        $queryBuilder->where('id', '>=', $id)->null('pack_id')->limit(abs($limit));\r
+        if($limit < 0) $queryBuilder->orderBy('id', 'DESC');\r
+        \r
         return $this->_dataMapper->map('Simfile', $queryBuilder);\r
     }\r
     \r