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 | } |
|
| @@ 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 | } |
|
| @@ 509-523 (lines=15) @@ | ||
| 506 | ORDER BY course_rel_user.sort ASC"; |
|
| 507 | $result = Database::query($sql); |
|
| 508 | $courses = array(); |
|
| 509 | while ($row = Database::fetch_array($result)) { |
|
| 510 | // We only need the database name of the course. |
|
| 511 | $courses[$row['k']] = array( |
|
| 512 | 'code' => $row['k'], |
|
| 513 | 'visual_code' => $row['vc'], |
|
| 514 | 'title' => $row['i'], |
|
| 515 | 'directory' => $row['dir'], |
|
| 516 | 'status' => $row['status'], |
|
| 517 | 'tutor' => $row['t'], |
|
| 518 | 'subscribe' => $row['subscr'], |
|
| 519 | 'unsubscribe' => $row['unsubscr'], |
|
| 520 | 'sort' => $row['sort'], |
|
| 521 | 'user_course_category' => $row['user_course_cat'] |
|
| 522 | ); |
|
| 523 | } |
|
| 524 | return $courses; |
|
| 525 | } |
|
| 526 | ||
