chamilo /
chamilo-lms
| @@ 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 |
|
| @@ 4296-4305 (lines=10) @@ | ||
| 4293 | $userConditions .= " AND u.active = $active "; |
|
| 4294 | } |
|
| 4295 | ||
| 4296 | if (!empty($keyword)) { |
|
| 4297 | $keyword = Database::escape_string($keyword); |
|
| 4298 | $userConditions .= " AND ( |
|
| 4299 | u.username LIKE '%$keyword%' OR |
|
| 4300 | u.firstname LIKE '%$keyword%' OR |
|
| 4301 | u.lastname LIKE '%$keyword%' OR |
|
| 4302 | u.official_code LIKE '%$keyword%' OR |
|
| 4303 | u.email LIKE '%$keyword%' |
|
| 4304 | )"; |
|
| 4305 | } |
|
| 4306 | ||
| 4307 | if (!empty($lastConnectionDate)) { |
|
| 4308 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
