chamilo /
chamilo-lms
| @@ 395-408 (lines=14) @@ | ||
| 392 | ORDER BY course_rel_user.sort ASC"; |
|
| 393 | $result = array(); |
|
| 394 | $resultset = Database::query($sql_select_courses); |
|
| 395 | while ($row = Database::fetch_array($resultset)) { |
|
| 396 | $code = $row['k']; |
|
| 397 | $result[$code] = array( |
|
| 398 | 'code' => $code, |
|
| 399 | 'visual_code' => $row['vc'], |
|
| 400 | 'title' => $row['i'], |
|
| 401 | 'directory' => $row['dir'], |
|
| 402 | 'status' => $row['status'], |
|
| 403 | 'tutor' => $row['t'], |
|
| 404 | 'subscribe' => $row['subscr'], |
|
| 405 | 'unsubscribe' => $row['unsubscr'], |
|
| 406 | 'sort' => $row['sort'], |
|
| 407 | 'user_course_category' => $row['user_course_cat']); |
|
| 408 | } |
|
| 409 | ||
| 410 | return $result; |
|
| 411 | } |
|
| @@ 690-704 (lines=15) @@ | ||
| 687 | ORDER BY course_rel_user.sort ASC"; |
|
| 688 | $result = Database::query($sql_select_courses); |
|
| 689 | $courses = array(); |
|
| 690 | while ($row = Database::fetch_array($result)) { |
|
| 691 | // We only need the database name of the course. |
|
| 692 | $courses[$row['k']] = array( |
|
| 693 | 'code' => $row['k'], |
|
| 694 | 'visual_code' => $row['vc'], |
|
| 695 | 'title' => $row['i'], |
|
| 696 | 'directory' => $row['dir'], |
|
| 697 | 'status' => $row['status'], |
|
| 698 | 'tutor' => $row['t'], |
|
| 699 | 'subscribe' => $row['subscr'], |
|
| 700 | 'unsubscribe' => $row['unsubscr'], |
|
| 701 | 'sort' => $row['sort'], |
|
| 702 | 'user_course_category' => $row['user_course_cat'] |
|
| 703 | ); |
|
| 704 | } |
|
| 705 | return $courses; |
|
| 706 | } |
|
| 707 | ||
