chamilo /
chamilo-lms
| @@ 4269-4278 (lines=10) @@ | ||
| 4266 | $userConditions .= " AND u.active = $active "; |
|
| 4267 | } |
|
| 4268 | ||
| 4269 | if (!empty($keyword)) { |
|
| 4270 | $keyword = Database::escape_string($keyword); |
|
| 4271 | $userConditions .= " AND ( |
|
| 4272 | u.username LIKE '%$keyword%' OR |
|
| 4273 | u.firstname LIKE '%$keyword%' OR |
|
| 4274 | u.lastname LIKE '%$keyword%' OR |
|
| 4275 | u.official_code LIKE '%$keyword%' OR |
|
| 4276 | u.email LIKE '%$keyword%' |
|
| 4277 | )"; |
|
| 4278 | } |
|
| 4279 | ||
| 4280 | if (!empty($lastConnectionDate)) { |
|
| 4281 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
| @@ 5300-5309 (lines=10) @@ | ||
| 5297 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5298 | } |
|
| 5299 | ||
| 5300 | if (!empty($keyword)) { |
|
| 5301 | $keyword = Database::escape_string($keyword); |
|
| 5302 | $userConditions .= " AND ( |
|
| 5303 | u.username LIKE '%$keyword%' OR |
|
| 5304 | u.firstname LIKE '%$keyword%' OR |
|
| 5305 | u.lastname LIKE '%$keyword%' OR |
|
| 5306 | u.official_code LIKE '%$keyword%' OR |
|
| 5307 | u.email LIKE '%$keyword%' |
|
| 5308 | )"; |
|
| 5309 | } |
|
| 5310 | ||
| 5311 | $where = " WHERE |
|
| 5312 | access_url_id = $urlId |
|
