From e674fe47e6a44d693314af4149022d51597b42ab Mon Sep 17 00:00:00 2001 From: Bernhard Posselt Date: Thu, 21 Mar 2013 23:29:54 +0100 Subject: disallow creating and renaming of folders that already exist --- db/foldermapper.php | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) (limited to 'db/foldermapper.php') 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 -- cgit v1.2.3