[prev in list] [next in list] [prev in thread] [next in thread]
List: kde-commits
Subject: [ocs-webserver/dev] application/modules/default/models: user page url
From: Ronald von Schlegell <null () kde ! org>
Date: 2018-09-12 8:44:56
Message-ID: E1g00lc-0004Yx-PI () code ! kde ! org
[Download RAW message or body]
Git commit 0f23a396998ae951dbe6ecff5578efb238bc3543 by Ronald von Schlegell.
Committed on 12/09/2018 at 08:44.
Pushed by ronaldv into branch 'dev'.
user page url
M +2 -2 application/modules/default/models/Member.php
https://commits.kde.org/ocs-webserver/0f23a396998ae951dbe6ecff5578efb238bc3543
diff --git a/application/modules/default/models/Member.php \
b/application/modules/default/models/Member.php index 18d979cc..78950eae 100644
--- a/application/modules/default/models/Member.php
+++ b/application/modules/default/models/Member.php
@@ -776,12 +776,12 @@ class Default_Model_Member extends Default_Model_DbTable_Member
$sql = 'SELECT DISTINCT member.member_id
FROM member
JOIN activity_log on activity_log.member_id = member.member_id
- WHERE username = :username
+ WHERE LOWER(username) = :username
AND is_active = 1
AND member.is_deleted = 0
ORDER BY member.changed_at DESC, activity_log.time DESC';
- $result = $this->getAdapter()->query($sql, array('username' => \
$username))->fetchAll(); + $result = $this->getAdapter()->query($sql, \
array('username' => strtolower($username)))->fetchAll();
if($result && count($result)>0) {
$member_id = $result[0]['member_id'];
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic