chamilo / chamilo-lms

     * Get platform language ID

     * @return     int     The platform language ID

     */

    public static function get_platform_language_id()

    {

        $name = api_get_setting('platformLanguage');

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "SELECT id FROM " . $tbl_admin_languages . " WHERE english_name ='$name'";

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

        if (Database::num_rows($res) < 1) {

            return false;

        }

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

        return $row['id'];

    }

    /**

     * Get parent language path (or null if no parent)

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

    /**

     * 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,course_code,parent_id,weight,visible,certif_min_score,session_id, generate_certificates, is_requirement

                    FROM '.$tbl_category.' c

                    WHERE c.id='.intval($selectcat);

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

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

            return $row;

        }

    }

    /**

     * Check if a category name (with the same parent category) already exists

     * @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'];

    }

    /**

     * Get the list of user_ids of users who are online.