chamilo / chamilo-lms

     * @param string $full_text The full post text

     * @param int $blog_id The internal ID of the blog in which the post is located

     */

    public static function editPost($post_id, $title, $full_text, $blog_id)

    {

        $tbl_blogs_posts = Database::get_course_table(TABLE_BLOGS_POSTS);

        $course_id = api_get_course_int_id();

        $title = Database::escape_string($title);

        $full_text = Database::escape_string($full_text);

        $post_id = intval($post_id);

        $blog_id = intval($blog_id);

        // Create the post

        $sql = "UPDATE $tbl_blogs_posts SET

                title = '$title',

                full_text = '$full_text'

                WHERE c_id = $course_id AND post_id = $post_id AND blog_id = $blog_id

                LIMIT 1";

        Database::query($sql);

    }

    /**

     * Deletes an article and its comments

     * @param string $endDate

     * @return array

     */

    public static function getCourseAccessPerCourseAndSession(

        $courseId,

        $sessionId,

        $startDate,

        $endDate

    ) {

        $table = Database::get_main_table(TABLE_STATISTIC_TRACK_E_COURSE_ACCESS);

        $courseId = intval($courseId);

        $sessionId = intval($sessionId);

        $startDate = Database::escape_string($startDate);

        $endDate = Database::escape_string($endDate);

        $sql = "SELECT * FROM $table

                WHERE

                    c_id = $courseId AND

                    session_id = $sessionId AND

                    login_course_date BETWEEN '$startDate' AND '$endDate'

                ";

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

        return Database::store_result($result);

    }

    /**

     * Get login information from the track_e_course_access table, for any

     * @param string $surveyCode

     * @return int

     */

    public static function invitationExists($courseId, $sessionId, $groupId, $surveyCode)

    {

        $table = Database::get_course_table(TABLE_SURVEY_INVITATION);

        $courseId = intval($courseId);

        $sessionId = intval($sessionId);

        $groupId = intval($groupId);

        $surveyCode = Database::escape_string($surveyCode);

        $sql = "SELECT survey_invitation_id FROM $table

                WHERE

                    c_id = $courseId AND

                    session_id = $sessionId AND

                    group_id = $groupId AND

                    survey_code = '$surveyCode'

                ";

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

        return Database::num_rows($result);

    }

    /**

     * Send the invitation by mail.