chamilo /
chamilo-lms
| @@ 5561-5570 (lines=10) @@ | ||
| 5558 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5559 | } |
|
| 5560 | ||
| 5561 | if (!empty($keyword)) { |
|
| 5562 | $keyword = Database::escape_string($keyword); |
|
| 5563 | $userConditions .= " AND ( |
|
| 5564 | u.username LIKE '%$keyword%' OR |
|
| 5565 | u.firstname LIKE '%$keyword%' OR |
|
| 5566 | u.lastname LIKE '%$keyword%' OR |
|
| 5567 | u.official_code LIKE '%$keyword%' OR |
|
| 5568 | u.email LIKE '%$keyword%' |
|
| 5569 | )"; |
|
| 5570 | } |
|
| 5571 | ||
| 5572 | $where = " WHERE |
|
| 5573 | access_url_id = $urlId |
|
| @@ 4373-4382 (lines=10) @@ | ||
| 4370 | $userConditions .= " AND u.active = $active "; |
|
| 4371 | } |
|
| 4372 | ||
| 4373 | if (!empty($keyword)) { |
|
| 4374 | $keyword = Database::escape_string($keyword); |
|
| 4375 | $userConditions .= " AND ( |
|
| 4376 | u.username LIKE '%$keyword%' OR |
|
| 4377 | u.firstname LIKE '%$keyword%' OR |
|
| 4378 | u.lastname LIKE '%$keyword%' OR |
|
| 4379 | u.official_code LIKE '%$keyword%' OR |
|
| 4380 | u.email LIKE '%$keyword%' |
|
| 4381 | )"; |
|
| 4382 | } |
|
| 4383 | ||
| 4384 | if (!empty($lastConnectionDate)) { |
|
| 4385 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
