chamilo /
chamilo-lms
| @@ 203-206 (lines=4) @@ | ||
| 200 | WHERE default_user_id = user.user_id "; |
|
| 201 | } |
|
| 202 | ||
| 203 | if (isset($_GET['keyword'])) { |
|
| 204 | $keyword = Database::escape_string(trim($_GET['keyword'])); |
|
| 205 | $sql .= " AND ( |
|
| 206 | user.username LIKE '%".$keyword."%' OR |
|
| 207 | default_event_type LIKE '%".$keyword."%' OR |
|
| 208 | default_value_type LIKE '%".$keyword."%' OR |
|
| 209 | default_value LIKE '%".$keyword."%') "; |
|
| @@ 271-277 (lines=7) @@ | ||
| 268 | WHERE track_default.default_user_id = user.user_id "; |
|
| 269 | } |
|
| 270 | ||
| 271 | if (isset($_GET['keyword'])) { |
|
| 272 | $keyword = Database::escape_string(trim($_GET['keyword'])); |
|
| 273 | $sql .= " AND (user.username LIKE '%".$keyword."%' OR |
|
| 274 | default_event_type LIKE '%".$keyword."%' OR |
|
| 275 | default_value_type LIKE '%".$keyword."%' OR |
|
| 276 | default_value LIKE '%".$keyword."%') "; |
|
| 277 | } |
|
| 278 | ||
| 279 | if (!empty($column) && !empty($direction)) { |
|
| 280 | $sql .= " ORDER BY col$column $direction"; |
|
| @@ 7073-7081 (lines=9) @@ | ||
| 7070 | $condition_user = " WHERE user.user_id = $user_ids "; |
|
| 7071 | } |
|
| 7072 | ||
| 7073 | if (!empty($_GET['user_keyword'])) { |
|
| 7074 | $keyword = trim(Database::escape_string($_GET['user_keyword'])); |
|
| 7075 | $condition_user .= " AND ( |
|
| 7076 | user.firstname LIKE '%".$keyword."%' OR |
|
| 7077 | user.lastname LIKE '%".$keyword."%' OR |
|
| 7078 | user.username LIKE '%".$keyword."%' OR |
|
| 7079 | user.email LIKE '%".$keyword."%' |
|
| 7080 | ) "; |
|
| 7081 | } |
|
| 7082 | ||
| 7083 | $url_table = null; |
|
| 7084 | $url_condition = null; |
|
