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 | } |
|
| @@ 734-748 (lines=15) @@ | ||
| 731 | ORDER BY course_rel_user.sort ASC"; |
|
| 732 | $result = Database::query($sql_select_courses); |
|
| 733 | $courses = array(); |
|
| 734 | while ($row = Database::fetch_array($result)) { |
|
| 735 | // We only need the database name of the course. |
|
| 736 | $courses[$row['k']] = array( |
|
| 737 | 'code' => $row['k'], |
|
| 738 | 'visual_code' => $row['vc'], |
|
| 739 | 'title' => $row['i'], |
|
| 740 | 'directory' => $row['dir'], |
|
| 741 | 'status' => $row['status'], |
|
| 742 | 'tutor' => $row['t'], |
|
| 743 | 'subscribe' => $row['subscr'], |
|
| 744 | 'unsubscribe' => $row['unsubscr'], |
|
| 745 | 'sort' => $row['sort'], |
|
| 746 | 'user_course_category' => $row['user_course_cat'] |
|
| 747 | ); |
|
| 748 | } |
|
| 749 | return $courses; |
|
| 750 | } |
|
| 751 | ||
| @@ 81-96 (lines=16) @@ | ||
| 78 | ORDER BY course_rel_user.sort ASC"; |
|
| 79 | $result = Database::query($sql); |
|
| 80 | $courses = array(); |
|
| 81 | while ($row = Database::fetch_array($result)) { |
|
| 82 | //we only need the database name of the course |
|
| 83 | $courses[] = array( |
|
| 84 | 'code' => $row['k'], |
|
| 85 | 'visual_code' => $row['vc'], |
|
| 86 | 'title' => $row['i'], |
|
| 87 | 'directory' => $row['dir'], |
|
| 88 | 'status' => $row['status'], |
|
| 89 | 'tutor' => $row['t'], |
|
| 90 | 'subscribe' => $row['subscr'], |
|
| 91 | 'category' => $row['cat'], |
|
| 92 | 'unsubscribe' => $row['unsubscr'], |
|
| 93 | 'sort' => $row['sort'], |
|
| 94 | 'user_course_category' => $row['user_course_cat'] |
|
| 95 | ); |
|
| 96 | } |
|
| 97 | ||
| 98 | return $courses; |
|
| 99 | } |
|
