chamilo /
chamilo-lms
| @@ 5037-5046 (lines=10) @@ | ||
| 5034 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5035 | } |
|
| 5036 | ||
| 5037 | if (!empty($keyword)) { |
|
| 5038 | $keyword = Database::escape_string($keyword); |
|
| 5039 | $userConditions .= " AND ( |
|
| 5040 | u.username LIKE '%$keyword%' OR |
|
| 5041 | u.firstname LIKE '%$keyword%' OR |
|
| 5042 | u.lastname LIKE '%$keyword%' OR |
|
| 5043 | u.official_code LIKE '%$keyword%' OR |
|
| 5044 | u.email LIKE '%$keyword%' |
|
| 5045 | )"; |
|
| 5046 | } |
|
| 5047 | ||
| 5048 | $where = " WHERE |
|
| 5049 | access_url_id = $urlId |
|
| @@ 3964-3973 (lines=10) @@ | ||
| 3961 | $userConditions .= " AND u.active = $active "; |
|
| 3962 | } |
|
| 3963 | ||
| 3964 | if (!empty($keyword)) { |
|
| 3965 | $keyword = Database::escape_string($keyword); |
|
| 3966 | $userConditions .= " AND ( |
|
| 3967 | u.username LIKE '%$keyword%' OR |
|
| 3968 | u.firstname LIKE '%$keyword%' OR |
|
| 3969 | u.lastname LIKE '%$keyword%' OR |
|
| 3970 | u.official_code LIKE '%$keyword%' OR |
|
| 3971 | u.email LIKE '%$keyword%' |
|
| 3972 | )"; |
|
| 3973 | } |
|
| 3974 | ||
| 3975 | if (!empty($lastConnectionDate)) { |
|
| 3976 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
