chamilo /
chamilo-lms
| @@ 5216-5225 (lines=10) @@ | ||
| 5213 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5214 | } |
|
| 5215 | ||
| 5216 | if (!empty($keyword)) { |
|
| 5217 | $keyword = Database::escape_string($keyword); |
|
| 5218 | $userConditions .= " AND ( |
|
| 5219 | u.username LIKE '%$keyword%' OR |
|
| 5220 | u.firstname LIKE '%$keyword%' OR |
|
| 5221 | u.lastname LIKE '%$keyword%' OR |
|
| 5222 | u.official_code LIKE '%$keyword%' OR |
|
| 5223 | u.email LIKE '%$keyword%' |
|
| 5224 | )"; |
|
| 5225 | } |
|
| 5226 | ||
| 5227 | $where = " WHERE |
|
| 5228 | access_url_id = $urlId |
|
| @@ 4247-4256 (lines=10) @@ | ||
| 4244 | $userConditions .= " AND u.active = $active "; |
|
| 4245 | } |
|
| 4246 | ||
| 4247 | if (!empty($keyword)) { |
|
| 4248 | $keyword = Database::escape_string($keyword); |
|
| 4249 | $userConditions .= " AND ( |
|
| 4250 | u.username LIKE '%$keyword%' OR |
|
| 4251 | u.firstname LIKE '%$keyword%' OR |
|
| 4252 | u.lastname LIKE '%$keyword%' OR |
|
| 4253 | u.official_code LIKE '%$keyword%' OR |
|
| 4254 | u.email LIKE '%$keyword%' |
|
| 4255 | )"; |
|
| 4256 | } |
|
| 4257 | ||
| 4258 | if (!empty($lastConnectionDate)) { |
|
| 4259 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
