chamilo /
chamilo-lms
| @@ 4280-4289 (lines=10) @@ | ||
| 4277 | $userConditions .= " AND u.active = $active "; |
|
| 4278 | } |
|
| 4279 | ||
| 4280 | if (!empty($keyword)) { |
|
| 4281 | $keyword = Database::escape_string($keyword); |
|
| 4282 | $userConditions .= " AND ( |
|
| 4283 | u.username LIKE '%$keyword%' OR |
|
| 4284 | u.firstname LIKE '%$keyword%' OR |
|
| 4285 | u.lastname LIKE '%$keyword%' OR |
|
| 4286 | u.official_code LIKE '%$keyword%' OR |
|
| 4287 | u.email LIKE '%$keyword%' |
|
| 4288 | )"; |
|
| 4289 | } |
|
| 4290 | ||
| 4291 | if (!empty($lastConnectionDate)) { |
|
| 4292 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
| @@ 5335-5344 (lines=10) @@ | ||
| 5332 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5333 | } |
|
| 5334 | ||
| 5335 | if (!empty($keyword)) { |
|
| 5336 | $keyword = Database::escape_string($keyword); |
|
| 5337 | $userConditions .= " AND ( |
|
| 5338 | u.username LIKE '%$keyword%' OR |
|
| 5339 | u.firstname LIKE '%$keyword%' OR |
|
| 5340 | u.lastname LIKE '%$keyword%' OR |
|
| 5341 | u.official_code LIKE '%$keyword%' OR |
|
| 5342 | u.email LIKE '%$keyword%' |
|
| 5343 | )"; |
|
| 5344 | } |
|
| 5345 | ||
| 5346 | $where = " WHERE |
|
| 5347 | access_url_id = $urlId |
|
