chamilo /
chamilo-lms
| @@ 4298-4307 (lines=10) @@ | ||
| 4295 | $userConditions .= " AND u.active = $active "; |
|
| 4296 | } |
|
| 4297 | ||
| 4298 | if (!empty($keyword)) { |
|
| 4299 | $keyword = Database::escape_string($keyword); |
|
| 4300 | $userConditions .= " AND ( |
|
| 4301 | u.username LIKE '%$keyword%' OR |
|
| 4302 | u.firstname LIKE '%$keyword%' OR |
|
| 4303 | u.lastname LIKE '%$keyword%' OR |
|
| 4304 | u.official_code LIKE '%$keyword%' OR |
|
| 4305 | u.email LIKE '%$keyword%' |
|
| 4306 | )"; |
|
| 4307 | } |
|
| 4308 | ||
| 4309 | if (!empty($lastConnectionDate)) { |
|
| 4310 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
| @@ 5354-5363 (lines=10) @@ | ||
| 5351 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5352 | } |
|
| 5353 | ||
| 5354 | if (!empty($keyword)) { |
|
| 5355 | $keyword = Database::escape_string($keyword); |
|
| 5356 | $userConditions .= " AND ( |
|
| 5357 | u.username LIKE '%$keyword%' OR |
|
| 5358 | u.firstname LIKE '%$keyword%' OR |
|
| 5359 | u.lastname LIKE '%$keyword%' OR |
|
| 5360 | u.official_code LIKE '%$keyword%' OR |
|
| 5361 | u.email LIKE '%$keyword%' |
|
| 5362 | )"; |
|
| 5363 | } |
|
| 5364 | ||
| 5365 | $where = " WHERE |
|
| 5366 | access_url_id = $urlId |
|
