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

	 *

	 * @return String Blog Title

	 */

	public static function get_blog_title ($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']);

		}

	}

	/**

	 *

	 * @return String Blog description

	 */

	public static function get_blog_subtitle($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

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

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