chamilo /
chamilo-lms
| @@ 4264-4273 (lines=10) @@ | ||
| 4261 | $userConditions .= " AND u.active = $active "; |
|
| 4262 | } |
|
| 4263 | ||
| 4264 | if (!empty($keyword)) { |
|
| 4265 | $keyword = Database::escape_string($keyword); |
|
| 4266 | $userConditions .= " AND ( |
|
| 4267 | u.username LIKE '%$keyword%' OR |
|
| 4268 | u.firstname LIKE '%$keyword%' OR |
|
| 4269 | u.lastname LIKE '%$keyword%' OR |
|
| 4270 | u.official_code LIKE '%$keyword%' OR |
|
| 4271 | u.email LIKE '%$keyword%' |
|
| 4272 | )"; |
|
| 4273 | } |
|
| 4274 | ||
| 4275 | if (!empty($lastConnectionDate)) { |
|
| 4276 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
| @@ 5250-5259 (lines=10) @@ | ||
| 5247 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5248 | } |
|
| 5249 | ||
| 5250 | if (!empty($keyword)) { |
|
| 5251 | $keyword = Database::escape_string($keyword); |
|
| 5252 | $userConditions .= " AND ( |
|
| 5253 | u.username LIKE '%$keyword%' OR |
|
| 5254 | u.firstname LIKE '%$keyword%' OR |
|
| 5255 | u.lastname LIKE '%$keyword%' OR |
|
| 5256 | u.official_code LIKE '%$keyword%' OR |
|
| 5257 | u.email LIKE '%$keyword%' |
|
| 5258 | )"; |
|
| 5259 | } |
|
| 5260 | ||
| 5261 | $where = " WHERE |
|
| 5262 | access_url_id = $urlId |
|
