chamilo / chamilo-lms

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

 * @version february 2006, dokeos 1.8

 */

function count_number_of_forums_in_category($cat_id)

{

    $table_forums = Database :: get_course_table(TABLE_FORUM);

    $course_id = api_get_course_int_id();

    $sql = "SELECT count(*) AS number_of_forums

            FROM ".$table_forums."

            WHERE c_id = $course_id AND forum_category='".Database::escape_string($cat_id)."'";

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

    $row = Database::fetch_array($result);

    return $row['number_of_forums'];

}

/**

 * This function update a thread

     *

     * @return string the comment

     */

    public static function get_comments($exe_id, $question_id)

    {

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $sql = "SELECT teacher_comment 

                FROM $table_track_attempt

                WHERE

                    exe_id='".Database::escape_string($exe_id)."' AND

                    question_id = '".Database::escape_string($question_id)."'

                ORDER by question_id";

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

        $comm = Database::result($sqlres, 0, 'teacher_comment');

        return $comm;

    }

    /**

     * @param int $exe_id

     * @param int user receiver id

     * @return int

     */

    public static function get_message_number_invitation_by_user_id($user_receiver_id)

    {

        $tbl_message = Database::get_main_table(TABLE_MESSAGE);

        $sql = 'SELECT COUNT(*) as count_message_in_box FROM '.$tbl_message.'

                WHERE

                    user_receiver_id='.intval($user_receiver_id).' AND

                    msg_status='.MESSAGE_STATUS_INVITATION_PENDING;

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

        $row = Database::fetch_array($res, 'ASSOC');

        return $row['count_message_in_box'];

    }

    /**

     * Get invitation list received by user

     * Returns the course name from a given code

     * @param string $code

     */

    public static function getCourseNameFromCode($code)

    {

        $tbl_main_categories = Database:: get_main_table(TABLE_MAIN_COURSE);

        $sql = 'SELECT title

                FROM ' . $tbl_main_categories . '

                WHERE code = "' . Database::escape_string($code) . '"';

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

        if ($col = Database::fetch_array($result)) {

            return $col['title'];

        }

    }

    /**

     * Generates a course code from a course title