chamilo /
chamilo-lms
| @@ 5031-5040 (lines=10) @@ | ||
| 5028 | $userConditions .= " AND u.last_login <= '$lastConnectionDate' "; |
|
| 5029 | } |
|
| 5030 | ||
| 5031 | if (!empty($keyword)) { |
|
| 5032 | $keyword = Database::escape_string($keyword); |
|
| 5033 | $userConditions .= " AND ( |
|
| 5034 | u.username LIKE '%$keyword%' OR |
|
| 5035 | u.firstname LIKE '%$keyword%' OR |
|
| 5036 | u.lastname LIKE '%$keyword%' OR |
|
| 5037 | u.official_code LIKE '%$keyword%' OR |
|
| 5038 | u.email LIKE '%$keyword%' |
|
| 5039 | )"; |
|
| 5040 | } |
|
| 5041 | ||
| 5042 | $where = " WHERE |
|
| 5043 | access_url_id = $urlId |
|
| @@ 3951-3960 (lines=10) @@ | ||
| 3948 | $userConditions .= " AND u.active = $active "; |
|
| 3949 | } |
|
| 3950 | ||
| 3951 | if (!empty($keyword)) { |
|
| 3952 | $keyword = Database::escape_string($keyword); |
|
| 3953 | $userConditions .= " AND ( |
|
| 3954 | u.username LIKE '%$keyword%' OR |
|
| 3955 | u.firstname LIKE '%$keyword%' OR |
|
| 3956 | u.lastname LIKE '%$keyword%' OR |
|
| 3957 | u.official_code LIKE '%$keyword%' OR |
|
| 3958 | u.email LIKE '%$keyword%' |
|
| 3959 | )"; |
|
| 3960 | } |
|
| 3961 | ||
| 3962 | if (!empty($lastConnectionDate)) { |
|
| 3963 | $lastConnectionDate = Database::escape_string($lastConnectionDate); |
|
