chamilo / chamilo-lms

     * @param   int $userId The user for which we need the unread messages count

     * @return  int The number of unread messages in the database for the given user

     */

    private static function getCountNewMessagesFromDB($userId)

    {

        if (empty($userId)) {

            return 0;

        }

        $table = Database::get_main_table(TABLE_MESSAGE);

        $sql = "SELECT COUNT(id) as count 

                FROM $table

                WHERE

                    user_receiver_id=".api_get_user_id()." AND

                    msg_status = " . MESSAGE_STATUS_UNREAD;

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

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

        return $row['count'];

    }

    /**

     * Gets the total number of messages, used for the inbox sortable table

    /**

     * Shows all information of an category

     */

    public function shows_all_information_an_category($selectcat = '')

    {

        if ($selectcat == '') {

            return null;

        } else {

            $tbl_category = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

            $sql = 'SELECT 

                        name,

                        description,

                        user_id,

                        c_id,

                        parent_id,

                        weight,

                        visible,

                        certif_min_score,

                        session_id, 

                        generate_certificates, 

                        is_requirement

 * @author Julio Montoya <[email protected]>

 * @return int access_url_id of the current Chamilo Installation

 */

function api_get_current_access_url_id() {

    $access_url_table = Database::get_main_table(TABLE_MAIN_ACCESS_URL);

    $path = Database::escape_string(api_get_path(WEB_PATH));

    $sql = "SELECT id FROM $access_url_table WHERE url = '".$path."'";

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

    if (Database::num_rows($result) > 0) {

        $access_url_id = Database::result($result, 0, 0);

        return $access_url_id;

    }

    //if the url in WEB_PATH was not found, it can only mean that there is

    // either a configuration problem or the first URL has not been defined yet

    // (by default it is http://localhost/). Thus the more sensible thing we can

    // do is return 1 (the main URL) as the user cannot hack this value anyway

    return 1;

}

/**

 * Gets the registered urls from a given user id