chamilo /
chamilo-lms
| @@ 5046-5055 (lines=10) @@ | ||
| 5043 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5044 | } |
|
| 5045 | ||
| 5046 | if (!empty($keyword)) { |
|
| 5047 | $keyword = Database::escape_string($keyword); |
|
| 5048 | $userConditions .= " AND ( |
|
| 5049 | u.username LIKE '%$keyword%' OR |
|
| 5050 | u.firstname LIKE '%$keyword%' OR |
|
| 5051 | u.lastname LIKE '%$keyword%' OR |
|
| 5052 | u.official_code LIKE '%$keyword%' OR |
|
| 5053 | u.email LIKE '%$keyword%' |
|
| 5054 | )"; |
|
| 5055 | } |
|
| 5056 | ||
| 5057 | $where = " WHERE |
|
| 5058 | access_url_id = $urlId |
|
| @@ 3976-3985 (lines=10) @@ | ||
| 3973 | $userConditions .= " AND u.active = $active "; |
|
| 3974 | } |
|
| 3975 | ||
| 3976 | if (!empty($keyword)) { |
|
| 3977 | $keyword = Database::escape_string($keyword); |
|
| 3978 | $userConditions .= " AND ( |
|
| 3979 | u.username LIKE '%$keyword%' OR |
|
| 3980 | u.firstname LIKE '%$keyword%' OR |
|
| 3981 | u.lastname LIKE '%$keyword%' OR |
|
| 3982 | u.official_code LIKE '%$keyword%' OR |
|
| 3983 | u.email LIKE '%$keyword%' |
|
| 3984 | )"; |
|
| 3985 | } |
|
| 3986 | ||
| 3987 | if (!empty($lastConnectionDate)) { |
|
| 3988 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
