chamilo /
chamilo-lms
| @@ 4267-4276 (lines=10) @@ | ||
| 4264 | $userConditions .= " AND u.active = $active "; |
|
| 4265 | } |
|
| 4266 | ||
| 4267 | if (!empty($keyword)) { |
|
| 4268 | $keyword = Database::escape_string($keyword); |
|
| 4269 | $userConditions .= " AND ( |
|
| 4270 | u.username LIKE '%$keyword%' OR |
|
| 4271 | u.firstname LIKE '%$keyword%' OR |
|
| 4272 | u.lastname LIKE '%$keyword%' OR |
|
| 4273 | u.official_code LIKE '%$keyword%' OR |
|
| 4274 | u.email LIKE '%$keyword%' |
|
| 4275 | )"; |
|
| 4276 | } |
|
| 4277 | ||
| 4278 | if (!empty($lastConnectionDate)) { |
|
| 4279 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
| @@ 5271-5280 (lines=10) @@ | ||
| 5268 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5269 | } |
|
| 5270 | ||
| 5271 | if (!empty($keyword)) { |
|
| 5272 | $keyword = Database::escape_string($keyword); |
|
| 5273 | $userConditions .= " AND ( |
|
| 5274 | u.username LIKE '%$keyword%' OR |
|
| 5275 | u.firstname LIKE '%$keyword%' OR |
|
| 5276 | u.lastname LIKE '%$keyword%' OR |
|
| 5277 | u.official_code LIKE '%$keyword%' OR |
|
| 5278 | u.email LIKE '%$keyword%' |
|
| 5279 | )"; |
|
| 5280 | } |
|
| 5281 | ||
| 5282 | $where = " WHERE |
|
| 5283 | access_url_id = $urlId |
|
