chamilo / chamilo-lms

     * Retrieves the user defined course categories and all the info that goes with it

     * @return array containing all the info of the user defined courses categories with the id as key of the array

     */

    public function get_user_course_categories_info()

    {

        $current_user_id = api_get_user_id();

        $table_category = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $sql = "SELECT * FROM " . $table_category . "

                WHERE user_id='" . $current_user_id . "'

                ORDER BY sort ASC";

        $result = Database::query($sql);

        while ($row = Database::fetch_array($result)) {

            $output[$row['id']] = $row;

        }

        return $output;

    }

    /**

     * Updates the user course category in the chamilo_user database

* @author Patrick Cool <[email protected]>, Ghent University

* @version march 2006

*/

function get_total_number_feedback($file_id = '')

{

    $course_id = api_get_course_int_id();

    $sql = "SELECT COUNT(feedback_id) AS total, file_id

            FROM ". Database::get_course_table(TABLE_DROPBOX_FEEDBACK) ."

            WHERE c_id = $course_id GROUP BY file_id";

    $result = Database::query($sql);

    $return = array();

    while ($row=Database::fetch_array($result)) {

        $return[$row['file_id']] = $row['total'];

    }

    return $return;

}

/**