Esempio n. 1
0
        /// <summary>
        /// Get the Client Extension update and message of the day information.
        /// </summary>
        /// <param name="Product">Supplies the product name, such as NWN2.</param>
        /// <param name="ClientExtensionVersion">Supplies the Client Extension
        /// version number in packed format.</param>
        /// <returns>The message of the day string, else an empty string if
        /// there was no string to display.</returns>
        public ClientExtensionUpdate GetClientExtensionUpdate(string Product, uint ClientExtensionVersion)
        {
            int ProductId = ProductNameToId(Product);
            ClientExtensionUpdate UpdateInfo = new ClientExtensionUpdate();
            string ClientVersion = String.Format("{0}.{1}.{2}.{3}",
                (ClientExtensionVersion >> 24) & 0xFF,
                (ClientExtensionVersion >> 16) & 0xFF,
                (ClientExtensionVersion >> 8) & 0xFF,
                (ClientExtensionVersion >> 0) & 0xFF);

            UpdateInfo.MOTD = "";
            UpdateInfo.UpdateUrl = "";
            UpdateInfo.UpdateVersion = "";
            UpdateInfo.InfoUrl = "";
            UpdateInfo.UpdateDescription = "";

            //
            // Gather the current Client Extension update information from the
            // database.
            //

            string Query = String.Format(
            @"SELECT
            `update_message`,
            `update_url`,
            `update_info_url`,
            `update_version`,
            `update_motd`
            FROM
            `client_extension_update`
            WHERE
            `product_id` = {0}",
                       ProductId);

            using (MySqlDataReader Reader = MySqlHelper.ExecuteReader(ConnectionString, Query))
            {
                if (Reader.Read())
                {
                    UpdateInfo.UpdateDescription = Reader.GetString(0);
                    UpdateInfo.UpdateUrl = Reader.GetString(1);
                    UpdateInfo.InfoUrl = Reader.GetString(2);
                    UpdateInfo.UpdateVersion = Reader.GetString(3);
                    UpdateInfo.MOTD = Reader.GetString(4);
                }
            }

            //
            // If the client is already running the recommended version, then
            // do not signal an update request to the client.
            //

            if (UpdateInfo.UpdateVersion == ClientVersion)
            {
                UpdateInfo.UpdateDescription = "";
                UpdateInfo.UpdateVersion = "";
                UpdateInfo.InfoUrl = "";
                UpdateInfo.UpdateUrl = "";
            }

            return UpdateInfo;
        }
        /// <summary>
        /// Get the Client Extension update and message of the day information.
        /// </summary>
        /// <param name="Product">Supplies the product name, such as NWN2.</param>
        /// <param name="ClientExtensionVersion">Supplies the Client Extension
        /// version number in packed format.</param>
        /// <returns>The message of the day string, else an empty string if
        /// there was no string to display.</returns>
        public ClientExtensionUpdate GetClientExtensionUpdate(string Product, uint ClientExtensionVersion)
        {
            int ProductId = ProductNameToId(Product);
            ClientExtensionUpdate UpdateInfo = new ClientExtensionUpdate();
            string ClientVersion             = String.Format("{0}.{1}.{2}.{3}",
                                                             (ClientExtensionVersion >> 24) & 0xFF,
                                                             (ClientExtensionVersion >> 16) & 0xFF,
                                                             (ClientExtensionVersion >> 8) & 0xFF,
                                                             (ClientExtensionVersion >> 0) & 0xFF);

            UpdateInfo.MOTD              = "";
            UpdateInfo.UpdateUrl         = "";
            UpdateInfo.UpdateVersion     = "";
            UpdateInfo.InfoUrl           = "";
            UpdateInfo.UpdateDescription = "";

            //
            // Gather the current Client Extension update information from the
            // database.
            //

            string Query = String.Format(
                @"SELECT 
    `update_message`, 
    `update_url`, 
    `update_info_url`, 
    `update_version`, 
    `update_motd` 
FROM 
    `client_extension_update` 
WHERE 
    `product_id` = {0}",
                ProductId);

            using (MySqlDataReader Reader = MySqlHelper.ExecuteReader(ConnectionString, Query))
            {
                if (Reader.Read())
                {
                    UpdateInfo.UpdateDescription = Reader.GetString(0);
                    UpdateInfo.UpdateUrl         = Reader.GetString(1);
                    UpdateInfo.InfoUrl           = Reader.GetString(2);
                    UpdateInfo.UpdateVersion     = Reader.GetString(3);
                    UpdateInfo.MOTD = Reader.GetString(4);
                }
            }

            //
            // If the client is already running the recommended version, then
            // do not signal an update request to the client.
            //

            if (UpdateInfo.UpdateVersion == ClientVersion)
            {
                UpdateInfo.UpdateDescription = "";
                UpdateInfo.UpdateVersion     = "";
                UpdateInfo.InfoUrl           = "";
                UpdateInfo.UpdateUrl         = "";
            }

            return(UpdateInfo);
        }