chamilo / chamilo-lms

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

     * @version January 2007

     */

    public static function get_number_of_survey_invitations()

    {

        $course_id = api_get_course_int_id();

        // Database table definition

        $table_survey_invitation = Database :: get_course_table(TABLE_SURVEY_INVITATION);

        $sql = "SELECT count(user) AS total

		        FROM $table_survey_invitation

		        WHERE

                    c_id = $course_id AND

                    survey_id='".intval($_GET['survey_id'])."' AND

                    session_id='".api_get_session_id()."' ";

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

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

        return $row['total'];

    }

    /**

     * Save the invitation mail

 * @author Christian Fasanando

 * @author Julio Montoya <[email protected]> Adding security

 */

function get_name_thread_by_id($thread_id)

{

    $t_forum_thread = Database::get_course_table(TABLE_FORUM_THREAD);

    $course_id = api_get_course_int_id();

    $sql = "SELECT thread_title FROM ".$t_forum_thread."

            WHERE c_id = $course_id AND thread_id = '".intval($thread_id)."' ";

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

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

    return $row[0];

}

/**

 * This function gets all the post written by an user

 * @param int $item_id

 * @param array $course_info

 */

function makeInvisible($item_id, $course_info)

{

    $work_table = Database :: get_course_table(TABLE_STUDENT_PUBLICATION);

    $item_id = intval($item_id);

    $course_id = $course_info['real_id'];

    $sql = "UPDATE  " . $work_table . "

            SET accepted = 0

            WHERE c_id = $course_id AND id = '" . $item_id . "'";

    Database::query($sql);

    api_item_property_update(

        $course_info,

        'work',

        $item_id,

        'invisible',

        api_get_user_id()

    );

}

/**

 * @param int $item_id