chamilo / chamilo-lms

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

 * @version April 2008

 */

function get_number_of_group_users()

{

    global $current_group;

    $course_id = api_get_course_int_id();

    // Database table definition

    $table = Database :: get_course_table(TABLE_GROUP_USER);

    // Query

    $sql = "SELECT count(iid) AS number_of_users

            FROM ".$table."

            WHERE c_id = $course_id AND group_id='".intval($current_group['id'])."'";

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

    $return = Database::fetch_array($result, 'ASSOC');

    return $return['number_of_users'];

}

/**

 * Get the details of the users in a group

 * @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

     *

     * @return String Blog Title

     */

    public static function getBlogTitle($blog_id)

    {

        $course_id = api_get_course_int_id();

        if (is_numeric($blog_id)) {

            $tbl_blogs = Database::get_course_table(TABLE_BLOGS);

            $sql = "SELECT blog_name

                    FROM ".$tbl_blogs."

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

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

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

            return stripslashes($blog['blog_name']);

        }

    }

    /**

     * Get the description of a blog

     *

     * @return String Blog description

     */

    public static function getBlogSubtitle($blog_id)

    {

        $tbl_blogs = Database::get_course_table(TABLE_BLOGS);

        $course_id = api_get_course_int_id();

        $sql = "SELECT blog_subtitle FROM $tbl_blogs

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

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

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

        return stripslashes($blog['blog_subtitle']);

    }

    /**

     * Get the users of a blog

     * @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