chamilo /
chamilo-lms
| @@ 5450-5459 (lines=10) @@ | ||
| 5447 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5448 | } |
|
| 5449 | ||
| 5450 | if (!empty($keyword)) { |
|
| 5451 | $keyword = Database::escape_string($keyword); |
|
| 5452 | $userConditions .= " AND ( |
|
| 5453 | u.username LIKE '%$keyword%' OR |
|
| 5454 | u.firstname LIKE '%$keyword%' OR |
|
| 5455 | u.lastname LIKE '%$keyword%' OR |
|
| 5456 | u.official_code LIKE '%$keyword%' OR |
|
| 5457 | u.email LIKE '%$keyword%' |
|
| 5458 | )"; |
|
| 5459 | } |
|
| 5460 | ||
| 5461 | $where = " WHERE |
|
| 5462 | access_url_id = $urlId |
|
| @@ 4357-4366 (lines=10) @@ | ||
| 4354 | $userConditions .= " AND u.active = $active "; |
|
| 4355 | } |
|
| 4356 | ||
| 4357 | if (!empty($keyword)) { |
|
| 4358 | $keyword = Database::escape_string($keyword); |
|
| 4359 | $userConditions .= " AND ( |
|
| 4360 | u.username LIKE '%$keyword%' OR |
|
| 4361 | u.firstname LIKE '%$keyword%' OR |
|
| 4362 | u.lastname LIKE '%$keyword%' OR |
|
| 4363 | u.official_code LIKE '%$keyword%' OR |
|
| 4364 | u.email LIKE '%$keyword%' |
|
| 4365 | )"; |
|
| 4366 | } |
|
| 4367 | ||
| 4368 | if (!empty($lastConnectionDate)) { |
|
| 4369 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
