chamilo /
chamilo-lms
| @@ 5567-5576 (lines=10) @@ | ||
| 5564 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5565 | } |
|
| 5566 | ||
| 5567 | if (!empty($keyword)) { |
|
| 5568 | $keyword = Database::escape_string($keyword); |
|
| 5569 | $userConditions .= " AND ( |
|
| 5570 | u.username LIKE '%$keyword%' OR |
|
| 5571 | u.firstname LIKE '%$keyword%' OR |
|
| 5572 | u.lastname LIKE '%$keyword%' OR |
|
| 5573 | u.official_code LIKE '%$keyword%' OR |
|
| 5574 | u.email LIKE '%$keyword%' |
|
| 5575 | )"; |
|
| 5576 | } |
|
| 5577 | ||
| 5578 | $where = " WHERE |
|
| 5579 | access_url_id = $urlId |
|
| @@ 4358-4367 (lines=10) @@ | ||
| 4355 | $userConditions .= " AND u.active = $active "; |
|
| 4356 | } |
|
| 4357 | ||
| 4358 | if (!empty($keyword)) { |
|
| 4359 | $keyword = Database::escape_string($keyword); |
|
| 4360 | $userConditions .= " AND ( |
|
| 4361 | u.username LIKE '%$keyword%' OR |
|
| 4362 | u.firstname LIKE '%$keyword%' OR |
|
| 4363 | u.lastname LIKE '%$keyword%' OR |
|
| 4364 | u.official_code LIKE '%$keyword%' OR |
|
| 4365 | u.email LIKE '%$keyword%' |
|
| 4366 | )"; |
|
| 4367 | } |
|
| 4368 | ||
| 4369 | if (!empty($lastConnectionDate)) { |
|
| 4370 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
