Пример #1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            MessageBox.Show("Thank you for Trying our Unofficial Demo, This was in no way a final project, and is only used as a demonstration, We hope you will Support our Development for the Future", "Demo ONLY", MessageBoxButtons.OK);

            // OPEN SETTINGS FORM IF WOW DIRECTORY IS NOT SETTED
            if (string.IsNullOrEmpty(Settings.Default.WowLocation) || !Directory.Exists(Settings.Default.WowLocation))
            {
                if (!string.IsNullOrEmpty(WoW.Directory))
                {
                    Settings.Default.WowLocation = WoW.Directory;
                    Settings.Default.Save();
                }
                else
                {
                    using (SettingsForm form = new SettingsForm())
                        form.ShowDialog();
                }
            }

            //========================================= GET TITLE FROM DATABASE SECTION ================================================
            MySqlConnection conn;
            int             i           = 0;
            int             count       = 6; //NUMBER OF NEWS DISPLAYED ON LAUNCHER
            string          MyConString = "server=wownewage.com;uid=launcher;" +
                                          "pwd=FiYeSO;database=website;";

            conn = new MySqlConnection(MyConString);
            conn.Open();
            MySqlCommand getTitle = new MySqlCommand("SELECT headline FROM articles ORDER BY id DESC LIMIT 6;", conn);

            //MySqlCommand getRow = new MySqlCommand("SELECT COUNT(*) FROM articles", conn); //USELESS FOR NOW BUT CAN BE USED IN FUTURE
            //count = (int)getRow.ExecuteScalar(); //SAME AS BEFORE
            string[]        titleContent = new string[count];
            MySqlDataReader title_row    = getTitle.ExecuteReader();

            while (title_row.Read())
            {
                string title = title_row["headline"].ToString();
                //MessageBox.Show(title.Substring(12, title.Length-2-12)); //ENABLE FOR DEBUG
                titleContent[i] = title.Substring(12, title.Length - 2 - 12);
                i++;
            }
            conn.Close();

            //========================================= GET CONTENT FROM DATABASE SECTION ================================================
            conn.Open();
            i = 0; // RESET i value for re-use it
            MySqlCommand getContent = new MySqlCommand("SELECT content FROM articles ORDER BY id DESC LIMIT 6;", conn);

            //MySqlCommand getRow = new MySqlCommand("SELECT COUNT(*) FROM articles", conn); //USELESS FOR NOW BUT CAN BE USED IN FUTURE
            //count = (int)getRow.ExecuteScalar(); //SAME AS BEFORE
            string[]        contentContent = new string[count];
            MySqlDataReader content_row    = getContent.ExecuteReader();

            while (content_row.Read())
            {
                string content = content_row["content"].ToString();
                //MessageBox.Show(content.Substring(12, content.Length-2-12)); //ENABLE FOR DEBUG
                contentContent[i] = content.Substring(3, content.Length - 7);
                i++;
            }

            conn.Close();

            //========================================= GET IMG LINK FROM DATABASE SECTION ================================================
            conn.Open();
            i = 0; // RESET i value for re-use it
            MySqlCommand getImgLink = new MySqlCommand("SELECT imgLink FROM articles ORDER BY id DESC LIMIT 6;", conn);

            //MySqlCommand getRow = new MySqlCommand("SELECT COUNT(*) FROM articles", conn); //USELESS FOR NOW BUT CAN BE USED IN FUTURE
            //count = (int)getRow.ExecuteScalar(); //SAME AS BEFORE
            string[]        ImgLinkContent = new string[count];
            MySqlDataReader ImgLink_row    = getImgLink.ExecuteReader();

            while (ImgLink_row.Read())
            {
                string ImgLink = ImgLink_row["imgLink"].ToString();
                //MessageBox.Show(content.Substring(12, content.Length-2-12)); //ENABLE FOR DEBUG
                ImgLinkContent[i] = ImgLink;
                i++;
            }

            conn.Close();

            //SET TITLE AND CONTENT SECTION
            News_Item1_Title.Text    = titleContent[0];
            Item1_Description.Text   = contentContent[0];
            UpdateBox1.ImageLocation = ImgLinkContent[0];

            News_Item2_Title.Text    = titleContent[1];
            Item2_Description.Text   = contentContent[1];
            UpdateBox2.ImageLocation = ImgLinkContent[1];

            News_Item3_Title.Text    = titleContent[2];
            Item3_Description.Text   = contentContent[2];
            UpdateBox3.ImageLocation = ImgLinkContent[2];

            News_Item4_Title.Text    = titleContent[3];
            Item4_Description.Text   = contentContent[3];
            UpdateBox4.ImageLocation = ImgLinkContent[3];

            News_Item5_Title.Text    = titleContent[4];
            Item5_Description.Text   = contentContent[4];
            UpdateBox5.ImageLocation = ImgLinkContent[4];

            News_Item6_Title.Text    = titleContent[5];
            Item6_Description.Text   = contentContent[5];
            UpdateBox6.ImageLocation = ImgLinkContent[5];

            // END UPDATES SECTION =====================================

            TransparencyKey = Color.Lime;

            downloadBar1.BarState = DownloadBar.DownloadBarState.Setup;

            try
            {
                string path = WoW.RealmListLocation;

                if (!string.IsNullOrEmpty(path) && File.Exists(path))
                {
                    using (StreamWriter writer = new StreamWriter(path))
                    {
                        writer.WriteLine(Settings.Default.realmlist);
                        writer.Flush();

                        writer.Close();
                    }
                }

                if (Settings.Default.patchDownloadURL != String.Empty)
                {
                    startDownloadBackgroundWorker.RunWorkerAsync();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "NewAge Launcher", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Пример #2
0
        private void MainForm_Load(object sender, EventArgs e)
        {
            //SERVER Connection
            ServerConnect();

            // Transparency Toggle(SettingsForm.cs)

            if (Settings.Default.TransparencyToggle == false)
            {
                Opacity = 1.00;
            }
            if (Settings.Default.TransparencyToggle == true)
            {
                Opacity = .90;
            }

            // LOAD CUSTOM FONT
            loadFont();

            //Alloc Font
            AllocFont(font, this.News_Item1_Title, 12, true);
            AllocFont(font, this.News_Item2_Title, 12, true);
            AllocFont(font, this.News_Item3_Title, 12, true);
            AllocFont(font, this.News_Item4_Title, 12, true);
            AllocFont(font, this.News_Item5_Title, 12, true);
            AllocFont(font, this.News_Item6_Title, 12, true);

            AllocFont(font, this.Item1_Description, 9, false);
            AllocFont(font, this.Item2_Description, 9, false);
            AllocFont(font, this.Item3_Description, 9, false);
            AllocFont(font, this.Item4_Description, 9, false);
            AllocFont(font, this.Item5_Description, 9, false);
            AllocFont(font, this.Item6_Description, 9, false);

            AllocFont(font, this.downloadProgressLabel, 14, false);
            //AllocFont(font, this.downloadSpeedLabel, 14, false);

            AllocFont(font, this.updatesLabel, 16, false);

            AllocFont(font, this.menuBar1, 14, false);

            //========================================= GET TITLE FROM DATABASE SECTION ================================================
            MySqlConnection conn;
            int             i           = 0;
            int             count       = 6; //NUMBER OF NEWS DISPLAYED ON LAUNCHER
            string          MyConString = "server=wownewage.com;uid=launcher;pwd=FiYeSO;database=website;";

            conn = new MySqlConnection(MyConString);
            conn.Open();
            MySqlCommand getTitle = new MySqlCommand("SELECT headline FROM articles ORDER BY id DESC LIMIT 6;", conn);

            //MySqlCommand getRow = new MySqlCommand("SELECT COUNT(*) FROM articles", conn); //USELESS FOR NOW BUT CAN BE USED IN FUTURE
            //count = (int)getRow.ExecuteScalar(); //SAME AS BEFORE
            string[]        titleContent = new string[count];
            MySqlDataReader title_row    = getTitle.ExecuteReader();

            while (title_row.Read())
            {
                string title = title_row["headline"].ToString();
                //MessageBox.Show(title.Substring(12, title.Length-2-12)); //ENABLE FOR DEBUG
                titleContent[i] = title.Substring(12, title.Length - 2 - 12);
                i++;
            }
            conn.Close();

            //========================================= GET CONTENT FROM DATABASE SECTION ================================================
            conn.Open();
            i = 0; // RESET i value for re-use it
            MySqlCommand getContent = new MySqlCommand("SELECT content FROM articles ORDER BY id DESC LIMIT 6;", conn);

            //MySqlCommand getRow = new MySqlCommand("SELECT COUNT(*) FROM articles", conn); //USELESS FOR NOW BUT CAN BE USED IN FUTURE
            //count = (int)getRow.ExecuteScalar(); //SAME AS BEFORE
            string[]        contentContent = new string[count];
            MySqlDataReader content_row    = getContent.ExecuteReader();

            while (content_row.Read())
            {
                string content = content_row["content"].ToString();
                //MessageBox.Show(content.Substring(12, content.Length-2-12)); //ENABLE FOR DEBUG
                contentContent[i] = content.Substring(3, content.Length - 7).Replace("<p>", " ").Replace("</p>", "").Replace("nbsp", "\n");
                i++;
            }

            conn.Close();

            //========================================= GET IMG LINK FROM DATABASE SECTION ================================================
            conn.Open();
            i = 0; // RESET i value for re-use it
            MySqlCommand getImgLink = new MySqlCommand("SELECT imgLink FROM articles ORDER BY id DESC LIMIT 6;", conn);

            //MySqlCommand getRow = new MySqlCommand("SELECT COUNT(*) FROM articles", conn); //USELESS FOR NOW BUT CAN BE USED IN FUTURE
            //count = (int)getRow.ExecuteScalar(); //SAME AS BEFORE
            string[]        ImgLinkContent = new string[count];
            MySqlDataReader ImgLink_row    = getImgLink.ExecuteReader();

            while (ImgLink_row.Read())
            {
                string ImgLink = ImgLink_row["imgLink"].ToString();
                //MessageBox.Show(content.Substring(12, content.Length-2-12)); //ENABLE FOR DEBUG
                ImgLinkContent[i] = ImgLink;
                i++;
            }

            conn.Close();

            //SET TITLE AND CONTENT SECTION
            News_Item1_Title.Text  = titleContent[0];
            Item1_Description.Text = contentContent[0];
            if (string.IsNullOrEmpty(ImgLinkContent[0]))
            {
                UpdateBox1.Visible = false;
            }
            else
            {
                UpdateBox1.ImageLocation = ImgLinkContent[0];
            }

            News_Item2_Title.Text  = titleContent[1];
            Item2_Description.Text = contentContent[1];
            if (string.IsNullOrEmpty(ImgLinkContent[1]))
            {
                UpdateBox2.Visible = false;
            }
            else
            {
                UpdateBox2.ImageLocation = ImgLinkContent[1];
            }

            News_Item3_Title.Text  = titleContent[2];
            Item3_Description.Text = contentContent[2];
            if (string.IsNullOrEmpty(ImgLinkContent[2]))
            {
                UpdateBox3.Visible = false;
            }
            else
            {
                UpdateBox3.ImageLocation = ImgLinkContent[2];
            }

            News_Item4_Title.Text  = titleContent[3];
            Item4_Description.Text = contentContent[3];
            if (string.IsNullOrEmpty(ImgLinkContent[3]))
            {
                UpdateBox4.Visible = false;
            }
            else
            {
                UpdateBox4.ImageLocation = ImgLinkContent[3];
            }

            News_Item5_Title.Text  = titleContent[4];
            Item5_Description.Text = contentContent[4];
            if (string.IsNullOrEmpty(ImgLinkContent[4]))
            {
                UpdateBox5.Visible = false;
            }
            else
            {
                UpdateBox5.ImageLocation = ImgLinkContent[4];
            }

            News_Item6_Title.Text  = titleContent[5];
            Item6_Description.Text = contentContent[5];
            if (string.IsNullOrEmpty(ImgLinkContent[5]))
            {
                UpdateBox6.Visible = false;
            }
            else
            {
                UpdateBox6.ImageLocation = ImgLinkContent[5];
            }

            // END UPDATES SECTION =====================================

            if (string.IsNullOrEmpty(Settings.Default.WowLocation) || !Directory.Exists(Settings.Default.WowLocation))
            {
                if (!string.IsNullOrEmpty(WoW.Directory))
                {
                    Settings.Default.WowLocation = WoW.Directory;
                    Settings.Default.Save();
                }
                else
                {
                    using (SettingsForm form = new SettingsForm())
                        form.ShowDialog();
                }
            }

            TransparencyKey = Color.Lime;

            downloadBar1.BarState = DownloadBar.DownloadBarState.Setup;

            checkServerStatusBackgroundWorker.RunWorkerAsync();

            try
            {
                string path = WoW.RealmListLocation;

                if (!string.IsNullOrEmpty(path) && File.Exists(path))
                {
                    using (StreamWriter writer = new StreamWriter(path))
                    {
                        writer.WriteLine(Settings.Default.realmlist);
                        writer.Flush();

                        writer.Close();
                    }
                }

                if (Settings.Default.patchDownloadURL != String.Empty)
                {
                    startDownloadBackgroundWorker.RunWorkerAsync();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "NewAge Launcher", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }