diff options
author | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-21 23:29:54 +0100 |
---|---|---|
committer | Bernhard Posselt <nukeawhale@gmail.com> | 2013-03-21 23:29:54 +0100 |
commit | e674fe47e6a44d693314af4149022d51597b42ab (patch) | |
tree | ea3bf0764b5f9d7af6127ce102487e1714d567aa /db | |
parent | b6adabf245fb2e32763dda43a54270eef11d3411 (diff) |
disallow creating and renaming of folders that already exist
Diffstat (limited to 'db')
-rw-r--r-- | db/foldermapper.php | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/db/foldermapper.php b/db/foldermapper.php index 9cfa905cb..041b3ada4 100644 --- a/db/foldermapper.php +++ b/db/foldermapper.php @@ -63,9 +63,19 @@ class FolderMapper extends NewsMapper { public function findAllFromUser($userId){ $sql = 'SELECT * FROM `*dbprefix*news_folders` ' . - 'AND `user_id` = ?'; + 'WHERE `user_id` = ?'; $params = array($userId); return $this->findAllRows($sql, $params); } + + + public function findByName($folderName, $userId){ + $sql = 'SELECT * FROM `*dbprefix*news_folders` ' . + 'WHERE `name` = ?' . + 'AND `user_id` = ?'; + $params = array($folderName, $userId); + + return $this->findAllRows($sql, $params); + } }
\ No newline at end of file |