Merge pull request #47 from umgfoin/umgfoin-fix-imapauth-postgresv14.0.0beta2v14.0.0beta1stable-swift-v3

Fix inappropriate SQL-quoting in imap.php

1 files changed, 5 insertions, 5 deletions

diff --git a/user_external/lib/imap.php b/user_external/lib/imap.php
index e53fb4605..046ba94c6 100644
--- a/user_external/lib/imap.php
+++ b/user_external/lib/imap.php
@@ -52,11 +52,11 @@ class OC_User_IMAP extends \OCA\user_external\Base {
 			$uid = str_replace("%40","@",$uid);
 		}
 
-		$result = OC_DB::executeAudited(
-			'SELECT `userid` FROM `*PREFIX*preferences`'
-			. ' WHERE `appid` = "settings" AND `configkey` = "email" AND `configvalue` = ?',
-			array($uid)
-		);
+                $result = OC_DB::executeAudited(
+                        'SELECT `userid` FROM `*PREFIX*preferences` WHERE `appid`=? AND `configkey`=? AND `configvalue`=?',
+                        array('settings','email',$uid)
+                );
+
 		$users = array();
 		while ($row = $result->fetchRow()) {
 			$users[] = $row['userid'];